Tech Integration Project
Lesson Accelerator: Project Launcher

Charting the Heights

Application:	Excel 2007
Platform:	PC

Description

The process for creating the sample spreadsheet in Microsoft^® Excel 2007 is described below. Each section contains tutorials that demonstrate how to complete a part of this project. The tutorials will take you through adding data to a simple spreadsheet, and entering formulas to determine the median, mean, and mode of a set of numbers. We will also create a 3-dimensional column chart to visually show the relationships between the data points.

The Example Project

The Completed Project movie will show you what the completed example project looks like.

Completed Project Movie

			Key #	Length
1.		What the example project looks like	70949	1:25

Go to: Project Overview (Information for Teachers)

Subscribers have access to download the resource materials for this project, which includes all example files, an assessment rubric, and information about adapting and extending the example project.

Creating Your Own Project

Students will be entering data about how tall each member of a class is into a spreadsheet. Formulas will also be entered to find the median, mean (average), and mode of the data. A column chart will be generated to visually display the relationships between the student heights. Students will have the opportunity to manipulate the data in order to see how the median, mean, and mode changes. A sample data set is provided in the Project Activity Guide that is included in the downloadable resource packet for this project.

A. Spreadsheet Basics

		Key #	Length
1.	Starting your spreadsheet	70934	2:48
2.	Adjusting column widths	70935	1:49
3.	Formatting text	70936	1:09
4.	Entering data into a cell	70937	1:54
5.	Saving your spreadsheet	70938	1:26
6.	Entering formulas	70939	3:05
7.	Using the Function wizard	70940	2:32
8.	Formatting numbers	70941	1:17