Northern York County School District

Technology Integrated Lesson Plan Template

Lesson Title: / Graphing Lifeboats / Grade Level: / 5
Subject Area: / Science- Variables / Time Frame: / 1 week
Teacher Name: / Allyson Lang
Summary: / This is a culminating activity for students to do together after completing the lifeboat portion of the variables unit.
Lesson Plan adapted from:
Connection to District Curriculum: / 3.2.7B
Technology
Competencies: / Basic Computer Operations and Concepts
Multimedia/Presentation Tools
Word Processing
Typing Skills
Objectives: / The students will work together to create a collage of graphs, data sheets, and a summary of their experiments using lifeboats.
Assessment: / There is a rubric to assess students’ final projects.
Prerequisite
Knowledge: / Students will need an understanding of basic computer skills, typing, and excel. Thy will also have to know how to collect data, and use the data they collected in the lifeboats lab to create their projects.
Materials and
Resources: / Hardware / Computers and printers.
Software / Excel and Word
Internet Websites
Other Materials / Printed rubric, lifeboat data, poster board, glue, and scissors.
Procedures: / 1. After students have finished collecting all of their data for the lifeboats experiments, introduce the project. Tell students they will be working in groups to create a poster board presentation with their data.
2. Explain to students they will be making a data table with all of their trials. They will need to list each boat name, capacity (make sure students list the number then a space then ml), every trial, and their final average. Make sure students do not skip spaces, their graphs will not work properly. (See attached for an example.)

3. Students will then be turning their data table into four different charts using chart wizard.

Chart 1- A bar graph showing each boat and the number of penny passengers with each trial
To make this chart highlight the boat names and the trial columns. Drag these columns below the chart then highlight them and click Chart Wizard. Select a bar graph, enter a title, and axes labels. Have students place this in a separate chart- chart one. (See chart one in sample.)

Chart 2- A line graph showing each boat trial and the number of penny passengers.
To make this chart highlight the boat names and the trial columns. Drag these columns below the chart then highlight them and click Chart Wizard. (This is the same data from chart one.) Select a line graph, enter a title, and axes labels. Have students place this in a separate chart- chart two. (See chart two in sample.)

Chart 3- A bar graph showing capacity and the final average.
To make this chart highlight the final average and capacity columns. Drag these columns below the chart then highlight them and click Chart Wizard. Select a bar graph, enter a title, and axes labels. Have students place this in a separate chart- chart three. (See chart three in sample.)

Chart 4- A pie graph showing capacity and final average with the number of passengers labeled.
To make this chart highlight the capacity column and the final average column. (This is the same data as chart 3) Drag these two below the chart then highlight them and click Chart Wizard. Select a pie graph, enter a title, and under data label select show label. Have students place this in a separate chart- chart four. (See chart four in sample.)

4. Students will also need to present their data table, a title for their presentation with each group member’s name clearly represented, and a summary of their findings. Encourage students to use several vocabulary words from this unit.
5. Allow students time to work together to plan their presentation, and write their summary. Help students where needed. Check students’ summaries for clarity and correctness.
6. Allow students to print their graphs and make a collage on poster board.
7. Have each group present their project to the class, and read their summary.
8. Assess with rubric.
Modifications for Differentiated Instruction: / Students are working in groups; make sure each group has a mix of students. Allow gifted students to add to their team’s presentation, and fewer graphs can be requited for lower students.
Other: