{"id":3977,"date":"2018-11-08T21:46:41","date_gmt":"2018-11-09T01:46:41","guid":{"rendered":"http:\/\/etechplace.org\/clough\/?p=3977"},"modified":"2019-09-08T17:36:59","modified_gmt":"2019-09-08T21:36:59","slug":"3rd-grade-patterns-and-in-out-boxes","status":"publish","type":"post","link":"https:\/\/etechplace.org\/clough\/?p=3977","title":{"rendered":"3rd Grade Patterns and In-Out Boxes"},"content":{"rendered":"<p><a href=\"http:\/\/etechplace.org\/clough\/?attachment_id=3979\" rel=\"attachment wp-att-3979\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/etechplace.org\/clough\/wp-content\/uploads\/2018\/11\/in-out-300x156.png\" alt=\"\" width=\"300\" height=\"156\" class=\"alignleft size-medium wp-image-3979\" srcset=\"https:\/\/etechplace.org\/clough\/wp-content\/uploads\/2018\/11\/in-out-300x156.png 300w, https:\/\/etechplace.org\/clough\/wp-content\/uploads\/2018\/11\/in-out-1024x531.png 1024w, https:\/\/etechplace.org\/clough\/wp-content\/uploads\/2018\/11\/in-out.png 1168w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a>Third graders at Varina Elementary have been learning how to identify, create, and extend patterns in Math (SOL3.16), so today students in Ms. Lanham&#8217;s class created patterns with Google Sheets. First, I gave the students <a href=\"https:\/\/docs.google.com\/spreadsheets\/u\/1\/d\/1w8n02DExMnaFbr28TcaMOO7NWXXQeAwSYNlMuQVG_JQ\/template\/preview\">a template<\/a> to use that has fewer cells and a larger font size than Google&#8217;s default spreadsheet. Since this was the first time many of them had seen a spreadsheet, I explained that each row in a spreadsheet has a number, each column has a letter, and each cell is labeled with a combination of both (like A2 or C4). This is important to understand when it comes to writing formulas later. The top row usually has the column names, so I showed them how to highlight the row by clicking the number 1 on the left, and we made it all bold by clicking the Bold button in the toolbar. Then we typed the column names: <strong>In<\/strong>, <strong>Out<\/strong>, and <strong>Pattern<\/strong>. In-Out boxes are a great way to get students thinking about patterns because they focus on just two numbers (<em>the number that goes &#8220;In&#8221; the box and the number that comes &#8220;Out&#8221;<\/em>) and infer what happens inside the &#8220;Box.&#8221; The students typed a few random numbers in the first column.  In the second column, they wrote simple formulas such as <em>=A2+5<\/em> or <em>=A3-3<\/em>, and when they pressed &#8220;Enter,&#8221; they saw what came out of the &#8220;Box&#8221; they created. Some people may think spreadsheets are boring, but students get very excited when they see their formulas work. They especially enjoy this next trick to continue the pattern: click on a cell in the second column (one with a formula) and a blue box should appear; click and drag the bottom corner of the blue box across the rest of the row, and it automatically fills with the continued pattern! Finally, I showed the students how they could click the &#8220;Explore&#8221; button in the bottom right corner of the spreadsheet and choose their Formatting colors (<em>or they could highlight rows and columns and make them whatever colors they wanted<\/em>). We shared our spreadsheets on Schoology so their classmates could guess the patterns by typing a reply like, &#8220;Row 3 is +5.&#8221; You can see their spreadsheets <a href=\"https:\/\/docs.google.com\/document\/u\/1\/d\/e\/2PACX-1vRu5tpPvQSRw8GX4fx118Lf0pkWpc4H9-hs0bMAiJMx6aSqvIGQE07Qmf-DJyf6dOYCSiLFXZWNgBuL\/pub\">here<\/a>.   <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Third graders at Varina Elementary have been learning how to identify, create, and extend patterns in Math (SOL3.16), so today students in Ms. Lanham&#8217;s class created patterns with Google Sheets. First, I gave the students a template to use that has fewer cells and a larger font size than Google&#8217;s default spreadsheet. Since this was&#8230; <\/p>\n<div class=\"read-more\"><a href=\"https:\/\/etechplace.org\/clough\/?p=3977\">Read More<\/a><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,11],"tags":[52,74],"class_list":["post-3977","post","type-post","status-publish","format-standard","hentry","category-3rd","category-math","tag-googledocs","tag-spreadsheet"],"_links":{"self":[{"href":"https:\/\/etechplace.org\/clough\/index.php?rest_route=\/wp\/v2\/posts\/3977","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/etechplace.org\/clough\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/etechplace.org\/clough\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/etechplace.org\/clough\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/etechplace.org\/clough\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3977"}],"version-history":[{"count":2,"href":"https:\/\/etechplace.org\/clough\/index.php?rest_route=\/wp\/v2\/posts\/3977\/revisions"}],"predecessor-version":[{"id":3980,"href":"https:\/\/etechplace.org\/clough\/index.php?rest_route=\/wp\/v2\/posts\/3977\/revisions\/3980"}],"wp:attachment":[{"href":"https:\/\/etechplace.org\/clough\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3977"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/etechplace.org\/clough\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3977"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/etechplace.org\/clough\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3977"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}