Skip to content

Summer Quarter – Cycle 17 & 18

08/31/2015 — 09/11/2015

We merged cycles 17 & 18 into a super cycle. Paul had vacation so it was shortened. Additionally we were working on Test Score repository which ended up being a very fluid (figure out the requirements as we built it) kind of project. We have a the functional base of test score repository working that will support our reporting process for PESB (Washington State Professional Educator Standards Board).

Work Complete

Courses

  • Report of all courses with any tags and a list of all the tags each course has

Students

  • Fixed a problem with import of initial advisors from Applicant Review. Added this as an automated job.
  • Corrected endorsement addition certificate type
  • More readable view of doctoral supervisory committees. Separate view of reading committee.
  • Added longitude and latitude to placement institutions in STEP to support visualizations of teacher placements in Tableau.

Recruitment

  • Tool to import a spreadsheet of prospective students into recruitment database (eg. sign up sheets from events and info sessions, shared data from other organizations).

Test Scores

  • Imported all available test score data including WEST-B, WEST-E, NES, ACTFL, Praxis, and edTPA from data files provided by testing agencies and ACT and SAT from UW test score data.
  • Provide summary counts of test scores in system by type along with percentage that have been matched to college person records.
  • Use SDB system key in test score import fields to match test scores to person records
  • Search for test scores by person. Searches college person records (students & applicants) and also person information found in test score import files.
  • Test score detail view
  • Forms to add test scores to system. Forms for each test score type that provides custom fields appropriate to that test score.
  • Created a user interface for defining certificate and endorsement requirement rules and defining evidence rules which specify the test scores that satisfy requirements.
  • Provided SQL queries so evidence for PESB reporting can be extracted from database.

Infrastructure

  • Migrated this blog from UW Blog Network to College of Education center/dept server

Work Planned

Test Scores

  • Import all files in Google Drive sample files, review import code for ongoing usage
  • Import SAT and ACT from UW data
  • UI to create Requirements, Requirement Rules, and Evidence Rules

Summer Quarter – Cycle 16

08/17/2015 — 08/28/2015

Work Complete

Appreview Plus

  • Page titles (in Appreview Plus and in Budgets and Person)
  • Recently viewed in application menu
  • Application deadlines
  • Display application review committee. Tools to set recommendation and scholarship
  • Tool to add a comment
  • Faculty dashboard view – set up and first couple elements, more to come
  • Academic Support Team tools for set final decision and set advisor
  • Report system with parameters (Report object query the database for related data to display on web pages and have parameters that can be adjusted for context or by the user)

Courses

  • Allow course numbers to be reused over time. Review system for any place where curriculum abbreviation and course number are assumed to identify a course and include effective year and quarter. Put in back-log for other work
  • GUI to set the update through quarter, start UW Time Schedule update process, and provide info about who changed setting and if update is currently running.
  • Further refinements to application configuration system that incorporates database settings

Grants

  • Improve grant data import process to prioritize “Principal Investigator” over other grant roles.

Students

  • Refine PESB placement editing tools for actual work flows. Decided to change this from a “defaults” tool to a bulk edit tool.
  • Placement tool that creates or edits a placement record for each student in a cohort.

Test Scores

  • Sync student data from STEP to Person database
  • Modify update process to match existing test score records and not insert duplicates
  • Build person matching routine that compares person data from import files to students and applicants in our system are relates test scores to the correct people
  • Plan Requirement entities and rules for automatically applying Evidence to Requirements.

Work Planned

Appreview Plus

  • Page titles
  • Recently viewed in application menu
  • Application deadlines
  • Set recommendation and scholarship
  • Faculty dashboard view
  • Academic Support Team tools for set final decision and set advisor
  • OSS workflow tools for needs decision and needs update in MyGrad

Courses

  • Report of all courses with any tag and list of all tags those courses have
  • Allow course numbers to be reused over time. Review system for any place where curriculum abbreviation and course number are assumed to identify a course and include effective year and quarter.
  • GUI to set the update through quarter, start UW Time Schedule update process, and provide info about who changed setting and if update is currently running.
  • Further refinements to application configuration system that incorporates database settings

Test Scores

  • Sync student data from STEP to Person database
  • Modify update process to match existing test score records and not insert duplicates
  • Build person matching routine that compares person data from import files to students and applicants in our system are relates test scores to the correct people
  • Plan Requirement entities and rules for automatically applying Evidence to Requirements.

Summer Quarter – Cycle 15

08/03/2015 — 08/14/2015

Work Complete

Appreview Plus

  • Map out full transition from SOARS to Appreview Plus with timeline
  • Show attachments and make them downloadable
  • Add comments pane to application detail and add comment tool
  • Tool to edit deadlines when rules based deadlines are wrong
  • Fixed application degree dates display

Courses

  • Change division configuration for new Associate Dean
  • Fix parameter header for Courses by ROU report
  • Remove reference to comments “under construction” in offering detail About tab

Grants

  • Fixed proposal download did not include the same records as proposal HTML report

Students

  • Automated update. SME readable documentation (flow chart?) shows where data comes from and how statuses are decided.
  • Update pre 2014 Field Placement PESB data with required hours, weeks, and placement type information
  • Fix PESB default table year-qtr sorting function
  • Add link to edit placement institutions tool

Test Scores

  • Build test score repository in database tables
  • Build import process for existing test score spreadsheets

Work Planned

  • Appreview Plus
  • Courses
  • Grants
  • Students
  • Test Scores