Skip to content Skip to navigation Skip to login

Tech Integration Project
Lesson Accelerator: Project Launcher

How Big is a Foot?
Platform: Mac
Application: Excel 2004

Description

The process for creating the example spreadsheet using Microsoft® Excel is described below. The Completed Project Movie shows what the finished product might look like. The tutorial movies that follow demonstrate, step-by-step, how to construct the "How Big is a Foot?" spreadsheet using the sample data provided in the downloadable resource packet. This project can be easily modified or adapted for other projects where recording, comparing, and analyzing data is required. 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.
expand  Completed Project Movie
Tutorial Number Availability Status Tutorial Title Key # Length
1. preview What the example project looks like 30569 1:52
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 workbook in Microsoft Excel. We will learn how to format column and row headers, and how to enter formulas into our spreadsheet. We'll enter data and create a bar graph to compare the data points. Finally, we'll learn how to print our data and chart.

Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Starting a new spreadsheet 30551 0:38
2. locked Adding column headers 30552 1:12
3. locked Wrapping text in a cell 30553 0:58
4. locked Adding names or a class list 30554 0:37
5. locked Enlarging the width of a cell 30555 1:28
6. locked Adding shading & bold text 30556 1:32
7. locked Inserting formulas to perform calculations pt. 1 30557 1:23
8. locked Inserting formulas to perform calculations pt. 2 30558 0:56
9. locked Saving the spreadsheet 30559 1:00
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Opening the spreadsheet 30560 1:04
2. locked Adding data 30561 0:39
3. locked Sorting & comparing results 30562 1:49
4. locked Creating a graph of the measurements 30563 1:37
5. locked Understanding calculations 30564 1:22
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Saving the completed spreadsheet file 30565 1:02
2. locked Setting the Print Area 30566 0:33
3. locked Printing the spreadsheet 30567 0:23
4. locked Printing the graph 30568 0:25
Tutorial series by Jeremy Anderson
©2013 Atomic Learning, Inc.   All rights reserved.