SECONDARY TECHNOLOGY YEARLY SCHEME OF WORK

2024 / 2025
(Edition Four)

SUBJECT: TECHNOLOGY
GRADE 12
SCHOOL: ___________________________________

TEACHER: ___________________________________

NUMBER OF PERIODS PER WEEK: _________________

Maadada: Technology 1 Fasalka: 12-aad (F4)

 SCHEME OF WORKFORM FOUR TECHNOLOGYTERM ONE AND TWOYEAR 2023/2024

TEACHING / MATERIALS
LESSON / SPECIFIC
WK/NO L/NO SUBTOPIC LEARNING / REF. REM.
OBJECTIVES
TOPIC ACTIVITIES RESOURCES
1
Admission of students and preparation
2 1 Introduction to By the end of the lesson,  Identifying  Assignments
system analysis the learner should be systems and its  Presentations
and design able to: characters  Group work
1.1 What is a  Describe the system  Explaining the activities
UNIT 1
system and its concept of  Practical
INTRODUC 1.2 Information characteristics system analysis assignments
TION TO system  Define information and design or Test for
SYSTEM 1.3 Purpose of system  Use the available computer
ANALYSIS information  Identify the five key devices to show networks. Pg 2-
AND system components of the system 7
DESIGN 1.4 System information system development
analysis and  Explain the concept
design of system analysis
1.5 System and design
development  Describe system
life cycle analyst

Maadada: Technology 2 Fasalka: 12-aad (F4)

 3 1 Introduction to By the end of the lesson,  Defining  Assignments
System to system the learner should be planning ,  Presentations
analysis and able to: analyzing in the  Group work
design  Discuss in detail the system activities
1.6 Stage of system system development development life  Practical
development life cycle cycle assignments
life cycle  Demonstrate  Test.
1.6.1 Planning Basic stages of
1.6.2 Analyzing system Pg 7-
development 13

Introduction to By the end of the lesson,  Describing the

System to system the learner should be system  Assignments
4 1 analysis and able to: development life  Presentations
design  Discuss in detail the cycle  Group work
1.6.3 Design system development  Demonstrate activities
1.6.4 System life cycle Basic stages of  Practical Pg
construction system assignments 13-
development or Test for 17
computer
networks.

Maadada: Technology 3 Fasalka: 12-aad (F4)

5 1 Network devices , By the end of the lesson,  Demonstrating  Assignments
cables and the learner should be Basic stages of  Presentations
protocols able to: system  Group work
1.6.5 Testing  Define testing the development life activities
1.6.6 Deployment system development cycle  Practical
of the life cycle assignments Pg
system  Define maintenance 17-
 Test.
1.6.7 Maintenanc 19
e

System By the end of the lesson,  Describing  Assignments

development the learner should be various system  Presentations
methodologies able to: methodologies  Group work
2.0 Waterfall  Explain various  Classifying agile activities
model system methodologies method and  Practical
6 2 2.1 what is agile  Differentiate between waterfall model assignments Pg
methods Agile method and  Test 20-
waterfall model 24

7 2 System By the end of the lesson,  Explaining the  Assignments

development the learner should be concept of RAD  Presentations Pg
methodologies able to: model  Group work 24-
2.2 Rapid  Explain the concept  Identifying activities 26
application of RAD model stages of RAD  Practical
development ( Identify stages of assignments
RAD ) RAD  Test

Maadada: Technology 4 Fasalka: 12-aad (F4)

 8 1 Introduction to By the end of the lesson,  Describing  Assignments
UNIT 2 database the learner should be Database  Reports Pg
management able to:  Identifying why  Group 28-
1.1 What is database  Define a database use a database 30
MICROSO Discussion
1.2 Why do we use a  Explain why use a
FT
database  Group work
ACCESS database?
activities
2016  Test

1 Introduction to By the end of the lesson,  Describing

9 database the learner should be basics of  Assignments Pg
management able to: database  Reports 30-
 Understand the management  Group 35
1.3 Database object basics of Database system Discussion
and Database  Identifying  Group work
Management System database objects activities
 Discuss database  Test
object

10 2 Managing By the end of the lesson,  Identifying

database and the learner should be features of  Assignments
object able to: Microsoft access  Reports
2.1 Getting started  Describe the major 2016  Group
Microsoft Access features of Microsoft  Use the available Discussion Pg
2016 access 2016 resource to show  Group work 36-
 Demonstrate how to the interface of activities 43
minimize and Microsoft Access  Test
maximize the ribbon  Identifying
 Customize the maximizing and
navigation pane in minimizing
different views ribbon

Maadada: Technology 5 Fasalka: 12-aad (F4)

11 2 Working with By the end of the lesson,  Creating ,saving  Assignments
Slides the learner should be and opening  Reports
2.2 Creating database able to: access using  Group
 Create, save and Microsoft access Discussion
open Access using   Group work
Microsoft Access. activities
 Test
 Individual Pg
Project 43-
 Practical Test 48

12 3 Working with By the end of the lesson,  Crating tables in  Assignments

tables the learner should be access  Reports
able to:  Crating primary  Group
3.1 Table basics  Demonstrate the keys in a table Discussion Pg
3.2 Creating ability to work with  Opening existing  Group work 49-
primary keys Data in Microsoft table activities 57
in a table Access  Adding ,editing  Individual
 Explain Microsoft or deleting Project
access table records in table  Practical Test
 Create or open
existing table
 Navigate within
tables in different
options
 Add, edit or delete
records in table
 Create primary keys
in a table

Maadada: Technology 6 Fasalka: 12-aad (F4)

 13 4 By the end of the lesson,  Identifying how  Assignments
Working with the learner should be to create forms  Reports
forms able to: with access  Group
4.1 why use forms  Explain Microsoft  Opening existing Discussion
access form forms in MS  Group work
 Create or open access activities
existing forms  Individual Pg
Project 58-
 Practical Test 61

14 4 By the end of the lesson,  Adding new  Assignments

Working with the learner should be record  Reports
forms able to:  Existing record  Group
 Add new record  Add new record to view or edit Discussion
 Find an existing  Search a record in  Save the current  Group work
record to view the form records activities
or edit  Add, edit or delete  Deleting the  Individual Pg
records using access current Project 61-
 Save the
forms documents  Practical Test 64
current record
 Delete the
current record

By the end of the lesson,  identifying how  Assignments

Designing a query the learner should be to use queries in  Reports
5.1 what are queries able to: MS access  Group
 Explain Microsoft  Discussion
access query  Group work
 discuss the benefits activities
15
of using query  Individual
Project
 Practical Pg
5 65-
68

Maadada: Technology 7 Fasalka: 12-aad (F4)

 Designing a query By the end of the lesson,  Describing how  Assignments
5.2 Designing a the learner should be to design multi-  Reports
5 multi-table query able to: table queries  Group
5.3 Creating a multi-  Demonstrate the  Crating mult- Discussion
table query ability to run queries table query  Group work
and reports activities
16
 Create or open an  Individual
existing a simple Project
query Practical Pg68
-72
17 6 Creating reports By the end of the lesson,  Creating report  Assignments
 Create report the learner should be  Save report  Reports
 Save report able to:  Delete field in a  Group
 Delete field in a  Explain Microsoft report Discussion Pg
report access report  Printing reports  Group work 73-
 Printing reports  Create or open in print preview activities 76
in print preview existing a simple  Individual
report Project
 Demonstrate how to Practical
save or print a simple
report

18 REVISON OF MID TERM

Maadada: Technology 8 Fasalka: 12-aad (F4)

 Basics of By the end of the lesson,  discussing  Practical
programming the learner should be programming assignments
1.1 what is a able to: languages  Practical
programming  define programming  Use the available Exercises
 identify the types of resource to show  Presentations
UNIT 3 programming the Basic  Group work
languages ( High – programming activities
19 1 Programmi
Level Languages and concepts  Individual
ng Pg
Low- Level Languages Project
)  Practical Test 79-
 Demonstrate how 82
.
programs are
executed using
compilers and
interpreters.
 explain the work of
IDE ( integrated
Development
Environment ) and
its tools

Maadada: Technology 9 Fasalka: 12-aad (F4)

20 1 Basics of By the end of the lesson,  Group  Practical
programming the learner should be discussion assignments
1.2 what is able to:  Use  Practical
debugging  define what is a Presentations Exercises
1.3 Whypython? debugging slides  Group work
 list and identify the  Use the available activities
different kinds of resource to show  Individual
errors occur in the Basic Project
programming programming  Practical Test Pg
 list and identify the concepts 83-
most popular  Use appropriate 87
programming shapes to
languages demonstrate
 Explain why a python input and output
is a power in programing
programming and Error
language for learning. handling, Data
types and
variables and
 program
structure using
Python

Introduction to By the end of the lesson,  Creating  Practical

programming using the learner should be important tools assignments
python able to: used to getting to  Practical
2 2.1 Getting python  Describe the start the python Exercises Pg
important tools used programming  Group work 88-
to getting to start the  Use the available activities 91
21
python programming resource to show  Individual
the Basic Project
programming  Practical Test
concepts

Maadada: Technology 10 Fasalka: 12-aad (F4)

22 2 Introduction to By the end of the lesson,  Describing  Practical
programming using the learner should be interactive assignments
python able to: window  Practical
2.2 The interactive  Execute a python  Use the available Exercises Pg
window script using at the resource to show  Group work 92-
2.3 The script shell prompt and the Basic activities 94
window interactive window programming  Practical Test
using IDE concepts

Introduction to By the end of the lesson,  Use the available  Practical Pg94
programming using the learner should be resource to show assignments -97
python able to: the Basic  Practical
 Explain the values , programming Exercises
2.4 Values, data data types, variables concepts  Group work
types , variables and expressions in  Use appropriate activities
and expressions python shapes to  Individual
2.5 Basic calculations  Demonstrate the demonstrate Project
skills to use input and output  Practical Test
2 in python
conditional in programing
23 statements in python and Error
 Demonstrate the handling, Data
skills to use types and
repetitions variables
statements in python andprogram
structure using
Python

Maadada: Technology 11 Fasalka: 12-aad (F4)

 By the end of the lesson,  describing  Practical
Introduction to the learner should be complex assignments
programming using able to: calculations in  Practical
python  Combine operators programing Exercises
2.6 More Complex into bigger languages  Group work
calculations calculations  Use the available activities Pg
 demonstrate input resource to show  Individual 97-
2.7 String
and output in the Basic Project 98
expressions
2 programing, Data programming  Practical Test
24 types program concepts
structure using
Python

25 Introduction to By the end of the lesson,  describing  Practical

programming using the learner should be variable in  Exercises
python able to: python  Presentations
2.8 variables  Group discussion programming  Group work
 Use Presentations  Use the available activities
slides resource to show  Individual Pg
 Use the available the Basic Project 98-
2 resource to show the programming  Practical Test 104
Basic programming concepts
concepts
 demonstrate input
and output in
programing variables
and program
structure using
Python

Maadada: Technology 12 Fasalka: 12-aad (F4)

 By the end of the lesson,  Identifying Practical
Introduction to the learner should be percentages assignments
programming using able to: using python  Individual
python  Calculate the program Project Pg
2
2.9 Calculating percentage using  Use the available  Practical Test 105-
percentage python program resource to show  Group work 106
the Basic activities
programming  Presentation
concepts
26
27 By the end of the lesson,  Describing  Presentations
Introduction to the learner should be conditional  Group work Pg
programming using able to: statements in activities 107-
python  Conditional python  Individual 108
2.10 Conditional statements and  Identifying Project
statements and Boolean logic Boolean logic in  Practical Test
2 python
Boolean logic
 Use the available
resource to show
the Basic
programming
concepts
28 Introduction to By the end of the lesson,  Describing  Presentation Pg
programming using the learner should be Boolean  Group work 108-
python able to: expressions and activities 109
2.11 Boolean  Demonstrate the relational  Practical Test
Expressions and Boolean and operators in  Individual
2 relational relational operators python project
 Use the available
operators
resource to show
the Basic
programming
concepts

Maadada: Technology 13 Fasalka: 12-aad (F4)

29 2 Introduction to By the end of the lesson,  Describing  Practical Pg
programming using the learner should be how to use if Exercises 109-
python able to: statement in  Presentations 117
2.12 Using the if  Demonstrate how python  Group work
statement to use if statement languages activities
 Individual
Project

30 Introduction to By the end of the lesson,  Identifying how  Presentations

programming using the learner should be to use loop  Group work
python able to: structure in activities
2 2.13 Loop  Demonstrate python  Individual
structures for structures for languages Project Pg
repetitions repetitions  Use the available  Assignments 118-
resource to show exercise 135
the Basic
programming
concepts
31 Digital Security , By the end of the lesson,  Describing
Safety And Privacy the learner should be digital security  Practical
1 UNIT 4 1.1 Digital security able to: and types of assignments
ICT Risks  Define the term cybercriminals  Practical
SECURITY 1.2 Cybercrime digital security, and  Use the available Exercises Pg
AND 1.3 Internet and describe the types of resource to show  Group work 138-
cybercriminals the Digital activities 146
ETHICS network attacks
 Explain various types security,  Individual
of internet and Cybercrime , Project
network attacks internet and  Practical Test
network attacks
Basics ICT ethics
.

Maadada: Technology 14 Fasalka: 12-aad (F4)

32 1 Digital Security , By the end of the lesson,  Defining firewalls  Exercises
Safety And Privacy the learner should be and its  Presentations
1.4 Firewalls able to: techniques  Group work
1.5 Access Control  Define firewalls  Describing activities Pg
1.6 User Name and  Discus techniques to access control in  Individual 147-
Password prevent unauthorized digital security Project 148
computer access and  Practical Test
use including access
controls , usernames
and passwords

33 1 Digital Security , By the end of the lesson,  List common  Group work
Safety And Privacy the learner should be software used for activities
1.7 Software Theft able to: thefts  Individual
1.8 Information Theft  Identify safeguards  Use the available Project Pg
1.9 Backing Up against software theft resource to show  Practical Test 149-
Explain options the software  Group 148-
available for backing theft discussion 151
up. ,information
theft and how to
backing up
information
34 2 Computer ethics By the end of the lesson,  Describing the  Practical Test
2.1 What are ethics the learner should be concepts of  Group
2.2 Computer able to: ethics. discussion
ethics  Explain the concepts  Listing the types  Individual
2.3 Intellectual of ethics and of intellectual project Pg
property computer ethics properties 152-
 Practical
 List the types of exercise
154
intellectual property

Maadada: Technology 15 Fasalka: 12-aad (F4)

35 2 Algorithms By the end of the lesson,  Defining privacy  Practical
Design , pseudo the learner should be  Listing free assignments
code and flow able to: software of  Practical
chart  Discuss privacy algorithms Exercises
2.4 Privacy concerns  Use the available  presentations Pg
concerns  Describe the resource to show  individual
155-
2.5 Free software, difference among free the privacy, free 159
project
freeware and software , freeware software in ICT
and shareware  Group
shareware Basics discussion

36
REVISION OF FINAL EXAM

Teacher’s Name: ____________________________

Period per week: 2

Maadada: Technology 16 Fasalka: 12-aad (F4)