Monday, 20 April 2015

Using Multiple Correct Answers with "Flubaroo"

Here's a quick tutorial if you want to use multiple correct answers with the text response type question with google forms and the grading add-on "Flubaroo". Having text type answers may seem difficult to standardize grading as opposed to multiple choice or check-box type responses, but does also make the student to dig deeper in order to show what they know and not use easy process of elimination which may may bias the rigor of Google forms as assessments.

Related Posts
Doc Appender-The Ultimate Peer Assessment Tool
Project Grouping with Doctopus

Sunday, 12 April 2015

Use Named Ranges and Countif for Amazing Data Collation

This is a handy function that you might want to use if you want to tabulate how many people indicate something on a survey that you want to "push" to another spreadsheet in order to look for trends in the data by dynamic graphs in real-time. Enjoy!

Related Posts
Importing Data through HTML
Using the query function to filter and sort data

Friday, 10 April 2015

Using the Query Function to Filter and Sort Data

Earth week is around the corner. To make the students more aware of their trash output, we're using the first day of earth week to have students "carry their trash" instead of disposing of it to make them more aware of what they consume and throw away. I made a simple google form for them to submit how many and what type of trash students collected at the end of the day.

One of my projects is to help students visualize this information from the data that comes in as it's submitted. The "Query" formula has become my saving grace and is a super cool way to filter data based on a specific column and push it into another tab so we can look for trends from the data. Here is a tutorial which shows you how to do it. Enjoy!

Sunday, 5 April 2015

The Power of Study Guides

Study guides might seem a bit "old school" and with all the rhetoric on 21st learning skills, many educators seem to disregarding these resources for other media. I feel that I'm a teacher from both worlds, and know that in-depth understanding of topics require sound foundational content knowledge which is best built over multiple class periods and is assessed in a cycle where instruction and assessment drive one another. I've seen countless differentiated monstrosities of student work where student's couldn't explain the most basic learning outcomes afterwards. In short, if students are encouraged to be content creators, we must make sure that web tools redefine what is possible, not cover up gaps in the learning with flashy presentation tools. 

I favor project-based learning, but use lessons and assessment frequently in the background to make sure that students (and I) understand what was really understood during the lesson to help guide instruction and re mediate if necessary. 

What Study Guides Do
Study guides should be formatted to have the intended learning outcomes of the unit. As my units are nearly 2 months long, I have them broken down into "chunks" of two weeks of lessons that usually have 3 lessons and a formative lab. If you've ever done "Understanding by Design", it's basically taking the intended learning outcomes and making them understandable to the students. I like Google docs because groups can work on them collaboratively and share their knowledge before whole-class shares. 

What Study Guides Have
This is completely up to the teacher, and you may want to explore samples online through a quick Google Search and see how formatting best supports your content area. Here are some parts that I like: 
  • Target Vocabulary
  • Summaries of major understandings
  • "I can statements" 
  • Practice areas before quizzes or other assessments