Overview

Background

The Scientia Enterprise applications are the University's chosen application suite for providing a shared academic Timetabling service. The Scientia applications also provide an ad-hoc Room booking service for Staff and Students via Web Room Booking.

The Scientia applications work on a separate database for each academic year. Each year, there are therefore tasks to create the new database and instances of each application for the next academic year. The roll-forward tasks take place in stages at appropriate times in the calendar and the applications are then re-pointed at the switch-over. For the 2019/20 academic year, this switch-over for LIVE feeds was brought forward to the 3rd week in July 2019.

The start of the new Timetabling year in 2020/21 will be Mon 20-July 2020

This is compliance work that is too large to be delivered within the current support budget and is therefore run as a project each year.

 

Scope

The scope of this project is restricted to the tasks required to roll forward the timetabling and room booking applications for use for the 2020-21 Academic Year. The roll forward tasks are as documented on the Wiki and include any decommissioning tasks.

This year, there are additional tasks for the first roll-forward for the new Lecture Capture feed from Timetabling to the Lecture Capture system.

The following  are not in the scope of this project:

  • Decommissioning of 18/19 database as this is required for historic reporting
  • Remedial or enhancement work to resolve existing issues unrelated to the roll-forward project
  • Investigation or resolution of existing  LIVE production infrastructure issues 

 

Objectives 

The key objective for the project is to deliver the roll forward to allow activities (lectures, tutorials, labs, other misc classes) and rooms to be scheduled and allocation carried out for the new academic year.

Deliverables

The following deliverables have been identified for completion of the roll forward

Ref Deliverables Must Have/Should Have/Could Have
D1

Core timetabling applications  - Roll-forward

  • Syllabus Plus Database (SDB) including Authorisation Manager database
  • Reporting Database (RDB) connected to 20-21 SDB
  • Enterprise Portal and Applications (inc. Script for populating UTF5 and Roles enabled for 20-21)
Must Have
D2

Deliver web applications  - Roll-forward

  • Staff Web Room Booking (WRB)
  • Student WRB (inc. Script for releasing the next available week for student bookings)
  • WRB Notifier
  • Web Timetables (inc. connector to RDB for reference data)
  • Onelan
  • PADS
  • RDB preparation for producing CTB, Bookable Rooms and Learn Feeds
  • Data Adaptor for Resource Booker ( as used by the Medical School)
Must Have
D3

Decommissioning tasks - 17/18;SDB / RDB & Web apps / 18-19;RDB & Web Apps

  • Decommission 17/18 SDB, RDB and 17/18 Web Apps
  • Decommission 18/19 RDB and 18/19 Web Apps
Must Have
D4

Deliver incoming interfaces 

  • Incoming interfaces and Syllabus Plus Data Adaptor (SPDA) (inc. Rollforward package for Academic rollover and initial loads)
  • SPDA 
Must Have
D5

Deliver Course Timetable Browser 

  • Course timetable browser repointed to 20-21
Must Have
D6

Bookable Rooms Website

  • Feed to the Bookable Rooms Website repointed to 20-21
Must Have
D7

Learn Feed

  • Outgoing Learn feed re-directed to 20-21 database
Must Have
D8

Lecture Capture Feed

  • Feed to the Lecture Capture System repointed to 20-21
Must Have
D8

Reporting

  • Repoint BI universe to 20-21 RDB
Must Have
D9

CalSync

  • Office 365 calendars integration to be repointed to 20-21
Must Have
D10 

Switchover academic year in July and service wrap

  • Repointable URL changed to re-direct Web Applications to 20-21
  • 20-21 OneLan, PADS, Student WRB
Must Have

Benefits

This is a compliance project, and  will allow 2020-21 Timetabling planning to occur from March 2020, and allow the Timetabling service to continue into the new academic year, 2020-21.

 

Success Criteria

The following criteria will confirm the project has been successful in each of its objectives:

  • UOE2021 SDB available in Scientia Enterprise by  Jan 2020
  • 20/21 Web Applications available by 31st January 2020
  • In April 2020, incoming interfaces will start to populate 20-21  with data from IDM and EUGEX
  • Course Timetable Browser, Bookable rooms, Calsync process, Learn outgoing interface, Lecture Capture feed and the BI Suite will be switched to point at 20-21 RDB at dates to be agreed with the business.
  • From July 2020, all Web Applications will, by default, display/refer to  2020-21 as the current academic year when accessed by any user in the University.

Project Milestones

 

Stage Milestone Due Date
Execute        Deliver new 20-21 database in Enterprise Timetabler                                                                                                                                                09-Dec-2019
Plan End of planning 12-Dec-2019
Deliver Deliver 20-21 Medical School Resource Booker 16-Dec-2019
Deliver Deliver 20-21 database for the Web applications ( WRB and Web Timetables) 27-Jan-2020
Deliver Roll-forward Incoming Interfaces to 20-21 - go-live 22-Apr-2020
Deliver Roll-forward Bookable Rooms feed to 20-21 - go-live 10-Jun-2020
Deliver Roll-forward Course Table Browser to 20-21 - Go-live 22-Jun-2020
Deliver Roll-forward BI Reports to 20-21 - Go-Live 08-Jul-2020
Deliver Roll-forward Calsync feed to 20-21 - Go-Live 15-Jul-2020
Deliver Roll-forward Learn Feed to 20-21 - Go-Live 15-Jul-2020
Deliver Roll-forward Lecture Capture Feed to 20-21 - Go-Live 20-Jul-2020
Deliver Roll-forward to 20/21 Academic Year - all live feeds - Onelan etc at start of new 20-21 session 22-Jul-2020
Deliver Roll-forward Medical School Resource Booker 22-Jul-2020
Deliver Deployment Review 28-Sep-2020
Close Project Closure 26-Oct-2020

 

Project Info

Project
Timetabling Service - Scientia Enterprise Timetabler Annual re-build & Rollforward
Code
TTU020
Programme
Timetabling (TTU)
Management Office
ISG PMO
Project Manager
Ken Miller
Project Sponsor
Scott Rosie
Current Stage
Initiate
Status
In Progress
Project Classification
Run
Start Date
04-Oct-2019
Planning Date
25-Oct-2019
Delivery Date
20-Jul-2020
Close Date
30-Oct-2020
Programme Priority
1
Overall Priority
Highest
Category
Compliance

Documentation

Plan