Fifth graders at Davis Elementary are reviewing addition, subtraction, multiplication, and division (SOL5.4) as well as studying number patterns (SOL5.17). So today students in Mr. Cangelosi’s class created number patterns for their classmates to solve using Google spreadsheets. First I gave them a template to use and shared it using Google classroom. Feel free to make a copy of the template for yourself. There’s a sheet on the template with an example for your reference. We discussed how spreadsheets work and how each cell has a name (like C5). Then we looked at the first formula to see how it was written to create a pattern. The students changed the formula to create their own pattern. Then they dragged the blue square from the cell that had the formula across the other cells in the row to continue the pattern. Next they changed the answer responses in the other formulas to reflect the correct answers and wrote their own feedback words (like, “Way to go!” or “Did you spell it correctly?”). Finally they posted their spreadsheets to Google classroom so their classmates could try to figure out their patterns. You can try to solve some here.
