Scheme of work (draft) for 2F - Information Technology, International School the Hague

Week
number

Term

Unit Name:

Tasks
type

Task Title

Tasks content

Skills

Assessment

35

1

Operating System

Practical

Introduction

Introduction, passwords, recap

Log in

Checked result (classwork)

36

1

Wordprocessing

Practical

Advertising Campaign

Produce an advertising campaign - Imagine you start a business of your own!

Describe your ideas
Search techniques

Checked result (classwork)

37

1

DTP

Practical

Advertising Campaign

Produce an advertising campaign - What do real companies do?

Note down ideas
Search techniques

Checked result (classwork)

38

1

Internet (e-mail)

Practical

Advertising Campaign

Send e-mail with attachment (e.g a graphics file) to students home account

Send e-mail

Students evaluate themselves

38

1

DTP

Practical

Advertising Campaign

Billboard Advert

Text Wrap, text box, scanner

Checked result (classwork)

38

1

DTP

Practical

Advertising Campaign

Design of Business Card

Design / Importing own picture from Filemaker Database, Imagestyler skills,

Checked result (work handed in)

39

1


Practical

Advertising Campaign

Billboard Advert

Text Wrap, text box, scanner

Checked result (classwork)

40

1

DTP

Practical

Advertising Campaign

Flyer for event

DTP

Checked result (classwork)

41

1

DTP

Practical

Advertising Campaign

Flyer for event

DTP

Checked result (classwork)

42

1

DTP

Practical

Advertising Campaign

Promotional Newsletter

DTP

Checked result (classwork)

43

1

DTP

Practical

Advertising Campaign

Promotional Newsletter

DTP

Checked result (classwork)

44

1

DTP

Practical

Advertising Campaign

Promotional Newsletter

DTP

Checked result (classwork)

45

1

Powerpoint

Communication Ex

Presentation

Present your campaign

Create a simple presentation, using a blank template. Use some animated features

Checked result (classwork)

46

1

Powerpoint

Communication Ex

Presentation

Present your campaign

Use a mastersheet (with Logo’s)

Checked result (classwork)

47

1

Powerpoint

Communication Ex

Presentation

Present your campaign

Presentation

Checked result (classwork)

48

1

Databases

Practical

Database

Practice Database

Database basics

Checked result (classwork)

49

1

Databases

Practical

Database

Practice Database

Database basics


50

1

Databases

Practical

Database

Design a MailMerge Database -> send a Xmas Card to a few addresses (Filemaker)

Field definition


51

1

Internet (research)

Practical

Database

Internet

Search techniques

Checked result (classwork)

52

3

Databases

Practical

Database

HOLIDAY


Checked result (classwork)

1

3

Databases

Practical

Database

HOLIDAY


Checked result (classwork)

2

2

Databases

Practical

Database

Decide on Database project

Internet research

Checked result (classwork)

3

2

Databases

Practical

Database

Input Fields

Databse

Checked result (classwork)

4

2

Databases

Practical

Database

Design Layout

Good Database Practice

Checked result (classwork)

5

3

Databases

Practical

Database

Create New Layouts: Columnar report, welcome page

Good Database Practice

Checked result (classwork)

6

3

Databases

Practical

Database

Buttons

Good Database Practice

Checked result (classwork)

7

3

Databases

Practical

Database

Pop up lists

Good Database Practice

Checked result (classwork)

8

3

Databases

Practical

Database

Validation

Good Database Practice

Checked result (classwork)

9

3

Databases

Practical

Database

Input data

Good Database Practice

Checked result (classwork)

10

3

Databases

Practical

Database

Security

Good Database Practice

Checked result (classwork)

11

3

Databases

Practical

Database

If calculation

Good Database Practice

Checked result (classwork)

12

3

Databases

Practical

Database

Sorting, searches

Good Database Practice

Checked result (classwork)

13

3

Databases

Practical

Database

Wordprocess results

Good Database Practice

Checked result (classwork)

14

3

Databases

Practical

Database

Wordprocess results

Print from a Database

Checked result (classwork)

15

3

Spreadsheets

Practical

Spreadsheets at work

Introduction to spreadsheets

formatting cells

Checked result (classwork)

16

3

Spreadsheets

Practical

Spreadsheets at work

Basic spreadsheet skills

Basic Formula

Checked result (classwork)

17

3

Spreadsheets

Practical

Spreadsheets at work

Temperature Chart

Working with charts

Checked result (classwork)

18

3

Spreadsheets

Practical

Spreadsheets at work

Copying formula (relative)

Writting formula - simple
Setting print range

Checked result (classwork)

19

3

Spreadsheets

Practical

Spreadsheets at work

Copying formula (absolute)

Writting formula - extended
Printing formula

Checked result (classwork)

20

3

Spreadsheets

Practical

Spreadsheets at work

Project: Sales Rep

Good Spreadsheet Practice

Checked result (classwork)

21

3

Spreadsheets

Practical

Spreadsheets at work

Project: Sales Rep

Good Spreadsheet Practice

Checked result (classwork)

22

3

Spreadsheets

Practical

Spreadsheets at work

Project: Sales Rep

Good Spreadsheet Practice

Checked result (classwork)

23

3

Spreadsheets

Practical

Spreadsheets at work

Project: Sales Rep

Good Spreadsheet Practice

Checked result (classwork)

24

3

Spreadsheets

Practical

Spreadsheets at work

Project: Sales Rep

Good Spreadsheet Practice

Checked result (classwork)

25

3

Spreadsheets

Practical

Spreadsheets at work

Project: Sales Rep

Good Spreadsheet Practice

Checked result (classwork)

26

3

Spreadsheets

Practical

Spreadsheets at work

Project: Sales Rep

Good Spreadsheet Practice

Checked result (classwork)