Statistical database Debbie Becker Developed by
Why do we collect statistics? Planning and managing library services Motivation for improved funding/staffing Expanding or reducing services Measuring progress Indicating value to company Benchmarking
How do we collect statistics? Manually (Forms, reports, budgets, vendor reports, etc) Automatically (Access control, Library software and reporting systems, MIS, Online counters, etc. )
Who collects statistics?
Problem! • Statistics need to be retrieved from a number of sources • Staff do not understand statistics • Staff do not see what happens to the statistics they collect
Solution - Statistical database Selected staff input statistics directly onto the database – monthly or annually The database is a central source for statistics Staff can view the statistics they input Using reports, staff can retrieve all statistics Staff can use the statistics in their reports http: //10. 47. 2. 33
Proposed system
Statistical database • • Source code PHP Database My. SQL Minimal jscript No cookies, flash animation, add-ons
Main features • • • Security Data Reports Automated alert system Documents Help
Access control Registration details (Institution and branch) + Access permissions (allocated by Systems administrator) + Roles assigned to person (allocated by Systems administrator) = Menu options
Data hierarchy Two components: CHELSA data • Accessible to all Institutions Institutional data • set up per institution • access restricted to institution
Data entry Staff member inputs data per counter Counters available are based on access permissions A detailed explanation is provided for each counter All data input can be retrieved via reports
Data maintenance menu Available to system administrators Lists all available functionality as menu items Used to: set-up parameters; allocate permissions; create links; provide access to templates for non-standard data
Menu items Training statistics Database statistics
Reports System administration Pre-defined View system setup Templates Pre-defined Fixed reports Non-standard data structures Designer reports Based on templates CHELSA reports Institutional reports Reports can be downloaded as EXCEL spreadsheets
Automated alerts Determined by Institution • Up to 4 alerts • Define period between alerts • Initial alerts sent to data entry staff • 3 rd alert sent to supervisor as well • 4 th alert – supervisor to take action • Inspect menu allows viewing of data input
Documents Can store documents on the database Access controlled Upload from PC
Documentation
Thank you
Скачать презентацию Statistical database Debbie Becker Developed by Why
c49179bd5f831cac846fb34891ae194d.ppt