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 that are familiar with student academic records.

Selection Criteria

How Students are selected for this report:

The school has opted in for Direct Admission and has been approved by the Universities of Wisconsin.
The student has an active enrollment during the specified date range.
The student is correctly identified for Direct Admission Reporting (select a Student > Compliance > Direct Admission Reporting).

Additional Criteria

The selected GPA calculation must be an unweighted calculation and must follow the Universities of Wisconsin guidance.
The GPA calculation must be on 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.
High School Math courses need be identified with the correct SCED Course Code or Roster Course Code (Courses > Select a Course > District - General > Wisconsin State Information).
Universities of Wisconsin Class of 2027 Accepted Math Courses for Direct Admit
- For courses with a Roster Code of 10150 or SCED: 2135, a student can qualify as math compliant for First Unit, Second Unit and Third Unit.
Direct Admit Wisconsin Resources for High School Partners - Here you can find an overview, key dates, webinars, technical documentation, etc.
Math classes are considered complete when:
- The Historical Grade has earned credit that is > 0
- The Roster_Course_Code_2526 is one of the DPI listed Course Codes OR
  the SCED12_Course_Code_2526 is one of the DPI listed SCED codes.
If running prior the District having completed the Year End Process use the option - Run for Current Grade 11, (running before EOY process).

Public Schools should download the State Courses (Data and Reporting > Data Exchange > State Courses)
Choice Schools will need down the Roster Course codes from the Department of Public Instruction. Update all the High School Mathematics courses with the appropriate Roster Code from the .xlsx. See Roster Course Code. See Defining District Courses.

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 Universities of Wisconsin 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.
Amount of current course credit hours to be used for in progress and future math classes.	Select percentage.
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	WISEid	The student’s WISEid.	[Students]State_StudentNumber
D	Student Number	Student’s Number	[Students] student_number
E	Generated Tier as of Today A Tier will not be generated if: On Track to Graduate is blank or No. Total Math Classes Completed or in Progress is less than 3 credits.	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 A Tier will not be stored if: On Track to Graduate is blank or No. Total Math Classes Completed or in Progress is less than 3 credits.	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	Total Math Credits Earned/In Progress	Indicates the total math credit earned/in progress by a student based on the CREDIT levels for the class of 2027.	N/A
L	Total Math Credits Earned/In Progress First Unit	Indicates the total math credit earned/in progress by a student for the First Unit (1 credit max.).	N/A
M	Total Math Credits Earned/In Progress Second Unit	Indicates the total math credit earned/in progress by a student for the Second Unit (1 credit max.).	N/A
N	Total Math Credits Earned/In Progress Third Unit	Indicates the total math credit earned/in progress by a student for the Third First Unit (1 credit max.).	N/A
O	Total Math Credits Earned/In Progress Fourth Unit	Indicates the total math credit earned/in progress by a student for the Fourth Unit (1 credit max.).	N/A
P	Total Math Credit Earned Frist Unit	Indicates total math credit earned by a student for the First Unit (1 credit max.).	N/A
Q	Math Classes Completed First Unit	The the math classes a student has completed the First Unit.	N/A
R	Total Math Credit In Progress First Unit	Indicates total math credit in progress (based on the dates specified at run time) for a student for the First Unit (1 credit max.)	N/A
S	Math Classes in Progress First Unit	Indicates the math classes in progress (based on the dates specified at run time) for the First Unit.	N/A
T	Total Math Credit in Future Schedule First Unit	Indicates total math credit in future classes for a student (based on the term the user runs the report from, in most cases this will be zero as the master schedule is not committed until June) for the First Unit (1 credit max.).	N/A
U	Math Classes in Future Schedule First Unit	Indicates the future math classes for a student (based on the term the user runs the report from, in most cases this will be zero as the master schedule is not committed until June) for the First Unit.	N/A
V	Total Math Credit Earned Second Unit	Indicates total math credit earned by a student for the Second Unit (1 credit max.).	N/A
W	Math Classes Completed Second Unit	The the math classes a student has completed the Second Unit.	N/A
X	Total Math Credits In Progress Second Unit	Indicates total math credit in progress (based on the dates specified at run time) for a student for the Second Unit (1 credit max.).	N/A
Y	Total Math Classes in Progress Second Unit	Indicates the math classes in progress (based on the dates specified at run time) for the Second Unit.	N/A
Z	Total Math Credit in Future Schedule Second Unit	Indicates total math credit in future classes for a student (based on the term the user runs the report from, in most cases this will be zero as the master schedule is not committed until June) for the Second Unit (1 credit max.).	N/A
AA	Math Classes in Future Schedule Second Unit	Indicates the future math classes for a student (based on the term the user runs the report from, in most cases this will be zero as the master schedule is not committed until June) for the Second Unit.	N/A
AB	Total Math Credit Earned Third Unit	Indicates total math credit earned by a student for the Third Unit (1 credit max.).	N/A
AC	Math Classes Completed Third Unit	The the math classes a student has completed the Third Unit.	N/A
AD	Total Math Credits In Progress Third Unit	Indicates total math credit in progress (based on the dates specified at run time) for a student for the Third Unit (1 credit max.).	N/A
AE	Total Math Classes in Progress Third Unit	Indicates the math classes in progress (based on the dates specified at run time) for the Third Unit.	N/A
AF	Total Math Credit in Future Schedule Third Unit	Indicates total math credit in future classes for a student (based on the term the user runs the report from, in most cases this will be zero as the master schedule is not committed until June) for the Third Unit (1 credit max.).	N/A
AG	Math Classes in Future Schedule Third Unit	Indicates the future math classes for a student (based on the term the user runs the report from, in most cases this will be zero as the master schedule is not committed until June) for the Third Unit.	N/A
AH	Total Math Credit Earned Fourth Unit	Indicates total math credit earned by a student for the Fourth Unit (1 credit max.).	N/A
AI	Math Classes Completed Fourth Unit	The the math classes a student has completed the Fourth Unit.	N/A
AJ	Total Math Credits In Progress Fourth Unit	Indicates total math credit in progress (based on the dates specified at run time) for a student for the Fourth Unit (1 credit max.).	N/A
AK	Total Math Classes in Progress Fourth Unit	Indicates the math classes in progress (based on the dates specified at run time) for the Fourth Unit.	N/A
AL	Total Math Credit in Future Schedule Fourth Unit	Indicates total math credit in future classes for a student (based on the term the user runs the report from, in most cases this will be zero as the master schedule is not committed until June) for the Fourth Unit (1 credit max.).	N/A
AM	Math Classes in Future Schedule Fourth Unit	Indicates the future math classes for a student (based on the term the user runs the report from, in most cases this will be zero as the master schedule is not committed until June) for the Fourth Unit.	N/A
AN	FERPA Consent	The date of FERPA consent.	[S_STU_DirectAdmit_X]FERPA_Consent_Date
AO	DA Include	Indicates if the student is included in Direct Admission.	[S_STU_DirectAdmit_X]DA_Include_YN
AP	On Track To Graduate	Indicates if the student is on track to graduate.	[S_STU_DirectAdmit_X]On_Track_Grad_YN
AQ	Unweighted GPA Calculation Method	This is the Unweighted GPA Calculation Method selected on the Report Parameter page.	N/A
AR	GPA Stored	Selection for Store GPA and Tier that was selected at Runtime.	N/A