Cambridge Information & Communication Technology
SCHEME OF WORK
SY 2019 - 2020
The
Lesson |
Subtopic |
Learning Aim |
Learning Objectives |
Support Study Links and Vocabulary |
1 |
Introduction to Personal Computer |
Understand the concept and components of Personal Computers. |
1. To be able to define the various parts of a Personal Computer |
1. End Users |
2 |
Input Devices |
Discover the various types of input devices and their functions and application. |
1. Define what an input device is |
1. Devices |
3 |
Output Devices |
Discover the various types of output devices and their functions and application. |
1. Define what an output device is |
1. Computer Monitor |
4 |
Processing Devices |
Recognize and Understand the concepts of Processing Devices and their types. |
"1. Define what a processing device is |
1. Central Processing System
|
5 |
Storage Devices |
List and recognize the concepts of Storage Devices and Its types. |
1. Explain the definition of Storage Devices. |
1. Primary Storage
|
6 |
Devices Review |
Recognize and identify the Computer Devices |
1. Describe the concepts of the I/O Devices. |
1. Peripheral |
6 |
Devices Review |
Recognize and identify the Computer Devices |
1. Describe the concepts of the I/O Devices. |
1. Peripheral
|
7 |
Software Types |
Define and describe software and its types. |
1. Define the Software definition and its characteristics. |
|
8 |
Moral Issues |
Identify and recognize some computer moral issues. |
1. Discuss the ICT moral issues and its classifications. |
1. Anti Virus
|
9 |
Laws and Protection |
Define and identify some common ethical laws and protection related to Computer issues and mechanism. |
1. Define Computer ethical laws. |
|
10-11 |
Laws and Protection |
Define and identify some common ethical laws and protection related to Computer issues and mechanism. |
1. Classifying the principles of data protection Acts. |
1. Password Protect |
12 |
Assessment |
Unit Assessment |
||
Lesson |
Subtopic |
Learning Aim |
Learning Objectives |
Support Study Links and Vocabulary |
1 |
What is a network |
- Explain what a computer network is |
- Identify the definition of a computer network |
![]() |
2 |
Network Hardware |
- Identify the purpose of network devices |
- Identify common network devices |
![]() |
3 |
Network Hardware |
- Identify the purpose of network devices |
- Identify common network devices |
![]() |
4 |
Wired V Wireless |
- Analyse the key differences between wired and wireless connections |
- Compare the different connection mediums |
![]() |
5 |
Network Topologies |
- Compare and contrast the different network topologies |
- Identify the different network topologies |
![]() |
6 |
Network Types |
- Differentiate between different network types and where they are used |
- Identify the different types of network |
![]() |
7 |
Protocols |
- Expound where different protocols fit into networks |
- Identify the names of different network protocols |
![]() |
8 |
The Internet |
- Identify what the internet is and how it impacts our lives |
- Identify what the internet is |
![]() |
9 |
Project |
TBC dependent of resources |
TBC dependent of resources |
|
10 |
Project |
TBC dependent of resources |
TBC dependent of resources |
|
11 |
Review |
Evaluation and Topics Review |
Review Topics |
EOS 1 Reviewer Link Click the ![]() |
12/13 |
End of Semester Review 219398 |
Hardware & Software Review 330571 |
Computer Networks Review Code 965907 |
Computer Fundamentals Review |
Review on advantage and disadvantage of different network topologies (Ring, Bus, Star, Mesh, etc.), and identifying components or parts on a network, online safety, and internal and external computer hardware parts, etc. |
||||
End of Semester 1 | ||||
|
Subtopic |
Learning Aim |
Learning Objectives |
Support Study Links and Vocabulary |
1 |
Introduction: Flat Files vs Relational DBs & their uses |
To develop an understanding of databases |
1. Describe what a database is |
|
2 |
Data Types |
To understand the use of data types in a database |
1. Understand we can search for information quickly in computer databases |
data types, currency, scientific, integer, boolean, text, yes/no, date/time |
3 |
Introduction to Microsoft Access: |
To develop practical skills in database creation |
1. Identify key database terms and why we use computerized databases |
table, create a database, import
|
4 |
Creating DBs, Importing & Tables |
1. Creating database tables 2. Create a database using fields & datatypes |
table, create a database, import
|
|
5 |
Forms |
Understand how to create database forms for data entry |
1.Identify what a database form is and why we use them |
|
6 |
Queries |
Develop the use of queries & search skills in databases |
1.Recognise that searching a computerized database is faster than by paper |
|
7 |
Reports |
Understand how to create database reports |
1.Explain why we use database reports |
report, sorting, ascending, descending
|
8 |
Relationships |
Develop an understanding of relationships in a database |
1. Be able to describe what a relational database is and why we use them |
relationship, link, one to many, many to many, relational
|
9 |
Practical uses |
To implement all learned database skills in a practical solution |
1. Be able to create a database with tables, fields and records |
all previous vocabulary |
10 |
Evaluation & Topic Review |
Review database theory concepts |
1. Review any topics that they struggled with in previous lessons. T will decide on the most appropriate topic for this lesson |
all previous vocabulary |
11 |
Assessment (theory/practical?) |
To complete the database assessment |
1. Complete a theory and practical exam that covers both lessons in this week |
Assessment |
12 |
Assessment (theory/practical?) |
To complete the database assessment |
1. Complete a theory and practical exam that covers both lessons in this week |
Assessment |
Lesson |
Subtopic |
Learning Aim |
Learning Objectives |
|
1 |
Introduction to App Inventor |
- Identify what app inventor is and its key features |
1. Understand how to login using a google account |
App Inventor, Design View, Blocks View |
2 |
Design View |
- Identify the key parts of design view |
1. Explain the key components in the palette |
Design View, Palette, Design Viewer, Components, Media, Properties |
3 |
Blocks View |
- Identify the key parts of blocks view |
1. Explain the key block categories |
Blocks View, Blocks Viewer, Blocks Viewer |
4 |
Simple Application |
- Create a simple application |
1. Recall the key components |
Blocks View, Designer View, Blocks Viewer, Palette, |
5 |
Application Enhancement |
- Enhance a mobile application |
1. Identify improvements to an application |
Blocks View, Designer View, Blocks Viewer, Palette, |
6 |
Procedures |
- Use advanced blocks within an application |
1. Understand what if statements are |
Procedure blocks, If statements, While loops |
7 |
Variables |
- Use advanced blocks within an application |
1. Define a variable |
Procedure blocks, Variable blocks, If statements, While loops |
8 |
Project Design |
- Design an application for a specific purpose |
1. Identify the purpose of your application |
App Inventor, Blocks View, Designer View, Blocks Viewer, |
9 |
Project Construction |
- Create an application for a specific purpose |
1. Select suitable components to use in your application |
App Inventor, Blocks View, Designer View, Blocks |
10 |
Project Construction |
- Create an application for a specific purpose |
1. Identify the blocks you need to build your application |
App Inventor, Blocks View, Designer View, Blocks Viewer, Palette, Control, Math, Logic, Text, List, colours blocks, Properties, Media, components |
11 |
Project Feedback |
- Give constructive feedback of a specific app |
1. Identify what specific feedback is |
App Inventor, Blocks View, Designer View, Blocks |
12 |
Project Improvements |
- Implement enhancements to your application |
1. Understand the importance of debugging/ enhancing |
App Inventor, Blocks View, Designer View, Blocks |