Tag Archives: Google

Learning From Setbacks: Next Steps

My last post discussed how some of my standards based assessment plans went awry. The next post or two will document the adjustments I’m making in the new semester in order to improve the process. I’ll begin with communication.

The SBA grade book I created worked well for me, but it was difficult to share with students who only were able to see a PowerSchool summary of my much more detailed assessments. This semester I’m using the =importrange function to open up my grade book for each student. It requires some initial setup, and there is probably an easier, more elegant solution, but this is how I’m getting the job done on the fly.

The =importrange function allows me to take information from one spreadsheet and display it in another spreadsheet. In this case, I created a spreadsheet for each student in class and imported only their grade information to their personal sheet. Then I shared the sheet with them on Google Drive. The best part is that whenever I make changes to my grade book, the =importrange function updates the student sheets, so after my initial investment in time, the grade information flows to the students without any extra work on my part. Here is a quick look at part of a student spreadsheet. (And, here is the link. Feel free to make a copy.)

Importrange Capture

I could explain how to use =importrange, but anyone really interested in the details should check out Alice Keeler‘s posts (like this one). I don’t have anything to add to her already helpful explanations.

Some tips:

  • importrange moves information in cells but not formatting
  • Create one student sheet as a template and include any colour formatting you would like, then duplicate the template for each additional student using FILE–>make a copy…
  • My grade book is one spreadsheet with a tab for each student. Once I set up my first student sheet each duplicate sheet only required me to change the tab name in the formula to import the student specific data (No need to rewrite the entire formula). For example, in the photo above, if I change the tab name, “Student Sample” in the formula to the name of the next student tab, “Jane Smith” suddenly Jane’s grade information is connected to her spread sheet.

Once the setup is complete, I’ll assess as I did last semester, but the communication (and hopefully conversation) around assessment will drastically increase. It isn’t a perfect system, but it is an important next step.

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