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
1Meaning of electronic spreadsheetThe 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 electronicExplanatory
2The generate features of spreadsheetsThe 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 environmentObservation teacher guided.
SummaryThe teacher summaries the lesson by revising the lesson from the beginning.The student contributes to the discussion as the teacher summariesDiscussion teacher guided
EvaluationTeacher 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 questionQuestioning and answering
AssignmentThe 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

 



Have a comment or question? Drop it here

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

width 400 alt_text

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