3 Campus Wide Diversity Data Workshops/Training
3 Campus Wide Diversity Data Workshops are opened to all University of Washington staff members in all 3 campuses, WHO ARE AUTHORIZED TO EXAMINE AND WORK WITH FERPA (The Family Educational Rights and Privacy Act of 1974) PROTECTED STUDENT DATA. We will NOT be involved in specific data/project requests outside OMAD.
What is “maximum representation?” Please click on this link for an explanation.
_______________________________________________________________________________________
Data Seminar#25) Date: July 27, 2023 Time: 10:00am-11:00am Location: 171E (Multi-Purpose Room) in Mary Gates Hall
Instructor: Gene Kim
*****ALL OMAD Staff members are welcome to make an individual or small group appointment to see me if this time does NOT fit your schedules. OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment/data projects specific to their programs’ needs.
1) Automating institutional data for NSF/NIH federal grant/annual performance reports via Python and SQL(Student Demographics & Performance).
2) Maximum undergraduate enrollment of each schools/colleges in UW-Seattle: ex) Measuring one unique student triple majoring in finance(College Code=E), social work (College Code=T), and English(College Code=C), and count this person in all three schools/colleges to examine the approximate “maximum representation of enrollment” per schools/colleges via “sec.transcript” and other data tables.
3) UW Profiles data via BI Portal.
4)How to gather and stack 10 or 20 or 100 or 1,000 separate spreadsheets into one analyzable spreadsheet without typing any of the file names or individually uploading them or using “tedious” commands such as “append”, “rbind”, or “concat” in matter of few minutes.
5) Application of MS Excel pivot tables from Python, R, or Julia outputs.
6) Addressing concerns related to the “two or more races” category and Hispanic/Latinx “override” from the National Center for Education Statistics (Integrated Postsecondary Education Data System): Concept and practice of Maximum Representation.
7) Only personnel AUTHORIZED TO EXAMINE AND WORK WITH FERPA (The Family Educational Rights and Privacy Act of 1974) PROTECTED STUDENT DATA at UW will be able to attend.
RSVP NOT REQUIRED.
_______________________________________________________________________________________
Data Seminar#24) Date: July 10, 2023 Time: 10:00am-11:00am Location: 171E (Multi-Purpose Room) in Mary Gates Hall
Instructor: Gene Kim
*****ALL OMAD Staff members are welcome to make an individual or small group appointment to see me if this time does NOT fit your schedules. OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment/data projects specific to their programs’ needs.
1) Application of Maximum Representation beyond ethnicity/race. Example: measuring one unique student triple majoring in finance(College Code=E), social work (College Code=T), and English(College Code=C), and count this person in all three schools/colleges to examine the approximate “maximum representation of enrollment” per schools/colleges via “sec.transcript” and other data tables.
2) How to gather and stack 10 or 20 or 100 or 1,000 separate spreadsheets into one analyzable spreadsheet without typing any of the file names or individually uploading them or using “tedious” commands such as “append”, “rbind”, or “concat” in matter of few minutes.
3) Application of MS Excel pivot tables from Python, R, or Julia outputs.
4) Addressing concerns related to the “two or more races” category and Hispanic/Latinx “override” from the National Center for Education Statistics (Integrated Postsecondary Education Data System): Concept and practice of Maximum Representation.
5) Spring 2023 UW-Seattle Undergraduate Transcript data (If time allows).
6) STEM vs Non-STEM degree earners by various demographic characteristics for the last 5 years(If time allows).
7) Only personnel AUTHORIZED TO EXAMINE AND WORK WITH FERPA (The Family Educational Rights and Privacy Act of 1974) PROTECTED STUDENT DATA at UW will be able to attend.
RSVP NOT REQUIRED.
_______________________________________________________________________________________
Data Seminar#23) Date: June 22, 2023 Time: 10:00am-11:00am Location: 171E (Multi-Purpose Room) in Mary Gates Hall
Instructor: Gene Kim
*****ALL OMAD Staff members are welcome to make an individual or small group appointment to see me if this time does NOT fit your schedules. OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment/data projects specific to their programs’ needs.
1) How to gather and stack 10 or 20 or 100 or 1,000 separate spreadsheets into one analyzable spreadsheet without typing any of the file names or individually uploading them or using “tedious” commands such as “append”, “rbind”, or “concat” in matter of few minutes.
2) Application of MS Excel pivot tables from Python, R, or Julia outputs.
3) Addressing concerns related to the “two or more races” category and Hispanic/Latinx “override” from the National Center for Education Statistics (Integrated Postsecondary Education Data System): Concept and practice of Maximum Representation.
4) Spring 2023 UW-Seattle Undergraduate Transcript data.
5) STEM vs Non-STEM degree earners by various demographic characteristics for the last 5 years.
6) Only personnel AUTHORIZED TO EXAMINE AND WORK WITH FERPA (The Family Educational Rights and Privacy Act of 1974) PROTECTED STUDENT DATA at UW will be able to attend.
RSVP NOT REQUIRED.
_______________________________________________________________________________________
Data Seminar#22) Date: January 20, 2023 Time: 10:00am-11:15am Location: 171E (Multi-Purpose Room) in Mary Gates Hall
Instructor: Gene Kim
*****ALL OMAD Staff members are welcome to make an individual or small group appointment to see me if this time does NOT fit your schedules. OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment/data projects specific to their programs’ needs.
1) Data demo:
- Automating fiscal data using Python and R: dangers of overreliance on pivot tables in MS Excel.
- Basic documentation (html, MS Word, PDF) of data analysis via R Markdown and Quarto.
- How to lift hundreds of pages of PDF data tables to csv files via Python.
2) Fall2022 transcript data: going beyond BI Portal via EDW and AIDB.
3) Addressing concerns related to the “two or more races” category and Hispanic/Latinx “override” from the National Center for Education Statistics (Integrated Postsecondary Education Data System): Concept and practice of Maximum Representation.
4) Basic pivot tables, and other basic spreadsheet functions.
5) Only personnel AUTHORIZED TO EXAMINE AND WORK WITH FERPA (The Family Educational Rights and Privacy Act of 1974) PROTECTED STUDENT DATA at UW will be able to attend.
RSVP NOT REQUIRED.
_______________________________________________________________________________________
Data Seminar#21) Date: August 25, 2022 Time: 10:00am-11:30am Location: 171E (Multi-Purpose Room) in Mary Gates Hall
Instructor: Gene Kim
*****ALL OMAD Staff members are welcome to make an individual or small group appointment to see me if this time does NOT fit your schedules. OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment/data projects specific to their programs’ needs.
Content: All contents in the workshops are related to protocols, security, and utilization of student data.
1) Data demo:
- Python vs R vs……Julia—- toggling between Python, R, and…..Julia (little bit) all integrated with SQL utilizing EDW/AIDB via one IDE:Quarto.
- Basic documentation (html, MS Word, PDF) of data analysis via R Markdown and Quarto.
- How to lift hundreds of pages of PDF data tables to csv files via Python.
2) Addressing concerns related to the “two or more races” category and Hispanic/Latinx “override” from the National Center for Education Statistics (Integrated Postsecondary Education Data System): Concept and practice of Maximum Representation.
3) Basic pivot tables.
4) Only personnel AUTHORIZED TO EXAMINE AND WORK WITH FERPA (The Family Educational Rights and Privacy Act of 1974) PROTECTED STUDENT DATA at UW will be able to attend.
RSVP NOT REQUIRED.
_______________________________________________________________________________________
Data Seminar#20) Date: June 24, 2022 Time: 10:00am-11:10am Location: 171E (Multi-Purpose Room) in Mary Gates Hall
Instructor: Gene Kim
*****ALL OMAD Staff members are welcome to make an individual or small group appointment to see me if this time does NOT fit your schedules. OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment/data projects specific to their programs’ needs.
Content: All contents in the workshops are related to protocols, security, and utilization of student data.
1) Addressing concerns related to the “two or more races” category and Hispanic/Latinx “override” from the National Center for Education Statistics (Integrated Postsecondary Education Data System): Concept and practice of Maximum Representation
2) Transcript data via EDW: OMAD in comparison to Non-OMAD undergraduate (freshman to seniors 1-4) students.
3) Admissions data via BI-Portal in comparison to EDW query.
4) Basic pivot tables.
5) Only personnel AUTHORIZED TO EXAMINE AND WORK WITH FERPA (The Family Educational Rights and Privacy Act of 1974) PROTECTED STUDENT DATA at UW will be able to attend.
RSVP NOT REQUIRED.
_______________________________________________________________________________________
Data Seminar#20 is CANCELLED DUE TO COVID) Date: January 6, 2022 Time: 10:00am-11:00am Location: 171E (Multi-Purpose Room) in Mary Gates Hall
Content: All contents in the workshops are related to protocols, security, and utilization of student data.
1) Addressing concerns related to the “two or more races” category and Hispanic/Latinx “override” from the National Center for Education Statistics (Integrated Postsecondary Education Data System): Concept and practice of Maximum Representation for Multiracial/Multiethnic Students and related items below:
a. Introduction to Electronic Academic Records System (EARS).
b. Introduction to UW Profiles: https://uwprofiles.uw.edu/
c. Introduction to EDW and AIDB.
d. Integrating and automating SQL to Python to Excel for consumption.
2) Data visualization (via density plots) of cumulative and quarterly undergraduate GPA distribution trends in relation to covid lockdown (prior, during, and present).
a. Fall 2021 (and prior) transcript data analysis by name, student ID, ethnicity/race, gender between OMAD and NON-OMAD undergraduate students.
b. How OMAD data team utilize R markdown for reporting (This is a demo, not an instruction).
c. Integrating and automating SQL to Python to Excel for consumption.
3) Analysis of all courses attempted in Fall 2021 Quarter:
a. Class performance analysis by name, race/ethnicity, gender, class standing, first-generation, pell-eligibility.
b. Basic introduction to pivot table.
c. Integrating and automating SQL to Python to Excel for consumption.
4) Example(s) of automating repetitious/tedious calculations in MyFinancial Desktop (Transaction Summary) by 10 or 20 or 30 or 100+ different budget numbers via R and Python all at once with one push of a button (This is a demo, not an instruction).
5) Demo: Integrating and automating from SQL -> to Julia programming language integrated with R -> to MS Excel for consumption.
6) Only personnel AUTHORIZED TO EXAMINE AND WORK WITH FERPA (The Family Educational Rights and Privacy Act of 1974) PROTECTED STUDENT DATA at UW will be able to attend.
RSVP NOT REQUIRED.
_______________________________________________________________________________________
Data Seminar#20) IS CANCELLED DUE TO COVID-19
*****ALL OMAD Staff members are welcome to make an individual or small group appointment to see me if this time does NOT fit your schedules. OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment/data projects specific to their programs’ needs.
Data Seminar#20) Date: March 9, 2020 Time: 10:00am-11:15am Location: 171E (Multi-Purpose Room) in Mary Gates Hall
Content: All contents in the workshops are related to protocols, security, and utilization of student data.
1) Analysis of all courses attempted in Fall 2019 Quarter (quick demo on SQL to R (also in Python) to Excel Spreadsheet/Pivot_Table):
a. Most and least enrolled/attempted classes by name, ethnicity, gender, class, first-generation, pell-eligible.
b. Identification of “high-risk” courses in relation to performance: I will need help from advisers.
2) Example(s) of automating repetitious/tedious calculations in MyFinancial Desktop (Transaction Summary) by 10 or 20 or 30 or 100+ different budget numbers via R(instead of Python) all at once with one push of a button (This is a demo, not an instruction).
3) Addressing concerns related to the “two or more races” category and Hispanic/Latinx “override” from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of Maximum Representation for Multiracial/Multiethnic Students (Upon Request).
a. Introduction to Electronic Academic Records System (EARS).
b. Introduction to UW Profiles: https://uwprofiles.uw.edu/
c. Introduction to EDW and AIDB.
4) Only personnel AUTHORIZED TO EXAMINE AND WORK WITH FERPA (The Family Educational Rights and Privacy Act of 1974) PROTECTED STUDENT DATA at UW will be able to attend.
RSVP NOT REQUIRED.
_______________________________________________________________________________________
Data Seminar#19) Date: January 23, 2020 Time: 10:00am-11:15am Location: 171E (Multi-Purpose Room) in Mary Gates Hall
Instructor: Gene Kim
*****ALL OMAD Staff members are welcome to make an individual or small group appointment to see me if this time does NOT fit your schedules. OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment/data projects specific to their programs’ needs.
Content: All contents in the workshops are related to protocols, security, and utilization of student data.
1) Analysis of all courses attempted in Fall 2019 Quarter (quick demo on SQL to Python to Excel Spreadsheet):
a. Most and least enrolled/attempted classes by name, ethnicity, gender, class, first-generation, pell-eligible.
b. Identification of “high-risk” courses in relation to performance: I will need help from advisers.
2) Example(s) of automating repetitious/tedious calculations in MyFinancial Desktop (Transaction Summary) by 10 or 20 or 30 or 100+ different budget numbers via R(instead of Python) all at once with one push of a button (This is a demo, not an instruction).
3) Addressing concerns related to the “two or more races” category and Hispanic/Latinx “override” from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of Maximum Representation for Multiracial/Multiethnic Students (Upon Request).
a. Introduction to Electronic Academic Records System (EARS).
b. Introduction to UW Profiles: https://uwprofiles.uw.edu/
c. Introduction to EDW and AIDB.
4) Only personnel AUTHORIZED TO EXAMINE AND WORK WITH FERPA (The Family Educational Rights and Privacy Act of 1974) PROTECTED STUDENT DATA at UW will be able to attend.
RSVP NOT REQUIRED.
_____________________________________________________________________________________
Data Seminar#18) Date: January 14, 2020 Time: 10:00am-11:15am Location: 171E (Multi-Purpose Room) in Mary Gates Hall
Instructor: Gene Kim
*****ALL OMAD Staff members are welcome to make an individual or small group appointment to see me if this time does NOT fit your schedules. OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment/data projects specific to their programs’ needs.
Content: All contents in the workshops are related to protocols, security, and utilization of student data.
1) Analysis of all courses attempted in Fall 2019 Quarter:
a. Most and least enrolled/attempted classes by name, ethnicity, gender, class, first-generation, pell-eligible (I anticipate the data to have well over 200,000+ rows ).
b. Identification of “high-risk” courses in relation to performance: I will need help from advisers.
2) Example(s) of automating repetitious/tedious calculations in MyFinancial Desktop (Transaction Summary) by 10 or 20 or 30 or 40+ different budget numbers via R(instead of Python) all at once with one push of a button (This is a demo, not an instruction).
3) Addressing concerns related to the “two or more races” category and Hispanic/Latinx “override” from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of Maximum Representation for Multiracial/Multiethnic Students (Upon Request).
4) Only personnel AUTHORIZED TO EXAMINE AND WORK WITH FERPA (The Family Educational Rights and Privacy Act of 1974) PROTECTED STUDENT DATA at UW will be able to attend.
RSVP NOT REQUIRED.
_______________________________________________________________________________________
Data Seminar#17) Date: November 19, 2019 Time: 10:00am-11:15am Location: 171E (Multi-Purpose Room) in Mary Gates Hall
Instructor: Gene Kim
*****ALL OMAD Staff members are welcome to make an individual or small group appointment to see me if this time does NOT fit your schedules. OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment/data projects specific to their programs’ needs.
Content: All contents in the workshops are related to protocols, security, and utilization of student data.
1) How many undergraduate, graduate, and professional students did NOT come back for Fall 2019 Quarter from Fall 2018, Winter 2019, and Spring 2019 Quarter by ethnicity/race, gender, and name (If time allows, we will examine specific major(s)/department(s)).
2) From SQL —> Python —> to your MS Excel Spreadsheet:
How data is: a) Gathered b) Organized c) Analyzed.
3) Introduction to MS Excel Pivot Table and MS Access.
4) Introduction to EARS (Electronic Academic Record System).
5) Addressing concerns related to the “two or more races” category and Hispanic/Latinx “override” from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of Maximum Representation for Multiracial/Multiethnic Students (Upon Request).
6) Introduction to R and Python (less emphasis than the previous session back in July 9, 2019).
7) Introduction to UW Profiles: https://uwprofiles.uw.edu/
8) Only personnel AUTHORIZED TO EXAMINE AND WORK WITH FERPA (The Family Educational Rights and Privacy Act of 1974) PROTECTED STUDENT DATA at UW will be able to attend.
RSVP NOT REQUIRED.
_______________________________________________________________________________________
Data Seminar#16) Date: October 1, 2019 Time: 10:00am-11:15am Location: 171E (Multi-Purpose Room) in Mary Gates Hall
Instructor: Gene Kim
*****ALL OMAD Staff members are welcome to make an individual or small group appointment to see me if this time does NOT fit your schedules. OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment/data projects specific to their programs’ needs.
Content: All contents in the workshops are related to protocols, security, and utilization of student data.
1) How many incoming URM (Underrepresented Minority) students (by name, race, ethnicity, and gender) are “requesting” Pre-STEM and STEM majors for Fall 2019 Quarter? (If time allows, we will examine specific major(s)/department requests from the incoming students).
2) Who are transitioning to graduate school/professional school outside (and within) UW among our UW-Seattle BA/BS degree earners from summer 2015 to spring 2016? By race/ethnicity, first-generation, pell-eligible, and gender (by schools and colleges, if time allows in “Safe Mode”).
Utilization method of National Student Clearninghouse data.
3) From SQL —> Python —> to your MS Excel Spreadsheet:
How data is: a) Gathered b) Organized c) Analyzed.
4) Introduction to MS Excel Pivot Table and MS Access.
5) Addressing concerns related to the “two or more races” category and Hispanic/Latinx “override” from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of Maximum Representation for Multiracial/Multiethnic Students (Upon Request):Concept of Maximum Representation for Multiracial/Multiethnic Students (Upon Request).
6) Introduction to R and Python (less emphasis than the previous session back in July 9, 2019).
7) Introduction to UW Profiles: https://uwprofiles.uw.edu/
8) Only personnel AUTHORIZED TO EXAMINE AND WORK WITH FERPA (The Family Educational Rights and Privacy Act of 1974) PROTECTED STUDENT DATA at UW will be able to attend.
RSVP NOT REQUIRED.
_______________________________________________________________________________________
Data Seminar#15) Date: September 9, 2019 Time: 10:00am-12:00am Location: 171E (Multi-Purpose Room) in Mary Gates Hall
Instructor: Gene Kim
*****ALL OMAD Staff members are welcome to make an individual or small group appointment to see me if this time does NOT fit your schedules. OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment/data projects specific to their programs’ needs.
Content: All contents in the workshops are related to protocols, security, and utilization of student data.
1) Who are transitioning to graduate school/professional school outside (and within) UW among our UW-Seattle BA/BS degree earners from summer 2015 to spring 2016? By race/ethnicity, first-generation, pell-eligible, and gender (by schools and colleges, if time allows in “Safe Mode”).
Utilization method of National Student Clearninghouse data.
2) From SQL —> Python —> to your MS Excel Spreadsheet:
How data is: a) Gathered b) Organized c) Analyzed.
3) Introduction to MS Excel Pivot Table and MS Access.
4) Addressing concerns related to the “two or more races” category and Hispanic/Latinx “override” from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of Maximum Representation for Multiracial/Multiethnic Students (last session).
5) Introduction to R and Python (less emphasis than the previous session back in July 9, 2019).
6) Introduction to UW Profiles: https://uwprofiles.uw.edu/
7) Only personnel AUTHORIZED TO EXAMINE AND WORK WITH FERPA (The Family Educational Rights and Privacy Act of 1974) PROTECTED STUDENT DATA at UW will be able to attend.
RSVP NOT REQUIRED.
_______________________________________________________________________________________
Data Seminar#14) Date: July 29, 2019 Time: 1:00pm-2:30pm Location: 171E (Multi-Purpose Room) in Mary Gates Hall
Instructor: Gene Kim
*****ALL OMAD Staff members are welcome to make an individual or small group appointment to see me if this time does NOT fit your schedules. OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment/data projects specific to their programs’ needs.
Content: All contents in the workshops are related to protocols, security, and utilization of student data.
1) Who are transitioning to graduate school/professional school outside (and within) UW among our UW-Seattle BA/BS degree earners from summer 2015 to spring 2016? By race/ethnicity, first-generation, pell-eligible, and gender (by schools and colleges, if time allows in “Safe Mode”).
Utilization method of National Student Clearninghouse data.
2) Introduction to MS Excel Pivot Table and MS Access.
3) Addressing concerns related to the “two or more races” category and Hispanic/Latinx “override” from the National Center for Education Statistics (Integrated Postsecondary Education Data System)::Concept of Maximum Representation for Multiracial/Multiethnic Students if time and equipment allows.
4) Introduction to R and Python (less emphasis than the previous session back in July 9, 2019).
5) Introduction to UW Profiles: https://uwprofiles.uw.edu/
6) EOP vs Non-EOP graduation and 1st year retention rates by ethnicity/race and gender.
7) Only personnel AUTHORIZED TO EXAMINE AND WORK WITH FERPA (The Family Educational Rights and Privacy Act of 1974) PROTECTED STUDENT DATA at UW will be able to attend.
RSVP NOT REQUIRED.
_________________________________________________________________________________
Data Seminar#13) Date: July 9, 2019 Time: 10:00am-11:30am Location: 171E (Multi-Purpose Room) in Mary Gates Hall
Instructor: Gene Kim
*****ALL OMAD Staff members are welcome to make an individual or small group appointment to see me if this time does NOT fit your schedules. OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment/data projects specific to their programs’ needs.
Content: All contents in the workshops are related to protocols, security, and utilization of student data.
1) Who are transitioning to graduate school/professional school outside (and within) UW among our UW-Seattle BA/BS degree earners from summer 2015 to spring 2016? By race/ethnicity, first-generation, pell-eligible, and gender (by schools and colleges, if time allows in “Safe Mode”).
Utilization method of National Student Clearninghouse data.
2) Introduction to MS Excel Pivot Table and MS Access.
3) Addressing concerns related to the “two or more races” category and Hispanic/Latinx “override” from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of Maximum Representation for Multiracial/Multiethnic Students if time and equipment allows.
4) Introduction to R and Python.
5) Introduction to UW Profiles: https://uwprofiles.uw.edu/
6) EOP(OMAD) vs Non-EOP(OMAD) graduation and 1st year retention rates by ethnicity/race and gender.
7) Only personnel AUTHORIZED TO EXAMINE AND WORK WITH FERPA (The Family Educational Rights and Privacy Act of 1974) PROTECTED STUDENT DATA at UW will be able to attend.
RSVP NOT REQUIRED.
__________________________________________________________________________________________
Data Seminar#12) Date: March 12, 2019 Time: 9:30am-11:00am Location: 171E (Multi-Purpose Room) in Mary Gates Hall
Instructor: Gene Kim
*****ALL OMAD Staff members are welcome to make an individual or small group appointment to see me if this time does NOT fit your schedules. OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment/data projects specific to their programs’ needs.
Content: All contents in the workshops are related to protocols, security, and utilization of student data.
1) How many of our undergraduate (freshman to seniors) students came back for Winter 2019 from Spring and Fall 2018 Quarters? :Student Persistence Data by student majors.
2) Addressing concerns related to the “two or more races” category and Hispanic/Latinx “override” from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of Maximum Representation for Multiracial/Multiethnic Students: basic application/demonstration of R and Python (in relation to Maximum Representation).
3) Introduction to MS Excel Pivot Table and MS Access.
4) UW Profiles: https://uwprofiles.uw.edu/
5) Only personnel AUTHORIZED TO EXAMINE AND WORK WITH FERPA (The Family Educational Rights and Privacy Act of 1974) PROTECTED STUDENT DATA at UW will be able to attend.
RSVP NOT REQUIRED.
__________________________________________________________________________________________
Data Seminar#11) Date: March 1, 2019 Time: 9:30am-11:00am Location: 171E (Multi-Purpose Room) in Mary Gates Hall
Instructor: Gene Kim
*****ALL OMAD Staff members are welcome to make an individual or small group appointment to see me if this time does NOT fit your schedules. OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment/data projects specific to their programs’ needs.
Content: All contents in the workshops are related to protocols, security, and utilization of student data.
1) How many of our undergraduate (freshman to seniors) students came back for Winter 2019 from Spring and Fall 2018 Quarters? :Student Persistence Data by student majors
2) Addressing concerns related to the “two or more races” category and Hispanic/Latinx “override” from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of Maximum Representation for Multiracial/Multiethnic Students IF TIME PERMITS.
3) Introduction to MS Excel Pivot Table and MS Access.
4) UW Profiles: https://uwprofiles.uw.edu/
5) IF TIME AND EQUIPMENT PERMITS: Basic R and Python demo in relation to maximum representation data.
6) Only personnel AUTHORIZED TO EXAMINE AND WORK WITH FERPA (The Family Educational Rights and Privacy Act of 1974) PROTECTED STUDENT DATA at UW will be able to attend.
RSVP NOT REQUIRED.
______________________________________________________________________________________________
Data Seminar#10) Date: January 22, 2019 Time: 10:00am-11:30am Location: 171E (Multi-Purpose Room) in Mary Gates Hall
Instructor: Gene Kim
*****ALL OMAD Staff members are welcome to make an individual or small group appointment to see me if this time does NOT fit your schedules. OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment/data projects specific to their programs’ needs.
Content: All contents in the workshops are related to protocols, security, and utilization of student data.
1) How many of our undergraduate (freshman to seniors) students came back for Winter 2019 from Spring and Fall 2018 Quarters? :Student Persistence Data by student majors
2) Addressing concerns related to the “two or more races” category and Hispanic/Latinx “override” from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of Maximum Representation for Multiracial/Multiethnic Students IF TIME PERMITS.
3) Introduction to MS Excel Pivot Table and MS Access. .
4) UW Profiles: https://uwprofiles.uw.edu/
5) Only personnel AUTHORIZED TO EXAMINE AND WORK WITH FERPA (The Family Educational Rights and Privacy Act of 1974) PROTECTED STUDENT DATA at UW will be able to attend.
RSVP NOT REQUIRED.
______________________________________________________________________________________________
Data Seminar#9) Date: January 8, 2019 Time: 10:00am-11:30am Location: 171E (Multi-Purpose Room) in Mary Gates Hall
Instructor: Gene Kim
*****ALL OMAD Staff members are welcome to make an individual or small group appointment to see me if this time does NOT fit your schedules. OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment/data projects specific to their programs’ needs.
Content: All contents in the workshops are related to protocols, security, and utilization of student data.
1) How many of our undergraduate (freshman to seniors) students came back for Winter 2019 from Spring and Fall 2018 Quarters? :Student Persistence Data by student majors
2) Addressing concerns related to the “two or more races” category and Hispanic/Latinx “override” from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of Maximum Representation for Multiracial/Multiethnic Students IF TIME PERMITS.
3) Introduction to MS Excel Pivot Table and MS Access.
4) UW Profiles: https://uwprofiles.uw.edu/
5) Basic RStudio demo in relation to maximum representation data.
6)EOP(OMAD) vs Non-EOP (Non-OMAD) graduation and 1st year retention rates by ethnicity/race and gender.
7) Only personnel AUTHORIZED TO EXAMINE AND WORK WITH FERPA (The Family Educational Rights and Privacy Act of 1974) PROTECTED STUDENT DATA at UW will be able to attend.
RSVP NOT REQUIRED.
_______________________________________________________________________________________________
Data Seminar#8) Date: November 29, 2018 Time: 9:30am – 10:30am Location: 171E (Multi-Purpose Room) in Mary Gates Hall
Instructor: Gene Kim
*****ALL OMAD Staff members are welcome to make an individual or small group appointment to see me if this time does NOT fit your schedules. OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment/data projects specific to their programs’ needs.
Content: All contents in the workshops are related to protocols, security, and utilization of student data.
1) Spring 2018 Student Persistence Data in relation to Fall 2018 Quarter.
2) Addressing concerns related to the “two or more races” category and Hispanic/Latinx “override” from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of Maximum Representation for Multiracial/Multiethnic Students IF TIME PERMITS.
3) Introduction to MS Excel Pivot Table and MS Access.
4) UW Profiles: https://uwprofiles.uw.edu/
5) Only personnel AUTHORIZED TO EXAMINE AND WORK WITH FERPA (The Family Educational Rights and Privacy Act of 1974) PROTECTED STUDENT DATA at UW will be able to attend.
RSVP NOT REQUIRED.
_______________________________________________________________________________________________
Data Seminar#7) Date: October 9, 2018 Time: 1:00pm – 2:30pm Location: 171E (Multi-Purpose Room) in Mary Gates Hall
Instructor: Gene Kim
*****ALL OMAD Staff members are welcome to make an individual or small group appointment to see me if this time does NOT fit your schedules. OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment/data projects specific to their programs’ needs.
Content: All contents in the workshops are related to protocols, security, and utilization of student data.
1) Who becomes STEM undergraduate degree holders in UW-Seattle? Historical data analysis:
- Requested STEM majors and earned STEM degrees.
- Did NOT request STEM majors but earned STEM degrees.
- Requested STEM majors and earned NON-STEM degrees.
- Did NOT request STEM majors and earned NON-STEM degrees.
- Did NOT graduate from UW-Seattle.
2) Addressing concerns related to the “two or more races” category and Hispanic/Latinx “override” from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of Maximum Representation for Multiracial/Multiethnic Students IF TIME PERMITS.
3) Introduction to MS Excel Pivot Table and MS Access.
4) UW Profiles: https://uwprofiles.uw.edu/
5) Only personnel AUTHORIZED TO EXAMINE AND WORK WITH FERPA (The Family Educational Rights and Privacy Act of 1974) PROTECTED STUDENT DATA at UW will be able to attend.
RSVP NOT REQUIRED.
_______________________________________________________________________________________________
Data Seminar#6) Date: October 5, 2018 Time: 9:30am – 11:00am Location: 171E (Multi-Purpose Room) in Mary Gates Hall
Instructor: Gene Kim
*****ALL OMAD Staff members are welcome to make an individual or small group appointment to see me if this time does NOT fit your schedules. OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment/data projects specific to their programs’ needs.
Content: All contents in the workshops are related to protocols, security, and utilization of student data.
1) Who becomes STEM undergraduate degree holders in UW-Seattle? Historical data analysis:
- Requested STEM majors and earned STEM degrees.
- Did NOT request STEM majors but earned STEM degrees.
- Requested STEM majors and earned NON-STEM degrees.
- Did NOT request STEM majors and earned NON-STEM degrees.
- Did NOT graduate from UW-Seattle.
2) Addressing concerns related to the “two or more races” category and Hispanic/Latinx “override” from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of Maximum Representation for Multiracial/Multiethnic Students IF TIME PERMITS.
3) Introduction to MS Excel Pivot Table and MS Access.
4) UW Profiles: https://uwprofiles.uw.edu/
5) Only personnel AUTHORIZED TO EXAMINE AND WORK WITH FERPA (The Family Educational Rights and Privacy Act of 1974) PROTECTED STUDENT DATA at UW will be able to attend.
_______________________________________________________________________________________________
Data Seminar#5) Date: September 7, 2018 Time: 10:00am-11:45am Location: 171E (Multi-Purpose Room) in Mary Gates Hall
Instructor: Gene Kim
*****ALL OMAD Staff members are welcome to make an individual or small group appointment to see me if this time does NOT fit your schedules. OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment/data projects specific to their programs’ needs.
Content: All contents in the workshops are related to protocols, security, and utilization of student data.
1) Addressing concerns related to the “two or more races” category and Hispanic/Latinx “override” from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of Maximum Representation for Multiracial/Multiethnic Students.
2) Introduction to MS Excel Pivot Table and MS Access.
3) UW Profiles: https://uwprofiles.uw.edu/
4) Only personnel AUTHORIZED TO EXAMINE AND WORK WITH FERPA (The Family Educational Rights and Privacy Act of 1974) PROTECTED STUDENT DATA at UW will be able to attend.
RSVP NOT REQUIRED.
_______________________________________________________________________________________________
Data Seminar#4) Date: August 10, 2018 Time: 10:00am-11:30am Location: 171E (Multi-Purpose Room) in Mary Gates Hall
Instructor: Gene Kim
*****ALL OMAD Staff members are welcome to make an individual or small group appointment to see me if this time does NOT fit your schedules. OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment/data projects specific to their programs’ needs.
Content: All contents in the workshops are related to protocols, security, and utilization of student data.
1) Addressing concerns related to the “two or more races” category and Hispanic/Latinx “override” from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of Maximum Representation for Multiracial/Multiethnic Students.
2) Introduction to MS Excel Pivot Table and MS Access.
3) UW Profiles: https://uwprofiles.uw.edu/
4) Only personnel AUTHORIZED TO EXAMINE AND WORK WITH FERPA (The Family Educational Rights and Privacy Act of 1974) PROTECTED STUDENT DATA at UW will be able to attend.
RSVP: CLOSED.
_______________________________________________________________________________________________
Data Seminar#3) Date: August 6, 2018 Time: 2:00pm-3:30pm Location: 171E (Multi-Purpose Room) in Mary Gates Hall
Instructor: Gene Kim
*****ALL OMAD Staff members are welcome to make an individual or small group appointment to see me if this time does NOT fit your schedules. OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment/data projects specific to their programs’ needs.
Content: All contents in the workshops are related to protocols, security, and utilization of student data.
1) Addressing concerns related to the “two or more races” category and Hispanic/Latinx “override” from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of Maximum Representation for Multiracial/Multiethnic Students.
2) Introduction to MS Excel Pivot Table and MS Access.
3) UW Profiles: https://uwprofiles.uw.edu/
4) EOP vs Non-EOP graduation and 1st year retention rates by ethnicity/race and gender.
5) Only personnel AUTHORIZED TO EXAMINE AND WORK WITH FERPA (The Family Educational Rights and Privacy Act of 1974) PROTECTED STUDENT DATA at UW will be able to attend.
RSVP: CLOSED.
_______________________________________________________________________________________________
Data Seminar#2) Date: July 12, 2018 Time: 1:30pm-3:00pm Location: 171E (Multi-Purpose Room) in Mary Gates Hall
Instructor: Gene Kim
*****ALL OMAD Staff members are welcome to make an individual or small group appointment to see me if this time does NOT fit your schedules. OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment/data projects specific to their programs’ needs.
Content: All contents in the workshops are related to protocols, security, and utilization of student data.
1) Addressing concerns related to the “two or more races” category and Hispanic/Latinx “override” from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of Maximum Representation for Multiracial/Multiethnic Students.
2) Introduction to MS Excel Pivot Table and MS Access.
3) UW Profiles: https://uwprofiles.uw.edu/
4) EOP vs Non-EOP graduation and 1st year retention rates by ethnicity/race and gender.
5)Only personnel AUTHORIZED TO EXAMINE AND WORK WITH FERPA (The Family Educational Rights and Privacy Act of 1974) PROTECTED STUDENT DATA at UW will be able to attend.
RSVP: CLOSED.
_______________________________________________________________________________________________
Data Seminar#1) Date: July 11, 2018 Time: 1:00pm-2:30pm Location: 171E (Multi-Purpose Room) in Mary Gates Hall
Instructor: Gene Kim
*****ALL OMAD Staff members are welcome to make an individual or small group appointment to see me if this time does NOT fit your schedules. OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment/data projects specific to their programs’ needs.
Content: All contents in the workshops are related to protocols, security, and utilization of student data.
1) Addressing concerns related to the “two or more races” category and Hispanic/Latinx “override” from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of Maximum Representation for Multiracial/Multiethnic Students.
2) Introduction to MS Excel Pivot Table and MS Access.
3) UW Profiles: https://uwprofiles.uw.edu/
4) Only personnel AUTHORIZED TO EXAMINE AND WORK WITH FERPA (The Family Educational Rights and Privacy Act of 1974) PROTECTED STUDENT DATA at UW will be able to attend.
RSVP: CLOSED.
_______________________________________________________________________________________________