Manage teachers and students

Free Trial

Install

The gsfeTchrs and gsfeStdnts pages will give you a list of the teachers and students currently in the classes listed in the gsfeCls page. You can also add teachers and students to those classes or remove teachers and students from the classes. Instructions for that are at the bottom of this page.

Managing teachers and Students in your classes

gsfeTchrs & gsfeStdnts

These page will give you lists of the teachers and students for the classes listed in the gsfeCls page. The fields are very similar for both sheets. They are used to manage the membership of the classes.

Class Name

name of the class

Class ID

Unique ID number for the class -hidden from users

Teacher

Email address of the teacher

Section

Section for the class

Status

Status of the class

Description Heading

This is not accessible through the normal Classroom Interface - it is useful in the syncing process

Owner?

This field is set to Y if the teacher is the owner of the class. You cannot remove the teacher from the class unless you transfer ownership first.

Add Student/Add Teacher

Put a Y in here to add a teacher or a student to the class. The Sync process will add a student or teacher record and put a Y here when you run the sync process - if the person needs to be added to the class.

When you run the update process this will be changed to the word Added

Delete Student/Add Teacher

Put a Y in here to remove a teacher or a student from the class. The Sync process will put a Y here when you run the sync process - if the person needs to be removed from the class.

When you run the update process this will be changed to the word removed

Date Actioned

When you run the process to add or remove a teacher or student this field will show the date actioned or an error message if it can't be actioned.

First Name

Surname

I added these at the request of a user

_______________________________________________________

Get details of teachers in the classes

Select Classroom Manager>Admin Menu from the add-ons menu That will open the sidebar

Select Students and Teachers data from the sidebar menu

Select GetGSFE data - this will open a new window

Select List - that will open a pop up window

Select Get GSFE Teachers - This will get Teachers data for all the classes listed in the gsfeCLS sheet.

Data will be pasted to the gsfeStdnts sheet - existing data will be over-written

It is important that you leave the window open while it is running. In my domain with about 2100 classes and an average of 2 teachers per class it takes 4 minutes to retrieve the data.

Get details of students in the classes

Select Classroom Manager>Admin Menu from the add-ons menu That will open the sidebar

Select Students and Teachers data from the sidebar menu

Select GetGSFE data - this will open a new window

Select List - that will open a pop up window

Select Get GSFE Teachers - This will get Teachers data for all the classes listed in the gsfeCLS sheet.

Data will be pasted to the gsfeStdnts sheet - existing data will be over-written

It is important that you leave the window open while it is running. In my domain with about 2100 classes and about 40,000 student/class records it takes 15 minutes to retrieve the data.

add teachers to classes

Click on to the gsfeTchrs sheet

if you haven't already done so run the process to fill the sheet with the current list of teachers in the classes listed in the gsfeCls page

To add a new teacher you need the teacher's email address and the Course Id which you can get from the gsfeCls page

Add those 2 details in a new row anywhere on the gsfeTchrs sheet and put a Y in the Add Teacher column

Repeat for all the teachers you want to add then from the sidebar menu select Students and Teachers data and click on the button to Add teachers

The script will run to add teachers which have a Y in the add teachers column as the teachers are added the data in columns H and J will be updated to report success or failure

add students to classes

Click on to the gsfeStdnts sheet

if you haven't already done so run the process to fill the sheet with the current list of students in the classes listed in the gsfeCls page

To add a new student you need the student's email address and the Course Id which you can get from the gsfeCls page

Add those 2 details in a new row anywhere on the gsfeStdnts sheet and put a Y in the Add Student column

Repeat for all the students you want to add then from the sidebar menu select Students and Teachers data and click on the button to Add students

The script will run to add students which have a Y in the add students column. As the students are added the data in columns F and H will be updated to report success or failure

remove teachers from classes

Click on to the gsfeTchrs sheet

if you haven't already done so run the process to fill the sheet with the current list of teachers in the classes listed in the gsfeCls page

To remove a teacher you need to put a Y in column I

Repeat for all the teachers you want to remove. Then from the sidebar menu select Students and Teachers data and click on the button to Remove teachers

The script will run to remove teachers which have a Y in the remove teachers column as the teachers are removed the data in columns I and J will be updated to report success or failure.

Please note - you cannot remove a teacher who is the owner of the class. To do that you will have to transfer ownership to another teacher first

remove students from classes

Click on to the gsfeStdnts sheet

if you haven't already done so run the process to fill the sheet with the current list of students in the classes listed in the gsfeCls page

To remove a student from a class you just need to put a Y in column G

Repeat for all the students you want to remove then from the sidebar menu select Students and Teachers data and click on the button to Remove students

The script will run to remove students which have a Y in the remove students column. As the students are removed the data in columns G and H will be updated to report success or failure

Report abuse