You can use the Test and Assessment Import Tool within you Classroom Monitor admin account to import GL CAT4 test data. The steps below will support you with completing this import.
Extracting and Preparing your Raw Data for Import
Before importing into Classroom Monitor, you will need to export the CAT4 data from the GL online system into excel. You may need to export English, Maths and Science results separately. If you are unsure how to do this we recommend you speak to GL Customer Support on 0330 1235375.
The exported spreadsheet will have many columns, but not all of these are required to import into Classroom Monitor. You can remove all unnecessary columns from the excel spread sheet to make this process much easier. An example export file is shown in the image below.
You will need to retain the forename and surname column, and the Student ID column. Any import into Classroom Monitor uses pupil ID numbers as the unique value to identify a pupil. For the import to be successful the ‘Student ID’ within the GL export MUST match the number being used in the ‘UPN’ field within your Classroom Monitor account. If these numbers do not match, you will need to add the correct Classroom Monitor ID number to your excel spreadsheet prior to import.
The table below details which scores can be imported into Classroom Monitor for each area of the CAT4 Tests. These are the columns you may wish to retain in your excel sheets. The tables also confirm the accepted mark range for each. You can choose to import some or all of these areas depending on your preferences.
Please ensure that the excel sheet has a single row of column headings and these are all in row ‘A’.
DO NOT split data for classes or year groups across multiple tabs within the excel sheet.
All data you are looking to import must be on a single tab.
The excel sheet then needs to be saved as a .CSV file. To do this, select to save within Excel, choose your location and select “CSV (Comma Delimited)” from the ‘Save as Type’ drop down as shown in the image below.
Importing your Data into Classroom Monitor
Step 1) Log in to your Admin Account
Log into Classroom Monitor through your Administrator account. You cannot import data through a 'teacher' account.
From the homepage click on the hexagon for 'Data Management' and then select the option for 'Test & Assessment Import'. This will take you to the Test and Assessment Import Tool.
Step 2) File Preparation Screen
On the 'File Preparation' screen
1. Select 'GL CAT4' from the Curriculum Selection drop down.
2. Tick 'Import results as Points'
3. Click on 'Browse' and select your .CSV file.
4. Click 'Upload File'
5. Click 'Next'
Step 3) Import Configuration Screen
The following screen requires you to confirm the information you are choosing to import, where you are importing this to, and when this relates to.
The left hand column (highlighted in the image below) details all of column headings from your .CSV file. The central column of drop down menus allows you to map this information to the destination within Classroom Monitor.
Locate the column called ‘Student ID’, and map this to the ‘UPN’ field in Classroom Monitor.
Then map each of your test score columns to the appropriate fields within Classroom Monitor. For example you may wish to map the ‘Standard Age Score’ for Verbal Reasoning to ‘Verbal - SAS’. You can map some or all of the areas as you prefer.
The right hand column allows you chose the date for which you are importing the data. You can enter an individual date for each of the subject areas, or more likely will wish to apply the same date for all the data within this import.
To add the same date for all. Select your chosen date from the top of the column and the select ‘update rows’. This will enter the same date for all areas which have been mapped.
*** Please note you can only import for one test date, for each area at one time. If you wish to import CAT4 test data for Autumn 18 and Autumn 17 and so forth, this would be a separate import. You can use the same file, but would need to map your 2018 columns, set the date and complete the import, then repeat your 2017 columns .
Once the above is all completed click ‘Next’ at the foot of the page.
Step 4) Preview and Validation Screen
The next screen, ‘Preview and Validation’, shows you all of the results that are about to be imported. Each score is colour-coded:
- Green indicates a score is valid and ready to be imported;
- blue indicates a score is already present and will be overwritten by this import;
- red indicates that either no score is recorded in the CSV file, or this is an invalid value.
If there are a significant number of red values, check your .CSV carefully, make your corrections and begin the import process again.
If all looks to be correct, click ‘Next’ at the bottom of the screen.
Step 5) Confirmation Screen
On the 'Confirmation Page' please read the information carefully. If you are happy to proceed enter the Administrator password and tick ‘I agree to import these results into Classroom Monitor’.
You can now click ‘Import Results’ .
The results will import and you will receive a message to confirm this has been successful.
Viewing the Data in Classroom Monitor
Once the import is completed you can view your data by logging into Classroom Monitor using your teacher account.
Select the 'Attainment and Progress Module', select 'Pupil Tracking, and choose your pupils. Under select 'Subject' choose ‘GL CAT4’ as your curriculum. You can or all of the areas to view the scores.
Once you have generated the Pupil Tracking Table, you will see the test results displayed. If you wish you can display GL Data alongside other curricular and assessment data within Classroom Monitor. This is especially useful to triangulate internal teacher assessment with external summative data.