Format of a lesson plan for secondary schools in Nigeria
LESSON PLAN OF FEDERAL GOVERNMENT GIRLS COLLEGE, EZZAMGBO, EBONYI STATE
Class: JSS 2
Duration: 40 minutes
Date 25th March 2014
Age: 12 years and above
Topic: Electronic Spreadsheet (Microsoft excel)
Specific objectives: at end 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 formular in Microsoft excel
- Discuss functions and recalculation in the Microsoft excel environment
- Draw the Microsoft excel environment
Instruction A Materials: Chalk, board, lap top and a chart showing Microsoft excel environment
Instructional Techniques: Observation explanatory discussion, demonstration, question and answers
Entry behaviour: The students have learnt about internet in the previous lesson.
Set induction or test entry behaviour: 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 explain 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 formular 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 consist of a series of boxes arranged horizontally in a workbook. (2) cell, cell address, values: a cells 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 demonstrate using a lap top.||Demonstration teacher guided|
How to use formular in Microsoft
The teacher explain how to use formulas in Microsoft excel: thus formulas are instructions for calculations eg in Ms excel, the formular = 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 functions and recalculation in Ms. excel.||The teacher discusses the function and recalculation in Microsoft excel: thus functions are in built formular 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 example on the board.||Discussion teachers guided|
|5.||Draws the Microsoft excel on the chalk board.||The teacher draws the Microsoft excel environment on the chalk board, using the chart showing 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 chalk board draw a Microsoft excel environment|
SCHEME OF WORK FOR 7TH WEEK
DATE: 23RD JUNE- 27TH JUNE, 2014
|English language||3||Speech: pronunciation practice (consonant)|
|Mathematics||3||Profit and loss 9calculating profit and loss)|
|Social studies||2||Agricultural technology|
|Cultural and creative art||1||Leaf printing|
|Christian religious knowledge||2||Jesus is with us|
|Home economics||1||Clothing for d/f occasion|
|Agric science||2||Cultural practice for growing vegetables|
|Computer science||1||Connecting parts of a computer|
|Health education||2||Internal organs s parts of the internal organs).|
A LESSON NOTE ON SOCIAL STUDIES
Topic: agricultural technology (traditional agriculture)
Class: Primary 5
Average: Age 9+
Duration: 35 Minutes
Date: 9th July, 2014
Specific Objectives: By the end of this lesson the pupils should be able to:
- Explain the concept of agriculture
- Discuss the advantages and disadvantages of traditional farming
- Practice the traditional ways of farming
Instructional Materials: The teacher will use some traditional agricultural implements. Thus, hoe, digger etc
Entry Behaviour: The teacher ask the pupils questions base on the particular topic he/she want to teach eg how many of you have hoe at home? (ii) Do you know what is called digger?
Set-Induction: The teacher draw or captures the pupils attention by asking then some relative question or felling then story about how our forefathers work in the farm.
Step i: The teacher will introduce the topic by pronouncing it before the children
Step ii: The teacher write the topic on the chalk board thus, agricultural technology (traditional agriculture)
Step iii: The teacher will explain the topic to the pupils.
Step IV: The teacher will write notes for them to copy.
Evaluation: The teacher assess the pupils base on the topic been thought to them by asking them questions thus,
- What is agricultural technology?
- State the advantages of traditional farming
- Mention three problems faced by traditional farmers
Closure: The teacher will close the lesson by picking out the key facts from the topic
Summary: The teacher will summarize the lesson by going through the topic again. The teacher also encourage the pupils to practice more at home.