Skip to content Skip to navigation Skip to login

Tech Integration Project
Lesson Accelerator: Project Launcher

Media Moments
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 create the spreadsheet and charts using the sample data provided. This project can be easily modified in order to create a spreadsheet and manipulate data relevant to any subject under study. 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 20099 1:37
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 document in Microsoft Excel 2003. The tutorial movies will demonstrate how to set up column and row labels, enter formulas, and enter data into your spreadsheet. We'll also learn how to create and format a 3-D pie chart and a 3-D area chart.
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Entering column and row labels 20100 2:42
2. locked Formatting cell contents 20101 1:30
3. locked Adjusting column widths 20102 1:42
4. locked Entering the daily total formula 20103 3:17
5. locked Entering the total media type formula 20104 1:42
6. locked Saving your spreadsheet 20105 1:00
7. locked Entering the daily media data 20106 2:01
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Creating a 3-D pie chart of total media types 20107 1:44
2. locked Adding category labels to the chart legend 20108 2:07
3. locked Formatting the chart title 20109 1:25
4. locked Labeling the pie with percentages 20110 1:12
5. locked Changing the 3-D view 20111 1:47
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Creating a 3-D area chart from daily data 20112 2:49
2. locked Formatting the category axis 20113 1:27
3. locked Formatting the value axis 20114 2:27
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Changing the color representing a series 20115 2:00
2. locked Changing the size of the plot area 20116 1:20
3. locked Printing your charts and sheets 20117 1:56
Tutorial series by Jody Ouradnik
©2012 Atomic Learning, Inc.   All rights reserved.