In this lesson, we’ll be learning how to slice and dice, filter and sort your data with the function QUERY. Those of you who have worked with databases before and SQL (Sequenced Query Language) will find this familiar, but even if all this is new to you it’s definitely doable. […]
pswanson
56 posts
In the previous example we saw how you can use the function ARRAYFORMULA to make a function apply to a whole column, including new form entries that fall into that column. However, in that example there was no header row and there were lots of #N/A errors that looked pretty […]
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 up the block of formulas. How then, do we have the formulas automatically […]
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 out Google Forms to students. We know we can automatically collect their […]
One of the most common sources of information for teachers about students is their School Information System, and this information often comes in the form of a spreadsheet (.xlsx or .csv) file. Sometimes you get all the information you need about a student, but sometimes you have to manipulate it […]
For almost a year now, I’ve been working on a presentation focused on 21st Century Problems. The premise is simple: we spend a tremendous amount of time analyzing, articulating, and standardizing the knowledge, skills, and dispositions necessary for students today, what many call “21st Century Skills”. However, all of these […]