PROGRESS IN MATHS

NON STATUTORY TESTS

PRIMARY

USING ASSESSMENT MANAGER 7

INSTRUCTIONS TO SCHOOLS

MAY 2014

PROGRESS IN MATHS

Entering data into Assessment Manager 7

Progress in Maths results for 2014 should be entered using marksheets in Assessment Manager 7 (created from templates imported in previous years). These results must then be exported and sent electronically to the LEA. One template exists for each of the Progress in Maths Tests, which need to be completed for Reception and Year 1 (progress in Maths 5 & 6 respectively).

Many schools will be entering results for a both year groups, therefore please follow these instructions to enter and export the results for each test individually.

Please use this checklist to ensure you have completed all steps for each test completed, full details for doing so are given on the following pages.

Create export folder, page 4

Create marksheets (for use with classes only), page 5

Enter appropriate Progress in Maths results onto marksheets, page 10

Calculate totals, page 13

Save the results, page 14

Create the export XML file, page 16

Upload the XML file as a generic file on the S2S site, page 25

If you need any further advice about the tests themselves, please contact Richard Evans on 01446 709132 or Wendy Evans on 01446 709368.

If you require guidance on using SIMS/Assessment Manager/S2S please call TheSIMS Helpdesk on 01446 709109.

PROGRESS IN MATHS TESTS, YEAR GROUP MAPPING

Year group: / Test: / Template/marksheet name: / Result set*:
Reception / NFER Progress in Maths 5 / PIM5TEMPLATE / PIM5
Y1 / NFER Progress in Maths 6 / PIM6TEMPLATE / PIM6
  1. Creating an export folder

As you may be exporting a number of results files, it is a good idea to create a folder named results_maths_2014 to store the results files before they are uploaded to the S2S site.

  • Click the Start menu
  • Select My Computer
  • Double click the S: Drive and navigate to the SIMS folder and then to the Assessment folder (these may need to be created if they do not already exist).

  • Once in the Assessment folder, click File
  • Select New
  • Click Folder
  • Type results_maths_2014 and press Enter
  • Close the window.

  1. Creating marksheets – for those working with classes only

For those schools using one marksheet for each class within the year group, templates need to be linked to the appropriate classes to create these. For those schools using one marksheet for each year group these will already exist as they were created last year (please continue to the following section).

  • Within SIMS.net go to Focus > Assessment Manager > Template

The Template area opens.

  • Type the first few letters of the template name (given on page 3), for example PIM5,in the Template Name field.
  • Click Search.

The template is listed in the browser.

  • Double click the template to view – please ensure the template name matches exactly with that on page 3 as there may be some old, redundant templates on the system from previous years.

The template is displayed in the main window.

  • Click on the Marksheet hyperlink.

The marksheet panel is moved to the top of the screen.

  • Click the New button within the Marksheet panel.

The Group Selector box is displayed.

  • Click on the + next to Registration Group.
  • Select all appropriate classes.
  • Click Apply.

This will create one marksheet for each class/reg group selected, the marksheets created are listed on the template.

  • Click the Save button.
  • Close the template area.

If Teaching staff are not entering their results directly onto the marksheet in SIMS or in the SLG it can be helpful to print the blank marksheet for them to manually enter their results onto it, it will then be in the correct format and order for entry into SIMS.

To do this:-

  • FocusAssessmentMarksheet Entry
  • Search for the required marksheet
  • Click on Print Icon
  • Tick Print Blank Marksheet

Repeat for all marksheets to be completed.

Alternatively

You can export the blank marksheet to an excel document which can they be sent to the teacher for them to enter the data directly into it.

To do this:-

  • FocusAssessmentMarksheet Entry
  • Search for the required marksheet
  • Click on Export Icon
  • Then name and save the marksheet in a suitable place for teaching staff to access it (ie on a secured share drive or it can be attached to a secure email for them to complete and return)

Repeat for all marksheets to be completed

  1. Entering the Progress in Maths results

Results can now be entered on to the marksheets.

  • Go to Focus > Assessment Manager > Marksheet Entry
  • Within the Template Name field type PIM followed by the appropriate test number, ie PIM5 for reception pupils.
  • Click the Search button.

The Progress in Maths marksheet(s) for the appropriate test is listed, as shown below.

  • Double click a marksheet to view.

Data can now be entered onto the marksheet. The pupils are listed in alphabetical order by surname. If the list you are working from is in another order, such as date of birth or gender, you can reorder the marksheet.

To reorder the marksheet:

  • Right click on the Students column header.
  • Select DOB or Gender etc – this will insert a column with this information into the marksheet.
  • Click on the column header of the column inserted – the pupils will now be in the order of the column inserted, ie DOB order.

It is also possible to enlarge the marksheet so that more pupils are in view at any one time.

To enlarge the marksheet:

  • Click the Zoom button
  • If you wish to return to the normal view click the Close button.

To enter Progress in Maths results:

  • Click into the cell corresponding with the pupil and insert the score in the first column, PIM5 1.
  • Tab across to the PIM5 2 column and insert the score, tabbing across the columns until all scores have been added for the pupil, with the exception of the last column which contains a total.
  • Use the downward cursor key to move to the next pupil and repeat until all scores have been entered for all pupils, again with the exception of the last column.
  1. Calculating the PIMZTOTAL

Once all the assessment data has been added for all but the last column (which is a formula column), the PIMZTOTAL (where Z is the test number) can be automatically calculated.

  • Click the Calculate button

The necessary results will appear in the PIMZTOTAL column for each pupil.

  1. Saving the results

Now that all the data has been added to the marksheet, the Data Entry for this Marksheet is Complete check box can be used to indicate the marksheet has been completed. This is useful for those people who created one marksheet for each class.

  • If in zoom view, click the Close button to return to normal view.
  • Click the Data entry for this marksheet is complete checkbox, indicated above.

The marksheet can now be saved, to do this:

  • Click the Save button on the marksheet.
  • Close the marksheet.

For those using one marksheet for each class repeat steps 3, 4 and 5 for each class within the year group.

  1. Creating the export XML file

Once all marksheets have been updated and saved, the results can be exported to the LEA. By following the instructions below, you should create one XML file for each test which will contain all pupils in the associated year group and their results.

  • Within SIMS.net go to Routines > Data Out > Assessment Manager > Export.

The Export wizard is displayed.

  • Select Export Results.
  • Click Next.
  • Click the Browse button to specify the export file.

The Save As dialog box is displayed.

  • From the Save In field select the S: drive (this may be the J drive in some schools).
  • Select the results_maths_2014 folder.
  • In the File name: field type a file name for the results, this must be in the following format:
  • Click Save.
  • Click Next.
  • Select Export using Custom Filter.
  • Click Next.
  • Click the Browse button to select the pupils.
  • Click the + alongside Year Group.
  • Select the appropriate year group by clicking into the checkbox.

The pupils from the selected year group are displayed in the bottom section of the window.

  • Click Select All.
  • Click Apply.
  • Click Next.
  • Click Next again – no aspects need to be selected.
  • Click the Browse button to view all available result sets.
  • Tick the appropriate result set (ie PIM5), as shown.
  • Click Select.
  • Click Next.
  • Type 30/04/2014 in the From field, or use the Calendar button to select the date from the pop up calendar.
  • Type 30/06/2014 in the To field, or use the Calendar button to select the date from the pop up calendar.
  • Click Finish.

The following message will be displayed.

  • Click Yes to proceed.

An activity log is displayed to say that the file was successfully created.

  • Click Close

The XML file will be saved in the results_maths_2014 folder in your S: drive (or J: drive) under the name 673SSSS_673LLLL_Y2M14(or similar format)shown earlier.

  1. Uploading the XML file to the S2S site

Once generated, the XML file now needs to be uploaded to the LEA via the S2S site.

Access the S2S web site by:

  • going to

(you can also access this through the WAG Schools Portal at and navigating through to S2S once you have selected your school type).

The login screen is displayed, shown below:

Login

Top of Form

UsernamePasswordI agree with the Terms of use

Forgotten username or password

  • Enter your username and password.
  • Click Submit.
  • Click on the plus button next to Upload file.
  • Select Upload Generic File.
  • Locate the file by clicking on the Browse button and navigating to the S: drive (or J: drive), then double clicking the results_maths_2014 folder.
  • Highlight the XML file created, this should be in the format 673SSSS_673LLLL_Y2M14 (or similar).
  • Click Open.
  • Click on Upload Generic file.

You will get a message to say that this may take up to 5 mins. You will then get a further message when the file has been successfully uploaded. Please contact the SIMS Helpdesk if you encounter problems successfully uploading the file.

FOR HELP PLEASE PHONE THE SIMS TEAM ON 01446 709109

1