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).
Exporting a Formatted Marksheet
Select Focus | Assessment | Marksheet Entry.
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.
If you need to edit any results, make sure that you save before exporting.
Select Formatted from the Export drop-down menu on the Focus Bar. When the export is complete the spreadsheet will open automatically in Excel.
Exporting an Unformatted Marksheet
Select Focus | Assessment | Marksheet Entry.
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.
If you need to edit any results, make sure that you save before exporting.
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
| Entering Data using an OMR
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
| Quick Start
If you are responsible only for entering the marks on to OMR sheets please see OMR Sheets.
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.
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.
|