I am new to Education as a Data Manager but have spent about 25 years in the IT industry as either a Software Developer or Information Analyst. My background has covered Systems Integration and Software Design for the Retail, Automotive, Insurance and Healthcare sectors (NHS).
My point - I am utterly appalled at the atrocious standard of Computer Software, Data Management & Processing techniques used in School MIS Systems.
We use Integris Classic which currently supports ODBC (Open Database Connectivity) access but the plan is to move our School over to the new Integris G2 system which doesn't support ODBC.
Did I miss something?.....A new system with reduced data access....No ODBC (a worldwide recognised industry standard)
Hold on a minute....I’m a Data Manager (or Data Consumer) how can I engage with my data and create reports?
How ridiculous - organisations in just about every other sector (for example the NHS who have immense targets to meet and report) develop their reporting systems using SQL Server, ODBC and Microsoft Access Databases - in other words they use proper relational database management systems (RDBMS) technology instead of these dysfunctional Assessment Worksheets/Markbooks.
Why not borrow good ideas from one of the world’s largest organisations!!!
I hear you say: “But I don’t know anything about SQL or databases?”
I reply: “Why are you a Data Manager then?”
Question: Why are there so many people employed in Local Education Authorities (who know nothing about Software, Data Management or Data Processing Techniques) and deciding which MIS systems to deploy in their local Schools?
Hold on a minute - DATA and DATABASE (I get it -- word association). That's right you got it!! DATA is best stored in a proper relational DATABASE - In other words the most suitable tool for the job.
If you think about it - recording an array of subjects holding A-G type grade against a student record is not exactly rocket science – so why all the problems?
Come on people it’s now 2010 – we have mobile communications, high capacity hard drives and memory, fibre optics, Laser printers and Bluetooth – so can’t we have a School MIS System which does the bread and butter?
I hear nothing but complaints about Integris.... but not to single it out – I also understand that all its competitors have weaknesses.
My challenge to you – give me 18 months, a small budget a couple of software developers and I’ll produce a School MIS Systems to knock the rest into touch at less than half the cost.
From what I've seen so far you'd be better of with a Patient Administration System
Students= Patients
Teachers = Consultants
Subjects = Specialties