Welcome great EduPodian, here is your Second Term JSS3 Computer Science Lesson Note excerpt.
Scheme of Work
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
Week 1:
Revision of First term work… Click here to order the complete Computer Science Lesson Note for JSS3 second term
Week 2:
TOPIC: SPREADSHEET PACKAGES I
Content: – Meaning and Definition of Spreadsheet Package
– USES OF SPREADSHEET PACKAGES
Sub-Topic 1: Meaning and Definition of Spreadsheet Package
A Package can be defined as software written to perform a particular task. Therefore, a Spreadsheet Package is a program that enables the computer user to carry out calculation-related tasks. Spreadsheets are majorly used for organizing and analyzing numeric data. They were designed to replace the pencil, calculator and the writing pad.
It is widely used in diverse range of discipline like Engineering, Mathematics, Science, Accounting,… Click here to order the complete second term Computer Science Lesson Note for JSS3
Week 3:
TOPIC: SPREADSHEET PACKAGES II
CONTENT: – Spreadsheet Features and Terminologies
– Loading and Exiting Spreadsheet Packages
Sub-Topic 1:
Spreadsheet Features and Terminologies
To fully understand and use a spreadsheet package, one must be used to some terminologies. These terminologies include;
Row
Column
Cell
Active Cell
Worksheets
Workbook
Chart
Data Range
Fill handle
Moving border
ROWS:
A Row is a horizontal line of cells which runs from left to right in a worksheet. They can be identified by the numbers at the left hand side of the sheet numbered from 1 to 1,048,576
COLUMNS:
A Column is a vertical line of cells in a worksheet usually identified by letters across the top of the sheet. There are about 16,384 columns in Excel 2007.
CELL:
A Cell is the intersection of a row and a column. The highlighted rectangle on the cell is the cursor but is known as ‘cell pointer’ which enable users to move around the sheet. They can be identified by the combination of column header (e.g ‘A’) and the row header (e.g ‘1’) to give cell A1.
ACTIVE CELL:
The active cell is the cell that… Click here to order the complete Lesson Note on Computer Science JSS3 second term
Week 4:
Get the complete second Term JSS3 Computer Science Lesson Note
Week 5:
Get the complete JSS3 Lesson Note on Computer Science second term
Week 6:
Get the complete JSS3 second term Lesson Note on Computer Science
Week 7:
Get the complete second Term JSS3 Computer Science Lesson Note
Week 8:
Get the complete lesson for JSS3 Computer Science second term
Week 9:
Get the complete second term Lesson Note on Computer Science JSS3
Week 10:
Get the complete second Term JSS3 Computer Science Lesson Note
Comments