Google Apps




In order to maintain order within our institutional Google Drive we ask that all files and folders visible to groups follow the naming convention outlined below. The naming convention is: (Grade Level) (Course Name/Topic/Unit) – Title (Version) Please make sure to: use hyphens as separators between the prefixes and the […]

Google Drive – UNIS Naming Convention





<iframe width=”640″ height=”480″ src=”https://www.youtube.com/embed/Mow78KQNA54″ frameborder=”0″ allowfullscreen></iframe> <div style=”max-width: 450px; float: left; padding-right: 20px;”> As you noticed in the last tutorial, you can’t simply copy down a formula and have it apply to new form submissions. This is because the response sheet actually inserts a new row for every submission, breaking […]

Google Sheets for Peer Feedback 3 – ARRAYFORMULA



<iframe width=”640″ height=”480″ src=”https://www.youtube.com/embed/LsHM0MMNIKE” frameborder=”0″ allowfullscreen></iframe> <div style=”max-width: 450px; float: left; padding-right: 20px;”>In this lesson we’ll continue our manipulations of SIS generated data.  One of the most common needs is to look up a student’s full name, email, parents’ emails, grade, etc. This becomes particularly important when we are sending […]

Google Sheets for Peer Feedback 2 – VLOOKUP