Skip to content Skip to navigation Skip to login

Tech Integration Project
Lesson Accelerator: Project Launcher

Fraction Frenzy
Application: Excel 2003
Platform: PC

Description

The process for creating the example spreadsheet using Microsoft® Excel 2003 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 29865 2:13
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 29846 1:53
2. locked Merging cells 29847 1:53
3. locked Creating a title 29848 2:06
4. locked Adjusting cell dimensions 29849 1:45
5. locked Formatting cells 29850 1:51
6. locked Adding the symbols 29851 2:24
7. locked Creating a background 29852 1:04
8. locked Adding the hints 29853 2:49
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Installing the Analysis Tool Pack 29854 1:20
2. locked Entering the fractions 29855 0:47
3. locked Adding the denominator formula 29856 4:02
4. locked Testing the denominator formula 29857 1:19
5. locked Adding the numerator formula 29858 3:47
6. locked Testing the numerator formula 29859 1:25
7. locked Adding the sum formula 29860 3:17
8. locked Testing the sum formula 29861 1:10
9. locked Adding the conditional formatting 29862 2:35
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Protecting your spreadsheet 29863 2:26
2. locked Printing your spreadsheet 29864 1:04
Tutorial series by Gerry Docherty
©2012 Atomic Learning, Inc.   All rights reserved.