With GAT+ Classrooms you can export your Classroom data to a Google Spreadsheet that can be modified and imported back to create, delete and make changes to many Courses.
One course can be selected. When it is exported to a spreadsheet, the classroom row can be copied and repeated many times to create multiple new classrooms with different subjects, teachers and students. When these are re-imported (after the original Course id is removed from the new duplicate rows) each new class will be created and you will have the chance to confirm it is correct before it goes live.
In this document, we are going to walk through the steps necessary to create, delete and modify classroom data.
Export to spreadsheet: The first step is to make sure the data is up to date, refreshing the data if necessary, then optionally apply any filters to limit the number of courses to export. In the example below we selected a single classroom called French and pressed ‘Export to CSV’ to use the classroom as a template.
Prepare data in the spreadsheet: GAT will only read the columns in the first sheet: “Course Id, Name, Description, Long Description, State, Created By, Teachers, Students”, all of them are optional except the Course Id column that is always required. Any other columns will be ignored. You can rearrange the order of the columns as you want (and remove optional columns that are not going to be updated). See more important details in the Details section below.
Import the spreadsheet: Click on ‘Import Data’ and GAT will show you a list of recently modified Classroom spreadsheets. Select the one you modified. GAT will read and parse the data, comparing it with the latest version stored in GAT. If a cell has students/teachers different than the same course in GAT, the course will be updated to reflect the new information, both adding and removing students/teachers as necessary. Any blank cell is interpreted to clear any item (except the Course Id cell).
Review the changes: GAT will show you a table describing the changes visually, the items to be added and the items to be removed like this. You can find some alert icons if some validation constraints are not met. This is the time to decide if everything looks fine or you can click Discard Changes and import a modified spreadsheet again.
Apply the changes: When you click on Apply Changes GAT will translate the changes detected into Classroom API requests and executes them. You can refresh the page to see the state of the changes. There will be icons besides each change item showing “check” if successful or “alert” if any error. You can view the error message in a tooltip over the icon. GAT will merge the successful changes with the stored data, so you don’t need to run a new scan before making more changes.
- If deleting courses: Set the Course Id cells with the courses to be removed and the State must be set to the value DELETED.
- If creating new courses: If the Course Id cell is blank GAT will recognize the row as new course data. To successfully create a course at least Name and Created By fields must be provided. The Created By field usually is a teacher email address because Google will automatically add it to the Teacher’s collection.
- Adding students/teachers using multiple rows: You can add user email addresses separated by commas in a single cell, the same way GAT is doing, but there is another way, add addresses in different rows while keeping the same value in the Course Id cells. For new courses, you can create the course first without students and then copy the new Course Id to the sheet to add students in different rows.