Sunday, April 9, 2017

Creating Intervention Logs with Google Forms

I hate the paperwork of intervention logs. I looked for a way to simplify this process using technology. For a long time, I would type into a document. It is not elegant, nor was it efficient.

I then started playing with Google Forms. At first, the formatting became problematic, but I learned to use the Query Function so that information can go from the responses tab to another tab. That information can be formatted.



Spreadsheet Example

Monday, January 4, 2016

Grading offline assessments with Flubaroo

I love Flubaroo, the Google Forms and Sheets Add-on that lets you correct online assessments. You set up a Google Form as your assessment. You install the Add-on to your form results page, and the assessment is graded automatically.

But not all tests can be online. I have realized the value of Flubaroo with tests I have to give my students on paper. For example, we take AIMSweb benchmark assessments three times a year. Instead of creating a form for students to fill out,  I created a Google Form to record their scores.

  1. I create a form with the first question a pulldown list of my students' names. I only have to do this once as I make a copy of the first form I created keeping me from having to repeatedly type in student names.
  2. All other entries are numbered to correspond with the paper questions. The help text is the correct answer to each question.
  3. Each test question has three possible choices: correct, incorrect, did not attempt. 
  4. If the test is multiple pages, I add page breaks to match the paper version.
  5. I record the KEY for my Flubaroo scoring. All you have to do is mark is mark CORRECT for each question.
  6. I use the form to record each students' answers.
  7. I set up the Flubaroo Add-on. With our AIMSweb math assessments, questions were weighted differently. I set this up just once, and all students' scores are tabulated automatically.

Sunday, January 3, 2016

Add + to your Google Apps for Education email address for signups and junk

I hate junk mail, and our current district email system does a poor job of filtering any of it. This is why I am excited for our district's transition to Google Apps for Education. Google does a better job of filtering junk mail, but it's still not perfect.

For years, I have used the + symbol to filter out accounts I sign up for. The idea is simple if your email is the following:
yourname@gmail.com

Add a plus to your email address like this:
yourname+A1bookclub@gmail.com

That way I can create a filter in my inbox. Perhaps I don't want my book club email to go into my main inbox but to go into a special folder instead. I can also see if  A1 Book Club is selling my email address to others. Of course this is just an example, you can add anything after the + to help you understand where this email is coming from.

As a teacher, I am always signing up for freebies, promotions,  etc, but I don't care for the email that comes to my inbox after doing so. After doing some tests, I have learned that the above email conventions works for Google Education email as well.

Bye bye unwanted email.

Friday, November 20, 2015

Create stunning multimedia timelines with Google Sheets

I love getting my students to create timelines. They give students a good understanding of a certain period of time or  the years of a person's life.

Timeline JS3 is an online tool students can use to create multimedia, embeddable timelines that are interactive. They look professional and do not require too much work. Below is a timeline that took me less than 10 minutes to create.

Check it out and start creating your own!



Thursday, November 19, 2015

Google Add-on lets you create doc from Google Form

I am a huge fan of using Google Forms with my fifth graders. Adding the functionality of Flubaroo, I am able give and grade assessments that my students take online. But there has always been something missing. My students' parents don't see the answers their students submitted.

Forms Publisher solves that problem. It lets you create an individual Google Doc or Sheets file each time someone submits a form. It gives parents a way to see their students' answers. While it still does not show what answers where wrong or right. It satisfies parents when they see grades for a mysterious online assessment.

It's very intuitive and easy to use. Watch the video below to see how easy it is!