© City of Glasgow CollegeCharity Number SC0 36198

ExamViewIntegrating Key Student Systems with the VLE

Background to the Project

• Presentation of exam results inconsistent:– Face to face– Printed results (posted on a wall)– Awards letter

• Duplication of effort• Privacy concerns

Project Aims

• Link the VLE (Moodle) with the Student Records system (Unit-e) and pull in exam results information

• Benefits– Flexible access to live information (online, 24/7)– Single point of access (one username / password)– Encourage staff to input results into Student Records

system promptly

Design

• Preliminary data models created, object oriented design

Design

• Student focus groups shown wireframe• Positive feedback and request for all results to be

shown, for all years

Development

• Three options considered:

– Option 1: Web service calls through Columbus– Option 2: Scheduled export of data from UNITe– Option 3: Querying Oracle directly

• Option 3 chosen > back-end written to query Unit-e’s Oracle database

• Option 2 also developed > back-end written to query MySQL database (if required in other institutions)

http://moodle.glasgowmet.ac.uk

Application

Application

Application

Student Feedback

Student Feedback

Delivery

• Project Outputs– Application (inc. two back-ends - Oracle and MySQL)– Source Code (inc. extensive comments)– User Guides

• All available to download from:– Project website: http://projects.glasgowmet.ac.uk/examview/ – Moodle.org: http://moodle.org/mod/data/view.php?id=6009

(search for “exam view”)– Google Code: http://code.google.com/p/examview/

Possible Future Developments

• Based on student feedback– Promotion to staff, to encourage timely input of results– Link for students to request results from staff– Inclusion of comments / feedback from staff

• Based on staff / community feedback ... ???• Read / write functionality to Student Records system• Use VLE gradebook as the ‘front end’

Questions?