Student Academic Review for Direct Admission

This creates a CSV audit file of all selected student(s) and their Direct Admit status. This can be run with or without storing the GPA and Tier. The information in the file should be reviewed by school staff.

Selection Criteria

How Students are selected for this report:

The School has opted in for Direct Admission and has been approved by Minnesota Office of Higher Education.
The Student has an active enrollment during the specified date range.
The Student is indicated to be submitted for Direct Admission > select a Student > State/Province - MN > Direct Admission Reporting.

Additional Criteria

The selected GPA Calculation Method must be an unweighted calculation.
THE GPA calculation must be a 4-point scale.
GPA calculations will be rounded to 2 decimals after the decimal point.
Only Schools with students in grade 12 may be selected.
The calculated English, Math, and Science GPA’s will be determined using the following:
- High School English, Math and Science courses need be identified with the correct MCCC Course Code (Courses > Select a Course > District - General > Minnesota Common Course Catalog (MCCC) > Course Code).
  - For any course to be considered the MCCC Course Level must be B, E, D, or G.
  - For Science:
    - The MCCC Course Code must start with 03 and can’t be '03215','03232','03233','03237','03238'
  - For Math:
    - The MCCC Course Code must start with 02 and can’t be '02005','02032','02033','02034','02036','02037','02955'
  - For English:
    - The MCCC Course Code must start with 01 and can’t be '01001','01009','01030','01031','01034','01035','01036','01043','01049'
The historical grade Course number ([StoredGrades]Course_number) must be associated to a valid course.
- The historical grade Hist. grade level ([StoredGrades]Grade_level) must be 10 or 11.
- The historical grade Potential credit hours ([StoredGrades]PotentialCrHrs) must be greater than 0.
- The historical grade GPA Calculation ([StoredGrades]ExcludeFromGpa) must be Include (0 or false).
- The historical grade GPA points ([StoredGrades]GPA_Points) will be used to generate the average GPA value.
If running prior the District having completed the Year End Process use the option - Run for Current Grade 11, (running before EOY process).

Report Input

Field	Description
Academic Year	Select the academic year. This will be the year that the student is a senior.
Select School	Select the school to run the report.
Select Students	Indicate which students to include in the report by selecting one of the following options: The selected [number] students only – Run the report for students in the current selection. All students – Run the report for all students in the current school or district that meet the selection criteria. If you run the report for a single student or a group of students, select the students prior to running the report.
Enrollment Entry Date	Enter the enrollment entry date for the students you wish to report.
Enrollment Exit Date	Enter the enrollment exit date for the students you wish to report.
Unweighted GPA Calculation Method. Method must follow Minnesota Office of Higher Education criteria.	Select the unweighted GPA calculation method. District Office > Setup > Grading > GPA Calculations
Store GPA and Tier	Select Yes or No.
Run for Current Grade 11, (running before EOY process).	Select Yes or No.
Scheduling	Select Run Now or Schedule to determine when to run the report.

Report Output

Item	Data Element	Description	Table[Field Name]
A	First Name	The student’s first name.	[Students]First_Name
B	Last Name	The student’s last name.	[Students]Last_Name
C	MARSS Number	The student’s MARSS number.	[Students]State_StudentNumber
D	Student Number	Student’s Number	[Students] student_number
E	Generated Tier as of Today	The student’s generated tier as of today.	N/A
F	Generated GPA as of Today	The student’s generated GPA as of today.	N/A
G	Stored Tier	The student’s stored Tier.	[S_STU_DirectAdmit_X]Stored_Tier
H	Stored GPA	The student’s stored GPA.	[S_STU_DirectAdmit_X]Stored_GPA
I	Tier Override	Tier override.	[S_STU_DirectAdmit_X]Override_Tier
J	GPA Override	GPA override.	[S_STU_DirectAdmit_X]Override_GPA
K	English GPA (Average)	GPA average for English.	N/A
L	Math GPA (Average)	GPA average for Math.	N/A
M	Science GPA (Average)	GPA average for Science.	N/A
N	C Average or higher	Indicates if the student has a C average or higher. Options are: Y = Yes N = No	N/A
O	FERPA Consent	The date of FERPA consent.	[S_STU_DirectAdmit_X]FERPA_Consent_Date
P	DA Include	Indicates if the student is included in Direct Admission.	[S_STU_DirectAdmit_X]DA_Include_YN
Q	Unweighted GPA Calculation Method	This is the Unweighted GPA Calculation Method selected on the Report Parameter page.	N/A
R	GPA Stored	Selection for Store GPA and Tier that was selected at Runtime.	N/A