DARTS : CSRPT Exercise: Modify Enrollment Query (Easy to moderate)

This exercise will help you learn the functions of the PS query by modifying an existing query. You need Query Manager access.

Please use the query in CSRPT, UMS_DTS_ENROLLMENT, and do these 10 exercises.

Exercise:

1. Log into CSRPT MaineStreet and search the query, UMS_DTS_ENROLLMENT. Click “Edit”.
2. Save the query as “UMS_DTS_ENROLLMENT_TEST” (as private)
3. Delete “STRM” field
4. Change the column name: “Acad Career” to “Academic Career” and change the translate value to "Long"
5. Change the order of the column: Move Credit hours to be the last column
6. Add new criteria: Credit hours "not equal to" 0
7. Sort data: sort credit hours (ascending order)
8. Add prompt for “ACAD_PROG” with the "Optional" box checked
9. Run the query
10. Delete the query you just created

Answer Key:

1. Running Reports with Query Viewer & Query Manager
2. Saving & Organizing Queries
3. Editing Queries - Delete a Field
4. Editing Queries - Change Heading Text (fieldname)
5. Editing Queries - Column Order
6. Changing a Selection for Variables in a Criteria - Using Criteria
7. Editing Queries - Sorting Order
8. Adding a New Prompt
9. Select the "Run" tab and the prompt screen will show up automatically. Enter values on prompts and then click OK.
   
   
10. Saving & Organizing Queries - Deleting Queries