Favorite Butterfly Data Collection

Author: Sharon Peterson  11/08/2004 08:59:00 AM EST		 TaskStream - Advancing Educational Excellence

VITAL INFORMATION
Subject(s):
Elementary, Mathematics, Technology
 
Topic or Unit of Study:
Data Collection, Graphing, Excel
 
Grade/Level:
1
 
Objective:

Students will collect data on the favorite type of butterfly of students in the classroom.

Students will input data into Excel.

Students will create a graph in Excel of the data they have input.
 
Summary:
Students will collect data, input the data in Excel and create a graph.
 
IMPLEMENTATION
Learning Context:

Students have already been collecting data and graphing.  This is the first time they are using Excel.  They will be doing a few other lessons on data collection and inputting it into Excel.
 
Procedure:

Introduction: Show digital story,  Life Cycle of a Butterfly.   Discuss with students what colors of butterflies have they seen. Show display of and discuss the different types of butterflies found in America.

Hand out data collection sheets.  Have students walk around the classroom and find out which type of American butterfly students like the best.

Go to other 1st grade classroom and collect data on their favorite American butterfly.

Hand out disks. Tell students to line up, bringing their data collection sheets and disks.

Take students to the computer lab.

Show students the Icon for Excel and have them click on it.

Explain that the opening page is called a spreadsheet and that each rectangle is called a cell.

Give students instructions on how to create the data collection sheet and input data.

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

Have students save the spreadsheet on their disks.

Have students print out the spreadsheet with the graph.

Go back to the classroom and discuss the results of their data collection.

Have students hand in their spreadsheets.
 
Differentiated Instruction:
The computer lab is set up for students with physical disabilities.  The classroom aid will be available for all students with learning disabilities.
 
Sample Student Products:
Attachments
  1. Student Sample
 
Collaboration:
Students will work individually.
 
Time Allotment:
1 class period. 1 Hr per class.
 
Author's Comments & Reflections:

Make sure and make appointment with other 1st grade class to collect data.
 
MATERIALS AND RESOURCES
Instructional Materials:
Attachments
  1. Data Collection
 
Resources:
  • Materials and resources:
    Life Cycle of Butterfly digital story, display of American butterflies
  • Technology resources:
    Excel
  • The number of computers required is 1 per student.
  • Students Familiarity with Software Tool:
    Students already know how to save items to their disks.
 
STANDARDS & ASSESSMENT
Standards:
MI- Michigan Grade Level Content Expectations
• Subject : MATHEMATICS
• Grade : FIRST GRADE
• Strand : DATA AND PROBABILITY
• Topic : Use pictographs
 Expectation : D.RE.01.01 Collect and organize data to use in pictographs.
 Expectation : D.RE.01.02 Read and interpret pictographs.

USA- ISTE: National Educational Technology Standards for Students: The Next Generation
• Standard : 3. Research and Information Fluency- Students apply digital tools to gather, evaluate, and use information.
 Indicator : Students: b. locate, organize, analyze, evaluate, synthesize, and ethically use information from a variety of sources and media.
 Indicator : Students: d. process data and report results.
 
Assessment/Rubrics:
Rubrics
  1. Favorite Butterfly Data Rubric