Workshops & Training

Data Seminar#30) Date:  July18, 2024  Time:  11:00am-12:00pm Location: via online
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.

Prerequisites: NONE.  Though the algorithms are written in R, Python, and SQL, we’ll focus on the excel outputs from these languages.

1) Fall2024 application algorithm via sec.sr_adm_appl  “Adam’s Apple”

• “Unirace” application in Fall 2024 appl_type 1,2,4 which matches EARS (Electronic Academic Records System).
• Maximum representation application in Fall 2024 appl_type 1,2,4.
• Admitted and confirmed overall  appl_type 1,2,4 applicants for Fall2024 via unirace model and diversity count which matches EARS (Electronic Academic Records System).
• Admitted and confirmed Business and Engineering applicants for Fall2024 via  sec.student_1_college_major using unirace model and diversity count which matches EARS (Electronic Academic Records System).

2) Difference between graduation rate and persistence rate.  SQL and Python algorithm to obtain persistence rate operationally defined by U.S. Department of Education.

3) 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#29) Date:  June 27, 2024  Time:  11:00am-12:00pm Location: via online
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.

Prerequisites: NONE.  Though the algorithms are written in R, Python, and SQL, we’ll focus on the excel outputs from these languages.

1) How many STEM major(s)/degree(s) are REQUESTED in the beginning and how many become STEM degree earners?  Path analysis (NOT structural equation modeling) of our students’ changes/development in their majors quarter to quarter via SQL and Python algorithm via sec.APPLHISTApplication  & other tables.

• 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.

2) Don’t try this in MS Excel or Access!   SQL and R algorithm demo: central tendency measurements (mean, median, standard deviation of specific course grades at specific calendar year) and number of students taken specific courses in a single cell at specific calendar year for the past 40 years in matter of 2-3 minutes.

3) IF we have time,  counting number of “stop outs” and withdrawals in relation to UW-Seattle UG graduation  via integrated SQL, R, and Python algorithm via sec.APPLHISTApplication & other 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#28) Date:  March 14, 2024  Time:  11:00am-12:00pm Location: via online
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.

Prerequisites: NONE—we encourage you to focus on the outputs/”overall useful theme” from various DS languages demonstrated and try to ignore the detailed code presented.

Case study:

1) Tracking STEM major status at the end of Fall2023 quarter, and STEM major status currently (Winter 2024) via sec.transcript & beyond.  For example:
a. Were STEM major(s) last quarter and are STEM major(s) currently.
b. Were STEM major(s)  last quarter but are no longer STEM major(s)  currently.
c. Were NOT STEM major(s)  last quarter but are STEM major(s) currently.
d. Were NOT STEM major(s)  last quarter and are NOT STEM major(s)  currently.

2) School/College transition “matrix” from Fall 2023 Quarter to Current Winter 2024 Quarter: For example,  number of UG students transitioning from Art and Sciences to Foster’s School of Business,  number of College Engineering UG students transitioning to Arts and Sciences and so forth via sec.transcript  (or addition of schools or colleges).

3) Who did NOT come back for the Winter 2024 quarter from Fall 2023 quarter via sec.transcript in relation to academic status (dean’s list, probation, drop….)?  Why do we (OMAD assessment team) exclude spcl_program 61?

4) Comparative analysis of academic status in relation to dean’s list, probation, drop and so forth between non-OMAD vs OMAD students.

5) Comparative cumulative and quarterly GPA analysis between Non-OMAD vs OMAD undergraduate students and data visualization via smooth density plots, boxplots, and non-parametric statistical analysis.

6) Changes in academic level : were undergraduates last quarter, but currently are graduate students.

7) Changes of campus: how many UW-Seattle undergraduate students transferred to UW Bothell or UW Tacoma campus in Winter2024 quarter?

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#27) Date:  February 29, 2024  Time:  1:00pm-2:00pm Location: via online
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.

Prerequisites: NONE—we encourage you to focus on the outputs/”overall useful theme” from various DS languages demonstrated and try to ignore the detailed code presented.

1) Automating institutional data for NSF/NIH federal grant/annual performance reports  via Python and SQL(Student Demographics & Performance).

2) Two of the algorithms presented at the December 2023 WERA(Washington Educational Research Conference).   In contrast to the conference presentation however, we will connect the algorithms to EDW and AIDB during the demo.   Each algorithm takes bit over 3 minutes to run.

3) Revisiting a 25 year old algorithm in relation to maximum unique number of students per schools and colleges at a university re-rewritten in combination of SQL, Julia, R, and Python  vs “old” algorithm written in R programming language.   For 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 uniquely per schools/colleges.

4) Python vs R vs Julia: why it doesn’t make a big difference (at least for gene’s operations).

5) Algorithm application in item “B” for historically underrepresented race/ethnicities via SQL and R (application of maximum representation beyond race/ethnicity).

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#26) Date:  February 22, 2024  Time:  1:00pm-2:00pm Location: via online OMAD staff only
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) Revisiting gene’s 16+ year old algorithm that automates NSF and US Dept. Ed. annual grant report under 3 minutes instead of weeks:

Case studies/examples:

a. Example of 16+ yr old algorithm of TRIO SSS annual report data automation for 6800+ EOP students from Summer2022 to Spring2023   (SECTION II — RECORD STRUCTURE                           FOR PARTICIPANT LIST)  via SQL and R (This algorithm was presented back in November 2007).

b. Example of 14+ yr old algorithm of LSAMP annual report data automation via SQL and Python (formerly R).

3) Material gene presented at the 2023 WERA(Washington Educational Research Conference):

a. 25 year old algorithm in relation to maximum unique number of students per schools and colleges at a university via SQL, R, and Python.

b. 12+ year old algorithm in relation to maximum representation of race/ethnicities via SQL, R, and Python.

4) If we have time, demonstrating automated operational data.

Case studies/examples:

a. ECC data -> combining and populating multiple 33 spreadsheets via EDW via SQL and R under 2 minutes.

b. CAMP data via SQL, Python, and R.

c. Why using Julia, Python, or R really doesn’t make a huge difference: demo on mixed algorithms.

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#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.

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).

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

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.

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.

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.

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#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.

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.

RSVP NOT REQUIRED

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.