Using Google Sheets / Forms to collect Student Data

Have you ever collected information about students in Google forms into a spreadsheet, but then have a cluttered mess of data to deal with? By using the tabs and a simple formula, you can sort your students into separate tabs and even add conditional formatting to highlight the results. Each individual tab will keep populating with student results as you keep adding to your Google form.

Check out the video!

Hapara Webinar

At the start of December, I had the wonderful opportunity to help facilitate my first webinar. I was asked to speak about Assessment For, As and Of Learning in Ontario and how that can align with Hapara and Google Apps. The webinar is private only to those who are participating in the Hapara Certified Educator course, but my slide deck is posted below.

Google Apps For Education Summit – Ottawa 2015

The Ottawa GAFE Summit is fast approaching this year and once again I am very excited to be presenting two sessions.

In my first session we will explore the explosive power of Hapara Teacher Dashboard. This session will focus on the basic overview of this management tool and how it is currently being used in instructional practice. Participants will learn how they can participate with students directly in their browser to support student collaboration, creativity, critical thinking and communication.  


In my second session, we will explore the different tools in Google that will allow you to make formative, summative and diagnostic assessment more manageable. Learn about the potential of add-ons in forms, sheets and docs that can help move your classroom into the 21st century.

Doctopus and Goobric

I have been using this wonderful add-on created by Andrew Stillman for years now. Before I had Hapara Teacher Dashboard, this was the script that helped me change the way I teach and also changed the workflow between myself and my students. Last year I created a video for a staff meeting outlining the basics of Doctopus and Goobric. Take a look!