University of Delaware
Upcoming Events

Standard COGNOS Reports - Student Data

Disclaimer
  1. The report data available here is for UD staff INTERNAL USE ONLY. It is NOT for re-distribution to any other UD department. Should you be contacted by an outside vendor for data, direct them to the Registrar's Office Reporting team.
  2. Unless otherwise noted, these reports use Cognos data marts which are refreshed nightly from UDSIS. The report data will be AT MOST one day old, compared to UDSIS.
  3. Do NOT re-use old reports. Since information is updated nightly, re-generate the report using the links below, or contact the Registrar's Office Reporting team.
  4. UD Staff are required to protect confidential student data. PNPI guidelines and FERPA guidelines.

SETUP:

Security: These reports require the COGNOS Access role: SA_SR_USERS. Use this form to request COGNOS access. (More info from UDEW).
Browsers:

  • Internet Explorer 7 - 9 is recommended. Perform this one-time setup.
  • There are known problems using Internet Explorer 10 and Chrome.
  • Firefox should also work for running these reports.

TRAINING:

We sponsor periodic LearnIT training sessions on how to use Standard Reports with Excel. Also available is the video: Using Excel with Registrar's Standard Reports.

NOTES:

  1. When prompted to login to COGNOS, use your UDelNet ID and password.
  2. The output format is set as Spreadsheet.
  3. Since some reports are extensive, select to receive these by email.
    1. Click Select a Delivery Method.
    2. Choose Email report.
    3. In the From/To Email options window, click Attach the report and then click OK.
    4. When prompted ...Do you want to close this window? click OK.
  4. Internet Explorer 9 users (6-24-13)    There is a current problem with the Delivery Method "Email report". If you need to receive the report by email, try a different browser, or run the report directly from our Registrar Standard Reports folder.

QUESTIONS / COMMENTS?

Please contact the Registrar Reporting team.
If the Standard Reports listed here do not provide the data you need, UD staff may submit a request for a custom report.  (Login required)



Report

Notes

Prompts
(Enter in COGNOS window/tab)

ENROLLMENT

E1. Students Active for Term by Program


   >> Run Report

Includes GPA. Results may be filtered to highlight a specific range.

  1. PROGRAM_STATUS: Select Active in Program.
  2. ACADEMIC_TERM: choose the desired Term. Then click OK button at bottom of screen.
  3. Select Program(s). Then click Finish button to the right.

NOTE: If students are not enrolled in classes, they will no longer appear on this report after the 10th day of classes (Fall/Spring) or after the Academic Penalty deadline (Winter/Summer).

E2. Students Active for Term by Major/Minor with all plans


   >> Run Report

Students in plans outside of their primary program ARE automatically included.

Includes GPA. Results may be filtered to highlight a specific range.

  1. PROGRAM_STATUS: Select Active in Program.
  2. ACADEMIC_TERM: Choose the desired Term.
  3. ACADEMIC CAREER : Select GRAD or UGRD. Click Reprompt.
  4. (Optional) Select MAJORS and/or MINORS. Then click Finish button to the right.

NOTE: If students are not enrolled in classes, they will no longer appear on this report after the 10th day of classes (Fall/Spring) or after the Academic Penalty deadline (Winter/Summer).

E3. Grade Distribution Crosstab with average


   >> Run Report

Provides a Grade Distribution report by course subject and term.

  1. ACADEMIC_TERM: Choose the desired Term.
  2. SUBJECT: Select your Course Subject code. Click Submit to get a report of all courses, OR, to choose a specific course, click Select Catalog Number.
  3. (Optional) CATALOG NUMBER: Select your Course Catalog number(s) and click Submit.
E4. Class Roster by Term, Subject, Catalog Number and Section


   >> Run Report

Provides a class roster of those currently enrolled by term, in a specific course and section.

After grades are posted (see Academic Calendar), this report will also list student course grades.

  1. PROGRAM_STATUS: Select Active in Program.
  2. ACADEMIC_TERM: Choose the desired Term.
  3. SUBJECT: Select your Course Subject code or Select all. Click Reprompt.
  4. CATALOG NUMBER: Select your Course Catalog number(s) or Select all. Click Finish or Reprompt to optionally choose Section numbers.
  5. (Optional) SECTION: Select the desired Section(s) and click Finish.
     
E5. Active Students but not Enrolled in Classes for the Term


   >> Run Report

Provides a list of students who are active and eligible to enroll for the term, but currently have NOT enrolled. See NOTES.

  1. ACADEMIC_TERM: Choose the desired Term.
  2. PROGRAM_STATUS: Select Active in Program.
  3. NO further action is required to select ALL for the following values:

    (Optional) ACADEMIC CAREER: Select the desired career(s).
    (Optional) ACADEMIC PROGRAM: Select the desired program(s).
    (Optional) ACADEMIC PLAN: Select the desired plan(s).
     
  4. Click Finish.

NOTES: This report can ONLY be run during a specific time period, starting approximately one week before registration begins for a future term, through the following deadlines for the current term:
Fall/Spring: through the 10th day of classes
>Winter / Summer: through the Academic Penalty deadline
This report cannot be run for past terms.

If enrollment does not occur, these students will no longer appear on this list after the 10th day of classes (Fall/Spring) or after the Academic Penalty deadline (Winter/Summer).

E6. Enrollment Census reports

  (from IR- UDSIS Official Extract data mart)

   >> Run Report


Registrar's Office Summary Webpage: Opening Day and Official Enrollment Numbers by Term

This report menu provides enrollment figures for the FIRST, OFFICIAL(end of drop/add period) or LAST day of the semester with breakdowns available by Gender, Time Status and Residency.

Optional prompts within these categories allow colleges/departments to request their specific student data. The prompts chosen by the user appear at the bottom of the report.

NOTE: Reports by default are created in html format. This allows you to click on the counts to receive the underlying student detail in Excel format.

FIRST Prompt page:
  1. ACADEMIC_TERM: Choose the desired Term and then click the Reprompt button at the top of the page (next to the light bulb).
  2. RUN_DATE_ID: Select FIRST - First day of Classes, LAST - Last day of Classes, or TENTH - Official Enrollment=End of the Drop/Add period.
  3. Click OK and you will move to the second prompt page.
    (Ignore the Select a delivery option request.)

SECOND Prompt page:

  1. NO action is required to select ALL for the following values. If you don't want to make further selections, click Finish at the top of the page.
    OR.....

  2. (Optional) CAMPUS(es): Select the desired campus.
    (Optional) ACADEMIC CAREER(s): Select the desired career(s).
    (Optional) ACADEMIC PROGRAM(s): Select the desired program(s).
    (Optional) ACADEMIC PLAN(s): Select the desired plan(s).
    (Optional) HONORS STUDENTS (ONLY): Click the Y button if you want to restrict the report to Honors students..
    (Optional) INTERNATIONAL STUDENTS (ONLY): Click the Y button if you want to restrict the report to International students..
     
  3. Click Finish.
  4. (Optional) Retrieving Student Detail for a specific count:
    • In the .html report, click the count for which you would like detail information.
    • You will receive a report is running message and then you will be prompted to open or save the associated Excel file.
  5. (Optional) To save the .html report as a .pdf file,
    • Click on the View icon in the top right bar (to the left of Add this report).
    • Choose View in PDF Fromat.
    • If you move your cursor over the bottom-middle of the pdf, a toolbar will appear with options to print or save the file.
E7. Courses Near Full - Newark On-Campus Only


   >> Run Report

Provides a list of courses by subject(s), with their Enrollment Totals and Caps, as of Start of Day when the report is run.

  1. TERM: Choose the desired Academic Term and then click Finish or continue your selection.
  2. (Optional) COLG(s): Select the desired college code(s) and then click Finish or continue your selection.
  3. (Optional) PRIMARY DEPT(s): Select the desired department code(s) and click Finish.
E8. Course Enrollment Caps and Totals


   >> Run Report
    (E8a - List only)

Provides a list of courses by subject(s), with their Enrollment Totals and Caps, as of Start of Day when the report is run. Choose the report version including course subtotals, or the list-only version.

  1. ACADEMIC_TERM: Choose the desired Term.
  2. SUBJ: Select the desired course subject(s).
  3. Click Finish.

ADVISEMENT

A1. Students with Incomplete grades


   >> Run Report

May be run by Colleges or Departments prior to the 10th day of the following semester, to check for students in jeopardy of a negative Academic standing due to the change of an Incomplete grade.

  1. PROGRAM_STATUS: Select Active in Program.
  2. ACADEMIC_TERM: choose the desired Term.
  3. PROGRAM(s): Select Program(s). Then click OK button at bottom of screen.
A2. Students with Term GPA < 2.0 and CUM GPA > 1.999


   >> Run Report

May be run by Colleges or Departments to identify students for outreach prior to receiving a derogatory academic standing.

  1. PROGRAM_STATUS: Select Active in Program.
  2. ACADEMIC_TERM: choose the desired Term.
A3. Students with Term GPA < 2.0 and CUM GPA > 1.999 with Courses


   >> Run Report

Same report as above. Also included are semester classes and grades.

  1. PROGRAM_STATUS: Select Active in Program.
  2. ACADEMIC_TERM: choose the desired Term.
A4. Students on Probation (CUM GPA < 2.0)


   >> Run Report

Lists student Cum GPA and Deficit points.

  1. PROGRAM_STATUS: Select Active in Program.
  2. ACADEMIC_TERM: Select the desired Term.
  3. PROGRAM: Select desired program(s).
A5. Students Active for Term by Major/Minor with all plans and all advisors


   >> Run Report

May be run by Colleges or Departments to obtain lists of all students and their plans, their Advisors, and to check for students without an Advisor.

Includes GPA. Results may be filtered to highlight a specific range.

  1. PROGRAM_STATUS: Select Active in Program.
  2. ACADEMIC_TERM: choose the desired Term.
  3. PLAN: Select Major(s) and/or Minor(s). Then click OK button at bottom of screen.

NOTE: If students are not enrolled in classes, they will no longer appear on this report after the 10th day of classes (Fall/Spring) or after the Academic Penalty deadline (Winter/Summer).

A6. Faculty Advisor and Students Assigned (by term)


   >> Run Report

May be run by Colleges or Departments to obtain a list of all students assigned to an Advisor for the term.

  1. PROGRAM_STATUS: Select Active in Program.
  2. ACADEMIC_TERM: choose the desired Term.
  3. ADVISOR_PRIMARY_NAME: Select Advisor's name. Then click Finish OR...
  4. (Optional) PLAN(s): Select plan(s) and click Finish.
A7. Students Enrolled in more than one Pass/Fail Course


   >> Run Report

May be run by Colleges or Departments to advise students who are enrolled in more than one Pass/Fail course for the term, in violation of UD policy.

  1. PROGRAM_STATUS: Select Active in Program.
  2. ACADEMIC_TERM: choose the desired Term.
  3. ACADEMIC PROGRAM: Select the desired program(s)and click Finish.

GRADUATION

G1. Students Expecting to graduate by Term


   >> Run Report

Report name: Expected Grads by College Major Grad Term

  1. PROGRAM_STATUS: Select Active in Program.
  2. ACADEMIC_TERM: Select the Current Term. Hit OK at bottom of screen.
  3. CAREER TYPE: Select UGRD and/or GRAD and hit Reprompt.
  4. PROGRAM: Select desired program(s) or Select all and hit Reprompt.
  5. PLAN: Select Major(s) and/or Minor(s)or Select all.
  6. EXPECTED GRAD TERM: Select grad term and click Finish.
G2. Students Expecting to graduate by Term, including currently-registered courses


   >> Run Report

Report Name: Expected Grads by Prog Plan Exp Grad Term with courses

May be used to verify credits needed and/or requirements to be met.

  1. PROGRAM_STATUS: Select Active in Program.
  2. ACADEMIC_TERM: Select the Current Term. Hit OK at bottom of screen.
  3. CAREER TYPE: Select UGRD and/or GRAD and hit Reprompt.
  4. PROGRAM: Select desired program(s) or Select all. Click Reprompt.
  5. PLAN: Select Major(s) and/or Minor(s) or Select all.
  6. EXPECTED GRAD TERM: Enter grad term and click Insert. Click Finish.
G3. Seniors, based on Cumulative Units, by College and Major


   >> Run Report

Report name: Seniors by College and Major

May be used to verify the Expected Grad term information is correct.

  1. PROGRAM_STATUS: Select Active in Program.
  2. ACADEMIC_TERM: Select the Current Term.
  3. PROGRAM: Select desired program(s) or Select All. Follow screen directions re: Finish or Reprompt.
  4. (Optional) PLAN: Select Major(s) and/or Minor(s) or Select all. Click Finish.
G4. Degrees/Certificates Conferred with Plan by Program and Grad Term


   >> Run Report

Report name: Degrees Conferred with Plan by Program and grad term

Provides a list of students who have earned their degree or a certificate in the Program and Term specified. Note that degrees are posted by the Registrar's Office a few weeks after graduation.

  1. DEGREE/CERTIFICATE COMPLETION_TERM(s): Select desired term(s).
  2. DEGREE PROGRAM(s): Select desired program(s). Hit FINISH to run the report or REPROMPT to select plan(s).
  3. PLAN DESCRIPTION(s) or CODE(s): Select Major(s) and/or Minor(s) or Select All and click Finish.
G5. Degrees Conferred with Minor and Grad Term


   >> Run Report

Report name: Degrees Conferred by Minor and grad term

Provides a list of students who have earned their degree with the MINOR specified. Note that degrees are posted by the Registrar's Office a few weeks after graduation.

  1. DEGREE COMPLETION_TERM(s): Select desired term(s).
  2. PLAN Description(s)or Code(s): Select desired Minor plans(s).
    Note: MINOR Plan Code(s) have the format: ___-MIN.
  3. Click Finish.
G6. Students Expecting to graduate by Term, including Primary Advisor


   >> Run Report

Report name: Expected Grads by College Major Grad Term and Primary Advisor

Provides a list of students expecting to graduate by advisor.

Student information is duplicated for each advisor, so that the report can easily be sorted and distributed for review.

  1. PROGRAM_STATUS: Select Active in Program.
  2. ACADEMIC_TERM: Select the Current Term.
  3. CAREER TYPE: Select desired career(s).
  4. PROGRAM: Select desired program(s).
  5. PLAN Code(s): Select Major(s) and/or Minor(s).
  6. Expected Grad Term: Select desired Expected Graduation term.
  7. Click Finish.