Course Requirements in Illuminate, is a way of tracking students' progress throughout HS (could be used at MS or ELEM) to see if they are going to meet a particular purpose/goal.
A "Graduation Requirement" (ie. Grad Check) is generally one that you would add to track if a student is making enough progress to graduate from HS. As an addition, you can add a "UC/CSU Requirement" to track whether a student is taking/progressing through UC/CSU-related courses to get into those college systems. Another example is a CalGrant course requirement, used for tracking CalGrant-related courses and determining a CalGrant GPA. Possibilities are endless!
Any request to import this data should go to [email protected].
Course Requirement Import Spec
Course Requirements consist of 3 parts:
Course Requirement: Column A,B,C. These pieces define what type of requirement this is and for which year's students.
Category: Columns D,E,F. Within the course requirement, these columns define the category(ies). Column F identifies what the minimum credits required to meet this category.
Courses: Columns G, H. Within each category, these are the courses that match/meet the category and what the priority is within this requirement.
Instead of using the manual tools through the UI you could submit a spreadsheet with the following rules:
1. Illuminate will be adding a unique Course Requirement per Name (Column A) AND Academic Year(Column B). So if I have 100 rows in which I have the name "Graduation Requirement" and Academic Year "2014", this will create one unique course requirement called "Graduation Requirement" for 2014. Please keep your requirement name/year consistent if your intention is to keep the aligned categories/courses under one bucket. FYI that a course requirement called "Grad Check" > "2014" is uniquely different than the one called "Graduation Check" > "2014". Even the smallest things, such as having an extra space, will create a new requirement.
2. Per academic year, Illuminate only allows for one Course Requirement to be flagged as a Grad Check(C). Having this Y flag in addition to tagging the students' Graduation Requirement Year (on Demographic Details page), Illuminate can automatically determine which Grad Check applies to which student. Please ensure that if you should have more than one course requirement per year, that only one can be flagged as Y, while the others are flagged N. Otherwise, you can flag all as N.
3. Course(G) and priority level(H) is unique per course requirement(A) and year(B). Keep in mind, this is NOT a priority per category. For example, if course 100A is a P1 in the Math category within the Graduation Requirement 2014, it cannot be P1 in a different category within that Graduation Requirement 2014. To add the course to another category within that same requirement, it must be a priority that is not already used by that course within that requirement (P2, P3, etc).