Getting Started In This Chapter



Download 14.49 Mb.
Page22/209
Date conversion08.07.2018
Size14.49 Mb.
1   ...   18   19   20   21   22   23   24   25   ...   209

Exporting a Marksheet to Microsoft Excel


Marksheets can be exported to Microsoft® Excel in two forms, Formatted and Unformatted.

Formatted – enables you to export the marksheet to Excel, from where results can be entered offline, i.e. away from the SIMS system. The file can then be used for importing the results back into SIMS Assessment through the Import from Excel routine:

  • The exported file will contain each Data Entry column, along with references to its associated aspects and result sets.

  • Results present in the marksheet are exported to the Excel file.

  • Data Review and Read-only columns are exported but without any reference to associated aspects or result sets. These columns are shaded light grey and no data entry is permitted.

  • Columns associated with pupil/student properties, e.g. name, Admission Number, etc, will also be shaded light grey and ‘Locked’.

  • Result date filters and notes attached to results will not be exported.

  • The Excel file is protected and cannot be unprotected. However, you can copy its contents to a new spreadsheet and you will then be able to use the normal spreadsheet functionality.

  • When working offline, the top cell of each Data Entry column can be used to enter the result date (dd/mm/yyyy) for all results in that column. Alternatively, the result date can be assigned during the Import from Excel routine.

NOTE: Before entering results in Excel, please make sure that the Enable AutoComplete for cell values check box, found in the Edit page of Tools | Options in Excel, is deselected. This will prevent the possibility of incorrect grade entries.

Unformatted – you can export marksheets as unformatted and you will then be able to perform more detailed calculations and use the additional functionality provided by spreadsheets.

Data entered into the spreadsheet can be imported back into SIMS Assessment system, through the Import from Excel routine, but this would entail mapping all of its data.



All the data in the marksheet must be saved before export, after which it can be saved in Excel and will contain the following information:

  • marksheet names

  • group name

  • export date

  • column headers

  • row headers

  • results/data

  • template notes.

NOTE: Notes added to individual results are NOT exported, neither is data within any hidden columns (e.g. those that may be used for calculation purposes).
      1. Exporting a Formatted Marksheet


  1. Select Focus | Assessment | Marksheet Entry.

  2. Filter the list of marksheets by Category (please see Filtering Your View using Categories on page 83). Click the required marksheet name to select it.

  3. If you need to edit any results, make sure that you save before exporting.

  4. Select Formatted from the Export drop-down menu on the Focus Bar. When the export is complete the spreadsheet will open automatically in Excel.
      1. Exporting an Unformatted Marksheet


  1. Select Focus | Assessment | Marksheet Entry.

  2. Filter the list of marksheets by Category (please see Filtering Your View using Categories on page 83). Click the required marksheet name to select it.

  3. If you need to edit any results, make sure that you save before exporting.

  4. Select Unformatted from the Export drop-down menu on the Focus Bar. When the export is complete the spreadsheet will open automatically in Excel.

As well as the export of one file at a time described above, users with suitable permissions can import and export a selected batch of formatted marksheets to and from Microsoft® Excel through System Utilities.


More Information:

Importing Data from Excel on page 236

Importing a Selection of Marksheets from Excel on page 329

Exporting a Selection of Marksheets to Excel on page 323
  1. Entering Data using an OMR

    In This Chapter


    Quick Start 51

    Introduction 51

    Creating OMR Templates 56

    Creating an Age OMR Template 62

    Editing OMR Templates 64

    Cloning OMR Templates 65

    Associating OMR Templates with Categories 65

    Deleting OMR Templates 66

    Creating OMR Sheets 66

    Printing OMR Sheets 68

    Reading OMR Sheets 69

    Editing Results Entered via the OMR 70

    Deleting OMR Sheets 70

    Viewing OMR Template Properties 71
    1. Quick Start


If you are responsible only for entering the marks on to OMR sheets please see OMR Sheets.
    1. Introduction


An Optical Mark Reader (OMR) can be used to read in all results or in combination with keyboard entry. For example, you might use OMRs for entering data collected from across the whole school, whilst individual departments may prefer to enter their results using the keyboard. Usually, where only one person is responsible for entering many of the results, using an OMR is quicker and more accurate.
      1. Process when Entering Results using an OMR


  • Create OMR template, i.e. select template type and aspects. Optionally, associate with Categories and/or result set.

  • Create OMR Sheets (associate one or more pupil/student groups with OMR template.

  • Print OMR sheets and distribute to teachers

  • Teachers enter results on OMR sheets

  • Feed completed OMR sheets into system through the OMR

  • View/edit results through existing or new marksheets

  • Retain OMR sheets for future results-delete marksheets that are not needed.
1   ...   18   19   20   21   22   23   24   25   ...   209


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

    Main page