Skip to main content

Google Classroom Rosters in Google Sheets, Easy!

By
Are you a user of Google Classroom? Do you work with your students' data in Google Sheets? Have you ever thought "I wish there was a way to grab my roster from Classroom and put it into a Spreadsheet. Ugh."

Well, now there is a way! Meet... rosterSync!



From the site...

rosterSync - Teacher Edition allows teachers to sync a Google Classroom course roster -- including student email addresses -- directly with Google Sheets for handy use with Add-ons like Doctopus, formMule, autoCrat, formRanger, and others.

Installing this Tool...


  • I installed the Sheets Add-on, which can be found here
  • I clicked the blue "FREE" button
  • An "Untitled Spreadsheet" opened up and the Add-on was installed
  • Easy! 

Using rosterSync...


  • After titling my Sheet (as any good Google Drive user does), I clicked "Add-ons" in the menu bar
  • I choose "rosterSync - Teacher Edition"
  • A few seconds later, I had this convenient sidebar at the right of my Sheet.
  • I selected the sheet a wanted to port my roster to,
  • Picked the Google Classroom course I wanted to pull my roster from,
  • Chose my "Sync direction" (from Classroom to Sheet, recommended),
  • And clicked the button "Run Sync", Done!
  • Seconds later I had my Classroom roster in Sheets.
  • Pure Sweetness!

As we use Google Forms more and more and; therefore, make more use of Google Sheets, I can see this as a valuable tool at the beginning of a course/class for any teacher. Using Google Classroom with rosterSync just make it that much more awesome!

Geek signing out!


Labels:

Comments

Post a Comment

Popular posts from this blog

Google Docs: Fonts for Early Elementary

By Jessica Winstanley
Sample of search results from fonts.google.com A couple weeks ago, I was sitting in a training with a bunch of my favorite lower elementary teacher friends, and several of them were lamenting the fact that it is hard to find "good" Google fonts for the little people they work with on a daily basis.  Specifically, it is a challenge to find the single story lower case a and the open 4 .  This conversation, of course, sent me out on a mission to remedy this for these fantastic people.  So, the next day I put on my headphones, turned up the tunes on Spotify, and dived into the website fonts.google.com .  This website lists all the Google fonts available.  It also allows you to type in your own letters and numbers and see them in all the various fonts.  For my purpose, I typed in "abckgy 1234 This is the font."  From here I could see all 877 fonts, and look specifically for the a   and the 4.  It was quite an adventure, and I came across...
Post a Comment
Read more

It's time to change your password!

By Jessica Winstanley
There are several times a year when it is important to change your password.  Your password will expire every 90 days. When your windows computer informs you that your password will be expiring soon, CHANGE IT THEN! It is also always a good idea to change your password before going on break so that you do not get locked out of your computer, email or gradebook.  Here is how you change your password from the school windows computers. On your Windows desktop/TEC computer , press the Alt, Ctrl and Delete buttons at the same time. Click on "Change a Password" on the menu below: Enter your username, if needed, and follow the directions on screen. If you are off site or working solely on a Chromebook , you can use the VDI (Virtual Desktop) to change your password.   Simply go to vdi.portageps.org.  Click "VMware Horizon HTML Access."  Click "Accept."  Login with your portage username (leave off the @portageps.org) and password.  Click "Login." ...
Post a Comment
Read more

Skyward Tech Tip: Student Birthday List

By Jessica Winstanley
Would you like to get a list of your students' birthdays from Skyward? This can be done in just a few clicks. Step 1: Login to Skyward and select the blue gradebook for the class you want to print usernames and passwords for - elementary staff, you can just select any of your gradebooks. Step 2: Go to the reports menu at the top of the screen and select Class Roster. Step 3: Choose Student Name & Student Info, then select Clone Template. Step 4: Give your new template a name, such as Birthdays. Click Save. Step 5: Select how you want the Names to Display, then UNCHECK all the boxes. Now only check Birth Date. Click Save. Step 6: Now you can select the template you just created. Click Print. Step 7: A PDF preview will open. From here you can choose to save or print. You do this by placing your curser in the bottom right corner of the screen and clicking on the picture of the disc (save) or the printer (print). This is what the report would look like:...
Read more