260 likes | 397 Views
Millennium Statistics. Gaelic Show ‘n Tell Workshop held at the National Library, Pretoria 09 September 2010 Maria Shibanda University of Limpopo. Millennium Statistics - Overview. What is Millennium Statistics? Types of Statistical Reports Finding and fixing bad codes.
E N D
Millennium Statistics Gaelic Show ‘n Tell Workshop held at the National Library, Pretoria 09 September 2010 Maria Shibanda University of Limpopo
Millennium Statistics - Overview • What is Millennium Statistics? • Types of Statistical Reports • Finding and fixing bad codes
Millennium Statistics • A tool for creating a wide range of statistical reports about your millennium database. • Database queries can be saved, can be calculated again at any time and may be scheduled to be run at a specific date and time • Reports that you can generate are: -How many records were catalogued in a specific time period -Counts of record in each call number range - How many records are for titles in foreign languages • Millennium Statistics offers two main modes of operation: -Saved queries: this option is used to create a new query, to run a saved query,to schedule a saved query or to edit a saved query -Results files: this option is used to view the statistical results of the query and to create reports based on these results.
Millennium Statistics examines and reports on a particular record type when gathering statistics Record types • Bibliographic records • Order records • Item records • Checkin records • Patron records • Course records • Authority records • Resource records • License records
Types of Statistical Reports • Field statistics report • Periodic report • Cross tabulation report
Field Statistics Report • Reports are based on fixed-length field and call number • Track totals of all records in the database • Gathers statistics on all fixed-length field in a specified record type
Periodic Report • Reports are based on date field contain in the record.eg CATDATE,Created date,Update Date,LCHKIN,ODUE DATE etc • Allows limiting the query to only those records in which a selected date field matches a specified range of years, quarters, months or days
Cross Tabulation Reports • Reports based on crossing two specific fixed fields.eg PTYPE on the vertical lines and Home library on the horizontal lines
Finding and Fixing bad codes • Bad codes are entries that appear in statistical reports under a heading labelled “Bad code” or “No code” • Annually, run a field statistics report for the entire range of records in the database to seek out, clean bad codes and Scat range not in the table.
References • http://yourIP address/manual/gmstat_main_page.html • http://csdirect.iii.com/documentation/milstats.shtml • http://csdirect.iii.com/documentation/badcode.shtml • http://csdirect.iii.com/documentation/booltroubleshooter.shtml • http://csdirect.iii.com/documentation/startmilstats.shtml • http://csdirect.iii.com/documentation/scat.shtml
Thank you marias@ul.ac.za