The Divisibility Rules, Seen Through Excel

The 6th Grade Math students made extensive use of the IF statement to create a Divisibility Checker for numbers from 1 to 100. Other functions used in this lesson include ISEVEN, MOD, AND, OR and SUM. Later the students used conditional formatting to show if the number was divisible (green) or not (red), and graphed their results. A few students who finished early, extended the test up to 500.