Lesson Plan Sample for Computer Science JSS2

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:

  1. Explain what electronic spreadsheet (Microsoft Excel) is
  2. Discuss the general features of spreadsheets
  3. How to use the formula in Microsoft Excel
  4. Discuss functions and recalculation in the Microsoft Excel environment
  5. 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



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

Effect of lesson plan in teaching of economics on students’ academic performance: A study of secondary schools in Oru East L.G.A of Imo state


error: Content is protected !!
Open chat
WhatsApp Now
We can get that stress off your shoulder.

width 400 alt_text

You can call now on +2347010711012 or +2348060755653 or click below to chat.