Skip to main content

Get a Class Roster easily with the Roster Extension!

A simple class roster provides a lot of uses for teachers.  They help track who you've conferenced with, who has completed a project and even allow you to upload your roster to other tools like Turnitin or Zipgrade.

Alice Keeler, the acknowledged Queen of Google Sheets, asked her nephew to create a Google Chrome extension that pulls a roster from Google Classroom and creates a Google Sheet with student information.

Watch the video below to see how it works or follow the written directions following the video!

Navigate to Alice's Website or to the Google Chrome Web Store.  Click the Add to Chrome button. 

You need to authorize the extension the first time you use it:

Once installed, look on your Chrome browser after the address bar.  Locate the Roster Extension icon and click it.

 Click the List classes button.  A list of your Google Classroom classes will appear.

Select the desired class.  

Click Make roster:

Google creates a Sheet using the name of your Google Classroom, and provides the last name, first name, full name, and email of the students in your class.

Make it easy for yourself! 

Highlight the far right column next to the email address.  Click Insert>Checkbox to add checkboxes in this column. 

Update the sheet with checkmarks electronically when you a student has completed the task, or print out the roster and keep track on paper!


Popular posts from this blog

Brain Research and Studying: Top Two Strategies you can help your students use

As midterm exams approach, your students are facing the challenge of preparing for them.  Cognitive learning research provides insight into the best practices for studying. 

 The Top 2 Study Strategies are Retrieval Practice and Spaced Learning: Retrieval Practice  Retrieval Practice is the act of pulling information out of your brain.  For example, you remember what you know about a word, topic, or lesson, pull itout of your brain and then articulate it in some way.  For example, you write down everything you remember.  This is the way your brain really wants to learn!  
Retrieval Practice is the opposite of reviewing notes or the textbook and trying to 'stuff' the knowledge into your brain!

Teacher Action:   If you are holding review session(s) or providing review documents, incorporate places for students to write everything they can remember about the topic before they interact with your review material.  Encourage them to not only write but create images, tables, whatever …

Grading in Google Classroom - Using the Comment Bank & More!

Google Classroom updates in August incorporated some big changes!  Grading in Google Classroom has been upgraded with a new grading feedback tool that features a Comment Bank.  Feedback is a huge part of the learning process, and the Comment Bank is designed to make giving and receiving feedback faster and easier.

New Features in Grading

Comment Bank Watch this excellent (and short!) video by Google Classroom/Google Sheets Guru Alice Keeler on how to use the Comment Bank.

For a quick recap (and for speedy feedback):
The Grading/Feedback tool automatically defaults to 'Suggestion' mode.

Use the shortcut keys Option + Command + M on a Mac to invoke comments.

Within the comment box, type #to open the Comment Bank. *  *Google Classroom will show the last 5 comments you have used.  Most teachers will have more than 5 comments in the Comment bank.  If you want to use a comment that isn't shown, type the #(hashtag) and begin typing a word found in the comment you want!  The list wi…

Just Released! Intelligent Search in Google Drive

Google has been busy this week, updating both GMail and Google Drive!

I have been excitedly waiting for the Intelligent Search feature in Google Drive.  Everyone could use a little help finding items in their Drive!

You are familiar with the Quick Access files Google shows you via their Artificial Intelligence (AI). 

Place your cursor in the search box located above your Google Drive.

Courtesy of Google Artificial Intelligence, you see a new list of options:

First:  Suggested search queriesNext:  Top collaboratorsNext:  File types, edit history, priority items, and more! Do you miss the old search box where you have additional criteria you can add?  Click the Advanced Search found at the bottom of the box.  The advanced search dialogue box you opens for your use!