Cool Trick: Using Data Sheets to Target Student Needs

Are you looking for a way to target your students’ strengths and weaknesses? Do you want to make your students more responsible for their learning? If you answered YES to either of those questions then STUDENT DATA SHEETS may be what you are looking for. Learn how to create these DATA SHEETS to regularly enforce the standards, skills, and knowledge you want your students to master. Students will record and track their scores based on the categories you assess.

Are you looking for a way to target your students’ strengths and weaknesses? Do you want to make your students more responsible for their learning? If you answered YES to either of those questions then STUDENT DATA SHEETS may be what you are looking for. Learn how to create these DATA SHEETS to regularly enforce the standards, skills, and knowledge you want your students to master. Students will record and track their scores based on the categories you assess.

Check out this presentation for rationale, how-to tutorials, and content specific examples.

 

Resource Introduction: Zipgrade

Ditch those Scantrons with ZipGrade!

21C Profile Pic-MalcolmThanks to Northview’s Ian Malcolm for this resource introduction!

 


What is it?

ZipGrade is a low-cost and fast alternative to using traditional Scantron grading sheets.  This phone app works for both Apple and Android devices, and allows you to grade multiple choice tests as soon as the students hand them in.  Along with quick grading, the app also creates individual grade sheets for each of your students, stores all data digitally in a way that can be quickly accessed online, and gives you in-depth item analysis.

You get 100 free demo scans, but after that it is $6.99 for a year subscription.

How can I use it?

Turns your phone into a Scantron!  Setup shouldn’t take more than 10 minutes and you’ll be able to use your phone as an electronic grading device.  Once you’ve graded, you’ll have access to a digital copy of each student’s answer sheet so you can double check to see if there were any grading errors.  You’ll also get item analysis showing the percentage of students that answered correctly, and what percentage of students picked each of the other options.  This is a great tool for finding your student’s misconceptions.

Also, you should be able to upload your student’s scores directly into Powerschool through ZipGrade’s export feature and Powerschool’s import feature, saving a lot of manual work.

Here is a quick run-down on how to make it work:

  • Download the app and create an account.  You get 100 free demo scans
  • Add a class through the website.  You can actually run a report from power school with your class roster and upload it into the app.  This an improvement over other grade scanning software which you have to enter manually, and I have created a video showing you how to do this.
  • Once you have the class, you can print out answer sheets that have the student’s name and number printed on them already.  
  • Create a quiz on the phone app, and then create the answer key.  Fastest way to create a key is to fill out a blank answer form and scan it as the key.
  • You’re finished.  Just select the quiz/test on your phone app and scan the student’s answer sheets when they complete the test.  The app saves a picture of the test, and uploads all the data to website.

Who’s using it?

Check out these teachers that know and use ZipGrade in your school. Ask them for help!

At Northview, Ian Malcolm

Are you or someone you know using this? Notify us, and we’ll post your or their name here as a building expert! Email to aclarkson@sylvaniaschools.org.


For more help with ZipGrade, watch Thomas Grodek’s excellent tutorial!


Resource Links

ZipGrade Home Page

ZipGrade Help Page

Zipgrade Apple Download on iTunes

ZipGrade Android Download on Google Play

Ian’s “ZipGrade Class Setup Tutorial” video

PD Session: Mastering Data in the Digital World

So, you’ve created a digital assessment. Now what? How about Flubaroo reports? Join John Word to explore simple tricks to climb out from the burden of data and master it!

Presented by John Word

Last presented on October 19, 2015 as part of the Sylvania Fall Inservice Day; Next presentation to be announced!


So, you’ve created a digital assessment. Now what? How do you deal with the grade data? What can you do with Achieve3000 data? How about Flubaroo reports? Join John Word to explore simple tricks to climb out from the burden of data and master it!

Description


Want some quick ways to gather powerful insights from your data? Check out these videos:


Session Materials

Useful Tricks and Formulas

More Formulas in Google Spreadsheet

Practice Spreadsheet with Fake Data

PD Session: Grade Student Writing- 21st Century Style

Skip printing entirely and learn to evaluate writing digitally. It’s easy when you know a few simple tricks.

Presented by Lauren Clark, Amy Schloegl, and Chris Harrington

Presenting last on October 19, 2015 as part of the Sylvania Fall Inservice Day. Next presentation to be announced!


From the ad: “Are you asking students to complete writing assignments online? Skip printing entirely and learn to evaluate writing digitally. It’s easy when you know a few simple tricks. Participants will learn and practice a variety of techniques to provide rich and timely feedback to students. Join us to overcome your fear of grading without a pen.”

The session is designed for all teachers from any discipline who assign digital writing. You will learn how to create a rubric and comment bank, manage a multi-window workspace, and use nifty keyboard shortcuts. Walk away feeling confident in digital grading techniques and the power they hold in helping students grow in writing across the curriculum!


Couldn’t make the session?  Check out this video from Kevin Brookhouser on keyboard shortcuts in Google Drive. This gives a taste of what’s in the session!


Session Materials

Links

Grade Student Writing 21st Century Style- PRESENTATION 

Teacher Showcase: Digital Grading with Ali Knowles

Digital is everywhere, even in band! See how Ali Knowles orchestrates digital practices for rich and simple grading.

Ali Knowles makes sure that if you visit her office at Southview, you get candy. The Reese’s peanut butter cup I choose just adds to the comfort of the office and the band room it joins. Ali’s work space reflects the stereotypical chaos of an artist, with stacks of papers, digital paraphernalia, and a colorful miscellany of musical equipment, but what’s going on inside is anything but disorganized. In fact, Ali is assessing her students’ musical performances through a process that is expertly structured, a process that is a model of effective digital grading.

As Ali sits at her desk, she examines video recordings of her sixth grade band students for assessment and feedback. She bounces back and forth between two windows on her screen. One displays the video of the student in a Quicktime player; the other shows Ali’s spreadsheet in Google Drive. Ali watches the video, pausing and rewinding as necessary, typing scores and comments into the spreadsheet as she goes. If she were merely to stand next to them, Ali would powerless to pause her eleven year-old students, but that power is hers through video. Using video instead of live performance gives her the ability to examine the student’s skills in much greater detail than a live viewing, and the resulting feedback is that much richer.

Once finished with the feedback, sharing these results with students would be a challenge to many teachers. After all, how does a teacher share individual rows on a spreadsheet with individual students? Copy them to a grade sheet? Hardly efficient. Cut them into strips? What a mess! Instead of those ludicrous options, Ali uses a mail merge to automatically plug the row data in an individualized email sent to each student. This all happens through an application called Yet Another Mail Merge (YAMM) that plugs into Google Sheets. Basically, YAMM looks at the spreadsheet, which includes student email addresses, and plugs the grade and feedback information into a template that Ali wrote. Each student receives an email discussing their grade with the data from the sheet Ali used while watching the video. The beauty of this? Once Ali mastered YAMM, she could send the entire batch of those customized emails with only a few clicks.

So, students open their email accounts to read a report from Ali that provides scores in various areas of assessment as well as comments on strengths and weaknesses. That structure and content of that report was not generated by an automated service, though. Ali made it herself, and since she did that, the report reflects her class objectives and learning process perfectly. Ali tailored the technology to her students’ needs, not the other way around. The end result? Speed and rich feedback. Ali quickly runs through each video, enters scores and comments, moves through the entire roster, and then uses YAMM to send the results with a few clicks. This may sound complicated, but if you asked Ali if it’s tough, she’d give a slight shrug and shake her head.

But how did Ali get to this point? This office, however comfortable and candy-laden it may be, is still a small room, isolated from students. Ali is not wading into a sea of sixth graders in a band room to accomplish this grading, but it does start there. Let’s check out this lesson through the story of an eighth grade band day at Timberstone.

20150925_085944
Students complete a warm-up listening activity.

About a minute after the bell rings, eighth graders excitedly filter into the band room, gather their instruments, and check out the directions on the SmartBoard, chattering all the while. Ali calls them together and completes the first two activities of the day, a listening activity to identify major and minor chords and a warm up with slurs. Then, she dismisses three pairs of students to band practice rooms with flip cameras. While Ali turns back to rehearsing a piece with the rest of the band, these few students will record each other completing “Technique 2a.”

20150925_091057
Nick and Ethan warm up before recording.

Nick, a trombone player, and Ethan, a baritone player, enter the first room and set to work immediately. Nick practices the technique and then watches Ethan do the same. Once warmed up, Ethan picks up the flip camera and aims it at Nick. Nick runs through the technique, performing much better than his warm up. Smiling in satisfaction, he trades places with Ethan, who performs his own pass.

20150925_091545
Abby and Lauren record the technique for flute.

Ali’s training is obvious with these boys, just as it is with Abby and Lauren in the next room, or Madison and Abby in the last. Each pair efficiently records each other and then exits the practice room to rejoin the band. Another series of pairs takes their place.

Throughout the recording, Ali continues to rehearse with the rest of the band. She explains that she loves this approach’s ability to leave her working with the main group throughout the period. She can rely on her students to record efficiently, and she will be able to “sit” with each one of them once she returns to her office.

Ali’s process has used digital technology to orchestrate the learning of a band full of students at the same time. By recording performances, she can be in two places at once, giving direction to the entire band and valuable feedback to each student individually. The mail merge makes that feedback instantly and permanently available to the students. What’s better is that each recording of each student stays in a digital folder that they can review as they progress through each stage of learning. And that means that Ali has refined a process by which each student receives more attention, clearer direction, and continuous reflection. Truly, her work at assessment is exceptional.

TS Sequence Slide-Knowles.jpg

Visit these links to learn more!

Yet Another Mail Merge Download

Yet Another Mail Merge Text Instructions

Yet Another Mail Merge Video Instructions

PD Session: Digital Grading with Flubaroo

Ready to go digital with tests and quizzes? Then get ready to trash those Scantrons and give your teacher’s aides a break. Flubraoo will handle the grading!

Presented by Alexander Clarkson

Next presented on August 18, 2015 at 10:00 AM at Northview High School


From the ad: “How many Scantrons have you used in your life? How many true/false items have you hand-graded? Well, leave all those moments in the past because Flubaroo is here! Join us to learn this simple add-on to Google sheets that will turn every form into an instantly graded quiz or test. It’s simple and powerful, and you’ll love it!”

Participants will take part in a quiz scored through Flubaroo. Then, the presenter will help each participant make their own quiz and grade it with the add-on. Participants will leave with a working knowledge of Flubaroo and be able to use it in their classes immediately.


Couldn’t make the session?  Check out this brief video from Dave Abouav on how to use the script! Then, check out a more detailed video below.


Session Materials

Alex’s Google Slides Presentation

Flubaroo Download Link in Playstore

Flubaroo Home Page

Amy Mayer’s Extended Tutorial on Flubaroo

Sylvania Digital Learning’s Resource Introduction on Flubaroo

PD Session: Lose the Red Pen! Go Digital in Grading Writing.

Join us to overcome your fear of grading without a pen. Learn how to use Google Drive to grade as quickly as before, and with richer feedback for students. This session is designed for any ELA teacher.

Part of Sylvania’s 2015 Summer PD Series

Presented by Alexander Clarkson

Last presented on July 7, 2015


Join us to overcome your fear of grading without a pen.  Learn how to use Google Drive to grade as quickly as before, and with richer feedback for students.  This session is designed for any ELA teacher.


Couldn’t make the session?  Watch Kevin Brookhouser’s video about keyboard shortcuts in Google Drive. This gives a taste of the information in the session. Explore the Google slides presentation file below for more.


Session Materials

Alex’s Google slides session presentation

Keyboard Shortcuts for Tab Management in Google Chrome (video; 1:30)