Tag Archives: Google Forms

Google Forms for Record Keeping and Formative Assessment

I should probably take my own advice more often. Today I’ll try.

Every time I use Google Forms, I wonder why I don’t use them more often. Ten years ago when I first tried reading workshop (inspired by Nancie Atwell‘s In the Middle) I had clipboards and several trees worth of paper charts to keep track of student reading. Looking for trends and growth was a time consuming process. Now I use a very simple form (see photo) that has several key improvements on my paper charts:

  1. Instead of me writing 20-30 entries on a chart, which takes 15 minutes at least, now students fill out the Form each week, and it takes a few minutes.
  2. The Form doubles as an open invitation for students to communicate with me.
  3. The data the students send through the Form are stored in a spreadsheet.

IMG_3192

Number three may not seem like a big deal at first, but it is the most important improvement. It means I can sort the data to measure growth and trends over time. Viola! Formative assessment that requires very little time and effort in class, but provides a wealth of information about the reading habits of the class and individual students. Sort first by date and then by student name, and you have a list of each student’s reading progress. Find out which books or genres students enjoy or quit. It is a simple form, so the sorting options are limited, but the concept can be scaled up.

Recently I developed a Form to help a number of teachers and Educational Assistants support a student with an individualized education program. The Form made use of Google Form question styles such as checkboxes, grids, dropdowns, and linear scales, in order make data entry easy and consistent. Teachers and EAs could all access the Form and someone filled it out each class period in the student’s schedule as they worked with him. Once the spreadsheet was populated it offered an impressive number of sorting options that helped better understand patterns of behaviour for the student and the support staff.

  • Is there a connection between optimum learning and the time of day? The subject? The teacher or EA?
  • Do behaviour incidents correlate with lunch? Days of the week? Medication administration?

We are still learning how to design Forms and interpret the data, but I think the potential is clear.

Recently on Twitter, Jenni vanRees asked,

and I immediately thought of Forms. I teach high school, so my experience with running records is limited to my role as parent. It seems that there is a huge variety of styles when it comes to running records, but in the right circumstances, a Form that uses linear scales, checkboxes, etc. could save time when working with students and really increase the usability of the data afterward. Certainly there would be time invested in the design and creation of a running record Form, but that investment would pay dividends all year. After creating the first Form, additional Forms could be created by making a copy of the original and tweaking some questions. If there are prompts that need to be changed, the original Form could be edited and the data would continue to compile.

I think it could be done with a little creativity. Anyone out there using Google Forms for Running Records? I’d love to see how you approach the task (Jenni, too).

 

 

Leave a comment

Filed under Classroom Ideas

Tracking 50 Passion Projects at Once

As my second full year of Genius Hour passion projects begins, I’m trying something new in order to better track each student’s progress. Last year I learned plenty from my students, including that I need a leaner, more agile tracking system in order to assess, encourage, and praise progress. Google Forms to the rescue!

Instead of clipboards and growing piles of paper charts, I created a simple Google Form that looks like this:PassionForm

The form is short and takes students only a minute or two to complete at the beginning of their Passion Project time (I schedule this period once a week on a Monday or Friday). The form can be distributed to students in several ways: email, url (I’d use a url shortener for this), or a QRcode (I use Qrafter Pro, but there are free apps). Most students simply bookmark the form the first time they use it, but some love scanning the QRcode every time because it makes them feel like they are attending class on the Starship Enterprise. If not all the students in the room have a device or access to a computer, they can complete the form on a friends device or take turns on a classroom computer. I’ve even circulated the room with my iPad so that students could complete the form.

If you don’t know how to make or use a Google Form, it is very simple, and @alicekeeler has a very good Intro to Google Forms that will walk you through the process.

Once students complete the form, the real power of Google Forms is at your fingertips. All the answers are sent to a spreadsheet like this:PassionResponses 

Obviously this one is blank at the moment, but once it is full of data, the spreadsheet is a versatile and handy assessment. If you click on the heading of column A (timestamp) and organize the information in alphabetical order from Z-A, you have a list of what everyone is doing (or supposed to be doing) today (alphabetizing the timestamp Z-A puts the most recent answers at the top and the oldest answers at the bottom). I use this information to connect with each student during passion project time and to help some students manage their time. It is a great way to help students to learn over time how to set reasonable goals and manage time independently.

After several classes have passed, I click on the heading of column B (Name) and organize alphabetically by name. This enables me to look at one student’s progress over time. Are they making progress? Are they accomplishing their weekly goals? Do they seem to recognize their progress (or lack of)? This helps me to identify stragglers and strugglers much earlier than I have previously, and all the information is on one spreadsheet in Google Drive instead of a pile of paper charts in my desk.

If you’re tired of treading water in a sea of paperwork, Google Forms may be the tool for you. It is very versatile and can be used in many situations. Some teachers use it to get to know their students, others to organize events or collect information from parents. Start with a simple form, and I think you’ll quickly see the power and potential of Google Forms.

 

Leave a comment

Filed under Classroom Ideas