Tech Integration Project
Lesson Accelerator: Project Launcher

Charting the Heights

Application:	Excel 2003
Platform:	PC

Description

The process for creating the sample spreadsheet in Microsoft^® Excel 2003 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	18308	1:14

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	18293	2:02
2.	Adjusting column widths	18294	1:40
3.	Formatting text	18295	1:19
4.	Entering data into a cell	18296	1:19
5.	Saving your spreadsheet	18297	1:47
6.	Entering formulas	18298	1:12
7.	Using the function wizard	18299	2:58
8.	Formatting numbers	18300	2:04