Cemis training

High-Level Overview of the Process

There are five stages to complete the entire recording and reporting (R&R) and data upload process. These stages are as follows:

  • Download R&R Tool and Learner Data file
  • Generate/Load R&R Tool
  • Importing assessments marks
  • Exporting data file from R&R Tool
  • Upload data file via CEMIS

The high-level process is illustrated in the figure below. Each stage is explained in more detail in the subsequent sections.

Process Diagram

Stage 1: Download R&R Tool and Learner Data File

This section describes how to download the R&R Tool and the associate learner data file for the particular grade from CEMIS.

  • Log on to CEMIS
pic01
  • Select the School Type
pic02
  • Select the School and click on the “Submit” button
pic03
  • Scroll down and click on the “Proceed” button
pic04
  • Select the “Recording Sheets” option from the “Reports” menu bar option, then select the “Gr1-9 Download” option from the “Recording Sheets” option
pic05
  • Select the applicable grade from the “Select a Grade” dropdown menu
pic06
  • A page will be shown displaying the learner data. Scroll to the bottom of the page and click on the “Click here to proceed to the download page” hyperlink
pic07
  • Detailed instructions are provided on the Download Page. The summarised steps follows:
    • Print the instructions if required
    • Create a folder to store the Excel Spreadsheet (R&R Tool)
    • Download the Excel Spreadsheet (R&R Tool)
    • Download the learner data file
pic08
  • Ensure that the R&R Tool downloaded and data file downloaded are saved in the same folder created in the steps above.
pic09
  • Log out of CEMIS

Stage 2: Activate R&R Tool and Load Learner Data

  • This section describes how to activate the R&R Tool and load the learner data file obtained from CEMIS into the R&R Tool.
    • Double-click on the Excel file to open the R&R Tool (named “GRD_3.xls” or similar).
    • The R&R Tool will open and display the following screen
    • Click on the “Start Loading data from CEMIS” button to load the learner data file. Note that this may take while.
pic01
  • The following message will be displayed on successful completion of the learner file load.
  • Click on the “OK” button
pic02
  • Inspect the subject sheets. Learner details will be displayed for each subject. Note that there will not be any marks at this stage.
pic03

Stage 3: Import Assessment Data

This section describes how to import data from an R&R Tool (Excel Spreadsheet) that contains previously captured data.

[Describe multiple imports – different class files to be combined in a grade file]

[Include addendum for importing errors – “go to” section]

Prerequisite:

Ensure that the R&R Tool containing the data is in the same folder as the newly activated R&R Tool

  • Open the newly activated R&R Tool and navigate to the “Personal Info” worksheet
  • On the “Personal Info” worksheet, click on the “Import marks” button
pic01
  • Navigate to where the R&R Tool that contains the data have been saved is (here called the “GRD_3_PREVIOUSLY CAPTURED DATA”).
  • Select the file and click on the “Open”
pic02

Do not describe errors in the narrative. Rather in the appendix section]

  • If there are discrepancies between the weighting of the selected file and the R&R Tool to which the data is being imported to, a warning screen will pop up. Select the applicable action.
pic03
  • If there are further discrepancies between weighting found the following warning screen will pop up. Select the appropriate action.
pic04
  • NOTE: The program also checks for other discrepancies. In all instances a warning message will pop up. Choose the appropriate action (as per above examples).
  • Once all the marks have been imported the program will display an “All marks imported” message box.
  • Click on the “OK” button
pic05
  • The newly activated R&R Tool will import the data from the selected file.
  • A message box will be displayed to inform the user that the marks have been imported.
  • Click on the “OK” button to close the message box
pic05
  • Inspect the subject sheets. The data should now show in the R&R Tool into which the data have been imported.
pic07
  • The R&R Tool may now be saved. (Note that it is good practice to save regularly throughout the process.)

Stage 4: Export Data

This section explains how to export the data from the R&R Tool.

  • Go to the “Personal Info” worksheet and click on the “Export” button
pic01
  • Once the file has been exported a “Data Exported” message box will be displayed.
  • Click on the “OK” button to close the message box.
pic02
  • Note that the exported file will be saved in the “Export” subfolder created automatically by the R&R Tool. See below.
pic03
  • WARNING: Do not change the filename before uploading. The exported filename is the exact format that is required for upload to CEMIS.
  • Click on the export folder to inspect that file have been saved
pic04

Stage 5: Upload Data

  • Log on to CEMIS as per normal process
  • Select the “Recording Sheets” option from the “Reports” menu bar option, then select the “Learner Performance Upload” option from the “Recording Sheets” option
  • Take out the Gr10-12 part of the CEMIS screenshots x2  
pic01
  • The grade selection screen will be displayed. Choose a grade from the “Select a Grade” dropdown menu. (Note that only Grade 3, 6 and 9 will be active currently.)
pic02 Copy
  • Click on “Browse…” button to upload the exported text file.
  • Check if this is the correct screenshot
pic03
  • Navigate to where the file to be uploaded is stored (in “Export” sub-folder).
  • Select the file you want to upload and click on the “Open” button to upload the file.
pic04
  • Click on the “Submit” button to complete the upload process
pic05
  • The system will display a “File uploaded successfully” message
  • Click on the “OK” button to close the message box.
  • Message box may change. Check again before final version of doc.
pic06
  • The system will display a “File loaded into Staging Area”.
  • [WARNING: If the user changed the filename to an incorrect format an “Invalid filename convention”error message will be displayed. Ensure that the filename is correct and upload the file again.]
  • Click on the “OK” button to close the message box.
pic07
  • This ends the file upload process