School Loop must first assign rights for the grade export system to a school or district designated person. That person may in turn assign rights to others in the same school site. These rights may be granted to anyone with a principal, assistant principal, staff, or system admin account. Use the Grade Export Rights link in Quick Links to grant rights.
Click the Grade Export System link in Quick Links to get started. There are three steps to prepare your school to export grades from School Loop to your Student Information System (SIS).
Marking Period Setup
For each marking period you must specify the window of opportunity for teachers to submit grades.
Set one marking period at a time or all the marking periods for an entire year.
1. Click the New Marking Period button.
2. Display Name: Use a name familiar to staff. For example, First Quarter Progress Report.
3. Enter a Unique Code: Any value will do here as long as each marking period has a unique value.
Note: Do not change this code once teachers have submitted grades. The system will consider this a new marking period and submitted grades will no longer be available. If this does happen, changing the code back to the original code will restore the grades.
4. Marking Period Ends Date: Enter the last day of the Marking Period. Grade submissions will include any classes active on this date. Be sure to choose a date that falls within the term that is active in this marking period. Specify the date in this format: mm/dd/yy
5. Window Opens: Enter the date and time teachers can begin submitting grades.
6. Window Closes: Enter the date and time teachers will no longer be able to submit grades.
7. Click Submit when finished and then click the Return to Grade Export Setup button.
Column Setup
Click the Edit button to set up a column:
Tip: To exclude a column from the grade submission page for teachers, remove all previously entered values.
Tip: Use the Save Settings File section to store all your settings in a downloadable file. This file may be used to quickly configure a site. It’s also useful for schools that change the comments based on the grading period.
Add/Edit Column
Name: Value Required: If you wish to require teachers to choose a comment, click the On button.
Values (export to SIS): Enter the value required by your SIS (e.g. A, B, 1, 2).
Legend (optional): Enter the conduct grade, work habits grade or comment (e.g. Satisfactory, Needs Improvement, A pleasure to have in class).
Current Values: Teacher View: A preview of how teachers will see this column. You may reorder the comments and, if desired, make a value the default choice.
Click Save and Back when finished. Continue setting up columns until finished and then click the Return to Grade Export Setup button.
Tip: Choosing a default value for conduct and work habits can save teachers time when exporting grades.
Tip: If a column is required, teachers may not export until a value is chosen for all students.
Import/Export Settings File
Once you've completed the column setup, you may export your settings to a text file. This settings file may be used to quickly configure another school or to create sets of alternate settings.
Custom Columns and Variable Credits
The grade export system contains the most common columns used by the Student Information Systems we support. If your SIS contains columns that are not included here, we may be able to add a custom column for you.
If you are using Aeries SQL or PowerSchool, and your school uses variable credits, we can add this column for you. It can be a pull-down menu containing the values you specify, or it can be a text field so teachers can enter any variable credit value they want.
Contact School Loop if you want to add a custom or variable credit column.
Multiple Grade Columns
For schools that require and can support multiple grade columns, our Grade Export System allows additional fields to be gradebook loadable. For example, your school may require teachers to submit a 4th quarter grade and a final semester grade. Teachers would be able to select the source of grades for each grade column, which then populates those grade columns with the letter grades from the selected gradebooks or progress reports.
Contact School Loop if you want to make additional columns gradebook loadable.
Create Import File
1. Select the marking period for which you wish to export grades. Only current or past marking periods will appear in this list.
Teachers who have submitted grades are listed in the right column. The left column lists teachers who have not yet submitted grades. Click the envelope icon to send a reminder email to one or all teachers who have not submitted grades.
2. Click the Create Import File Button.
3. Select all the teachers whose grades you wish to include in the export file.
4. Click the Create Import File button to save the import file on your hard drive. You may change the file name, but do not change the extension (slgrd or csv).
Tip: As an option, you may check the box next to Remove +/– From Grades before creating the import file.
