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
SS3 DATA PROCESSING 1ST TERM
SS3 Data Processing First Term main topics are:

Indexing and Indexes, Database Security, Crash Recovery, Parallel and Distributed Databases, Networking, Computer Virus, etc.

NEW! Exam Questions. Click on
SS2 Biology 2nd Term to get started.

Announcement for Students in:
SS One, SS Two & SS Three, First Term

Study Online & Get
Better SSCE (WAEC & NECO) Results
Than in Tutorial Classes
Tutorial or Home lesson may not be so effective in your quest for academic excellence, especially when you have the opportunity to access our content-rich, well-formatted e-Notes, Video Lessons, Voice Notes, etc
Week 1: 09-09-2024

Indexing and Indexes

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

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

Week 2: 16-09-2024

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

Week 3: 23-09-2024

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.

Week 4: 30-09-2024

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

Week 5: 07-10-2024

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)

Week 6: 14-10-2024

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

Week 7: 21-10-2024

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. The field in a database which uniquely identifies each record is called a — WAEC 2021, Q22

 
 
 
 

2. Ensuring the correctness and consistency of data is referred to as data — WAEC 2019, Q38

 
 
 
 

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

 
 
 
 

4. One unique feature of index file is that it contains — WAEC 2019, Q36

 
 
 
 

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

 
 
 
 

Question 1 of 5

Week 8: 28-10-2024

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.

Week 9: 04-11-2024

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.

Week 10: 11-11-2024

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

Work in Progress. Please check back 49

Other Classes are Listed Below
for Data Processing
SS 1 SS 2 SS 3
1st 2nd 3rd 1st 2nd 3rd 1st 2nd 3rd

Scheme of Work by Topic for:
SS3 Data Processing 1st Term
(Ana Arm Technologies)
Indexing and Indexes
Database Security
Crash Recovery
Parallel and Distributed Databases
Networking
Computer Virus
Online Quiz
Reference Textbooks

Senior School e-Classes

Trending Post

Select a Category

Archives

SS One Subjects 1st Term

SS Two Subjects 1st Term

SS Three Subjects 1st Term

NTI PgDE Past Q & A

SS One Subjects 2nd Term

SS Two Subjects 2nd Term

SS Three Subjects 2nd Term

Textbooks and References

SS One Subjects 3rd Term

SS Two Subjects 3rd Term

SSCE Past Questions

TRCN Past Q & A

Youtube Videos

error: Content is protected !!