Information Technology

Objectives:

To complete project on SM based on a given scenario within the time set.

To demonstrate sufficient knowledge based on each section of unit 1: Information Technology Systems. (Digital Devices, Transmitting Data, Operating Online, Protecting Data and Information, Impact of IT systems and Issues).

To build a relational database in controlled conditions within a given timeframe including manipulating data, normalisation, testing and evaluation.

Year

Year 12

Term

Autumn

Spring

Summer

Unit

Unit 3: Social Media in Business

GLH: 90

Internal Assessed Project

Unit 1: Information Technology Systems

GLH: 120

External Assessed Exam

Unit 1: Information Technology Systems

GLH: 120

External Assessed Exam 

Unit 1: Information Technology Systems

GLH: 120

External Assessed Exam

Unit 1: Information Technology Systems

GLH: 120

External Assessed Exam 

Time

14 weeks

4 weeks

8 weeks

9 weeks

5 weeks

C
O
N
T
E
N
T

&

E
L
E
M
E
N
T
S

A: Explore the impact of social media on the ways in which business promote their products and services

B: Develop a plan to use SM in a business to meet requirements

C: Implement the use of social media in a Business

A: Digital Devices in IT Systems

B: Transmitting Data

C: Operating Online

D: Protecting Data and Information

E: Impact of IT sysyems

F: Issues

Revision

&

Introduction to Unit 2

Databases


Year

Year 13

Term

Autumn

Spring

 

Unit

Unit 2: Creating Systems to Manage Information

CW2

Option Unit

Web design Or Spreadsheets

 

Time

13 weeks

1

2 weeks

6 weeks

3 weeks

C
O
N
T
E
N
T

&

E
L
E
M
E
N
T
S

A: The purpose and structure of relational database management systems

B: Standard methods and techniques to design relational database solutions

C: Creating a relation database structure

D: Evaluating a database development project

M
O
C
K

E
X
A
M
I
N
A
T
I
O
N
S

Mock Exam

Option Unit

Web design Or Spreadsheets

Revision for repeat exams

R
E
V
I
S
I
O
N

A
L
E
V
E
L