How to Upload Grades From Google Classroom to Aeries

To enter scores for assignments for the unabridged form, select Scores By Assignment from any of the dashboard views. An Assignment dropdown will display when y'all click the mouse on Assignments in the header bar. At the top of the Consignment dropdown is a Search feature. The Search feature tin can be used to search for an assignment in the list. The Assignment Clarification or Assignment Number tin can be used in the Search box to search for existing assignments in the Gradebook assignment list.

An choice to Add Assignment displays beneath the Consignment search feature. The existing assignments volition display with the about current consignment at the top of the list grouped by Category. Select the assignment from the dropdown.

The following page will display. The assignment clarification and information will brandish at the top of the page with all students enrolled listed to the left of the page.

A link is available on the student name list on the left side of the Scores by Assignment page. Clicking on the student name will navigate to the Scores by Studentfolio.

To the right of the student name on the Scores Past Assignments page is a Profile and Calendar icon for each student.

Clicking on the Contour icon side by side to a educatee will navigate to the Student Profile for that pupil.

Clicking on the Calendar icon next to a student volition navigate to the Omnipresence folio for that educatee.

If the Teacher Portal group has Read permission to the Contacts (CON) table an boosted Quick Contact icon will too brandish. Clicking due north the Quick Contacts icon will display a contact list for the student.

If the pupil has an Alias name populated, the alias will display below the student name in parentheses.

When clicking in a Score field for a student on the Scores By Assignment page, the row associated with the educatee will highlight in blue. The highlighting will remain on the selected student until the user moves to the score field of another student or until the page is refreshed.

An assignment link is available by clicking on the assignment name at the summit of the page.

The Edit Consignment page will brandish for the selected consignment. Consignment data tin can be changed by using the Edit Assignment page.

Clicking on the arrows to the far left and far right of the assignment at the top of the page will move you to the previous or adjacent consignment.

Clicking on the down arrow at the top of the Scores By Assignments page will show more assignment options.

The Simply Display Students Missing Assignmentspick when checked will display just students that have been flagged equally Grading Completed and who accept no scores entered.

The score field volition display in Orange.

The Sort Students by Custom Sort Field instead of Name choice will sort the students in the custom sort gild as defined on the Manage Students page.

All students and scores will display for the assignment selected. To select a unlike consignment click the mouse on the assignments dropdown from the list in the header.

Enter the Date Completed. Enter whatsoever text in the Commentfieldor select a pre-divers Status from the dropdown if needed. NOTE: All scores entered are saved immediately.

Import Scores from File

The Scores past Assignments folio has an selection to Import Scores from File. The accustomed file formats for importing scores are .xlsx, .xls and .csv. The current required fields to import scores are Pupil ID and # Correct. If a header row is included on the Import file, the system will try and lucifer the headers with the required fields.

To Import Scores into gradebook from a file click the Import Scores from File button on the Scores by Assignment folio.

An Import Window will display. Click on the Select Files button.

Scan to select the file. If headers will be included, click on the Include Header? Option. To upload the file, click the Upload Files button.

The Import Window will display an area to assign the required fields to the columns. Select the correct required field from the dropdown for each column.

To remove a score in the file from being imported click on the 10 next to the score to not include.

Later all selections accept been made click on the Import Scores button. After import the scores volition display in the gradebook.

Import Scores from Google Classroom

If the Aeries administrator has properly configured Google Classroom integration with Aeries, so the Import from Google push will display on the Scores by Assignment page. Click this button to import scores from your Google Classroom into this Aeries Gradebook assignment.

Importing Assignments into Linked Gradebooks is not supported. Only one Aeries Gradebook tin be linked to a Single Google Classroom, if more than one Aeries Gradebook is linked, unexpected results may occur.

For Staff-Section schools, the associated Staff ID must accept Full permissions to at to the lowest degree i Gradebook to enable the 'Import from Google' button ( SSE.GBP = '' or 'F").
If the assignment in Aeries is using the Input By Standard choice to enter a dissever score for each standard, then the Import from Google push button will be disabled because at that place is no way to link the unmarried score in Google Classroom to the separate scores by standard in Aeries. The assignment tin still accept one or more standards linked to it, every bit long every bit Input By Standard is not checked.

To Import to an Existing Consignment in Gradebook:

A list of all your Google Classrooms will brandish. Click on the Classroom that contains the assignment whose scores who wish to import into Aeries.

After the Google Classroom is selected, a list of all assignments in that Classroom will brandish. Click the assignment that you wish to link to this Aeries Gradebook consignment.

The following confirmation message will display.

If the maximum points value on the Google assignment is not the same every bit the total points possible value in Aeries, the following alert will display instead. Click Confirm to import the scores anyhow, bearing in mind that the percentages in Aeries volition be impacted past this discrepancy.

Once you click Confirm, the scores from Google volition be imported into Aeries for students who take a valid Google account known to Aeries. Only "returned" scores from Google Classroom will be imported. Depending on the size of the class, information technology tin can take up to 30 seconds to import scores from Google Classroom.

NOTE:Scores from Google volition overwrite existing scores in Aeries.

When the import is completed, a summary will brandish the number of students whose scores were imported, as well as each student in the Aeries Gradebook for whom no score was imported. Click OK to return to the Scores by Assignment page, which will be refreshed with the newly imported scores.

Once a Google assignment has been linked to an Aeries assignment, that link volition be remembered. If you click the Import from Google button again on the same assignment, the post-obit message will brandish.

Click Confirm to import scores from the same Google assignment over again. Click Change to brandish the list of your Google Classrooms and link to a different assignment instead. Each Aeries assignment can exist linked to only one Google assignment at a time.

Auto Import Google Classroom Assignments

All Google Classroom assignments can exist imported into your Gradebook(s) without having to outset create assignments in your Gradebook(south). This can be done two ways:

1. Using an Import button on your Gradebooks Dashboard

two. A nightly synchronize routine that will automatically import your Assignments.

If you have at to the lowest degree one Gradebook tied to a Google Classroom, an Import Assignments From Google push button will display on your Gradebook Dashboard

Clicking this Button will take you to the Import Assignments From Google page. The folio volition display all Gradebooks tied to a Google Classroom. It will testify the Gradebook proper name, the number of assignments currently in each Gradebook, the number of Assignments in the Google Classroom for that Gradebook and a link to the Google Classroom.

To Import Assignments from Google, select the Gradebooks you want to utilize, cheque whether you lot would like to Import Scores and click Import.

Notation:This Import process is affected past the Import Assignments Already Marked equally Grading Completed and Days Past Due Engagement To Include settings on the Google Classroom tab of the Google App Integration page. If you have marked 'Grading Complete' for an assignment, scores may still import if the setting is checked on Google Classroompage. If not, and you lot wish to override a 'Grading Complete' on an assignment, employ the Import from Googleoption direct into the Assignment equally outlined above.

This will import the Assignments into your Gradebook using the Default Category that is set up. If no Categories have been ready up, a Default 'Assignments' Category will be created and the Google imports will be assigned to that one. Later the 1st import you may assign a Category to the Assignment.

Once the Import process has started the text banner at the top will show the Consignment currently being imported

When the process finishes, the concluding Import date and fourth dimension will display at the top.

Clicking on the Appointment/Time will bear witness the results of the Import. It will display whether the Assignment already exists in the Gradebook, which Assignments were imported, any Scores that were imported, including which Students did not accept Scores and whatever Scores which were updated.

At any fourth dimension you may click the Stop Importing button to terminate the procedure. Clicking Return to Dashboardvolition accept you dorsum to the Gradebook Dashboard but the import process will continue to run.

The Assignments will appear in your Gradebook according to the Due dateof the Consignment gear up in Google Classroom using the Default Category. But the Assignment and the Scores will import. Any Documents or Media you had attached to the Assignment in Google Classroom will non import, neither volition any Rubric scoring. If no Due date was assigned in Google Classroom, so the Assignment will be imported with today's engagement.

If your Administrator has configured a nightly synchronization routine with Google, your Assignments and Scores tin can be imported on a regular ground.

Any Consignment marked 'Grading Complete' will non update during this procedure.

Export to Excel

The Consign to Excel button volition export assignment scores into an Excel file. Click on the Export to Excel button and an Excel file will automatically exist created of the Scores by Consignment page data.

Mass Assign Values

Click the mouse on the down pointer on the Assignments folio on the consignment to display the Mass Assign Values push. This function tin can be used to mass add or change data. For example, if all students turned in the assignment on time a default date can be entered and all assignments will be updated with the same Date Completed.

Clicking on the Mass Assign Values button will brandish a dropdown of fields that can exist updated and the Mass Assign Values button will change to Hibernate Mass Assign.

Click on the dropdown next to the "Set up the" field to brandish the fields that tin be updated:

Select the field to update, such as Number Correct. To the right of the field, enter a value to be added to all pupil'due south class assignments. To overwrite existing values, click the mouse on the Overwrite existing values? check box. A check marking will display to Overwrite existing Values. Click the mouse on the Save Mass Changes button.

Annotation: If Overwrite Existing Values is not selected merely blanks volition be changed in the field selected.

The form will now brandish default changes fabricated to all educatee's class assignments. In the instance below, all students at present have a score of 9 for the consignment.

Click the mouse on the downwards arrow on the Assignments folio on the consignment to display the Show Stats push. After all class scores are entered clicking on the Show Stats button will brandish statistical calculations for the assignment.

Quick Data Entry

Quick Data Entry can be used to rapidly enter scores for a student on the Scores past Assignment page. Click the mouse on the downward arrow on the Assignments page on the assignment to display then click on the Quick Data Entry button.

To enter scores using the Quick Data Entry method click on the Quick Data Entry button.

The post-obit Quick Data Entry box will display.

Select a student from the Student dropdown list or enter the first characters of the educatee's first or last name. Click the mouse on the correct student to select.

Press Tab to move to the score field and blazon in the score. Printing Tab again for the score to be saved and to render to the Educatee field to select the next educatee.

The updated scores will be saved immediately and will display on the Score pages.

Bryan Regave