Students Favroite Seasons

Author: shelley lavara  03/26/2008 11:07:00 AM EDT
TaskStream - Tools of Engagement

VITAL INFORMATION

Elementary, Mathematics, Technology
 
Data Collection, Graphing, Excel
 
2
 
We will collect data as a class on what students favorite seasons are.

Students will input the data into Excel.

Students will create a graph in Excel on our findings.
 
Students will collect data, input the data in Excel and create a graph.
 
IMPLEMENTATION

Students already have been collecting data and graphing. This is the first time they are using Excel. After this lesson, there will be other lessons on data collection and inputting it into Excel.
 
Introduction: Discuss the pro's and con's of each of the four seasons. Then tell the students that we are going to collect data on how many students like each season and then create a graph of the results on Excel.

Write each of the four seasons on the chalkboard and survey students by asking them to raise their hands on who likes what season the best.

Record results under the name of each season and have students write the results down in their notebooks.

Hand out flash drives, tell students to line up with their flash drives and notebooks in hand.

Take students to the computer lab and show them how to open Excel.

Explain what a spreadsheet and cell is.

Instruct students on how to create a graph from the data and input the graph on the spreadsheet.

Have students save their spreadsheets on their flash drives.

Instruct students to print out their graphs.

Go back to the classroom and discuss any questions students have and go over results.

Have students hand in graphs.
 
The computer lab is set up for students with physical disabilities and available for all students with learning disabilities.
 
Attachments
 
Students will work collaboratively & individually.
 
1 class period. 1.5 Hrs per class.
 
This lesson could be expanded by comparing results of students favorite season's results to another second grade's favorite season's results.
 
MATERIALS AND RESOURCES

Attachments
 
  • Technology resources:
    Excel
  • The number of computers required is 1.
  • Students Familiarity with Software Tool:
    Students familiarity with Software Tool: Students already know how to save items to their flash drives.
 
STANDARDS & ASSESSMENT

USA- ISTE: Profiles for Technology Literate Students (includes NETS for Students)
• Grade Grades PreK-2

Numbers in parentheses following each performance indicator refer to the standards category to which the performance is linked. The categories are:
1. Basic operations and concepts
2. Social, ethical, and human issues
3. Technology productivity tools
4. Technology communications tools
5. Technology research tools
6. Technology problem-solving and decision-making tools

Reprinted from National Educational Technology Standards for Students - Connecting Curriculum and Technology, copyright 2000, ISTE (International Society for Technology in Education), 800.336.5191 (U.S. & Canada) or 541.302.3777 (Intl), iste@iste.org, www.iste.org. All rights reserved. For more information about the NETS Project, contact Lajeane Thomas, Director, NETS Project, 318.257.3923, lthomas@latech.edu. Reprint permission does not constitute an endorsement by ISTE or the NETS Project.

 Performance Objective 1Use input devices (e.g., mouse, keyboard, remote control) and output devices (e.g., monitor, printer) to successfully operate computers, VCRs, audiotapes, and other technologies. (1)
 Performance Objective 6Demonstrate positive social and ethical behaviors when using technology. (2)
 Performance Objective 7Practice responsible use of technology systems and software. (2)
 Performance Objective 9Use technology resources (e.g., puzzles, logical thinking programs, writing tools, digital cameras, drawing tools) for problem solving, communication, and illustration of thoughts, ideas, and stories. (3, 4, 5, 6)

MI- Michigan Grade Level Content Expectations
• Subject MATHEMATICS
• Grade SECOND GRADE
• Strand DATA AND PROBABILITY
• Topic Create, interpret, and solve problems involving pictographs
 Expectation D.RE.02.01 Make pictographs using a scale representation, using scales where symbols equal more than one.
 Expectation D.RE.02.02 Read and interpret pictographs with scales, using scale factors of 2 and 3.
 Expectation D.RE.02.03 Solve problems using information in pictographs; include scales such as each represents 2 apples; avoid cases.