Teachers Network
Translate Translate English to Chinese Translate English to French
  Translate English to German Translate English to Italian Translate English to Japan
  Translate English to Korean Russian Translate English to Spanish
Lesson Plan Search
Our Lesson Plans
TeachNet Curriculum Units
Classroom Specials
Popular Teacher Designed Activities
TeachNet NYC Directory of Lesson Plans TeachNet NYC Dirctory of Lesson Plans

VIDEOS FOR TEACHERS
RESOURCES
Teachers Network Leadership Institute
How-To Articles
Videos About Teaching
Effective Teachers Website
Lesson Plans
TeachNet Curriculum Units
Classroom Specials
Teacher Research
For NYC Teachers
For New Teachers
HOW-TO ARTICLES
TEACHER RESEARCH
LINKS

GRANT WINNERS
TeachNet Grant:
Lesson Plans
2010
TeachNet Grant Winners
2009
TeachNet Grant Winners
Adaptor Grant Winners
2008
TeachNet Grant Winners
Adaptor Grant Winners
2007
TeachNet Grant Winners
Adaptor Grant Winners
Other Grant Winners
Power-to-Learn
Math and Science Learning
Ready-Set-Tech
Impact II
Grant Resources
Grant How-To's
Free Resources for Teachers
ABOUT
Our Mission
Funders
   Pacesetters
   Benefactors
   Donors
   Sponsors
   Contributors
   Friends
Press
   Articles
   Press Releases
Awards
   Cine
   Silver Reel
   2002 Educational Publishers Award

Sitemap

TeachNet Disseminator Grant      << Back to all Grant Winners

Data! Data! Graph that Data!

Subject: Math, Technology

Grade Level: 5th grade

Materials: Computers with Internet access and MS Excel software, printer, projector, student worksheets, teacher-created charts, graphs, sample survey, pencils, paper

About: Students learn to formulate survey questions, make predictions, collect data, and use MS Excel to represent their data and report their findings.

For their final project, the students print out their data, graph, survey questions, and predictions.

Data! Data! Graph That Data! introduces students to MS Excel, a valuable spreadsheet program for representing data. The project also enables students to see themselves as mathematicians who collect data and make predictions based on that data.

Teachers should create a sample survey question and graph the results in MS Excel so students can see what the final project should look like. Emphasize that they are mathematicians and should use language such as “My prediction is…” rather than “I think that…”

 Objectives
Students will learn to collect data.
Students will learn to make predictions based on the data collected.
Students will learn spreadsheet program MS Excel to represent their findings.

Websites
If you do not have MS Excel, this free website allows for creating graphs online. Students can then use a word processing program to write their predictions, survey questions, etc.
http://nces.ed.gov/nceskids/createagraph/

Standards
5S.1: Students collect and record data from a variety of sources (newspapers, magazines, polls, charts, and surveys).
5th grade
Math, Statistics, and Probability
5.PS.7: Students represent problem situations verbally, numerically, algebraically, and/or graphically.
5th grade
Math, Problem Solving
MST.5.E: Students use the computer as a tool for generating ideas and drawings.
5th grade
Math, Science, and Technology

Day 1: Creating survey question/answers, and making predictions.
Objectives
Students will create a survey question.
Students will make predictions using statements such as "My prediction is that people are more likely choose answer B" and "My prediction is that people are least likely to choose answer C."
Materials
Teacher-created survey worksheet
Computer with MS Excel
Projector
Pencils
Procedures
The teacher shows the students what the final project students will look like, and uses a computer and projector to show the survey question, data table, prediction, conclusions, and graph.
Students use the survey worksheet to create survey question and answers.
Students make predictions using statements such as "People are more likely choose answer B" and "People are least likely to choose answer C."
Students ask 10 people their survey questions and record the data.
Homework
Assessment
Students are assessed through teacher observation to ensure that they have completed the worksheet.

Day 2: How to use MS Excel
Objectives
Students will learn to input data into MS Excel.
Students will learn to create a graph using MS Excel.
Materials
Teacher-created chart on creating a graph in MS Excel
Computers with Internet access and MS Excel software, projector
Teacher-created chart on MS Excel basics
Student work sheets
Procedures
Show students how to open MS Excel. It is a good idea to have an icon on the desktop so students can double-click on it.
Discuss the Excel screen; use the MS Excel Basics chart to explain rows, columns, and cells in Excel.
Show students how to type their survey question/answers, predictions, and data table in MS Excel.
Show students how to access the chart wizard (refer to MS Excel Creating a Graph chart).
Go through each of the steps of the chart wizard to create a graph.
Show students how to save their work (Click on File-Save-Name your file-Click on Save).
Students use MS Excel to input their data in a table format and generate their graphs.
Homework
Assessment
Students are assessed through teacher observations ensuring that they are entering the information correctly.

Day 3: How to Edit in MS Excel
Objectives
Students will learn how to edit their work in MS Excel.
Students will learn how to add color to their graphs.
Materials
Computers with MS Excel and Internet access, projector
Student work sheets
Procedures
Show students how to open their work in MS Excel (File-Open-Click on file name-Click on Open).
Show students that to edit their work, they click on the cell they typed in and make the corrections in that cell, and then press Enter.
Show students how to add color to their graphs by having them right-click on the parts of the graph they want to add color to, and then click on Format.
Students follow the steps to edit and add color to their graphs.
Homework
Assessment
Students are assessed through teacher observations ensuring that they are editing their work correctly.

Day 4: How to Print in MS Excel
Objectives
Students will learn how to print their work.
Students will learn that what they see on the screen is not what they print.
Materials
Computers with MS Excel and Internet access, projector, printer, paper
Student work sheets
Procedures
Show students how to open their work in MS Excel (File-Open-Click on file name-Click on Open).
Explain to students that what they see on the screen is not what they print.
Show students how to “preview” their work (File-Print Preview).
Explain that Print Preview allows them to see how their work will look when they print it.
Show them how to close the Print Preview window.
Show them how to print their work (File-Print-Click on Print).
Students follow the steps to preview their work and then print.
Homework
Assessment
Student graphs will be assessed using the rubric.

Day 5:
Objectives
Materials
Procedures
Homework
Assessment

Annette Lopez

alopez6@schools.nyc.gov

PS 306
40 West Tremont Ave.
Bronx, NY 10453

Annette Lopez is the Technology Teacher at PS 306. She began teaching through the NYC Teaching Fellows Program after having worked in the computer field for 12 years. At PS 306 she teaches computers to students in grades 1-5. She has developed a technology curriculum that is project-based and integrates literacy, science, and social studies. She is the point person for all technology professional development for teachers at PS 306, making sure they use technology effectively in the classroom.


Important documents for this lesson plan.

Student worksheet.doc
Creating Graphs in MS Excel chart.doc
MS Excel Basics.doc
sample excel.xls
rubric.doc

 

Come across an outdated link?
Please visit The Wayback Machine to find what you are looking for.

 

Journey Back to the Great Before