Tech Integration Classroom Project
Subject: unknown subject
Application: Excel 2010
The process for creating the example Geometry Crossword using Microsoft® Excel 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 an interactive crossword puzzle using the sample data provided. This project can be easily modified or adapted for any subject under study, by just changing the words and clues that are used in the crossword puzzle. If each student creates a puzzle using a different word list, the class could create a crossword puzzle book. For a complete project description, including goals, objectives, and materials, see the Project Overview.
What's in a Project?
Each project 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
Information for Teachers
This project can be easily modified or adapted for other subject areas or other skill levels.
All example files, an assessment rubric, and information about adapting and extending the example project are included in the resource materials available for download with this project.
Creating Your Own Project
We will begin by creating a new document in Microsoft Excel. We are going to enter some words for geometrical shapes into the cells of our spreadsheet — one letter in each cell. We'll learn how to format the text in the cells and how to add a border and gridlines. We'll learn how to add a comment that will act as a pop-up clue when someone hovers their cursor over a square that will be used for the first letter of a word. We'll also learn how to add "conditional" formatting to the first-letter cells to indicate whether the letter entered is right or wrong. We'll save the puzzle as a template and learn how to print it out, in case someone wants to complete the puzzle on paper, rather than on the computer.