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 […]
Yearly Archives: 2015
37 posts
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 […]
When I was teaching back in Indiana, I used PowerPoint fairly regularly to present content to my students. It served as a record of what I had taught, so I could use it the next year; it allowed students who were absent to catch up on some of the material […]