Tech Integration Project
Lesson Accelerator: Project Launcher

If I Had a Million
Application: Excel 2004
Platform: Mac

Description

The process for creating the example spreadsheet using Microsoft® Excel 2004 is described below. The Completed Project Movie shows what the finished project might look like. The tutorial movies that follow demonstrate, step-by-step, how to construct the "If I Had a Million" spreadsheet using the sample data provided. This project can be easily modified or adapted for other projects where tracking limited resources might be useful. For a complete project description, including goals, objectives, and materials, 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 28574 0:45
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 will begin by creating a new document in Microsoft Excel. We will be learning how to enter, modify, and format data in spreadsheet cells. We’ll be creating formulas to solve routine calculations, as well as track diminishing resources. We’ll also learn how to create, modify, and format a pie chart that graphically illustrates where the resources have been used. Finally, we’ll learn how to print our spreadsheet and chart.
Key # Length
1. locked Creating a title 28562 1:12
2. locked Creating column labels 28563 0:34
3. locked Setting category labels 28564 1:14
4. locked Changing column widths 28565 0:33
5. locked Shading category labels 28566 1:13
Key # Length
1. locked Formatting font & size 28567 2:03
2. locked Setting cell alignment 28568 0:41
3. locked Formatting numbers 28569 1:23
Key # Length
1. locked Creating category formulas 28570 2:22
2. locked Creating a total formula 28571 1:14
3. locked Creating a countdown formula 28572 0:52
4. locked Formatting totals 28573 2:22
Key # Length
1. locked Entering items & prices 28575 1:28
2. locked Inserting a row 28576 0:43
Key # Length
1. locked Selecting data 28577 1:07
2. locked Selecting chart types 28578 2:54
3. locked Changing chart fonts 28579 1:19
4. locked Changing chart colors 28580 2:01
5. locked Printing a chart 28581 0:41
Tutorial series by Margie Nisbett