UCOP IRAP Data Users Group Matt Reed, 10/20/17 ELWR = Entry Level - PowerPoint PPT Presentation

UCOP IRAP Data Users Group Matt Reed, 10/20/17

ELWR = Entry Level Writing Requirement AWPE = Analytical Writing Placement Exam UCOPE = University Committee on Preparatory Education  Needed for report to UCOPE (Academic Senate): ◦ Correlations: SAT, ACT, AP, and AWPE vs. Lower- Division Writing Course Grade Point Average (GPA) 2

Undergraduate Course Registration ID Enrollment Data Admissions Data Campus Name Subject Fuzzy match Fuzzy match Birthdate Course Number Last 4 SSN College Board Advanced Writing Course Placement (AP) Lists Data 3

 Cohort ◦ Academic Year Academic Year (2016-17) ◦ Ter Term (Fall) ◦ Enr Enrollment s nt status atus (Yes) ◦ Reg Registr strati tion ID on ID (for matching to Course Enrollment data) ◦ Name Name (for matching to College Board AP data) ◦ Birthdate Birthdate (for matching to College Board AP data) ◦ Last four digits Last four digits of of social security n social security number ber (for matching to College Board AP data)  Derived Test Scores ◦ SAT Writi SAT Writing (highest score; official if available otherwise self-reported) ◦ ACT Writing ACT Writing (highest score; official if available otherwise self-reported)  Other Test Scores ◦ Analytical Analytical Writing Placement Examination (AWPE) Writing Placement Examination (AWPE) 4

 Student Information ◦ Name Name (for matching to UAD data) ◦ Birthdate Birthdate (for matching to UAD data) ◦ Last four digits of Last four digits of social security number social security number (for matching to UAD data)  Official Test Scores ◦ AP English AP English Language Language ◦ AP English AP English Literature Literature 5

 Course Information (for matching to Course Enrollment data) Campus Campus ◦ Subject Subject ◦ Course Number Course Number ◦ 6

 Grade Point Average (GPA) ◦ sum of grade point units grade point units / sum of attempted units attempted units  Course Information Subject Subject (for matching with Lower Division Writing Course ◦ Lists) Course Number (for matching with Lower Division Writing Course Number ◦ Course Lists) Campus Campus (for matching with Lower Division Writing Course ◦ Lists) Term (fall, winter, spring) Term ◦ Sub-term Sub-term (EOT) ◦ Academic Year Academic Year (2016-17) ◦ Course Enrollment Status Code Course Enrollment Status Code (E,W) ◦  Student Information Regi Registrati stration ID ID (for matching to UAD data) ◦ 7

Select variables and cases (columns and rows) needed 1. from course data (one record per student per course) Import writing course list and add courses with ‘W’ in 2. course number from RV campus Select the cases from #1 on the list in #2 3. Derive grades (for checking) 4. Calculate GPA (one record per student) 5. 8

Select test score variables from UG admissions 1. data for relevant cohort (Fall 2016 incoming freshmen) Import and fuzzy match to College Board AP data 2. Calculate correlations and save results to table 3. 9