GBA 573 Final Project Prepared by Ross Niswanger Transfer of Student Records to OPMIS Problem Statement Current database record keeping is a dualentry process With the advent of a Windows Based OPMIS program STUDENT redundant data information can be eliminated Goal is to incorporate STUDENT electronic data with paper files and eliminate as much of the paper trail as possible Current Situation Currently use Binnacle to track Midshipmen information electronically for use by the staff Binnacle information is a repeat of information require by CNET that is held within OPMIS System was developed because of old OPMIS being a single user system with no ability for network usage System was designed in house to run on Windows Microsoft Access Binnacle Binnacle Binnacle Along Comes STUDENT New OPMIS program instituted this summer LAN enabled Windows program 10 users User Friendly in many aspects Duplicates many of the functions of Binnacle STUDENT STUDENT STUDENT Current Issues 191 Data Fields in Binnacle that are also kept in OPMIS 6 or 7 Fields in Binnacle not utilized in OPMIS but used by Unit or Battalion Staff Many errors through lack of communication between the two databases Would like to reduce amount of paperwork kept within Student Files Certain Reports generated by Binnacle Duplication possible with STUDENT Feasibility Currently use Binnacle as database for Unit use All data required by CNET within STUDENT Data not required by CNET to be transported to another smaller database or not used anymore Reports can be generated by using SQL and can get to all data kept by STUDENT Bottom Line Feasible to implement STUDENT as main database for UNIT use Requirements Installation of Software on all staff machines Training staff on how to use software Training staff on how to use software to get the information required reports paradigm shift Creation of shared drive for keeping electronic documents generated by for students Hard copies of required signed documents Design Development STUDENT already designed Functions within Binnacle not handled by STUDENT to be offloaded and issue pressed with CNET to allow user fields to be added to STUDENT Paradigm Shift Implementation Sudden Change Want to eliminate Binnacle in one fell swoop and force use of STUDENT Help to ensure Paradigm Shift Questions
View Full Document
Unlocking...