Sample Lesson Integrating Spreadsheet

A sample lesson plan to show the integration of spreadsheet without teaching spreadsheets in isolation.

Name of Lesson	Weather and Climate
Author	Anthea Thomas
Grade	Five
Subject	Social Studies
Curriculum / Standards	Students should be able to use the data collected to show the daily temperature both day and night over a seven day period
Materials, measurements, data required	Students recordings of the daily temperature collected before the lesson Four laptops projector
Time required	One hour
Activities and procedures
Prior learning	Students can define and identify the instrument used for measuring temperature .
ICT Skills and resources	Students will using the laptop as well as excel
Learner activity	This activity is student centered and will also be self paced.
Procedure	Step One: Review previous lessons with students through brief questionning. Tell students the aim of the lesson. Let students know that they would be showing the data they have collected on a graph. Illicit students knowledge of how this can be done. Discuss students answers. Let students know that the computer and a specific program will be used to do so. Step Two: Place students into groups of three’s . Each group will have a laptop to use. There will be three persons in each group. Proceed to turn on the laptops. Have students open  Excel Step Three: Using the projector so that the whole class can view, open excel and point students to the meaning and or use of the letters and numbers. Teacher will proceed to outline the headings needed to create the graph.  Teacher will demonstrate and then allow students to do so on the computers that they are using. Each student in the group will take turns putting details into Excel. Teacher will visit each each group to make sure that they are doing the correct thing. The lesson will proceed in a likely manner until all the data have been added and the graph created.
Follow-up activities
Assessment
Student Follow-up	The graphs will be printed and students will answer questions based on the graph that students have created. Questions include Which day had the highest temperature? etc
Dependancies	Since there is only two computers at the school, I will depend on teachers to lend their laptops for the students to use.
After the lesson