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.
Indexing and Indexes, Database Security, Crash Recovery, Parallel and Distributed Databases, Networking, Computer Virus, etc.
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
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
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.
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
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)
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
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!
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.
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.
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