Second Term JSS3 Computer Science Lesson Note

Description

This lesson note covers the following topics for JSS3 Second Term Computer Studies:

1        Revision of First term work

2. Spreadsheet Packages:

First Period:  (a) Meaning   (b) Examples of spreadsheet package:   (i) Excel    (ii) LOTUS 1,2,3    (iii) Statview etc.

Second Period:        (b) Uses of spreadsheet packages: (i) preparation of daily sales   (ii) Budget

(iii) Examination result, etc.

3. Spreadsheet packages cont.

First & second

period:         (a) Spreadsheet features and terminologies   (i) Row   (ii) Column    (iii)) Cell

(iv) Worksheet     (v) Chart     (vi) Data range etc.

(b) Loading and exiting spreadsheet packages.

4. Worksheets

First Period:  (a) Starting Excel worksheet:  i.e. (i) opening a worksheet  (ii) Data entry   (iii) Editing    (iv) saving     (v) Retrieving worksheet

Second Period:        (b) Formatting worksheet, i.e. (text, cell and column, naming, etc)

5. Worksheets cont.

First period: (c) Excel calculations:  (i) Addition   (ii) Subtraction   (iii) Average   (iv) Counting    (v) Multiplication    (vi) Division, etc

Second:        (d) Printing of worksheets

6. Practical on excel calculation.
7. Graphs:

First period:           (a) Creating Graphs. (i) Line graph   (ii) Histograms  (iii) Pie-charts    (iv) Legends, etc.

Second Period:        (b) Editing graphs

8. Graphs cont.

F & S period: (c) Formatting graphs:  (i) Line graph   (ii) Histograms  (iii) Pie-charts    (iv) Legends

9. Practical on Excel graphs.

 

10. Revision