Departmental Admin Center Newsletter - Volume 9

Topics include:

 

Statistics and Data

The Office of the University Registrar provides data related to student enrollment, degrees and credentials, as well as the course catalog and schedule of classes. This data can be obtained through a few different systems.

The university's data portal utilizes Tableau, a data visualization tool, to make some student records data available to the university community. For more Tableau resources and information, see About Tableau.

The Student Information System (SIS) has PDF reports and queries.< Because there are multiple ways to find data, we’ve created an Additional Reporting page to help you decipher the best place to find what you’re looking for. The page is organized by data category and then system.

Below are some specific and relevant examples of data you may need this time of year.

 

Locating a Student's ID

Do you often need to find a student’s 7-digit ID or CWRU network ID? We've got you covered! There are two new queries available to you in SIS.

From the Staff Home page, select the Reporting Center tile, then the Admin Center Reports tile.

To look up a student’s 7-digit ID, use the query CW_SR_STUDENT_EMPLID_LOOKUP. Click the HTML link to run the query. Enter their network ID (abc123) in the prompt field and click View Results.

To look up a student’s network ID, use the query CW_SR_STUDENT_NETID_LOOKUP. Click the HTML link to run the query. Enter their 7-digit EMPLID in the prompt field and click View Results.

 

Finding GPAs

Need to quickly find the cumulative GPA for one or all of your students, for example, for rankings or awards?

From your DAC, click on the Additional Info tab to see the column Career Cum GPA. You can sort students by GPA by clicking the Career Cum GPA header once to sort in ascending order, and clicking again to sort in descending order. (The DAC grid can be sorted on any column by clicking the header.)

Want to save this data as a spreadsheet? Click the icon to Download to Excel. Save the file to your computer and open it in Excel.

 

Past Graduates Report

Looking for an easy way to see which of your students have recently graduated? We have a report for you in the university's data portal!

To access this report, go to data.case.edu. Log in if you're not already logged in to Single Sign-On (SSO). Select CWRU Analytics, then choose the folder SIS - Student Records and the workbook Awarded Degrees/Certificates. Within the workbook, you'll find the report Awarded Degrees/Certificates.

Use the filters on the left to narrow your results by completion term, academic plan, degree, and more.

Need counts of the number of graduates over a period of time? E.g., how many PhDs has your department awarded in the last 10 years? Try >General Institutional >Degrees >Degrees by Plan.

 

Send questions about the Departmental Admin Center to registrar@case.edu.