HelpDesk
sign in

SMART Support Guide for Winter IPEDS 2025-2026

Creation date: 8/25/2025 1:00 PM    Updated: 9/5/2025 2:57 PM   2025 2025-2026 2026 annual annual report ipeds report winter
Print...

Reporting Opens:December 3rd, 2025

Reporting Deadline:February 4th, 2025 (Keyholders); February 18th, 2025 (Coordinators)


Location: Reports (Standard) > Annual > IPEDS > 2025-2026 > Winter


General Details

OnlineSMART generates data for the following sections required in Winter IPEDS:


  • Student Financial Aid

  • Cost Section 2

  • Graduation Rates

  • 200% Graduation Rates

IMPORTANT NOTES:


The Admissions section deals with school information that is not stored in (or able to be completed by) OnlineSMART.


Additionally, most schools would not qualify for the Outcome Measures portion, but SMART Support may have some ideas depending on a school’s procedures if you do need information for this section.


Please make sure all CIP codes are entered for each qualifying course under the Administration > Courses section.

Exclusions from the IPEDS:
  1. 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).
  2. 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 with each section.

Student Financial Aid


The Student Financial Aid section of IPEDS categorizes qualifying students and then looks at the information entered on their Fin Aid tab. Financial Aid reports do not look at the ledger as a student may be awarded a higher amount of financial aid, but choose not to accept all of it against their balance.

The 07 - SFA & Cost Student List is provided to assist in detailing which students make up the cohort. To confirm these numbers, perform the following tasks:

  1. Export the 07 - SFA & Cost Student List to Excel
  2. Click into Cell A1 and within the Home tab, go to Sort & Filter and click the Filter icon

01 - Financial Aid Part A

For Lines 02 and 03:

  • Filter by Early Withdrawal (Column I) for “N”

For Line 05:

  • Keep the filters from Lines 02 and 03
  • Filter by Grade Level (Column D) for “First Year, Never Attended”
  • Filter by Enrollment Type (Column C) for “FULL” (Additionally, if you determine HALF or 3/4 to be part of your full time cohort, include those as well
  • Filter by Original Start Date (Column H) to only include months of July, August, September, October, November, and December from 2024 and January, February, March, April, May, June from 2025

For Line 06:

  • Keep the filters from Line 05
  • Filter by AY1 Title IV (Column N) to exclude 0, record number of students and then clear the filter on this column.
    • Repeat the above step for each Column (O-U), and the sum of these counts will be the total for Line 06
    • If a student has entries in more than one of these Columns (N-U) then the above method will count them as duplicates. You must manually remove these duplicates to get an accurate count. (SMART Support has some tricks for making this process easier to manage so please feel free to reach out to our Support line)

For Line 07:

  • Keep the filters from Line 05
  • Filter by AY1 Title IV (Column N) to exclude 0, record number of students and then clear the filter on this column.
    • Repeat the above step for Column O, Column P and Column R, and the sum of the counts from these four columns will be the total for Line 07
    • If a student has entries in more than one of these Columns (N-P, or R) then the above method will count them as duplicates. You must manually remove these duplicates to get an accurate count. (SMART Support has some tricks for making this process easier to manage so please feel free to reach out to our Support line)

02 - Financial Aid Part BCD

Ensure you either generate a new 07 - SFA & Cost Student List to Excel report or clear all filters from the prior student list exported to Excel.


01 Grant and Scholarship Aid from the federal...

  • On your newly generated and exported 07 - SFA & Cost Student List report, filter AY1 Total Grants or Scholarships Aid (Column V) to exclude 0
  • The count of students (rows) remaining from this filter would be the ‘Number students who were awarded aid’ while the total sum of the values in Column V would be the ‘Total amount of aid awarded’

    • 01a Grants or scholarships from the federal government, state/local government, or the institution (Do NOT include student loans)

    • Clear all Filters from the prior steps in the student list exported to Excel.
    • Filter by AY1 PELL (Column K) to exclude 0, record number of students remaining, as well as the sum of all totals in this column, and then clear the filter on this column.
    • Repeat the above steps for each Column: L, P, Q, and R
      • The sum of the student counts will be the total for Line 01a Column 1
        • If a student has entries in more than one of these Columns (K, L, or P-R) then the above method will count them as duplicates. You must manually remove these duplicates to get an accurate count.
      • The total for all values in the above columns will be the total for Line 01a Column 3 (you may disregard the instruction to remove duplicated students for this field as we are looking for a total dollar amount of all disbursements)

    01b Grant and Scholarship Aid from other sources...

    • Clear all Filters from the prior steps in the student list exported to Excel.
    • Filter by AY1 Agencies (Column S) to exclude 0, record number of students remaining, as well as the sum of all totals in this column, and then clear the filter on this column.
    • Repeat the above steps for each Column: T and U
      • The sum of the student counts will be the total for Line 01b Column 1
        • If a student has entries in more than one of these Columns (S, T, or U) then the above method will count them as duplicates. You must manually remove these duplicates to get an accurate count.
      • The total for all values in the above columns will be the total for Line 01b Column 3 (you may disregard the instruction to remove duplicated students for this field as we are looking for a total dollar amount of all disbursements)

02 Federal Grants and Scholarship Aid

  • Filter by AY1 PELL (Column K) to exclude 0, record number of students remaining, as well as the sum of all totals in this column, and then clear the filter on this column.
  • Repeat the above steps for each Column: L and P
    • The sum of the student counts will be the total for Line 02 Column 1
      • If a student has entries in more than one of these Columns (K, L, or P) then the above method will count them as duplicates. You must manually remove these duplicates to get an accurate count.
    • The total for all values will be the total for Line 02 Column 3 (you may disregard the instruction to remove duplicated students for this field as we are looking for a total dollar amount of all disbursements)

    02a Federal Pell Grants

    • Clear filters from previous steps
    • Filter by AY1 Pell Total (Column K) to exclude 0
    • The count of students remaining from this filter would be the ‘Number students who were awarded aid’ while the total of this column would be the ‘Total amount of aid awarded’

    02b Other federal grants and scholarship aid

    • Filter by AY1 FSEOG (Column L) to exclude 0, record number of students remaining, as well as the sum of all totals in this column, and then clear the filter on this column.
    • Repeat the above steps for Column: Q
      • The sum of the student counts will be the total for Line 02b Column 1
        • If a student has entries in more than one of these Columns (L and Q) then the above method will count them as duplicates. You must manually remove these duplicates to get an accurate count.
      • The total for all values will be the total for Line 02b Column 3 (you may disregard the instruction to remove duplicated students for this field as we are looking for a total dollar amount of all disbursements)

03 State/local government grant or scholarship aid (includes fellowships, waivers, and employee exemptions)

  • Clear filters from 02
  • Filter by AY1 State/Local Grants (Column P) to exclude 0
  • The count of students remaining from this filter would be the ‘Number students who were awarded aid’ while the total of this column would be the ‘Total amount of aid awarded’

04 Institutional grant or scholarship aid (includes fellowships, waivers, and employee exemptions)

  • Clear filters from 02
  • Filter by AY1 Inst Scholarship (Column R) to exclude 0
  • The count of students remaining from this filter would be the ‘Number students who were awarded aid’ while the total of this column would be the ‘Total amount of aid awarded’

05 - Loans to students

  • Clear filters from 02
  • Filter by AY1 Title IV Loans (Column M) to exclude 0, record number of students remaining, as well as the sum of all totals in this column, and then clear the filter on this column.
  • Repeat the above steps for Column O
    • The sum of the student counts will be the total for Line 05 Column 1
      • If a student has entries in more than one of these Columns (M and O) then the above method will count them as duplicates. You must manually remove these duplicates to get an accurate count.
    • The total for all values will be the total for Line 05 Column 3 (you may disregard the instruction to remove duplicated students for this field as we are looking for a total dollar amount of all disbursements)

    05a Federal loans to students

    • Filter by AY1 Title IV Loans (Column M) to exclude 0
    • The count of students remaining from this filter would be the ‘Number students who were awarded aid’ while the total of this column would be the ‘Total amount of aid awarded’

    05b Other loans to students (including private loans)

    • Filter by AY1 Private Loans (Column O) to exclude 0
    • The count of students remaining from this filter would be the ‘Number students who were awarded aid’ while the total of this column would be the ‘Total amount of aid awarded’

03 - Financial Aid Part E

Ensure you either generate a new 07 - SFA & Cost Student List report or clear all filters from the prior student list exported to Excel.

This report is only concerned with your “First Time Full Time” students, so follow these initial filtering steps before following the subsequent filtering steps for each column:

  • Filter by Grade Level (Column D) for “First Year, Never Attended”
  • Filter by Enrollment Type (Column C) for “FULL” (Additionally, if you determine HALF or 3/4 to be part of your full time cohort, include those as well
  • Filter by Original Start Date (Column H) to only include months of July, August, September, October, November, and December from 2024 and January, February, March, April, May, June from 2025

01 Grant and Scholarship Aid from the federal...

  • On your newly generated and exported 07 - SFA & Cost Student List report, filter AY1 Total Grants or Scholarships Aid (Column V) to exclude 0
  • The count of students (rows) remaining from this filter would be the ‘Number students who were awarded aid’ while the total sum of the values in Column V would be the ‘Total amount of aid awarded’

    • 01a Grants or scholarships from the federal government, state/local government, or the institution (Do NOT include student loans)

    • Clear all Filters from the prior steps in the student list exported to Excel.
    • Filter by AY1 PELL (Column K) to exclude 0, record number of students remaining, as well as the sum of all totals in this column, and then clear the filter on this column.
    • Repeat the above steps for each Column: L, P, Q, and R
      • The sum of the student counts will be the total for Line 01a Column 1
        • If a student has entries in more than one of these Columns (K, L, or P-R) then the above method will count them as duplicates. You must manually remove these duplicates to get an accurate count.
      • The total for all values in the above columns will be the total for Line 01a Column 3 (you may disregard the instruction to remove duplicated students for this field as we are looking for a total dollar amount of all disbursements)

    01b Grant and Scholarship Aid from other sources...

    • Clear all Filters from the prior steps in the student list exported to Excel.
    • Filter by AY1 Agencies (Column S) to exclude 0, record number of students remaining, as well as the sum of all totals in this column, and then clear the filter on this column.
    • Repeat the above steps for each Column: T and U
      • The sum of the student counts will be the total for Line 01b Column 1
        • If a student has entries in more than one of these Columns (S, T, or U) then the above method will count them as duplicates. You must manually remove these duplicates to get an accurate count.
      • The total for all values in the above columns will be the total for Line 01b Column 3 (you may disregard the instruction to remove duplicated students for this field as we are looking for a total dollar amount of all disbursements)

02 Federal Grants and Scholarship Aid

  • Filter by AY1 PELL (Column K) to exclude 0, record number of students remaining, as well as the sum of all totals in this column, and then clear the filter on this column.
  • Repeat the above steps for each Column: L and P
    • The sum of the student counts will be the total for Line 02 Column 1
      • If a student has entries in more than one of these Columns (K, L, or P) then the above method will count them as duplicates. You must manually remove these duplicates to get an accurate count.
    • The total for all values will be the total for Line 02 Column 3 (you may disregard the instruction to remove duplicated students for this field as we are looking for a total dollar amount of all disbursements)

    02a Federal Pell Grants

    • Clear filters from previous steps
    • Filter by AY1 Pell Total (Column K) to exclude 0
    • The count of students remaining from this filter would be the ‘Number students who were awarded aid’ while the total of this column would be the ‘Total amount of aid awarded’

    02b Other federal grants and scholarship aid

    • Filter by AY1 FSEOG (Column L) to exclude 0, record number of students remaining, as well as the sum of all totals in this column, and then clear the filter on this column.
    • Repeat the above steps for Column: Q
      • The sum of the student counts will be the total for Line 02b Column 1
        • If a student has entries in more than one of these Columns (L and Q) then the above method will count them as duplicates. You must manually remove these duplicates to get an accurate count.
      • The total for all values will be the total for Line 02b Column 3 (you may disregard the instruction to remove duplicated students for this field as we are looking for a total dollar amount of all disbursements)

03 State/local government grant or scholarship aid (includes fellowships, waivers, and employee exemptions)

  • Clear filters from 02
  • Filter by AY1 State/Local Grants (Column P) to exclude 0
  • The count of students remaining from this filter would be the ‘Number students who were awarded aid’ while the total of this column would be the ‘Total amount of aid awarded’

04 Institutional grant or scholarship aid (includes fellowships, waivers, and employee exemptions)

  • Clear filters from 02
  • Filter by AY1 Inst Scholarship (Column R) to exclude 0
  • The count of students remaining from this filter would be the ‘Number students who were awarded aid’ while the total of this column would be the ‘Total amount of aid awarded’

05 - Loans to students

  • Clear filters from 02
  • Filter by AY1 Title IV Loans (Column M) to exclude 0, record number of students remaining, as well as the sum of all totals in this column, and then clear the filter on this column.
  • Repeat the above steps for Column O
    • The sum of the student counts will be the total for Line 05 Column 1
      • If a student has entries in more than one of these Columns (M and O) then the above method will count them as duplicates. You must manually remove these duplicates to get an accurate count.
    • The total for all values will be the total for Line 05 Column 3 (you may disregard the instruction to remove duplicated students for this field as we are looking for a total dollar amount of all disbursements)

    05a Federal loans to students

    • Filter by AY1 Title IV Loans (Column M) to exclude 0
    • The count of students remaining from this filter would be the ‘Number students who were awarded aid’ while the total of this column would be the ‘Total amount of aid awarded’

    05b Other loans to students (including private loans)

    • Filter by AY1 Private Loans (Column O) to exclude 0
    • The count of students remaining from this filter would be the ‘Number students who were awarded aid’ while the total of this column would be the ‘Total amount of aid awarded’

Cost Section II

The Cost Section II section in IPEDS focuses on First-Time, Full-Time (FTFT) students who are enrolled in the program with the highest enrollment during the reporting period.

Generate a new 07 - SFA & Cost Student List or clear all filters from your currently exported report.

To confirm these numbers, perform the following tasks:

  1. Export the 07 - SFA & Cost Student List to Excel
  2. Click into Cell A1 and within the Home tab, go to Sort & Filter and click the Filter icon
  3. Filter by Enrollment Type (Column C) for FULL (Additionally, if you determine HALF or 3/4 to be part of your full-time cohort, include those as well.)
  4. Filter by Grade Level (Column D) for First Year, Never Attended.
  5. Filter by Course (Column E) for just your largest course.
  6. Filter by Original Start Date (Column H) to only include months of July, August, September, October, November, and December from 2024 and January, February, March, April, May, June from 2025.

NOTE: The above filters will be the "default" filter to take the report back to after filtering for the more specific instructions below for each part: A, B, and C


04 - Cost Section II Part A

For Line 01:

  • Total number of students shown with the base filtering defined above.

For Line 02:

  • Filter by AY1 Pell (Column K) to exclude 0, record number of students remaining, and then clear the filter on this column.
  • Repeat the above steps for Columns: L, P, Q and R
  • The sum of the counts of all students tallied above will be the total for Line 02.
    • If a student has entries in more than one of these columns then the above method will count them as duplicates. You must manually remove these duplicates to get an accurate count.

For Line 03:

  • Clear the filters from Line 02
  • Filter by AY1 Title IV (Column N) to exclude 0. The count of students remaining will be the entry for Line 03

05 - Cost Section II Part B

Revert all filters and sorting options on your 07 - SFA & Cost Student List report to the default state for this report, as described in the beginning of this section

NOTE: For Part B only, add one additional filter: Exclude 0 from AY1 Grant & Scholarhip Aid (Fed/State/Inst) (Column W).

Verifying the 2024-2025 column

For Line 02:

  • Filter Housing Plan (Column G) for "On-Campus"
  • Note: This field will be a zero for most schools.

For Line 03:

  • Clear filters from 02
  • Filter Housing Plan (Column G) for "Off-Campus(with family)"

For Line 04:

  • Clear filters from 03
  • Filter Housing Plan (Column G) for "Off-Campus(not with family)"

For Line 06:

  • Clear filters from 04
  • The total for Line 06 will be the sum of all values in AY1 Grant & Scholarhip Aid (Fed/State/Inst) (Column W)

06 - Cost Section II Part C

Revert all filters and sorting options on your 07 - SFA & Cost Student List report to the default state for this report, as described in the beginning of this section

NOTE: For Part C only, add one additional filter: Exclude 0 from AY1 Title IV (Column N).

Verifying the 2024-2025 column

For Line 02:

  • Filter Housing Plan (Column G) for "On-Campus"
  • Note: This field will be a zero for most schools.

For Line 03:

  • Clear filters from 02
  • Filter Housing Plan (Column G) for "Off-Campus(with family)"

For Line 04:

  • Clear filters from 03
  • Filter Housing Plan (Column G) for "Off-Campus(not with family)"

For Line 06:

  • Clear filters from 04
  • The total for Line 06 will be the sum of all values in AY1 Title IV (Column N)

Graduation Rates


These reports look at your full time, first time students that originally started a course that has a CIP code within the reporting range (9/1/2022 – 8/31/2023), categorizes them based on gender and race, and then further breaks down that categorization.

The 13 - Graduation Rates List of Students is provided to assist in detailing which students make up Screen 1 cohort. To confirm these numbers, perform the following tasks:


  1. Export the 13 - Graduation Rates List of Students to Excel
  2. Click into Cell A1 and within the Home tab, go to Sort & Filter and click the Filter icon
  3. Filter Enrollment Type (Column G) for FULL and filter Grade Level (Column H) for First Year, Never Attended

NOTE:This report relies on Sex, Race, Enrollment Type, and Grade Level; so you also use an unfiltered 13 - Graduation Rates List of Students to ensure those boxes are not blank.


08 - Graduation Rates - Screen 1

To Verify Column 1 Numbers:

  • Filter by Sex (Column E) and Race (Column F) in accordance to what you’re searching for

09 - Graduation Rates - Screen 2

To verify Column 11 numbers:

  • Filter by Course Hours (Column D) for values 1800 and less
  • Filter by Sex (Column E) and Race (Column F) in accordance to what you’re searching for
  • Filter by students that have a Grad Date (Column J)
  • Filter by Grad Within 150% (Column W) for Y

To verify Column 12 numbers:

  • Filter by Course Hours (Column D) for values 1801 and greater
  • Filter by Sex (Column E) and Race (Column F) in accordance to what you’re searching for
  • Filter by students that have a Grad Date (Column J)
  • Filter by Grad Within 150% (Column W) for Y

Column 29 = Column 11 + Column 12


10 - Graduation Rates - Screen 3

To verify Column 30 numbers:

  • Filter by Sex (Column E) and Race (Column F) in accordance to what you’re searching for
  • Filter by students that have a Grad Date (Column J)
  • Filter by Drop Description (Column L/N/P) for “Transfer to another school”

To verify Column 45 numbers:

  • Filter by Sex (Column E) and Race (Column F) in accordance to what you’re searching for
  • Filter by students that have a Grad Date (Column J)
  • Filter by Drop Description (Column L/N/P) for “*Deceased”, “*Permanently Disabled”, “*Active Duty Armed Forces”, “*Official Church Mission”, or “*Fed Govt Serv Foreign Aid”

To verify Column 51 numbers:

  • Filter by Sex (Column E) and Race (Column F) in accordance to what you’re searching for
  • Filter by students that have a Grad Date (Column J)
  • Filter by Grad Within 150% (Column W) for Y

11 - Graduation Rates - Screen 4

To verify Column 55 numbers:

  • Filter by Course Hours (Column D) for values 1800 and less
  • Filter by Sex (Column E) and Race (Column F) in accordance to what you’re searching for
  • Filter by students that have a Grad Date (Column J)
  • Filter by Grad Within 150% (Column W) for Y

To verify Column 56 numbers:

  • Filter by Course Hours (Column D) for values 1801 and greater
  • Filter by Sex (Column E) and Race (Column F) in accordance to what you’re searching for
  • Filter by students that have a Grad Date (Column J)
  • Filter by Grad Within 150% (Column W) for Y

Column 57 = Column 55 + Column 56


12 - Graduation Rates - Screen 2 or 5

To verify Column 10 numbers:

For Recipients of a Pell Grant:

  • Filter by Pell (Column T) for “Y”
    • These students may be a larger count than the Screen 2 or 5 report because the Screen 2 or 5 report looks at students who received Pell in pay periods 11 or 12 and this student list generalizes the student receiving all Pell disbursements.

For Recipients of a Subsidized Stafford Loan that did not receive a Pell Grant:

  • Filter by Pell (Column T) for “N”
  • Filter by Title IV Loans (Column U) for “Y”

For Did not receive either a Pell Grant or Subsidized Stafford Loan:

  • Filter by Pell (Column T) for “N”
  • Filter by Title IV Loans (Column U) for “N”

To verify Column 45 numbers:

For Recipients of a Pell Grant:

  • Filter by Drop Description (Column L/N/P) for “*Deceased”, “*Permanently Disabled”, “*Active Duty Armed Forces”, “*Official Church Mission”, or “*Fed Govt Serv Foreign Aid”
  • Filter by Pell (Column T) for “Y”
    • These students may be a larger count than the Screen 2 or 5 report because the Screen 2 or 5 report looks at students who received Pell in pay periods 11 or 12 and this student list generalizes the student receiving all Pell disbursements.

For Recipients of a Subsidized Stafford Loan that did not receive a Pell Grant:

  • Filter by Drop Description (Column L/N/P) for “*Deceased”, “*Permanently Disabled”, “*Active Duty Armed Forces”, “*Official Church Mission”, or “*Fed Govt Serv Foreign Aid”
  • Filter by Pell (Column T) for “N”
  • Filter by Title IV Loans (Column U) for “Y”

For Did not receive either a Pell Grant or Subsidized Stafford Loan:

  • Filter by Drop Description (Column L/N/P) for “*Deceased”, “*Permanently Disabled”, “*Active Duty Armed Forces”, “*Official Church Mission”, or “*Fed Govt Serv Foreign Aid”
  • Filter by Pell (Column T) for “N”
  • Filter by Title IV Loans (Column U) for “N”

To verify Column 29 or 11 numbers:

For Recipients of a Pell Grant:

  • Filter by students that have a Grad Date (Column J)
  • Filter by Grad Within 150% (Column W) for Y
  • Filter by Pell (Column T) for “Y”
    • These students may be a larger count than the Screen 2 or 5 report because the Screen 2 or 5 report looks at students who received Pell in pay periods 11 or 12 and this student list generalizes the student receiving all Pell disbursements.

For Recipients of a Subsidized Stafford Loan that did not receive a Pell Grant:

  • Filter by students that have a Grad Date (Column J)
  • Filter by Grad Within 150% (Column W) for Y
  • Filter by Pell (Column T) for “N”
  • Filter by Title IV Loans (Column U) for “Y”

For Did not receive either a Pell Grant or Subsidized Stafford Loan:

  • Filter by students that have a Grad Date (Column J)
  • Filter by Grad Within 150% (Column W) for Y
  • Filter by Pell (Column T) for “N”
  • Filter by Title IV Loans (Column U) for “N”

For Less-Than-2-Year-Institutions


You will be required to complete only 2 screens. You will print out all 5 Graduation Rates (Screen 1 to Screen 2 or 5) reports and find the corresponding column that they are asking of you. The only exception is that Column 10 is the same exact data as Screen 1 Column 1. The chart below is a reference for what data you'll need to input to IPEDS and which SMART report you can find it on.


IPEDS Data Column 10 Column 45 Column 11 Column 55 Column 30 Column 51
SMART Report Screen 1 (column 1) Screen 3 Screen 2 Screen 4 Screen 3 Screen 3

Once you reach IPEDS Graduation Rates Screen 2 of 2, print the 12 - Graduation Rates Screen 2 or 5 report in OnlineSMART and it will be a direct match for entering into IPEDS.

NOTE: This section of the report can be a little confusing. Please dont hesitate to reach out to our Support line. We can quickly help make sense of what is being requested to avoid anymore frustration than IPEDS already causes.


200% Graduation Rates

This report looks at your full time, first time students that originally started a course that has a CIP code within the reporting range (9/1/2021 – 8/31/2022) and further categorizes them based on them dropping, graduating, or still being enrolled. This report relies on Enrollment Type, Grade Level, and Original Start Date; you may run the 15 - 200% Graduation Rates List of Students to ensure those boxes are not blank.


The 15 - 200% Graduation Rates List of Students is provided to assist in detailing which students make up the numbers in the 11 - 200% Graduation Rates report in OnlineSMART. To confirm these numbers, perform the following tasks:

  1. Export the 15 - 200% Graduation Rates List of Students to Excel
  2. Click into Cell A1 and within the Home tab of Excel, go to Sort & Filter and click the Filter icon

For 06 Additional exclusions (between 151%-200% of normal time):

  • Filter Enrollment Type (Column D) for FULL
  • Filter Grade Level (Column E) for First Year, Never Attended
  • Further filter by Additional Exclusions (Column Q) for Y.

For 08 Number of students in the cohort who completed a program between 151%-200% of normal time to completion:

  • Filter Enrollment Type (Column D) for FULL
  • Filter Grade Level (Column E) for First Year, Never Attended
  • Further filter by 151-200% Completer (Column R) for Y.

For 09 Still enrolled as of 200% of normal time to completion:

  • Filter Enrollment Type (Column D) for FULL
  • Filter Grade Level (Column E) for First Year, Never Attended
  • Further filter by Still Enrolled at 200% (Column S) for Y
    • As Enrollment Type, Grade Level, and Original Start Date are important fields for this report, ensure that none of your students within the 15 - 200% Graduation Rates List of Students report have a blank entry for these fields.

Please Remember that SMART Support is available to address any questions during normal business hours.

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.

IPEDS Report Winter Menu Screenshot.png
Step-by-step guides for utilizing various functions, reports, and data verification in OnlineSMART.
Get help for this page