COMPUTER STUDIES ICT JSS 3 FIRST TERM LESSON NOTES PLAN

FIRST TERM E-LEARNING NOTES                                                        

JSS 3 (BASIC 9)

SUBJECT:      COMPUTER SCIENCE

SCHEME OF WORK

WEEK    TOPICS

1. Revision of JSS 2 third term’s work

2. Internet III

First Period: (a) Meaning of search engine (b) Examples of search engines (i) google.com (ii) man.com (iii) ask.com (iv) yahoo.com etc.

Second period: (c) Uses of Search Engines

3. Internet III

First & Second Period: Practical uses of search engine

(Note I:    Connect to the Internet and let each student know how to use all the search engines above. Note II: please

 make all the search engines diagram in this week)

4. Digital Divide

First & Second Period:(a) Concept of digital divide

5. Digital Divide

First Period: (b) Features of old economy    i.e. (i) Time consuming (ii) Labour based (iii) Mechanical (iv) Constrained by space, time and distance

Second Period:       (c) Features of new economy   i.e.  (i) Digital gadgets (ii) Time, space and distance is irrelevant (iii) New economy is technology driven (iv) knowledge based (v) Technology innovation is the key cornerstone to limitation of the old economy

6. Digital Divide Cont. (d) Limitation of the old economy

 (e) Benefits of new economy.  (i) Low capital to start business (ii) Low unemployment (iii) immunity to boom macroeconomic cycle (iv) Creating of new jobs (v) Practical on the uses of search engine.

7. Mid Term Holiday

8. Database

(a) Definition

(b) Database Terminologies (i) Fields (b) Records (iii) File (iv) Database (v) Key etc

9. Database cont.

c) Forms of Database: (i) Flat file (ii) Hierarchical (iii) Relational etc

10. Examination JSS 3 COMPUTER STUDIES ICT

DATABASE PRACTICAL (MS ACCESS)

Starting and opening and existing database

Sub-Topic 1: PRACTICAL

Starting MS Access

Unlike a word processing or spreadsheet document, which you can name after you have started or completed it, a database has to be named before any work is started on it.

1. Click on the Start
2. Select All Programs.
3. Select Microsoft Office and then Microsoft Office Access.
4. Check for New Blank Database and then click on ‘Blank database’.
5. Type a name for your database into the ‘File Name’, box.
6. Click Create and you are in Access environment

When working in Access, you make use of tables. Tables are the most important object in the database.

To create a table, you can use any of the following methods:

1. Datasheet view
2. Design view
3. Table wizard

Creating a table in Datasheet view

1. Open the database.
2. Click Create
3. Click Table Design Tab
4. Enter Field Names and Data Type g. Surname, Middle name, Last Name etc
5. Save table,
6. (A prompt for primary key pops out, click No for now)
7. Click View

8. Select Datasheet view.