hi john
We are using Moodle as our Learning Platform and have enlisted the support of the University of London Computer Centre to develop an ILP and ePortfolio (Mahara). We are currently trying to get data out of Facility CMIS SQL database to display in Moodle for parents, students and staff.
The data we would need access would be a range of things:
- Student details
- Lessons or Courses (set lists for automatic creation of courses)
- Student Behaviour Events
- Student Attendance (AM PM roll call)
- Student Timetable
- Staff Timetable
- Assessment data (from assessment tracker - eg. 6 data tracks throughout the year and a target grade)
- Results (SATs, Teacher Assessments, GCSEs)
I'm sure there is more, but that is all I can think of at present...
ULCC have managed to find some of the data and it is working in terms of functionality and appearing the in ILP... with so many tables, many without data its very time consuming.
I have approached Serco for support with regards the database schema but they say they only support API.