WEEKS
|
TOPIC
|
CONTENT
|
1.
|
Revision/ Logic Gates
|
Revision of last term work/ Definition of logic gate
Simple logic gates: AND, OR, NOT
Microsoft PowerPoint practical
|
2.
|
Logic Gates
|
Alternative logic gates: NAND, NOR
Truth table: Definition
Construction of truth tables for AND, OR, NAND, NOR
|
3.
|
Computer network
|
Definition of computer network
Types of network: LAN, WAN, MAN
Network topology: star network topology, bus network topology, ring network topology
|
4.
|
Database
|
1. Definition of a database and DBMS
2. Database Terminologies
- Fields
- Records
- File
- Database
- primary Key, data types,etc
3.Introduction to MS Access database
|
5.
|
Database
|
Forms of Database
- Flat file
- Hierarchical
- Relational, etc
Practical on to create a new database in MS Access
Practical: Create and develop a new database for a specific purpose
Set appropriate data types for each field
Input, store and retrieve information from a database application
Start and open an existing database
|
6
|
Spreadsheet Packages
|
1. Definition of Spreadsheet Packages
2. Examples of spreadsheet packages
- Excel
- Lotus 1-2-3
- STATVIEW, etc
3. Uses of spreadsheet packages
- Preparation of daily sales
- Budget
- Examination results
4. Spreadsheet features and terminologies
- Row - Worksheets
- Column - Chart
- Cell - Data range, etc
|
7
|
MIDTERM
|
Midterm Assessment and Mid-Term break
|
8.
|
Spreadsheet Packages
|
a. Introduction to MS Excel: Practical on loading and exiting a worksheet, identify the features of a spreadsheet i.e. cells, worksheet, row, column, entering data in a worksheet
|
9.
|
Spreadsheet Package
|
a. MS Excel: entering data in a worksheet, performing simple math calculations using formulas and functions, creating charts (bar chart, pie chart, doughnut chart)
|
10.
|
Spreadsheet package: MS Excel Practical
|
Worksheet:
- Printing a worksheet
- Formatting worksheet (text, cell and columns naming, etc)
- performing Maths calculations using formulas and functions i.e. SUM, AVERAGE, MAX, MIN, PRODUCT. Carrying out subtraction and division. Creating charts.
|
11
|
Revision/Examination
|
|
12 - 13
|
|
|
Share with your friends: |
