Because AdminPlus and TeacherPlus Gradebook integrate seamlessly as one system, you can easily receive grades from TeacherPlus into the Report Cards module. You can also import grades from other systems, such as GradeQuick, APWeb Teacher, or a file on your computer that you exported from an LMS gradebook (for example, Haiku or Finalsite).
Receive Grades from TeacherPlus Gradebook
After a teacher has entered grades into the gradebook, they're available for you to receive into AdminPlus. It's recommended that the teachers complete the Submit process in TeacherPlus Gradebook before you receive grades, but grades are available to you regardless of whether a teacher has submitted them or not.
- In Report Cards, click Ent. Grades.
- In the Enter Grades dialog box, click 6. Receive from TeacherPlus Gradebook, and then click Next.
- Click the Current Marking Period drop-down list, and then click the marking period you want to receive grades from.
In the Gradebook Columns list, select the check box(es) next to any column(s) that you want to receive into AdminPlus.
For the Receive Which Grades specification, do either of the following:
- Click Yes next to Skill and/or Course to receive skill and/or course grades from TeacherPlus Gradebook.
- Click No next to Skill and/or Course to opt out of receiving skill and/or course grades.
- Click Next once you've set the relevant specifications.
- In the Checking Gradebook Server for New Grades dialog box, click Yes, and then click Done when the sync is complete.
Select the check box(es) next to any gradebook(s) you want to receive grades from, and then click Save Grades from Selected Gradebooks.
If you think a teacher may have submitted their gradebook since your last sync, click TeacherPlus Sync before you receive grades.
Import Grades from GradeQuick
- In Report Cards, click Ent. Grades.
- Click 4. Receive from Grade Quick, and click Next.
Click next to the Receive From box, browse your computer, click the desired file, and then click OK.
Click next to each applicable Write GQ box, click the appropriate report card column, and click Select.
- Click Done.
Import Grades from APWeb Teacher
- In Report Cards, click Ent. Grades.
- Click 5. Receive from APWeb Teacher, and click Next.
Select the check box(es) next to any course you want to import, and click Receive From Holding Bin.
The holding bin contains data imported from APWeb Teacher (or other compatible applications), which you then manually receive into AdminPlus.
Import Grades from a File (LMS Import Tool)
The following are required in an import file:
- Tab or comma delimited format
- Student key field (UNID, APID, GUID, etc)
- Course and Section number: They can be separated into two fields or combined in one field
- Acceptable formats: CRSSC, CRS/SC, and CRS-SC
- Earned grades
- Term designation
The LMS Import Tool requires an initial activation code. Also, importing skills, comments, or narratives from an import is not yet supported.
- In the Report Cards module, click Enter Grades, and then click Receive from file, and click Next.
In Select Import File, click , select a comma or tab delimited file from your computer, and set the import file type to Comma Delimited or Tab Delimited.
The following figure illustrates steps 2-5.
For the How many header lines to ignore configuration, enter the number of rows AdminPlus is to ignore in the import file (that is, the number of rows before the grade data actually begins).
Typically, an import file only contains one row of field label information that is to be ignored, for which you would enter the value 1 in this step. However, it's possible that a school may have an import file containing extra rows of preliminary information, such one row with information about the school and another row with field label information (requiring a value of 2). Remember to double-check your import file to determine how many rows should be ignored.
For Which header line that contains the field names, enter a number corresponding to the row where the field names are located.
This is the row containing the labels for student ID, class code, term, and grade. If this is the very first row in your import file, then enter a value of 1. If there are other rows of extra information in the import file before this row, find out which row contains the field labels and enter the number corresponding to the row.
- For How many fields per records, enter the total number of information columns in the import file.
Set the primary key in the import file to the field containing the student ID, and set the primary key in AdminPlus to the student's Unique ID (UNID).
The Primary Key is an item of data that should uniquely identify an individual student. This item of data must exist in both the import file and your AdminPlus database. Matching this data ensures that the information in each line of the import file gets posted to the correct student.
The following figure illustrates steps 6-8
In the Field from file column, click a column cell, and select a field in the import file that matches the AdminPlus field in the Key fields column.
For example, for the AdminPlus Course ID field (located in the Key fields column), click the corresponding cell in the Field from file column, and select a field in the import file that matches the course ID.
In the Field format column, select the format for the Course ID and Section ID, and click Next. The following formats are available: CRS (Course), SC (Section), CRSSC (CourseSection), CRS-SC (Course-Section), and CRS/SC (Course/Section)
About setting the Course ID and Section ID format:
Let's say an import file has one column set aside for the course and another column set aside for the section. In the course column, an example course could appear as 702, and in the section column, the field could appear as 01. In this example, we set the course field format to CRS and the section format to SC.
Now, imagine that the import file contains one column for both the course and section. In this example, course 702, section 01 appears as one field as 70201. We would then set both the course and the section field format to CRSSC. Similarly, if the course and section were separated by a dash (702-01), we would configure both the course and section to CRS-SC, and if the values were separated by a slash (702/01), we would set both fields to CRS/SC.
- Repeat steps 7 and 8 for Section ID.
For specification 1 in the column Marking Period Columns From File, click a cell corresponding to a marking period to be imported, and select the marking period as it appears in the import file. Repeat this step as needed for additional relevant marking periods.
The following figure illustrates steps 10 and 13.
- Select the check box corresponding to the marking period (mentioned in step 10). Repeat this step as needed for other marking periods.
- For specifications 2 and 3, set the grade range that the import will affect by choosing a Start Grade and End Grade. For example, if this import only applies to juniors and seniors, the Start Grade would be 11 and the End Grade would be 12.
Leave the last specification 4 as Receive them into another section of the same course, and click Next.
About specification 4:
This setting only applies to the rare occurrence of there being a section mismatch between the import file and AdminPlus when students are moved from one section to another. For example, a student could have been moved from English section 1 to section 2. If the student and grade still happen to be associated with the former section 1 in the import file (even though the student is now in section 2 in AdminPlus), this setting ensures the grades are received into the proper section in AdminPlus.