Lesson Plan Sample for Computer Science JSS2
Subject: Computer Science
Class: JSS 2
Duration: 40 minutes
Date 25th March 2014
Age: 12 years and above
Topic: Electronic Spreadsheet (Microsoft Excel)
Specific objectives: at end of the lesson, the students should be able to do the following:
- Explain what electronic spreadsheet (Microsoft Excel) is
- Discuss the general features of spreadsheets
- How to use the formula in Microsoft Excel
- Discuss functions and recalculation in the Microsoft Excel environment
- Draw the Microsoft Excel environment
Instruction A Materials: Chalk, board, laptop and a chart showing Microsoft excel environment
Instructional Techniques: Observation explanatory discussion, demonstration, question and answers
Entry behavior: The students have learned about the internet in the previous lesson.
Set induction or test entry behavior: Introduction of the topic to the students starting from the know to unknown.
| Content development | Teacher activities | Students activities | Instructional method | |
| 1 | Meaning of electronic spreadsheet | The teacher explains the meaning of spreadsheet thus electronic spreadsheet are simply computer software that allows users to create tables and financial schedules and reports by entering data and formula into cells formed by the intersection of rows and columns on a display screen. | The students listen as the teacher explain the meaning of electronic | Explanatory |
| 2 | The generate features of spreadsheets | The teacher discusses the general features of electronics spreadsheet: thus (1) columns rows and labels: A column is made up of a series of boxes arranged vertically in a workbook. A row consists of a series of boxes arranged horizontally in a workbook. (2) cell, cell address, values: a cell is formed at the intersection of each column row cell address is the references name or identifier for a particular cell. | The students watch the teacher as he demonstrates using a laptop. | Demonstration teacher guided |
| 3 | How to use the formula in Microsoft | The teacher explains how to use formulas in Microsoft Excel: thus formulas are instructions for calculations eg in Ms excel, the formula = Sum (A2: A20)” means “Sum (Add) all the numbers in the cells A2 through A20. | The students watch the teacher as he demonstrates and they participate in the discussion | Demonstration teacher guide |
| 4. | Discuss the functions and recalculation in Ms. excel. | The teacher discusses the function and recalculation in Microsoft excel: thus functions are an inbuilt formula to perform common calculations. For instance, a function can be used to compute the average of a range of numbers or to count the occurrence of any specific entry on the worksheet or workbook. With this recalculation feature, the waste of man-hour trying to re-compute an entire worksheet due to change in one value became a thing of past. | The students participate in the discussion and watch the teacher write an example on the board. | Discussion teachers guided |
| 5. | Draws the Microsoft excel on the chalkboard. | The teacher draws the Microsoft Excel environment on the chalkboard, using the chart showing the Microsoft Excel environment. | The student watch and observe the teacher drawing Ms. excel environment | Observation teacher guided. |
| Summary | The teacher summaries the lesson by revising the lesson from the beginning. | The student contributes to the discussion as the teacher summaries | Discussion teacher guided | |
| Evaluation | Teacher evaluates the students based on the lesson thus what is spreadsheet? What are the features of Ms excel? = Sum (A2: A10)” means what? | The student listen and answer the question | Questioning and answering | |
| Assignment | The teacher copies the assignment on the chalkboard draw a Microsoft Excel environment |
Also Recommended:
Format of a lesson plan for secondary schools in Nigeria
