Magic Squares
Create a 4x4 "Magic Square" board with the following properties:
- The cells in the Magic Square and the surrounding "sums squares" are all
"square", at least ½ x ½ .
- The heights of digits in the Magic Square are between 60% and 70% of the height
of the squares. The heights of the digits in the surrounding "sums square" are
between 30% and 40% of the height of the squares.
- The digits in the Magic Square and the surrounding "sums squares" are centered
both vertically and horizontally.
- The row sums appear both left and right. There column sums appear both above
and below. The diagonal sums appear at each end of the diagonals.
- The Magic Square and the "sums squares" have appropriate borders to enhance
visual definition.
- In a merged cell which spans the width of the Magic Square and the "sums
squares" there is a title for the project. In a second merged cell which spans the
width of the Magic Square and the "sums squares" there is subtitle for the project
which identifies the author. In a third merged cell which spans the width of the
Magic Square and the "sums squares" there is date variable which shows the most
recent change in the Magic Square.
- The "sums squares" are color coded (conditionally formatted) to show "red" if the
sum is less than the expected value, "blue" if the sum is exactly the expected
value and "green" if the sum is more than the expected value.
- There is a tally board below the Magic Square which shows how many times each
number in the Magic Square has been used..