Tag Archives: Sheets

Webinar: Use FilterRoster on your Google Forms for Individual Student Spreadsheets

This is a webinar that is a result of @edtechchic exclaiming on Twitter how much she loves the Google Sheets formula =importrange(). I told her that if she loved that she might like my script I wrote that creates and individual spreadsheet for each student based on filtered data from a Google Form. The process uses […]

Read more

Google Forms: Sign In Sheet & Providing Weekly Feedback to Students

Google Forms allow you to collect information from students. One thing I use Google Forms for is to have students sign into class. Once a week I ask for students “Comments, Questions, Concerns or Compliments” to allow me to hear from every student in the class. The information from the Google Form goes to a Google […]

Read more

Have Your Class Tweet Experts in the Field

One of my favorite teaching moments was when one of my students was wondering about Google Glass. This was not part of what we were teaching that day and I did not have first hand experience with Google Glass so I could not do it justice. I remembered that Adam Bellow wore Google Glass during his […]

Read more

Gamification Tip: Provide a Challenge

I started my 7 year old on using Scratch Jr for the iPad. This app is for young children to get started with the idea of coding. It allows the child to drag action blocks to snap together to have a character do something. My daughter was interested in this for about 30 minutes when […]

Read more

Google Forms: Notification Rules

Depending on the data you are collecting from students you may want to receive an email when the form is submitted. At the suggestion of Ramsey Musallam I have included an anonymous honest feedback form with each lesson. Students do not always fill out the form each lesson, thus necessitating that I receive a notification […]

Read more

Google Forms: Creating a Rubric

Google Forms has so many  applications for education. For students to fill out to submit data to the teacher, for the teacher to record data on observations about students, for students and teachers to monitor their progress on a task they are tracking, for self and peer evaluation and so much more. Google Forms is […]

Read more

Google Forms: Streamline your Data with FilterRoster Script

If you re-use a Google Form for attendance, turning in homework, daily warm-up, peer evaluation data, or anything where there are multiple rows per student  in your Form data my script FilterRoster may be helpful. It creates a tab for EACH student with a filter to show just that students data. Rather than filtering the Google […]

Read more

Elise Legaspi Shares How She Uses TemplateTab with Students

By Elise Legaspi I proudly admit that I have drunk the Google-flavored Kool-aid and it was Alice Keeler who handed me the cup! My love affair with Google started a couple of years ago when Alice Keeler led a PD at my school district and she talked about all things Google: Drive, Docs, Slides, Drawing, etc. […]

Read more

Multiple Google Forms to One Spreadsheet

The magic of Google Forms is the ability to view all of your Form data in a spreadsheet. I use Google Forms a considerable amount in my classroom. Google Forms basically allows me to be paperless. Any data I need to collect, including student work, I utilize a Google Form. This means that I have […]

Read more

Google Sheets: Copy a Template for Each Student

As a teacher, I use collaborative spreadsheets with students to  have everyone in my class participate on the same document at the same time. Spreadsheets allow me to create multiple tabs to give each student their own sheet to work on within the same document. This gives me one document to open and assess.   Previously […]

Read more

Google Sheets: Give Each Student Their Own Tab

One of my favorite class activities is to have students all contribute to the same Google Sheets spreadsheet. Each student can have their own tab in the spreadsheet. This gives me one document to access and assess. It allows me, and classmates, to view the work of other students for the purpose of peer evaluation […]

Read more

Gamify Your PD: Badges and Level Up

If you are providing a professional development workshop you may want to consider trying to gamify the event. I have created a template using Google Sheets that allows you to create a list of activities the PD participants will engage in. Assign a difficulty level, XP points and a badge to each task. As the […]

Read more

Google Forms: Create a Quiz from a Question Bank

Google Forms is a survey tool, not a quiz generator. Many teachers utilize Google Forms for formative assessment since they are easy to administrate and the data is easily accessible in a Google spreadsheet. Using the Add-On Flubaroo will automatically grade the multiple choice questions and provide the student with their score. Google Forms allows […]

Read more

Google Docs: Prompt Students to Make a Copy

A feature of the old Google spreadsheets was to be able to append &newcopy to the end of the URL. What this would do is when you share a view only link with a student, it would prompt the student to make a copy. This is a feature I used all the time with students […]

Read more

Google Forms: Daily Sign In – Identifying Struggling Students

Each class I ask my students to fill out a Google Form to check into class. I also ask the students to provide a link to their digital portfolio where they post all of their work and I ask them for “Comments/Questions/Concerns/Compliments” so I can respond to them personally. Recently I have added a rating […]

Read more