Magic Squares in Excel

Magic Squares in Excel
Grade Levels
3rd, 4th, 5th, 6th
Resource Types
Product Rating
4.0
File Type
Excel Spreadsheet File
Be sure that you have an application to open this file type before downloading and/or purchasing.
0.02 MB   |   2 pages

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
Answer Key
Included
Teaching Duration
N/A

Average Ratings

4.0
Overall Quality:
4.0
Accuracy:
4.0
Practicality:
4.0
Thoroughness:
4.0
Creativity:
4.0
Clarity:
4.0
Total:
1 rating
COMMENTS AND RATINGS:
Please log in to post a question.
PRODUCT QUESTIONS AND ANSWERS:
$2.00
Digital Download
ADD ONE TO CART
User Rating: 4.0/4.0
 (19 Followers)
$2.00
Digital Download
ADD ONE TO CART
Magic Squares in Excel