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. preview 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.
Key # Length
1. preview Starting your spreadsheet 70934 2:48
2. preview Adjusting column widths 70935 1:49
3. preview Formatting text 70936 1:09
4. preview Entering data into a cell 70937 1:54
5. preview Saving your spreadsheet 70938 1:26
6. preview Entering formulas 70939 3:05
7. preview Using the Function wizard 70940 2:32
8. preview Formatting numbers 70941 1:17
Key # Length
1. preview Creating a column chart 70942 1:10
2. preview Changing Chart options 70943 2:09
3. preview Formatting chart text 70944 1:46
4. preview Printing your spreadsheet and chart 70945 1:44
Key # Length
1. preview Copying and pasting cell contents 70946 1:44
2. preview Creating a chart displaying median, mean, and mode 70947 0:43
3. preview Changing data values 70948 1:19
Tutorial series by Robert Norgon