Department Chair Queries
Purpose: The queries listed under the Department Chair Queries page are the most commonly used queries by Department Chairs and Deans to gather reliable information for their day-to-day tasks. Follow the steps below to find a query that may suit your needs.
1. Log into MyRIC here: https://my.ric.edu
2. Type in your log in credentials then click on the LOGIN button
![Click to View Full Image Uploaded Image (Thumbnail)](https://servicecenter.ric.edu/TDPortal/Images/Viewer?fileName=98213a53-3677-4b7c-9c82-c7b53bc93ca3-thumb.jpg&beidInt=300)
3. Click on the RIC Announcements button to collapse other homepages, then select the RIC Administrative Systems Homepage.
![Click to View Full Image Uploaded Image (Thumbnail)](https://servicecenter.ric.edu/TDPortal/Images/Viewer?fileName=9fb3ad14-e0a2-47dd-a539-b5eb10b09f43-thumb.jpg&beidInt=300)
4. Click on the Campus Solutions (On Campus) tile
![Click to View Full Image Uploaded Image (Thumbnail)](https://servicecenter.ric.edu/TDPortal/Images/Viewer?fileName=541d030f-7e44-4b6e-9883-397a59d15db6-thumb.jpg&beidInt=300)
5. Navigate to Main Menu >> RIC Custom Applications >> RIC Academic Department >> Department Chair Queries
![Click to View Full Image Uploaded Image (Thumbnail)](https://servicecenter.ric.edu/TDPortal/Images/Viewer?fileName=1a98a2c9-fe73-46a6-b374-b9a60c222c9c-thumb.jpg&beidInt=300)
6. Select one of the tabs to see the queries available to you.
![Click to View Full Image Uploaded Image (Thumbnail)](https://servicecenter.ric.edu/TDPortal/Images/Viewer?fileName=bc62ce1b-5270-45b8-93ea-e45f93ef5fcd-thumb.jpg&beidInt=300)
In this example, we will use the ZRSR_DEPT_SEM_CLASSES query to view the list of courses being offered by your department for a given semester.
Use the magnifying glass to search for the Academic Organization (Department).
7. Fill in the remaining criteria such as Term and Session.
8. Click on the View Results yellow button.
9. Click on the Excel Spreadsheet hyperlink should you need to sort the data produced by the query.
![Click to View Full Image Uploaded Image (Thumbnail)](https://servicecenter.ric.edu/TDPortal/Images/Viewer?fileName=67e2f57c-04a8-440a-928e-ab3f330e48b5-thumb.jpg&beidInt=300)
10. The Microsoft Excel file will be saved in the Downloads folder on your computer.
![Click to View Full Image Uploaded Image (Thumbnail)](https://servicecenter.ric.edu/TDPortal/Images/Viewer?fileName=cf2153fd-37cd-4d6b-a248-b77919974ae1-thumb.jpg&beidInt=300)
You can find technical assistance by entering a ticket request into Team Dymamix (TDX) by copying the text below and pasting it onto a web browser address bar.
https://servicecenter.ric.edu/TDClient/1794/Portal/Requests/ServiceCatalog?CategoryID=10327