Magic Squares in Excel

Magic Squares in Excel
Grade Levels
Product Rating
4.0
1 rating
File Type

Unknown Format

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

18 KB|2 pages
Share
Product Description
This is a technology lesson you can use to create a table using autosum. It is meant for intermediate Excel users.

The first sheet shows you three different magic squares that have already been created. If you click inside of the empty cells in the table, you should see the formula I used in the formula bar. This sheet also has simple directions for students for trying to solve the magic square.

The second sheet shows you one way to complete each magic square correctly.

I would have students start with a blank file (or one with the tables already created but no formulas) and I would step by step help them to create those formulas using autosum. Remember, because there are no numbers on your sheet yet, you will have to help autosum highlight the cells you want it to add.

This lesson typically took students about twenty minutes to create, then another fifteen to work on filling in the magic squares.
Total Pages
2 pages
Answer Key
Included
Teaching Duration
N/A
Report this Resource
Loading...
$2.00
Digital Download
More products from Amber Reinecke
Product Thumbnail
$0.00
Product Thumbnail
$0.00
Product Thumbnail
$0.00
Product Thumbnail
$0.00
Product Thumbnail
$0.00
$2.00
Digital Download
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