Lesson Plan 1

ETC 447 Lesson Plan 1

I.               Rationale

The reason for teaching this lesson is to make sure students understand how to interpret data and create graphs. This lesson matches requirements for second grade math under Arizona’s College and Career Ready Standards.

II.             Overview

a.     Grade level: Second Grade

b.     Subject: Math

c.     Topic of Study: Represent and Interpret Data  

d.     Time Allotment: 30 minutes

e.     Standards: Arizona’s College and Career Ready Standards

·      2.MD.D.10 - Draw a picture graph and a bar graph (with single-unit scale) to represent a data set with up to four categories. Solve simple put-together, take-apart, and compare problems using information presented in a bar graph

f.      Objectives: TSWBAT identify what types of data that is appropriate to create a bar graph. They will then collect their own data and create their own bar graph using Microsoft Word and Excel

III.           Implementation

a.     Procedure:

·      Introduce the word “data” to the student’s vocabulary (1 minute)

·      Have them brainstorm on what they already know about data and what they want to know about data using the KWL chart on Inspiration (3 minutes)

·      Ask the students what type of things would be appropriate to take data on (1 minute)

·      Create an example of a bar graph using the example of how many students and their favorite food on Microsoft Word and Excel (Student’s have already had a lesson on how to use Excel) (8 minutes max)

·      Allow the students to choose what they want to take their data on and have their idea approved by the teacher (2 minutes)

·      Ask students to take out a piece of lined paper and pencil and give them time to collect their data from their peers using 4 different items that fit under their selected topic  (3 minutes)

·      Have the students create their own bar graph using the data they collected from their peers using Microsoft Word and Excel (6 minutes)

·      Students will answer the questions on how to read their graph while talking with a peer and seeing their graph as well (questions will be displayed on the board and students will answer the questions under their graphs on their Word document (4 minutes)

·      The teacher should be roaming the room and observing the students progress and answering any questions

·      The teacher will refer back to the KWL chart and record what the students learned by calling on students randomly (2 minutes)

b.     Technology Integration

·      The teacher will use the KWL chart on Inspiration to record what the students already know and what they want to know at the beginning of the lesson and record what they learned at the end of the lesson

·      The teacher will use Microsoft Word and Excel to show an example of how to create a bar graph using the topic of students favorite type of food

·      The students will use Microsoft Word and Excel to create their own bar graph using the data they collected from their chosen topic that they collected from their peers

·      Each student should have access to their own computer with Microsoft Word and Excel installed on it

c.     Differentiated Integration

·      Cognitive Delay: For students with cognitive delays there will be provided a key guard to prevent the hitting of unwanted keys. They will also be given the opportunity to work on the questions about their graphs with a peer that can assist if needed (working in pairs will benefit the class as a whole

·      Gifted: Students who are gifted will be challenged by being asked to create a bar graph for 8 different items under their selected topic. The questions they are asked about how to read their graphs will be more challenging with higher-level vocabulary words.

·      ELL: Students who are English Language Learners will be given support by being given background knowledge on what “data” is (this will benefit the class as a whole). If necessary the questions students are asked about how to read their graphs will be simplified with language catered to their comprehension level

IV.           Assessment

a.     Procedure

·      The assessment portion will be the student’s ability to successfully create their own bar graph using the data they collected from their peers. This will be able to judge how the students were able to retain information from the lesson and use that information to create their own work.

b.     Instruments

·      Microsoft Word and Excel (The students will open Word from their desktop and be able to access Excel by choosing the bar graph option under the charts section, Excel will open automatically)

V.             Materials and Resources

Inspiration (KWL chart)