Skip to content Skip to navigation Skip to login

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.
expand  Completed Project Movie
Tutorial Number Availability Status Tutorial Title Key # Length
1. preview What the example project looks like 18308 1:14
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.
Tutorial Number Availability Status Tutorial Title 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
Tutorial Number Availability Status Tutorial Title 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
Tutorial Number Availability Status Tutorial Title 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
©2012 Atomic Learning, Inc.   All rights reserved.