SS3 Data Processing 1st Term

SS3 DATA PROCESSING 1ST TERM

SS3 Data Processing First Term Scheme of Work & Lesson Note

Data Processing is one of the science subjects SS3 students are required to study in first term. The Unit of Instruction for SS3 Data Processing 1st Term is carefully developed from the Scheme of Work, which in turn is, based on NERDC current curriculum and SSCE syllabus.

Students can now learn based on weekly lesson plan. Select any week, then click Go
Week 1   Week 2   Week 3
Week 4   Week 5   Week 6
Week 7   Week 8   Week 9
Week 10

Indexing and Indexes

SUB TOPICS:
A. Concepts and definition of index
B. Index classification
C. Types of indexing

NTI PgDE Past Q & A Click on
First Semester to get started.

LEARNING OBJECTIVES: At the end of the lesson, learners should be able to:
1 Explain the concept of indexing.
2 Define an index.
3 Explain how indexes are created.
4 List two purposes of indexing.
5 ETC

Database Security

SUB TOPICS:
A. Data security and risk assessment
B. Definition of access control
C. Types of access control
D. Methods of securing database
E. Terms used in database management
F. Cardinality relationship in database management

LEARNING OBJECTIVES: At the end of the lesson, learners should be able to:
1 Define: (i) Data security (i) Data risk assessment. (Source: Ref WAEC 2015, Q4a)
2 Explain the term access control. (Source: Ref WAEC 2015, Q4b [i])
3 List the access control methods in database security. (Source: Ref WAEC 2015, Q4b [ii])
4 State three roles of a database administrator. (Source: Ref WAEC 2015, Q4c)
5 ETC

Database Security (CONT'D)

SUB TOPICS:
A. Meaning and types of ciphers
B. Password and database security
C. Benefits of data security

LEARNING OBJECTIVES: At the end of the lesson, learners should be able to:
1 Explain substitution and transportation ciphers in (DBAS).
2 Explain the following: data migration and performance monitoring.
3 Demonstrate the methods, uses, and importance of password in database security.
4 State the benefits of data security.

Crash Recovery

SUB TOPICS:
A. System crash
B. Database crash
C. Definition of crash recovery
D. Phases involved in crash recovery

LEARNING OBJECTIVES: At the end of the lesson, learners should be able to:
1 Define system crash.
2 State three conditions under which a system crash occurs.
3 Define database crash.
4 List five methods use to prevent database crash.
5 ETC

Parallel and Distributed Databases

SUB TOPICS:
A. Characteristics or features of parallel and distributes databases
B. Methods for improving the performance of parallel database system

LEARNING OBJECTIVES: At the end of the lesson, learners should be able to:
1 Highlight two features or characteristics of a parallel database.
2 State three importance of using a distributed database. (Source: Ref WAEC 2020, Q4a [i])
3 List three features of a distributed database. (Source: Ref WAEC 2021, Q40)

Parallel and Distributed Databases (CONT'D)

SUB TOPICS:
A. Distributed storage system
B. Types of memoring and sharing
C. Storing in a DBMS

LEARNING OBJECTIVES: At the end of the lesson, learners should be able to:
1 Demonstrate and explain the three purposes of the distributed storage system.
2 Define data store and list the purposes of the distributed storage system.
3 Explain the following terms: shared memory, shared disk and sharing nothing.
4 State the benefits of storage in DBMS.
5 ETC

SS3 Data Processing 1st Term Revision and Mid Term Test

Take a Quiz on SS3 Data Processing 1st Term

It does not require sign up or login. But a correct and valid e-mail will help the quiz machine send you the questions and answers when you click SUBMIT. Cheers!

Please enter your email:

1. A file organization that contains a reference number is called — WAEC 2021, Q37

 
 
 
 

2. Which of the following file organizations requires a primary key? WAEC 2019, Q37

 
 
 
 

3. Mr Francis has an office complex with 20 rooms. What type of network is suitable for connecting all the computers in their various rooms into a single network? WAEC 2021, Q14

 
 
 
 

4. The correct order of the steps taken in creating a database from the database template in MS Access 2007 is — WAEC 2021, Q23

 
 
 
 

5. Which of the following terms is not a feature of distributed database? WAEC 2021, Q40

 
 
 
 

Question 1 of 5

Networking (CONT'D)

SUB TOPICS:
A. Meaning and types of architecture
B. Comparison between different architectures

LEARNING OBJECTIVES: At the end of the lesson, learners should be able to:
1 State the difference between the following: storage architecture, system architecture, server architecture and small architecture
2 State the benefits, advantages and disadvantages of each architecture.
3 Explain the following terms: PAN, LAN, WLAN, EPN and VPN.
4 Explain the following terms as used in network technology: network hubs, adapter, ethernet cable, servers, client, and repeater.

Networking (CONT'D)

SUB TOPICS:
A. Comparison between different networks

LEARNING OBJECTIVES: At the end of the lesson, learners should be able to:
1 Distinguish between different types of networks.
2 State the similarities between different types of networks.

Computer Virus

SUB TOPICS:
A. Meaning and types of computer virus
B. Sources and effects of computer virus
C. Advantaged and disadvantages of computer virus
D. Examples and signs of computer virus
E. Preventing computer virus
F. Installation of anti-virus software

LEARNING OBJECTIVES: At the end of the lesson, learners should be able to:
1 Explain and list types of computer virus.
2 Mention different sources of computer virus.
3 Highligt the effects or signs of computer virus.
4 State the advantages and disadvantages of computer virus.
5 ETC

Make Payment, Join e-Classes Online & Learn More

Back to Scheme of Work Go to Ana Arm YouTube

Get Resources for eClasses:
error: Content is protected !!