# How to Use Excel to Teach Math Arrays

Posted by on October 6, 2011

Background: None. This is an intro to MS Excel

Vocabulary: Excel, cell, rows, columns, paint bucket, borders, arrays, resize, formulas

Steps:

• Open Excel. Review the basics–how to identify a cell (where the column and row intersect), what’s on the toolbars, especially where the paint bucket and border tools are found
• Resize the cells so they are square. Here’s how you do that:
• Select the cell at the top left where rows and columns intersect. That will select the entire worksheet.
• Set the row height to 25 pixels by clicking the line between row 1 and 2 and dragging it to a 25 pixel size.
• Set the column width to 25 pixels the same way
• When yo click out of the entire worksheet selection, the cells will resize. It’ll look like graph paper.
• Add name, teacher, ‘problem’ and ‘array as shown

• Add the first problem. I’ll use 3*3

= A5*A6 (Excel automatically calculates the answer for the two digits in A5 and A6)

• Fill in 3 cells over and 3 cells down to create the array.
• Use the border tool–all borders to outline each cell in the array

• Have students do two more of your choice
• Have students create one of their own, to confirm that they understand

Extensions

• Fill in the row with ‘Problem’ and ‘Array’
• Change font size for the headings

from the Structured Learning Technology series for K-5

–Click forÂ 5 bundled Excel lesson plans (for a fee)

Jacqui Murray has been teaching K-8 technology for 15 years. She is the editor/author of over a hundred tech ed resources including a K-8 technology curriculum, K-8 keyboard curriculum, K-8 Digital Citizenship curriculum. She is an adjunct professor in tech ed, CSG Master Teacher, webmaster for four blogs, anAmazon Vine Voice book reviewer, Editorial Review Board member for Journal for Computing Teachers, CAEP reviewer, CSTA presentation reviewer, freelance journalist on tech ed topics, and a weekly contributor to TeachHUB. You can find her resources at Structured Learning.

updated 5-18-16

This site uses Akismet to reduce spam. Learn how your comment data is processed.