Divisibility Rules and Excel

The 6th Grade Math students used Excel to create formulas that checked the divisibility of numbers from 1 to 200. Using the Formula Builder, they combined several functions including IF, OR, MOD, and ISEVEN to construct the different rules. Later the students used conditional formatting to identify patterns. The lesson took three class periods to complete.