Skip to content Skip to navigation Skip to login

Tech Integration Project
Lesson Accelerator: Project Launcher

Geometry Crossword
Platform: PC
Application: Excel 2010

Description

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.

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 95724 1:31
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 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.

Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Starting your crossword 95712 1:50
2. locked Entering more words into the puzzle 95713 0:46
3. locked Formatting the cells 95714 1:34
4. locked Filling in the background 95715 1:15
5. locked Formatting height and width 95716 0:58
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Adding the clues 95717 2:58
2. locked Applying conditional formatting 95718 2:47
3. locked Testing & editing conditional formatting 95719 1:32
4. locked Adding clues to print 95720 2:12
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Setting up the blank template 95721 1:53
2. locked Printing the crossword 95722 0:55
3. locked Working the crossword 95723 2:00
Tutorial series by Robert Norgon
©2013 Atomic Learning, Inc.   All rights reserved.