250 likes | 486 Views
Selkirk College. Management Information Systems. Management Information Systems (MIS). Project Overview Why? Scope Project Objectives Partners in Development Timeframe Upcoming Projects Questions?. Management Information Systems (MIS). Why? Cost/Benefit analysis Fragmented systems
E N D
Selkirk College Management Information Systems
Management Information Systems (MIS) • Project Overview • Why? • Scope • Project Objectives • Partners in Development • Timeframe • Upcoming Projects • Questions?
Management Information Systems (MIS) • Why? • Cost/Benefit analysis • Fragmented systems • No local expertise • President’s Goals & Objectives • To establish effective College Student Information Systems • Strategic Directions Framework • Learner Support Services • Selkirk College’s student information systems will undergo review and development
Student Records System (SRS) Financial System (FRS) Data Warehouse MIS Development Human Resources System Budget Development MIS Project Scope
Management Information Systems (MIS) • Objectives (original) • Gain increased local control of systems • Increase effectiveness of systems • Move from Colleague to upgraded FRS • Implement on-line (Web) registration • Implement Post Secondary Data Warehouse • Make Oracle the preferred application back-end • Additions • Migrate existing data extracts and reports to be sourced from the data warehouse • Human Resources • Budget development
Human Resources Staff Finance Staff Admissions. Records & Registrar Computer Services & Institutional Research Staff Budget Development Project Partners
MIS Development Timeframes System FRS SRS Data Warehouse Financial Aid Human Resources April 2001 November 2001 June 2002 November 2002 June 2003
MIS DevelopmentHardware & Software Installation System • Purchased and installed new DEC Alpha • Purchased and installed Oracle • Installed FRS software
MIS DevelopmentImplemented FRS on the DEC Alpha • Customized screens • Developed budget officer reporting using Oracle • Added fields to vendor file for Student ID and SIN • Converted cheque printing to laser format • Developed month & year end user reports using Oracle System FRS
Moved SRS from old VAX to new Alpha Installed and configured Apache web server Implemented SRS web registration Developed on-line timetable & exam schedules, class lists, transcripts and grade entry Pilot and “Go Live” MIS Development Timeframes System FRS SRS
Mandatory compliance $50,000 grant funding Final phase of implementers Exceeded data quality standards Minimal working notice provided $10,000 grant funding Exceeded data quality standards MIS Development Data Warehouse System FRS SRS Data Warehouse
Ministry Student Data Warehouse Data Selkirk Student Data Warehouse Data Selkirk MIS Tables & Data Transformation Area SRS Student, Course & Program Data Oracle
MIS Development Timeframes • Implement software purchased in the previous year • Upload basic data elements from payroll data • Populate required tables, develop standard reports and convert benefit administration System FRS SRS Data Warehouse Human Resources
Upcoming SRS Projects • Top Priority* • Work with School Chairs to make on-line registration available for all students • On-line document scanning and storage • Provide on-line student access to T2202A tax forms • Develop reports to meet Ministry Performance Measures requirements • Data support for enrolment management process • In-house Oracle training
Upcoming SRS Projects • Second Priority • Convert SRS to Oracle • Campus laser receipt printing • On-line registration enhancements • E-Payment
Upcoming FRS Projects • Accounts Receivable processing • Automate refund processing • Move report generation from paper to web-based reports • Fee distribution from e-payment options • Web access for inquiry users
Upcoming Data Warehouse Projects • PEN extract • New reports by last high school attended • Web based reporting • Continue conversion of Audited FTE Report • Continue conversion of reports