QN36b

Printer-friendly version

	Banner Student Information Reports
	Quicknote #36B	October 2007

Introduction:

This Quicknote is intended to supplement Quicknote 36 in assisting UM-Flint Banner Users with Student Information reports in the ssem2000 database. Student Information reports are alphabetized lists of student names and addresses based on criteria such as major or minority status. Please refer to Quicknote 36 for instructions on opening the database and information about other types of reports contained in it.

¨ Introduction

¨ Student Information

■ Current Students by Major

■ Current Students by Minor

■ Minority Students by Term

■ Advising Report by Major

■ Registration Audit Report

¨ Additional Resources

Student Information:

After opening the ssem2000 database, double-click on the Student Information form in the database window. You will be notified that the report data is current as of the moment it is run. Click OK.

**Note: All options on the Student Information form require the user to select a term from the drop-down list provided. You may be prompted to login using your Banner ID and password before the term list will display. Do not attempt to type a term code or to click on any report button prior to selecting a term from the list provided; otherwise, the form will not work properly and must be reset by clicking the Close Form button.

The following reports are available in the Student Information form.

¨ Current students by Major (Address/Phone)

¨ Current students by Major (Detailed)

¨ Current students by Minor (Address/Phone)

¨ Minority Students by Term

¨ Advising Report by Major

¨ Student Schedule Report

¨ Registration Audit Report

For each of the Student Information reports, users have the option to print the report or download it to a file. Users will see two columns of buttons in the Student Information form. Both columns contain the same reports. The first column, titled Print Reports, will allow users to view the report on the screen and print it using the print icon on the toolbar. The second column, titled Download Files, will produce the report in the form of a text file saved on your local hard drive. Below are details about the various Student Information reports.

Current Students by Major (Address/Phone/E-mail)

In this report, users can specify up to 3 major codes and retrieve an alphabetized list of all students in those majors who are registered for the specified term. Output includes name, ID, degree, class standing, major, address, phone number and e-mail address. To run the report:

1. Click on Current Students by Major (Address/Phone/E-mail List) to view the report on your screen, or click on Create File of Current Students by Major (Address/Phone/E-mail) to save the report to a file.

2. When prompted, enter the 1st major code (upper-case, e.g.: ENG) and click OK.

3. When prompted, enter the 2nd major code (upper-case, e.g.: HIS) and click OK. Leave blank and click OK if no other major is desired.

4. When prompted, enter the 3rd major code (upper-case, e.g.: SOC) and click OK. Leave blank and click OK if no other major is desired.

5. The report will then begin to run. If you chose to view the report it will be displayed on the screen and can be printed using the print icon on the toolbar. If you chose to create a file of the report, it will be saved to the location you specified.

Current Students by Major (Detailed)

In this report, users can specify up to 3 major codes and retrieve an alphabetized list of all students in those majors who are registered for the specified term. Output includes ID, name, address, phone number, birthdate, ethnicity, gender, level, student type, degree, major(s), class standing, registered term hours, total earned hours, cumulative GPA and e-mail address. Students are grouped by level, then primary major. To run the report:

1. Click on Current Students by Major (Detailed List) to view the report on your screen, or click on Create File of Current Students by Major (Detailed Info) to save the report to a file.

2. When prompted, enter the 1st major code (upper-case, e.g.: ENG) and click OK.

3. When prompted, enter the 2nd major code (upper-case, e.g.: HIS) and click OK. Leave blank and click OK if no other major is desired.

4. When prompted, enter the 3rd major code (upper-case, e.g.: SOC) and click OK. Leave blank and click OK if no other major is desired.

Current Students by Minor (Address/Phone /E-mail)

This report allows users to enter a minor code and retrieve an alphabetized list of all students with that minor who are registered for the specified term. Output includes name, ID, class standing, major(s), minor(s), address, phone number and e-mail address. To run the report:

1. Click on Current Students by MINOR (Address/Phone/E-mail List) to view the report on your screen, or click on Create File of Current Students by Minor (Address/Phone/E-mail) to save the report to a file.

2. When prompted, enter a minor code (upper-case, e.g.: ENG) and click OK.

3. The report will then begin to run. If you chose to view the report it will be displayed on the screen and can be printed using the print icon on the toolbar. If you chose to create a file of the report, it will be saved to the location you specified.

Minority Students by Term

This report will retrieve an alphabetized list of all students registered for the specified term who have reported a minority ethnic status. Output includes ID, name, address, phone number, birthdate, ethnicity, gender, level, student type, degree, major(s), class standing, registered term hours, total earned hours, cumulative GPA and e-mail address. Students are grouped by ethnicity code. To run the report:

1. Click on Minority Students Registered for Term Report to view the report on your screen, or click on Create File of Minority Students to save the report to a file.

2. The report will then begin to run. If you chose to view the report it will be displayed on the screen and can be printed using the print icon on the toolbar. If you chose to create a file of the report, it will be saved to the location you specified.

Advising Report by Major

This report is intended for use with the web-based advisor holds process. It allows users to specify a major code and retrieve all students in that major who are eligible to enroll for the specified term (i.e., have attended courses in the past year). This list will correspond exactly with the group of students selected by the advisor hold process when applying holds by major. Output for the printed report includes ID, name, level, student type, degree, total earned hours, cumulative GPA, primary advisor, and advisor hold information (department, user, reason and release date). The printed report is alphabetized by name and grouped by level. Additional information is available in the downloaded file, including address, e-mail address, phone number, expected graduation date, graduation indicator ('Y' is student has already graduated), and minor(s). To run the report:

1. Click on Advising Report by Major to send the report directly to your printer, or click on Download Detailed Advising Report to save the report to a file.

2. When prompted, enter a major code (upper-case, e.g.: ENG) and click OK.

3. The report will then begin to run. If you chose to print the report, it will be send directly to your default printer (it will not display on the screen). If you chose to download the report, it will be saved to the location you specified.

Student Schedule Report

This report is a printer friendly version of the information on the student registration form. It prints the student ID, name, course(s), course status(es) and credit hours. To run the report:

2. When prompted, enter a Student’s UM ID (social security number will not work) and click OK.

3. The report will be displayed on the screen when it has completed and can be printed using the print icon on the toolbar.

Registration Audit Report

This report is a printer friendly version of the information on the student registration audit form SFASTCA. It is sorted by sequence number (chronologically). It shows all updates and attempts to update of a student’s classes. To run the report:

2. When prompted, enter a Student’s UM ID (social security number will not work) and click OK.

3. The report will displayed on the screen when it has completed and can be printed using the print icon on the toolbar.

Additional Resources:

ITS Quicknotes are available in the Student Computer Lab in 206 MSB, at the ITS HelpDesk in 207A MSB or on-line at http://www.umflint.edu/its/helpdesk.

a division of Information Technology Services at The University of Michigan-Flint.

Banner Student Information Reports

Quicknote #36B

October 2007