Reporting Opens:September 6th, 2023
Reporting Deadline:October 18th, 2023 (Keyholders);
November 1st, 2023
(Coordinators)
Location: Reports (Standard) > Annual > IPEDS >
2023-2024 > Fall
- This guide will break down each report that is found within OnlineSMART.net for the 2023/2024 Fall IPEDS
and outline the data being pulled in particular so you may audit your data accordingly.
- You will need to make sure all CIP codes are entered for each qualifying course under the
Administration > Courses section of OnlineSMART.
- NOTE: OnlineSMART generates 2 of the 3 sections required for Fall IPEDS: 12 Month Enrollment and
Completions. The third, Institutional Characteristics, deals with school information and is not able
to be completed by the system.
- These reports exclude any student in a course with no CIP code. If the student’s course does require a
CIP code, make sure that it has been entered under Administration > Course > CIP Code; if the
course is not supposed to have a CIP code, enter a zero (0).
- These reports exclude any student who dropped within 4 days if they are in a course less than 900 Hrs,
and 14 Days if they are in a course greater the 900 Hrs. These students can be found on the Student List
reports associated to either 12-month Enrollment or Fall Completions.
This report looks at your students that were actively enrolled in a course that has
a CIP code within the reporting range (7/1/2022 – 6/30/2023) and sorts them by gender and race. It is
important that you make sure all students have a gender and race selected on their profiles, as well as a
start date, so that this report pulls accurate results.
If a student has more than one active record during the date range, they will be counted for each record. If
this is the case, you will need to subtract the duplicated students from their overall count on this report.
The 12 Month Enrollment Student List is provided to assist in detailing which students make up the numbers
in OnlineSMART. To confirm these numbers, perform the following tasks:
- Export the 12 Month Enrollment Student List to Excel
- Click into Cell A1 and within the Home tab, go to Sort & Filter and click the Filter icon
- Click on the filter icon for Early Withdrawal (Column O) and uncheck the "Yes" box if present
PLEASE NOTE: Since Race, Sex, Enrollment Type, and Grade Level
are important fields for this report, ensure that none of your students within the 12 Month Enrollment
Student List report have a blank entry for these fields.
For the First-Time, certificate seeking Full Time Undergraduate Students:
- Filter Enrollment Status (Column Q) for Full Time
- Filter Grade Level (Column R) for First Year,
Never Attended
- Filter Start Date to check only those within July 2022 to June 2023
- Further filter by Sex (Column K) and Race (Column J) in accordance to what you’re searching for
For the All Other Full Time Undergraduate Students:
- Filter Enrollment Status (Column Q) for Full Time
- Remove the First-Time, certificate seeking Full Time Undergraduate Students from this list
- Further filter by Sex (Column K) and Race (Column J) in accordance to what you’re searching for
For the Part-Time, certificate seeking Full Time Undergraduate Students:
- Filter Enrollment Status (Column Q) for what you don’t determine as Full Time
- Filter Grade Level (Column R) for First Year, Never Attended
- Filter Start Date to check only
those within July 2022 to June 2023
- Filter Start Date to check only those within July 2022 to June 202
- Further filter by Sex (Column K) and Race (Column J) in accordance to what you’re searching for
For the All Other PART Time Undergraduate Students
- Filter Enrollment Status (Column Q) for PART
- Remove the First-Time, certificate seeking Full Time Undergraduate Students from this list
- Further filter by Sex (Column K) and Race (Column J) in accordance to what you’re searching for
This report looks at your students’ schedules and tallies the total amount of hours
scheduled for all students within the reporting date range. The Full Time Equivalent, or FTE, is calculated
by taking the total scheduled hours generated under Contact Hour Activity, and divides the amount by 900.
This report will not generate Credit Hour Activity, and the Calculated FTE/Prior Year FTE fields are
generated by IPEDS.
One thing to note is that it is important that you clear schedules for students
after they drop or graduate after the date of their drop/graduation so that this report is accurate.
The 12 Month Enrollment Student List is provided to assist in detailing which
students make up the scheduled hours in OnlineSMART. To confirm these numbers, perform the following tasks:
- Export the 12 Month Enrollment Student List to Excel
- If the report is already opened from 12 Month Enrollment – Part A, go into the Home tab and
clear the filters
- If filters are not enabled yet, click into Cell A1 and within the Home tab, go to Sort & Filter
and click the Filter icon
- Click on the letter L, above cell L1 – Scheduled Hours Within Range, to highlight the entire column.
- At the bottom right in Excel, you’ll see a Sum of the total hours of that column which should align
with the hours in the report
- If the hours don’t align, there are student that were not active within the date range who are
still scheduled within the date range
OnlineSMART offers three reports to provide statistics on completers. You will need to determine if you need
to run this report for All Completers or whether you will run it for each different course to sort their
numbers by level/by CIP data.
The main differences are:
- Completions – All Completers
- Shows all students who graduated within the date range
- Completions By CIP data
- Shows those students who had graduated in the reporting date
range and are in a course that has
a CIP code
- Completions By Level
- Allows you to select the course you wish to report on, and adds
an Age table to further identify
those students who had graduated within the reporting date range in that specific
course
These reports will break down the race and gender of graduates who had an actual
graduation date
within the
reporting date range.
We created these options to allow schools to comply with the addition to the IPEDS
regarding tracking completions by level. Some schools will have different levels of awards, certificates, or
diplomas.
To ensure these reports are accurate, students will need to have their race, gender and DOB input on
their profiles, and have an actual graduation date within the reporting date range.
The IPEDS Fall Completions Student List is provided to assist in detailing which
students make up the numbers in OnlineSMART. To confirm these numbers, perform the following tasks:
- Export the IPEDS Fall Completions Student List to Excel
- Click into Cell A1 and within the Home tab, go to Sort & Filter and click the Filter icon
- Click on the filter icon for Sex (Column F) and uncheck M or F, depending on which cohort you’re
verifying
- Click on the filter icon for Race (Column E) and choose Sort A-Z. You’ll be able to count the
students that meet that Sex and Race criteria that is shown within the report.
- Alternatively, you can filter out by race one by one to verify the count as well.
- (OPTIONAL) If performing the verification by CIP Data, click on the filter icon for CIP Code (Column
J) and check/uncheck boxes depending on which cohort you’re verifying
- (OPTIONAL) If performing the verification By Level, click on the filter icon for Age (Column I) and
choose Sort A-Z.
- Alternatively, you can filter out by ages within the criteria you’re looking for.
Feel free to reach out to us via phone at (480) 744-0050 during our office hours of
Monday - Friday 7:00AM - 3:30PM MST.
Or email any time at [email protected]