Math 5364

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..