Getting Started In This Chapter

Exporting a Marksheet to Microsoft Excel

• 
  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.
  

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.

• 
  marksheet names
  
• 
  group name
  
• 
  export date
  
• 
  column headers
  
• 
  row headers
  
• 
  results/data
  
• 
  template notes.
  

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.
   

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

3. 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

2. Introduction

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.