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…

Conquering the Email Battle!

If you feel overwhelmed by your email, you are not alone!

95.2 GB  Space to store my email  28% Time in the workweek spent handling email.  (1)
$10,000.00 Cost of an average worker per year due to email distractions. (2) 
38% The percentage of emails that are "important".  (3)
Email overload is a real problem, both in the business world and in Education.  The costs above are a little astonishing.  This research highlights the real cost of interrupting your concentration to check your email, impairing your decision making and leading to stress.  Many studies suggest that once interrupted, it is difficult to immediately return to the task you were working on, and some conclude that you can lose up to 40% of your productivity. (4) 
The good news is that efficiency experts are suggesting strategies to overcome email overload.   The strategies are based both on 'habit of mind' and effective use of technology tools available! 

1.  Check your email at set times of the day a fe…