Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

...

Instructions:

1. Enter the SchoolYear for the data being submitted (2024).

  • This is NOT the calendar year.

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 017.

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. Enter the CourseAttemptResult using one of the allowable course attempt result types listed on the yellow chart below.

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

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

7. Enter the CourseAttemptResult using one of the allowable descriptors listed on the chart below.

Note: These descriptors are both case and space sensitive.

Insert excerpt
IKHTV:Student Academic Record: Descriptors and Code Values
IKHTV:Student Academic Record: Descriptors and Code Values
nameCourseAttemptResultDescriptors
nopaneltrue

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. 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.

 

10. Enter the CreditTypeDescriptor. This field is required for all High School credit bearing courses. There are three available descriptors (they are both space and case sensitive).

Insert excerpt
IKHTV:Student Academic Record: Descriptors and Code Values
IKHTV:Student Academic Record: Descriptors and Code Values
nameCreditTypeDescriptors
nopaneltrue

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

  2. 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.

...