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
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
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.
(Ana Arm Technologies)
Data Modeling
Database Normalisation: Normal Forms
Entity Relationship Model
Relational Model
File Organisation
Online Quiz
Reference Textbooks
Quick Links to
SS 2 Subjects 1st Term
SS 2 Accounting 1st Term SS 2 Agric Science 1st Term
SS 2 Animal Husbandry 1st Term
SS 2 Biology 1st Term
SS 2 Chemistry 1st Term
SS 2 Civic Education 1st Term
SS 2 Commerce 1st Term
SS 2 Computer Science 1st Term
SS 2 Computer Studies 1st Term
SS 2 Data Processing 1st Term
SS 2 Economics 1st Term
SS 2 English Language 1st Term
SS 2 Government 1st Term
SS 2 Marketing 1st Term
SS 2 Mathematics 1st Term
SS 2 Physics 1st Term
SS3 Class 3rd Term
SS2 Class 3rd Term
SS1 Class 3rd Term
SS3 Class 2nd Term
SS2 Class 2nd Term
SS1 Class 2nd Term
SS3 Class 1st Term
SS2 Class 1st Term
SS1 Class 1st Term
-
Contact Us