Skip to content Skip to navigation Skip to login

Tech Integration Project
Lesson Accelerator: Project Launcher

Average Kid
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 product might look like. The tutorial movies that follow demonstrate, step-by-step, how to construct the "Average Kid" spreadsheet using the sample data provided in the downloadable resource packet. This project can be easily modified or adapted for other subjects where students might wish to find the averages and compare values in recorded sets of data. 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 31716 1:28
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 spreadsheet in Microsoft Excel. We will learn how to add and format column and row labels. Then, we'll record the measurement data that has been collected into the appropriate cells. We will add formulas for calculating the average value for each body measurement, and then we'll add formulas for comparing and counting how many students have a measurement that is greater than or less than the class average. We'll also learn how to print out the data that has been recorded in our spreadsheet.
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Starting a new spreadsheet 31698 0:55
2. locked Saving the spreadsheet 31699 1:16
3. locked Adding column headers & row labels 31700 1:39
4. locked Wrapping text in a cell 31701 1:50
5. locked Viewing the Formatting toolbar 31702 0:38
6. locked Formatting text in cells 31703 2:20
7. locked Adding shading to cells 31704 1:20
8. locked Adding borders or gridlines 31705 0:59
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Adding data 31706 1:01
2. locked Calculating averages 31707 2:09
3. locked Duplicating formulas 31708 0:50
4. locked Adding & formatting additional labels 31709 1:15
5. locked Calculating # > averages 31710 2:28
6. locked Calculating # < averages 31711 2:15
7. locked Copying the formula 31712 0:38
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Saving the completed spreadsheet file 31713 1:10
2. locked Setting the Print Area 31714 1:07
3. locked Printing the spreadsheet 31715 0:57
Tutorial series by Kyle Pace
©2012 Atomic Learning, Inc.   All rights reserved.