Tag : google

post image

List all Google Classroom Groups With Scripts


Sometimes it’s nice to check in and see who is using Google Classroom across your Google Apps organization.

The script (which was adapted from another blog here) will allow you to create a spreadsheet with a full list of classes taught by everyone in your organization.

It will also show you the:

  • -Teacher Name
  • -Creation Date
  • -Enroll Code
  • -Number of enrolled students

In order for the script to work properly, you’ll need to set up a few things:

  1. Visit Google Scripts 
  2. Under Resources, choose Advanced Google services
    Screenshot 2015-12-17 at 8.12.46 PM
  3. Turn on the Admin Directory API, Google Classroom API, and Drive API
    Screenshot 2015-12-17 at 8.14.19 PM
  4. Click the Google Developers Console link in the same dialog from step 3.
  5. Find and enable the Admin SDK, Drive API,  and Google Classroom API
    Screenshot 2015-12-17 at 8.18.10 PM
  6. Click the Run button to execute your code (the black triangular icon).
    Screenshot 2015-12-17 at 8.21.28 PM
  7. Now if you visit your Google Drive, you will have a new Sheets file named Google Classroom Listing / Count
    Screenshot 2015-12-17 at 8.25.33 PM
    (if you have a large number of teachers/classes, this file may take a few minutes to populate)

  8. You can rerun this script from script.google.com any time you would like to update the list of classes and/or the number of students in each class.
  9. Coming soon: View a list of the students in each class

The Code:

post image

5 Things Chromebooks Do Better Than iPads

HP Chromebook 11

I have been an iPad user since Apple released them in 2010 and a Chromebook user for the past few months.  In that time, I have found that the Chromebook has many great selling points for both the education user and the general population.  Here are my top 5 so far:


Keyboard and Mouse

Let’s face it, if you are doing anything beyond basic short bursts of typing for emails, web urls, and tweets, an on screen keyboard has its limits.  The Chromebook that I am using right now has a very well built keyboard (clearly Macbook inspired) and mouse, both of which give me the tactile feel I have grown accustomed to when typing.  Of course iPads support a variety of wired and wireless keyboards, but it is nice to have everything all in one form factor without the need to pack an extra keyboard everywhere you go.



Working with A Variety of File Types

Have you ever tried to work with anything other than a photo on an iPad?  It is often miserable.  Something as routine as saving a PDF from a website and sending it as an attachment can only be accomplished with the help of 3rd party apps that not all users have the time or experience to download.  The Chromebook lets you save documents right to the hard drive and/or the Google Drive, making them easily accessible to email to other users or open in another program.



USB Support

Even though the Cloud has many of us ditching the USB drives, there are still many times in my week when I am approached by a colleague who has documents on a thumb drive.  Chromebooks have full support for USB drives, mice, keyboards, and many other USB peripherals that iPad users have been asking for since 2010.



Adobe Flash!

Even though most modern websites have moved on to HTML5 and other mobile friendly designs, there is still a lot of great content out there that uses Flash.  I find it incredibly stubborn that Apple still refuses to support Flash.  Not only does the Chromebook support Flash, it updates it silently in the background for me (so no more constant annoying reminders, like my PC and Mac).



Staying Up To Date

I really like and appreciate the silent updates of the Chromebook.  The only sign that an update has taken place is the occasional arrow in the notification area telling you that an update will be applied on the next restart.  Even then the update is so quick you probably would not know it was happening.

**Full Disclosure: I love both Chromebooks and the iPad.  I own several of each and both are very useful in their own right.**