Skip to content Skip to navigation Skip to login

Tech Integration Project
Lesson Accelerator: Project Launcher

Fraction Frenzy
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 Fractions Frenzy spreadsheet using the sample data provided in the downloadable resource packet. This project can be easily modified or adapted for other subject or content areas, where the use of a spreadsheet to perform calculations and provide feedback would 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.
expand  Completed Project Movie
Tutorial Number Availability Status Tutorial Title Key # Length
1. preview What the example project looks like 30646 1: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 the project with an introduction to the Excel interface. We will learn how cells are addressed and how to merge and format cells in order to create boxes that will contain our title and the feedback. We will then adjust the dimensions of cells and add a background and comments in the form of suggestions and hints. We will also add an interactive component to the spreadsheet by inserting formulae to provide feedback. Finally we will learn how to protect spreadsheet cells so that they are not inadvertently accessed or changed and to set up the print area in order to print out a copy of the worksheet.
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Opening Excel 30627 2:07
2. locked Merging cells 30628 2:10
3. locked Creating a title 30629 2:15
4. locked Adjusting cell dimensions 30630 1:32
5. locked Formatting cells 30631 2:10
6. locked Adding the symbols 30632 2:35
7. locked Creating a background 30633 1:06
8. locked Adding the hints 30634 2:42
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Installing the Analysis Tool Pack 30635 1:14
2. locked Entering the fractions 30636 0:45
3. locked Adding the denominator formula 30637 3:44
4. locked Testing the denominator formula 30638 1:03
5. locked Adding the numerator formula 30639 3:38
6. locked Testing the numerator formula 30640 1:22
7. locked Adding the sum formula 30641 3:10
8. locked Testing the sum formula 30642 1:06
9. locked Adding the conditional formatting 30643 2:46
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Protecting your spreadsheet 30644 2:37
2. locked Printing your spreadsheet 30645 1:11
Tutorial series by Kyle Pace
©2012 Atomic Learning, Inc.   All rights reserved.