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. preview 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.
Key # Length
1. locked Starting your spreadsheet 18293 2:02
2. locked Adjusting column widths 18294 1:40
3. locked Formatting text 18295 1:19
4. locked Entering data into a cell 18296 1:19
5. locked Saving your spreadsheet 18297 1:47
6. locked Entering formulas 18298 1:12
7. locked Using the function wizard 18299 2:58
8. locked Formatting numbers 18300 2:04
Key # Length
1. locked Creating a column chart 18301 1:58
2. locked Changing Chart options 18302 1:39
3. locked Formatting chart text 18303 1:42
4. locked Printing your spreadsheet and chart 18304 1:30
Key # Length
1. locked Copying and pasting cell contents 18305 1:31
2. locked Creating a chart displaying median, mean, and mode 18306 0:47
3. locked Changing data values 18307 1:14
Tutorial series by Jody Ouradnik