Tech Integration Project
Lesson Accelerator: Project Launcher
Memory Game
| Application: | Excel 2007 and Word 2007 |
|---|---|
| Platform: | PC |
Description
The process for creating memory game cards using Microsoft® Excel 2007 and Word 2007 is described below. The Completed Project Movie shows you what the example project might look like. The tutorial movies that follow demonstrate, step-by-step, how to merge the data from a spreadsheet to a word processing document to create the cards. The subject of this project can be easily modified just by changing the data pairs used in the spreadsheet to relate to a current area of study. 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
Completed Project Movie| Key # | Length | |||
|---|---|---|---|---|
| 1. |  |
What the example project looks like | 32611 | 1:22 |
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
This project involves creating a simple data entry form in Microsoft Excel. We will enter geological terms and their matching definitions into our spreadsheet. Then, we'll create a merge template in Microsoft Word using a 2-column label format. In the left column we will enter a merge placeholder for the geological term, and in the right column we will enter a merge placeholder for the definition. Data will be merged from the spreadsheet into our template to create cards that can be used to play a matching game.
| Key # | Length | |||
|---|---|---|---|---|
| 1. | |
Starting a new workbook | 32599 | 0:49 |
| 2. | |
Entering data | 32600 | 1:51 |
| 3. | |
Saving your spreadsheet | 32601 | 0:50 |
| Key # | Length | |||
|---|---|---|---|---|
| 1. | |
Creating the main document | 32602 | 0:42 |
| 2. | |
Choosing the data source | 32603 | 0:44 |
| 3. | |
Adding merge fields to first row labels | 32604 | 0:57 |
| 4. | |
Formatting the term and definition | 32605 | 0:41 |
| 5. | |
Copying the placeholders | 32606 | 0:42 |
| 6. | |
Saving the main document | 32607 | 0:34 |
| Key # | Length | |||
|---|---|---|---|---|
| 1. | |
Formatting the table | 32608 | 1:13 |
| 2. | |
Previewing your cards | 32609 | 0:39 |
| 3. | |
Printing your cards | 32610 | 0:55 |
Generate Direct Linking HTMLBrowse Training
Find an Answer to a Tech Question
What’s in a Tech Integration Project?
Each Lesson Accelerator provides:
- Project activity guide
- Copy of the completed project
- All the resources needed to recreate the example project
- Step-by-step tutorial movies that walk students through the project
- Assessment rubric
These resources come as .zip files.
To access, please log in, then click on the "Click here to download project resources" button.