News

5/8/2017 – 5/19/2017

Work Complete 

Courses

• Instructor activity report shows courses taught by specific teaching staff over user adjustable period of time (existing report was locked to current and next academic year).
• Moved Associate Dean list to a central shared system. This configuration data had been repeated in a couple places making updates time consuming.

File Store

• Created a password protected file store for hosting report files that are only accessible to COE faculty and staff.

Student

• Modify search so results include students who only have registrations for future quarters.
• Investigate issue where preferred name was not being imported.
• Adjusted layout so search bar and top of page is not obscured when the menu header changes height due to menu wrapping.
• Tools for bulk data entry of PESB (WA state) required data for teach placements.
• Added instructions for change advisor on student advisor history page and on faculty page.
• Added ability to enter & display placements by academic year. The period type is configured per placement type.
• System now ends faculty role on doctoral committees after the quarter the student completed a doctoral degree.
• Added form for administrative staff to manually end doctoral committees.
• Added doctoral committee history view to faculty advisor pages. This surfaces data that is included on the merit report.
• Added MEd credits requirement for "45 overall credits"

Person

• Fixed person with authorizations in retired STEP database still listed in Auth Audit report.

4/24/2017 – 5/5/2017

Work Complete

Student

• Manually add non College of Education students to the student database when COE processes WA certification for students from other units. These students appear in search and cohort lists, but not in other areas of the system. They have a limited student detail page.
• Import ethnic data from UW SDB for external students.
• Import for OSPI institution data (WA state schools).
• Import for OSPI career data (WA state teacher and administrators).
• Add issued_year and report_year fields to Certification table to support required state reporting.
• Add career report by cohort view. Shows all students in a given cohort and their most recent career placement record.

4/10/17 – 4/21/17

Work Complete

Appreview

• Added safety on email Send button to prevent double sending.
• Reworked email batch workflows to give each item a distinct URL. This prevents unexpected behavior when using the back button during email batch.

Courses

• Updated to get Doctoral Committee history from Student database web service.

Person

• User interface for authorizing users in Person database (previously updated directly in database).

Student

• Configuration load routine that updates student sets is now the same routine that updates college programs. This prevents compiled set table from getting out of sync with the actual college programs.
• Provide Doctoral Committee data as a web service. Support merit report in Courses.
• UW Ethnicity data for College of Education students now imported into Student database nightly.
• Moved the placements by cohort report to the menu in the cohort student list view. This matches the other cohort based reports (certification, edTPA). All of these view were made more consistent.

Test Scores

• Work on Pass/Fail for all test scores. Requirements document for rules and strategies to assign Pass/Fail to all test scores in system.

3/27/17 – 4/7/17

Work Complete

Courses

• Updated faculty merit report to get advising history from new Student database.
• Add Course (e.g. recurring curriculum) to nightly batch updates from the UW Student Web Service.
• Add fill UW Term data (quarter start, end dates) to nightly update process.
• System now generates offerings required by repetition rules each night.
• All system updates original run quarterly have been optimized and moved to the nightly update system. Quarterly update code is deleted from the project.
• Budget change report can be downloaded as a CSV spreadsheet.
• Research Associate Dean section added to the course load report.
• Faculty activity report accessible by Academic Support Team.
• About page updates to attachments, policy statements, and course program & faculty affiliation.

Student

• Added Completed Advisees list to faculty page. This list can also be downloaded as a CSV spreadsheet.
• Faculty advising history web service. This provides data to faculty merit report view in Courses system while keeping domain logic around faculty advising history in the Student system.
• Fixed issue where tracked issues were not created for students that had "Expected" complete records.
• Modified the quarterly batch transcript update to not process credit counts. Credit counts require the full transcript history. Credit counts are refreshed from full transcript, per student, when a use expands the credits section on the student detail. Changed the –again argument on this batch to override "fresh cache" as well as "quarter processed" conditions.
• Quarterly batch transcript update will use an EDW/SDB connection, when available, to query what is the latest quarter with grade data posted.
• Simplified the report filters on Tracked Issue report. The previous filters were unclear and generated unexpected results.
• Deleted empty cohort groups. Changed L4L cohort configuration to every 3 years.
• Group names in header on a specific student's detail page are now links to view the entire group.
• Nightly student data load from EDW/SDB will search for new COE student majors nightly.
• Course need report added. This report uses course milestone configuration to provide a list of students who need to complete a specific course.
• Added list of students who have multiple advisors in the current quarter. Resource for cleaning up advisor history records.
• Fixed system loses ability to query UW Student Web Service (SWS) when student is assigned a new RegID identifier. When our system receives a Not Found error it will automatically check for a change in RegID and re-run requested query.
• Repeat button on edit Placement form creates a copy of placement record with same mentors.

Infrastructure

• The system context menu (top right, lists all COE information systems for switching) now includes link to "College Reports". This is an index of PDF documents and Tableau reports located in the COEIR blog.

3/13/2017 – 3/24/2017

Work Complete

Appreview

• Add application creation by staff for ECFS transfer students. These students will apply to UW via College Net and ECFS staff will receive email notification of application. We wanted to remove the second step for applicants, but still have all applications reviewable in one place.
• Show faculty which admitted students are coming. New report for Applicant Intent and dashboard cards also display intent message.

Courses

• Refined table sorting for columns with academic quarter values.
• New permission sets for editing course-release data. This allows Associate Deans to delete course-releases.
• Duplicate button on course-releases to continue same policy for following academic years.
• Update process now includes offerings with "suspended" status in UW Time Schedule. Some offerings were incorrectly being displayed as canceled in the courses database.
• Course plan is final on 11th day of quarter. This means offerings will be locked from edits and fully update from UW Time Schedule. Previously this would happen after quarter ended. Any offerings in plan that are not in the UW Time Schedule will also be canceled on 11th day.

Grants

• Grants data moved to a "grants" database, extracted from STEP student data.

Person

• Refactor person update to separate out update processes into logical code components. The person update rules had grown over time to the point where they were no longer clearly readable in the code.
• Add automated testing to the person update service.
• Extend the person update service to provide a matching strategy on first name + last name + birthdate. This strategy will be used for ECFS application entry.

Student 

• Report of issued Washington certificates by UW academic year.
• Certificate checklist report provides overview of certification process for a specific cohort.
• Student number zero padded in student detail header.
• Report of students who should have faculty academic advisor and do not.
• Advising end quarters are set when degree complete records are imported from the UW SDB.

Test Scores

• CBEST test scores converted to 3 separate subject matter scores. This allows CBEST scores to be configured as evidence of Basic Skills Proficiency for state certification.

2/20/17 – 3/3/17

Work Complete

Courses

• Log for instructor change. This will support fiscal reporting.
• Repetition rules now only fill A/B term for summer quarter course offerings.

Person

• Updated authorization views for Student 2 launch and STEP retirement.

Recruitment

• RSVP heading size reduced for tablet / phone screens.
• Added timezone to event metadata to support traveling attendees.

Student

• Fixed student status display on table views to be clearer and consistent with header on student detail.
• Add Certificate / Endorsement form that matches existing STEP workflow.
• On-leave report has export to CSV spreadsheet implemented.
• On-leave report now includes graduate students with UW status last quarter (either enrolled or on-leave) who do not have status this quarter.
• On-leave import only generates leave records up to one year in future. SDB data (possibly erroneous) has some students on-leave for several years from now.
• Rebuild of on-leave load from SDB. Previous process tried to use on-leave information from enrollment query, but missed records where the student has been on-leave for several quarters. Refactor of student data load reorganized tasks into more logical, manageable segments.
• General users have been removed from STEP.
• Tested and implemented strategy for removing withdrawn students from faculty advisee lists. These students will be removed by setting advising end quarters for the last quarter student was enrolled.
• Milestone report removed from menu. This report had unclear meaning and data update issues. We will regroup and clarify requirements with business owners.
• Doctoral credits progress bar fixed to include course levels 400 and above.
• Added credits progress bars for Masters credits.
• L4L cohort configuration changed to new cohort every 3 years.
• Certificate and Endorsement view is updated to display when endorsements belong to a specific Certificate. Orphan Endorsements can still be added (as expected endorsements) and these are listed individually at the bottom of the Certificate / Endorsement list.
• Final sync of WA state OSPI Certificate Numbers from STEP to Student 2.

2/6/2017 – 2/17/2017

Work Complete

Recruitment

• Reworked group index to display only recent active groups by default with optional access to "archived" groups. Make group views more accessible by eliminating cruft. Added more metadata data about groups to the index view so origin of groups is clearer.
• RSVP feature display refined further. Make event info page clear on various screen sizes.

Student

• Tool to delete placement records.
• Transcript reversed order, most recent quarters display at top.
• Mentor payment report.
• edTPA score report available by TEP cohort.
• In-State / Out-of-State indicated in student contact information on detail page.
• Teacher Certification checklist view. Tool for certification manager to record completed steps in applying for Washington state teacher certification. Brings in relevant test score data. Ability to check items complete and optionally upload attachment evidence.

1/23/2017 – 2/3/2017

New Student database is officially launched. Old STEP database is still available for reference, but will no longer be updated. Links to Student database are updated to new system and STEP has a retired message on the front page.

Work Complete

Student

• Teacher certificate view on student detail.
• Milestones for ECO program.
• Optimized the "latest" quarter major and fixed this so it would be limited to the current quarter or earlier. When a future quarter has upcoming registration data it will not become the latest quarter enrolled.
• Cohort rules built and displayed under Settings menu.
• STEP sync task only syncs cohort membership. Cohort configuration now owned by Student 2.
• System to populate cohorts based on cohort configuration.
• Fixed problem where advisor with no start date in STEP were added multiple times.
• Can rename cohorts from menu on cohort student list view.
• Institution reports shows institutions with COE placements for a specific quarter.
• Links on college website and context menu updated to point to Student 2. About pages and STEP home page updated to indicate STEP retired and Student database is system of record.
• Edit tool for student career and alumni emails.
• Edit tools for mentor list.

Recruitment

• Convert "About Yourself" (half sheet) form to new college website template.
• Ethnicity selector in bulk email tool.
• Log RSVP events to prospect activity log.
• Opt in language on RSVP form.
• Added hero images to RSVP form.

Test Scores

• Relinked test score requirements configuration to Certificate and Endorsement data in Student 2 database. (Previously referred to STEP)

1/9/2017 – 1/20/2017

More work on Student 2 this cycle. Planning on a rollout meeting Thursday, Feb 2.

Work Complete

Appreview

• New rubric form prompts for program category. This value is used to organize rubric list on "Enter Scores" page.
• Make sure tally runs in all rubric creation workflows. Found a bug where creating a new rubric as copy of last year and not changing anything creates rubric in incomplete state.
• Fixed "Enter Scores" page was not respecting lock, it was showing rubrics that were still under construction.

Student 2

• Access control updated for placement tools.
• Moved Tracked Issues into requirement sets. This allows Tracked Issue creation rules to vary by degree & program.
• Configured Tracked Issues for undergraduate programs with different low grade, low GPA threshold.
• Added ECFS expected courses as Milestones.
• Added student number to standard student header.
• Import UW applied to graduate data and displayed in Student 2.
• Staff can add expect to graduate (in X quarter) to a student record.
• Display UW total credits including transfer credits and official cumulative GPA.
• Tracked issue rules for undergraduate based on cumulative GPA.
• Teaching Certificates data model and import process to bring existing data over from STEP.

Techsupport

• Fix for email message ingestion crashing with large email messages.