Administrative Systems Projects
The Administrative Systems staff spend a large percentage of their time on projects contributing to the strategic use of technology for the continual improvement of operations at Jackson Community College.
Below is a list of the current items that we are working on. If you have any questions about this information, please contact us at (517) 796-8513 or email clonemarcelll@jccmi.edu .
The Administrative Systems staff has completed a variety of projects this year already. Click the link above to view a list of completed projects.
IT PROJ: p0126- Colleague ODS Implementation Phase I
Summary: Work with IR and Datatel consultants to implement and begin using the Datatel’s DataOrchestrator ODS (Operational Data Store). The ODS is an advanced reporting solution that automates the process of managing and manipulating data to produce reports that support detailed analysis and fact-based decision making.
Completed Milestones:
- Evaluated reporting needs and review product
- Purchased and coordinated installation and training for Administrative Systems Staff
- Server created and ODS Data Populated
- ODS Database Administration and Reporting Consulting
- Created Database for use in Account Provisioning
- Created reports for Exit Loan Interviews
- Created export for use in TutorTrac student data population
- Corrected refresh errors and scheduled nightly refreshes
- Installed and configured SQL Reporting Services
Remaining Milestones:
| Additional Task | Resources | Estimated Time |
|---|---|---|
| Customize the ODS Targets | Information Technology | 20 hrs |
| ODS Data clean-up | Information Technology | 120 hrs |
| Review AP5 needs | Information Technology Institutional Research |
10 hrs 10 hrs |
| Brainstorm and create data models | Information Technology Intuitional Research |
50 hrs 10 hrs |
| Develop and deploy security model | Information Technology | 10 hrs |
| Develop custom reports | Information Technology | 65 hrs |
| End-user training | Information Technology | 40 hrs |
Back to Top
Updated 09.29.09
IT PROJ: p0159- Colleague Application Security Review and Process Improvement
Summary: Review Colleague Application security to determine weaknesses and develop an improved security structure.
Completed Milestones:
- Established new security structure and standards
- Migrated all current Colleague users to the new structure and standards
- Developed and documented process for creating new accounts for employees and student employees
- Developed and documented process for removal of permissions for internal transfers
- Developed and documented process for granting additional permissions
- Created and distributed communication to appropriate stakeholders
Remaining Milestones:
| Additional Task | Resources | Estimated Time |
|---|---|---|
| Internally audit current user permissions to identify weaknesses | Information Technology | 40 hrs |
Back to Top
Updated 09.29.09
IT PROJ: p0084a- Historical Transcript Importation
Summary: Create ELF specification to import historical transcripted students into Colleague for use by the JCC Registrar's Office and the JCC Foundation. This will allow for integration between Colleague and the ImageNow software.
Completed Milestones:
- Source file format determined
- Create ELF Specification and Test
- Install and Import records into Production
Remaining Milestones:
| Additional Task | Resources | Estimated Time |
|---|---|---|
| Resolve and import errors | Information Technology | 5 hrs |
| Import images into ImageNow | Information Technology | 15 hrs |
Back to Top
Updated 10.28.08
IT PROJ: p0259- Datatel Roadmap for JCC/Action Planning
Summary: Datatel consultants will work with major user areas to identify concerns and process needs within the Datatel application. JCC and Datatel will develop potential action plans for future potential projects. This project will give JCC a holistic view of client needs and concerns.
Completed Milestones:
- Datatel Business Advisor has met with JCC Technical and Executive Sponsor
- Coordinated the Action Planning visit
- Completed Colleague Usage Surveys
- Interviewed all user areas
- Received Action Plan from Datatel
- Develop priorities/costs/benefits
Remaining Milestones:
| Additional Task | Resources | Estimated Time |
|---|---|---|
| Develop plans for future projects | Information Technology | 15 hrs |
Back to Top
Updated 09.29.09
