within reach – beyond imagination selkirk college management information systems
TRANSCRIPT
WITHIN REACH – BEYOND IMAGINATION
Selkirk College
Management Information Systems
WITHIN REACH – BEYOND IMAGINATION
Management Information Systems (MIS)
Project Overview• Why?• Scope• Project Objectives• Partners in Development• Timeframe• Upcoming Projects• Questions?
WITHIN REACH – BEYOND IMAGINATION
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
WITHIN REACH – BEYOND IMAGINATION
Student Records
System (SRS)Financial
System
(FRS)
Budget
Development
Human
Resources
System
MISMISDevelopmentDevelopment MIS Project
Scope
Data
Warehouse
WITHIN REACH – BEYOND IMAGINATION
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
WITHIN REACH – BEYOND IMAGINATION
Finance
Staff
Admissions.
Records
& Registrar
Budget
Development
Human
Resources StaffComputer Computer Services & Services & InstitutionInstitution
al al Research Research
StaffStaff
Project Partners
WITHIN REACH – BEYOND IMAGINATION
MIS Development Timeframes
System
April
2001
FRS
SRS
November
2001
June
2002
Data Warehouse
November
2002
June
2003
Financial Aid
Human Resources
WITHIN REACH – BEYOND IMAGINATION
System
• Purchased and installed new DEC Alpha
• Purchased and installed Oracle
• Installed FRS software
MIS Development Hardware & Software Installation
WITHIN REACH – BEYOND IMAGINATION
System
FRS
MIS Development Implemented 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
WITHIN REACH – BEYOND IMAGINATION
MIS Development Timeframes
• 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”
System
FRS
SRS
WITHIN REACH – BEYOND IMAGINATION
WITHIN REACH – BEYOND IMAGINATION
WITHIN REACH – BEYOND IMAGINATION
WITHIN REACH – BEYOND IMAGINATION
WITHIN REACH – BEYOND IMAGINATION
MIS Development Data Warehouse
• 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
System
FRS
SRS
Data Warehouse
WITHIN REACH – BEYOND IMAGINATION
SRS Student,
Course &
Program Data
Selkirk MIS
Tables & Data
Transformation Area
Selkirk Student
Data Warehouse
Data
Ministry Student
Data Warehouse
Data
Oracle
WITHIN REACH – BEYOND IMAGINATION
MIS Development Timeframes
System
FRS
SRS
Data WarehouseHuman Resources• Implement software purchased in the previous year• Upload basic data elements from payroll data• Populate required tables, develop standard reports
and convert benefit administration
WITHIN REACH – BEYOND IMAGINATION
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
WITHIN REACH – BEYOND IMAGINATION
Upcoming SRS Projects
• Second Priority• Convert SRS to Oracle • Campus laser receipt printing• On-line registration enhancements• E-Payment
WITHIN REACH – BEYOND IMAGINATION
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
WITHIN REACH – BEYOND IMAGINATION
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
WITHIN REACH – BEYOND IMAGINATION
Questions?