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 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).
Math classes are considered complete when:
- The Historical Grade has earned credit that is > 0
- The Course_Code is one of the DPI listed Course Codes OR
  the SCED5_Course_Code 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 should download all 2024-25 courses 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 Completed	Indicates the number of math credits the student has completed.	N/A
L	Math Classes Completed If a grade is manually entered only the Course number will display.	Indicates the course and section number of the math classes the student has completed.	N/A
M	Total Math Credits in Current Schedule	Indicates the total number of credits in the student’s current schedule.	N/A
N	Math Classes in Current Schedule	Indicates the course and section number of the math classes in the student’s current schedule.	N/A
O	Total Math Credits in Future Schedule This information comes from the student’s schedule for the selected Academic Year. The PowerScheduler Commit Master Schedule must be completed.	Indicates the number of math credits the student has in progress (is enrolled in).	N/A
P	Math Classes in Future Schedule	Indicates the course and section number of the math classes in the student’s future schedule.	N/A
Q	FERPA Consent	The date of FERPA consent.	[S_STU_DirectAdmit_X]FERPA_Consent_Date
R	DA Include	Indicates if the student is included in Direct Admission.	[S_STU_DirectAdmit_X]DA_Include_YN
S	On Track To Graduate	Indicates if the student is on track to graduate.	[S_STU_DirectAdmit_X]On_Track_Grad_YN
T	Unweighted GPA Calculation Method	This is the Unweighted GPA Calculation Method selected on the Report Parameter page.	N/A
U	GPA Stored	Selection for Store GPA and Tier that was selected at Runtime.	N/A
V	Amount of Course Credit	Selection for Amount of current course credit hours to be used for in progress and future math classes selected at Runtime.	N/A