{"id":218,"date":"2018-07-10T01:53:31","date_gmt":"2018-07-10T01:53:31","guid":{"rendered":"http:\/\/depts.washington.edu\/aromad\/?page_id=218"},"modified":"2026-04-08T18:46:38","modified_gmt":"2026-04-08T18:46:38","slug":"data-workshops","status":"publish","type":"page","link":"http:\/\/depts.washington.edu\/aromad\/data-workshops\/","title":{"rendered":"3 Campus Wide Data\/Assessment Workshops"},"content":{"rendered":"<p><strong>3 Campus Wide Data Workshops are opened to all University of Washington staff members in all 3 campuses <span style=\"color: #0000ff;\">in most cases<\/span>, <span style=\"color: #ff0000;\">WHO ARE AUTHORIZED TO EXAMINE AND WORK WITH FERPA (The Family Educational Rights and Privacy Act of 1974) PROTECTED STUDENT DATA.<\/span>\u00a0 <em><span style=\"text-decoration: underline;\">We will NOT be involved in specific data\/project requests outside OMAD<\/span><\/em>.\u00a0\u00a0<\/strong><\/p>\n<p><a href=\"http:\/\/depts.washington.edu\/aromad\/maximum-representation\/\">What is \u201c<strong>maximum representation<\/strong>?\u201d Please click on this link for an explanation.\u00a0<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>_____________________________________________________________________________________<\/p>\n<p><b>Data Seminar#39) Date: April 7, 2026 \u202fTime:\u202f 11:00am-11:30am Location: via online<br \/>\n<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><strong>Instructor: <a href=\"https:\/\/www.washington.edu\/omad\/aromad\/gene-kim\/\">Gene Kim<\/a><\/strong><\/span><\/b><\/p>\n<p><em><strong>*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu or genekim@uw.edu to request assessment\/data projects specific to their programs\u2019 needs.<\/strong><\/em><\/p>\n<p>Prerequisites: NONE.\u00a0 Though the algorithms are written in <strong>Python, R, Julia Programming Language,<\/strong> and <strong>SQL<\/strong>, we\u2019ll focus on the excel outputs from these languages.\u00a0 I will not go beyond columns, rows, mean, median, standard deviation, %, fractions, and decimals.<\/p>\n<ol>\n<li style=\"list-style-type: none;\">How many quarters does it takes to finish a Ph.D. <strong>at UW-Seattle<\/strong>? All doctorates stored in EDW\/UWSDB, by degree major\/department, college\/school, UW student ID number, race\/ethnicity, gender, names in just over 1 minute and 15 seconds via <strong>SQL<\/strong> and <strong>Python<\/strong> automating algorithm.\u00a0 Reviving a 14 year old algorithm:\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>\n<style>\na {<br \/>    text-decoration: none;<br \/>    color: #464feb;<br \/>}<br \/>tr th, tr td {<br \/>    border: 1px solid #e6e6e6;<br \/>}<br \/>tr th {<br \/>    background-color: #f5f5f5;<br \/>}<br \/><\/style>\n<p><strong>The advantage of counting the number of quarters to Ph.D. completion, rather than calculating the time by subtracting the start date from the end date (and dividing the number of quarters by 4):<\/strong><\/p>\n<div>\n<ol>\n<li><strong>Counting the quarters from the starting quarter to the quarter in which the Ph.D.\/doctorate was completed(within UW-Seattle).<\/strong><\/li>\n<li><strong>Counting the quarters after completion of the master\u2019s degree<\/strong> (e.g., in my Ph.D. program, the master\u2019s degree was a byproduct of passing the Ph.D. qualifying exams) <strong>when the master\u2019s and Ph.D.\/doctorate were completed within the same school or college(within UW-Seattle).<\/strong><\/li>\n<li><strong><strong>Counting the quarters after completion of the master\u2019s degree when the master\u2019s degree was earned in a different school or college from the one in which the Ph.D.\/doctorate was completed(within UW-Seattle).<\/strong><\/strong><\/li>\n<\/ol>\n<\/div>\n<\/li>\n<li>Simple <strong>SQL<\/strong> , <strong>R code via Quarto<\/strong> demo: automating and completing report which would take hours or days in matter of seconds.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ol>\n<li style=\"list-style-type: none;\"><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p><strong>RSVP NOT REQUIRED.<\/strong><\/p>\n<p>_____________________________________________________________________________________<\/p>\n<p><b>Data Seminar#38) Date<\/b>:\u00a0 March 4, 2026 \u202f<b>Time<\/b>:\u202f 11:00am-11:45am <b>Location<\/b>: via online<br \/>\n<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><strong>Instructor: <a href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><\/p>\n<p><em><strong>*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu or genekim@uw.edu to request assessment\/data projects specific to their programs\u2019 needs.<\/strong><\/em><\/p>\n<p>Prerequisites: NONE.\u00a0 Though the algorithms are written in <strong>Python, R, Julia Programming Language,<\/strong> and <strong>SQL<\/strong>, we\u2019ll focus on the excel outputs from these languages.\u00a0 I will not go beyond columns, rows, mean, median, standard deviation, %, fractions, and decimals.<\/p>\n<p>All 571,000+ UW-Seattle, UW-Bothell, UW-Tacoma BA\/BS, MA\/MS, Ph.D., M.D, DDS, J.D&#8230;. stored in EDW, with demographic data by every quarter and year from Spring of 1939 to Fall of 2025 via algorithm written in SQL and Julia Programming Language in under 1 minute:<\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>Counting maximum unique degree majors <strong>within<\/strong> and <strong>outside <\/strong>Colleges\/Schools from Spring of 1939 to Fall of 2025 in under 2 minutes(length of wait time of the Julia SQL algorithm):\n<ul>\n<li>Counting maximum unique number of <u>degree earners<\/u> <strong>within<\/strong> School\/College:\u00a0 For example, Counting maximum unique accounting degree earners = Accounting degree earners only, Accounting and Information Systems degree earners, Accounting and Marketing degree earners..within School of Business.<\/li>\n<li>Counting maximum unique number of degree earners <strong>outside <\/strong>Schools\/Colleges:\u00a0\u00a0 For example, counting MD\/Ph.D. degree earners separately and uniquely per degree majors =\u00a0 counting unique maximum number of Ph.D. in chemistry (Arts &amp; Sciences) in 2018 and counting unique maximum number of M.D. (Medicine) degree earner in medicine in 2020.<\/li>\n<\/ul>\n<\/li>\n<li>Caution of utilizing AI tools at current developmental stage : \u201ca very overconfident stack overflow\u201d which guesses and estimates with generous &amp; wide margin of error.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ol>\n<li style=\"list-style-type: none;\"><\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p><strong>RSVP NOT REQUIRED.<\/strong><\/p>\n<p>_____________________________________________________________________________________<\/p>\n<p><b>Data Seminar#37) Date<\/b>:\u00a0 January 13, 2026 \u202f<b>Time<\/b>:\u202f 11:00am-11:45am <b>Location<\/b>: via online<br \/>\n<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><strong>Instructor: <a href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><\/p>\n<p><em><strong>*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu or genekim@uw.edu to request assessment\/data projects specific to their programs\u2019 needs.<\/strong><\/em><\/p>\n<p>Prerequisites: NONE.\u00a0 Though the algorithms are written in <strong>Python, R, Julia Programming Language,<\/strong> and <strong>SQL<\/strong>, we\u2019ll focus on the excel outputs from these languages.\u00a0 I will not go beyond columns, rows, mean, median, standard deviation, %, fractions, and decimals.<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><span style=\"color: #0000ff;\"><strong>Big Picture First<\/strong><\/span>: Overall Julia algorithm(SQL integrated) that takes under 3 minutes to run will provide:\n<ul>\n<li>Every single cumulative GPA, majors, academic status\/scholarship types by UW academic quarter and year from <strong>Spring1946 to Fall 2025<\/strong> under a minute for <strong>all<\/strong> undergraduates recorded in EDW (per row of each unique student).<\/li>\n<li>Count every single \u201cstop_out\u201d(ex. Drop out, transfer out, stop out) count which automatically excludes summer quarters from <strong>Spring1946 to Fall 2025<\/strong> under a minute for <strong>all<\/strong> undergraduates recorded in EDW(per row of each unique student).<\/li>\n<li>Count every withdrawal counts from <strong>Spring1946 to Fall 2025<\/strong> under a minute for <strong>all<\/strong> undergraduates recorded in EDW(per row of each unique student).<\/li>\n<li>How many undergraduate students earned below attempted credit for Fall2025.<\/li>\n<li>How many undergraduates graduated in Fall2025 (this number will increase as time progresses).<\/li>\n<li>How many undergraduate students are back for Winter2026 quarter from Fall2025 quarter (for those who did NOT graduate yet).<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul>\n<li>Application of <strong>polars<\/strong> in substitute of <strong>pandas<\/strong> in Python programming language: downloading and calculating (via SQL &amp; Python) 8.2 million rows\u00a0 by 14 columns EDW dataframe in under 30 seconds.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><span style=\"color: #0000ff;\"><strong>College of Engineering and bit of School of Business with all features applied above. <\/strong><\/span><\/li>\n<\/ul>\n<p>We will primarily focus on engineering undergraduate majors with \u201cJ\u201d designation which will <strong>exclude<\/strong> bioengineering majors which\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 belongs in \u201cO\u201d designation (INTERSCHOOL OR INTERCOLLEGE PROGRAMS) via sec.transcript table in EDW.<\/p>\n<p>Maximum unique count of all undergraduate majors in schools or colleges:<\/p>\n<p><strong>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Example:<\/strong> Maximum unique number of accounting majors. therefore =<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li>Accounting majors only.<\/li>\n<li>Accounting &amp; Finance majors.<\/li>\n<li>Accounting &amp; Information Systems\u2026.and so forth.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p>Maximum unique count of undergraduate students per school of college:<\/p>\n<p><strong>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Example:<\/strong> Maximum unique number of undergraduate students in College of Arts and Sciences.<br \/>\nTherefore=<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li>Arts &amp; Sciences only.<\/li>\n<li>Art &amp; Science and College of Engineering.<\/li>\n<li>Art &amp; Science and School of Business and so forth<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p>Data visualization example via chemical engineering majors: density plots, boxplots,\u00a0 contingency tables.<\/p>\n<p>Why I\u2019m sticking with ggplot2 for data visualization.<\/p>\n<p><strong>RSVP NOT REQUIRED.<\/strong><br \/>\n_____________________________________________________________________________________<\/p>\n<p><b>Data Seminar#36) Date<\/b>:\u00a0 October 7, 2025 \u202f<b>Time<\/b>:\u202f 10:30am-11:00am <b>Location<\/b>: via online<br \/>\n<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><strong>Instructor: <a href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><\/p>\n<p><em><strong>*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu or genekim@uw.edu to request assessment\/data projects specific to their programs\u2019 needs.<\/strong><\/em><\/p>\n<p>Prerequisites: NONE.\u00a0 Though the algorithms are written in <strong>Python, R, Julia Programming Language,<\/strong> and <strong>SQL<\/strong>, we\u2019ll focus on the excel outputs from these languages.\u00a0 I will not go beyond columns, rows, mean, median, standard deviation, %, fractions, and decimals.<\/p>\n<p>First_Year_Undergraduates&#8217; 4,5,6 year graduation rate:<\/p>\n<ul>\n<li>Why 6 years graduation rate over 4 or 5 graduation rate?<\/li>\n<li>Graduation rate by first-generation, pell eligibility and other demographic characteristics.<\/li>\n<li>Last class standing(First_Year_Undergraduates, sophomore, junior, senior) of students who have transferred out, dropped out, stopped out from UW-Seattle.<\/li>\n<li>Where do they go? (Institutions outside UW) UW-Seattle First_Year_Undergraduate cohort who transferred out, dropped out, stopped out from UW-Seattle.\u00a0 Integrating AIDB, EDW, and National Student Clearinghouse data. Number of BA\/BS earners outside UW and students still enrolled outside UW as well as number of unknowns.<\/li>\n<li>Last Cumulative Undergraduate GPA of students who did not graduate vs BA\/BS earners at UW-Seattle.<\/li>\n<li>How many quarters do our students miss and still graduate per cohort?<\/li>\n<li>How many STEM &amp; non_STEM degree earners per cohort at UW-Seattle?<\/li>\n<\/ul>\n<p><strong>RSVP NOT REQUIRED.<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>_____________________________________________________________________________________<\/p>\n<p><b>Data Seminar#35) Date<\/b>:\u00a0 August 19, 2025 \u202f<b>Time<\/b>:\u202f 10:30am-11:30am <b>Location<\/b>: via online<br \/>\n<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><strong>Instructor: <a href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><\/p>\n<p><em><strong>*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu or genekim@uw.edu to request assessment\/data projects specific to their programs\u2019 needs.<\/strong><\/em><\/p>\n<p>Prerequisites: NONE.\u00a0 Though the algorithms are written in <strong>Python, R, Julia Programming Language,<\/strong> and <strong>SQL<\/strong>, we\u2019ll focus on the excel outputs from these languages.\u00a0 I will not go beyond columns, rows, mean, median, standard deviation, %, fractions, and decimals.<\/p>\n<p>&nbsp;<\/p>\n<ol>\n<li>Fall 2025 UW\u2013Seattle Incoming\/Confirmed Freshman Demographic Data Delivered <strong>in 55 Seconds<\/strong> via <strong>SQL <\/strong>and <strong>Python<\/strong> Algorithm, Producing:<\/li>\n<\/ol>\n<ul>\n<li>Geomapping Video: Visualization of incoming freshman students (using the unirace model) across the United States and globally.<\/li>\n<li>Demographic Breakdown:\n<ul>\n<li>Overall student demographics<\/li>\n<li>Washington state residents vs. non-residents<\/li>\n<li>International students by visa type<\/li>\n<\/ul>\n<\/li>\n<li>School\/College Demographics:\n<ul>\n<li>Engineering<\/li>\n<li>Business<\/li>\n<\/ul>\n<\/li>\n<li>Maximum representation.<\/li>\n<\/ul>\n<p>2. Demographic trend of freshman application and incoming enrollment data from Fall2013 and Fall2024 via\u00a0 <em style=\"color: #3d3d3d;\">UW EDW <strong>sec.APPLHISTApplication<\/strong> and <strong>sec.APPLHISTStudent <\/strong><\/em><span style=\"color: #3d3d3d;\">in unirace and maximum representation <\/span><strong style=\"color: #3d3d3d;\">within 75 seconds <\/strong><span style=\"color: #3d3d3d;\">via <\/span><strong style=\"color: #3d3d3d;\">R<\/strong><span style=\"color: #3d3d3d;\"> and <\/span><strong style=\"color: #3d3d3d;\">SQL<\/strong><span style=\"color: #3d3d3d;\"> algorithm<\/span><em style=\"color: #3d3d3d;\"><strong>.<\/strong><\/em><\/p>\n<p>&nbsp;<\/p>\n<p>3. Via <strong>SQL<\/strong> and <strong>R<\/strong> programming language algorithm under 11 minutes:<\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>How many quarters do our students miss and still graduate per cohort?<\/li>\n<li>How many STEM &amp; non_STEM degree earners per cohort?<\/li>\n<li>Calculating every single undergraduate cumulative GPA per quarter and year to measure persistence.<\/li>\n<li>Why do we use 6 year graduation rate rather than 4 or 5?<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">______________________________________________________________________________________<\/span><\/p>\n<p><b>Data Seminar#34) Date<\/b>:\u00a0 July 15, 2025 \u202f<b>Time<\/b>:\u202f 10:30am-11:30am <b>Location<\/b>: via online<br \/>\n<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><strong>Instructor: <a href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><\/p>\n<p><em><strong>*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu or genekim@uw.edu to request assessment\/data projects specific to their programs\u2019 needs.<\/strong><\/em><\/p>\n<p>Prerequisites: NONE.\u00a0 Though the algorithms are written in <strong>Python, R, Julia Programming Language,<\/strong> and <strong>SQL<\/strong>, we\u2019ll focus on the excel outputs from these languages.\u00a0 I will not go beyond columns, rows, mean, median, standard deviation, %, fractions, and decimals.<\/p>\n<ol>\n<li>Original intended design for maximum representation at the University of Wisconsin-Madison back 1999. \u00a0 We will revisit a 26 year old algorithm of maximum unique number of students per schools and colleges at UW-Seattle, \u00a0re-rewritten in Julia programming language where the execution speed should be\u00a0 <strong>under 2 minutes <\/strong>for Spring 2025 quarter via \u201c<strong>sec.transcript<\/strong>\u201d and other data tables.\u00a0 \u00a0Please observe the table below. Charlie is triple majoring in Math, Biology, and Business, Mary is majoring in math and electrical engineering\u2026and so forth:<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p>a. How many maximum unique math majors do you see below? Hopefully you said <strong style=\"color: #3d3d3d;\">4<\/strong><span style=\"color: #3d3d3d;\">.<\/span><\/p>\n<p>b. How many maximum unique business majors do you see below? Hopefully you said <strong>2<\/strong>.<\/p>\n<p>c. Can one unique student belong in more than one School or College? Hopefully you said \u201c<strong>yes<\/strong>.\u201d So do we count Charlie as less math and more business?<\/p>\n<p>d. We will also discuss other applications of this algorithm.<\/p>\n<table style=\"height: 274px;\" width=\"694\">\n<tbody>\n<tr>\n<td width=\"96\">Name<\/td>\n<td width=\"179\">Major1<\/td>\n<td width=\"187\">Major2<\/td>\n<td width=\"139\">Major3<\/td>\n<\/tr>\n<tr>\n<td width=\"96\">Charlie<\/td>\n<td width=\"179\">Math=C_Arts &amp;Sci<\/td>\n<td width=\"187\">Biology=C_Arts &amp;Sci<\/td>\n<td width=\"139\">Business Adminstration=E_Foster School of Business<\/td>\n<\/tr>\n<tr>\n<td width=\"96\">Mary<\/td>\n<td width=\"179\">Math=C_Arts &amp;Sci<\/td>\n<td width=\"187\">Electrical_Engineering_J_Col_of_Engineering<\/td>\n<td width=\"139\"><\/td>\n<\/tr>\n<tr>\n<td width=\"96\">John<\/td>\n<td width=\"179\">Math=C_Arts &amp;Sci<\/td>\n<td width=\"187\">Nursing=N_School of Nursing<\/td>\n<td width=\"139\"><\/td>\n<\/tr>\n<tr>\n<td width=\"96\">Teri<\/td>\n<td width=\"179\">Math=C_Arts &amp;Sci<\/td>\n<td width=\"187\">Business Adminstration=E_Foster School of Business<\/td>\n<td width=\"139\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>2) Data visualization how many non_UW Credits \u00a0Fall 2019 to Fall2024 UW-Seattle Incoming Undergraduate Freshman Students bring in via \u00a0<strong>APPLHISTApplication<\/strong> and other tables via SQL, R, and Python in <strong>under 1 minute<\/strong>.\u00a0 Trend and demographic analysis.<\/p>\n<p>3) <u>IF we have time<\/u>: difference between graduation rate and persistence rate.\u00a0 Obtaining persistence rate and time relative cumulative GPA and academic status operationally defined by U.S. Department of Education via\u00a0 <strong>SQL<\/strong> and <strong>R<\/strong>, <strong>Python<\/strong> algorithm.<\/p>\n<p>4) Combining and populating multiple 33 or 330 or 33,000 separate spreadsheets via EDW via <strong>SQL<\/strong> and <strong>R<\/strong> <strong>under 2 minutes<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>RSVP NOT REQUIRED.<\/strong><\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">______________________________________________________________________________________<\/span><\/p>\n<p><b>Data Seminar#33) Date<\/b>:\u00a0 July 8, 2025 \u202f<b>Time<\/b>:\u202f 10:30am-11:30am <b>Location<\/b>: via online<br \/>\n<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><strong>Instructor: <a href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><\/p>\n<p><em><strong>*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu or genekim@uw.edu to request assessment\/data projects specific to their programs\u2019 needs.<\/strong><\/em><\/p>\n<p>Prerequisites: NONE.\u00a0 Though the algorithms are written in <strong>Python, R, Julia Programming Language,<\/strong> and <strong>SQL<\/strong>, we\u2019ll focus on the excel outputs from these languages.\u00a0 I will not go beyond columns, rows, mean, median, standard deviation, %, fractions, and decimals.<\/p>\n<p>1) All chemistry(all course with abbreviation CHEM) courses (it could be any course) taken by UW-Seattle undergraduates in the past 46 years by course number, dept abbrev, quarter and year, with individual grades, central tendency measurements (mean, median, \u201cN\u201d, and standard deviation of grades), student names, and demographic features such as race\/ethnicity gender attached to the outputs in <strong>under 2 minutes<\/strong> instead of weeks or months via <strong>SQL<\/strong> and <strong>Julia<\/strong> algorithm.\u00a0 Can we \u201ceyeball predict\u201d\u00a0 between student performance and types of degrees attained without regression modeling?<\/p>\n<p>2) How many of our UW-Seattle BA\/BS earners (from 2010 to 2015 calendar year) earned their masters, doctorates, and professional degrees <strong>within <\/strong>UW systems (Seattle, Bothell, Tacoma, STEM vs NOT) and <strong>outside<\/strong> UW systems (ex. UMichigan, UWisconsin, Purdue\u2026..) just over <strong>\u00a02 minutes<\/strong> \u00a0instead of weeks or months.\u00a0 Integrating EDW, AIDB, and National Student Clearinghouse data via <strong>SQL<\/strong> and <strong>R<\/strong> and <strong>Python<\/strong> algorithm.<br \/>\n*****Trickiest algorithm: estimating <strong>currently enrolled<\/strong> graduate and professional students within and outside UW systems.<\/p>\n<p>&nbsp;<\/p>\n<p>3) Spring 2025 UG transcript data analysis via <strong>SQL<\/strong> and <strong>Julia<\/strong> algorithm:<\/p>\n<ul>\n<li>Calculating all 7, 009,006 rows by 15 column variables to produce \u201cquarterly relative cumulative GPA transactions\u201d for each respective quarter and year in less than 15 seconds: for example, Fall2021 cumulative GPA of 3.4; Winter2022 Cumulative GPA of 3.65 and so forth for all 30,000+ individual undergraduate students for the past 60 quarters.\u00a0 And why is this important? (persistence rate and relative undergraduate GPA)<\/li>\n<\/ul>\n<ul>\n<li>Were STEM major(s) last quarter and are STEM major(s) currently.<\/li>\n<li>Were STEM major(s) last quarter but are no longer STEM major(s)<\/li>\n<li>Were NOT STEM major(s) last quarter but are STEM major(s) currently.<\/li>\n<li>Were NOT STEM major(s) last quarter and are NOT STEM major(s)<\/li>\n<li>How many students went below the attempted credits?<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>4) <u>IF we have time<\/u>: difference between graduation rate and persistence rate.\u00a0 Obtaining persistence rate and time relative cumulative GPA and academic status operationally defined by U.S. Department of Education via\u00a0 <strong>SQL<\/strong> and <strong>R<\/strong>, <strong>Python<\/strong> algorithm.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>RSVP NOT REQUIRED.<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">______________________________________________________________________________________<\/span><\/p>\n<p><b>Data Seminar#32) Date<\/b>:\u00a0 April 3, 2025 \u202f<b>Time<\/b>:\u202f 10:00am-11:30am <b>Location<\/b>: via online Student Data Council Meeting<br \/>\n<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><strong>Instructor:\u00a0<a href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><\/p>\n<p>Prerequisites: <span style=\"color: #ff0000;\">NONE<\/span>\u2014we encourage you to focus on the outputs\/\u201doverall useful theme\u201d from various DS languages demonstrated and try to ignore the detailed code presented.<\/p>\n<p><span style=\"color: #0000ff;\"><em><strong>*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment\/data projects specific to their programs\u2019 needs.<\/strong><\/em><\/span><\/p>\n<p>Prerequisites: NONE.\u00a0 Though the algorithms are written in <strong>Python, R, Julia Programming Language, and SQL,<\/strong> we\u2019ll focus on the excel outputs from these languages.<\/p>\n<p>1) How many of our UW-Seattle BA\/BS earners (from 2010 to 2015 calendar year) earned their masters, doctorates, and professional degrees within UW systems (Seattle, Bothell, Tacoma, STEM vs NOT) and outside UW systems (ex. UMichigan, UWisconsin, Purdue\u2026..) in 45 seconds instead of weeks or months.\u00a0 Integrating EDW, AIDB, and National Student Clearinghouse data via <strong>SQL<\/strong> and <strong>R algorithm<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n<p>2) All math courses (it could be any course) taken by UW-Seattle undergraduates in the past 45 years by course number, dept abbrev, quarter and year, with individual grades, central tendency measurements (mean, median, \u201cN\u201d, and standard deviation of grades), student names, and demographic features such as race\/ethnicity gender attached to the outputs in 1 minute and 45 seconds instead of weeks or months via<strong> SQL and R algorithm<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n<p>3) Example of automating algorithm of NSF Grant Annual Report for student demographics and performance in 1 minute and 50 seconds instead of weeks via <strong>SQL and Python algorithm<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n<p>4) IF we have time: difference between graduation rate and persistence rate.\u00a0 Obtaining persistence rate and time relative cumulative GPA and academic status operationally defined by U.S. Department of Education via\u00a0 <strong>SQL and Python algorithm<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n<p>5) IF we have time: Fall2024 UG transcript data analysis via <strong>SQL and Julia algorithm<\/strong>:<\/p>\n<p>-Were STEM major(s) last quarter and are STEM major(s) currently.<br \/>\n-Were STEM major(s)\u00a0 last quarter but are no longer STEM major(s)\u00a0 currently.<br \/>\n-Were NOT STEM major(s)\u00a0 last quarter but are STEM major(s) currently.<br \/>\n-Were NOT STEM major(s)\u00a0 last quarter and are NOT STEM major(s)\u00a0 currently.<br \/>\n-School\/College transition \u201cmatrix\u201d from Fall 2024 Quarter to Current Winter 2025<br \/>\n-Quarter: For example,\u00a0 number of UG students transitioning from Art and Sciences to Foster\u2019s School of Business (or vise versa),\u00a0 number of College Engineering UG students transitioning\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0to Arts and Sciences and so forth via sec.transcript\u00a0 (or addition of schools or colleges).<\/p>\n<p>&nbsp;<\/p>\n<p><strong>RSVP NOT REQUIRED.<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">______________________________________________________________________________________<\/span><\/p>\n<p><b>Data Seminar#31) Date<\/b>:\u00a0 March 18, 2025 \u202f<b>Time<\/b>:\u202f 11:00am-12:00pm\u00a0<b>Location<\/b>: via online<br \/>\n<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><strong>Instructor:\u00a0<a href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><\/p>\n<p>Prerequisites: <span style=\"color: #ff0000;\">NONE<\/span>\u2014we encourage you to focus on the outputs\/\u201doverall useful theme\u201d from various DS languages demonstrated and try to ignore the detailed code presented.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #0000ff;\"><em><strong>*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment\/data projects specific to their programs\u2019 needs.<\/strong><\/em><\/span><\/p>\n<p>Prerequisites: NONE.\u00a0 Though the algorithms are written in <strong>Python, R, Julia Programming Language, and SQL,<\/strong> we\u2019ll focus on the excel outputs from these languages.<\/p>\n<p>1) How many of our UW-Seattle BA\/BS earners (from 2010 to 2015 calendar year) earned their masters, doctorates, and professional degrees within UW systems (Seattle, Bothell, Tacoma, STEM vs NOT) and outside UW systems (ex. UMichigan, UWisconsin, Purdue\u2026..) in 45 seconds instead of weeks or months.\u00a0 Integrating EDW, AIDB, and National Student Clearinghouse data via <strong>SQL<\/strong> and <strong>R algorithm<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n<p>2) All math courses (it could be any course) taken by UW-Seattle undergraduates in the past 45 years by course number, dept abbrev, quarter and year, with individual grades, central tendency measurements (mean, median, \u201cN\u201d, and standard deviation of grades), student names, and demographic features such as race\/ethnicity gender attached to the outputs in 1 minute and 45 seconds instead of weeks or months via<strong> SQL and R algorithm<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n<p>3) Example of automating algorithm of NSF Grant Annual Report for student demographics and performance in 1 minute and 50 seconds instead of weeks via <strong>SQL and Python algorithm<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n<p>4) IF we have time: difference between graduation rate and persistence rate.\u00a0 Obtaining persistence rate and time relative cumulative GPA and academic status operationally defined by U.S. Department of Education via\u00a0 <strong>SQL and Python algorithm<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n<p>5) IF we have time: Fall2024 UG transcript data analysis via <strong>SQL and Julia algorithm<\/strong>:<\/p>\n<p>-Were STEM major(s) last quarter and are STEM major(s) currently.<br \/>\n-Were STEM major(s)\u00a0 last quarter but are no longer STEM major(s)\u00a0 currently.<br \/>\n-Were NOT STEM major(s)\u00a0 last quarter but are STEM major(s) currently.<br \/>\n-Were NOT STEM major(s)\u00a0 last quarter and are NOT STEM major(s)\u00a0 currently.<br \/>\n-School\/College transition \u201cmatrix\u201d from Fall 2024 Quarter to Current Winter 2025<br \/>\n-Quarter: For example,\u00a0 number of UG students transitioning from Art and Sciences to Foster\u2019s School of Business (or vise versa),\u00a0 number of College Engineering UG students transitioning\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0to Arts and Sciences and so forth via sec.transcript\u00a0 (or addition of schools or colleges).<\/p>\n<p>6) Difference between graduation rate and persistence rate.\u00a0 SQL and Python and R algorithm to obtain persistence rate operationally defined by U.S. Department of Education.<\/p>\n<p><strong>RSVP NOT REQUIRED.<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">_______________________________________________________________________________________<\/span><\/p>\n<p><b>Data Seminar#30) Date<\/b>:\u00a0 July18, 2024 \u202f<b>Time<\/b>:\u202f 11:00am-12:00pm\u00a0<b>Location<\/b>: via online<br \/>\n<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><strong>Instructor:\u00a0<a href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><\/p>\n<p>Prerequisites: <span style=\"color: #ff0000;\">NONE<\/span>\u2014we encourage you to focus on the outputs\/\u201doverall useful theme\u201d from various DS languages demonstrated and try to ignore the detailed code presented.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #0000ff;\"><em><strong>*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment\/data projects specific to their programs\u2019 needs.<\/strong><\/em><\/span><\/p>\n<p>&nbsp;<\/p>\n<p>1) Fall2024 application algorithm via sec.sr_adm_appl\u00a0 \u201cAdam\u2019s Apple\u201d<\/p>\n<ul>\n<li>\u201cUnirace\u201d application in Fall 2024 appl_type 1,2,4 which matches EARS (Electronic Academic Records System).<\/li>\n<li>Maximum representation application in Fall 2024 appl_type 1,2,4.<\/li>\n<li>Admitted and confirmed overall\u00a0 appl_type 1,2,4 applicants for Fall2024 via unirace model and diversity count which matches EARS (Electronic Academic Records System).<\/li>\n<li>Admitted and confirmed Business and Engineering applicants for Fall2024 via\u00a0 sec.student_1_college_major using demographic characteristic count which matches EARS (Electronic Academic Records System).<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>2) Difference between graduation rate and persistence rate.\u00a0 SQL, R, and Python algorithm to obtain persistence rate operationally defined by U.S. Department of Education.<\/p>\n<p>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.<\/p>\n<p><strong>RSVP NOT REQUIRED.<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">_______________________________________________________________________________________<\/span><\/p>\n<p><b>Data Seminar#29) Date<\/b>:\u00a0 June 27, 2024 \u202f<b>Time<\/b>:\u202f 11:00am-12:00pm <b>Location<\/b>: via online<br \/>\n<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><span style=\"color: #008000;\"><strong>Instructor: <a style=\"color: #008000;\" href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><\/span><\/p>\n<p><em><strong><span style=\"color: #3366ff;\">*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment\/data projects specific to their programs&#8217; needs.<\/span><\/strong><\/em><\/p>\n<p>Prerequisites: <span style=\"color: #ff0000;\">NONE<\/span>\u2014we encourage you to focus on the outputs\/\u201doverall useful theme\u201d from various DS languages demonstrated and try to ignore the detailed code presented.<\/p>\n<p>1) How many STEM major(s)\/degree(s) are REQUESTED in the beginning and how many become STEM degree earners?\u00a0 Path analysis (NOT structural equation modeling) of our students\u2019 changes\/development in their majors quarter to quarter via SQL and Python algorithm via sec.APPLHISTApplication\u00a0 &amp; other tables.<\/p>\n<ul>\n<li>Requested STEM majors and earned STEM degrees.<\/li>\n<li>Did NOT request STEM majors but earned STEM degrees.<\/li>\n<li>Requested STEM majors and earned NON-STEM degrees.<\/li>\n<li>Did NOT request STEM majors and earned NON-STEM degrees.<\/li>\n<\/ul>\n<p>2) Don\u2019t try this in MS Excel or Access!\u00a0\u00a0 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.<\/p>\n<p>&nbsp;<\/p>\n<p>3) IF we have time,\u00a0 counting number of \u201cstop outs\u201d and withdrawals in relation to UW-Seattle UG graduation \u00a0via integrated SQL, R, and Python algorithm via sec.APPLHISTApplication &amp; other tables.<\/p>\n<p>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.<\/p>\n<p><strong>RSVP NOT REQUIRED.<\/strong><\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">_______________________________________________________________________________________<\/span><\/p>\n<p><b>Data Seminar#28) Date<\/b>:\u00a0 March 14, 2024 \u202f<b>Time<\/b>:\u202f 11:00am-12:00pm <b>Location<\/b>: via online<br \/>\n<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><span style=\"color: #008000;\"><strong>Instructor: <a style=\"color: #008000;\" href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><\/span><\/p>\n<p><em><strong><span style=\"color: #3366ff;\">*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment\/data projects specific to their programs&#8217; needs.<\/span><\/strong><\/em><\/p>\n<p>Prerequisites: <span style=\"color: #ff0000;\">NONE<\/span>\u2014we encourage you to focus on the outputs\/\u201doverall useful theme\u201d from various DS languages demonstrated and try to ignore the detailed code presented.<\/p>\n<p>Case study:<\/p>\n<p>1) Tracking STEM major status at the end of Fall2023 quarter, and STEM major status currently (Winter 2024) via <strong><em>sec.transcript &amp; beyond<\/em><\/strong>.\u00a0 For example:<br \/>\na. Were STEM major(s) last quarter and are STEM major(s) currently.<br \/>\nb. Were STEM major(s) \u00a0last quarter but are no longer STEM major(s) \u00a0currently.<br \/>\nc. Were NOT STEM major(s) \u00a0last quarter but are STEM major(s) currently.<br \/>\nd. Were NOT STEM major(s) \u00a0last quarter and are NOT STEM major(s) \u00a0currently.<\/p>\n<p>2) School\/College transition \u201cmatrix\u201d from Fall 2023 Quarter to Current Winter 2024 Quarter: For example,\u00a0 number of UG students transitioning from Art and Sciences to Foster\u2019s School of Business,\u00a0 number of College Engineering UG students transitioning to Arts and Sciences and so forth via <strong><em>sec.transcript<\/em><\/strong> \u00a0(or addition of schools or colleges).<\/p>\n<p>3) Who did NOT come back for the Winter 2024 quarter from Fall 2023 quarter via <strong><em>sec.transcript<\/em><\/strong> in relation to academic status (dean\u2019s list, probation, drop\u2026.)?\u00a0 Why do we (OMAD assessment team) exclude spcl_program 61?<\/p>\n<p>4) Comparative analysis of academic status in relation to dean\u2019s list, probation, drop and so forth between non-OMAD vs OMAD students.<\/p>\n<p>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.<\/p>\n<p>6) Changes in academic level : were undergraduates last quarter, but currently are graduate students.<\/p>\n<p>7) Changes of campus: how many UW-Seattle undergraduate students transferred to UW Bothell or UW Tacoma campus in Winter2024 quarter?<\/p>\n<p>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.<\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">_______________________________________________________________________________________<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><b>Data Seminar#27) Date<\/b>:\u00a0 February 29, 2024 \u202f<b>Time<\/b>:\u202f 1:00pm-2:00pm <b>Location<\/b>: via online<br \/>\n<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><span style=\"color: #008000;\"><strong>Instructor: <a style=\"color: #008000;\" href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><\/span><\/p>\n<p><em><strong><span style=\"color: #3366ff;\">*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment\/data projects specific to their programs&#8217; needs.<\/span><\/strong><\/em><\/p>\n<p>Prerequisites: <span style=\"color: #ff0000;\">NONE<\/span>\u2014we encourage you to focus on the outputs\/\u201doverall useful theme\u201d from various DS languages demonstrated and try to ignore the detailed code presented.<\/p>\n<p>1) Automating institutional data for NSF\/NIH federal grant\/annual performance reports\u00a0 via Python and SQL(Student Demographics &amp; Performance).<\/p>\n<p>2) Two of the algorithms presented at the December 2023 WERA(Washington Educational Research Conference).\u00a0\u00a0 In contrast to the conference presentation however, we will connect the algorithms to EDW and AIDB during the demo.\u00a0\u00a0 Each algorithm takes bit over 3 minutes to run.<\/p>\n<p>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\u00a0 vs \u201cold\u201d algorithm written in R programming language.\u00a0\u00a0 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.<\/p>\n<p>4) Python vs R vs Julia: why it doesn\u2019t make a big difference (at least for gene\u2019s operations).<\/p>\n<p>5) Algorithm application in item \u201cB\u201d for historically underrepresented race\/ethnicities via SQL and R (application of maximum representation beyond race\/ethnicity).<\/p>\n<p>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.<\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">_______________________________________________________________________________________<\/span><\/p>\n<p><b>Data Seminar#26) Date<\/b>:\u00a0 February 22, 2024 \u202f<b>Time<\/b>:\u202f 1:00pm-2:00pm <b>Location<\/b>: via online OMAD staff only<br \/>\n<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><span style=\"color: #008000;\"><strong>Instructor: <a style=\"color: #008000;\" href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><\/span><\/p>\n<p><em><strong><span style=\"color: #3366ff;\">*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment\/data projects specific to their programs&#8217; needs.\u00a0<\/span><\/strong><\/em><\/p>\n<p>1) Automating institutional data for NSF\/NIH federal grant\/annual performance reports\u00a0 via Python and SQL(Student Demographics &amp; Performance).<\/p>\n<p>2) Revisiting gene&#8217;s 16+ year old algorithm that automates NSF and US Dept. Ed. annual grant report under 3 minutes instead of weeks:<\/p>\n<p><span style=\"color: #0000ff;\">Case studies\/examples:<\/span><\/p>\n<p>a. Example of 16+ yr old algorithm of TRIO SSS annual report data automation for 6800+ EOP students from Summer2022 to Spring2023 \u00a0 (SECTION II &#8212; RECORD STRUCTURE\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0FOR PARTICIPANT LIST) \u00a0via SQL and R (This algorithm was presented back in November 2007).<\/p>\n<p>b. Example of 14+ yr old algorithm of LSAMP annual report data automation via SQL and Python (formerly R).<\/p>\n<p>&nbsp;<\/p>\n<p>3) Material gene presented at the 2023 WERA(Washington Educational Research Conference):<\/p>\n<p>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.<\/p>\n<p>b. 12+ year old algorithm in relation to maximum representation of race\/ethnicities via SQL, R, and Python.<\/p>\n<p>&nbsp;<\/p>\n<p>4) If we have time, demonstrating automated operational data.<\/p>\n<p><span style=\"color: #0000ff;\">Case studies\/examples:<\/span><\/p>\n<p>a. ECC data -&gt; combining and populating multiple 33 spreadsheets via EDW via SQL and R under 2 minutes.<\/p>\n<p>b. CAMP data via SQL, Python, and R.<\/p>\n<p>c. Why using Julia, Python, or R really doesn\u2019t make a huge difference: demo on mixed algorithms.<\/p>\n<p>&nbsp;<\/p>\n<p>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.<\/p>\n<p>&nbsp;<\/p>\n<p>6) RSVP NOT REQUIRED.<\/p>\n<p>&nbsp;<\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">_______________________________________________________________________________________<\/span><\/p>\n<p><b>Data Seminar#25) Date<\/b>:\u00a0 July 27, 2023 \u202f<b>Time<\/b>:\u202f 10:00am-11:00am <b>Location<\/b>: 171E (Multi-Purpose Room) in Mary Gates Hall<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><br \/>\n<span style=\"color: #008000;\"><strong>Instructor: <a style=\"color: #008000;\" href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><\/span><\/p>\n<p><em><strong><span style=\"color: #3366ff;\">*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment\/data projects specific to their programs&#8217; needs.\u00a0<\/span><\/strong><\/em><\/p>\n<p>1) Automating institutional data for NSF\/NIH federal grant\/annual performance reports\u00a0 via Python and SQL(Student Demographics &amp; Performance).<\/p>\n<p>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 &#8220;maximum representation of enrollment&#8221; per schools\/colleges via &#8220;sec.transcript&#8221; and other data tables.<\/p>\n<p>3) <span style=\"font-size: 13.0pt; font-family: 'Times New Roman',serif; color: #3d3d3d;\">UW Profiles data via BI Portal.\u00a0<\/span><\/p>\n<p>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 \u201ctedious\u201d commands such as \u201cappend\u201d, \u201crbind\u201d, or \u201cconcat\u201d in matter of few minutes.<\/p>\n<p>5) Application of MS Excel pivot tables from Python, R, or Julia outputs.<\/p>\n<p>6) Addressing concerns related to the &#8220;two or more races&#8221; category and Hispanic\/Latinx &#8220;override&#8221; from the National Center for Education Statistics (Integrated Postsecondary Education Data System): Concept and practice of <a href=\"http:\/\/depts.washington.edu\/aromad\/maximum-representation\/\">Maximum Representation.<\/a><\/p>\n<p><span style=\"font-size: 13.0pt; font-family: 'Times New Roman',serif; color: #3d3d3d;\">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.\u00a0 <\/span><\/p>\n<p>RSVP NOT REQUIRED<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">_______________________________________________________________________________________<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><b>Data Seminar#24) Date<\/b>:\u00a0 July 10, 2023 \u202f<b>Time<\/b>:\u202f 10:00am-11:00am <b>Location<\/b>: 171E (Multi-Purpose Room) in Mary Gates Hall<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><br \/>\n<span style=\"color: #008000;\"><strong>Instructor: <a style=\"color: #008000;\" href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><\/span><\/p>\n<p><em><strong><span style=\"color: #3366ff;\">*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment\/data projects specific to their programs&#8217; needs.\u00a0<\/span><\/strong><\/em><\/p>\n<p>1) Application of\u00a0 <a href=\"http:\/\/depts.washington.edu\/aromad\/maximum-representation\/\">Maximum Representation<\/a>\u00a0 beyond ethnicity\/race.\u00a0 \u00a0Example: 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 &#8220;maximum representation of enrollment&#8221; per schools\/colleges via &#8220;sec.transcript&#8221; and other data tables.<\/p>\n<p>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 \u201ctedious\u201d commands such as \u201cappend\u201d, \u201crbind\u201d, or \u201cconcat\u201d in matter of few minutes.<\/p>\n<p>3) Application of MS Excel pivot tables from Python, R, or Julia outputs.<\/p>\n<p>4) Addressing concerns related to the &#8220;two or more races&#8221; category and Hispanic\/Latinx &#8220;override&#8221; from the National Center for Education Statistics (Integrated Postsecondary Education Data System): Concept and practice of <a href=\"http:\/\/depts.washington.edu\/aromad\/maximum-representation\/\">Maximum Representation.<\/a><\/p>\n<p>5) Spring 2023 UW-Seattle Undergraduate Transcript data (If time allows).<\/p>\n<p>6)\u00a0 STEM vs Non-STEM degree earners by various demographic characteristics for the last 5 years(If time allows).<\/p>\n<p><span style=\"font-size: 13.0pt; font-family: 'Times New Roman',serif; color: #3d3d3d;\">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.\u00a0 <\/span><\/p>\n<p>RSVP NOT REQUIRED<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">.<\/span><\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">_______________________________________________________________________________________<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><b>Data Seminar#23) Date<\/b>:\u00a0 June 22, 2023 \u202f<b>Time<\/b>:\u202f 10:00am-11:00am <b>Location<\/b>: 171E (Multi-Purpose Room) in Mary Gates Hall<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><br \/>\n<span style=\"color: #008000;\"><strong>Instructor: <a style=\"color: #008000;\" href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><\/span><\/p>\n<p><em><strong><span style=\"color: #3366ff;\">*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment\/data projects specific to their programs&#8217; needs.\u00a0<\/span><\/strong><\/em><\/p>\n<p>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 \u201ctedious\u201d commands such as \u201cappend\u201d, \u201crbind\u201d, or \u201cconcat\u201d in matter of few minutes.<\/p>\n<p>2) Application of MS Excel pivot tables from Python, R, or Julia outputs.<\/p>\n<p>3) Addressing concerns related to the &#8220;two or more races&#8221; category and Hispanic\/Latinx &#8220;override&#8221; from the National Center for Education Statistics (Integrated Postsecondary Education Data System): Concept and practice of <a href=\"http:\/\/depts.washington.edu\/aromad\/maximum-representation\/\">Maximum Representation.<\/a><\/p>\n<p>4) Spring 2023 UW-Seattle Undergraduate Transcript data.<\/p>\n<p>5)\u00a0 STEM vs Non-STEM degree earners by various demographic characteristics for the last 5 years.<\/p>\n<p><span style=\"font-size: 13.0pt; font-family: 'Times New Roman',serif; color: #3d3d3d;\">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.\u00a0 <\/span><\/p>\n<p>RSVP NOT REQUIRED<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">.<\/span><\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">_<\/span><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">______________________________________________________________________________________<\/span><\/p>\n<p><b>Data Seminar#22) Date<\/b>:\u00a0 January 20, 2023 \u202f<b>Time<\/b>:\u202f 10:00am-11:15am <b>Location<\/b>: 171E (Multi-Purpose Room) in Mary Gates Hall<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><br \/>\n<span style=\"color: #008000;\"><strong>Instructor: <a style=\"color: #008000;\" href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><\/span><\/p>\n<p><em><strong><span style=\"color: #3366ff;\">*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment\/data projects specific to their programs&#8217; needs.\u00a0<\/span><\/strong><\/em><\/p>\n<p>1) Data demo:<\/p>\n<ul>\n<li>Automating fiscal data using Python and R: dangers of overreliance on pivot tables in MS Excel.<\/li>\n<li>Basic documentation\u00a0 (html, MS Word, PDF) of data analysis via R Markdown and Quarto.<\/li>\n<li>How to lift hundreds of pages of PDF data tables to csv files via Python.<\/li>\n<\/ul>\n<p>2) Fall2022 transcript data: going beyond BI Portal via EDW and AIDB.<\/p>\n<p>3) Addressing concerns related to the &#8220;two or more races&#8221; category and Hispanic\/Latinx &#8220;override&#8221; from the National Center for Education Statistics (Integrated Postsecondary Education Data System): Concept and practice of <a href=\"http:\/\/depts.washington.edu\/aromad\/maximum-representation\/\">Maximum Representation.<\/a><\/p>\n<p>4) Basic pivot tables, and other basic spreadsheet functions.<\/p>\n<p><span style=\"font-size: 13.0pt; font-family: 'Times New Roman',serif; color: #3d3d3d;\">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.\u00a0 <\/span><\/p>\n<p>RSVP NOT REQUIRED<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">.<\/span><\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">_______________________________________________________________________________________<\/span><\/p>\n<p><b>Data Seminar#21) Date<\/b>:\u00a0 August 25, 2022 \u202f<b>Time<\/b>:\u202f 10:00am-11:30am <b>Location<\/b>: 171E (Multi-Purpose Room) in Mary Gates Hall<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><br \/>\n<span style=\"color: #008000;\"><strong>Instructor: <a style=\"color: #008000;\" href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><\/span><\/p>\n<p><em><strong><span style=\"color: #3366ff;\">*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment\/data projects specific to their programs&#8217; needs.\u00a0<\/span><\/strong><\/em><\/p>\n<p>Content:\u00a0 <strong>All contents in the workshops are related to protocols, security, and utilization of student data.\u00a0<\/strong><\/p>\n<p>1) Data demo:<\/p>\n<ul>\n<li>Python vs R vs&#8230;&#8230;Julia&#8212;- toggling between Python, R, and&#8230;..Julia (little bit) all integrated with SQL utilizing EDW\/AIDB via one IDE:Quarto.<\/li>\n<li>Basic documentation\u00a0 (html, MS Word, PDF) of data analysis via R Markdown and Quarto.<\/li>\n<li>How to lift hundreds of pages of PDF data tables to csv files via Python.<\/li>\n<\/ul>\n<p>2) Addressing concerns related to the &#8220;two or more races&#8221; category and Hispanic\/Latinx &#8220;override&#8221; from the National Center for Education Statistics (Integrated Postsecondary Education Data System): Concept and practice of <a href=\"http:\/\/depts.washington.edu\/aromad\/maximum-representation\/\">Maximum Representation.<\/a><\/p>\n<p>3) Basic pivot tables.<\/p>\n<p><span style=\"font-size: 13.0pt; font-family: 'Times New Roman',serif; color: #3d3d3d;\">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.\u00a0 <\/span><\/p>\n<p>RSVP NOT REQUIRED<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">_______________________________________________________________________________________<\/span><\/p>\n<p><b>Data Seminar#20) Date<\/b>:\u00a0 June 24, 2022 \u202f<b>Time<\/b>:\u202f 10:00am-11:10am <b>Location<\/b>: 171E (Multi-Purpose Room) in Mary Gates Hall<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><br \/>\n<span style=\"color: #008000;\"><strong>Instructor: <a style=\"color: #008000;\" href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><\/span><\/p>\n<p><em><strong><span style=\"color: #3366ff;\">*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment\/data projects specific to their programs&#8217; needs.\u00a0<\/span><\/strong><\/em><\/p>\n<p>Content:\u00a0 <strong>All contents in the workshops are related to protocols, security, and utilization of student data.\u00a0<\/strong><\/p>\n<p>1) Addressing concerns related to the &#8220;two or more races&#8221; category and Hispanic\/Latinx &#8220;override&#8221; from the National Center for Education Statistics (Integrated Postsecondary Education Data System): Concept and practice of <a href=\"http:\/\/depts.washington.edu\/aromad\/maximum-representation\/\">Maximum Representation<\/a><\/p>\n<p>2) Transcript data via EDW: OMAD in comparison to Non-OMAD undergraduate (freshman to seniors 1-4) students.<\/p>\n<p>3) Admissions data via BI-Portal in comparison to EDW query.<\/p>\n<p>4) Basic pivot tables.<\/p>\n<p><span style=\"font-size: 13.0pt; font-family: 'Times New Roman',serif; color: #3d3d3d;\">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.\u00a0 <\/span><\/p>\n<p>RSVP NOT REQUIRED<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">_______________________________________________________________________________________<\/span><\/p>\n<h2><b><span style=\"color: #ff0000;\">Data Seminar#20 is CANCELLED DUE TO COVID<\/span>) <del>Date<\/del><\/b><del>:\u00a0 <span style=\"color: #ff0000;\"><strong>January 6, 2022<\/strong><\/span>\u00a0\u202f<b>Time<\/b>:\u202f 10:00am-11:00am\u00a0 \u00a0<b>Location<\/b>: 171E (Multi-Purpose Room) in Mary Gates Hall<\/del><\/h2>\n<p><del>Content:\u00a0 <strong>All contents in the workshops are related to protocols, security, and utilization of student data.\u00a0<\/strong><\/del><\/p>\n<p><del>1) Addressing concerns related to the &#8220;two or more races&#8221; category and Hispanic\/Latinx &#8220;override&#8221; from the National Center for Education Statistics (Integrated Postsecondary Education Data System):\u00a0 Concept and practice of <a href=\"http:\/\/depts.washington.edu\/aromad\/maximum-representation\/\">Maximum Representation<\/a> for Multiracial\/Multiethnic Students and related items below:<\/del><\/p>\n<p><del>a.\u00a0 Introduction to Electronic Academic Records System (EARS).<\/del><br \/>\n<del>b.\u00a0 Introduction to\u00a0 <span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><a href=\"https:\/\/uwprofiles.uw.edu\/\">UW Profiles:\u00a0 \u00a0https:\/\/uwprofiles.uw.edu\/<\/a><\/span><\/del><br \/>\n<del>c.\u00a0 Introduction to EDW and AIDB.<\/del><br \/>\n<del>d. Integrating and automating SQL to Python to Excel for consumption.<\/del><\/p>\n<p>&nbsp;<\/p>\n<p><del>2) Data visualization (via density plots) of cumulative and quarterly undergraduate GPA distribution trends\u00a0 in relation to covid lockdown (prior, during, and present).<\/del><\/p>\n<p><del>a. Fall 2021 (and prior) transcript data analysis by name, student ID, ethnicity\/race, gender between OMAD and NON-OMAD undergraduate students.<\/del><br \/>\n<del>b. How OMAD data team utilize <strong><span style=\"color: #0000ff;\">R markdown<\/span><\/strong> for reporting <strong>(This is a demo, not an instruction)<\/strong>.<\/del><br \/>\n<del>c. Integrating and automating SQL to Python to Excel for consumption.<\/del><\/p>\n<p>&nbsp;<\/p>\n<p><del>3) Analysis of all courses attempted in Fall 2021 Quarter:<\/del><\/p>\n<p style=\"padding-left: 30px;\"><del>a. Class performance analysis by name, race\/ethnicity, gender, class standing, first-generation, pell-eligibility.<\/del><br \/>\n<del>b. Basic introduction to pivot table.<\/del><br \/>\n<del>c. Integrating and automating SQL to Python to Excel for consumption.<\/del><\/p>\n<p>&nbsp;<\/p>\n<p><del>4) Example(s) of automating repetitious\/tedious\u00a0 calculations in MyFinancial Desktop (Transaction Summary) by 10 or 20 or 30 or 100+ different budget numbers via <strong>R and Python<\/strong> <u>all at once<\/u><u> with one push of a button<\/u>\u00a0(This is a demo, not an instruction).<\/del><\/p>\n<p><del>5) <strong>Demo:<\/strong>\u00a0 Integrating and automating from <strong><em>SQL<\/em> <\/strong>-&gt;\u00a0 to <strong><em>Julia programming language <\/em><\/strong>integrated with<strong><em> R<\/em><\/strong> -&gt;\u00a0 to <em>MS <strong>Excel <\/strong><\/em>for consumption.<\/del><\/p>\n<p><del><span style=\"font-size: 13.0pt; font-family: 'Times New Roman',serif; color: #3d3d3d;\">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.\u00a0 <\/span><\/del><\/p>\n<p><del>RSVP NOT REQUIRED<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">.<\/span><\/del><\/p>\n<p>&nbsp;<\/p>\n<p><del><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">_______________________________________________________________________________________<\/span><\/del><\/p>\n<h1><b><del>Data Seminar#20) <\/del><span style=\"color: #ff0000;\"><del>I<\/del>S CANCELLED DUE TO COVID-19<\/span><\/b><\/h1>\n<p><del><em><strong><span style=\"color: #3366ff;\">*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment\/data projects specific to their programs&#8217; needs.\u00a0<\/span><\/strong><\/em><\/del><\/p>\n<p><del><b>Data Seminar#20) Date<\/b>:\u00a0 March 9, 2020 \u202f<b>Time<\/b>:\u202f 10:00am-11:15am\u00a0<b>Location<\/b>: 171E (Multi-Purpose Room) in Mary Gates Hall<\/del><\/p>\n<p><del>Content:\u00a0 <strong>All contents in the workshops are related to protocols, security, and utilization of student data.\u00a0<\/strong><\/del><\/p>\n<p><del>1) Analysis of all courses attempted in Fall 2019 Quarter (quick demo on SQL to R (also in Python) to Excel Spreadsheet\/Pivot_Table):<\/del><\/p>\n<p style=\"padding-left: 30px;\"><del>a. Most and least enrolled\/attempted classes by name, ethnicity, gender, class, first-generation, pell-eligible.<\/del><br \/>\n<del>b. Identification of &#8220;high-risk&#8221; courses in relation to performance: I will need help from advisers.<\/del><\/p>\n<p><del>2) Example(s) of automating repetitious\/tedious\u00a0 calculations in MyFinancial Desktop (Transaction Summary) by 10 or 20 or 30 or 100+ different budget numbers via <strong>R<\/strong>(instead of\u00a0Python<strong>)<\/strong>\u00a0<strong><u>all at once<\/u><\/strong><strong><u> with one push of a button<\/u><\/strong><strong>\u00a0(This is a demo, not an instruction).<\/strong><\/del><\/p>\n<p><del>3) Addressing concerns related to the &#8220;two or more races&#8221; category and Hispanic\/Latinx &#8220;override&#8221; from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of <a href=\"http:\/\/depts.washington.edu\/aromad\/maximum-representation\/\">Maximum Representation<\/a>\u00a0for Multiracial\/Multiethnic Students (<strong><span style=\"color: #ff0000;\">Upon Request<\/span><\/strong>).<\/del><br \/>\n<del>a.\u00a0 Introduction to\u00a0Electronic Academic Records System (EARS).<\/del><br \/>\n<del>b.\u00a0 Introduction to\u00a0\u00a0<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><a href=\"https:\/\/uwprofiles.uw.edu\/\">UW Profiles:\u00a0 \u00a0https:\/\/uwprofiles.uw.edu\/<\/a><\/span><\/del><br \/>\n<del>c.\u00a0 Introduction to EDW and AIDB.<\/del><\/p>\n<p><del><span style=\"font-size: 13.0pt; font-family: 'Times New Roman',serif; color: #3d3d3d;\">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.\u00a0 <\/span><\/del><\/p>\n<p><del>RSVP NOT REQUIRED<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">.<\/span><\/del><\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">_______________________________________________________________________________________<\/span><\/p>\n<p><b>Data Seminar#19) Date<\/b>:\u00a0 January 23, 2020 \u202f<b>Time<\/b>:\u202f 10:00am-11:15am <b>Location<\/b>: 171E (Multi-Purpose Room) in Mary Gates Hall<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><br \/>\n<span style=\"color: #008000;\"><strong>Instructor: <a style=\"color: #008000;\" href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><\/span><\/p>\n<p><em><strong><span style=\"color: #3366ff;\">*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment\/data projects specific to their programs&#8217; needs.\u00a0<\/span><\/strong><\/em><\/p>\n<p>Content:\u00a0 <strong>All contents in the workshops are related to protocols, security, and utilization of student data.\u00a0<\/strong><\/p>\n<p>1) Analysis of all courses attempted in Fall 2019 Quarter (quick demo on SQL to Python to Excel Spreadsheet):<\/p>\n<p style=\"padding-left: 30px;\">a. Most and least enrolled\/attempted classes by name, ethnicity, gender, class, first-generation, pell-eligible.<br \/>\nb. Identification of &#8220;high-risk&#8221; courses in relation to performance: I will need help from advisers.<\/p>\n<p>2) Example(s) of automating repetitious\/tedious\u00a0 calculations in MyFinancial Desktop (Transaction Summary) by 10 or 20 or 30 or 100+ different budget numbers via <strong>R<\/strong>(instead of\u00a0Python<strong>)<\/strong>\u00a0<strong><u>all at once<\/u><\/strong><strong><u> with one push of a button<\/u><\/strong><strong>\u00a0(This is a demo, not an instruction).<\/strong><\/p>\n<p>3) Addressing concerns related to the &#8220;two or more races&#8221; category and Hispanic\/Latinx &#8220;override&#8221; from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of <a href=\"http:\/\/depts.washington.edu\/aromad\/maximum-representation\/\">Maximum Representation<\/a>\u00a0for Multiracial\/Multiethnic Students (<strong><span style=\"color: #ff0000;\">Upon Request<\/span><\/strong>).<br \/>\na.\u00a0 Introduction to\u00a0Electronic Academic Records System (EARS).<br \/>\nb.\u00a0 Introduction to\u00a0\u00a0<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><a href=\"https:\/\/uwprofiles.uw.edu\/\">UW Profiles:\u00a0 \u00a0https:\/\/uwprofiles.uw.edu\/<\/a><\/span><br \/>\nc.\u00a0 Introduction to EDW and AIDB.<\/p>\n<p><span style=\"font-size: 13.0pt; font-family: 'Times New Roman',serif; color: #3d3d3d;\">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.\u00a0 <\/span><\/p>\n<p>RSVP NOT REQUIRED<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">.<\/span><\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">_____________________________________________________________________________________<\/span><\/p>\n<p><b>Data Seminar#18) Date<\/b>:\u00a0 January 14, 2020 \u202f<b>Time<\/b>:\u202f 10:00am-11:15am <b>Location<\/b>: 171E (Multi-Purpose Room) in Mary Gates Hall<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><br \/>\n<span style=\"color: #008000;\"><strong>Instructor: <a style=\"color: #008000;\" href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><\/span><\/p>\n<p><em><strong><span style=\"color: #3366ff;\">*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment\/data projects specific to their programs&#8217; needs.\u00a0<\/span><\/strong><\/em><\/p>\n<p>Content:\u00a0 <strong>All contents in the workshops are related to protocols, security, and utilization of student data.\u00a0<\/strong><\/p>\n<p>1) Analysis of all courses attempted in Fall 2019 Quarter:<\/p>\n<p style=\"padding-left: 30px;\">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 ).<br \/>\nb. Identification of &#8220;high-risk&#8221; courses in relation to performance: I will need help from advisers.<\/p>\n<p>2) Example(s) of automating repetitious\/tedious\u00a0 calculations in MyFinancial Desktop (Transaction Summary) by 10 or 20 or 30 or 40+ different budget numbers via <strong>R<\/strong>(instead of\u00a0Python<strong>)<\/strong>\u00a0<strong><u>all at once<\/u><\/strong><strong><u> with one push of a button<\/u><\/strong><strong>\u00a0(This is a demo, not an instruction).<\/strong><\/p>\n<p>3) Addressing concerns related to the &#8220;two or more races&#8221; category and Hispanic\/Latinx &#8220;override&#8221; from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of <a href=\"http:\/\/depts.washington.edu\/aromad\/maximum-representation\/\">Maximum Representation<\/a>\u00a0for Multiracial\/Multiethnic Students (<strong><span style=\"color: #ff0000;\">Upon Request<\/span><\/strong>).<\/p>\n<p><span style=\"font-size: 13.0pt; font-family: 'Times New Roman',serif; color: #3d3d3d;\">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.\u00a0 <\/span><\/p>\n<p>RSVP NOT REQUIRED<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">.<\/span><\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">_______________________________________________________________________________________<\/span><\/p>\n<p><b>Data Seminar#17) Date<\/b>:\u00a0 November 19, 2019 \u202f<b>Time<\/b>:\u202f 10:00am-11:15am <b>Location<\/b>: 171E (Multi-Purpose Room) in Mary Gates Hall<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><br \/>\n<span style=\"color: #008000;\"><strong>Instructor: <a style=\"color: #008000;\" href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><\/span><\/p>\n<p><em><strong><span style=\"color: #3366ff;\">*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment\/data projects specific to their programs&#8217; needs.\u00a0<\/span><\/strong><\/em><\/p>\n<p>Content:\u00a0 <strong>All contents in the workshops are related to protocols, security, and utilization of student data.\u00a0<\/strong><\/p>\n<p>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\u00a0 (If time allows, we will examine specific major(s)\/department(s)).<\/p>\n<p>2) From SQL &#8212;&gt; Python &#8212;&gt; to your MS Excel Spreadsheet:<br \/>\nHow data is: a) Gathered b) Organized\u00a0 c) Analyzed.<\/p>\n<p>3) Introduction to MS Excel Pivot Table and MS Access.<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">\u00a0<\/span><\/p>\n<p>4) Introduction to EARS (Electronic Academic Record System).<\/p>\n<p>5) Addressing concerns related to the &#8220;two or more races&#8221; category and Hispanic\/Latinx &#8220;override&#8221; from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of <a href=\"http:\/\/depts.washington.edu\/aromad\/maximum-representation\/\">Maximum Representation<\/a>\u00a0for Multiracial\/Multiethnic Students (<strong><span style=\"color: #ff0000;\">Upon Request<\/span><\/strong>).<\/p>\n<p>6) Introduction to R and Python (less emphasis than the previous session back in July 9, 2019).<\/p>\n<p>7) Introduction to\u00a0 <span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><a href=\"https:\/\/uwprofiles.uw.edu\/\">UW Profiles:\u00a0 \u00a0https:\/\/uwprofiles.uw.edu\/<\/a><\/span><\/p>\n<p>8)\u00a0 <span style=\"font-size: 13.0pt; font-family: 'Times New Roman',serif; color: #3d3d3d;\">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.\u00a0 <\/span><\/p>\n<p>RSVP NOT REQUIRED<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">.<\/span><\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">_______________________________________________________________________________________<\/span><\/p>\n<p><b>Data Seminar#16) Date<\/b>:\u00a0 October 1, 2019 \u202f<b>Time<\/b>:\u202f 10:00am-11:15am <b>Location<\/b>: 171E (Multi-Purpose Room) in Mary Gates Hall<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><br \/>\n<span style=\"color: #008000;\"><strong>Instructor: <a style=\"color: #008000;\" href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><\/span><\/p>\n<p><em><strong><span style=\"color: #3366ff;\">*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment\/data projects specific to their programs&#8217; needs.\u00a0<\/span><\/strong><\/em><\/p>\n<p>Content:\u00a0 <strong>All contents in the workshops are related to protocols, security, and utilization of student data.\u00a0<\/strong><\/p>\n<p>1) How many incoming URM (Underrepresented Minority) students (by name, race, ethnicity, and gender) are &#8220;requesting&#8221; Pre-STEM and STEM majors for Fall 2019 Quarter? (If time allows, we will examine specific major(s)\/department requests from the incoming students).<\/p>\n<p>2) Who are transitioning to graduate school\/professional school <span style=\"color: #ff0000;\"><strong>outside (and within)<\/strong><\/span>\u00a0UW among our UW-Seattle BA\/BS degree earners from summer 2015 to spring 2016?\u00a0 By race\/ethnicity, first-generation, pell-eligible, and gender\u00a0 (by schools and colleges, if time allows in &#8220;Safe Mode&#8221;).<br \/>\nUtilization method of National Student Clearninghouse data.<\/p>\n<p>3) From SQL &#8212;&gt; Python &#8212;&gt; to your MS Excel Spreadsheet:<br \/>\nHow data is: a) Gathered b) Organized\u00a0 c) Analyzed.<\/p>\n<p>4) Introduction to MS Excel Pivot Table and MS Access.<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">\u00a0<\/span><\/p>\n<p>5) Addressing concerns related to the &#8220;two or more races&#8221; category and Hispanic\/Latinx &#8220;override&#8221; from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of <a href=\"http:\/\/depts.washington.edu\/aromad\/maximum-representation\/\">Maximum Representation<\/a>\u00a0for Multiracial\/Multiethnic Students (<strong><span style=\"color: #ff0000;\">Upon Request<\/span><\/strong>):Concept of <a href=\"http:\/\/depts.washington.edu\/aromad\/maximum-representation\/\">Maximum Representation<\/a>\u00a0for Multiracial\/Multiethnic Students (<strong><span style=\"color: #ff0000;\">Upon Request<\/span><\/strong>).<\/p>\n<p>6) Introduction to R and Python (less emphasis than the previous session back in July 9, 2019).<\/p>\n<p>7) Introduction to\u00a0\u00a0<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><a href=\"https:\/\/uwprofiles.uw.edu\/\">UW Profiles:\u00a0 \u00a0https:\/\/uwprofiles.uw.edu\/<\/a><\/span><\/p>\n<p>8)\u00a0Only 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.<\/p>\n<p>RSVP NOT REQUIRED<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">.<\/span><\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">_______________________________________________________________________________________<\/span><\/p>\n<p><b>Data Seminar#15) Date<\/b>:\u00a0 September 9, 2019 \u202f<b>Time<\/b>:\u202f 10:00am-12:00am <b>Location<\/b>: 171E (Multi-Purpose Room) in Mary Gates Hall<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><br \/>\n<span style=\"color: #008000;\"><strong>Instructor: <a style=\"color: #008000;\" href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><\/span><\/p>\n<p><em><strong><span style=\"color: #3366ff;\">*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment\/data projects specific to their programs&#8217; needs.\u00a0<\/span><\/strong><\/em><\/p>\n<p>Content:\u00a0 <strong>All contents in the workshops are related to protocols, security, and utilization of student data.\u00a0<\/strong><\/p>\n<p>1) Who are transitioning to graduate school\/professional school <span style=\"color: #ff0000;\"><strong>outside (and within)<\/strong><\/span>\u00a0UW among our UW-Seattle BA\/BS degree earners from summer 2015 to spring 2016?\u00a0 By race\/ethnicity, first-generation, pell-eligible, and gender\u00a0 (by schools and colleges, if time allows in &#8220;Safe Mode&#8221;).<br \/>\nUtilization method of National Student Clearninghouse data.<\/p>\n<p>2) From SQL &#8212;&gt; Python &#8212;&gt; to your MS Excel Spreadsheet:<br \/>\nHow data is: a) Gathered b) Organized\u00a0 c) Analyzed.<\/p>\n<p>3) Introduction to MS Excel Pivot Table and MS Access.<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">\u00a0<\/span><\/p>\n<p>4) Addressing concerns related to the &#8220;two or more races&#8221; category and Hispanic\/Latinx &#8220;override&#8221; from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of <a href=\"http:\/\/depts.washington.edu\/aromad\/maximum-representation\/\">Maximum Representation<\/a>\u00a0for Multiracial\/Multiethnic Students (<strong><span style=\"color: #ff0000;\">last session<\/span><\/strong>).<\/p>\n<p>5) Introduction to R and Python (less emphasis than the previous session back in July 9, 2019).<\/p>\n<p>6) Introduction to\u00a0\u00a0<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><a href=\"https:\/\/uwprofiles.uw.edu\/\">UW Profiles:\u00a0 \u00a0https:\/\/uwprofiles.uw.edu\/<\/a><\/span><\/p>\n<p>7)\u00a0Only 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.<\/p>\n<p>RSVP NOT REQUIRED<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">.<\/span><\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">_______________________________________________________________________________________<\/span><\/p>\n<p><b>Data Seminar#14) Date<\/b>:\u00a0 July 29, 2019 \u202f<b>Time<\/b>:\u202f 1:00pm-2:30pm <b>Location<\/b>: 171E (Multi-Purpose Room) in Mary Gates Hall<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><br \/>\n<span style=\"color: #008000;\"><strong>Instructor: <a style=\"color: #008000;\" href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><\/span><\/p>\n<p><em><strong><span style=\"color: #3366ff;\">*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment\/data projects specific to their programs&#8217; needs.\u00a0<\/span><\/strong><\/em><\/p>\n<p>Content:\u00a0 <strong>All contents in the workshops are related to protocols, security, and utilization of student data.\u00a0<\/strong><\/p>\n<p>1) Who are transitioning to graduate school\/professional school <span style=\"color: #ff0000;\"><strong>outside<\/strong><\/span> <span style=\"color: #ff0000;\"><strong> (and within)\u00a0<\/strong><\/span>UW among our UW-Seattle BA\/BS degree earners from summer 2015 to spring 2016?\u00a0 By race\/ethnicity, first-generation, pell-eligible, and gender (by schools and colleges, if time allows in &#8220;Safe Mode&#8221;).<br \/>\nUtilization method of National Student Clearninghouse data.<\/p>\n<p>2) Introduction to MS Excel Pivot Table and MS Access.<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">\u00a0<\/span><\/p>\n<p>3) Addressing concerns related to the &#8220;two or more races&#8221; category and Hispanic\/Latinx &#8220;override&#8221; from the National Center for Education Statistics (Integrated Postsecondary Education Data System)::Concept of <a href=\"http:\/\/depts.washington.edu\/aromad\/maximum-representation\/\">Maximum Representation<\/a>\u00a0for Multiracial\/Multiethnic Students if time and equipment allows.<\/p>\n<p>4) Introduction to R and Python (less emphasis than the previous session back in July 9, 2019).<\/p>\n<p>5) Introduction to\u00a0\u00a0<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><a href=\"https:\/\/uwprofiles.uw.edu\/\">UW Profiles:\u00a0 \u00a0https:\/\/uwprofiles.uw.edu\/<\/a><\/span><\/p>\n<p>6)\u00a0EOP vs Non-EOP graduation and 1st year retention rates by ethnicity\/race and gender.<\/p>\n<p>7)\u00a0Only 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.<\/p>\n<p>RSVP NOT REQUIRED<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">.<\/span><\/p>\n<p>_________________________________________________________________________________<\/p>\n<p><b>Data Seminar#13) Date<\/b>:\u00a0 July 9, 2019 \u202f<b>Time<\/b>:\u202f 10:00am-11:30am <b>Location<\/b>: 171E (Multi-Purpose Room) in Mary Gates Hall<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><br \/>\n<span style=\"color: #008000;\"><strong>Instructor: <a style=\"color: #008000;\" href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><\/span><\/p>\n<p><em><strong><span style=\"color: #3366ff;\">*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment\/data projects specific to their programs&#8217; needs.\u00a0<\/span><\/strong><\/em><\/p>\n<p>Content:\u00a0 <strong>All contents in the workshops are related to protocols, security, and utilization of student data.\u00a0<\/strong><\/p>\n<p>1) Who are transitioning to graduate school\/professional school <span style=\"color: #ff0000;\"><strong>outside\u00a0 (and within)<\/strong><\/span> UW among our UW-Seattle BA\/BS degree earners from summer 2015 to spring 2016?\u00a0 By race\/ethnicity, first-generation, pell-eligible, and gender\u00a0 (by schools and colleges, if time allows in &#8220;Safe Mode&#8221;).<br \/>\nUtilization method of National Student Clearninghouse data.<\/p>\n<p>2) Introduction to MS Excel Pivot Table and MS Access.<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">\u00a0<\/span><\/p>\n<p>3) Addressing concerns related to the &#8220;two or more races&#8221; category and Hispanic\/Latinx &#8220;override&#8221; from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of\u00a0<a href=\"http:\/\/depts.washington.edu\/aromad\/maximum-representation\/\">Maximum Representation<\/a>\u00a0for Multiracial\/Multiethnic Students if time and equipment allows.<\/p>\n<p>4) Introduction to R and Python.<\/p>\n<p>5) Introduction to\u00a0\u00a0<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><a href=\"https:\/\/uwprofiles.uw.edu\/\">UW Profiles:\u00a0 \u00a0https:\/\/uwprofiles.uw.edu\/<\/a><\/span><\/p>\n<p>6)\u00a0EOP(OMAD) vs Non-EOP(OMAD) graduation and 1st year retention rates by ethnicity\/race and gender.<\/p>\n<p>7)\u00a0Only 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.<\/p>\n<p>RSVP NOT REQUIRED<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">.<\/span><\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">__________________________________________________________________________________________<\/span><\/p>\n<p><b>Data Seminar#12) Date<\/b>: March 12, 2019 \u202f<b>Time<\/b>:\u202f 9:30am-11:00am <b>Location<\/b>: 171E (Multi-Purpose Room) in Mary Gates Hall<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><br \/>\n<span style=\"color: #008000;\"><strong>Instructor: <a style=\"color: #008000;\" href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><\/span><\/p>\n<p><em><strong><span style=\"color: #3366ff;\">*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment\/data projects specific to their programs&#8217; needs.\u00a0<\/span><\/strong><\/em><\/p>\n<p>Content:\u00a0 <strong>All contents in the workshops are related to protocols, security, and utilization of student data.\u00a0<\/strong><\/p>\n<p>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.<\/p>\n<p>2) Addressing concerns related to the &#8220;two or more races&#8221; category and Hispanic\/Latinx &#8220;override&#8221; from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of\u00a0<a href=\"http:\/\/depts.washington.edu\/aromad\/maximum-representation\/\">Maximum Representation<\/a>\u00a0for Multiracial\/Multiethnic Students: basic application\/demonstration of R and Python (in relation to <a href=\"http:\/\/depts.washington.edu\/aromad\/maximum-representation\/\">Maximum Representation<\/a>).<\/p>\n<p>3) Introduction to MS Excel Pivot Table and MS Access.<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">\u00a0<\/span><\/p>\n<p>4)\u00a0<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><a href=\"https:\/\/uwprofiles.uw.edu\/\">UW Profiles:\u00a0https:\/\/uwprofiles.uw.edu\/<\/a><\/span><\/p>\n<p>5)\u00a0Only 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.<\/p>\n<p>RSVP NOT REQUIRED<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">__________________________________________________________________________________________<\/span><\/p>\n<p><b>Data Seminar#11) Date<\/b>: March 1, 2019 \u202f<b>Time<\/b>:\u202f 9:30am-11:00am <b>Location<\/b>: 171E (Multi-Purpose Room) in Mary Gates Hall<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><br \/>\n<span style=\"color: #008000;\"><strong>Instructor: <a style=\"color: #008000;\" href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><\/span><\/p>\n<p><em><strong><span style=\"color: #3366ff;\">*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment\/data projects specific to their programs&#8217; needs.\u00a0<\/span><\/strong><\/em><\/p>\n<p>Content:\u00a0 <strong>All contents in the workshops are related to protocols, security, and utilization of student data.\u00a0<\/strong><\/p>\n<p>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<\/p>\n<p>2) Addressing concerns related to the &#8220;two or more races&#8221; category and Hispanic\/Latinx &#8220;override&#8221; from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of\u00a0<a href=\"http:\/\/depts.washington.edu\/aromad\/maximum-representation\/\">Maximum Representation<\/a>\u00a0for Multiracial\/Multiethnic Students <span style=\"color: #ff0000;\"><strong>IF TIME PERMITS<\/strong><\/span>.<\/p>\n<p>3) Introduction to MS Excel Pivot Table and MS Access.<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">\u00a0<\/span><\/p>\n<p>4)\u00a0<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><a href=\"https:\/\/uwprofiles.uw.edu\/\">UW Profiles:\u00a0https:\/\/uwprofiles.uw.edu\/<\/a><\/span><\/p>\n<p>5) <span style=\"color: #ff0000;\"><strong>IF TIME AND EQUIPMENT PERMITS:\u00a0<\/strong><\/span>Basic R and Python demo in relation to <a href=\"http:\/\/depts.washington.edu\/aromad\/maximum-representation\/\">maximum representation data<\/a>.<\/p>\n<p>6)\u00a0Only 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.<\/p>\n<p>RSVP NOT REQUIRED<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">______________________________________________________________________________________________<\/span><\/p>\n<p><b>Data Seminar#10) Date<\/b>: January 22, 2019 \u202f<b>Time<\/b>:\u202f10:00am-11:30am <b>Location<\/b>: 171E (Multi-Purpose Room) in Mary Gates Hall<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><br \/>\n<span style=\"color: #008000;\"><strong>Instructor: <a style=\"color: #008000;\" href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><br \/>\n<\/span><\/p>\n<p><em><strong><span style=\"color: #3366ff;\">*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment\/data projects specific to their programs&#8217; needs.\u00a0<\/span><\/strong><\/em><\/p>\n<p>Content:\u00a0<strong>All contents in the workshops are related to protocols, security, and utilization of student data.\u00a0<\/strong><\/p>\n<p>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<\/p>\n<p>2) Addressing concerns related to the &#8220;two or more races&#8221; category and Hispanic\/Latinx &#8220;override&#8221; from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of\u00a0<a href=\"http:\/\/depts.washington.edu\/aromad\/maximum-representation\/\">Maximum Representation<\/a>\u00a0for Multiracial\/Multiethnic Students IF TIME PERMITS.<\/p>\n<p>3) Introduction to MS Excel Pivot Table and MS Access.<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">\u00a0<\/span>.<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">\u00a0<\/span><\/p>\n<p>4)\u00a0<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><a href=\"https:\/\/uwprofiles.uw.edu\/\">UW Profiles:\u00a0https:\/\/uwprofiles.uw.edu\/<\/a><\/span><\/p>\n<p>5)\u00a0Only 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.<\/p>\n<p>RSVP NOT REQUIRED<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">.<\/span><\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">______________________________________________________________________________________________\u00a0<\/span><\/p>\n<p><b>Data Seminar#9) Date<\/b>: January 8, 2019 \u202f<b>Time<\/b>:\u202f10:00am-11:30am\u202f\u00a0<b>Location<\/b>: 171E (Multi-Purpose Room) in Mary Gates Hall<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><br \/>\n<span style=\"color: #008000;\"><strong>Instructor: <a style=\"color: #008000;\" href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><br \/>\n<\/span><\/p>\n<p><em><strong><span style=\"color: #3366ff;\">*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment\/data projects specific to their programs&#8217; needs.\u00a0<\/span><\/strong><\/em><\/p>\n<p>Content:\u00a0<strong>All contents in the workshops are related to protocols, security, and utilization of student data.\u00a0<\/strong><\/p>\n<p>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<\/p>\n<p>2) Addressing concerns related to the &#8220;two or more races&#8221; category and Hispanic\/Latinx &#8220;override&#8221; from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of\u00a0<a href=\"http:\/\/depts.washington.edu\/aromad\/maximum-representation\/\">Maximum Representation<\/a>\u00a0for Multiracial\/Multiethnic Students IF TIME PERMITS.<\/p>\n<p>3) Introduction to MS Excel Pivot Table and MS Access.<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">\u00a0<\/span><\/p>\n<p>4)\u00a0<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><a href=\"https:\/\/uwprofiles.uw.edu\/\">UW Profiles:\u00a0https:\/\/uwprofiles.uw.edu\/<\/a><\/span><\/p>\n<p>5)\u00a0Basic RStudio demo in relation to <a href=\"http:\/\/depts.washington.edu\/aromad\/maximum-representation\/\">maximum representation data<\/a>.<\/p>\n<p>6)EOP(OMAD) vs Non-EOP (Non-OMAD) graduation and 1st year retention rates by ethnicity\/race and gender.<\/p>\n<p>7)\u00a0Only 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.<\/p>\n<p>RSVP NOT REQUIRED<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">.<\/span><\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">_______________________________________________________________________________________________\u00a0<\/span><\/p>\n<p><b>Data Seminar#8) Date<\/b>: November 29, 2018 \u202f<b>Time<\/b>:\u202f 9:30am &#8211; 10:30am\u202f\u00a0<b>Location<\/b>: 171E (Multi-Purpose Room) in Mary Gates Hall<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><br \/>\n<span style=\"color: #008000;\"><strong>Instructor: <a style=\"color: #008000;\" href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><br \/>\n<\/span><\/p>\n<p><em><strong><span style=\"color: #3366ff;\">*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment\/data projects specific to their programs&#8217; needs.\u00a0<\/span><\/strong><\/em><\/p>\n<p>Content:\u00a0<strong>All contents in the workshops are related to protocols, security, and utilization of student data.\u00a0<\/strong><\/p>\n<p>1) Spring 2018 Student Persistence Data in relation to Fall 2018 Quarter.<\/p>\n<p>2) Addressing concerns related to the &#8220;two or more races&#8221; category and Hispanic\/Latinx &#8220;override&#8221; from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of <a href=\"http:\/\/depts.washington.edu\/aromad\/maximum-representation\/\">Maximum Representation<\/a> for Multiracial\/Multiethnic Students IF TIME PERMITS.<\/p>\n<p>3) Introduction to MS Excel Pivot Table and MS Access.<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">\u00a0<\/span><\/p>\n<p>4)\u00a0<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><a href=\"https:\/\/uwprofiles.uw.edu\/\">UW Profiles:\u00a0https:\/\/uwprofiles.uw.edu\/<\/a><\/span><\/p>\n<p>5)\u00a0Only 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.<\/p>\n<p>RSVP NOT REQUIRED<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">.<\/span><\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">_______________________________________________________________________________________________\u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><b>Data Seminar#7) Date<\/b>: October 9, 2018 \u202f<b>Time<\/b>:\u202f 1:00pm &#8211; 2:30pm\u202f\u00a0<b>Location<\/b>: 171E (Multi-Purpose Room) in Mary Gates Hall<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><br \/>\n<span style=\"color: #008000;\"><strong>Instructor: <a style=\"color: #008000;\" href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><br \/>\n<\/span><\/p>\n<p><em><strong><span style=\"color: #3366ff;\">*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment\/data projects specific to their programs&#8217; needs.\u00a0<\/span><\/strong><\/em><\/p>\n<p>Content:\u00a0<strong>All contents in the workshops are related to protocols, security, and utilization of student data.\u00a0<\/strong><\/p>\n<p>1) Who becomes STEM <span style=\"color: #000080;\"><strong>undergraduate<\/strong><\/span> degree holders in <strong><span style=\"color: #ff00ff;\">UW-Seattle<\/span><\/strong>? Historical data analysis:\u00a0 <strong>Necessity of SQL, R, Python programming language<\/strong><\/p>\n<ul>\n<li>Requested STEM majors and earned STEM degrees.<\/li>\n<li>Did NOT request STEM majors but earned STEM degrees.<\/li>\n<li>Requested STEM majors and earned NON-STEM degrees.<\/li>\n<li>Did NOT request STEM majors and earned NON-STEM degrees.<\/li>\n<li>Did NOT graduate from <span style=\"color: #ff00ff;\"><strong>UW-Seattle<\/strong><\/span>.<\/li>\n<\/ul>\n<p>2) Addressing concerns related to the &#8220;two or more races&#8221; category and Hispanic\/Latinx &#8220;override&#8221; from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of <a href=\"http:\/\/depts.washington.edu\/aromad\/maximum-representation\/\">Maximum Representation<\/a> for Multiracial\/Multiethnic Students IF TIME PERMITS.<\/p>\n<p>3) Introduction to MS Excel Pivot Table and MS Access.<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">\u00a0<\/span><\/p>\n<p>4)\u00a0<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><a href=\"https:\/\/uwprofiles.uw.edu\/\">UW Profiles:\u00a0https:\/\/uwprofiles.uw.edu\/<\/a><\/span><\/p>\n<p>5)\u00a0Only 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.<\/p>\n<p>RSVP NOT REQUIRED<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">.<\/span><\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">_______________________________________________________________________________________________\u00a0<\/span><\/p>\n<p><b>Data Seminar#6) Date<\/b>: October 5, 2018 \u202f<b>Time<\/b>:\u202f 9:30am &#8211; 11:00am\u202f\u00a0<b>Location<\/b>: 171E (Multi-Purpose Room) in Mary Gates Hall<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><br \/>\n<span style=\"color: #008000;\"><strong>Instructor: <a style=\"color: #008000;\" href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><br \/>\n<\/span><\/p>\n<p><em><strong><span style=\"color: #3366ff;\">*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment\/data projects specific to their programs&#8217; needs.\u00a0<\/span><\/strong><\/em><\/p>\n<p>Content:\u00a0<strong>All contents in the workshops are related to protocols, security, and utilization of student data.\u00a0<\/strong><\/p>\n<p>1) Who becomes STEM <span style=\"color: #000080;\"><strong>undergraduate<\/strong><\/span> degree holders in <strong><span style=\"color: #ff00ff;\">UW-Seattle<\/span><\/strong>? Historical data analysis: <strong>Necessity of SQL, R, Python programming language<\/strong><\/p>\n<ul>\n<li>Requested STEM majors and earned STEM degrees.<\/li>\n<li>Did NOT request STEM majors but earned STEM degrees.<\/li>\n<li>Requested STEM majors and earned NON-STEM degrees.<\/li>\n<li>Did NOT request STEM majors and earned NON-STEM degrees.<\/li>\n<li>Did NOT graduate from <span style=\"color: #ff00ff;\"><strong>UW-Seattle<\/strong><\/span>.<\/li>\n<\/ul>\n<p>2) Addressing concerns related to the &#8220;two or more races&#8221; category and Hispanic\/Latinx &#8220;override&#8221; from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of <a href=\"http:\/\/depts.washington.edu\/aromad\/maximum-representation\/\">Maximum Representation<\/a> for Multiracial\/Multiethnic Students IF TIME PERMITS.<\/p>\n<p>3) Introduction to MS Excel Pivot Table and MS Access.<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">\u00a0<\/span><\/p>\n<p>4)\u00a0<a href=\"https:\/\/uwprofiles.uw.edu\/\">UW Profiles:\u00a0https:\/\/uwprofiles.uw.edu\/<\/a><\/p>\n<p>5)\u00a0Only 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.<\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">_______________________________________________________________________________________________\u00a0<\/span><\/p>\n<p><b>Data Seminar#5) Date<\/b>: September 7, 2018\u202f \u202f<b>Time<\/b>:\u202f 10:00am-11:45am\u202f\u00a0<b>Location<\/b>: 171E (Multi-Purpose Room) in Mary Gates Hall<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><br \/>\n<span style=\"color: #008000;\"><strong>Instructor: <a style=\"color: #008000;\" href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><br \/>\n<\/span><\/p>\n<p><em><strong><span style=\"color: #3366ff;\">*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment\/data projects specific to their programs&#8217; needs.\u00a0<\/span><\/strong><\/em><\/p>\n<p>Content:\u00a0<strong>All contents in the workshops are related to protocols, security, and utilization of student data.\u00a0<\/strong><\/p>\n<p>1) Addressing concerns related to the &#8220;two or more races&#8221; category and Hispanic\/Latinx &#8220;override&#8221; from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of <a href=\"http:\/\/depts.washington.edu\/aromad\/maximum-representation\/\">Maximum Representation<\/a> for Multiracial\/Multiethnic Students.\u00a0 <strong>Necessity of SQL, R, Python programming language<\/strong><\/p>\n<p>2) Introduction to MS Excel Pivot Table and MS Access.<\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">3) <a href=\"https:\/\/uwprofiles.uw.edu\/\">UW Profiles:\u00a0https:\/\/uwprofiles.uw.edu\/<\/a><br \/>\n<\/span><\/p>\n<p>4)\u00a0Only 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.<\/p>\n<p>RSVP NOT REQUIRED<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">.<\/span><\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">_______________________________________________________________________________________________\u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><b>Data Seminar#4) Date<\/b>: August 10, 2018\u202f \u202f<b>Time<\/b>:\u202f 10:00am-11:30am\u202f\u00a0<b>Location<\/b>: 171E (Multi-Purpose Room) in Mary Gates Hall<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><br \/>\n<span style=\"color: #008000;\"><strong>Instructor: <a style=\"color: #008000;\" href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><br \/>\n<\/span><\/p>\n<p><em><strong><span style=\"color: #3366ff;\">*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment\/data projects specific to their programs&#8217; needs.\u00a0<\/span><\/strong><\/em><\/p>\n<p>Content:\u00a0<strong>All contents in the workshops are related to protocols, security, and utilization of student data.\u00a0<\/strong><\/p>\n<p>1) Addressing concerns related to the &#8220;two or more races&#8221; category and Hispanic\/Latinx &#8220;override&#8221; from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of <a href=\"http:\/\/depts.washington.edu\/aromad\/maximum-representation\/\">Maximum Representation<\/a> for Multiracial\/Multiethnic Students.\u00a0 <strong>Necessity of SQL, R, Python programming language<\/strong><\/p>\n<p>2) Introduction to MS Excel Pivot Table and MS Access.<\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">3) <a href=\"https:\/\/uwprofiles.uw.edu\/\">UW Profiles:\u00a0https:\/\/uwprofiles.uw.edu\/<\/a><br \/>\n<\/span><\/p>\n<p>4)\u00a0Only 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.<\/p>\n<p>RSVP: CLOSED<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">.<\/span><\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">_______________________________________________________________________________________________\u00a0<\/span><\/p>\n<p><b>Data Seminar#3) Date<\/b>: August 6, 2018\u202f \u202f<b>Time<\/b>:\u202f 2:00pm-3:30pm\u202f\u00a0<b>Location<\/b>: 171E (Multi-Purpose Room) in Mary Gates Hall<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><br \/>\n<span style=\"color: #008000;\"><strong>Instructor: <a style=\"color: #008000;\" href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><br \/>\n<\/span><\/p>\n<p><em><strong><span style=\"color: #3366ff;\">*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment\/data projects specific to their programs&#8217; needs.\u00a0<\/span><\/strong><\/em><\/p>\n<p>Content:\u00a0<strong>All contents in the workshops are related to protocols, security, and utilization of student data.\u00a0<\/strong><\/p>\n<p>1) Addressing concerns related to the &#8220;two or more races&#8221; category and Hispanic\/Latinx &#8220;override&#8221; from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of <a href=\"http:\/\/depts.washington.edu\/aromad\/maximum-representation\/\">Maximum Representation<\/a> for Multiracial\/Multiethnic Students.\u00a0 <strong>Necessity of SQL, R, Python programming language<\/strong><\/p>\n<p>2) Introduction to MS Excel Pivot Table and MS Access.<br \/>\n<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><br \/>\n3) <a href=\"https:\/\/uwprofiles.uw.edu\/\">UW Profiles:\u00a0https:\/\/uwprofiles.uw.edu\/<\/a><br \/>\n<\/span><\/p>\n<p>4)\u00a0EOP vs Non-EOP graduation and 1st year retention rates by ethnicity\/race and gender.<\/p>\n<p>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.<\/p>\n<p>RSVP: CLOSED<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">.<\/span><\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">_______________________________________________________________________________________________\u00a0<\/span><\/p>\n<p><b>Data Seminar#2) Date<\/b>: July 12, 2018\u202f \u202f<b>Time<\/b>:\u202f 1:30pm-3:00pm\u00a0<b>Location<\/b>: 171E (Multi-Purpose Room) in Mary Gates Hall<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><br \/>\n<span style=\"color: #008000;\"><strong>Instructor: <a style=\"color: #008000;\" href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><br \/>\n<\/span><\/p>\n<p><em><strong><span style=\"color: #3366ff;\">*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment\/data projects specific to their programs&#8217; needs.\u00a0<\/span><\/strong><\/em><\/p>\n<p>Content:\u00a0<strong>All contents in the workshops are related to protocols, security, and utilization of student data.\u00a0<\/strong><\/p>\n<p>1) Addressing concerns related to the &#8220;two or more races&#8221; category and Hispanic\/Latinx &#8220;override&#8221; from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of <a href=\"http:\/\/depts.washington.edu\/aromad\/maximum-representation\/\">Maximum Representation<\/a> for Multiracial\/Multiethnic Students. <strong>Necessity of SQL, R, Python programming language<\/strong><\/p>\n<p>2) Introduction to MS Excel Pivot Table and MS Access.<\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">3) <a href=\"https:\/\/uwprofiles.uw.edu\/\">UW Profiles:\u00a0https:\/\/uwprofiles.uw.edu\/<\/a><br \/>\n<\/span><\/p>\n<p>4) EOP vs Non-EOP graduation and 1st year retention rates by ethnicity\/race and gender.<\/p>\n<p>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.<\/p>\n<p>&nbsp;<\/p>\n<p>RSVP: CLOSED.<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">\u00a0<\/span><\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">_______________________________________________________________________________________________\u00a0<\/span><\/p>\n<p><b>Data Seminar#1) Date:<\/b>\u00a0July 11, 2018\u202f \u202f<b>Time<\/b>:\u202f 1:00pm-2:30pm\u00a0<b>Location<\/b>: 171E (Multi-Purpose Room) in Mary Gates Hall<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\"><br \/>\n<span style=\"color: #008000;\"><strong>Instructor: <a style=\"color: #008000;\" href=\"http:\/\/depts.washington.edu\/aromad\/gene\/\">Gene Kim<\/a><\/strong><\/span><br \/>\n<\/span><\/p>\n<p><em><strong><span style=\"color: #3366ff;\">*****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.\u00a0 OMAD staff members are also welcome to make an appointment via aromad@uw.edu to request assessment\/data projects specific to their programs&#8217; needs.\u00a0<\/span><\/strong><\/em><\/p>\n<p>Content:\u00a0<strong>All contents in the workshops are related to protocols, security, and utilization of student data.\u00a0<\/strong><\/p>\n<p>1) Addressing concerns related to the &#8220;two or more races&#8221; category and Hispanic\/Latinx &#8220;override&#8221; from the National Center for Education Statistics (Integrated Postsecondary Education Data System):Concept of <a href=\"http:\/\/depts.washington.edu\/aromad\/maximum-representation\/\">Maximum Representation<\/a> for Multiracial\/Multiethnic Students. <strong>Necessity of SQL, R, Python programming language<\/strong><\/p>\n<p>2) Introduction to MS Excel Pivot Table and MS Access.<\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">3) <a href=\"https:\/\/uwprofiles.uw.edu\/\">UW Profiles:\u00a0https:\/\/uwprofiles.uw.edu\/<\/a><br \/>\n<\/span><\/p>\n<p>4)\u00a0Only 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.<\/p>\n<p>RSVP: CLOSED.<span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">\u00a0<\/span><\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:2,&quot;335559739&quot;:218,&quot;335559740&quot;:439}\">_______________________________________________________________________________________________\u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>3 Campus Wide Data Workshops are opened to all University of Washington staff members in all 3 campuses in most cases, WHO ARE AUTHORIZED TO EXAMINE AND WORK WITH FERPA (The Family Educational Rights and Privacy Act of 1974) PROTECTED STUDENT DATA.\u00a0 We will NOT be involved in specific data\/project requests outside OMAD.\u00a0\u00a0 What is&#8230;<\/p>\n<div><a class=\"more\" href=\"http:\/\/depts.washington.edu\/aromad\/data-workshops\/\">Read more<\/a><\/div>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-218","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/depts.washington.edu\/aromad\/wp-json\/wp\/v2\/pages\/218","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/depts.washington.edu\/aromad\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/depts.washington.edu\/aromad\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/depts.washington.edu\/aromad\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/depts.washington.edu\/aromad\/wp-json\/wp\/v2\/comments?post=218"}],"version-history":[{"count":203,"href":"http:\/\/depts.washington.edu\/aromad\/wp-json\/wp\/v2\/pages\/218\/revisions"}],"predecessor-version":[{"id":1166,"href":"http:\/\/depts.washington.edu\/aromad\/wp-json\/wp\/v2\/pages\/218\/revisions\/1166"}],"wp:attachment":[{"href":"http:\/\/depts.washington.edu\/aromad\/wp-json\/wp\/v2\/media?parent=218"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}