tag:blogger.com,1999:blog-88184192337963064942024-03-12T23:45:23.816-07:00Teaching Above the TestIdeas on gamification, project based learning and genius hour to encourage students to become lifelong learners in the age of technology.Mariana Garcia Serratohttp://www.blogger.com/profile/08902695384276465117noreply@blogger.comBlogger117125tag:blogger.com,1999:blog-8818419233796306494.post-52271308075922477952021-12-19T14:00:00.002-08:002021-12-19T14:01:51.170-08:00Digital Escape Room Puzzle Ideas<p> I have been a fan of digital escape rooms in the classroom for a couple of years now. I like creating them and consider them a useful tool for review at the end of a unit. They also work very well for me as emergency subplans - students will be engaged and doing something worthwhile and I do not have to worry about setting things up, making copies or really anything else, other than assigning them in Google classroom.</p><p>All of this being said, I'm always on the hunt for puzzle ideas. For starters in order to keep it fresh, I do like to be able to challenge them with puzzles that they have not seen before. While they are always different because of content, there are only so many times that you can present a maze, clock or 4 x 4 grid.:</p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjl5TSzCL7uqNknbVwtyilTUQCyhqWt_oGPqImG6xLPkm7DA5eMBm9WsmADo8FGlEpd9qGVgQEVKvRnMnEdlMeOQEQ9XVGYAWdWANvm7W_h0QO5AH15hIFM553kcGtJgbi4IGt4phnkUrA/" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img alt="" data-original-height="776" data-original-width="1380" height="106" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjl5TSzCL7uqNknbVwtyilTUQCyhqWt_oGPqImG6xLPkm7DA5eMBm9WsmADo8FGlEpd9qGVgQEVKvRnMnEdlMeOQEQ9XVGYAWdWANvm7W_h0QO5AH15hIFM553kcGtJgbi4IGt4phnkUrA/w189-h106/image.png" width="189" /></a></div><p></p><p><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZd8-uSSHC-rC73N8zaPshB_iHRePxgm3q42Z02F6TtKwxBGjdpOtipftEceB8YvGBaGWNxBTxZ8aA6ZaWGW5ucbyPNus1S4c-mVoDany9oGUQAlyCvOX0NbfVyXHflxhTa4wcFn0-dQ0/" style="clear: left; display: inline; margin-bottom: 1em; margin-right: 1em; text-align: center;"><img alt="" data-original-height="751" data-original-width="1377" height="109" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZd8-uSSHC-rC73N8zaPshB_iHRePxgm3q42Z02F6TtKwxBGjdpOtipftEceB8YvGBaGWNxBTxZ8aA6ZaWGW5ucbyPNus1S4c-mVoDany9oGUQAlyCvOX0NbfVyXHflxhTa4wcFn0-dQ0/w197-h109/image.png" width="197" /></a> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9vBhKx1V6VN7k-f5iay4ohBMp9ms3F7FOvjY2x8xUpcxlg8hMTHWNNLrMcxlL2f3RdfMOeOkWGewEM-cmNQVJ4bp05Vj5xn_83gcJ1L5SmaNozk21uQcsWrF76GBgMww0jkxLSYK2Ip8/" style="clear: left; display: inline; margin-bottom: 1em; margin-right: 1em; text-align: center;"><img alt="" data-original-height="753" data-original-width="1373" height="107" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9vBhKx1V6VN7k-f5iay4ohBMp9ms3F7FOvjY2x8xUpcxlg8hMTHWNNLrMcxlL2f3RdfMOeOkWGewEM-cmNQVJ4bp05Vj5xn_83gcJ1L5SmaNozk21uQcsWrF76GBgMww0jkxLSYK2Ip8/w195-h107/image.png" width="195" /></a></p><p><br /></p><p>On the other, some of my students have figured out that if a code is only four letters and those letters repeat in a "clue item" they can pretty much spend their time guessing. In order to eliminate that, I do like to use substitution cyphers which do present a bit more of a challenge:</p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEil_FClzxjOQHHF5V9n71fJ4_lTQCVMypeYjWgfwdEfTfr4AJTTPAzAahIyOvq7ML4BdHSzUEPjAkaY2x69HFjObZA3P2THEvz5Og5sKemTnyOM7PQlmU6TkUNlm4uQqGaROePWJWHbuw0/" style="clear: left; display: inline; float: left; margin-bottom: 1em; margin-right: 1em;"><img alt="" data-original-height="775" data-original-width="1377" height="112" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEil_FClzxjOQHHF5V9n71fJ4_lTQCVMypeYjWgfwdEfTfr4AJTTPAzAahIyOvq7ML4BdHSzUEPjAkaY2x69HFjObZA3P2THEvz5Og5sKemTnyOM7PQlmU6TkUNlm4uQqGaROePWJWHbuw0/w198-h112/image.png" width="198" /> </a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgF93EOLa6kujCrHmG5i5wx_tEyMU58QIl0m2CoF7Mu5kbaXY46xJ3zVidJwq0v5UKIhcVe0XB8rUmDOpbxxg2lERXVTbV88S4JDp7TjjSeZtLP8dMI-d_ZTkKHKtv7-apdc6AvQRgU6zE/" style="clear: left; display: inline; margin-bottom: 1em; margin-right: 1em;"><img alt="" data-original-height="780" data-original-width="1382" height="106" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgF93EOLa6kujCrHmG5i5wx_tEyMU58QIl0m2CoF7Mu5kbaXY46xJ3zVidJwq0v5UKIhcVe0XB8rUmDOpbxxg2lERXVTbV88S4JDp7TjjSeZtLP8dMI-d_ZTkKHKtv7-apdc6AvQRgU6zE/w188-h106/image.png" width="188" /></a> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhyKPKQdo0Ycv9u8gSVRnaFyrCnRp8qm-dsnlcbPuxnpOMtRBOeqVMjb3QA-CPgmmQtfjH4D9K8Vy_nFGh9NTpM99XYDWvewPfqkKcJUmT_I8sLDF83E5E2hQtALQMvhOGDFjIJshNpwk/" style="clear: left; display: inline; margin-bottom: 1em; margin-right: 1em;"><img alt="" data-original-height="784" data-original-width="1395" height="110" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhyKPKQdo0Ycv9u8gSVRnaFyrCnRp8qm-dsnlcbPuxnpOMtRBOeqVMjb3QA-CPgmmQtfjH4D9K8Vy_nFGh9NTpM99XYDWvewPfqkKcJUmT_I8sLDF83E5E2hQtALQMvhOGDFjIJshNpwk/w196-h110/image.png" width="196" /> </a><div class="separator" style="clear: both; text-align: center;"><br /></div><div style="text-align: left;">But again, these end up being overused in many escape rooms. If you are looking for some ways to create that your students may have not seen and/or that present a bit more of a challenge, I suggest:</div><div style="text-align: left;"><br /></div><div style="text-align: left;"><a href="https://www.festisite.com/rebus/">Rebus Generator</a> - This site generates a combination of emojis and letters for you that you can just screenshot and paste into a slide show. You just type your phrase and done. The one below, for example, says "Escape rooms are cool.":</div><div style="text-align: left;"><br /></div><div style="text-align: left;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEju0icKyiIO3_OjQwGQAwMdy58KnTydnNX8CLw5NLg_2SDiZXEV7X8fcS8t-nlQql85B_52Cj0JAkqPW9h9Pyk-OsxifmK9BmmfPWkqLKVGC91G3VOJqhyphenhypheniwXQ5k11ZDsKeb6RBtRsq-Rc/" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="222" data-original-width="1066" height="101" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEju0icKyiIO3_OjQwGQAwMdy58KnTydnNX8CLw5NLg_2SDiZXEV7X8fcS8t-nlQql85B_52Cj0JAkqPW9h9Pyk-OsxifmK9BmmfPWkqLKVGC91G3VOJqhyphenhypheniwXQ5k11ZDsKeb6RBtRsq-Rc/w486-h101/image.png" width="486" /></a></div><div style="text-align: left;"><br /></div><div style="text-align: left;">On the same site as the Rebus above, there is also a maze creator that allows you to type a phrase and create a maze with it. That can be used to pose a question or give a clue to students.</div><div style="text-align: left;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgM-DRVk6LwiP2XJs_B1pNmt2fz0Xt1BgCPKacEBpQLa4wf3TgayCbp4kbAPU_dWsswIvyFzuXSCtN-rQxsdcOsRMYkRVKPU0f0Xp03GzegSNkpp0gpTPsKhNKIFTveHILm3Zpw8J1fyjw/" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="422" data-original-width="459" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgM-DRVk6LwiP2XJs_B1pNmt2fz0Xt1BgCPKacEBpQLa4wf3TgayCbp4kbAPU_dWsswIvyFzuXSCtN-rQxsdcOsRMYkRVKPU0f0Xp03GzegSNkpp0gpTPsKhNKIFTveHILm3Zpw8J1fyjw/" width="261" /></a></div><br /><br /></div><div style="text-align: left;"><br /></div><a href="https://docs.google.com/spreadsheets/d/13VnNwrQ9-45mT0ERBc5EW_kFsdOGPBuAQqezguR5HYU/edit?usp=sharing">Vigenere Squares</a> - I got this spreadsheet template from <a href="https://lockpaperscissors.co/ciphers-playbook">lockpaperscissors</a>. I love it because it is a spreadsheet template so modifications are easy and are always in my drive.</div><div style="text-align: left;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhf_-XSnR_98-RhuCmvJ8bkcKBWAweDFsw2ePkbSr7tJyFYelaFK8jj-abluaz82oXjeOC4TLaVIQPhas_AZDfJsqQuFbZiAGhwc2Vag_DNOSMtfN7EYYXeC-G97VkmpqgYRZkNla4vRps/" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="750" data-original-width="1277" height="188" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhf_-XSnR_98-RhuCmvJ8bkcKBWAweDFsw2ePkbSr7tJyFYelaFK8jj-abluaz82oXjeOC4TLaVIQPhas_AZDfJsqQuFbZiAGhwc2Vag_DNOSMtfN7EYYXeC-G97VkmpqgYRZkNla4vRps/" width="320" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;"><a href="https://cryptii.com/">Online encoders</a>: For encoding in a variety of ways, like morse code, I like <a href="http://Cryptii.com">Cryptii.com</a> because I do not have to worry about creating an account or bother with adds. </div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: left;"><a href="https://learningapps.org/">Learningapps</a>: While this site is intended to create minigames, I often use it in my escape rooms since you can create an activity within it, and use what they call "Feedback" to provide an encoded message. For example, in this very simple camouflage or mimicry sort, the kids receive a message "encoded" with Cryptii in Morse Code.</div></div><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhyKPKQdo0Ycv9u8gSVRnaFyrCnRp8qm-dsnlcbPuxnpOMtRBOeqVMjb3QA-CPgmmQtfjH4D9K8Vy_nFGh9NTpM99XYDWvewPfqkKcJUmT_I8sLDF83E5E2hQtALQMvhOGDFjIJshNpwk/" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><br /><br /></a></div><p style="text-align: center;">
<iframe allowfullscreen="true" mozallowfullscreen="true" src="https://learningapps.org/watch?v=pdgzb3s8a21" style="border: 0px; height: 500px; width: 100%;" webkitallowfullscreen="true"></iframe>
</p><p>Another example is this crossword whose answers reveal a scrambled word that should then be unscrambled and used as a code.</p>
<div style="text-align: center;"><iframe allowfullscreen="true" mozallowfullscreen="true" src="https://learningapps.org/watch?v=pbt281ixj20" style="border: 0px; height: 500px; width: 100%;" webkitallowfullscreen="true"></iframe></div><p>What other ideas do you have for your digital escape rooms? I'd love to hear about them :)</p>Mariana Garcia Serratohttp://www.blogger.com/profile/08902695384276465117noreply@blogger.com0tag:blogger.com,1999:blog-8818419233796306494.post-53837263615636936262021-07-21T09:34:00.006-07:002022-07-21T16:13:02.075-07:00Get to know your students with a Cellfie<p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://docs.google.com/presentation/d/1qhEK3rhjFvE4GUs6aslDxqAscva3JbSGgzNhJqKM9aA/copy" style="margin-left: 1em; margin-right: 1em;" target="_blank"><img alt="" data-original-height="610" data-original-width="1340" height="279" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDb0SVCCp2CNEOXOc_S9K4UTs6MrjLrsd8nt9GIc7DosAGolkejwhudH7H-LDZMWZPr4btSdpqh2cUau3JMVdy73LB3-oRL-Lbf6aTCmU_HTFmOK8kWBLRN4ESxUVaOi8oahsVi3hUm-s/w612-h279/image.png" width="612" /></a></div><br /><br /><p></p><p><br /></p><p>The 2021-2022 school year is about to start. As I started to think about what I could have students do to introduce themselves and came across an idea posted by Ms. McCurdy on a Facebook group I belong to. She posed the question:</p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSUxn8ueJVKuYgwjYzF9P1L0q8251Pxnj_uM1L5XIm5LvEQtNV69pKf-dmoHzwGBwPGRYpqCqPN_FxIdZ-Lqgjt57U_rIYj1ILqZplRunANRoz1lPwHUsCMXKLWGTsUJesOV7hFcksvL0/" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="627" data-original-width="629" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSUxn8ueJVKuYgwjYzF9P1L0q8251Pxnj_uM1L5XIm5LvEQtNV69pKf-dmoHzwGBwPGRYpqCqPN_FxIdZ-Lqgjt57U_rIYj1ILqZplRunANRoz1lPwHUsCMXKLWGTsUJesOV7hFcksvL0/" width="241" /></a></div><br />That immediately brought to mind the <a href="https://docs.google.com/presentation/d/14Qx2oLND_kyF_AiqsiyceAl4b4X9W7WmP8fqa-M-n6I/copy" target="_blank">plant and animal cell diagrams</a> I drew a while back. After a bit of trial and error to make things fit and teasing out what each organelle could represent I came up with this activity where students can add text and use the paint bucket to color in the organelles.<p></p><p></p><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://docs.google.com/presentation/d/1qhEK3rhjFvE4GUs6aslDxqAscva3JbSGgzNhJqKM9aA/copy" style="margin-left: 1em; margin-right: 1em;" target="_blank"><img alt="" data-original-height="611" data-original-width="1346" height="268" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEinASvHwex-RXLrr8gTpiAd7ALpTcMEfpPIkj4pJHi7nXoMO7u28dVH-mxfQr1M6RP-z4nkPBu1ZGD4I4dimz91Ty9XGToT_vZh-mScm_d_cCC8JVKliIABZgbU8I-9LnXE2R0YOBGC0io/w590-h268/image.png" width="590" /></a></div><a href="https://www.teacherspayteachers.com/Product/Cellfie-Back-to-School-Print-and-Digital-8315833" target="_blank">Click here to get your own copy</a> (this is a TPT link)<br /><br /></div><div class="separator" style="clear: both; text-align: center;">Feel free to share with your colleagues.</div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><br /></div><br /><br /><p></p>Mrs.Garciahttp://www.blogger.com/profile/16492613229969352064noreply@blogger.com0tag:blogger.com,1999:blog-8818419233796306494.post-39996760677022616462020-07-28T18:08:00.000-07:002020-07-28T18:08:13.521-07:00Periodic Table Pixel Art - A Digital Activity<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj2N4tcwe581tlDVXbg0SZgsJ-VYPeaoEIwqJX7-RH1Tq7sBHi_IDXOHTCyy54FCdI1cOprGk4tV6gp_rzH17kj0Xcfc0ML4sAeXt1G98lr4gLJlA4f7Y0iYoZH36tHrnmcr_9C8M4B5zc/s1600/periodic1.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="245" data-original-width="530" height="294" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj2N4tcwe581tlDVXbg0SZgsJ-VYPeaoEIwqJX7-RH1Tq7sBHi_IDXOHTCyy54FCdI1cOprGk4tV6gp_rzH17kj0Xcfc0ML4sAeXt1G98lr4gLJlA4f7Y0iYoZH36tHrnmcr_9C8M4B5zc/s640/periodic1.PNG" width="640" /></a></div>
<div style="text-align: center;">
<br /></div>
<br />
A couple of years ago I created a <a href="https://www.teacherspayteachers.com/Product/Periodic-Table-Pixel-Art-4882128" target="_blank">periodic table pixel art activity</a> inspired by a <a href="https://www.middleschoolchemistry.com/lessonplans/chapter4/lesson2" target="_blank">card sort activity published by the ACS</a>. This morning Ms. Widrig shared a really cool mystery picture activity within the Facebook Group Digital INBs and Binders, an amazing group of educators that have come together to share ideas, lessons, and activities in preparation for the digital re-opening of schools in 2020. Mashing what I had with her example, I transformed 5 of my original sets of 30+ clues into a digital activity.<br />
<br />
In the interest of sharing forward, here is a link to a force copy of the complete set for you to download/use/adapt for use in your own classrooms. The complete activity is self-checking (including capitalization), making it a good activity for assessment or review.<br />
<br />
<h3 style="text-align: center;">
<a href="https://docs.google.com/spreadsheets/d/1425zGshSdERtqmH64lzr3C19IbRw4GFELf-9sJtu9MU/copy" target="_blank">Digital Periodic Table Pixel Art File</a></h3>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://docs.google.com/spreadsheets/d/1425zGshSdERtqmH64lzr3C19IbRw4GFELf-9sJtu9MU/copy" target="_blank"><img border="0" data-original-height="642" data-original-width="1298" height="315" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisJd0P_b0nfZMYa9K8HCsvDYdJJJVPzD59vvRMW70WAAfY5Vwjg4gtINZXULj9hklWMyWOKdnBkiRTklKgu-h2eKdtO_k86nIl8Pp1GZCj4ZFKUOdq01tuLPaH_Pu3b6XOiHeftm4eRS4/s640/periodic1.PNG" width="640" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
Mrs.Garciahttp://www.blogger.com/profile/16492613229969352064noreply@blogger.com0tag:blogger.com,1999:blog-8818419233796306494.post-76009188267525560022020-07-26T14:33:00.002-07:002020-07-26T14:33:25.099-07:00Cross Cutting Concepts Graphic Organizers for Digital Notebooks<div class="separator" style="clear: both; text-align: center;">
<a href="https://docs.google.com/presentation/d/1kyDEkE3T_MMzE2Xd7QoY-QTqQbsGWN8t8cgUsHPCXXw/copy" target="_blank"><img border="0" data-original-height="641" data-original-width="484" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdONxiC9UyEJDGL7IN14KiAvhNyIphn0rUcQGgo2JjjlmzZ_Ee1BZdVUgdEraBf4EvTRF4FaDn9ZEA3qefIfe5M875rSPC7yWCHnyCue2v_-8UTNQ0Cd1kqN890XECGFJwweBlTEaYJnM/s320/blog.PNG" width="241" /></a></div>
<br />
<br />
For a while now I've been working with the NGSS's cross-cutting concepts, inviting my students to <a href="http://www.teachingabovethetest.com/2015/10/my-students-are-taking-ownership-of.html" target="_blank">take ownership of them</a>. As part of this process, I have often used graphic organizers to help my students process and make connections between big ideas. This year, as we move completely away from paper, and into the world of digital notebooks, I knew that I would need to transform all of the organizers and prompts I've collected over the years into digital versions so my students could add to them into their digital notebooks. I am finally done, and as always I am sharing them with any teacher that needs them.<br />
<br />
In order to create your own copy of the slide deck where the organizers are found, <a href="https://docs.google.com/presentation/d/1kyDEkE3T_MMzE2Xd7QoY-QTqQbsGWN8t8cgUsHPCXXw/copy" target="_blank">click here</a>.<br />
<br />
It is important to mention that the organizers have no instructions other than textholders stating "type here".<br />
<br />
<iframe allowfullscreen="true" frameborder="0" height="841" mozallowfullscreen="true" src="https://docs.google.com/presentation/d/e/2PACX-1vRjANntK6-19lQT1uWTNW5zsibNCf-hWi6OQXJ-4CE_WNOMOLE4uRRFqOJfLQxko0yPwsYLO6r6i8Cr/embed?start=false&loop=false&delayms=3000" webkitallowfullscreen="true" width="612"></iframe>
<br />
These slides are intended not as a stand-alone digital notebook, but rather as masters that can be added to your existing notebooks. If you are unsure about how to add them to your own teacher digital notebook, you may wish to watch <a href="https://www.youtube.com/watch?v=lWjHJcyrAHs" target="_blank">this video.</a><br />
<br />Mrs.Garciahttp://www.blogger.com/profile/16492613229969352064noreply@blogger.com1tag:blogger.com,1999:blog-8818419233796306494.post-82637683375746573252020-07-15T11:56:00.000-07:002020-07-15T11:56:12.830-07:00Digital Interactive NotebooksOver the last month, and with the uncertainty of how we will re-open, I decided to make a move to digital notebooks using Google slides. Taking inspiration from Matt Miller's <a href="https://ditchthattextbook.com/google-slides-interactive-notebooks-20-activities-to-fill-them/" target="_blank">Google Slides Interactive Notebooks</a>, as well as the thousands of teachers that came before me and graciously published templates (<a href="https://slidesmania.com/" target="_blank">SlidesMania</a> comes to mind) and YouTube videos, I came up with about 20 that I plan to use. As you know, I am all about sharing so I am publishing them all here for you to peruse and make copies if you wish.<br />
<br />
<br />
<div>
<a data-pin-board-width="600" data-pin-do="embedBoard" data-pin-scale-height="480" data-pin-scale-width="160" href="https://www.pinterest.com/mariana680106/interactive-digital-notebooks/5th-grade/"></a>
</div>
<div>
<a data-pin-board-width="600" data-pin-do="embedBoard" data-pin-scale-height="480" data-pin-scale-width="160" href="https://www.pinterest.com/mariana680106/interactive-digital-notebooks/6th-grade/"></a>
</div>
<div>
<a data-pin-board-width="600" data-pin-do="embedBoard" data-pin-scale-height="480" data-pin-scale-width="160" href="https://www.pinterest.com/mariana680106/interactive-digital-notebooks/7th-grade/"></a>
</div>
<div>
<a data-pin-board-width="600" data-pin-do="embedBoard" data-pin-scale-height="480" data-pin-scale-width="160" href="https://www.pinterest.com/mariana680106/interactive-digital-notebooks/8th-grade/"></a>
<script async="" defer="" src="//assets.pinterest.com/js/pinit.js"></script>
</div>
Mrs.Garciahttp://www.blogger.com/profile/16492613229969352064noreply@blogger.com0tag:blogger.com,1999:blog-8818419233796306494.post-73500554863537761772020-05-11T09:10:00.000-07:002020-05-11T09:19:55.424-07:00Interactive Padlet Activity for Google Meets/Zoom<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPksJ0l0lG4dXisZAXQ-p3QFDmg-RCow9Kdh_G0kNQDuoLv7WdbuO7M6t8XPyh7TcYvouHuoLWplMTyBdxL3ipGP4g-0BlIecN2_bQJluhdfhEvsF5krFwoh00PxEErjk1cMT1ZNaHgeg/s1600/pic.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="834" data-original-width="1403" height="380" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPksJ0l0lG4dXisZAXQ-p3QFDmg-RCow9Kdh_G0kNQDuoLv7WdbuO7M6t8XPyh7TcYvouHuoLWplMTyBdxL3ipGP4g-0BlIecN2_bQJluhdfhEvsF5krFwoh00PxEErjk1cMT1ZNaHgeg/s640/pic.jpg" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
Like many of you, I've been trying to figure out how to make my Google Meets interactive and fun. We've done digital breakouts, Kahoot, Quizziz, Legends of Learning, scavenger hunts, and the like, but most of these have still lacked the conversation piece that I crave. Half the time it feels like I'm sitting in front of a one-way conversation, and while there are some conversations in the chat, I am mostly holding a soliloquy while students are working through those activities.<br />
<br />
This week I am going to try something a little different, and am excited about the possibilities. Taking inspiration from <a href="https://www.nasa.gov/multimedia/imagegallery/iotd.html" target="_blank">NASA's Image of the day</a> and the Change My Mind meme that keeps popping up in several of my Social Media feeds, I created the column Padlet where I placed three images and ask the students to respond to each without naming the content of the image. The way I envision this is that students will be able to do a reverse image search, find out what the picture is showing and open up an article/webpage with some information that they can read and share as a comment. The "Change My Mind" column is an addition that I envision working much the same way, where students can do a quick search on the topic (or use their background knowledge) and write a sentence or two backed up with facts/graphs to support their claim.<br />
<br />
If you are interested in doing something like this, good places to search for those images to share with students include:<br />
<br />
<a href="https://earthobservatory.nasa.gov/topic/image-of-the-day" target="_blank">Earth Observatory Image of the Day</a><br />
<a href="https://www.nasa.gov/multimedia/imagegallery/iotd.html" target="_blank">NASA's Image of the day</a><br />
<a href="https://www.nytimes.com/column/learning-whats-going-on-in-this-picture" target="_blank">What's going on in this Picture - New Your Times</a><br />
Electron Microscope Photography - <a href="https://twistedsifter.com/2011/08/electron-microscope-photography/" target="_blank">Twisted Sifter</a> and <a href="https://www.gettyimages.com/photos/scanning-electron-microscope?mediatype=photography&phrase=scanning%20electron%20microscope&sort=mostpopular" target="_blank">Getty Images</a><br />
<a href="https://www.smithsonianmag.com/photocontest/photo-of-the-day/" target="_blank">Smithsonian Magazine Photo of the Day</a><br />
<br />
Let me know what you think. What other interactive activities are you doing during your GoogleMeets/Zoom calls?<br />
<br />Mrs.Garciahttp://www.blogger.com/profile/16492613229969352064noreply@blogger.com0tag:blogger.com,1999:blog-8818419233796306494.post-21578345336548508782020-04-24T09:17:00.000-07:002020-04-24T09:17:02.756-07:00Reporting "completion" grades - use IF statements<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOr7Pybz0v4TzkiFsTj5uqU3aBKHE5Mt9sr3znoVAjUSGPbOOUJqc-WUPnxEP8VScf-iWNiZBA5NEAVD8IGKi1ez9tTDE1sI1XQxsEap_81n7XiKUuXfdNrfeSmTk3DR9cZjSHyUpun04/s1600/c-nc.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="404" data-original-width="1080" height="239" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOr7Pybz0v4TzkiFsTj5uqU3aBKHE5Mt9sr3znoVAjUSGPbOOUJqc-WUPnxEP8VScf-iWNiZBA5NEAVD8IGKi1ez9tTDE1sI1XQxsEap_81n7XiKUuXfdNrfeSmTk3DR9cZjSHyUpun04/s640/c-nc.JPG" width="640" /></a></div>
<br />
Much like other districts around the U.S., mine has opted to forgo grades and simply report work as completed/not completed during this time of emergency remote learning. While I agree with this practice for now, it dawned on me that I would be looking at papers or digital submissions twice as many times as before since. Not only do I need to read and provide feedback to students (oftentimes grading it still), I also need to contemplate whether a submission counts as completed or not. I am not averse to doing the former, but the idea of then manually"transforming" that into complete/not complete in order to report it in my LMS, especially when students are all working at different paces, is a real pain. Trying to ease that pain I started thinking of all those skills I've gained from my gamified leaderboards and came up with a relatively easy workflow that for all intents and purposes semi-automates the process.<br />
<br />
It all starts with reporting all feedback grading uniformly. I am using Google classroom as my feedback grade book for students, whether manually grading there or importing into it the feedback grading from GoFormative, EdPuzzle, etc., the trick is to make everything worth the same number of points. Once you are ready to report the C/NC grades you will need to download the complete grade book you want to transform as a CSV. In Google classroom, this means going into any of your assignments and clicking on the cog you see on the top right.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgx81jnvIUUkRKxqQ8VvMR3hg68E5Ga7K1IzFs49Dc2PJi-4pnO9tAESTPmMYJIwZt77nRTUbfJdOXLnsPxBFthIkFp2U3SGtgYgTvgi0JPcbWt2vXlvzN_N8oNhCd1xYvDKjHn6u3UP1w/s1600/pic1.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="273" data-original-width="955" height="182" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgx81jnvIUUkRKxqQ8VvMR3hg68E5Ga7K1IzFs49Dc2PJi-4pnO9tAESTPmMYJIwZt77nRTUbfJdOXLnsPxBFthIkFp2U3SGtgYgTvgi0JPcbWt2vXlvzN_N8oNhCd1xYvDKjHn6u3UP1w/s640/pic1.JPG" width="640" /></a></div>
<br />
Once you have your grade spreadsheet, it is simply a matter of adding an IF statement that references the cell you'd like to change into C/NC. The formula is<br />
<br />
<span style="font-size: large;"><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; white-space: pre-wrap;">=</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; white-space: pre-wrap;">IF</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; white-space: pre-wrap;">(</span><span dir="auto" style="background-color: white; color: #f7981d; font-family: Inconsolata, monospace, arial, sans, sans-serif; white-space: pre-wrap;">E6</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; white-space: pre-wrap;">></span><span class="number" dir="auto" style="background-color: white; color: #1155cc; font-family: Inconsolata, monospace, arial, sans, sans-serif; white-space: pre-wrap;">6</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; white-space: pre-wrap;">,</span><span class=" string " dir="auto" style="background-color: white; color: green; font-family: Inconsolata, monospace, arial, sans, sans-serif; white-space: pre-wrap;">"C"</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; white-space: pre-wrap;">,</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; white-space: pre-wrap;"> </span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; white-space: pre-wrap;">IF</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; white-space: pre-wrap;">(</span><span dir="auto" style="background-color: white; color: #f7981d; font-family: Inconsolata, monospace, arial, sans, sans-serif; white-space: pre-wrap;">E6</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; white-space: pre-wrap;"><=</span><span class="number" dir="auto" style="background-color: white; color: #1155cc; font-family: Inconsolata, monospace, arial, sans, sans-serif; white-space: pre-wrap;">6</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; white-space: pre-wrap;">,</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; white-space: pre-wrap;"> </span><span class=" string " dir="auto" style="background-color: white; color: green; font-family: Inconsolata, monospace, arial, sans, sans-serif; white-space: pre-wrap;">"NC"</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; white-space: pre-wrap;">)</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; white-space: pre-wrap;">) </span></span><br />
<br />
Where <span style="background-color: white; color: #f7981d; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; white-space: pre-wrap;">E6</span> is the cell that has the grade, and <span style="background-color: white; color: #1155cc; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; white-space: pre-wrap;">6</span> is the points threshold that I decided on as the lower limit of "completeness". <span style="background-color: white; color: green; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; white-space: pre-wrap;">C </span>and <span style="background-color: white; color: green; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; white-space: pre-wrap;">NC </span>can be whatever you want it to report out.<br />
<br />
Once you have that formula in place, it is simply a matter of dragging it down and across to copy it. Both Google sheets or Excell will automatically change the cell references.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCoubfSD9gIDskgzAIZoK71HBittXXyCr_wTEC-SAdWrYY4zHbicQXetyfDIs4mfE3Or2V-mThqrKpJiyGU5OCH-gWJ9KQr1BjqzwfFhDGDndXAmsAUoGgJ9lCcMJMgaPK6iip_D5iyeg/s1600/drag22.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="900" data-original-width="1600" height="360" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCoubfSD9gIDskgzAIZoK71HBittXXyCr_wTEC-SAdWrYY4zHbicQXetyfDIs4mfE3Or2V-mThqrKpJiyGU5OCH-gWJ9KQr1BjqzwfFhDGDndXAmsAUoGgJ9lCcMJMgaPK6iip_D5iyeg/s640/drag22.gif" width="640" /></a></div>
<br />
Once that is done, your spreadsheet is ready to be uploaded to whichever LMS you are using. While you will have to do it again any time you update your grades, it will at least save you some time and keystrokes.<br />
<br />
Have you found any other shortcuts to deal with this new normal? I'd love to hear about them.<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />Mrs.Garciahttp://www.blogger.com/profile/16492613229969352064noreply@blogger.com0tag:blogger.com,1999:blog-8818419233796306494.post-84719644234362886712020-04-12T08:10:00.000-07:002020-04-12T11:13:15.437-07:00Distance learning made "easy" with Formative<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbxl_ql-dFg11Ems0CcNjZiZhz9kPRCbgz3TqghWnLrHd7aqb207YhjLxVlFNLmAhQTSnBrdpktRDGoO54EKfV3C9OFZ6tMqEfb6Ryp64MQc4XhYDv3yyu4_F_hVApLTF9tVpTrO6kxSw/s1600/formative11.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="790" data-original-width="776" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbxl_ql-dFg11Ems0CcNjZiZhz9kPRCbgz3TqghWnLrHd7aqb207YhjLxVlFNLmAhQTSnBrdpktRDGoO54EKfV3C9OFZ6tMqEfb6Ryp64MQc4XhYDv3yyu4_F_hVApLTF9tVpTrO6kxSw/s400/formative11.JPG" width="392" /></a></div>
<br />
<br />
A while back I shared <a href="http://www.teachingabovethetest.com/2018/09/eight-reasons-to-use-goformative.html" target="_blank">8 Reasons to Love GoFormative</a>. All of what I mentioned back then still holds true, but in this new era of remote teaching, <a href="https://goformative.com/" target="_blank">GoFormative</a> has become the most powerful tool in my teaching arsenal. Let me share why.<br />
<blockquote class="tr_bq">
It is important to note that some of the awesome things I'll be sharing are available to premium/partner users. However also important to state that GoFormative is offering access to their premium features for those facing school closures and that any premium features you use during this time remain active in your Formatives even if later you downgrade to a free plan.</blockquote>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://goformative.com/" target="_blank"><img border="0" data-original-height="65" data-original-width="967" height="42" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgNrzpp3I-OXjoXws4ddlGWOlU5ESY5_CvqXwX55Uoj8sEz_gayKgjrZG2xo_h4Fg2ZqDxjnYUr_uJIpF2u10JEaSIN3vB_ygMT1MaaSGvbKLM0gaaOJajLoplYHnwk_3VXRMYye9hi4Xc/s640/giz.JPG" width="640" /></a></div>
<br />
<br />
<h3>
<a href="https://goformative.com/" target="_blank">GoFormative</a> and Google Classroom</h3>
<br />
GoFormative "talks" to Google Classroom. There is nothing worse than trying to introduce a new tool to students. That initial walk-through of setting up student accounts, having students remember passwords, etc is a pain even in the best of times. GoFormative allows you to import your classes, assign work and pass back scores to Google classroom. Students do not have to do anything other than click on the assignment in their Google classroom, log in to GoFormative using their Google credentials and get to the actual work at hand.<br />
<br />
<h3>
Everything in One Place</h3>
<br />
This is the best part. GoFormative allows you to embed practically anything directly into your formative assignment. What this means is that you can have a full lesson on Formative that starts with a screencast or video, then a simulation, followed by a slideshow and a Quizziz, all in one place. No need for students to open up new tabs or get lost while trying to remember where to go.<br />
<br />
Last week I was tasked to give a PD on using GoFormative for distance learning and <a href="https://docs.google.com/presentation/d/1UGeS5Cm7dKZrNnt2ylBPb3axDeH1BrBP91IQhjoqvKg/copy" target="_blank">created this slideshow</a> walking you through what I consider the best things to embed for distance learning.<br />
<br />
<iframe allowfullscreen="true" frameborder="0" height="299" mozallowfullscreen="true" src="https://docs.google.com/presentation/d/e/2PACX-1vSfdOPR_ZlvscdGQXzhLQQDC-Ry4BfJTBQwuxmec8hLN2OAvkNF5YIaPMRCJ4u6XuvC17_Vy_RYkENv/embed?start=false&loop=false&delayms=3000" webkitallowfullscreen="true" width="480"></iframe>
<br />
<br />
And just to be clear, embedding is not a premium feature. It is always available as a stand-alone embed, though as a premium partner you can embed directly into a question type.<br />
<br />
And while we are on the subject of embedding, if you embed a Google document using the <a href="https://docs.google.com/presentation/d/e/2PACX-1vSfdOPR_ZlvscdGQXzhLQQDC-Ry4BfJTBQwuxmec8hLN2OAvkNF5YIaPMRCJ4u6XuvC17_Vy_RYkENv/pub?start=false&loop=false&delayms=3000&slide=id.g73171d058e_0_68" target="_blank">"second way" mentioned above</a>, and give editing rights to the document to your students, you can effectively transform that document into a discussion board that the students can type into while still in GoFormative!<br />
<div class="separator" style="clear: both; text-align: center;">
<iframe allowfullscreen="" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/0P3mhA5z-OA/0.jpg" frameborder="0" height="266" src="https://www.youtube.com/embed/0P3mhA5z-OA?feature=player_embedded" width="460"></iframe></div>
Of course, if you want to close the "discussion board" you simply change the permissions of the document back to anyone with the link can view.<br />
<h3>
Real-Time feedback</h3>
Once students are working in your Formative, you can give feedback in real-time or asynchronously. This <a href="https://help.goformative.com/en/articles/265395-give-instant-feedback" target="_blank">GoFormative article shows you how</a>. Now, while in a Google meet (or Zoom), you can also choose to display the student answers, hiding their names (which is an actual feature in GoFrmative) and have a full discussion about their answers.<br />
<div class="separator" style="clear: both; text-align: center;">
<iframe allowfullscreen="" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/akK3GxBq8F0/0.jpg" frameborder="0" height="266" src="https://www.youtube.com/embed/akK3GxBq8F0?feature=player_embedded" width="460"></iframe></div>
<br />
<h3>
Formative Library</h3>
<div>
If you don't know where to start or just want to find something quickly, <a href="https://goformative.com/" target="_blank">GoFormative</a> also has a <a href="https://goformative.com/library/8YbcZiY9RL8dLD54Q" target="_blank">library of teacher-created Formatives</a> shared by teachers that can help pave the way to your use of GoFormative during this time.</div>
<div>
<br /></div>
<div>
Some more information about the use of GoFormative during school closures, including a recording of a webinar that walks you through setting everything up can be found in their article <a href="https://help.goformative.com/en/articles/3790381-covid-19-virtual-classroom-action-plan" target="_blank">"COVID-19 Virtual Classroom Action Plan"</a></div>
<div>
<br /></div>
<div>
This is how <a href="https://goformative.com/" target="_blank">GoFormative</a> has made my transition to remote teaching easy. How about you, what tools are you using and found especially powerful during these times?</div>
Mrs.Garciahttp://www.blogger.com/profile/16492613229969352064noreply@blogger.com0tag:blogger.com,1999:blog-8818419233796306494.post-4357009053118007662020-04-08T07:45:00.002-07:002020-04-08T07:48:21.518-07:00Covid-19: Where am I during school closures?<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0zEBdcKhkOF2BZWMtY4Nu3U0pZGyyEbacDcW1JGT781dvu63RiWMKchfu2L6y4nzreQwW8tq1d5btIOADk-6dtD7J18V7K_Q-CacmPAyzMXiy1BwWpuXH0UWnGZhFNCIz2eLCM1kSnXM/s1600/Who+do+I+choose+to+be+V2+%25281%2529.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="720" data-original-width="960" height="480" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0zEBdcKhkOF2BZWMtY4Nu3U0pZGyyEbacDcW1JGT781dvu63RiWMKchfu2L6y4nzreQwW8tq1d5btIOADk-6dtD7J18V7K_Q-CacmPAyzMXiy1BwWpuXH0UWnGZhFNCIz2eLCM1kSnXM/s640/Who+do+I+choose+to+be+V2+%25281%2529.jpg" width="640" /></a></div>
<br />
It has been 3 weeks since my school site closed, and a week since we got the news that our schools will be closed for the remainder of the school year. As many of you, I have been scrambling to get things in place so that my students can continue learning. I have now had Google meet check-ins with my middle schoolers, and developed a slew of online lessons and experiences, and I've had to redifine what this school closure means for me and my students several times over. As I was working through this I came across a <a href="https://twitter.com/CarolLRead/status/1247396695656316930/photo/1" target="_blank">graphic</a> posted by @CarolLRead that helped me focus and recognize my feelings over the situation and in some ways gave me a path forward. So, I set about re-creating it for use with students as a way to help them recognize that:<br />
<br />
1. Their feelings are valid, and their reactions are completely normal.<br />
2. They can move from one "zone" to another at any given time.<br />
3. There are ways to change their outlook and use this time in meaningful ways.<br />
<br />
I don't know where we will all land when this is over, but I am hopeful that we will all come out of this a little bit stronger.<br />
<br />
If you'd like a copy of the graphic to share with your students, you can create your own by <a href="https://docs.google.com/drawings/d/1fPdutKVuuvdV7QIktgbBeG5iVPz2oAWZtJ5Yoad3phk/copy" target="_blank">clicking here</a>Mrs.Garciahttp://www.blogger.com/profile/16492613229969352064noreply@blogger.com0tag:blogger.com,1999:blog-8818419233796306494.post-31842230957724604442020-03-16T15:41:00.002-07:002020-03-16T15:41:58.906-07:00Biogeochemical Cycles Digital Dice Games<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhXeC9zvrqER5UKE5iG3kdAJopjSbXuxY8WeNyqW6Op3XSk38jQg7qRmQZEePhkCTV4EMvGsf5PzElV_yF8z3PN9k63YE0dz8clP7l2WoGEacf58MIUiDfiuw1HmDH3ApXbaN5bbyihqks/s1600/cycles1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="712" data-original-width="712" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhXeC9zvrqER5UKE5iG3kdAJopjSbXuxY8WeNyqW6Op3XSk38jQg7qRmQZEePhkCTV4EMvGsf5PzElV_yF8z3PN9k63YE0dz8clP7l2WoGEacf58MIUiDfiuw1HmDH3ApXbaN5bbyihqks/s640/cycles1.jpg" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<br />
<br />
During my career as a middle school teacher, I've made use of a number of biogeochemical cycle dice games that are readily available in several variations on the internet. A couple of days ago, as I was bringing the illustrated dice I had for the water cycle, I thought that this would be the last year I could use that particular set - they were a little crumpled from handling and the pictures had faded. While creating the dice is not hard, I was a little unmotivated to do it and wondered whether there was another way to still use the activity but save me the work of recreating the dice every so often.<br />
<br />
It has now been several days, but I did it! A digital version of the water cycle dice game.<br />
<br />
<iframe allowfullscreen="true" frameborder="0" height="311.2" mozallowfullscreen="true" src="https://docs.google.com/presentation/d/e/2PACX-1vSUwtByDTHB5i2YNE-zGpHyzGxkbIw7zSs7RtcEBw-qlPp16EjGKZ9R-3n7Va4K0joS7I8LbAyAZZO1/embed?start=false&loop=false&delayms=3000" webkitallowfullscreen="true" width="384"></iframe>
<iframe height="250" src="https://www.openprocessing.org/sketch/100534/embed/" width="250"></iframe>
<br />
<br />
<br />
Now, of course, this would not be the way to show it to students, so I posted it up for actual use on a Google site, with a link to a record sheet -<br />
<h2 style="text-align: center;">
<a href="https://sites.google.com/oakgrovesd.net/biogeochemical-cycles/home" target="_blank">Biogeochemical Cycles Dice Games</a></h2>
<div>
<br /></div>
<div>
Not being able to stop myself at just the water cycle, I then went ahead and created a page and "game" for all other cycle games I use. </div>
<div>
<br /></div>
<div>
<ul>
<li>Carbon - both <a href="https://sites.google.com/oakgrovesd.net/biogeochemical-cycles/home/carbon-cycle-pre-industrial" target="_blank">pre</a> and <a href="https://sites.google.com/oakgrovesd.net/biogeochemical-cycles/home/carbon-cycle-post-industrial" target="_blank">post</a>-industrial revolution</li>
<li><a href="https://sites.google.com/oakgrovesd.net/biogeochemical-cycles/home/nitrogen-cycle" target="_blank">Nitrogen</a></li>
<li><a href="https://sites.google.com/oakgrovesd.net/biogeochemical-cycles/home/phosphorus-cycle" target="_blank">Phosphorus</a></li>
<li><a href="https://sites.google.com/oakgrovesd.net/biogeochemical-cycles/home/rock-cycle" target="_blank">Rock</a></li>
</ul>
</div>
I purposely re-used the illustrations to give students an idea of the similar reservoirs for matter as it cycles through on Earth and to allow for easy comparison between the cycles.<br />
<br />
After playing any of the games, you could have students write stories or draw cartoons with the information they gathered or discuss how difficult/easy it is for a molecule to leave a specific reservoir. If they play more than one, they can also compare their journeys in both (which reservoirs are present in two or more, which processes are similar, etc.)<br />
<br />
I would love to hear more ideas about what you could do with them.Mrs.Garciahttp://www.blogger.com/profile/16492613229969352064noreply@blogger.com3tag:blogger.com,1999:blog-8818419233796306494.post-80865175626888558582020-03-04T18:59:00.001-08:002021-09-28T06:02:12.203-07:00Plate Tectonics Google Map<iframe height="480" src="https://www.google.com/maps/d/embed?mid=1cZV-bUQk07SWhQn6-qzHgDgI9GLkO8l8" width="640"></iframe>
<br />
<br />
For several years I have been teaching Plate Tectonics to students and we have done several paper-pencil activities that have to do with plotting earthquakes, volcanos and landforms on maps. Over those years, I've searched far and wide for a Google map that included the outlines of the plates in the hopes of turning those activities into a digital product. I've only ever found Google Earth maps with this feature and while cool, the idea of navigating Google Earth with students has always been daunting. This year I had some time and decided to create my own Plate Tectonics Google map.<br />
<br />
The link to the map, which you can see above and can use to make a copy is <span style="color: #1155cc; font-family: "arial"; font-size: 11pt; vertical-align: baseline; white-space: pre-wrap;"><b><a href="https://bit.ly/2VOCDOr" style="text-decoration-line: none;">https://bit.ly/2VOCDO</a></b></span>. If you decide to use it, I only ask that you share it forward, freely, to any teacher who may also be looking for it.<br />
<br />
The project I use it for, which includes not only the link but also a Google slide deck with instructions on how to make a copy of the map, add markers and share it (see below), can be <a href="https://docs.google.com/document/d/1k_6nPqOlJGObpqoHT9Itx2zw4x3iB1y_lTMHr1XoVsI/copy" target="_blank">downloaded here</a><br />
<div style="text-align: center;">
<br /></div>
<iframe allowfullscreen="true" frameborder="0" height="299" mozallowfullscreen="true" src="https://docs.google.com/presentation/d/e/2PACX-1vTptT3hBLh-mD8ajSikNf8X1EFK6ggrBztiibC0JMb_6LsLdtXSdQ4NmsblvteuPhm4y9u7isYCUwC7/embed?start=false&loop=false&delayms=3000" webkitallowfullscreen="true" width="480"></iframe>
<br />
If you do download it, consider leaving a review. Thanks!<br />
<br />Mrs.Garciahttp://www.blogger.com/profile/16492613229969352064noreply@blogger.com0tag:blogger.com,1999:blog-8818419233796306494.post-12400345808954478182020-02-02T10:33:00.000-08:002020-02-02T10:33:44.359-08:00Interpreting graphs with "What's Going on in this Graph?" <div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDVuIYY3yGyVKtcaxgyH3KmeGjHd8TRRZqH0FFcGoYQkfEaRqpn5WkLJ8mqZLh5fHdeC3ThKYrd85l69bsjmWQM57EAc2K3JK_LNxInL56pVzAvUqJZJ3dhIxa8h55pLsDNCqii8gtrAE/s1600/graphs.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="720" data-original-width="556" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDVuIYY3yGyVKtcaxgyH3KmeGjHd8TRRZqH0FFcGoYQkfEaRqpn5WkLJ8mqZLh5fHdeC3ThKYrd85l69bsjmWQM57EAc2K3JK_LNxInL56pVzAvUqJZJ3dhIxa8h55pLsDNCqii8gtrAE/s320/graphs.png" width="247" /></a></div>
<br />
<br />
It's been three years since the <a href="https://www.nytimes.com/2018/08/27/learning/whats-going-on-in-this-graph-is-now-weekly-stem-teachers-explain-why-its-a-powerful-activity.html">New York Times partnered with the American Statistical Association</a> to bring "<a href="https://www.nytimes.com/column/whats-going-on-in-this-graph">What's Going on in this Graph?</a>" to teachers and students. The premise is simple, every week during the school year they publish a graph asking students to think about it and discuss their observations whether on the site itself or on <a href="https://teacher.desmos.com/curriculum/view/5c38d8b9b2e2c80d2230827c">Desmos</a>. A week later, they have a reveal, with more information and highlights from the moderation.<br />
<br />
I started using the activity with my 8th grade Science and Engineering classes last year, as I struggled to teach them to interpret motion graphs. What I was looking at at the time, was students who jumped to conclusions without stopping to actually look at axes or units, or choosing to bar graphs over line graphs simply because they were more familiar. I also, at the time, was invested in having students create infographics for projects, but again, they were doing so without actually looking or thinking about why one choice was better than another, or even worse, Googling for ready-made ones and pasting them without realizing that what they had included actually contradicted or was completely irrelevant to the message they were trying to send. The need was obvious - How do I help students acquire the skills they need to analyze graphs and charts.<br />
<br />
During the first few months of using them, I presented the graph posted by the NYT that week and used their prompt:<br />
<br />
<ul>
<li>What do you notice?</li>
<li>What do you wonder?</li>
<li>What's going on?</li>
</ul>
<div>
This was fine except for one little thing, they started looking at the comments posted for "correct" answers or as a guide for what to write in their response to me. While it did force them to at least open and read the comments, they were still taking that short-cut of having someone else do the thinking and noticing. So I started adding some other questions that would require the act of reading the graph in order to answer them. These questions were not necessarily of a very high DOK, but rather of the "actually look at the graph" type. Things like</div>
<ul>
<li>"What is the military spending worldwide presented on the graph?" for <a href="https://www.nytimes.com/2019/02/07/learning/whats-going-on-in-this-graph-feb-13-2019.html">this installment</a></li>
<li>"Which destination seems to be the most popular for Thanksgiving Travel?" for <a href="https://www.nytimes.com/2018/11/08/learning/whats-going-on-in-this-graph-nov-14-2018.html">this one</a></li>
<li>"Describe how the author represents data in the graphic."</li>
</ul>
<div>
These types of questions are always presented before the analysis questions and have served us well to help students look at the graphs before moving on to the deeper analysis posed by: </div>
<br />
<ul>
<li>What's going on in this graph? (i.e. what would be an accurate conclusion that can be supported by this graph). To answer this question use the <a href="https://mariana68.wixsite.com/adventurescience/cer-frames">CER framework</a></li>
<li>Write a >140 character Tweet that could accompany the sharing of the graph. Your response must include a relevant hashtag.</li>
</ul>
<div>
By now, I have a bundle of 29 such activities in the <a href="https://goformative.com/library/5c7d561dc745aebb3dd71fd2">GoFormative</a> library. Most of which come from the weekly NYT publishing, with a couple added from other sources due to my students' interest in a topic. The activity for me is weekly and takes up about 30 minutes of class time. Since many of them are related to my content it ends up supporting not only the acquisition of the skills for interpreting graphs espoused in the CCSS and NGSS but also addressing <a href="https://www.iste.org/standards/for-students">ISTE standards</a> for students, making the activity an absolute win.</div>
Mrs.Garciahttp://www.blogger.com/profile/16492613229969352064noreply@blogger.com0tag:blogger.com,1999:blog-8818419233796306494.post-68261131375360845542020-02-02T07:28:00.001-08:002020-02-02T07:28:57.028-08:00Documenting Peer-Reviews leads to better builds<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1BEIrEfkGN7VCgOHI_XxdUtXyif0s9KKELOyu7u8d16l5K7fUXj_znvTY2eRhNSx8lVtxku7vOFvc_OZTWD0NB8y59FIWj3cwenWgHSa5QiBKvmRVC7IiwY15k-erCrP8n1jIzG4YrsY/s1600/giz.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="303" data-original-width="287" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1BEIrEfkGN7VCgOHI_XxdUtXyif0s9KKELOyu7u8d16l5K7fUXj_znvTY2eRhNSx8lVtxku7vOFvc_OZTWD0NB8y59FIWj3cwenWgHSa5QiBKvmRVC7IiwY15k-erCrP8n1jIzG4YrsY/s1600/giz.JPG" /></a></div>
<br />
<br />
As a project-based learning teacher, I know about the importance of feedback during project runs. I constantly conference with students, formally and informally, trying to push them to think critically about the project as well as what they are creating. Unfortunately, these conversations and documents don't always make it into their final projects, leaving both me and the students frustrated come unveiling day. You see, often my students become enamored with an idea and it is really hard to sway them, even when they realize that they should have taken a different approach. They come up with "patch" solutions to "fix" the immediate problem, but they seldom take a step back and realize that they should start from scratch. While I know that the learning is in the process, I also see a lack of transfer of those lessons from project to project - i.e. this did not work last time, why would it work this time?<br />
<br />
Case in point - I run a project based on Teach Engineering's "<a href="https://www.teachengineering.org/makerchallenges/view/cub_carrierdevices_maker1" target="_blank">Adding Helpful Carrier Devices to Crutches</a>", and have this whole set-up that walks students through the engineering design process for it (<a href="https://sites.google.com/oakgrovesd.net/assistivetechnology-crutches/" target="_blank">Assistive Technology - Crutches</a>). Last year we even had one of the students as an actual client that needed the device and built to her specifications, supposedly. What happened was that students basically attached whatever they had on hand without much consideration for usability - boxes and bags that make holding the crutches almost impossible, or too big causing a severe imbalance, etc. When challenged about this during first testing, their solutions were always about fixing what was already there (create a hole for the hand or adding dividers so help with the swaying of things), but they never included "take the whole thing off and re-work from scratch". After weeks of patches, students unveiled final products that did comply with the requirements but were not actually useful. The posed to the student we were building for, "Would you buy this?", was always met with, "No, not really" - even for her own build! This led me to a bigger reflection of where I was dropping the ball and/or what could I do to help promote better builds.<br />
<br />
As I pondered this question, I came up with two key things that I've implemented and seem to be working:<br />
<br />
<h3>
The fast build </h3>
As soon as the project is introduced, the students have one class period to create and test a quick prototype. This happens even before the brainstorm. The goal of the fast build is to help students identify where the problems may eventually arise.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjFPOQQYDg_a9HljLuW60cqb2DhrlK7Rigtxzi-y5YnGx4gZX0G2LWYZqaExrMhc18kaqb3izH_WkaSWwR6HJMHXSbtO26RL6fqSKX80qIUg0EssunUwBJgB2XfAnADYW419dqd_dYzgag/s1600/giz.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="423" data-original-width="907" height="298" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjFPOQQYDg_a9HljLuW60cqb2DhrlK7Rigtxzi-y5YnGx4gZX0G2LWYZqaExrMhc18kaqb3izH_WkaSWwR6HJMHXSbtO26RL6fqSKX80qIUg0EssunUwBJgB2XfAnADYW419dqd_dYzgag/s640/giz.JPG" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<h3>
The Peer-Review documentation</h3>
<div>
After the fast build, my students continued through the engineering design project as usual. However, when it came time for testing the first full build, I introduced a "<a href="https://docs.google.com/document/d/1kdk4ziiz7Tt3jZOtKpwC-hIYAf1hDnqNv49vF6Iwgu8/copy" target="_blank">Prototype Evaluation</a>" rubric.</div>
<div>
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg5ODZW0QSKCzXca3l65sx1qFbF9aIKbEO1_ACXRkZZvUS-Pc2_oJ2Us-Vf4qkkLMrh_j7pQW18SWKyJH79LPoA_PFJBvM6WBlVQIGWbanH0qtgZpyhFQXfUYpOHMhnWtfx-Uqp-j3Apk8/s1600/giz.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="488" data-original-width="1294" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg5ODZW0QSKCzXca3l65sx1qFbF9aIKbEO1_ACXRkZZvUS-Pc2_oJ2Us-Vf4qkkLMrh_j7pQW18SWKyJH79LPoA_PFJBvM6WBlVQIGWbanH0qtgZpyhFQXfUYpOHMhnWtfx-Uqp-j3Apk8/s640/giz.JPG" width="640" /></a></div>
<div>
The key portion for us was the requirement of providing specific ideas to help the team improve. I "sold" this to the students as "your team has already thought about different ways to address issues, but that is only 4 brains. You are getting the benefit of 28 other brains that are seeing other things you have to address." After the testing and prototype evaluation rubric has been filled out, each team is responsible for compiling the feedback and presenting a summary of the information obtained from those rubrics and creating a plan of action for the next prototype. </div>
<div>
<br /></div>
<div>
This peer review documentation seems to be working, though it does add three days of work for each prototype. In this case, I am requiring at least three rounds, extending the project 9 more class periods. while this may not be feasible in every situation, I believe that it will be time well spent.</div>
<div>
<br /></div>
<div>
What do you think? What scaffolds do you have in place to ensure yous students are successful during their project runs? I'd love to hear about them.</div>
<div>
<br /></div>
<div>
<br /></div>
Mariana Garcia Serratohttp://www.blogger.com/profile/08902695384276465117noreply@blogger.com0tag:blogger.com,1999:blog-8818419233796306494.post-42750849470208781082019-07-29T09:33:00.000-07:002019-07-29T09:42:57.975-07:00Declutter your district Gmail<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh9jFxjF4orGkEqxA_wrM2u1L3qyCPwkufvdw6E-ZvZZfaGS1WS8Yd54m3Ek44TaVXS482x1xkMsdhTEWEVKEEBGrFRh1qStKzwwNwSlu8bkFYwnNo68YrljUmmsoJD4rsbd_k3P9GncmQ/s1600/gmail.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="225" data-original-width="225" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh9jFxjF4orGkEqxA_wrM2u1L3qyCPwkufvdw6E-ZvZZfaGS1WS8Yd54m3Ek44TaVXS482x1xkMsdhTEWEVKEEBGrFRh1qStKzwwNwSlu8bkFYwnNo68YrljUmmsoJD4rsbd_k3P9GncmQ/s400/gmail.png" width="400" /></a></div>
<br />
<br />
Having a district Google account has many benefits. From single sign-on to sharing documents with students and using Google classroom, it provides many opportunities for collaboration and communication, which makes it an invaluable tool. However, dealing with the e-mail attached to that account has always been a nightmare for me. That e-mail account is clogged with newsletters from different vendors and notifications of shared documents from students to the point of making it completely useless. In the past, this has not been a problem since my district was also using an LMS which made it easy for me to bypass the use of that Gmail. However, it looks like it may no longer be the case, so I needed to find a way to make that Gmail account work more efficiently for me, and the answer was not as difficult as I thought it would be. It all relies on filtering your e-mails.<br />
<br />
<h4>
Filtering the vendors</h4>
<div>
1. Click on any e-mail you receive from a vendor to open it</div>
<div>
2. Click on the three little dots at the top right of the message to open the "more" menu and select "filter messages like this"</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhA31kXBDQGODoNbiGGJSHZOSaaY75EWaQoFhWyi6485eiLlqJgGc_G2j6haFtx35SF_IYrqQrKVW-X7eZUsF963m7p_wRT4SCnZ2uwwt7KtGkNXvLEkn-2f_Dej94dMW13zMZnQSSXfmk/s1600/steps.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="685" data-original-width="1328" height="330" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhA31kXBDQGODoNbiGGJSHZOSaaY75EWaQoFhWyi6485eiLlqJgGc_G2j6haFtx35SF_IYrqQrKVW-X7eZUsF963m7p_wRT4SCnZ2uwwt7KtGkNXvLEkn-2f_Dej94dMW13zMZnQSSXfmk/s640/steps.PNG" width="640" /></a></div>
<div>
<br /></div>
<div>
3. On the screen that opens, select "Create Filter" and then choose what you want to do with those e-mails.</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkHtNSq4lmzagZ24VeNFuccGn6hYwgGv2WaudoyYhZzDmDGe9RY_hpfxod9zJ-qWg27U29r22vkIzJvsPjjho7H650eFRekuy-3YTOFlinZ-0K8wQSjHVeTVwjNspCobVGb8ekz78H2zU/s1600/steps1.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="744" data-original-width="1326" height="358" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkHtNSq4lmzagZ24VeNFuccGn6hYwgGv2WaudoyYhZzDmDGe9RY_hpfxod9zJ-qWg27U29r22vkIzJvsPjjho7H650eFRekuy-3YTOFlinZ-0K8wQSjHVeTVwjNspCobVGb8ekz78H2zU/s640/steps1.PNG" width="640" /></a></div>
<div>
<br /></div>
<h4>
Filtering the invitations to edit</h4>
<div>
This was my biggest issue. No matter how many times I've asked my 240 stduents that when they share something with me (which I do want, of course) they should "skip sending a notification", they almost never do - that requires paying attention to details, which is not their forte. So on any given day, I would get hundreds of "____ has shared a document" e-mails. Filtering those was not as straightforward since the option to "filter messages like this" is not available. However, it can also be done.</div>
<div>
<br /></div>
<div>
1. Open your Gmail. Click on the Gear icon and then on Settings.</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXQyD87axALk_VLCfRId1jz3yhsuc8RRa8kd31Hd7sRzmBHsj60iDOqHwc1DUBogNs1kM5lEkeC244Lg9oYdfN47l7AWmHgx5GQNrtuzq30Z_SUJMlrXr5zi-z97CCKGAOP18I-QaQaUs/s1600/steps3.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="709" data-original-width="1321" height="342" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXQyD87axALk_VLCfRId1jz3yhsuc8RRa8kd31Hd7sRzmBHsj60iDOqHwc1DUBogNs1kM5lEkeC244Lg9oYdfN47l7AWmHgx5GQNrtuzq30Z_SUJMlrXr5zi-z97CCKGAOP18I-QaQaUs/s640/steps3.PNG" width="640" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
2. Select Filters and Blocked Addresses</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvYwgDdkij0kaposxuqw541y9jlfgke7R3_QmHygxDbhGjx76cKCuhWpnOgjkgNhZZhphuIuN-AAj32lCEJIF_rnqCqYyaKYW5z8mYHJ2JIHePAXrkwXR95v_7kfGkk3AZsZJTsLuGE_I/s1600/steps4.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="312" data-original-width="1333" height="148" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvYwgDdkij0kaposxuqw541y9jlfgke7R3_QmHygxDbhGjx76cKCuhWpnOgjkgNhZZhphuIuN-AAj32lCEJIF_rnqCqYyaKYW5z8mYHJ2JIHePAXrkwXR95v_7kfGkk3AZsZJTsLuGE_I/s640/steps4.PNG" width="640" /></a></div>
<div>
<br /></div>
<div>
3. Scroll down until you see Create a New Filter</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhcqPwn3e8U03rF87MaIz_80nyHffWC5IqSEl8iitN8qtn9ioibnPjDh6N7JROJgnLQh8JiEiL_p6mgFKJBoY8p9rTfydOFXtoHL97Uf6ihk9CrZWc5YTrmVBTCpkRMSFb2M8Cwa-VeAGY/s1600/steps5.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="657" data-original-width="1330" height="316" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhcqPwn3e8U03rF87MaIz_80nyHffWC5IqSEl8iitN8qtn9ioibnPjDh6N7JROJgnLQh8JiEiL_p6mgFKJBoY8p9rTfydOFXtoHL97Uf6ihk9CrZWc5YTrmVBTCpkRMSFb2M8Cwa-VeAGY/s640/steps5.PNG" width="640" /></a></div>
<div>
</div>
<div>
4. In the box that appears, create the filter</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgV_0dcL45jcHNht4kMqUaWVwOjfoj5Lwmqw9e3jj1qTRWCPSMX1UfXsqwSx9gG2r-sHlA9_ByeXNmorKuBehipgm4th-ox1D6vWcj6nyBrawWi3IwEI1_WZ0vAcR_hvV49W_D5p24iryE/s1600/steps6.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="527" data-original-width="1322" height="254" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgV_0dcL45jcHNht4kMqUaWVwOjfoj5Lwmqw9e3jj1qTRWCPSMX1UfXsqwSx9gG2r-sHlA9_ByeXNmorKuBehipgm4th-ox1D6vWcj6nyBrawWi3IwEI1_WZ0vAcR_hvV49W_D5p24iryE/s640/steps6.PNG" width="640" /></a></div>
<div>
<br /></div>
<div>
5. Once you click continue, select what you want the filter to do and then click "create filter"</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhiRvnEtP37fVYcnDfE2jgqzvb3VzlSJBlYTVHSNK9ty4czAxaPaSrBTDU_tvkQycUFKITPqtRyIAzSCyV1pYYTYngfs1QXt-7cR5vkKlrhPBzkC3nn-18TCBh7LtQAncH_KA4kHaHpWqs/s1600/steps7.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="587" data-original-width="1328" height="282" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhiRvnEtP37fVYcnDfE2jgqzvb3VzlSJBlYTVHSNK9ty4czAxaPaSrBTDU_tvkQycUFKITPqtRyIAzSCyV1pYYTYngfs1QXt-7cR5vkKlrhPBzkC3nn-18TCBh7LtQAncH_KA4kHaHpWqs/s640/steps7.PNG" width="640" /></a></div>
<div>
<br /></div>
<div>
I selected "skip the inbox" for these types of e-mails just in case something gets filtered that I then need to go back to at some point. These e-mails will never make it to your inbox so if you ever need to see them, you will need to click on "more" on the left side of the screen, and then on "all e-mail".</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQFNxjHS2gWCZj7Tgcjl6-KJQlPHqsx7sn3RXGOtbY0vq7UuWGJg6F-oqKo-614IoP5BxG1fVLJlE-Npwk8p23DrO4yeSgbkQ3yGZX8uubaClb_QLwIvKGrgpNknUzpFfnQZLJJusUU_A/s1600/steps8.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="577" data-original-width="1115" height="330" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQFNxjHS2gWCZj7Tgcjl6-KJQlPHqsx7sn3RXGOtbY0vq7UuWGJg6F-oqKo-614IoP5BxG1fVLJlE-Npwk8p23DrO4yeSgbkQ3yGZX8uubaClb_QLwIvKGrgpNknUzpFfnQZLJJusUU_A/s640/steps8.PNG" width="640" /></a></div>
<div>
<br /></div>
<div>
It is important to note that all these filters you created do not necessarily apply retroactively. Anything received before you created the filter will still appear in your inbox unless you do something about it. However, anything new will be filtered according to the rules you just created.</div>
<div>
<br /></div>
<div>
So there it is. I hope you find this useful and if you have other tips I'd love to hear about them. On to teaching students about the wonder of BCC and never using "reply all".</div>
<div>
<br /></div>
Mrs.Garciahttp://www.blogger.com/profile/16492613229969352064noreply@blogger.com0tag:blogger.com,1999:blog-8818419233796306494.post-58454827781467569202019-07-08T18:51:00.000-07:002019-07-09T06:50:09.567-07:00Boss Battles with Google Forms and Sheets - An Update<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTMZiglafn_-ChzgfZIcmqVvyMKDMXexJz8ywDc-nlS7IW8_PzYl9xXBocXPzam3RWdqlRfA6mCUuFyVnFEorH0i5uZm0WqLeKXoambSIaTkzHFB7SV1mrcyzRwCAQC1rLZurwdc4BhR0/s1600/boxing.jpeg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1069" data-original-width="1600" height="213" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTMZiglafn_-ChzgfZIcmqVvyMKDMXexJz8ywDc-nlS7IW8_PzYl9xXBocXPzam3RWdqlRfA6mCUuFyVnFEorH0i5uZm0WqLeKXoambSIaTkzHFB7SV1mrcyzRwCAQC1rLZurwdc4BhR0/s320/boxing.jpeg" width="320" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
I spent most of the last summer creating <a href="http://www.teachingabovethetest.com/2018/06/boss-battles-with-google-formssheets.html">Boss Battles</a> for my gamified classroom. Throughout the school year, I also shared with you a couple of tweaks I made to those original sheets, adding "<a href="http://www.teachingabovethetest.com/2018/11/first-perfect-hit-tweaks-to-boss-battles.html">first hit and first perfect hit</a>", and then adding "<a href="http://www.teachingabovethetest.com/2019/03/shiny-bosses.html">shiny bosses</a>". My students really got into this whole idea of battling the bosses and I was really happy with the excitement they generated.<br />
<div>
<br /></div>
<div>
A couple of days ago, I began the painstaking process of clearing all of this work out in preparation for the new school year. While I would have loved to use them as they are, they no longer fit the game narrative that I am exploring for the upcoming year, plus, I reused Bosses across my grade levels. While this may not be a problem for most teachers, it is for me because I loop the students, so most of them would be re-battling the same bosses they already know. Perhaps they would not remember, but all it would take is one of them to check their <a href="http://www.teachingabovethetest.com/2018/06/individual-rank-sheets-google-sheets-to.html">student sheets</a> (where the bosses are displayed), and the excitement of getting collecting the boss would be diminished. </div>
<div>
<br /></div>
<div>
With all of this in mind, I started creating new bosses - we will be rescuing scientists - and clearing out the old forms/sheets tweaking the originals a bit, which is what I am sharing today.</div>
<div>
<br /></div>
<div>
<a href="https://docs.google.com/spreadsheets/d/16KVjNflmGRD86rT3rPIja4h83ouvTYrKxPrcA8zqYFU/copy">Boss Battle Form (will auto copy)</a> - I have dummy-filled it with some data so that it is easier to explain. If you make a copy simply delete all the prefilled contents of "form responses 1"</div>
<div>
<br /></div>
<h3>
Boss Sheet</h3>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOzbBAIC7GDkUUpR2AQcwunVyldOo6568kn2XL_tuIKQXIaOnuYugs_9k7OJ781wYspk5loFdYBFkhJAN7ih4J3gLhyaEoZpY8qBsPtFuUlClBCECzjw3eGhzK_yasXH5KT1_ANcb7mo8/s1600/giz.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="731" data-original-width="1600" height="292" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOzbBAIC7GDkUUpR2AQcwunVyldOo6568kn2XL_tuIKQXIaOnuYugs_9k7OJ781wYspk5loFdYBFkhJAN7ih4J3gLhyaEoZpY8qBsPtFuUlClBCECzjw3eGhzK_yasXH5KT1_ANcb7mo8/s640/giz.PNG" width="640" /></a></div>
<div>
<br /></div>
<div>
While it looks basically the same, there are important things to note. </div>
<div>
<ul>
<li>Column L contains each of the Boss possibilities. Each is its own drawing (published to the web) and placed into the cell using </li>
</ul>
</div>
<div style="text-align: center;">
<span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">=</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">image</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">(</span><span class=" string " dir="auto" style="background-color: white; color: green; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">"published address of your google drawing"</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">)</span></div>
<blockquote class="tr_bq" style="text-align: left;">
You may be tempted to make use of the new "insert image in cell" function. Don't. You will be calling the images into the boss battle pane and into the scores sheet. Google Sheets does not recognize images insterted that way as actual objects so until they fix that what will happen is that you get blank instead of the image you want to display.</blockquote>
<br />
<ul>
<li> Cell F15 now contains a new formula:</li>
</ul>
<blockquote class="tr_bq">
<span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">=</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">index</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">(</span><span dir="auto" style="background-color: white; color: #f7981d; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">'Form Responses 1'!$B:$B</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;"> </span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">match</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">(</span><span class="boolean" dir="auto" style="background-color: white; color: #1155cc; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">true</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">isnumber</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">(</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">search</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">(</span><span class=" string " dir="auto" style="background-color: white; color: green; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">"/"</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span dir="auto" style="background-color: white; color: #7e3794; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">'Form Responses 1'!$A:$A</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">)</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">)</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class=" string " dir="auto" style="background-color: white; color: green; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">""</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">)</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">)</span></blockquote>
<blockquote class="tr_bq">
This formula looks at the timestamp looking for the first appearance of the slash symbol (/) in Form Responses 1 column A and reports the matching contents of column B in the same sheet. This formula solves the problem of having to change cell references as the sheet is populated the first time around.</blockquote>
<br />
<ul>
<li>Cell F16 contains a similar formula:</li>
</ul>
<blockquote class="tr_bq">
<span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">=</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">index</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">(</span><span dir="auto" style="background-color: white; color: #f7981d; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">'Form Responses 1'!$B:$B</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;"> </span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">match</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">(</span><span class="boolean" dir="auto" style="background-color: white; color: #1155cc; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">true</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;"> </span><span dir="auto" style="background-color: white; color: #7e3794; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">'Form Responses 1'!$C:$C</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">=</span><span class="number" dir="auto" style="background-color: white; color: #1155cc; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">12</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;"> </span><span class="number" dir="auto" style="background-color: white; color: #1155cc; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">0</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">)</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">)</span></blockquote>
<blockquote class="tr_bq">
In this case, it matches the contents in column B with the first time the "perfect score" of 12 is achieved, and of course that can be changed to whatever number you is your "perfect score". </blockquote>
<h3>
Perfect Sheet</h3>
That sheet simply reports the contents of first hit and first perfect hit and assigns them a value. I bring that into my leaderboard using the Vlookup function as a way to give students an added incentive.<br />
Formula that imports this into your leaderboard:<br />
<br />
<span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">=</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">IFERROR</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">(</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">VLOOKUP</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">(</span><span dir="auto" style="background-color: white; color: #f7981d; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">A17</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">IMPORTRANGE</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">(</span><span class=" string " dir="auto" style="background-color: white; color: green; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">"Boss Battle Google Sheet Identifier"</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class=" string " dir="auto" style="background-color: white; color: green; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">"Perfect!A:B"</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">)</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class="number" dir="auto" style="background-color: white; color: #1155cc; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">2</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class="number" dir="auto" style="background-color: white; color: #1155cc; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">0</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">)</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;"> </span><span class="number" dir="auto" style="background-color: white; color: #1155cc; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">0</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">)</span><br />
<span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;"><br /></span>
Where the number 2 is the column number where those "extra points" are housed.<br />
If you are interested in the Vlookup formula as it pertains to the leaderboard, visit my post <a href="http://www.teachingabovethetest.com/2018/06/assign-xp-automatically-using-vlookup.html">"Assign XP automatically using Vlookup - Google Sheets"</a><br />
<br />
<h3>
Scores Sheet - AKA Where the magic happens</h3>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhY8IcbhOe1wdKpYh_jNcLVehnkohVKlPA1-7-SX2QPw6VW0d9G5Vy8gO9TrrhyE-yU3GXx-efaM2ewOkTcotmCdYxW3VD3wqmm4jpC1CcG35QbKVHYYQZH4pFrI9v6MV94l0dJvd9uGFo/s1600/giz2.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="763" data-original-width="1600" height="304" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhY8IcbhOe1wdKpYh_jNcLVehnkohVKlPA1-7-SX2QPw6VW0d9G5Vy8gO9TrrhyE-yU3GXx-efaM2ewOkTcotmCdYxW3VD3wqmm4jpC1CcG35QbKVHYYQZH4pFrI9v6MV94l0dJvd9uGFo/s640/giz2.PNG" width="640" /></a></div>
<br />
As originally, this is a pivot table that aggregates the data generated first by adding all the scores each student generates (Column B - Sum of Scores) and then by reporting the maximum score the student obtained (Column C - Max Score).<br />
<br />
<h4>
Column D (Counts the number of times a student achieved a Perfect Score)</h4>
I've been toying with the idea of having students "catch/rescue the Bosses". This collecting of the bosses had a great impact in engaging students to attempt the quizzes multiple times throughout a semester, regardless of whether it is an official Boss Battle day with the whole display of the Boss. In order to achieve this assigning of bosses I first needed to know how many times a student scored a perfect score. To do this, I added a Calculated Field to my Pivot Table:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitzv__OhX3r2m92Xki7r5-0wjadWgt-Eyg0IHOxK8Hwp15Zx8y6QzpIyDLxBfCpOkqMQZEMkwrT0h8bcPfNgzML1davVkzBaPKN1bN5ZLcXaUW9zKXNa4S7CL4lupzrK9td_5Eza0UH9c/s1600/giz3.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="643" data-original-width="350" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitzv__OhX3r2m92Xki7r5-0wjadWgt-Eyg0IHOxK8Hwp15Zx8y6QzpIyDLxBfCpOkqMQZEMkwrT0h8bcPfNgzML1davVkzBaPKN1bN5ZLcXaUW9zKXNa4S7CL4lupzrK9td_5Eza0UH9c/s320/giz3.PNG" width="174" /></a></div>
If you click anywhere inside the already populated pivot table, the Pivot Table Editor opens. This already had the score summarization by SUM and by MAX.<br />
<br />
The Times Perfect Score was added using by clicking Add values and selecting "calculated field". The formula is simply a COUNTIF, though you notice that the normal use of the quotations is eliminated.<br />
<br />
=COUNTIF (Score, 12)<br />
<br />
The number 12 obviously corresponds to the "perfect score" in this particular case and could be changed to whatever suits your needs.<br />
<br />
If you are recreating your own, also make sure that you select Summarize by Custom and Show as Default.<br />
<br />
That got me the number of times a student got a perfect score. You may be wondering why this was important. The answer is that I did not want to give out the Boss simply based on the number of points. My students are notorious for finding the easy way out and often would rather take a quiz 100 times scoring 1 each time than getting 100 the first time.<br />
<br />
<h4>
Column F (Where the Shiny Bosses come in)</h4>
<div>
With that number of "perfect scores" aggregated by student, it was time to move on to the "catching/rescuing" of the boss.</div>
<div>
<br /></div>
<div>
When working to pivot tables, you can still add formulas to the columns that are not being used by the pivot table itself. I added a title to Column F and called it boss obtained. To give the illusion of randomness to the catch, I decided on the following formula</div>
<div>
<br /></div>
<div>
<span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">=</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">IF</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">(</span><span dir="auto" style="background-color: white; color: #f7981d; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">D2</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">>=</span><span class="number" dir="auto" style="background-color: white; color: #1155cc; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">10</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;"> </span><span dir="auto" style="background-color: white; color: #7e3794; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">Boss!$L$9</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;"> </span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">IF</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;"> </span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">(</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">AND</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">(</span><span dir="auto" style="background-color: white; color: #f7981d; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">D2</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">=</span><span class="number" dir="auto" style="background-color: white; color: #1155cc; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">9</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">)</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;"> </span><span dir="auto" style="background-color: white; color: #11a9cc; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">Boss!$L$8</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;"> </span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">IF</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;"> </span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">(</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">AND</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">(</span><span dir="auto" style="background-color: white; color: #f7981d; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">D2</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;"><=</span><span class="number" dir="auto" style="background-color: white; color: #1155cc; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">8</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span dir="auto" style="background-color: white; color: #f7981d; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">D2</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">>=</span><span class="number" dir="auto" style="background-color: white; color: #1155cc; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">6</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">)</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span dir="auto" style="background-color: white; color: #7e3794; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">Boss!$L$9</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;"> </span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">IF</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;"> </span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">(</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">AND</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">(</span><span dir="auto" style="background-color: white; color: #f7981d; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">D2</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;"><=</span><span class="number" dir="auto" style="background-color: white; color: #1155cc; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">5</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span dir="auto" style="background-color: white; color: #f7981d; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">D2</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">>=</span><span class="number" dir="auto" style="background-color: white; color: #1155cc; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">1</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">)</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span dir="auto" style="background-color: white; color: #11a9cc; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">Boss!$L$8</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class=" string " dir="auto" style="background-color: white; color: green; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">" "</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">)</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">)</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">)</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">)</span></div>
<div>
<span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;"><br /></span></div>
which gives the Boss in Cell L9 or L8 of the Boss sheet depending on the number of perfect scores. You would think that you could use the RAND (random) function, but unfortunately, it is what is called a volatile function, which means it refreshes each time and I did not want students to have a new boss catch simply by opening the sheet.<br />
<div>
<br /></div>
<div>
The formula is just copy/pasted down through the sheet so that each row gets its own student reference. The results of this column are again imported to my Leaderboard using VLOOKUP as mentioned in Perfect Sheet above. The key here is to remember that VLOOKUP references the column number:</div>
<div>
<br /></div>
<div>
<span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">=</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">IFERROR</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">(</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">VLOOKUP</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">(</span><span dir="auto" style="background-color: white; color: #f7981d; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">A2</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">IMPORTRANGE</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">(</span><span class=" string " dir="auto" style="background-color: white; color: green; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">"your sheet identifier"</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class=" string " dir="auto" style="background-color: white; color: green; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">"scores!$A$2:F"</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">)</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,<span style="color: #1155cc;">6</span></span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class="number" dir="auto" style="background-color: white; color: #1155cc; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">0</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">)</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;"> </span><span class="number" dir="auto" style="background-color: white; color: #1155cc; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">0</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">)</span></div>
<div>
<span style="font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif;"><span style="font-size: 14px; white-space: pre-wrap;"><br /></span></span></div>
<div>
where the initial<span style="font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif;"><span style="font-size: 14px; white-space: pre-wrap;"> </span></span><span style="background-color: white; color: #f7981d; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">A2 </span>- is what it is looking for (e-mail of my student),</div>
<div>
<span style="background-color: white; color: green; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">"scores!$A$2:F"</span>- the sheet and range where the data is housed</div>
<div>
<span style="background-color: white; color: #1155cc; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">6 </span>- really column F where the bosses caught were "assigned"<br />
<br /></div>
<h4>
Column E - Maximum Possible Score: the end to "grinding"</h4>
<div>
Last year, some of my students greatly inflated their leaderboard standing by retaking boss battles over and over again. While in principle this would be OK with me, there is a point where enough is enough. I know that I can simply close the form, but that leaves the student who may need the extra practice out of the loop, and opening and closing a form manually means that I must remember to do so. Taking this into consideration, I opted for writing in a formula that reports a set number of points out to my leaderboard (again with the VLOOKUP formula) to my leaderboard once the maximum is reached.</div>
<div>
<br /></div>
<div>
<span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">=</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">if</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;"> </span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">(</span><span dir="auto" style="background-color: white; color: #f7981d; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">B2</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">></span><span class="number" dir="auto" style="background-color: white; color: #1155cc; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">40</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;"> </span><span class="number" dir="auto" style="background-color: white; color: #1155cc; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">40</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;"> </span><span dir="auto" style="background-color: white; color: #f7981d; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">B2</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">)</span></div>
<div>
<span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;"><br /></span></div>
Looking at the formula, it simply reads if the contents of cell <span style="background-color: white; color: #f7981d; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">B2</span> (where the scores are added is greater than 40, report 40, otherwise report the number present in cell <span style="background-color: white; color: #f7981d; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">B2</span>. The formula is copied down Column E.<br />
<div>
<br /></div>
<div>
That is it for today. I hope this inspires you to keep working on your leaderboards and perhaps make some additions or modifications. And as always a big shout-out to <a href="https://twitter.com/MrPowley">Mr. Powley</a> who although has moved on to <a href="https://classroompowerups.com/2019/06/24/kill-your-darlings/">standards-based grading</a> and may be letting go of the <a href="https://classroompowerups.com/2017/12/08/dreadsheets-using-spreadsheets-for-boss-battles/">Dread Sheets</a> inspired this whole Boss Battle process.<br />
<div>
<br /></div>
<div>
<br /></div>
</div>
Mrs.Garciahttp://www.blogger.com/profile/16492613229969352064noreply@blogger.com0tag:blogger.com,1999:blog-8818419233796306494.post-50050405758440829122019-07-04T20:45:00.000-07:002019-07-19T07:25:05.900-07:00Embed a Live Google Slide into a Google Doc<br />
<iframe allowfullscreen="true" frameborder="0" height="432" id="1722541503" mozallowfullscreen="true" src="https://docs.google.com/drawings/d/1WOOrlaRY_7_qWgXnZdMlBToAegplor9OmNSrWDpNTdY/preview?authuser=0&h=432&hl=en&w=576" title="Tips for success - OGSD" webkitallowfullscreen="true" width="576"></iframe>
<br />
This post falls under the "How did I not know this before" category...<br />
<br />
Over the last few days, I have been updating my 8th-grade waves unit and will be using this <a href="https://drive.google.com/open?id=1eykipSUeG-nT5qMiyJNCxbbfsP3v5hxq">performance task</a> I found online. As I was working, I was going back and forth between the document and a slide deck "template" that I want students to use as a guide to organizing their work. My students tend to lose track of things so this was my way of ensuring that once they got to the end of the task they had everything they needed. Anyway, long story short I placed the document, which is rather long, into my preferred delivery site (<a href="https://www.wix.com/">WIX</a>) and embedded the slide deck but was not particularly satisfied with the way it looked. I needed side by side and rather specific placements.<br />
I definitely did not want to just give access to the slide deck since I know that my students would just make a copy of the template and use that instead of going through the instructions. I also did not want to add all the instructions to the slide deck. So then I decided that I wanted to add the slide deck to the instructions document.<br />
<br />
I know that I could take a screenshot of the slides I wanted to reference and then link them, but while searching I came across the absolute easiest way of doing this:<br />
<br />
<h3>
How to Embed a Google Slide Into a Google Doc</h3>
1. Open your Google slide deck.<br />
<span style="color: #432d2d; font-family: "libre franklin"; font-size: 16px;"><br /></span>
<span style="color: #432d2d; font-family: "libre franklin"; font-size: 16px;">2. From the left side panel, click and select the slide you want to add to your Google doc. Go up to Menu and select Edit > Copy.</span><br />
<span style="color: #432d2d; font-family: "libre franklin"; font-size: 16px;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDY-Fbc52WZGATchK2yn2S34HgSEXvqrynTfdW2qMW7M3ULBn3s6kPVigEf4L10qWceyd7wCppvNiAdVxoZ4Rq6Jz4GqTUhkElcCm-TdPsrn7IrlD4kuHI_rWCRpOWfUIEUbdwpX3z5-o/s1600/vid1.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="360" data-original-width="640" height="360" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDY-Fbc52WZGATchK2yn2S34HgSEXvqrynTfdW2qMW7M3ULBn3s6kPVigEf4L10qWceyd7wCppvNiAdVxoZ4Rq6Jz4GqTUhkElcCm-TdPsrn7IrlD4kuHI_rWCRpOWfUIEUbdwpX3z5-o/s640/vid1.gif" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
3. <span style="color: #432d2d; font-family: "libre franklin"; font-size: 16px;">Open the Google Doc where you want your slide to be. Place your cursor in the location in the document where you want to add the slide.</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: #432d2d; font-family: "libre franklin"; font-size: 16px;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: #432d2d; font-family: "libre franklin"; font-size: 16px;">4. </span><span style="color: #432d2d; font-family: "libre franklin"; font-size: 16px;">Go up to the menu and select </span><span style="color: #432d2d; font-family: "libre franklin"; font-size: 16px;">Edit > Paste</span><span style="color: #432d2d; font-family: "libre franklin"; font-size: 16px;">. </span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: #432d2d; font-family: "libre franklin"; font-size: 16px;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: #432d2d; font-family: "libre franklin"; font-size: 16px;">5. Choose</span><span style="color: #432d2d; font-family: "libre franklin"; font-size: 16px;"> "Link to presentation" to make it an active link.</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: #432d2d; font-family: "libre franklin"; font-size: 16px;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXg8PnhZQbC3TSXClszI971xduQ2uuMxY9dePuAoKNiIGmTyEuyJi7vjKSKAcVqQndbdLuO4hJ04BtlnzQPGttXePEqHf9S0KEPHDUSRCHCxSQ1Ss82Kl_UBWmf3FmgC2NOdHHNxzHKus/s1600/vid2.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="360" data-original-width="640" height="360" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXg8PnhZQbC3TSXClszI971xduQ2uuMxY9dePuAoKNiIGmTyEuyJi7vjKSKAcVqQndbdLuO4hJ04BtlnzQPGttXePEqHf9S0KEPHDUSRCHCxSQ1Ss82Kl_UBWmf3FmgC2NOdHHNxzHKus/s640/vid2.gif" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: #432d2d; font-family: "libre franklin"; font-size: 16px;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: #432d2d; font-family: "libre franklin"; font-size: 16px;">Google docs will treat this as any other image, so you can resize, add borders, crop to shape or whatever you want. The absolute beauty of this is that the link not only directs the user (my students) to the specific slide, but also any changes made to the slide in the slide deck are updated in the doc by just clicking on update. You can see how this worked in the document I was talking about before:</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: #432d2d; font-family: "libre franklin"; font-size: 16px;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEilb83wyJdHkqIVJotEkV1qW9SkUuoxSYcZ8FlwJVdIdT_rutQ-2TdrcUO0QhAJLJokBHKQLsuj4L5Ze3454VEAfqa7jcmTiin8Uu-73b-bW51Z3IXtXxplxKIXWDlB-fFyhIQBVzQi3BY/s1600/My+Video.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="360" data-original-width="640" height="360" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEilb83wyJdHkqIVJotEkV1qW9SkUuoxSYcZ8FlwJVdIdT_rutQ-2TdrcUO0QhAJLJokBHKQLsuj4L5Ze3454VEAfqa7jcmTiin8Uu-73b-bW51Z3IXtXxplxKIXWDlB-fFyhIQBVzQi3BY/s640/My+Video.gif" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: #432d2d; font-family: "libre franklin"; font-size: 16px;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: #432d2d; font-family: "libre franklin"; font-size: 16px;">I am thinking that this little trick can be used for hyperdocs, instructables or even lab reports. What do you think. What other uses do you see?</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: #432d2d; font-family: "libre franklin"; font-size: 16px;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: #432d2d; font-family: "libre franklin"; font-size: 16px;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: #432d2d; font-family: "libre franklin"; font-size: 16px;"><br /></span></div>
<span style="color: #432d2d; font-family: "libre franklin"; font-size: 16px;"><br /></span>Mrs.Garciahttp://www.blogger.com/profile/16492613229969352064noreply@blogger.com0tag:blogger.com,1999:blog-8818419233796306494.post-27574501224460879402019-03-16T19:00:00.000-07:002019-03-16T19:01:30.914-07:00Reviewing Content with Shiny Bosses<div style="text-align: center;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVUfHQOg-iE33Pi-mUb0Krtm1xtUEyPCquv-9kQsC2yhFSq9ACXM7VlEljHIwAw21DKljub9mSfpEcZiYTCMAV_uuvNwn367ue-FODPMEjlHjHYmLMw5bo-Hyz4xgPKJHmENiQ0JL2oYQ/s1600/shinyb.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="473" data-original-width="646" height="468" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVUfHQOg-iE33Pi-mUb0Krtm1xtUEyPCquv-9kQsC2yhFSq9ACXM7VlEljHIwAw21DKljub9mSfpEcZiYTCMAV_uuvNwn367ue-FODPMEjlHjHYmLMw5bo-Hyz4xgPKJHmENiQ0JL2oYQ/s640/shinyb.JPG" width="640" /></a></div>
<br /></div>
<br />
By far, the greatest successful addition to my game this year was the <a href="http://www.teachingabovethetest.com/2018/06/boss-battles-with-google-formssheets.html" target="_blank">Boss Battles</a>. Piloted at the end of last year, and fully implemented this year, I've even had students present this form of testing during Student Exhibition Nights. This boggles my mind since the Boss Battles are in reality nothing more than the normal tests and quizzes I would normally have, but as we all know, beating the Boss, and even better, adding each to our collection of "perfect bosses", is so much better than simply taking a test.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg5C6ZKFMsdOlGpLljVPqOYq64eVUFflycjquCg9A96sHRYTFz-mr5LVxUOcQPBTZmMRnttrr1JJUpq_m6mpE_9PwaRPZUGYl9Mafw_1QOP6G7_9-6orSZS051EyfBHlfvB_ThS0wNLytE/s1600/boss.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="181" data-original-width="830" height="138" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg5C6ZKFMsdOlGpLljVPqOYq64eVUFflycjquCg9A96sHRYTFz-mr5LVxUOcQPBTZmMRnttrr1JJUpq_m6mpE_9PwaRPZUGYl9Mafw_1QOP6G7_9-6orSZS051EyfBHlfvB_ThS0wNLytE/s640/boss.JPG" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: justify;">
My boss battles have undergone a couple of minor tweaks over the course of the year, with the addition of the <a href="http://www.teachingabovethetest.com/2018/11/first-perfect-hit-tweaks-to-boss-battles.html" target="_blank">first hit and first perfect hit</a>, and Google Sheet's new (to me) <a href="http://blog.whooosreading.org/google-forms-hacks-for-teachers/" target="_blank">shuffle question order</a>, but other than that they have remained the same as when I first created them. </div>
<div class="separator" style="clear: both; text-align: justify;">
<br /></div>
<div class="separator" style="clear: both; text-align: justify;">
With CASP dates approaching, I started to think about pulling questions from this already created "bank" of questions to create new battles for review. However, I did not love this idea simply because, I did not think this far along in the school year when I set up the <a href="http://www.teachingabovethetest.com/2018/06/individual-rank-sheets-google-sheets-to.html" target="_blank">individual student sheets</a>, and thus did not leave myself extra places for more than a couple extra bosses. The other issue I had was that each unit is tied to a race of aliens we encounter through our narrative so it would not make much sense for a "robot" boss (matter) to suddenly ask questions about earth systems, for example. </div>
<div class="separator" style="clear: both; text-align: justify;">
<br /></div>
<div class="separator" style="clear: both; text-align: justify;">
I was pondering this one morning while on my daily Pokemon Go walk (yes, I still play) when the idea to make shiny bosses came. If you are unfamiliar with the term, a shiny Pokemon is a variant of a regular Pokemon that has a slightly different coloration. It does not give anything new out nor does it have any special attacks, it is simply different. So I set about trying to figure out how to make that happen without having to recreate (copy) a multitude of forms and sheets and do a bunch of work with changing cell references in my evergrowing leaderboard. Most importantly, I did not want to touch the student ranking sheets. So here goes - <a href="https://docs.google.com/presentation/d/e/2PACX-1vTg3hUBZJ74bVYKUlAjM9bGqR4FVo5QXzDMOgZ5kHkBhwLLfjNY1jmV7_MC5VF6VUNEAZNLAReO4_5Z/pub?start=false&loop=false&delayms=3000" target="_blank">Fullscreen link</a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div style="text-align: center;">
<iframe allowfullscreen="true" frameborder="0" height="509" mozallowfullscreen="true" src="https://docs.google.com/presentation/d/e/2PACX-1vTg3hUBZJ74bVYKUlAjM9bGqR4FVo5QXzDMOgZ5kHkBhwLLfjNY1jmV7_MC5VF6VUNEAZNLAReO4_5Z/embed?start=false&loop=false&delayms=3000" webkitallowfullscreen="true" width="480"></iframe>
</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: justify;">
If you are presenting the shiny boss battles as a stand-alone thing for review, you are done, but if like me, you were already pulling data into your leaderboard, you will need to make some other adjustments. </div>
<div class="separator" style="clear: both; text-align: justify;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div style="text-align: center;">
<iframe allowfullscreen="true" frameborder="0" height="509" mozallowfullscreen="true" src="https://docs.google.com/presentation/d/e/2PACX-1vSivdAW-K_O37UkHdEL11gAXIRt3kqKdwlA-2YSH9JG3Huq_sXT7_jCMvkMBLmN8bFd0qtNh-bR2m2a/embed?start=false&loop=false&delayms=3000" webkitallowfullscreen="true" width="480"></iframe>
</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
As with most of the gamification set-up tasks, the joy for you may be in creating the first shiny boss, and the rest of the process may become tedious, but remember, once done you do not have to do anything other than enjoy your students as they confront the shiny boss. As you see below, the figuring things out ends up being done by Google Sheets so there is no time wasted in looking up individual students to see if they got the shiny boss or not.</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiEbxrk2FfQLmeDkx7hH7vmT0AjzEPQByjvMgIp83bi4ZxXQL1VQENcgAHzZMstC335zjOhpXfIk2piwT480cp6lKeIkbNeASsVb6lrdnc-_QSGiBTvmxdcKoXJ3BMAzRLWGN_-FxXYMeQ/s1600/boss11.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="360" data-original-width="640" height="360" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiEbxrk2FfQLmeDkx7hH7vmT0AjzEPQByjvMgIp83bi4ZxXQL1VQENcgAHzZMstC335zjOhpXfIk2piwT480cp6lKeIkbNeASsVb6lrdnc-_QSGiBTvmxdcKoXJ3BMAzRLWGN_-FxXYMeQ/s640/boss11.gif" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: justify;">
What do you think? Any other ideas to make review a part of your game or narrative? I'd love to hear about them.</div>
Mariana Garcia Serratohttp://www.blogger.com/profile/08902695384276465117noreply@blogger.com0tag:blogger.com,1999:blog-8818419233796306494.post-59264350243075882532019-02-10T16:24:00.001-08:002019-03-02T15:13:35.227-08:00Foldables or what to do when there are no devices allowedI am sure that many of you are familiar with the foldable idea. There are books and blogs specifically dedicated to them, and the whole interactive notebook movement is still making the rounds. Although I love the idea, I am more of an #edtech teacher and tend to prefer to find opportunities for students to create digitally. That is until I am absent from the classroom, and I need to find an activity that ties into what we are doing and that will not need the use of devices. Too many times I've been burned by either my sub not knowing the rules of using tech with students or my students taking that absence as an opportunity to be off-task on their devices under the guise of "doing research".<br />
<br />
So for those times, I find that foldables are "just right" in that they allow for a bit of scaffolding, but they are easy enough for students to handle without my presence. Unfortunately, every time I need one and do a Google search, I end up with several Pinterest hits that lead to TpT - a site that I prefer to avoid.<br />
<br />
Today was one of those days, which spurred the idea of sharing the one that I created this morning for human body systems, along with some others, in case you are in need of them.<br />
<br />
<b id="docs-internal-guid-827b1842-7fff-cd36-81b9-d46da80e675f" style="font-weight: normal;"><br /></b><br />
<div dir="ltr" style="margin-left: 0pt;">
<table style="border-collapse: collapse; border: none;"><colgroup><col width="173"></col><col width="173"></col><col width="173"></col></colgroup><tbody>
<tr style="height: 119pt;"><td style="border-bottom: solid #000000 0.98958pt; border-left: solid #000000 0.98958pt; border-right: solid #000000 0.98958pt; border-top: solid #000000 0.98958pt; padding: 5pt 5pt 5pt 5pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.44; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap; white-space: pre;"><img height="125" src="https://lh3.googleusercontent.com/FFfIjeuBNqPJdksoy0Qbe6wWZVr2ofCYTUdJjJi5MP9sI_a-kswjkXPk9xFvkPQDkYQFywv77q0JkPp3F-dsSrPLsgV6A3IeDpdHvWQmfMCj4V-dezV-I3kZmDa7PCcmEzJWRBDM" style="-webkit-transform: rotate(0.00rad); border: none; transform: rotate(0.00rad);" width="154" /></span></div>
<div dir="ltr" style="line-height: 1.44; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<a href="https://docs.google.com/document/d/1dOPqw5VMhmoSJMg-oIfH9c5DvZ56AoqelRu7QxHBo4c/copy" style="text-decoration: none;"><span style="-webkit-text-decoration-skip: none; background-color: transparent; color: #1155cc; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration-skip-ink: none; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap; white-space: pre;">Human Body Systems</span></a></div>
</td><td style="border-bottom: solid #000000 0.98958pt; border-left: solid #000000 0.98958pt; border-right: solid #000000 0.98958pt; border-top: solid #000000 0.98958pt; padding: 5pt 5pt 5pt 5pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.44; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap; white-space: pre;"><img height="106" src="https://lh4.googleusercontent.com/FOCAW-fqATX8sB62q0up73MqvU8LhUxUWb5UFE06fyMF2RG9fN7u7mljJmODqBoDm455LwK4QgMJfFC3gEw7gj-8DP5UkeQvvx2BFQgPkqEzfH1S5aNhxTEuRIk_KilDQVpx3H9w" style="-webkit-transform: rotate(0.00rad); border: none; transform: rotate(0.00rad);" width="166" /></span></div>
<br /><div dir="ltr" style="line-height: 1.44; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<a href="https://docs.google.com/document/d/10YEz20pdxFiTR8M4yrEhkZdJ_yrSdPcOkES9u3sm_DQ/copy" style="text-decoration: none;"><span style="-webkit-text-decoration-skip: none; background-color: transparent; color: #1155cc; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration-skip-ink: none; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap; white-space: pre;">Macromolecules</span></a></div>
</td><td style="border-bottom: solid #000000 0.98958pt; border-left: solid #000000 0.98958pt; border-right: solid #000000 0.98958pt; border-top: solid #000000 0.98958pt; padding: 5pt 5pt 5pt 5pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.44; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap; white-space: pre;"><img height="110" src="https://lh4.googleusercontent.com/_U97C-_Aasnwmu-bSfbdcSvLYLbm08ocwTtApWNxd0cMbDXWQikrGkwAr8zesySpyZHUVJsqHLPRRztTToGKSgl32KfWYG_7oISY-fElDX8dnW2R1JwZVfuzAHFe_hueNzP8Y-of" style="-webkit-transform: rotate(0.00rad); border: none; transform: rotate(0.00rad);" width="157" /></span></div>
<br /><div dir="ltr" style="line-height: 1.44; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<a href="https://docs.google.com/document/d/16h2eUd4u6TGx3RJ5Elz5jX6KwE07ONFRN3UjCzzAJJk/copy" style="text-decoration: none;"><span style="-webkit-text-decoration-skip: none; background-color: transparent; color: #1155cc; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration-skip-ink: none; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap; white-space: pre;">Scalar and Vector</span></a></div>
</td></tr>
<tr style="height: 132pt;"><td style="border-bottom: solid #000000 0.98958pt; border-left: solid #000000 0.98958pt; border-right: solid #000000 0.98958pt; border-top: solid #000000 0.98958pt; padding: 5pt 5pt 5pt 5pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.44; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap; white-space: pre;"><img height="103" src="https://lh5.googleusercontent.com/N7doqb-sQG2X0ZuXtA5leVN1EeWCddNeRCCCmujGmwwNHnCXQvihHQh1FoX7R-Ltjn7On-k2mkpUFFa5oAN_5GORrwTl-7MuUbwUESU_ZN3mSEVBtn18l56i_S1fd3umIXJqGL1n" style="-webkit-transform: rotate(0.00rad); border: none; transform: rotate(0.00rad);" width="157" /></span></div>
<br /><br /><div dir="ltr" style="line-height: 1.44; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<a href="https://docs.google.com/document/d/1KgCQ5ZEa_hm-g57YMi0PcmoRS3xX-EP3XfdPbC68ej0/copy" style="text-decoration: none;"><span style="-webkit-text-decoration-skip: none; background-color: transparent; color: #1155cc; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration-skip-ink: none; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap; white-space: pre;">Ecological pyramid</span></a></div>
</td><td style="border-bottom: solid #000000 0.98958pt; border-left: solid #000000 0.98958pt; border-right: solid #000000 0.98958pt; border-top: solid #000000 0.98958pt; padding: 5pt 5pt 5pt 5pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.44; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap; white-space: pre;"><img height="110" src="https://lh3.googleusercontent.com/oEIU5QodpkCyOfxvoGGqktl7b8CIkQnWRVcau0duglucjiSeGPZuaWOtCpCzSPdUB1gM9Xx9lai4nmm0ddFXdXGcf1jNwTM672JbVlnwr_ao_8-ikXkUicwM2lPGHN_n3shkHroa" style="-webkit-transform: rotate(0.00rad); border: none; transform: rotate(0.00rad);" width="157" /></span></div>
<br /><div dir="ltr" style="line-height: 1.44; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: #1155cc; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap; white-space: pre;">Classification of</span><a href="https://docs.google.com/document/d/1bQRgS2S1LtsqRleYui23l8x4d1q-lUMdnih7YGKk6O8/copy" style="text-decoration: none;"><span style="background-color: transparent; color: #1155cc; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap; white-space: pre;"> </span><span style="-webkit-text-decoration-skip: none; background-color: transparent; color: #1155cc; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration-skip-ink: none; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap; white-space: pre;">Matter</span></a></div>
</td><td style="border-bottom: solid #000000 0.98958pt; border-left: solid #000000 0.98958pt; border-right: solid #000000 0.98958pt; border-top: solid #000000 0.98958pt; padding: 5pt 5pt 5pt 5pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.44; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap; white-space: pre;"><img height="98" src="https://lh4.googleusercontent.com/eDs5lqzfY0d4FoA86dPNUf09g8Xv_Sg9f5hXNDFvFPYE8ghe8AIf00t4V6Fyl3nP_K0VV1YbHKelwupf34JFoRkcqvvdPez7T0fkSSiVpTF4ZrN5DLvbWHK-qExgCAkfgWZgSgjN" style="-webkit-transform: rotate(0.00rad); border: none; transform: rotate(0.00rad);" width="143" /></span></div>
<br /><div dir="ltr" style="line-height: 1.44; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<a href="https://docs.google.com/document/d/1uRlJL42Jv_6levi0jijZVQznJX4pzaFf0gucbNgr5kI/copy" style="text-decoration: none;"><span style="-webkit-text-decoration-skip: none; background-color: transparent; color: #1155cc; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration-skip-ink: none; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap; white-space: pre;">Mechanisms for evolution</span></a></div>
</td></tr>
<tr style="height: 132pt;"><td style="border-bottom: solid #000000 0.98958pt; border-left: solid #000000 0.98958pt; border-right: solid #000000 0.98958pt; border-top: solid #000000 0.98958pt; padding: 5pt 5pt 5pt 5pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.44; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap; white-space: pre;"><img height="94" src="https://lh6.googleusercontent.com/yOaE85ldSPkZZXcSsAfY-Wx5CTNhw2Mx7zpfjJxZJ5f1uPmQgUdwFCCKlqMWs4Kv9-BtSCfEq0b1j3IdHPeRuQ1wPvpvYGpOoH_dj1bHl_f_4S72NZR3regKom_HktI2J7ji2_8Z" style="-webkit-transform: rotate(0.00rad); border: none; transform: rotate(0.00rad);" width="142" /></span></div>
<br /><br /><div dir="ltr" style="line-height: 1.44; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<a href="https://docs.google.com/document/d/19kP83dRUM8RPBxYEsOA39F9FjlcUkLLRlKTudjn2Aro/copy" style="text-decoration: none;"><span style="-webkit-text-decoration-skip: none; background-color: transparent; color: #1155cc; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration-skip-ink: none; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap; white-space: pre;">Properties of Matter</span></a></div>
</td><td style="border-bottom: solid #000000 0.98958pt; border-left: solid #000000 0.98958pt; border-right: solid #000000 0.98958pt; border-top: solid #000000 0.98958pt; padding: 5pt 5pt 5pt 5pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.44; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap; white-space: pre;"><img height="107" src="https://lh6.googleusercontent.com/-9WPC33rko8R7xVPewXyqQb0mNh5LgYg_050anVSLbISGnj7B5F_AeQICAc1rYzydbhMjlbZN1uHRfDNHXEGAzIm95oBOeBOwPvnDiJ_UXH-39dQXygM0MKIbOAmee7Cv75mZGT2" style="-webkit-transform: rotate(0.00rad); border: none; transform: rotate(0.00rad);" width="154" /></span></div>
<br /><div dir="ltr" style="line-height: 1.44; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<a href="https://docs.google.com/document/d/1oMRapi3Ark4vJEdd2adJG62gQGLP114PpXYVI6_jKgQ/copy" style="text-decoration: none;"><span style="-webkit-text-decoration-skip: none; background-color: transparent; color: #1155cc; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration-skip-ink: none; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap; white-space: pre;">Heat transfer</span></a></div>
</td><td style="border-bottom: solid #000000 0.98958pt; border-left: solid #000000 0.98958pt; border-right: solid #000000 0.98958pt; border-top: solid #000000 0.98958pt; padding: 5pt 5pt 5pt 5pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.44; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap; white-space: pre;"><img height="107" src="https://lh3.googleusercontent.com/BFUNXovB6QYvSce5mhsZ6ys2-UFBazJAXIEYJTuHOpOXVuvtn5PhJbwTofPlJdN07Ra7jz1AsUGGJqKGww6YX-bi62jQMmSGoox6uGpVvp9br7-e5lgXxdKxzLfesFV3qCPCQXcm" style="-webkit-transform: rotate(0.00rad); border: none; transform: rotate(0.00rad);" width="155" /></span></div>
<br /><div dir="ltr" style="line-height: 1.44; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<a href="https://docs.google.com/document/d/1vDZM1z-gO9BuLykgZtJEwHol_unGsnd1_XKDJ11LtGQ/copy" style="text-decoration: none;"><span style="-webkit-text-decoration-skip: none; background-color: transparent; color: #1155cc; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration-skip-ink: none; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap; white-space: pre;">Layers of the Earth</span></a></div>
</td></tr>
<tr style="height: 132pt;"><td style="border-bottom: solid #000000 0.98958pt; border-left: solid #000000 0.98958pt; border-right: solid #000000 0.98958pt; border-top: solid #000000 0.98958pt; padding: 5pt 5pt 5pt 5pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.44; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<a href="https://docs.google.com/document/d/1bDk4y_YAqxLgFujU4wCQrNyPHGAvv1C0SLuiwAtWJIQ/copy" style="text-decoration: none;"><span style="-webkit-text-decoration-skip: none; background-color: transparent; color: #1155cc; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration-skip-ink: none; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap; white-space: pre;"><img height="134" src="https://lh6.googleusercontent.com/dQt2j6Zy7lhAjS6gjMaNVvIWnBgJF_dijmtf2UMc2yC7j5J6TAZEq6hlY9xSkJTXh3skfPiPVHPYOKameWeOuuHQGSgogOCP-lTiuZgjaqy6p4stXYa3pra2eHn5RuKgm3Gei6oq" style="-webkit-transform: rotate(0.00rad); border: none; transform: rotate(0.00rad);" width="135" /></span></a></div>
<br /><div dir="ltr" style="line-height: 1.44; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<a href="https://docs.google.com/document/d/1bDk4y_YAqxLgFujU4wCQrNyPHGAvv1C0SLuiwAtWJIQ/copy" style="text-decoration: none;"><span style="-webkit-text-decoration-skip: none; background-color: transparent; color: #1155cc; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration-skip-ink: none; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap; white-space: pre;">Water Cycle</span></a></div>
</td><td style="border-bottom: solid #000000 0.98958pt; border-left: solid #000000 0.98958pt; border-right: solid #000000 0.98958pt; border-top: solid #000000 0.98958pt; padding: 5pt 5pt 5pt 5pt; vertical-align: top;"><br /><div dir="ltr" style="line-height: 1.44; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<a href="https://docs.google.com/document/d/1HCdY0lJWfJpBMTi_seOcYybMp6xtB2vMx9Oqgb1X9jc/copy" style="text-decoration: none;"><span style="-webkit-text-decoration-skip: none; background-color: transparent; color: #1155cc; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration-skip-ink: none; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap; white-space: pre;"><img height="105" src="https://lh5.googleusercontent.com/0qLKlx9vkwxLi1SJISeq6Ms81qC7jFv-9Kha15WCZLQqKdQf3OONnBNk9vWcsBngRePSuFillkidHHKHsh46MkJIN6nRaGu4998f9C8pK4NECFBrcZcEe6M96rbmW8hW4V_r2lu5" style="border: none; transform: rotate(0rad);" width="146" /></span></a></div>
<br /><div dir="ltr" style="line-height: 1.44; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<a href="https://docs.google.com/document/d/1HCdY0lJWfJpBMTi_seOcYybMp6xtB2vMx9Oqgb1X9jc/copy" style="text-decoration: none;"><span style="-webkit-text-decoration-skip: none; background-color: transparent; color: #1155cc; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration-skip-ink: none; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap; white-space: pre;">Adaptations</span></a></div>
</td><td style="border-bottom: solid #000000 0.98958pt; border-left: solid #000000 0.98958pt; border-right: solid #000000 0.98958pt; border-top: solid #000000 0.98958pt; padding: 5pt 5pt 5pt 5pt; vertical-align: top;"><div dir="ltr" style="line-height: 1.44; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<a href="https://docs.google.com/document/d/1EsWGWHR3NA0cje-YQVlbYJZeYz5GHERDXvN429JvcvI/copy" style="text-decoration: none;"><span style="-webkit-text-decoration-skip: none; background-color: transparent; color: #1155cc; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration-skip-ink: none; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap; white-space: pre;"><img height="125" src="https://lh4.googleusercontent.com/a8ZPoLOhgBsc6WDKNeFx4eI_JLRleSrXMoRoZnIqTV-xDeBL-jLTSMi8o29-dTjK4gQj6wKjTxTcmq6UzM4bi91pxPObzG-DbboXzDX0UP66Cv7--LJC4v8Nx8784uJ_5BJezEtt" style="border: none; transform: rotate(0rad);" width="127" /></span></a></div>
<br /><div dir="ltr" style="line-height: 1.44; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<a href="https://docs.google.com/document/d/1EsWGWHR3NA0cje-YQVlbYJZeYz5GHERDXvN429JvcvI/copy" style="text-decoration: none;"><span style="-webkit-text-decoration-skip: none; background-color: transparent; color: #1155cc; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration-skip-ink: none; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap; white-space: pre;">Heredity</span></a></div>
</td></tr>
</tbody></table>
</div>
<br />Mrs.Garciahttp://www.blogger.com/profile/16492613229969352064noreply@blogger.com0tag:blogger.com,1999:blog-8818419233796306494.post-19912887857026694652019-01-21T10:53:00.003-08:002019-01-21T10:53:38.501-08:00Experience Points for Student Goal Setting<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiSGAJWEI1o-7D0G0GOapew2FOyUV6JdIEIi4bR0iDWQrSbJhEzYyoVsNlOB0qLMkikbf_f1fr3kAZx5NNtq58QEJBU8AMyGkEZ-9IPYN8nNX3x69CxrrPRjKeZ8YuHk9bcL9RG4wDmfrM/s1600/goals1.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="500" data-original-width="1169" height="273" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiSGAJWEI1o-7D0G0GOapew2FOyUV6JdIEIi4bR0iDWQrSbJhEzYyoVsNlOB0qLMkikbf_f1fr3kAZx5NNtq58QEJBU8AMyGkEZ-9IPYN8nNX3x69CxrrPRjKeZ8YuHk9bcL9RG4wDmfrM/s640/goals1.JPG" width="640" /></a></div>
<br />
<br />
A couple of days ago, I posted about using <a href="http://www.teachingabovethetest.com/2019/01/reflective-students-with-google-forms.html">forms and sheets for student reflections</a>. As I was pushing it out to students, I started thinking about how to make it easy for me to assign XP and leveled badges for its use. Ideally, I would have some sort of automation that:<br />
<br />
1. Allowed me to see students' latest goal without having to open each individual spreadsheet, and<br />
2. Assigned XP and badges automatically.<br />
<br />
<h4>
Students latest goals:</h4>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIZqL-fNJNFSP7vI9CqybUclcxV0QUjRSOV12UN6yhYwwUv0OImb6DsiKgl2kCanhX396zPr7dis6zNIGdWGcJkp64fTPt4m1yY3BY8NmD4qhTHoZiIsrqXS_ZtV7zBg0wqv5MiV1KQJ0/s1600/blog1.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="505" data-original-width="1046" height="308" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIZqL-fNJNFSP7vI9CqybUclcxV0QUjRSOV12UN6yhYwwUv0OImb6DsiKgl2kCanhX396zPr7dis6zNIGdWGcJkp64fTPt4m1yY3BY8NmD4qhTHoZiIsrqXS_ZtV7zBg0wqv5MiV1KQJ0/s640/blog1.JPG" width="640" /></a></div>
<br />
<br />
I created a new spreadsheet, copy pasted my roster in column A, and used the importrange formula to bring the timestamp and goal from each individual grade reflection Goal sheet. For example:<br />
<br />
<span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; white-space: pre-wrap;">=</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; white-space: pre-wrap;">IMPORTRANGE</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; white-space: pre-wrap;">(</span><span class=" string " dir="auto" style="background-color: white; color: green; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; white-space: pre-wrap;">"https://docs.google.com/spreadsheets/d/180ZOz9vkPq20ZDKy3KJUN--gVpWP6TABFKzk-hSxW5Q/edit#gid=168726689"</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; white-space: pre-wrap;"> </span><span class=" string " dir="auto" style="background-color: white; color: green; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; white-space: pre-wrap;">"Goals!$A$3:$B$3"</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; white-space: pre-wrap;">)</span><br />
<br />
Where:<br />
<br />
<ul>
<li> <span style="background-color: white; color: green; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; white-space: pre-wrap;">https://docs.google.com/spreadsheets/d/180ZOz9vkPq20ZDKy3KJUN--gVpWP6TABFKzk-hSxW5Q/edit#gid=168726689" </span>is the URL of the individual grade sheet</li>
<li><span style="background-color: white; color: green; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; white-space: pre-wrap;">Goals</span> is the name of the sheet I am bringing over</li>
<li><span style="background-color: white; color: green; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; white-space: pre-wrap;">$A$3:$B$3</span> is the cell reference for time stamp and goal</li>
</ul>
<br />
Painstaking in that you do have to change each cell reference, but you only have to do this during set up. It is worth noting that when you do this the first time, you will probably get an error telling you that you need to grant permission. Just click on the cell and allow access. Also note that the sorting by timestamp was already done in their individual sheets as explained under Form Responses 2 in my <a href="http://www.teachingabovethetest.com/2019/01/reflective-students-with-google-forms.html">previous post</a>.<br />
<br />
<h4>
Automatically assign XP for goals</h4>
<div>
<i>This portion of the post assumes that you are already using spreadsheets to house your leaderboard, and works with any version you may have created. If you are looking for one, I offer <a href="http://www.teachingabovethetest.com/2017/12/leaderboard-and-badging-with-google.html">mine</a>, <a href="https://www.mrmatera.com/shop-1/digital-leaderboard-control-center">Mr. Matera's</a> or <a href="http://www.techedupteacher.com/gamify-your-class-level-ii-leaderboards/">Mr. Powley's</a>.</i></div>
<div>
<i><br /></i></div>
<div>
As we all know, the faster XP are show/given out, the better. This posed a problem for the assigning of XP for this activity since nothing would replace the student/teacher conferencing about their goals or the student actually reflecting on them. However, I figured that if I could at least give out points and badges for some measure of completion, I could always go back and make time for those conversations. As I toyed with how to do this, I thought about making sure that some specific words were included, but quickly gave up on that simply because my list of possibilities grew rather quickly. I settled instead for a simple word count and figured that 30 words at a minimum per goal are sufficient. Letting Google spreadsheets do the work for me, I added a hidden spreadsheet to the <a href="https://docs.google.com/spreadsheets/d/1sczeVn_ZWBN4iwIy0n5BLvAAC6alGYQZ54eTJy2lGos/edit#gid=39498175">grade reflection spreadsheet template</a> I shared before. When you make your own copy of that document, simply unhide it</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1hBsdkCiM10IerLauzZoPT_-OFO7l4iue9ENihBBmrBTpFuKz0V539gzWspAlxAoFL8Xls-KMiqtx7tSof38Jsq9n_cKATmcun5140ttNvFBDDdEuqy-R84cMpbSclrTN5QPqL-wkgq4/s1600/copy9.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="480" data-original-width="720" height="266" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1hBsdkCiM10IerLauzZoPT_-OFO7l4iue9ENihBBmrBTpFuKz0V539gzWspAlxAoFL8Xls-KMiqtx7tSof38Jsq9n_cKATmcun5140ttNvFBDDdEuqy-R84cMpbSclrTN5QPqL-wkgq4/s400/copy9.gif" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
As displayed when unhidden, this sheet is simply the place where the counting and calculation of XP happens and can be modified to suit your needs.</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEil9LgWp5dQIwDj3G1WVXqC3hPh_XCE0TiWu5mV5jTKBVds8ZRTtgm5H5xEmbPiiWHq-G5-1BpbHDNngqaQa5RZQwkvqzkoB0tste7OyjzFRUEunxb43InyQM2FZGfdHwK3H1E-7hEAk1s/s1600/blog1.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="233" data-original-width="564" height="165" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEil9LgWp5dQIwDj3G1WVXqC3hPh_XCE0TiWu5mV5jTKBVds8ZRTtgm5H5xEmbPiiWHq-G5-1BpbHDNngqaQa5RZQwkvqzkoB0tste7OyjzFRUEunxb43InyQM2FZGfdHwK3H1E-7hEAk1s/s400/blog1.JPG" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
With that in place, it is back to the leaderboard page, where you would need to decide where you would like to maintain the information and when to assign badges. </div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
The formula used to bring the XP from the student grade reflection sheet to the corresponding cell in your leaderboard is:</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; white-space: pre-wrap;">=</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; white-space: pre-wrap;">IMPORTRANGE</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; white-space: pre-wrap;">(</span><span class=" string " dir="auto" style="background-color: white; color: green; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; white-space: pre-wrap;">"https://docs.google.com/spreadsheets/d/180ZOz9vkPq20ZDKy3KJUN--gVpWP6TABFKzk-hSxW5Q/edit#gid=168726689"</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; white-space: pre-wrap;"> </span><span class=" string " dir="auto" style="background-color: white; color: green; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; white-space: pre-wrap;">"Wordcount!C2"</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; white-space: pre-wrap;">)</span></div>
<br />As before, each spreadsheet reference is unique to the student grade reflection sheet, so it needs to be manually changed and the spreadsheets need to be linked.<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDbVRzHd14cb5btOo4CRnD2l7N2cGqrcNiz2y00IiTFg0D_JYpMRCEgIt_VqtEHP1SKhqy75-oz5hmO7EYHGSfdkXKXdt3XuWDKsk8sicG1F59fmQMumww2M38Cjx4ehOar8PPi0fWdsE/s1600/goals1.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="342" data-original-width="187" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDbVRzHd14cb5btOo4CRnD2l7N2cGqrcNiz2y00IiTFg0D_JYpMRCEgIt_VqtEHP1SKhqy75-oz5hmO7EYHGSfdkXKXdt3XuWDKsk8sicG1F59fmQMumww2M38Cjx4ehOar8PPi0fWdsE/s200/goals1.JPG" width="108" /></a></div>
<div>
<br /></div>
<div>
Finally, the awarding of badges is done using the techniques described in my <a href="http://www.teachingabovethetest.com/2017/12/leaderboard-and-badging-with-google.html">Leaderboard and Badges</a> post, using a conditional formula that awards badges according to the total points accumulated from the word count.</div>
<div>
<br /></div>
<div>
And the badges are displayed on the individual student sheets which feed from the leaderboard as <span id="goog_10512766"></span><span id="goog_10512767"></span><a href="http://www.teachingabovethetest.com/2018/06/individual-rank-sheets-google-sheets-to.html">explained in this post</a>.</div>
<div>
<br /></div>
<div>
In an ideal world, the badges would only be assigned if the student actually met the goal they set for themselves, but that is a conundrum that I have yet to solve. Perhaps you have some ideas?</div>
Mrs.Garciahttp://www.blogger.com/profile/16492613229969352064noreply@blogger.com0tag:blogger.com,1999:blog-8818419233796306494.post-41868284337769044652019-01-18T07:25:00.001-08:002019-01-19T08:05:46.655-08:00Reflective Students with Google Forms and Sheets<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFTxJPNRpldZQ7fxfTwEViuPIK80V9NiJ2pSW9htfqPiVdG4mmjcv8mVllT7a3NHqqSw1k-X0gbZI9O7RzzCWa-pKWjOhjUX95-GoMVbYbWxS3EkGrMvbpwtiY0sstWn_POAZNhx_ZFd8/s1600/abstract-arrows-asphalt-910299.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1067" data-original-width="1600" height="425" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFTxJPNRpldZQ7fxfTwEViuPIK80V9NiJ2pSW9htfqPiVdG4mmjcv8mVllT7a3NHqqSw1k-X0gbZI9O7RzzCWa-pKWjOhjUX95-GoMVbYbWxS3EkGrMvbpwtiY0sstWn_POAZNhx_ZFd8/s640/abstract-arrows-asphalt-910299.jpg" width="640" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
It is the end of the semester, and like most teachers, my colleagues and I are currently under the barrage of with last minute regrade requests that should have been taken care of months ago. Like you, we published grades in our LMS as assignments were due, and the students received feedback with full knowledge that their grades are fluid. We have been encouraging them to take action on the feedback, make corrections, additions, etc. We have had individual conferences, sent e-mails, and clarified, but still, some of them are surprised when they finally log on to look at their grades, and the inevitable "What can I do?" question pops up. At this point, the reply is, "Go do what I've been asking you to do all along."<br />
<br />
As we pondered this in our last PLC meeting, we figured that one of the issues our students have is that not only are they not looking at our LMS consistently, they are not opening the rubrics and comments left on their assignments. By the same token, they are not thinking about the work habits they are cultivating and forget about any type of goal setting related to their work or performance. The question then became, how can we set up a routine that will allow our students to do all of this consistently.<br />
<div>
<br /></div>
<div>
<a href="https://twitter.com/judyzaccheo">@judyzaccheo</a> shared her use of <a href="https://www.sowntogrow.com/">Sown to Grow</a>, a platform whose goal is to "Empower students to set goals, reflect on strategies, and learn how to learn.". While it looks awesome and an easy way to address these issues, if you have been here before, you know that:</div>
<div>
<br /></div>
<div>
1. I do not have the funds to pay for stuff like that ( even if it is inexpensive), and </div>
<div>
2. I do not like to use platforms that cannot "move" with the students. (I like to use things that my students can keep using even after they have left my class).</div>
<div>
<br /></div>
<div>
So, I spent the last few days coming up with a solution, and along the way, I learned some things about how to allow anyone to make a copy of a Google form, automatically sort form responses by timestamp so that the latest shows on top, and forgo creating charts within a spreadsheet using a sparkline instead. </div>
<div>
<br /></div>
<div>
Before we get into the how-to, let me show you the final product.</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhCX-qJ6rQ9rcPjlM6GChbUoP4GIWMWxOw2a5v8ks5Kxd_Hr8ES1IE5UZXHo1Uzr664CSEJYLaphT0KO7GmWe8wLGYJ9gE2j6gaR9ItEVLDarKf7SPDJYVM8dfv8ZwYG2muFVIrToj1ek8/s1600/blog2.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="440" data-original-width="611" height="230" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhCX-qJ6rQ9rcPjlM6GChbUoP4GIWMWxOw2a5v8ks5Kxd_Hr8ES1IE5UZXHo1Uzr664CSEJYLaphT0KO7GmWe8wLGYJ9gE2j6gaR9ItEVLDarKf7SPDJYVM8dfv8ZwYG2muFVIrToj1ek8/s320/blog2.JPG" width="320" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
We start off with a traditional Google form. The form is divided into sections that allow students to input their grades for each subject, discuss what made them successful (or not) in each class, and set a goal for the next week.</div>
<div>
<br /></div>
<div>
</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
This feeds into a spreadsheet that then organizes the information so that the latest goal and information is at the top. I figured that if we are doing this every week and things populated at the bottom, the students would never scroll down to find the latest entry. This is also why I needed the "Goals" sheet as the landing sheet. They need to see, front and center what they said they were going to do.</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHobk6UB5FIc3U4dN7s2XL32NEFQ3Daciv5XoY80Ap2shjANbQ1OpTYfAZV5xeDuYfeiIKR-G-d7xZjU_wWlP2cvP2NwhGut1VYwCRXzzYISB8DafjN81hEMOlDKCK5jmISflWwqK1qiY/s1600/blog1.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="621" data-original-width="1053" height="376" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHobk6UB5FIc3U4dN7s2XL32NEFQ3Daciv5XoY80Ap2shjANbQ1OpTYfAZV5xeDuYfeiIKR-G-d7xZjU_wWlP2cvP2NwhGut1VYwCRXzzYISB8DafjN81hEMOlDKCK5jmISflWwqK1qiY/s640/blog1.JPG" width="640" /></a></div>
<div>
<br /></div>
<div>
Finally the "Content Area" sheets, where students can see their grade trends, and notice when their grade changed, and the work habits that led to those grades.</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhxD4xtcgWp7epcYCkw6WLNrQrHO33BeQPwT-aZOn6ZD2m5nIZtOutpF8thDpIzQt0DlaJVxbnJOtofWLcz6D9ZjOePqg6fQFh_KQjE9MdsILlMvspmT_iFDHMsdySOEQGq7sIaT9dhMNc/s1600/blog3.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="465" data-original-width="1236" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhxD4xtcgWp7epcYCkw6WLNrQrHO33BeQPwT-aZOn6ZD2m5nIZtOutpF8thDpIzQt0DlaJVxbnJOtofWLcz6D9ZjOePqg6fQFh_KQjE9MdsILlMvspmT_iFDHMsdySOEQGq7sIaT9dhMNc/s640/blog3.JPG" width="640" /></a></div>
<div>
<br /></div>
<div>
Hopefully, you are still with me as I share just how to do this. First off, I started with the creation of a Folder with "Anyone with the link can view" permissions that would house both the master spreadsheet and form. This step is important when sharing the forced copy of the form.</div>
<h3>
</h3>
<h3>
</h3>
<h3>
Copy of a Google Form. </h3>
<div>
In the past, I've shared <a href="https://alicekeeler.com/2017/01/02/5-steps-sharing-copy-google-form/">copies with teachers</a> by simply having them create copies of the spreadsheet linked to it. I tried to do the same with the students, first by making them copies in Google classroom and when that didn't work forcing a copy of a link I sent them. For some reason, this does not work when working with student accounts! Even when the Form button appears, once students click on it ends up creating a blank form. Yup, you guessed it, spent a class period with my pilot class trying to troubleshoot with them and then the bell rang... After some digging that still did not explain why it would not work, I came across <a href="https://msdrasby.com/2016/07/15/google-forms-force-a-copy/">Mrs. Drasby's post</a>. Following her instructions, I was able to create a link that would force that copy of the actual form for my students. That was all fine, but now I had to walk my students through recreating the spreadsheet with all that sorting and tabs that I had painstakingly created.</div>
<h3>
</h3>
<h3>
</h3>
<h3>
Copy of the Spreadsheet </h3>
<div>
While some of my students would jump at the idea of working with the different formulas and conditional formatting that make the spreadsheet work, I know that for many it would end up in frustration and me running around "fixing" it. So instead I <a href="https://docs.google.com/presentation/d/1cW95L5IwYWg0FVw6jM1UklE4sN2Hpzq3vYUomkqcZ3U/edit?usp=sharing">created instructions</a> that would allow the students to copy each of the sheets from my master with minimal possibility of error. </div>
<div>
<br /></div>
<div>
<iframe allowfullscreen="true" frameborder="0" height="299" mozallowfullscreen="true" src="https://docs.google.com/presentation/d/e/2PACX-1vRQri86OlE61K5cd2odVVRml6AOSWBzdcJR62cC5yybUNG3MtawKba98oQ98DGx2-V7mXQoh8zUKsEE/embed?start=false&loop=false&delayms=3000" webkitallowfullscreen="true" width="480"></iframe>
</div>
<div>
<br />
Note, these start off with the copying of the form. Once the students had their personal forms and sheets, it was simply a matter of having them submit their sheets to me in Google classroom so I would have them all for an easy looking into.<br />
<h3>
</h3>
<h3>
</h3>
<h3>
How the spreadsheet works</h3>
While I have shared my form, spreadsheet and instructions in this <a href="https://drive.google.com/drive/folders/1GrSIXt3JDgR9g3UoKzQe1tdLh4mQzYYh?usp=sharing"><b>folder</b></a> for you to use "as is", I am under no illusion that it suits your needs perfectly. So a little explanation that would allow you to recreate or modify is in order. I do recommend that when you make your own copies, you house them in a folder with "Anyone with the link can view" permissions to ensure that you do not run into problems when students copy your form. Anyway...<br />
<h4>
</h4>
<h4>
</h4>
<h4>
Form Responses 1</h4>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTjGMpxlWShyphenhyphenXaKDMvOvv5wYlZmbgNEVnH5MTf99Jx1UZsqixL1O1DoWaJTCG48IVKa5Eu3EVK0hSYt9mO5HzJY6v5osldfHc8qQKdBTeux09FvMCdEW0g__YdQHmsMbZcNKiYFIuT_oo/s1600/blog2.JPG" imageanchor="1" style="display: inline !important; margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" data-original-height="620" data-original-width="457" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTjGMpxlWShyphenhyphenXaKDMvOvv5wYlZmbgNEVnH5MTf99Jx1UZsqixL1O1DoWaJTCG48IVKa5Eu3EVK0hSYt9mO5HzJY6v5osldfHc8qQKdBTeux09FvMCdEW0g__YdQHmsMbZcNKiYFIuT_oo/s320/blog2.JPG" width="233" /></a></div>
<br />
<br />
<br />
This is simply the sheet created by the form. Notice the purple box indicating that it is linked.<br />
<h4>
</h4>
<h4>
</h4>
<h4>
Form Responses 2</h4>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipXZR-M8D78fNOd4-qvvctmRJd3nMp7GB0WWjbRN4HVCH7Qi3Ur8VlhYp3JPa1whr5s4fuWR9Z03W8eukvCpE4shp34kHkeJU2tQMfPgc8pHwInIfT1pCJ6LUEAmGOzw_cBxyc3uc41j4/s1600/blog3.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="623" data-original-width="430" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipXZR-M8D78fNOd4-qvvctmRJd3nMp7GB0WWjbRN4HVCH7Qi3Ur8VlhYp3JPa1whr5s4fuWR9Z03W8eukvCpE4shp34kHkeJU2tQMfPgc8pHwInIfT1pCJ6LUEAmGOzw_cBxyc3uc41j4/s320/blog3.JPG" width="220" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
This sheet sorts the responses from Form Responses 1 in ascending order. The only thing it actually contains is this formula in cell A1.<br />
<div style="text-align: center;">
<span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">=</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">sort</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">(</span><span dir="auto" style="background-color: white; color: #f7981d; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">'Form Responses 1'!A:O</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;"> </span><span class="number" dir="auto" style="background-color: white; color: #1155cc; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">1</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class="number" dir="auto" style="background-color: white; color: #1155cc; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">0</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">)</span></div>
If your form has more or fewer cells than A:O, simply change the cell reference.<br />
<h4>
</h4>
<h4>
</h4>
<h4>
Goals sheet</h4>
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJ6zOqu1coyzbA7uNYRnSG2tWextwlN-aGZ-9yCSctNH6K-A2BOVBal1C-zqipj66hX0woqMR9SXv8CoPJsM316vHdyl5Pr2hNwdQ5dIDe7t1cDftsa5GZpeJVSzGDuDwem868IxPpOew/s1600/blog4.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="491" data-original-width="1311" height="236" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJ6zOqu1coyzbA7uNYRnSG2tWextwlN-aGZ-9yCSctNH6K-A2BOVBal1C-zqipj66hX0woqMR9SXv8CoPJsM316vHdyl5Pr2hNwdQ5dIDe7t1cDftsa5GZpeJVSzGDuDwem868IxPpOew/s640/blog4.JPG" width="640" /></a></div>
<div>
<br /></div>
<div>
This sheet brings up the responses from the Goals column from the sorted Forms Responses 2, using</div>
<div>
<br /></div>
<div>
<span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">=</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">ARRAYFORMULA</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">(</span><span dir="auto" style="background-color: white; color: #f7981d; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">'Form Responses 2'!A1:A</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">) </span>in cell A2 to bring up the timestamp in column A</div>
<div>
<span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">=</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">ARRAYFORMULA</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">(</span><span dir="auto" style="background-color: white; color: #f7981d; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">'Form Responses 2'!O:O</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">) </span>in cell B2 to bring up the goals typed in from column O</div>
<div>
<br /></div>
<div>
Column B has a set of conditional formatting color-coding the responses when they include the content area names. Here the idea was that students can look at how frequently they make a goal for a specific class and reflect on whether they are meeting their goal or not.</div>
<h4>
</h4>
<h4>
</h4>
<h4>
Content Area Sheets</h4>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjjkp7JokjPA4I72_52OGiT3EK03caCTWuEMDzIrj7NG8qyKmBDtVmthaQzmKEJl2eo4MT7oplQtmKFUCFbWg5mtM2dU0OP2Itt81RQyzmI1BexbMhqsaMY5CZUqSdibLuT4vDdNGGirk0/s1600/blog5.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="590" data-original-width="1317" height="284" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjjkp7JokjPA4I72_52OGiT3EK03caCTWuEMDzIrj7NG8qyKmBDtVmthaQzmKEJl2eo4MT7oplQtmKFUCFbWg5mtM2dU0OP2Itt81RQyzmI1BexbMhqsaMY5CZUqSdibLuT4vDdNGGirk0/s640/blog5.JPG" width="640" /></a></div>
<div>
<br /></div>
<div>
Bring up the grades reported for each class to its corresponding sheet along with the "what made you successful or not answer. In each, the only thing that changes is the cell references. </div>
<div>
<br /></div>
<div>
<span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">=</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">ARRAYFORMULA</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">(</span><span dir="auto" style="background-color: white; color: #f7981d; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">'Form Responses 2'!A1:A</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">) </span>in cell A2 to bring up the timestamp in column A</div>
<div>
<span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">=</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">ARRAYFORMULA</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">(</span><span dir="auto" style="background-color: white; color: #f7981d; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">'Form Responses 2'!H:I</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">) </span>in cell B2 to bring up the grade and comment, which have adjoining columns, in this case, cells from column H and I. </div>
<div>
<br /></div>
<div>
Column B in these sheets has conditional formatting as a visual for students to notice when their grades for a class dip or move up and reflect on the habits that took them there.</div>
<div>
<br /></div>
<div>
Finally, these sheets also contain a <a href="https://support.google.com/docs/answer/3093289?hl=en">sparkline formula</a> that creates the added "graph":</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-UV3oF843udPoMzsXmUSQUarqTi3MyhBw0buXa9OGb8_G9-NAZ_ibjSQj6_gQDfqHPiwkpmwg2FIV0Dfqa6GElWT9_MB4eFAQpsoTw8hoigr1yNu50bICi5WaY7q1IrNfnFzvbxaZ-Ls/s1600/blog6.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="182" data-original-width="347" height="167" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-UV3oF843udPoMzsXmUSQUarqTi3MyhBw0buXa9OGb8_G9-NAZ_ibjSQj6_gQDfqHPiwkpmwg2FIV0Dfqa6GElWT9_MB4eFAQpsoTw8hoigr1yNu50bICi5WaY7q1IrNfnFzvbxaZ-Ls/s320/blog6.JPG" width="320" /></a></div>
<div>
I toyed with the idea of adding an actual chart, which you could still do. Since it was really an added visual to show quick trends I opted for a sparkline. The one I used is</div>
<div>
<span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">=</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">SPARKLINE</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">(</span><span dir="auto" style="background-color: white; color: #f7981d; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">B3:B</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;"> </span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">{</span><span class=" string " dir="auto" style="background-color: white; color: green; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">"charttype"</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class=" string " dir="auto" style="background-color: white; color: green; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">"column"</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">;</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;"> </span><span class=" string " dir="auto" style="background-color: white; color: green; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">"axis"</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;"> </span><span class="boolean" dir="auto" style="background-color: white; color: #1155cc; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">true</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">;</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;"> </span><span class=" string " dir="auto" style="background-color: white; color: green; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">"axiscolor"</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;"> </span><span class=" string " dir="auto" style="background-color: white; color: green; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">"red"</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">}</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">) - </span>Using the information now housed in column B, but you could change it up with any of the other versions found in this <a href="https://support.google.com/docs/answer/3093289?hl=en">support article</a> from Google.</div>
<h3>
</h3>
<h3>
</h3>
<h3>
Using this with students</h3>
<div>
I basically just rolled this out a couple of days ago. The intention is that students will input answers in their forms weekly, during class time, giving them a moment to stop and reflect on how they are doing. I know, from the examples submitted that we definitely have work to do in the goal-setting department, but my hope is that with instruction, consistency, and practice we will finally get rid of those last minute "What can I do to bring my grade up?" requests. I am also thinking that it is a great resource to have at parent conferences and SSTs. It even helps address ISTE standard for students 1a "Students articulate and set personal learning goals, develop strategies leveraging technology to achieve them and reflect on the learning process itself to improve learning outcomes".<br />
<br />
What do you think?</div>
Mrs.Garciahttp://www.blogger.com/profile/16492613229969352064noreply@blogger.com0tag:blogger.com,1999:blog-8818419233796306494.post-14378281019420964072018-11-23T15:29:00.000-08:002018-11-27T06:18:11.317-08:00Drag and drop with Google Draw and Slides<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgV3gkMrhCmoQ4XBEMHabk36VDHKx8SuqsRf6w7tEukwBvPS38i0IRYKCg2x2HDi85S_7tDxnuadZylK6diYse9pc2xcFcPkuiYcWqcsujAfq1t0M0QRHsR2YCQqV0eKoIq9T9AIZDa7F4/s1600/food.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="522" data-original-width="653" height="318" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgV3gkMrhCmoQ4XBEMHabk36VDHKx8SuqsRf6w7tEukwBvPS38i0IRYKCg2x2HDi85S_7tDxnuadZylK6diYse9pc2xcFcPkuiYcWqcsujAfq1t0M0QRHsR2YCQqV0eKoIq9T9AIZDa7F4/s400/food.JPG" width="400" /></a></div>
<br />
<br />
This morning, as I was looking over my upcoming lessons on analyzing webs I found out that the app I used to create drag and drop assignments is no more. Since before we get deeper into what happens in a food web when the population of an organism decreases or increases I need to be sure that my students are able to track the different food chains within a web, and we have been struggling with what is known in my classroom as "the arrows mean something", this was not a step I was willing to simply forgo. So I turned to the trusty internet for something already made. As I was inputting different search parameters I stumbled upon Matt Miller's "<a href="https://youtu.be/K6aAU1rWuOw" target="_blank">Creating moveable digital activities with Google Drawings + Slides</a>". I watched the first part and, being a Google Drawing fan I went ahead and created my drawing, stacking multiples of the same text boxes as needed by simply copy/pasting them on top of each other and placing them as a stack on top of an "empty" box.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhk7QyZDHFUT6Hj3f1_-VutdbmPFm2CYK6MkSdMw0ZyByfub-Pxk6ADj8xEEx1SZRbw9UmX_qOUFBHq9vJMWDKgZSCHQWVKRiXCYiqisj0u3BQmAVB31QZgUzsi3_XWnL1L2qfEYvw3qDk/s1600/dragndrop.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="480" data-original-width="720" height="266" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhk7QyZDHFUT6Hj3f1_-VutdbmPFm2CYK6MkSdMw0ZyByfub-Pxk6ADj8xEEx1SZRbw9UmX_qOUFBHq9vJMWDKgZSCHQWVKRiXCYiqisj0u3BQmAVB31QZgUzsi3_XWnL1L2qfEYvw3qDk/s400/dragndrop.gif" width="400" /></a></div>
<br />
<br />
I felt rather pleased with myself and called my daughter to try it out. Dutifully she did, and immediately two super important things became evident:<br />
<br />
1. I needed to be able to lock the background<br />
<blockquote class="tr_bq">
After another round of searching and watching Matt's whole video, I found out that while you cannot lock the background on Google Drawing, you can set an image as a background on Google Slides. </blockquote>
2. I also needed to be able to "lock" the text the students were dragging so they could not modify it accidentally.<br />
<blockquote class="tr_bq">
Instead of adding them as text boxes, I created the text and used the snipping tool to create them as images. While they can still be deleted as a "block" the content cannot be modified.</blockquote>
I am sharing the <a href="https://docs.google.com/presentation/d/18zAOzTckyHerPBaN-ndvIAmOlvXup8xkdktGYjiIZJU/copy" target="_blank">student template</a> to give you an idea of what you can do.<br />
<br />
I then started thinking, what else could we do with this? I love the idea of the drag and drop but also wanted this to be a little more challenging. Inspiration struck as I moved on to a different grade level, where I decided that students could use the traditional labeling assignment as a drag and drop that leads to a presentation. Using the same technique as before, but adding links to blank slides students could do more than just a simple labeling assignment.<br />
<br />
For example, in <a href="https://docs.google.com/presentation/d/19VC9_QcYtF6gjM5UQtqQBQbM3SmjOCHy6HjfhlYMGW8/copy" target="_blank">this assignment</a> where students will be asked to label a plant and an animal cell and use that as a springboard to create a presentation detailing organelle functions.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhrynwyykp-iX2PjX17ayJfHCByOENQcQo2t4pXnOom_vxkJZ8qsxynOdvdIsL1W8t_9Q9igj1-cT4a31lo5DNGLR3pCr23UtkUPYvCkTQgYG41GVyWTZgZex-CmIiHFmS4aqZqcMvVg9g/s1600/celldd.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="480" data-original-width="720" height="213" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhrynwyykp-iX2PjX17ayJfHCByOENQcQo2t4pXnOom_vxkJZ8qsxynOdvdIsL1W8t_9Q9igj1-cT4a31lo5DNGLR3pCr23UtkUPYvCkTQgYG41GVyWTZgZex-CmIiHFmS4aqZqcMvVg9g/s320/celldd.gif" width="320" /></a></div>
<br />
What do you think? What other uses of the drag and drop do you see yourself creating?<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<br />
<br />
<br />Mrs.Garciahttp://www.blogger.com/profile/16492613229969352064noreply@blogger.com0tag:blogger.com,1999:blog-8818419233796306494.post-52305045130635796612018-11-20T19:36:00.000-08:002018-11-21T05:51:42.882-08:00First Perfect Hit - The Match Function<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKo42EChYfVzLnApdzZQeWHWI-uYE5ePg5SHp0DUUyZ5bDezo8MV602oNmn_8xZQPPXABjI4Gm3iVprIlA1KovGsv9nKUpYf6ruFfA4EMV-Z7AqxxkOPH-HwX1Ocj_TzckDa0dqZKoypA/s1600/boss2.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="481" data-original-width="597" height="514" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKo42EChYfVzLnApdzZQeWHWI-uYE5ePg5SHp0DUUyZ5bDezo8MV602oNmn_8xZQPPXABjI4Gm3iVprIlA1KovGsv9nKUpYf6ruFfA4EMV-Z7AqxxkOPH-HwX1Ocj_TzckDa0dqZKoypA/s640/boss2.JPG" width="640" /></a></div>
<br />
A couple of months ago I shared with you how to create <a href="http://www.teachingabovethetest.com/2018/06/boss-battles-with-google-formssheets.html" target="_blank">Boss Battles using Google Forms and Sheets</a> and <a href="http://www.teachingabovethetest.com/2018/06/assign-xp-automatically-using-vlookup.html" target="_blank">assign XP automatically u</a><a href="http://www.teachingabovethetest.com/2018/06/assign-xp-automatically-using-vlookup.html" target="_blank">sing the Vlookup function</a>. I spent most of my summer creating all the Boss Battles I intended to use this school year and tweaking my <a href="http://www.teachingabovethetest.com/2018/06/individual-rank-sheets-google-sheets-to.html" target="_blank">individual student sheets</a> so that if a student scored a "perfect" hit on the boss they would capture it and add it to their collection.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyW9clWiL2YDOuNSUQGlZ5SNE3dFaZ2-1bimK7BUEYLUjVRudvBEtWNa7oyvzYYoRIep7xM3BjMYDNnc4EngCDeuMLAXn0p_8cqGc1M1tdRYUgf8Ay5WKTm6EkeDSTQwdijDsVMSWhcxY/s1600/boss.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="486" data-original-width="660" height="293" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyW9clWiL2YDOuNSUQGlZ5SNE3dFaZ2-1bimK7BUEYLUjVRudvBEtWNa7oyvzYYoRIep7xM3BjMYDNnc4EngCDeuMLAXn0p_8cqGc1M1tdRYUgf8Ay5WKTm6EkeDSTQwdijDsVMSWhcxY/s400/boss.JPG" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
The response of my students to this whole idea has been very encouraging. They actually look forward to Boss Battle days, literally rushing to class to participate in what you and I would actually call a testing day. However, there were a couple of little nagging issues that my more hardcore gamers immediately asked for: Extra XP for "first hit" and/or for "first perfect hit". Apparently, this is a "thing", and while they were satisfied with my answer at the time "Don't know how to do that other than scouring the sheet, which I do not want to do. If you figure it out, we can implement it", it stayed in the back of my head. </div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
A couple of days ago, I once again sat down to try to figure it out, and it finally crystallized.</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhy1WI0ZrveaLN6m_QZLrvRkj1WPTFi4amXNmSJo3Dp3VCRMJ293LmpHHoxbn4SLalpTbHvPdoTUCoGNaw1SmWEobXwWgI5z91cGVBvpIk5IKOwUhOXYGlgX4iRqXKa_qz2OyFFNgv1eos/s1600/boss.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="618" data-original-width="835" height="295" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhy1WI0ZrveaLN6m_QZLrvRkj1WPTFi4amXNmSJo3Dp3VCRMJ293LmpHHoxbn4SLalpTbHvPdoTUCoGNaw1SmWEobXwWgI5z91cGVBvpIk5IKOwUhOXYGlgX4iRqXKa_qz2OyFFNgv1eos/s400/boss.JPG" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
On one of my existing <a href="https://docs.google.com/spreadsheets/d/1ZPV5dZG7usTDSsle-A_EU_t023ovILzU3J-2l2bRVXk/copy" target="_blank">Boss Battle Sheets</a> I added:</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
- First hit: Easy, since you only need to bring up the first entry on the form</div>
<blockquote class="tr_bq" style="clear: both; text-align: left;">
<span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">=</span><span dir="auto" style="background-color: white; color: #f7981d; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">'Form Responses 1'!$B$2</span></blockquote>
- First perfect hit: This formula looks up the e-mail of the student Form Responses sheet (column B) and returns the value found in column C when it equals 10 (the perfect score for this Boss battle). Once it finds the first one, it stops.<br />
<blockquote class="tr_bq">
<span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">=</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">index</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">(</span><span dir="auto" style="background-color: white; color: #f7981d; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">'Form Responses 1'!B:B</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;"> </span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">match</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">(</span><span class="boolean" dir="auto" style="background-color: white; color: #1155cc; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">true</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;"> </span><span dir="auto" style="background-color: white; color: #7e3794; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">'Form Responses 1'!C:C</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">=</span><span class="number" dir="auto" style="background-color: white; color: #1155cc; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">10</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;"> </span><span class="number" dir="auto" style="background-color: white; color: #1155cc; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">0</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">)</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">)</span> </blockquote>
These two formulas made the students happy since at least they now had the "bragging rights". The addition of extra XP for those two instances can be done manually, or by adding a "Perfect" sheet to your BossBattle (as in the example), where you again report those two values and input whatever XP you wish for them. You can then use the Vlookup function explained in my <a href="http://www.teachingabovethetest.com/2018/06/assign-xp-automatically-using-vlookup.html" target="_blank">previous post</a> to have Google sheets find the value for you. That formula in your leaderboard would look something like:<br />
<blockquote class="tr_bq">
<span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">=</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">IFERROR</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">(</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">VLOOKUP</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">(</span><span dir="auto" style="background-color: white; color: #f7981d; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">A2</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">IMPORTRANGE</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">(</span><span class=" string " dir="auto" style="background-color: white; color: green; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">"GoogleSheetID"</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class=" string " dir="auto" style="background-color: white; color: green; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">"Perfect!A:B"</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">)</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class="number" dir="auto" style="background-color: white; color: #1155cc; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">2</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class="number" dir="auto" style="background-color: white; color: #1155cc; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">0</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">)</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">,</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;"> </span><span class="number" dir="auto" style="background-color: white; color: #1155cc; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">0</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: "inconsolata" , monospace , "arial" , "sans" , sans-serif; font-size: 14px; white-space: pre-wrap;">)</span></blockquote>
I now have to add those formulas to all my Boss Battles, but I know that it will be a nice surprise when we come back from break. What about you, any other tweaks to share?Mrs.Garciahttp://www.blogger.com/profile/16492613229969352064noreply@blogger.com0tag:blogger.com,1999:blog-8818419233796306494.post-58681887146468410152018-11-10T14:39:00.000-08:002018-11-10T14:40:00.028-08:00Five ways to use Pop-ups<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuq1OX6uVOIcMvYdjlTCWJCPP19KEwrT8IlNfD6rInDacMn8wQ7Q8F71mM7UwdN4ceXiyASsScRFKWlk48PHWW34UuFWGE0gdYq7Ale1QIFTd2qyex59Qy5TNs2rNreRi-Xn9ylOIV1is/s1600/pop1.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="269" data-original-width="582" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuq1OX6uVOIcMvYdjlTCWJCPP19KEwrT8IlNfD6rInDacMn8wQ7Q8F71mM7UwdN4ceXiyASsScRFKWlk48PHWW34UuFWGE0gdYq7Ale1QIFTd2qyex59Qy5TNs2rNreRi-Xn9ylOIV1is/s1600/pop1.JPG" /></a></div>
<br />
<br />
A couple of days ago, <a href="https://twitter.com/JakeMillerTech">@JakeMillerTech</a> posted a way to create a pop-up window on Google Docs.<br />
<blockquote class="twitter-tweet" data-lang="en">
<div dir="ltr" lang="en">
When you see the phrase "Code a popup message for your <a href="https://twitter.com/hashtag/GoogleDocs?src=hash&ref_src=twsrc%5Etfw">#GoogleDocs</a>" it sounds really complex š¤, but it's not. Watch, I can do it in a ~40 second ā³ <a href="https://twitter.com/hashtag/EduGIF?src=hash&ref_src=twsrc%5Etfw">#EduGIF</a>: <a href="https://twitter.com/hashtag/elearning?src=hash&ref_src=twsrc%5Etfw">#elearning</a> <a href="https://twitter.com/hashtag/21stedchat?src=hash&ref_src=twsrc%5Etfw">#21stedchat</a> <a href="https://twitter.com/hashtag/21stcenturyskills?src=hash&ref_src=twsrc%5Etfw">#21stcenturyskills</a> <a href="https://twitter.com/hashtag/hyperdoc?src=hash&ref_src=twsrc%5Etfw">#hyperdoc</a> <a href="https://t.co/Rxo5vmcNLX">https://t.co/Rxo5vmcNLX</a> <a href="https://t.co/rDMRBSMb81">pic.twitter.com/rDMRBSMb81</a></div>
ā Jake Miller (@JakeMillerTech) <a href="https://twitter.com/JakeMillerTech/status/1059900823814180864?ref_src=twsrc%5Etfw">November 6, 2018</a></blockquote>
I was intrigued by the idea, especially after a couple of messages back and forth with Jake and <a href="https://twitter.com/dyerksjr1">@dyerksjr1 </a> revealed that even with the "must be editor of the document" limitation, it could work via Google Classroom using the create a copy for each student and insert "from Drive" options (<a href="https://docs.google.com/document/d/1u-oj9dTHjeRYrnHTms3p61lH-4tY0yYzpr634z3kUiA/copy?copyScriptEditor=true" target="_blank">link</a>). So I set about finding out whether you could include links, change fonts, add images (not just emojis), etc. Two frustrating days later, it dawned on me that I've never seen these kinds of adjustments on Google's actual pop-ups, so while I still have hope that it perhaps can be done, I instead changed my focus to what I could use the pop-up idea for.<br />
<div>
<script async="" charset="utf-8" src="https://platform.twitter.com/widgets.js"></script>
</div>
<div>
<br /></div>
So let's start by referencing Jake's original post <a href="http://jakemiller.net/docspopup/" target="_blank">"Add a Popup Message to your Google Docs"</a>, where he provides step by step instructions on how to add the code to your document.<br />
<div>
<br /></div>
<div>
The code for a Google doc is:</div>
<div>
<blockquote class="tr_bq">
function onOpen() {<b>Document</b>App.getUi().alert(<head> "insert your message here" </head>)}</blockquote>
<div>
If you would like to add to Slides instead, you would use:</div>
</div>
<div>
<blockquote class="tr_bq">
function onOpen() {<b>Slides</b>App.getUi().alert(<head> "insert your message here" </head>)}</blockquote>
</div>
<div>
and for Sheets, well:</div>
<div>
<blockquote class="tr_bq">
function onOpen() {<b>Spreadsheet</b>App.getUi().alert(<head> "insert your message here" </head>)}</blockquote>
</div>
<div>
With that out of the way, it is time to have some fun and think of ways of using it:<br />
<br />
1. Reminders:<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDglqcHZLIxD7G_Ex8E7a03hA7M2Ud32yc45xKGcLWrr53HXS3Kk7s0Rnr0sUwHRgDISq6aaoiZ0WWSQIcfQ-mlqLqZxcrHyKACiJs3mcWUTKdBE8k6STKVZLyANqeRMaYiPI9UvMtR-8/s1600/pop1.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="250" data-original-width="548" height="181" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDglqcHZLIxD7G_Ex8E7a03hA7M2Ud32yc45xKGcLWrr53HXS3Kk7s0Rnr0sUwHRgDISq6aaoiZ0WWSQIcfQ-mlqLqZxcrHyKACiJs3mcWUTKdBE8k6STKVZLyANqeRMaYiPI9UvMtR-8/s400/pop1.JPG" width="400" /></a></div>
<br />
<br />
2. Provide links: Although the link itself will not work, students can always copy/paste it:<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDZ4kx7uk1rC5QfJ581wr35W8JNjC2k6GCwHCUpRsJt9eaAxQde7sttDlO3lNylzk-jKRhzKAQozYHdTO1gOQoSa7t7OOshPKpCnw3MhloP_uaM8HYCA30liaR0ra8tJiW6LXfaaoaxKw/s1600/pop1.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="265" data-original-width="568" height="186" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDZ4kx7uk1rC5QfJ581wr35W8JNjC2k6GCwHCUpRsJt9eaAxQde7sttDlO3lNylzk-jKRhzKAQozYHdTO1gOQoSa7t7OOshPKpCnw3MhloP_uaM8HYCA30liaR0ra8tJiW6LXfaaoaxKw/s400/pop1.JPG" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
3. Give words of encouragement:</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjx-AVSts9cLZN31LI2TGOj9tlVlaa4N2cJA5h9_FKNffuICf8bsejcYqfwdGMER6bkKaL_y1-PmMusQj8k4Wma-f3pELsSBHqa28h6VOb-cpfQ8pWW7UgGujxLWKDF_eiS2hJO02aH3Wk/s1600/pop1.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="227" data-original-width="554" height="163" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjx-AVSts9cLZN31LI2TGOj9tlVlaa4N2cJA5h9_FKNffuICf8bsejcYqfwdGMER6bkKaL_y1-PmMusQj8k4Wma-f3pELsSBHqa28h6VOb-cpfQ8pWW7UgGujxLWKDF_eiS2hJO02aH3Wk/s400/pop1.JPG" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
If you do not mind a little extra work, you can even provide individual pop-ups or even chose only a couple of random or carefully selected students for whom the pop-up appears.</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
4. Provide hints in a <a href="https://www.breakoutedu.com/digital/" target="_blank">Break-out Edu</a> activity:</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgftpbQhbj6smp8t1A9GKnOFOSinyiDmemMWQ3MTa56wnv3Dn5uC2TV6x4BCHAoXEpPa_X_qlqpu6SG70GhnrVyQXObf3qcb4-pFy22FkSKGFZoFEw7xmewZ2wLsF0Wb81racZ220kSTnE/s1600/pop1.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="224" data-original-width="556" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgftpbQhbj6smp8t1A9GKnOFOSinyiDmemMWQ3MTa56wnv3Dn5uC2TV6x4BCHAoXEpPa_X_qlqpu6SG70GhnrVyQXObf3qcb4-pFy22FkSKGFZoFEw7xmewZ2wLsF0Wb81racZ220kSTnE/s400/pop1.JPG" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
5. In a gamified environment, perhaps even provide some hints about Easter Eggs. </div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgDrXy3mINEiV6C_1zpo4uxkQtGobtuOpybybnX3FgGEI6mG1-XXfcV8sP6q6LrnoZ0VXHaxl-eP9FdjwijzR9mMC3HKRNxDFXml6COznsI1BG42faCprRW2SQHvvyaVg-fTxZHNDYeiHo/s1600/pop1.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="244" data-original-width="540" height="180" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgDrXy3mINEiV6C_1zpo4uxkQtGobtuOpybybnX3FgGEI6mG1-XXfcV8sP6q6LrnoZ0VXHaxl-eP9FdjwijzR9mMC3HKRNxDFXml6COznsI1BG42faCprRW2SQHvvyaVg-fTxZHNDYeiHo/s400/pop1.JPG" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
I'm sure you can think of some other awesome uses, and if so inclined tell us about them in the comments.<br />
<br /></div>
<div>
Thank you <a href="https://twitter.com/JakeMillerTech">@JakeMillerTech</a> and <a href="https://twitter.com/dyerksjr1">@dyerksjr1</a> for teaching me about this fun addition to my teaching arsenal.</div>
<div>
<br /></div>
Mrs.Garciahttp://www.blogger.com/profile/16492613229969352064noreply@blogger.com0tag:blogger.com,1999:blog-8818419233796306494.post-8506984640014069852018-11-03T15:39:00.001-07:002018-11-03T17:58:40.303-07:00Collaborative Annotations Using Scrible<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKeowEaLGYy0O5G4-lnWZNe5djeLU6a6AkqVXMcljHvVjel3StM-OAH-KXJnXrATCChKp97jM8mPVwBs5O9ez_zMrJyUHJb52qik391u02W88CxHQgyLznRTh6DldblPftVdq_4-nwfOE/s1600/book+annotation+2.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="450" data-original-width="600" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKeowEaLGYy0O5G4-lnWZNe5djeLU6a6AkqVXMcljHvVjel3StM-OAH-KXJnXrATCChKp97jM8mPVwBs5O9ez_zMrJyUHJb52qik391u02W88CxHQgyLznRTh6DldblPftVdq_4-nwfOE/s320/book+annotation+2.png" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><a href="https://www.murrieta.k12.ca.us/cms/lib/CA01000508/Centricity/ModuleInstance/36324/large/book%20annotation%202.png?rnd=0.612180663092146" target="_blank">Book annotation 2</a> by <a href="https://www.murrieta.k12.ca.us/Page/30339" target="_blank">Katherine Stone</a></td></tr>
</tbody></table>
<br />
As many of you may have experienced in your own educational journey, at some point I was taught about annotating what I read. The mighty highlighter made its appearance in every school supply list my mother received, and much like you see above, I gleefully used it to mark pretty much everything I was allowed to. As the years progressed the highlighter slowly disappeared and the annotations instead made heavy use of the marvel of Post-Its which gave me the advantage of being able to write something along the text and not simply marking things that my young self considered "important".<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgjg3OnGRGAPhnO2ui4lLuke_VWyUFaqfjxbEDt7oU9PZYqrG-mBshOOARQvZEibBRiPng4gU_9YUyIbI3TvnkIhyphenhyphenxGXs-BN4C5d5SUxbAYjTRDpL2Bkr2PES1De7_Swet_NaFT7K9bSas/s1600/close+reading1.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="560" data-original-width="431" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgjg3OnGRGAPhnO2ui4lLuke_VWyUFaqfjxbEDt7oU9PZYqrG-mBshOOARQvZEibBRiPng4gU_9YUyIbI3TvnkIhyphenhyphenxGXs-BN4C5d5SUxbAYjTRDpL2Bkr2PES1De7_Swet_NaFT7K9bSas/s200/close+reading1.png" width="152" /></a></div>
At some point in my career as an educator, I was introduced to the idea of <a href="http://www.ascd.org/publications/educational-leadership/dec12/vol70/num04/Closing-in-on-Close-Reading.aspx" target="_blank">close reading</a>, and with it came a whole new way of marking text that I was expected to teach my students. Colors and specific markings were the norm and while I am not against close reading or increasing student understanding of text (<a href="https://soa.ccsdschools.com/common/pages/DisplayFile.aspx?itemId=17314957" target="_blank">What is annotating and why is it an essential skill to close reading?</a>), the idea of having my students have to follow a specific format and key made it seem more like busy work, akin to my highlighter overuse.<br />
<br />
The questions I asked myself throughout the close reading professional development were:<br />
<br />
<ul>
<li>After all of this, will the student ever go back and use all those notes for something other than answering a couple of questions? </li>
<li>Will they ever remember that that particular document had some important notes that could be used later for something else? </li>
<li>What about all the reading we now do online? Am I really going to print out all their research so they can use this?</li>
<li>What about using collaborative close reading, especially in my PBL classroom where students are often reading a relatively dense scientific text? Shouldn't there be a way for students to close read together?</li>
</ul>
<div>
All of these questions can be answered with just one "magical" digital annotation tool - <a href="https://chrome.google.com/webstore/detail/scrible-toolbar/lijhjhlnfifgoabbihoobnfapogkcjgk?hl=en-US" target="_blank">Scrible</a>. Let me explain...</div>
<div>
<br /></div>
<div>
A couple of years ago, I developed a project for my 6th graders on <a href="https://mariana68.wixsite.com/climatechange1" target="_blank">Climate Change</a>. The idea was that the students would choose a topic from a list, interact with several digital resources from places like the EPA and the NCA and collaboratively develop a product to educate others about the impact of climate change. Par for the course, except that many of them were overwhelmed by the amount of reading and synthesizing they had to do. Add to that that they had to share their thoughts on the reading with each other and organize all of the information and ideas into one cohesive product, all the hallmarks of chaos leading to disengagement. That is when Scrible, a free tool, makes its entrance.</div>
<div>
<br /></div>
<div>
Scrible makes the possibility of collaborative digital annotations a reality! The only thing students have to do is create an account (using their district e-mail). Once that is done, a student can use the tool on any webpage sharing their thoughts right next to the text they highlight. If they create and share a permalink, they can also annotate collaboratively, which means other students can join a conversation about that digital text; this can take the form of questions, responses, comments and even links to other corroborating sources.</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLs6lh4Px2rpbXcwcy_g2QJ4UiZah2DBOdJXQ0P-VAeKZ6FL92_KAZNG-3DK-i2DnvRlz_8eGZhuBU48H1cv5CxK0mFvovOihcFdNHFdNBAflKLTltmcO-N76kBbEOa2nblLfGNgVwcvk/s1600/scrib.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="577" data-original-width="1266" height="289" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLs6lh4Px2rpbXcwcy_g2QJ4UiZah2DBOdJXQ0P-VAeKZ6FL92_KAZNG-3DK-i2DnvRlz_8eGZhuBU48H1cv5CxK0mFvovOihcFdNHFdNBAflKLTltmcO-N76kBbEOa2nblLfGNgVwcvk/s640/scrib.JPG" width="640" /></a></div>
<div>
<br /></div>
<div>
At first, students used the tool simply to remind themselves of the information, stating simply that "this information is important". However, as they progressed, and with some prodding on my part (adding cryptic replies such as "why?"), they started adding a more thorough commentary, and even inserting links that corroborated what they were reading. These annotations then allowed them not only to record their thinking but also to organize their thoughts in preparation for their project work. They served as reminders of key concepts and lateral readings they had done as they interacted with the resources. Since they were sharing the reading and annotating load, all the students were happy to add to what was being said instead of that solo "this is too much" mentality that we had before the use of the tool.</div>
<div>
<br /></div>
<div>
What is even more perfect, is that as long as you are logged on, the tool will keep track of the web pages you have visited and their annotations. This came into play for us when the students used pages they had annotated for the climate change project several months after the fact to support some of their building choices in their <a href="http://mariana68.wixsite.com/disasterproofedc" target="_blank">disaster-proof housing project</a> during our human impacts unit. </div>
<div>
<br /></div>
<div>
However, the best indication that the tool worked for my students was when I discovered it being used, without prompting, by former students. When I asked them why, they shared that it made their work easier since they could talk to each other about what they were reading, saving them time and allowing for everyone to join even if they were not in the same room. That, in itself, is a win for me.</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiUmzMzSUEnhwYSnTka1-yc4qQmzV-ji4JypoRL5aYfrT38b4f85qByg0Q3-BE5055E3xchm3DCtvmS38Ylx9fCzuYj6-CNofI6Gppfh1L3wqXYwnphio-8R11jYHaWJQuSP-OAuFCCXe0/s1600/scrib2.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="642" data-original-width="1323" height="310" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiUmzMzSUEnhwYSnTka1-yc4qQmzV-ji4JypoRL5aYfrT38b4f85qByg0Q3-BE5055E3xchm3DCtvmS38Ylx9fCzuYj6-CNofI6Gppfh1L3wqXYwnphio-8R11jYHaWJQuSP-OAuFCCXe0/s640/scrib2.JPG" width="640" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
There are a couple of Scrible tutorials on Youtube in case you need help signing up and using it:</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<iframe allowfullscreen="" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/H4bCpj0D3zo/0.jpg" frameborder="0" height="266" src="https://www.youtube.com/embed/H4bCpj0D3zo?feature=player_embedded" width="320"></iframe></div>
<div>
<br /></div>
<div>
It is worth noting that you can use Scrible on pdf's and "published to the web" Google documents, saving you the time and cost of printing resources you may already have to share with students.</div>
<div>
<br /></div>
<div>
I invite you to start playing with Scrible and share a comment telling us how it went. Until next time.</div>
Mrs.Garciahttp://www.blogger.com/profile/16492613229969352064noreply@blogger.com0tag:blogger.com,1999:blog-8818419233796306494.post-51993381122917873662018-09-14T20:52:00.000-07:002018-09-14T21:36:17.076-07:00Eight reasons to love GoFormative<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8JnISp-pvgGbZF4KP_2QNpEc7k4px18hbcjV1YmC3gw2YK7jdTmzXKGhc_4bV-s-huNaglsAE8CZSPA31zO0VCUmHwI2jm67znu8s7XFd4UqU1IZEV4Qrm2gzRHPktJ0cVsUYwyFU2-I/s1600/Formative.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1440" data-original-width="1440" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8JnISp-pvgGbZF4KP_2QNpEc7k4px18hbcjV1YmC3gw2YK7jdTmzXKGhc_4bV-s-huNaglsAE8CZSPA31zO0VCUmHwI2jm67znu8s7XFd4UqU1IZEV4Qrm2gzRHPktJ0cVsUYwyFU2-I/s400/Formative.png" width="400" /></a></div>
<br />
<br />
In a recent tweet, my good friend and colleague @JudyZaccheo posted the following "challenge"<br />
<blockquote class="twitter-tweet" data-lang="en">
<div dir="ltr" lang="en">
After trying <a href="https://twitter.com/goformative?ref_src=twsrc%5Etfw">@Goformative</a> years ago and hating it....I think Iām finally ready to give it another try š¤ Tell me what you LOVE about it people! <a href="https://twitter.com/hashtag/Goformative?src=hash&ref_src=twsrc%5Etfw">#Goformative</a> <a href="https://twitter.com/MarianaGSerrato?ref_src=twsrc%5Etfw">@MarianaGSerrato</a></div>
ā Judy Zaccheo (@judyzaccheo) <a href="https://twitter.com/judyzaccheo/status/1040774317103935488?ref_src=twsrc%5Etfw">September 15, 2018</a></blockquote>
Since this cannot be answered in a mere 240 characters or less, I had to respond "long text", and what better way than a post that can then be shared with all of you.<br />
<br />
Much like Judy, my first foray into <a href="https://goformative.com/" target="_blank">GoFormative</a> was perhaps a bit bumpy. At the time, I loved the idea of some of the question types I saw ("show your work", for example) so much that chose to present about it at a district PD, but I did not really use it much myself. This had nothing to do with the platform itself, but rather with my unfamiliarity with it. Back then, you created an account and landed on the home page but there was not much to see in terms of its capabilities, and my account remained dormant for a while.<br />
<br />
About a year ago while participating in a Twitter chat, GoFormative came up quite a few times, and I went back in if only to see what people were talking about. That led me to the first reason why I love GoFormative:<br />
<br />
1. <a href="https://discuss.goformative.com/" target="_blank">The Formative Community Center</a>: A vibrant community of educators that share content, best practices, implementation ideas and all sorts of ideas on everything from pedagogy to the latest in #edtech. What makes this community unique from others is that it also provides you with a direct line to GoFormative's amazing team of developers, who listen and respond with a "can do" attitude. To most of my "it would be wonderful if..." posts I have gotten a "we'll make that happen!" or at least a "we cannot do that right now, but what if we ...; would this be useful?"<br />
<br />
Within that community and before some of the more recent changes that have made GoFormative super user-friendly, I found a great introduction to GoFormative made by <a data-user-card="michael.lutz" href="https://discuss.goformative.com/u/michael.lutz" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #646464; cursor: pointer; font-family: Helvetica, Arial, sans-serif; font-size: 14px; font-weight: bold; outline: 0px; text-decoration-line: none; white-space: nowrap;">Michael Lutz</a>:<br />
<a href="https://discuss.goformative.com/t/an-amazing-formative-within-a-formative/516" target="_blank">Formative within a Formative</a>, which helped me explore all the different things that could be done with formative, which leads me to the 7 other reasons why I love GoFormative:<br />
<br />
2. Ability to create multimedia-rich lessons with just a few clicks. Not only does GoFormative allow you to include a wide variety of question types, you can also embed all sorts of media. It is almost an "if it is on the web, you can add it to a Formative".<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgByMNdcpPAdoKLTixr8ygR-fAOugLvIkjtT9uWqB_Ts7jwEEfB5yI5ddBUJubUNHvE371ZUdkdSuK3ufNpksHgCguUiek_aspAV8vlPZLFE9jmrqYgnJndgXeUlHimn8Y6awhx6aRHtAg/s1600/formative1.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="367" data-original-width="686" height="211" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgByMNdcpPAdoKLTixr8ygR-fAOugLvIkjtT9uWqB_Ts7jwEEfB5yI5ddBUJubUNHvE371ZUdkdSuK3ufNpksHgCguUiek_aspAV8vlPZLFE9jmrqYgnJndgXeUlHimn8Y6awhx6aRHtAg/s400/formative1.JPG" width="400" /></a></div>
<br />
Even if there is no obvious embed code on whatever you want to add, a simple iframe generated using the tricks learned in the Formative within a Formative mentioned above makes everything embeddable. In this "<a href="https://goformative.com/clone/FSBPUS" target="_blank">Relationship between Organisms</a>" example, I have not only a presentation and videos, but also LearningApps and a Flipgrid.<br />
<br />
3. Along the same lines, the "enhance a PDF/Doc feature", which allows you to digitally gather answers to anything you are already using, or add reflection questions to any formative, much like Rebecca Mann did in this example:<br />
<br />
<blockquote class="twitter-tweet" data-lang="en">
<div dir="ltr" lang="en">
Our Formative Educator of The Day is Rebecca Mann! She uses <a href="https://twitter.com/hashtag/goformative?src=hash&ref_src=twsrc%5Etfw">#goformative</a> to help her students self-assess their progress on learning standards!<a href="https://twitter.com/hashtag/formativechat?src=hash&ref_src=twsrc%5Etfw">#formativechat</a><a href="https://twitter.com/hashtag/studentcenteredlearning?src=hash&ref_src=twsrc%5Etfw">#studentcenteredlearning</a><a href="https://twitter.com/hashtag/mathchat?src=hash&ref_src=twsrc%5Etfw">#mathchat</a><a href="https://twitter.com/hashtag/hsmath?src=hash&ref_src=twsrc%5Etfw">#hsmath</a> <a href="https://t.co/KauVLnlIjm">pic.twitter.com/KauVLnlIjm</a></div>
ā formative (@goformative) <a href="https://twitter.com/goformative/status/989277020898152448?ref_src=twsrc%5Etfw">April 25, 2018</a></blockquote>
<script async="" charset="utf-8" src="https://platform.twitter.com/widgets.js"></script>
<br />
<br />
4. Ability to assess and provide feedback in real time, with no lag! Gone are the days when you have to wait for a student to submit a paper or finish the digital work. With GoFormative you can immediately send feedback to a student or group of students - even whole class, while they are working on a formative.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEinB7ixtPrFgmraCg1UoaqduiZublYFSNc9WLspme9MfSwSLG5umIC0qhJCQh917ZNcTlqaHqU6yBhVG4_16RDuAsA51ZSEP4DOzuw3-o8lCheZeZHYZC9l-kfu7Lcpu89_uCjV6eVvcno/s1600/formative5.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="558" data-original-width="1286" height="170" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEinB7ixtPrFgmraCg1UoaqduiZublYFSNc9WLspme9MfSwSLG5umIC0qhJCQh917ZNcTlqaHqU6yBhVG4_16RDuAsA51ZSEP4DOzuw3-o8lCheZeZHYZC9l-kfu7Lcpu89_uCjV6eVvcno/s400/formative5.JPG" width="400" /></a></div>
<br />
<br />
5. Identify the struggling student, find patterns in answers and be ready to pull a small group or even get everyone's attention to clarify a misconception or difficult concept.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEijFHNpD4x6UhDlJv_7pn3R4k992tknePkAU_FB9afFTMwHKp9O09tu_ukcqs0rjN8FFFKgAc7yezlp0bCRdLQYccpaZQbDjMQqV3PDXH4oGsIxnIVwl99Gq15mht1Ki_m7Ar_dycODP24/s1600/formative2.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="551" data-original-width="823" height="265" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEijFHNpD4x6UhDlJv_7pn3R4k992tknePkAU_FB9afFTMwHKp9O09tu_ukcqs0rjN8FFFKgAc7yezlp0bCRdLQYccpaZQbDjMQqV3PDXH4oGsIxnIVwl99Gq15mht1Ki_m7Ar_dycODP24/s400/formative2.JPG" width="400" /></a></div>
<br />
6. Track student progress towards mastery of standards. All you need to do is tag your standards, and Formative will summarize all the data for you!<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhiDO-_QzdwKy4xwlMzITDRBPzIrAdMhgDkLIt0q3aQfteNC9QufSWw32rwKBNjBnBR2_TBFLj_YDr2EBroS8v2QxSFKdfSdeQ7FGA6GulVE1WkGxy1qGTsbfepGSpCQ5c6BpfLt-vooNY/s1600/formative2.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="470" data-original-width="422" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhiDO-_QzdwKy4xwlMzITDRBPzIrAdMhgDkLIt0q3aQfteNC9QufSWw32rwKBNjBnBR2_TBFLj_YDr2EBroS8v2QxSFKdfSdeQ7FGA6GulVE1WkGxy1qGTsbfepGSpCQ5c6BpfLt-vooNY/s400/formative2.JPG" width="354" /></a></div>
<br />
7. Short on time? GoFormative now has a searchable library of ready-made formatives submitted by educators, searchable by grade level and content. No need to reinvent the wheel when you can clone to use as is and/or adapt to your particular situation<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhXH0_1VPrQJTj3bPxoZzioJXZhC7CkFEbSHvTZG-e-aG9NgFKYCVjQE5zDSEUGm-Nfvdk-tju7WKiorq_wdV6pxNLxAMqY213Ajjc7neoJYr9tB5mZBfYNMvGzQKKNUPaKOxuW3YjjEfs/s1600/formative2.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="633" data-original-width="1366" height="182" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhXH0_1VPrQJTj3bPxoZzioJXZhC7CkFEbSHvTZG-e-aG9NgFKYCVjQE5zDSEUGm-Nfvdk-tju7WKiorq_wdV6pxNLxAMqY213Ajjc7neoJYr9tB5mZBfYNMvGzQKKNUPaKOxuW3YjjEfs/s400/formative2.JPG" width="400" /></a></div>
<br />
8. Google classroom integration. Whether you want to import your classes from GC or you want your formatives posted directly to GC, it is all available to your students with the click of a button. No need to remember passwords or try to find "what they are supposed to do".<br />
<br />
Now, this is not to say that you have to do all of this. GoFormative is so versatile that you can even produce a quick GoFormative on the fly to act as an exit ticket or as a "Do Now" in a matter of seconds. That versatility is the reason why my students now equate GoFormative with being successful in my classroom.<br />
<br />
<br />
<script async="" charset="utf-8" src="https://platform.twitter.com/widgets.js"></script>
Mrs.Garciahttp://www.blogger.com/profile/16492613229969352064noreply@blogger.com0