For use with Google Sheets™ to manage and monitor all the Google Classroom™ courses in your domain

THIS ADD-ON ENABLES SUPER-ADMINS TO: 
► manage and monitor all the Google Classroom™ courses in your domain.  
► delegate those rights to selected users to manage and monitor dynamic groups of classes.
► manage student/guardian links. 
► report on relevant Google apps usage over a period to measure student engagement. 
► monitor classroom usage over time with an overview of all announcements and assignments for all classes in the domain (or for a selection of classes). 
► report on grades awarded on all submissions and get information on assignments which students have not yet submitted and which assignments were submitted late. 

ADMINS CAN MANAGE ALL CLASSES IN THE DOMAIN. 
► archive and delete classes in bulk, 
► create new classes, 
► transfer ownership and add and remove teachers and students to and from classes. 

AN ADMIN USER (OR A DELEGATE) CAN USE THE ASSIGNMENTS MENU TO:
► get an overview of the work being set by all teachers in the domain. 
► get information about the number of assignments and announcements made for each class. 
► select a class to drill down and get, for that class, details of all those assignments and announcements. It will populate a spreadsheet to show details such as when the assignment was set, when it is due, who it was set by, the title and the description.
► edit various details of the domain's courses from a spreadsheet. This includes changing:

          ⟹ the course status (Active, Archived), 
          ⟹ course name 
          ⟹ section 
          ⟹ description 
          ⟹ room. 
          ⟹ the course owner  
You can also see how many students are associated with a course. 

► get lists of teachers and students associated with a course 
► add and delete teachers and students on a course. 
► schedule jobs to sync data about teachers and students of classes with data from your School Information System.

TEACHER CONTROL
Teachers can use the Classroom Management add on to manage all their own classes in bulk

DELEGATE ADMIN CONTROLS
Admins can use the Classroom Management add-on to delegate control of the Classrooms in the domain to selected non-admin users in the domain.


Once you have installed the add-on and setup the spreadsheet you can retrieve details of all existing courses. They are listed on the GSFEcls page. There you will see information about 
► when each class was created; 
► who the owner is; 
► the enrolment code; 
► whether or not Guardian emails have been enabled for the class.  

ENABLE VISITOR ACCESS
Admins can use the add-on to allow school leaders to visit any classroom in the domain as and when they need.

SYNC YOUR CLASSROOMS WITH YOUR SCHOOL INFORMATION SYSTEM
If you upload to the spreadsheet data from your School Information System you can also use the add-on to sync that data with the data in Classroom™. New classes will automatically be created where necessary and teachers and students automatically assigned to the appropriate classes. 


PRICING
All the features of the the add-on are free to use for 7 days from first installation. 
To use the other features you will need to purchase an Admin or Teacher  licence. The admin licence also covers all the teachers in your domain. The cost of an Admin licence is currently $150 for a year. 

An Admin licence provides this functionality for all teachers in the domain. If you purchase an admin licence it is not necessary to also purchase teacher licences.

You may need to change some settings in the admin panel to make this work. I have explained how on the link here - 

https://docs.google.com/document/d/14KJjCgDJydj8S9FrZeCLXchUIn07Il2-cXQGueA3_dk/view

Google Classroom™ is a trademark of Google LLC