Excel (PBL) - The Harry Potter Edition

Excel (PBL) - The Harry Potter Edition
Product Rating
1 Rating
File Type

Unknown Format

Be sure that you have an application to open this file type before downloading and/or purchasing.

34 KB|7 pages
Product Description
This is a fun project. In the Excel spreadsheet, there are 5 Harry Potter riddles. Students race to solve the riddles. They can complete the riddles quicker if they use Excel features.

Puzzle 1 - Cryptology
Students must use a key code to determine a quote and a clue that will lead them to Puzzle 2. If students use a vlookup formula they will be quicker than the rest of the class.

Puzzle 2 - Cell Names
Students use the clue from Riddle 1 and find a special cell name to collect Riddle 4.

Riddle 3 - Insert graphic
Students skip Riddle 3 if they read Riddle 2 close enough. If students do Riddle 3 they must insert a special picture into the worksheet.

Riddle 4 - Fill Handle
Students must "write lines" as punishment. Hopefully, they know about the fill handle. They also get the last clue.

Riddle 5 - Conditional Formatting
Students must use conditional formatting to find the one set of duplicate cells that lead to a message. The message must then be relayed to the teacher.

Excel Skills:
vlookup formula
cell names
Inserting graphics
Conditional formatting
Data Validation / Message

Foundation Skills
Research (students must have access to the internet)
Critical Thinking
Problem Solving

The last Friday of every month I have "Race Day" in my classroom. On Race Day students work with a partner and compete to see who can complete the project first - giving a set of partners bragging rights for a month. This is a great project for Race Day.
Total Pages
7 pages
Answer Key
Teaching Duration
90 minutes
Report this Resource
Digital Download

Mindy Carson

More products from Mindy Carson
Product Thumbnail
Product Thumbnail
Product Thumbnail
Product Thumbnail
Product Thumbnail
Teachers Pay Teachers

Teachers Pay Teachers is an online marketplace where teachers buy and sell original educational materials.

Learn More

Keep in Touch!

Sign Up