Versions Compared

Old Version 2

changes.mady.by.user IDOE

Saved on

compared with

New Version 3

changes.mady.by.user IDOE

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
{"id":"xIK5TDCmeSBmtGiU6WH3-","name":"page","children":[{"id":"gz_3WeS80MeW3FH1d5Ptf","params":{"
Appanvil karma designer
summarypage
Appanvil karma designer
summary
page{"id":"xIK5TDCmeSBmtGiU6WH3-","name":"page","children":[{"id":"gz_3WeS80MeW3FH1d5Ptf","params":{"background":"#151e47ff","padding":0,"gap":10},"children":[{"id":"luCLktJRqT69ooed4ED8F","name":"row","children":[{"id":"57RMwMEF-pU6DEM3g7A3l","name":"column","children":[{"name":"image","params":{"templateId":"full-width rounded","alignment":"start","position":"center center","borderRadius":{"all":20,"bbl":0,"bbr":0,"btl":0,"btr":0,"isIndividualCorners":false},"image":{"value":"att488407041","target":"_blank","type":"attachment"},"width":243,"height":48,"link":{"value":"487915701","target":"_self","type":"page"}},"children":[],"id":"EoS8AmGCe11rGIOfr-Yvk"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"}},{"id":"XzpCYF-se5EBAKhxAt1qo","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"_QbnascCwzERqL8KPYX8V","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"-mQRUNyFJNf321IaXTrhB","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"OjzrG_OE17ZXIbusx0ps7","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"cSh2zfo9ju-PTiXG-xuNU","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}}],"params":{"layout":[1],"gap":10,"minHeight":0,"padding":10,"borderRadius":0,"size":"full"}}],"name":"section"}]}

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

3. Enter the STN. 

  • Formatting 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 SessionName.

  • Note: The SessionName reported (case and space-sensitive) must match with the SessionName reported when completing EdOrgCalendar_SessionGradingPeriod (Template 001). 

5. Enter the EventDate.

  • This is where each date the student is expected to be in attendance is reported. 

  • Note: This needs to be formatted as TEXT as “MM/DD/YYYY”.

  • Note: This could potentially be 180 records for each student if the student begins the school year at your school. 

  • Note: The dates must be valid calendar dates as set on Template 003.

  • Note: Attendance Event Dates cannot be reported on non-school days. 

  • Note: The dates being reported for attendance will need to be included within the date range provided with the corresponding SessionName on Template 001 as well.

6. Enter the EventDuration.

  • Event Duration can ONLY be reported with .5 (half) or 1 (whole) for each EventDate. Attendance is reported as being present or absent for half or whole days. 

  • Note: A student cannot have more than a whole day of attendance reported.

  • Note: Two half days (.5) of attendance may equal a whole day.

  • Note: Students cannot have .25, .33, .65, etc. reported. 

7. Enter the AttendanceEventCategoryDescriptor using the chart below.

  • These descriptors are space and case-sensitive.

  • Note: A student may have more than one attendance code reported with each code showing a .5 (half) Event Duration, as long as each code in entered on a separate row.

    1. An example of this might be a student is present for the 1st half a day and absent the 2nd half of a day.

  • Note: Students dual enrolled should have attendance reported for the days they are expected to be in attendance and these days are considered a full day of attendance if present for the duration they are expected to be in attendance. Days the students are not expected to be in attendance are not reported. These days should not be reported with any attendance date, duration, or attendance code. 

true

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

Instructions:

1. Enter the EdOrgID.

  • This is the school corporation or LEA Id. See Chart below for more details. 

Excerpt
nameHow to Complete Template 023019

Overview:

Here are the quick instructions for utilizing Template 023 Student Attendance Student School Attendance Event019 Student Program Multilingual Learner Program.

Before Beginning, Note:

  • IDOE recommends attendance data is provided no less than once a week.

  • Please confirm the accuracy of your attendance data before submitting. This avoids submitting duplicate attendance records. 

  • Data provided via Attendance Template cannot be corrected by the school submitting a new template and will require assistance from IDOE support. Therefore it is critical schools are careful in making sure the data is accurate prior to uploading.

  • There are multiple strategies for utilizing this template. A school could:

    • Create a single copy of this template for an individual student, which is updated and submitted regularly throughout the year (as long as priorly submitted rows are kept the same).

    • Create a single copy of this template for all students that is submitted monthly and regularly updated (as long as priorly submitted rows are kept the same).

    • Create a new copy of this template weekly, and all students are submitted on this template.

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

Insert excerpt
IKHTV:Attendance: DescriptorsIKHTV:Attendance: Descriptors
nameAttendanceEventCategoryDescriptors
nopanel

EdOrgID: Public vs. Non-Public Schools

Public

Non-Public

  • EdOrgID (Corp/LEA) is a ten digit number comprised from current Corporation assigned ID

  • ALL School ID’s start with 10

  • Next current state assigned Corporation ID - example 1234

  • Last ends with 0000

    • Example School ID: 1012340000

  • EdOrgID is a ten digit number comprised from current CorpID 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

2. Enter the STN. 

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

3. For ProgramEdOrgID, enter in this number exactly: 1088000000

4. For MultilingualLearnersProgramTypeDescriptor, enter this phrase exactly (case and space-sensitive): Multilingual Learners

5. Select the ProgramName from the following options on the chart below.

  • Note: these program names are both space and case sensitive.

Insert excerpt
Multilingual Learners: Program Names and Details
Multilingual Learners: Program Names and Details
nameMultilingualLearnersProgramNames
nopaneltrue

6. Enter the BeginDate.

  • This is usually the date the student starts their enrollment in the program, or first day of the school year.

  • Note: Spreadsheets will often auto-format dates. Be sure to format the cell to “TEXT”, then type the date [MM/DD/YYYY]

7. If necessary, enter the EndDate.

  • This may be if the student graduates or if student changes programs (i.e. ESL to Regular Education).

  • Schools DO NOT report end dates to the Multilingual Learner program when a student exits the school (transfers).

  • Note: Spreadsheets will often auto-format dates. Be sure to format the cell to “TEXT”, then type the date [MM/DD/YYYY]

8. If you entered an EndDate, you must provide a ReasonExitedDescriptor.

  • The available Code Values, along with their meaning, can be found on the green chart below.

CodeValue

ShortDescription

99

No longer qualifies

Note:

End of Year (EOY)

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.

...