Tech Integration Project
Lesson Accelerator: Project Launcher

Charting the Heights

Application:	Excel 2004
Platform:	Mac

Description

The process for creating the sample spreadsheet in Microsoft^® Excel 2004 is described below. The Completed Project Movie shows you what the example project might look like. The tutorial movies that follow demonstrate, step-by-step, how to construct the spreadsheet. This project can be easily modified for collecting data and creating charts about other subjects. For a complete project description, including goals, objectives, and materials needed, see the Project Overview.

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	18324	1:00

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

We'll begin by creating a new spreadsheet in Microsoft Excel. The first section will demonstrate how to enter labels, values, and formulas, as well as saving and printing the spreadsheet. In the second section, we'll be creating and formating a column chart, using the data that has been entered in to the spreadsheet. The tutorials in the final section will demonstrate some possible ways to manipulate the data, and how this affects charts which have been created from the data set.

A. Spreadsheet Basics

		Key #	Length
1.	Starting your spreadsheet	18309	1:36
2.	Adjusting column widths	18310	1:23
3.	Formatting text	18311	1:01
4.	Entering data into a cell	18312	1:27
5.	Saving your spreadsheet	18313	0:57
6.	Entering formulas	18314	2:19
7.	Using the function wizard	18315	1:42
8.	Formatting numbers	18316	0:52