Friday, February 4, 2022
Prep for Google Certified Educator Level 2 Exam: Google Forms
Friday, December 10, 2021
Prep for Google Certified Educator Level 1 Exam: Google Forms
Wednesday, November 17, 2021
Keep Track of Google Forms with Notification Rules
The popularity of Google Forms has exploded over the years. It's so versatile. You can create surveys to collect a wide range of data and information. You can create self paced lessons, Create Your Own Adventure Stories, assessments and more.
Keeping track of who fills out a form and when they complete it can be a tedious task. This requires you to go searching through your Drive to find the Google Sheet that stores the Form's data. Hiding in plain sight, built into Google Sheets, is a Notification rules function. This allows you to be emailed when someone fills out your Form.
Get started by opening the Sheet that accompanies your Google Form. Click Tools on the top menu and select Notification rules.
Wednesday, September 8, 2021
Get Started with "Choose Your Own Adventure" Stories Using Google Forms
Just the other day, I wrote a blog post on how to get started with "Choose Your Own Adventure" Stories using Google Slides. It's a great way to give multiple perspectives when students read as well as inject a little bit of voice and choice. If you're a fan of Google Forms, you can create these types of experiences with Forms too. One advantage Forms has over Slides is ability to track accountability. When students complete or submit, there is a record of them reading and which path they chose. You could have kids read all versions and do a comparison of the characters' journeys. The possibilities abound.
Take a look at the screenshots below to get started with the bare bones basics of creating "Choose Your Own Adventure" Stories with Google Forms.
The example below gives three options for students to choose. Jack and Jill went up the hill, but there are three forks in the road. They can fetch a pail of water, get a better view of the city or plant an oak tree. For this example, I typed the opening of the story as a multiple choice question and each option was a choice.
Tuesday, November 17, 2020
Use Google Forms and Sheets to Track Intervention Students and More
A common pain point among educators is having to transpose grades, data, etc. from paper or a program to another program. One thing we have started doing is electronically submitting records of student intervention. We have the autonomy to track and record student intervention interactions with our own preferred methods. For the most part, I have seen teachers write down their intervention on a paper chart. When we were turning in hard copies, this method is fine, but now we're submitting electronically.
One solution would be to scan intervention forms, but that can be tedious and time consuming. Using Google Forms in concert with CONCATENATE in Google Sheets or Microsoft Excel, you can track intervention data, and much more, digitally and efficiently. I am by no means an expert with spreadsheets. My skill level is rather rudimentary, but this trick has made my workflow much better and saved me hours of tedious work.
In the GIF below, you see a sample of a form similar to what I use to track intervention with students. Setting the form is not difficult. The tedious, difficult part is getting all the student names into the form.
Using your school's student data system (We currently use Illuminate), you can download spreadsheets with your class rosters. Below is a sample of what these spreadsheets can look like. Using CONCATENATE in Google Sheets or Microsoft Excel, you can combine student last names, first names, and a comma in between, into a list that is EASILY copied and pasted into a Google Form.
Thursday, November 12, 2020
Monitor Asynchronous Work with Sheets Notification Rules
Since the dawn of distance learning, the term Asynchronous has become a huge part of the EDU lexicon. I think I say this word at least a dozen times daily and type it more than double that. Keeping students engaged in asynchronous work can be a struggle. Some students have thrived, others struggled while many have been rather hit and miss.
A common asynchronous learning activity is to embed lesson videos with questions on Google Forms. Teachers insert a recorded lesson video to the Form, students watch the video in the Form then answer a variety of checking for understanding questions.
Keeping track of when students submit work are valuable data points not only for tracking asynchronous work, but also for gaining insight on when students are completing work. This type of information can be useful when trying to better understand student study habits and routines. In addition, this data can be useful when setting up intervention groups. Using notification rules in the Google Sheet generated by a Google Form, you can access this data. You can receive an email immediately after a student submits a Form or get a daily digest of Form submissions.
Below is a series of screenshots showing you how to get started using notification rules with Google Forms and Google Sheets.
Step 1: After creating a Form, click Responses.
Thursday, September 24, 2020
Make a Force Copy of a Digital File in GSuite
As educators, we create resources all the time. When we collaborate with colleagues, we share these resources, but issues arise with editing and viewing permissions as well having to make copies of digital files. If you are using GSuite, there is a simple trick for creating a "Force Copy" link. A "Force Copy" link forces anyone who clicks on it to make a copy of your file without having open a View Only version and make the copy on their own. It removes a few steps from that process. With many colleagues, removing those extra steps can be very helpful.
This isn't a brand new idea, and you could Google it and find many articles on how to do this, but take a look at the steps and screenshots below to learn how to make a "Force Copy" of a file in GSuite.
Step 1: Open your file and click Share. Set permissions for Anyone with the link is a Viewer.
My book, The Complete EdTech Coach: An Organic Approach to Digital Learning, co-authored with my wife Katherine Goyette is due out in October/November of 2020. It will be published by Dave Burgess Publishing. Keep an eye out on this blog and on social media. Be sure to follow the hashtag #OrganicEdTech and #CVTechTalk for updates.
Tuesday, September 22, 2020
A Couple of Ideas for EdTech Coaches to Track Coaching Interactions
As an edtech coach, it is vital to track your teacher and student interactions. Administrators love data and want data to support their investment in your edtech coach position. In our upcoming book, The Complete EdTech Coach: An Organic Approach to Digital Learning, my co-author and wife, Katherine Goyette and I, discuss ways to measure your effectiveness and impact as an edtech coach. We recommend using the 4 C's for this. We like to say, "if you plan with the 4 C's in mind, the tech will take care of itself". The wisdom is that if administrators observe students engaged in the 4 C's, you've effectively integrated technology.
Edtech coaches wear many hats. Where the 4 C's measure the effectiveness of edtech coaching and integration, hard data for your everyday coaching interactions are also important. Take a look below at the Google Form I use to track all of my coaching duties from meeting with teachers, walking classrooms, providing feedback and training students, quasi-IT duties and more.
The first "question" is where I choose the school site of the teacher or student I am supporting. Depending on the choice, it will take me to a list of teachers for that school site.
After selecting the school site, I select the name of the teacher or select "Student". If "Student" is selected, when I get to the summary at the end of the form, I add the student's name there.
After selecting the teacher name or "Student", the form takes me to a Checkbox question of a variety of "services" provided.





































