...
Warren Gordon from Math department wanted a report based on Freshman Undergraduate Students with enrollment of (CSTM 0120, MTH 1030, MTH 2003, MTH 2207, or MTH 2610) during Fall 2015 (1159) with Regents (SMA3 or MATHB) . Please see the ticket from KACE: https://helpdesk.baruch.cuny.edu/admin Ticket: 56099
| Panel |
|---|
| Warren, When do you need this data? Is this specific data likely a one-time, or would you require this data set again for another term? Thanks. Patrick Notes on Request: Warren had previously requested math placement scores for enrolled students - https://helpdesk.baruch.cuny.edu/userui/ticket.php?ID=45318 Data provided was from the CU_BAR_AD_0006A and CU_BAR_AD_0006B series queries. In this case Warren is looking for new freshman (admit type 2 for 1156 or 1159) enrolled in (CSTM 0120, MTH 1030, MTH 2003, MTH 2207, or MTH 2610) during Fall 2015 (1159), with grades each student received in the course and what their math regent exam type and score (no regent data if no record exists). |
| Note |
|---|
Regents math score code ‘SMA3’ and ‘MATHB’ was confirmed by OTE previously. Looking at the data the enrollment of student with (CSTM 0120, MTH 1030, MTH 2003, MTH 2207, or MTH 2610) during Fall 2015 (1159) with Regents are very few. OTE will help in the future for accuracy to set up the new set of codes for Regents Greetings, The Zicklin Dean's Office is currently working on the AACSB accreditation survey and require information via queries in CUNYfirst. We will require the following queries by Monday, April 20th, 2015 to complete the survey: Query 3: Admissions - Institution: BAR01 - Academic Level Term Start - Service Indicator: "Accepted In Official Major" -Reason: "Admitted to the Zicklin School" -Start Term (Prompt to select term) -Service Indicator: "Academic Plan Status" (include IF they also have a Service Indicator of "Accepted In Official Major") -Reason: "Must Satisfy additional req" -Start Term (Prompt to select term) -Academic Plan: BBA plans If you have any questions or if there is anything else needed, please let me know as soon as possible. Thank you in advance. Best regards,Sarah
Later added start term, academic level, active term request by SARAH. |
Final Report Delivery with requirements:
The query for Zicklin Student Enrollment CU_BAR_SR_00030_6 and Zicklin Admissions
CU_BAR_SR_00080 have 00085 has not been shared with you. Both the queries are Warren but Mike and Patrick. The query is working fine.
CU_BAR_SR_00080 Prompts are below00085 Report includes:
- Institution: Bar01 BAR01
- Career: UGRD
- Term From: UGRD 1156
- Term To: pick any term
- Degree: BBA (or pick any others)
- 1159
- Admit Type: 2 (as freshman)
- Total : 1074 (with grades and Regents date, score)AcadProg (optional) If you want to be more specific – AcadPlan (optional) If you want to be more specific
...
Query Development:
Following table shows all necessary records that have been used to generate fields as requested by an user to create this report.
...