Skip to content Skip to navigation Skip to login

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.
expand  Completed Project Movie
Tutorial Number Availability Status Tutorial Title Key # Length
1. preview 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.
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Starting a new workbook 32599 0:49
2. locked Entering data 32600 1:51
3. locked Saving your spreadsheet 32601 0:50
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Creating the main document 32602 0:42
2. locked Choosing the data source 32603 0:44
3. locked Adding merge fields to first row labels 32604 0:57
4. locked Formatting the term and definition 32605 0:41
5. locked Copying the placeholders 32606 0:42
6. locked Saving the main document 32607 0:34
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Formatting the table 32608 1:13
2. locked Previewing your cards 32609 0:39
3. locked Printing your cards 32610 0:55
Tutorial series by Robert Norgon
©2012 Atomic Learning, Inc.   All rights reserved.