Getting Started In This Chapter



Download 14.49 Mb.
Page120/209
Date conversion08.07.2018
Size14.49 Mb.
1   ...   116   117   118   119   120   121   122   123   ...   209

Importing Data from Excel


Marksheet results can be imported from Microsoft® Excel .XML files, which must have been created in Office 2003 or later.

There are likely to be three main reasons for importing results data from Excel:



  • Importing results from users who have been working offline - this import may be the second stage in a process that began with the export of a formatted marksheet from your own SIMS Assessment system to Excel. The formatted marksheet would have contained pupil/student details, Data Entry columns and references to their associated Aspects and result sets. This means that, on importing into SIMS Assessment, the mapping of columns is not necessary and the import is an uncomplicated process.

  • Importing from third parties – for example, results from LAs, nferNelson, Cat Scores, etc. Part of the import will involve the mapping of the spreadsheet columns, so that SIMS Assessment knows where and how to store the results.

  • Importing of legacy data – the one-off import of data that schools have been storing in other systems. Again, the import will involve the mapping of the spreadsheet columns.

The process described in this section enables you to import one file at a time. Alternatively, users with suitable permissions can import and export a selected batch of formatted marksheets to and from Excel through System Utilities.


More Information:

Exporting a Marksheet to Microsoft Excel on page 48

Importing a Selection of Marksheets from Excel on page 329

Exporting a Selection of Marksheets to Excel on page 323
      1. Importing Excel Data – Formatted Marksheets


  1. Select Routines | Data In | Assessment | Import from Spreadsheet to display the first page of the Import wizard.



  1. Click the
1   ...   116   117   118   119   120   121   122   123   ...   209


The database is protected by copyright ©dentisty.org 2016
send message

    Main page