SS2 Data Processing 1st Term

SS2 DATA PROCESSING 1ST TERM

SS2 Data Processing First Term Scheme of Work & Lesson Note

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

Data Modeling

SUB TOPICS:
A. Introduction to data modeling
B. Types of data modeling

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 State the meaning of data modeling.
2 List and discuss types of data modeling with the aid of diagrams.
3 Explain the meaning of relational, hierarchical, object oriented, and flat data modelings.

Data Modeling (CONT'D)

SUB TOPICS:
A. Creating Tables, Forms, Queries and Reports
B. Table structure and concept of Primary Key
C. Types of Forms
D. Building blocks of a Form – the fields
E. Significance of data modeling

LEARNING OBJECTIVES: At the end of the lesson, learners should be able to:
1 Create a table structure and add tables to a database.
2 Create a form and link it to a database table.
3 Use a Simple Query wizard to create a query.
4 Identify and discuss four major objects in Microsoft Access.
5 ETC

Data Modeling (CONT'D)

SUB TOPICS:
A. Introduction to standard data model
B. Examples of standard data model

LEARNING OBJECTIVES: At the end of the lesson, learners should be able to:
1 State the meaning of standard data model.
2 List examples of standard data model.

Database Normalisation: Normal Forms

SUB TOPICS:
A. Meaning of norminalisation
B. Definition and types of normal form

LEARNING OBJECTIVES: At the end of the lesson, learners should be able to:
1 Give examples of tables in first and second normal tables.
2 State the problems of tables in first normal form.
3 Describe the following first, second, and third normal forms.
4 Explain foreign key and primary key.
5 ETC

Database Normalisation: Normal Forms (CONT'D)

SUB TOPICS:
A. Problems of table in first normal form
B. Determinants of normal forms

LEARNING OBJECTIVES: At the end of the lesson, learners should be able to:
1 Highlight and explain the problems of table in first normal form.
2 Identify any determinants, other than the primary key, and the columns they determine.

Database Normalisation: Normal Forms (CONT'D)

SUB TOPICS:
A. Importance of normalisation
B. Advantages and disadvantages of normalisation

LEARNING OBJECTIVES: At the end of the lesson, learners should be able to:
1 Highlight the significance of normalisation.
2 List the advantages of normalisation.
3 State the disadvantages of normalisation.

SS2 Data Processing 1st Term Revision and Mid Term Test

Take a Quiz on SS2 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. Relational database is also known as —

 
 
 
 

2. An interactive tool that searches through large volume of text to retrieve information from the internet as —

 
 
 
 

3. Which of the following is not an advantage of file organization? WAEC 2017, Q38

 
 
 
 

4. The process of locating stored data and making them available for use is referred to as —

 
 
 
 

5. What file organization would require that all the five (5) records be read before the 6th record is written? WAEC 2017, Q37

 
 
 
 

Question 1 of 5

Relational Model

SUB TOPICS:
A. Creating and modifying relations using SQL
B. Integrity constraints over relations

LEARNING OBJECTIVES: At the end of the lesson, learners should be able to:
1 List steps for creating and modifying relations using SQL.
2 State and explain the two parts of an SQL.
3 Highlight the importance of using a SQL in a database.
4 List and explain different types of SQL statements.
5 ETC

Relational Model (CONT'D)

SUB TOPICS:
A. Enforcing integrity constraints
B. Querying relational data

LEARNING OBJECTIVES: At the end of the lesson, learners should be able to:
1 Identify and explain different types of constraints.
2 Write a SQL NOT NULL constraint.
3 Write a SQL UNIQUE KEY constraint.
4 Write a SQL PRIMARY KEY constraint.
5 ETC

File Organization

SUB TOPICS:
A. Meaning and features of a file
B. Definition and importance of file organisation
C. Methods or types of file organization
D. Characteristics of file organization.

LEARNING OBJECTIVES: At the end of the lesson, learners should be able to:
1 Explain the meaning and features of a file.
2 Define and state the importance of file organisation.
3 List and explain different types of file organizations.
4 Highlight the characteristics of file organization.

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 !!