Description
JSS3 Computer Studies Scheme of Work for Second Term: This lesson note covers the following topics.
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
Reviews
There are no reviews yet.