All Course Outcomes Templates: How to Complete Template 026

Overview:

Here are the quick instructions for utilizing Template 026 Student Transcript Course Transcript.

Make sure to read the general reporting information for templates before proceeding. Failure to follow these guidelines will result in errors and/or data validation issues.


Before Beginning, Note:

  • All steps will be completed in Row 7, downwards.


Instructions:

1. Enter the SchoolYear for the data being submitted.

  • This is the current reporting school year and NOT the calendar year.

    • Example: If the reporting school year is 2023-2024, the school year field should be 2024.

  • Note: Incorrect school year provided will cause data to not be found in Data Exchange.

2. Enter the StudentEdOrgID.

  • This is also known as the SchoolID.

  • See the chart below for more details.

School ID: Public vs. Non-Public Schools

Public

Non-Public

School ID is a ten digit number comprised from current Corporation and State assigned ID

ALL School ID’s start with 10

Next current state assigned Corporation ID - example 1234

Last ends with state assigned School ID 6789

Example School ID: 1012346789

School ID is a ten digit number comprised from current Corporation and State assigned ID

ALL School ID’s start with 10

Next Corporation ID is always four zeros - example 0000

Last ends with state assigned School ID A456 with Alpha converted to number

  • A=1, B=2, C=3, D=4

Example: School ID: 1000001456

3. Enter the STN

  • Note: Any STNs beginning with a zero will need the field or entire column to be formatted to hold the nine digits being reported. Leading zeros will be dropped upon reopening the csv file.

4. Enter the TermDescriptor. The allowable Term Descriptors are listed below on the green chart.

  • Note: The descriptors are both case and space-sensitive.

  • Note: The “Term” reported must match with the term provided on the StudentEnrollment_StudentSectionAssociation Template 018.

Term Descriptors

Fall Semester 

First Quarter 

First Trimester 

Fourth Quarter 

MiniTerm

MiniTerm One

MiniTerm Two

MiniTerm Three 

MiniTerm Four

MiniTerm Five

MiniTerm Six

Other

Second Quarter 

Second Trimester 

Spring Semester 

Summer Semester 

Third Quarter 

Third Trimester 

Year Round

5. Enter the CourseCode using this website.

  • These CourseCodes are the identified and allowable codes for reporting.

  • Remember that codes are both case and space sensitive, as well as to format your cells as TEXT.

6. For the CourseEdOrgID, enter this number exactly: “1088000000”

7. Enter the CourseAttemptResult using one of the allowable course attempt result types listed on the chart below.

  • Note: These descriptors are both case and space sensitive.

8. Enter the FinalNumericGrade.

  • This field is required for all High School credit bearing courses. The data value must be provided on a 4.0 scale and is considered the final grade or GPA the student earned in the course. 

  • Note: This field is optional for elementary and middle school courses.

9. Report the Method Credit Earned.

  • Report accurate Method Credit Earned Type to identify the method a student earned credits.

    • Allowable Method Credit Earned Types are on the chart below.

    • Note: These descriptors are both case and space sensitive.

10. Enter the EarnedCredits.

  • This field is required for all High School credit bearing courses. The data value must be a whole number (0, 1, 2, etc.) Half credits are not allowed for reporting. 

  • Note: Students failing and not earning a credit should have 0 (zero) reported.

  • Note: This field is not required for elementary and middle school courses.

11. Enter the CreditTypeDescriptor using one of the allowable descriptors listed on the chart below..

  • This field is required for all High School credit bearing courses.

  • Note: Students failing and not earning a credit must still show the type of credit they were attempting to earn.

  • Note: This field is not required for elementary and middle school courses.

  • Note: These descriptors are both case and space sensitive.

12. If Dual Credit is reported in CreditTypeDescriptor, then the External Educational Organization Id (formerly Post Secondary Institution Id) field must be completed by entering the Ed Org Id on the chart.

  • Note: This field is not required for elementary and middle school courses


Remember: Templates must be saved as a CSV file (with cells formatted as TEXT) inside of a Compressed Zipped Folder, in order to process correctly.