Data Formats

Export

Almost all of the data you use within Exams Manager can be exported to a variety of different data formats. This includes the latest Microsoft Excel formats. More information on exporting data can be found in the Exams Manager Demonstration Package.

Import

Exams Manager has an automated import process that can receive regular updates from your student records system.

Exams Manager require three data files to be produced by your student records system:

  • Students
  • Units
  • Enrolments

Data File Formats

EM can import data from a variety of spreadsheet style formats, including:

  • Microsoft Excel 1995-2004 (.xls)
  • Microsoft Excel 2007-2008 (.xlsx)
  • Tab Separated Values (.tab)
  • Comma Separated Values (.csv)

The use of .tab files is recommended where possible.

Students

Personal details about your students can be imported from a data file. This data file might be produced daily by your student records system and imported automatically overnight. This ensures you always have the latest contact details for your students.

Download Students.xls. Full documentation about each file is not included here, but is available on request.

Units

Information about each of your units (a.k.a. Topics, Courses etc) can be imported from a data file.

Download Units.xls. Full documentation about each file is not included here, but is available on request.

Enrolments

A list of every current enrolment should be included in this data file. Your enrolment data will change daily at the start of each study period. Enrolments that have been withdrawn should not appear in the data file.

Enrolments that existed in a previously imported file, but do not exist in the current file, will be marked as "withdrawn". This allows you manage students that withdraw from units after you have made special arrangements for them.

Download Enrolments.xls. Full documentation about each file is not included here, but is available on request.

 

 
  © 2008 Databee Business Systems