April 2010
The Westfield Centre
Key Stage 1 and P Scales 2010 Lancashire Schools
The Westfield Centre Redwood Avenue ● Leyland ● PR25 1RP
Tel: 01772 623222
Fax: 01772 621209
E-mail:
[email protected] www.westfield.lancsngfl.ac.uk
Version
Change Description
Approved By
Date
1.0
First Draft
Melanie Steele
13/04/2010
1.1
Peer Check Amendments
Angela Teasey
21/04/2010
1.2
Non-Peer Check Amendments
Caroline brown
26/04/2010
1.3
School Check (where applicable)
1.4
Final Proof Read
Shirley Bampton
27/07/2010
Document Author Filename
Melanie Steele K:\Support Areas\Assessment & Reporting\FSP_Key Stage 2010\KS1\LCC\KS1 AM7 2010 LCC (7.128).docx
The Westfield Centre – Lancashire County Council
Contents End of Key Stage Procedures ...................................................................................... 5 Importing the Key Stage Manager Wizards into Assessment Manager 7 ................. 7 Importing the Key Stage 1 Wizards. ............................................................................. 8 Key Stage 1 .................................................................................................................. 12 Creating an Assessment User-Defined Key Stage 1 Pupil Group ................................. 12 Entering Key Stage Data Into the Imported Key Stage Wizards .............................. 21 Entering P Scale Information Into the Imported Key Stage Wizards .............................. 31 Previewing and Printing Key Stage 1 Reports .......................................................... 35 Uploading Individual Reports to Pupil Records (Optional) ............................................. 42 Viewing the Report in SIMS .net .................................................................................... 43 Sending Key Stage 1 Results to Your LA Using SIMS.net ....................................... 45 Missing Postcode Check ............................................................................................... 45 Running the Missing Postcode Check ........................................................................... 48 Creating a Common Transfer File to Send to the LA ..................................................... 49 Copying the Common Transfer File to Anycout ............................................................. 57 Sending the Common Transfer File to the LA via Anycomms ....................................... 60 Checking the summary of results sent from the LA ....................................................... 62 Appendix A – Pupil Eligibility for Key Stage 1 .......................................................... 63 Appendix B - KS1 Acceptable Entries ....................................................................... 65 Appendix C - Setting up Users Through System Manager ...................................... 67 Adding existing people .................................................................................................. 67 Assigning Users to Groups ............................................................................................ 69 Appendix D – Macro Security Settings ...................................................................... 71 For Users of Microsoft Word 2003 ................................................................................. 71 For Users of Microsoft Word 2007 ................................................................................. 72 Appendix E – P-Scales supplement ........................................................................... 74 5.5 P Scales .................................................................................................................. 74 Reportable levels for P Scales....................................................................................... 75 Examples................................................................................................................ 76
3
The Westfield Centre – Lancashire County Council
Have users been set up and assigned to the appropriate Assessment Manager user groups in System Manager SQL? Set up users in System Manager SQL (see Appendix C).
No Yes
Import Key Stage Wizards into Assessment Manager from the AMPA folder.
Create user defined Key Stage 1 cohort.
Use the Key Stage Wizards in Assessment Manager to enter pupil results.
Errors
Produce reports for in-school use and to send home to parents.
Send Key Stage 1 results to your LA
Check the results summary emailed from your LA for any errors
4
The Westfield Centre – Lancashire County Council
End of Key Stage Procedures This document covers the end of Key Stage procedures common to Key Stage 1. Guides to the Assessment and Reporting Arrangements for Key Stages in England can be accessed at the Qualifications and Curriculum Development Agency (QCDA) web pages: http://www.qcda.gov.uk/ The Key Stage Wizard Manager provides an easy method of managing the statutory end of Key Stage procedures. There is no requirement for any previous Assessment Manager 7 experience as you will be guided through selecting the required Key Stage Pack(s), selecting the required pupils, entering, editing and validating the results in Marksheets, and generating and printing the reports.
Access Rights Schools may need to set up user access rights through System Manager SQL. See Appendix C. Only members of the Assessment Co-ordinator and Assessment Operator user groups in System Manager SQL have the required access rights to use the Key Stage Wizard Manager within Assessment Manager 7.
5
The Westfield Centre – Lancashire County Council
Key Stage Check List
Process
Completed
Set-up for the 2010 Collection Check Version of SIMS .net (see page 7). User access rights set up through System Manager SQL. Key Stage Wizards imported into Assessment Manager (see page 8).
Assess the Pupils Ensure that all eligible pupils are assessed (see Appendix A).
Enter the Results Key Stage 1 user-defined group created. Key Stage 1 results entered (Teacher Assessments). Key Stage 1 P-Scales entered where relevant. Key Stage 1 reports printed. Key Stage 1 results sent to LA by 18th June 2010. Check the Key Stage 1 Summary of Results received from LA
6
The Westfield Centre – Lancashire County Council
Importing the Key Stage Manager Wizards into Assessment Manager 7 To be able to import and use the Key Stage Wizards, SIMS .net should be version 7.128 (Spring 2010 release) or higher. To check this, within SIMS.net, take route Help | About SIMS.net.
As long as the version is Version 7.128 or above, you will be able to import and use the Key Stage Wizard. If the version of SIMS.net is lower, please contact The Westfield Centre Service Desk on 01772 623222 to request upgrade notes. Click anywhere on the About SIMS .net screen to close it.
7
The Westfield Centre – Lancashire County Council
Importing the Key Stage 1 Wizards. Take route Routines | Data In | Assessment | Import.
NOTE: The following Import message may appear, ensure all options are ticked and select Yes to continue.
This process will take a few minutes to complete.
An Activity log will display.
Click Close.
8
The Westfield Centre – Lancashire County Council
Click on the Browse button to select the file to import from:
Click on the drop-down menu to the right-hand side of the Look in box and Select C:\Program Files\SIMS\SIMS.net\AMPA\England Primary (and Middle Deemed Primary)\Assessment Manager
Select Key Stage 1 Wizard England 2010.XML and click Open.
9
The Westfield Centre – Lancashire County Council
The selected file will now be displayed.
Click Finish. An overlay screen will be presented asking if you want to proceed
Click Yes. NOTE: The import of the Wizards may take some time to complete.
10
The Westfield Centre – Lancashire County Council
Once the import is complete, an Activity Log will be displayed detailing the aspects, templates and reports that have been imported.
If there are any problems with the import, it is possible to Print or Save this log to a suitable location so that you can report any errors to The Westfield Centre Service Desk. Click Close. Assessment Manager now contains everything required to record end of Key Stage 1 2010 and P Scale assessments.
11
The Westfield Centre – Lancashire County Council
Key Stage 1 Creating an Assessment User-Defined Key Stage 1 Pupil Group This process will enable the selection of pupils who are part of the Key Stage 1 2010 assessment process to ensure accurate reporting and analysis both now and in the future. From SIMS.net Homepage, take route Focus | Groups | Assessment Defined Groups. Click New to create a new group.
On the Group Details screen, enter a unique Group Description e.g. KS1 2010 Cohort. Choose Active in the Active Status field and enter a unique name in the Short Name field eg KS110. You may also enter some notes to describe the group membership.
Click Save. It is possible to add a supervisor to the user-defined group to make marksheets available. Click the Browse button to the right of the Current Main Supervisor field.
12
The Westfield Centre – Lancashire County Council
This will open the Manage Group Supervisors dialogue.
Click the Action button and choose Add Supervisor.
Click the Search button to display members of staff and highlight the person who will be the supervisor.
Click OK. From the Supervisor Title field choose Main Supervisor in the Add Supervisor dialogue and click OK.
13
The Westfield Centre – Lancashire County Council
The teacher is displayed in the Manage Group Supervisors dialogue. Click OK to return to the Group Details panel. Click Save.
To add pupils to this group click the Membership hyperlink. Click on the Browse to the right of Effective Date Range.
14
The Westfield Centre – Lancashire County Council
Select Custom dates of 01/05/10 to 31/07/10.
Click OK. Click the Action button and choose Add Member.
The Select Members screen displays. In Group Type field choose Year Group from the drop-down arrow.
15
The Westfield Centre – Lancashire County Council
Click the Browser button
of the Group field.
The Groups Browse will be displayed. Click Search to display the groups.
Select Year 2 and click OK.
The year group will display in the Group field. Click the Search button of the Select Members screen to display the members.
16
The Westfield Centre – Lancashire County Council
The pupils displayed will be those that were on roll during the selected date range.
Highlight all the pupils by clicking on the first pupil, holding down the Shift key and clicking on the last pupil.
Click OK.
17
The Westfield Centre – Lancashire County Council
All the pupils display in the Membership panel. Click Save.
If any Year 2 pupils should not be included in the Key Stage 1 Cohort, right-click on the orange bar to highlight the relevant pupil and choose Remove Membership.
At the prompt click Yes to remove the pupil.
It may be necessary to add pupils from other Year Groups who are being assessed early or late. Click the Action button and choose Add Member.
. 18
The Westfield Centre – Lancashire County Council
Click the Browse button to the right of the Group field.
Click the Search button and choose the required year group.
Click OK.
Click the Search button to display the pupils.
19
The Westfield Centre – Lancashire County Council
Choose the required pupils by holding down the Ctrl key and selecting the pupils.
Click OK. The pupils will display in the Membership section.
Click Save. Click Close to return to the homepage.
20
The Westfield Centre – Lancashire County Council
Entering Key Stage Data Into the Imported Key Stage Wizards NOTE: It is a statutory requirement to report Teacher Assessment (TA) results at Key Stage 1 to the Local Authority. Please refer to Appendix A for Key Stage 1 pupil eligibility. Test results are not required. Once the wizards have been imported into Assessment Manager, take route: Tools | Performance | Assessment | Wizard Manager.
The imported wizards will be displayed. Ensure the Filter is set to Incomplete.
Click on Key Stage 1 England 2010 to highlight it and click Next.
21
The Westfield Centre – Lancashire County Council
You now need to select the group of pupils who are to be assessed for KS1. Click on the focus Browse button.
To select the required group of pupils to be displayed on the marksheet wizards click on the + to expand Assessment User Defined.
22
The Westfield Centre – Lancashire County Council
Highlight the KS1 2010 cohort group created earlier and click Apply.
The selected group(s) will then be displayed on the Select Group screen. At this point it is possible to create marksheets for class (registration) groups but it is only possible to work on one class (registration) group at a time.
Click Next to continue.
23
The Westfield Centre – Lancashire County Council
There are 3 types of Key Stage Marksheets onto which data may be entered:
KS1 A. Teacher Assessment 2010 KS1 B. P Scales (Data Entry) 2010 KS1 C. Test Outcomes (Optional) 2010 The KS1 D. Broadsheet (Review) 2010 marksheet allows the review of results entered through the previous marksheets as part of Key Stage 1 in 2010. The KS1 E Average Point Score Calculator allows the calculation of the Average Point Score. With the Marksheets Filter set to Incomplete, select KS1 A. Teacher Assessment 2010 and click the pencil button to enter/edit pupil results.
24
The Westfield Centre – Lancashire County Council
After a few moments, a marksheet will be displayed on screen that displays the Key Stage 1 cohort group created earlier. The white columns are for data entry and the grey columns are read-only.
For Key Stage 1 only, all subjects are included on one marksheet. See Appendix B for acceptable entries. If you want to print out a copy of this marksheet to give to your class teachers to collect results, Click on the Print
button.
Put a tick in Print Blank Marksheets and if necessary change the Orientation and the Font size.
Click Print.
25
The Westfield Centre – Lancashire County Council
When you have received all the data relating to the pupil results you will have to enter this information into the data entry columns. You can move between the cells using the cursor keys on the keyboard.
If you enter an incorrect result, the screen below will be displayed. Click Close and enter the correct result in the cell.
26
The Westfield Centre – Lancashire County Council
Alternatively, to enter grades you can right-click into a cell and click Select Grade for Cell.
You will be presented with an overlay screen showing acceptable entries for that cell. Highlight the appropriate grade and click Apply & Next button.
This action will enter a grade for the chosen pupil and automatically move down to the next pupil.
27
The Westfield Centre – Lancashire County Council
Once you have finished entering all of the pupil Key Stage 1 Teacher Assessments, click on the Calculate
button.
The final levels will be automatically calculated and displayed in the grey, read-only columns. Where any pupils have missing marks, the final read-only column Missing Entry Check will display a Fail.
NOTE: These fails will disappear when the marksheet is closed.
28
The Westfield Centre – Lancashire County Council
NOTE: If you have not entered results for a pupil because they were assessed at another school or left before being assessed at your school, you may ignore any fails as there are no results to be recorded. If grades have been omitted by mistake, you will need to enter these grades and click on the Calculate
button again to clear the fails.
To print a copy of the marksheet displaying the fails, click on the Calculate button and click on the printer button at the top of the marksheet screen. Select Single Copy from the Print Options box that appears and then click Print.
Once you have entered all of the required data, recalculated and have cleared all of your fails, enter a tick in the Data Entry for this Marksheet is Complete box and click on Save to save your changes.
To close the marksheet click on the Close
button at the top of the page.
29
The Westfield Centre – Lancashire County Council
You will be returned to the list of available Key Stage 1 Marksheets. From the Filter drop down menu select All, and ensure that there is a tick in the Complete box for KS1 A. Teacher Assessment 2010.
You should now enter P Scale information for applicable pupils.
30
The Westfield Centre – Lancashire County Council
Entering P Scale Information Into the Imported Key Stage Wizards P Scale information should only be entered where a pupil has special educational needs and a Teacher Assessment of W (Working towards Level 1). NOTE: When creating a CTF to submit results to the LA, checks will be made to ensure that where a level W has been recorded there is a corresponding P Scale entry. For further information please refer to the P-Scales Supplement in Appendix E. To enter P Scale information, highlight KS1 B. P Scale Data Entry 2010 and click on the Edit Marksheet button.
Pupils who have a Teacher Assessment of W in any area will need to have a corresponding P Scale entry made for the same area on this marksheet.
Once you have entered all of the required data, enter a tick in the Data Entry for this Marksheet is Complete box and click on Save to save your changes.
31
The Westfield Centre – Lancashire County Council
To close the marksheet click on the Close button at the top of the page. On the Marksheets screen ensure that there is a tick in the Complete box for KS1 B. P Scale Data Entry 2010.
The KS1 C. Test Outcomes (Optional) 2010 marksheet can be accessed in the same way as the KS1 A. Teacher Assessments 2010 and the KS1 B. P Scale Data Entry. The entry of Test Outcomes is entirely optional and they will not be used in the standard report to parents. Previewing the Broadsheet Review Marksheet If you wish to view all results which have been entered on the Individual marksheets, from the Marksheets Wizard screen make sure the Filter is set to All and highlight KS1 D. Broadsheet Review 2010. Click the Edit Marksheet button.
32
The Westfield Centre – Lancashire County Council
The Marksheet will display on screen. It is possible to print this marksheet by clicking on the Print icon.
Average Point Score Calculator It is possible to calculate the Average Point Score using this marksheet. From the Marksheets Wizard screen highlight KS1 E Average Point Score Calculator and click the Edit Marksheet button to open.
33
The Westfield Centre – Lancashire County Council
When the KS1 E. Average Point Score Calculator screen is presented, click the Calculate
button.
Click the Save button. Once you have finished entering/reviewing Key Stage 1 data, close down this screen using the Close button in the top right corner.
34
The Westfield Centre – Lancashire County Council
Previewing and Printing Key Stage 1 Reports Before printing individual pupil reports, it will be necessary to check Macro Security settings within Microsoft Word. Please see Appendix D for instructions on how to do this. From SIMS .net Homepage, take route Tools | Performance | Assessment | Wizard Manager.
From the Select Wizard screen ensure the Filter is set to All and highlight the Key Stage 1 England 2010 wizard.
Click Next.
35
The Westfield Centre – Lancashire County Council
The Key Stage 1 2010 group that you created should be displayed.
Click Next. When the Marksheets screen opens, click Next.
The Individual Report Format screen will open.
36
The Westfield Centre – Lancashire County Council
There are two separate reports which can be printed: KS1 P1 Student England 2010 – produces a separate sheet of individual results for each pupil selected. KS1 P2 Comparative England 2010 – produces a percentage summary report of results for the school (2010) and national (2009) at the end of Key Stage 1 split by gender.
To preview a copy of a pupil’s result sheet ensure that KS1 P1 Student England 2010 is highlighted in the report list in the top panel of the screen and select at least one pupil from the bottom panel of the screen. Click on the Preview Report
button.
The system will generate the report for the selected pupil(s).
37
The Westfield Centre – Lancashire County Council
If you are working with Microsoft Word 2003, click the Enable Macros button to enable the Word document to open.
For users of Microsoft Word 2007 click on Options and then Enable this Content with the Word document open.
The selected pupil’s individual Key Stage 1 report will be displayed and will resemble the report on the following page.
38
The Westfield Centre – Lancashire County Council
End of Key Stage 1 Teacher Assessment 2010 Jordan Acton ELM ENGLISH Teacher assessment results Speaking and listening P Level Speaking P Level Listening Reading P Level Reading Writing P Level Writing P Level English MATHEMATICS Teacher assessment result Mathematics P Level Number P Level Using & Applying P Level Shape, Space & Measures P Level Mathematics SCIENCE Teacher assessment result Science P Level Science
W P4 P5 W P5 W P5 P3i
W P5 P4 P4 P2i
1 P2i
Teacher assessment in reading, writing and mathematics is informed by the administration of statutory tasks and/or tests during year 2, unless children are working below level 1. Level 1 and W (working towards level 1) represent achievement below the nationally expected standards for most seven-year-olds. Level 2 is divided into three sublevels for reading, writing and mathematics - 2C, 2B and 2A. Level 2 is the nationally expected level of achievement for children at the end of key stage 1. A level of 3 or above represents achievement above the nationally expected standard for most seven-year-olds. For children with special educational needs working within W, P levels 1–8 are recorded alongside the ‘W’.
39
The Westfield Centre – Lancashire County Council
Close Microsoft Word. You may be asked if you wish to save changes to the selected pupil’s report. Click No and you will be returned to the list of reports. To print all individual reports, ensure that you have KS1 P1 Student England 2010 highlighted in the list of available reports.
Click on the Select All button to select all pupils. At this point, remove the ticks from any pupils for whom you do not wish to print an individual report. Click on the Print Report
button.
To produce the comparative report, with one pupil highlighted on the list of pupils, click on KS1 P2 Comparative England 2010.
This time click on the Print Report
button to print a copy of your school’s results.
A report similar to the one shown on the following page will be printed. Your report can then be copied for distribution to parents with their child’s individual report.
40
The Westfield Centre – Lancashire County Council
COMPARATIVE REPORT This table shows a summary of the National Curriculum assessment results of pupils in the school (2010) and nationally (2009) at the end of Key Stage 1, as a percentage of those eligible for assessment. The number of eligible children is: 62 Figures may not total 100 per cent because of rounding. RESULTS OF TEACHER ASSESSMENT Percentage at each level
Speaking and listening
3 or above
Disapplied Children
Absent Children
96
0
0
0
0
100
0
0
0
2
0
98
0
0
0
National
2
11
65
21
0
0
Boys
4
0
0
96
0
0
0
0
Girls
0
0
0
100
0
0
0
0
Whole School
2
0
0
98
0
0
0
0
National
3
13
12
22
24
26
0
0
Boys
4
0
14
82
0
0
0
0
Girls
0
0
12
88
0
0
0
0
Whole School
2
0
13
85
0
0
0
0
National
4
15
21
28
20
12
0
0
Boys
4
0
64
14
18
0
0
0
Girls
0
0
65
12
24
0
0
0
Whole School
2
0
65
13
21
0
0
0
National
2
8
16
26
27
21
0
0
W
1
2
2C
2B
2A
3 or above
U
Boys
0
4
96
0
0
Girls
0
0
100
0
0
Whole School
0
2
98
0
0
National
2
9
67
22
W
1
2
Boys
4
0
Girls
0
Whole School
2C
2B
2A
Reading
Writing
Mathematics
Science
W represents children who are working towards level 1, but have not yet achieved the standards needed for level 1. U represents children for whom it is not possible to determine a level. NOTE: You may wish to save a copy of this report to a suitable location on your computer to use for Reports to Governors etc in the Autumn 2010 Term.
41
The Westfield Centre – Lancashire County Council
Uploading Individual Reports to Pupil Records (Optional) With the Key Stage 1 wizard open ensure that you have KS1 P1 Student England 2010 highlighted in the list of available reports.
Click on the Select All button to select all the pupils (you could, at this point, remove the ticks from any pupils for whom you do not wish to upload an individual report). Note: This process is optional and due to the memory-intensive nature of this routine it may take some time to complete. Click on the Upload Report button.
You will see a status bar on the screen indicating the progress of the upload. When this disappears the reports have been uploaded.
The reports are now available for viewing directly from the pupil record in SIMS .net. Click Finish to close the Key Stage wizard screen. 42
The Westfield Centre – Lancashire County Council
Viewing the Report in SIMS .net In SIMS .net select Focus | Pupil | Pupil Details to display the Find Student browse. Enter the pupil’s Surname and click Search.
Any matching pupil names will be displayed in the list. Either double-click on the required pupil’s name or highlight the pupil’s name and click on Open. The Pupil Details screen will be displayed.
From the Links menu on the click on Linked Documents. A list of all documents attached to the pupil record will be displayed. From the list select the required report and click Open.
43
The Westfield Centre – Lancashire County Council
The Edit Note/Document window will be displayed.
Click on View. Click OK to the read only message.
A read only document will open in Word and can be printed if required.
44
The Westfield Centre – Lancashire County Council
Sending Key Stage 1 Results to Your LA Using SIMS.net Key Stage 1 results should be sent to your LA by 18th June 2010. Only one CTF should be created and submitted to your LA. Schools are asked to run a Missing Postcode Check report prior to creating a CTF – this report is available for download from The Westfield Centre website (see below).
Missing Postcode Check If you have already downloaded and imported this report as part of the Foundation Stage Profile processes, you can move straight to running the report on page 48. Go to The Westfield Centre website at www.westfield.lancsngfl.ac.uk. Click on SIMS .net Reports at the left of the Homepage. Click on Other Reports. The FSP / Key Stage Missing Postcode Check Report is listed.
45
The Westfield Centre – Lancashire County Council
Right-click on the FSP / Key Stage Missing Postcode report link and choose to Save Target As.
Save the report in route C:\Program Files\SIMS\SIMS .net. Click Close once the download is complete. From the SIMS .net Homepage, take route Reports | Import to import the report. Click on Open.
46
The Westfield Centre – Lancashire County Council
Highlight the FSP - Key Stage Missing Postcode.RptDef report downloaded from The Westfield Centre website and click Open.
Click Import.
Once the report has been imported, click Close.
47
The Westfield Centre – Lancashire County Council
Running the Missing Postcode Check To run the imported report, from the SIMS .net Homepage take route Reports | Run Report. Click on the + next to Focus and click on the Student folder. Highlight the FSP / Key Stage Missing Postcode Check report. Click Run.
Click Bypass effective date (Use Today). Tick the required year group(s) i.e. Year 2 for Key Stage 1. Click OK.
Any pupils who have a missing postcode will be listed. These pupils will need to have a valid address and postcode entered for them prior to creating a CTF to submit Key Stage 1 results to the LA.
48
The Westfield Centre – Lancashire County Council
Creating a Common Transfer File to Send to the LA From the Homepage of SIMS .net take route Tools | Setup | CTF.
Ensure that the Directory Details on panel 1 are as follows: CTF import directory - S: \SIMS\Star\CTFIN CTF Export directory - S: \SIMS\Star\CTFOUT
The Collect Attendance Data From field on panel 3 should be populated with SIMS Attendance Module and Include KS1 Tasks/Tests should be ticked. If you make any changes click Save and then click Close.
49
The Westfield Centre – Lancashire County Council
To set up Lancashire LEA Key Stage as a destination school, take route Tools | Other Schools.
Click Search and check if Lancashire LEA Key Stage School No 3951 already exists.
If Lancashire LEA Key Stage is not available, click on New. Enter a School Name of Lancashire LA Key Stage.
Click on the Browse button to the right of LA.
50
The Westfield Centre – Lancashire County Council
Enter LA number 888 and click Search.
Ensure Lancashire is highlighted and click OK.
Enter the Establishment Number 3951.
Choose a School Phase of Multiple Phases (not Middle, Special or PRU). Tick Destination in the School Purpose panel. Click Save. Click Close
.
51
The Westfield Centre – Lancashire County Council
To create the Common Transfer File. From the Homepage of SIMS .net take route Routines | Data Out | CTF | Export CTF.
Before selecting pupils, place a tick in Include students already exported. Click on Refresh Students.
Click on the arrow to the right of the column heading Year and select 2 from the dropdown list. NOTE: There may already be information in the Previous Destination column. This could be because information was sent to the LA regarding Foundation Stage Profile assessments when the pupil was in Reception.
52
The Westfield Centre – Lancashire County Council
Right-click in one of the cells under Destination School and left-click on Select All. This will select all of the Year 2 pupils in the list.
With all of the Year 2 pupils selected, left-click in the first cell in the Destination School column and select Lancashire LA Key Stage from the list of destination schools. This will tag all of the selected pupils with a destination school of Lancashire LA Key Stage.
NOTE: If you have pupils from more than one year group, rather than selecting just Year 2 pupils, you will need to use Ctrl + left click to cherry pick those pupils who make up the Key Stage 1 Cohort. To attach the Destination School to these pupils, click in the destination school cell of the last pupil highlighted and select Lancashire LA Key Stage from the list of destination schools.
53
The Westfield Centre – Lancashire County Council
To create the CTF, click on Export CTF at the bottom of the list of pupils names.
An overlay screen may be presented at this point. Cick Yes to continue with CTF Export.
Once the CTF export has finished, an Export Complete screen will be displayed.
Make a note of the CTF filename and click OK.
54
The Westfield Centre – Lancashire County Council
Information will be displayed in the Exception Log pane including: Number of students in file Number of students processed Number of students not exported Any students identified as having errors will be displayed..
Click Close.
To check that you have the correct number of pupils in the CTF file, from SIMS .net Homepage, take route Routines | Data Out | CTF | View Export History Log.
55
The Westfield Centre – Lancashire County Council
Click the Search button. The CTF will be displayed along with a list of pupils included in this file.
Click the Preview button. A Word report resembling the image below will enable you to view the pupils in the CTF file. If pupils are missing from this list, you will need to discard this CTF and create a new one.
Close the Word report. The CTF that has been created is now stored in the S:\SIMS\star\ctfout folder and will need to be copied to the Anycout folder on drive C:\. 56
The Westfield Centre – Lancashire County Council
Copying the Common Transfer File to Anycout To copy the created CTF file to the anycout folder, you will need to open Windows Explorer. Right-click on the Start button
on your opening desktop screen.
Left-click on Explore from the drop down list that appears.
Click on the arrow next to the Views button on the Explorer toolbar and select Details from the drop down list.
Scroll to the bottom of the left-hand side of the screen and locate your S: drive. Click on the + to expand the drive. You should then be able to see your SIMS folder.
Click on the + button to expand the SIMS folder. Click on the + button to expand the STAR folder and finally double-click on the CTFOUT folder. 57
The Westfield Centre – Lancashire County Council
You should now see the CTF created earlier, displayed on the right-hand side of the screen. Right-click on this file. Left-click on the option to Copy from the drop-down list that appears.
Scroll to the top of the left-hand side of the screen and locate your C: drive and doubleclick on it.
58
The Westfield Centre – Lancashire County Council
Right-click on the anycout folder on the right-hand side of the screen and left-click on the option to Paste that appears on the drop-down list.
To check that the CTF has been copied to the anycout folder, double-click on it and the copied CTF should be displayed on the right-hand side of the screen.
You can now Close down Windows Explorer
59
The Westfield Centre – Lancashire County Council
Sending the Common Transfer File to the LA via Anycomms Once the Common Transfer File is in the Anycout folder it can be forward to County Hall. NOTE: This procedure can only be carried out on on the machine that is linked to Anycomms. Double-click on the AnyComms Client icon on your opening desktop screen.
The AnyComms Client program will open. Click on the Start Call button.
The call will then begin. AnyComms Client will then check if there are any files waiting to be sent or received. It will upload any files you are sending to the LA from the anycout folder and will download any files from County Hall into your anycin folder.
60
The Westfield Centre – Lancashire County Council
Once files have been sent and/or received sucessfully, you will be presented with a screen resembling the screen below. This screen will contain information of any files transferred to or from your system via AnyComms.
61
The Westfield Centre – Lancashire County Council
Checking the summary of results sent from the LA Once you have sent your CTF file to the Local Authority using Anycomms, the Professional Support Team will process your data within ten working days. You will receive a file via Lancashire ROSE containing a brief summary of the school’s results:
The school is required to check these results carefully, verify that they are accurate and confirm that they can be submitted to the DCSF. This will be done via the Schools Portal E-Form, a link to which is displayed on the bottom of your results file. Without a response Lancashire County Council cannot submit your results to the DCSF. If the results are incorrect, you can notify the Professional Support Team using the link on the bottom of the results checking sheet. Please make changes to the data in SIMS Assessment Manager and create a new CTF file to send via Avco Anycomms (see page 49). If you are having difficulty correctly generating the CTF file from SIMS, please contact the Westfield Centre for assistance. On receipt of a new CTF file from a school, Lancashire County Council will upload a new version of the checking file to Lancashire ROSE for the school to again check and confirm for submission. Subject to confirmation from the school, the results are processed by the local authority and sent to the DCSF to form part of the national data set, which in turn is passed to other official sources. The National Data Set will close on the 31 st July and schools submitting corrections to their data after this date risk other datasets being inaccurate (e.g. LSIP, RAISE Online, FFT).
62
The Westfield Centre – Lancashire County Council
Appendix A – Pupil Eligibility for Key Stage 1 Key Stage 1 Results Teacher Assessment results are required for all sections of the Key Stage 1; Speaking and Listening (EN1), Reading (EN2), Writing (EN3), Maths (MASUB), Science: Scientific Enquiry (SC1), Science: Life Processes (SC2), Science: Materials (SC3), Science: Physical Processes (SC4), Science Overall (SCSUB). Test results can still be recorded by the school, but they are not statutory, and as such are not collected by Lancashire County Council. P-Scales are statutory and are required for each element / subject where a W is given under National Curriculum assessment.
Pupil Eligibility Key Stage 1 results are required for all pupils at the school subject to the following stipulations: Results must be submitted for all pupils who are leaving Year 2 in 2010 to start Year 3 in academic year 2010/11, either at this school, or at another school. On the rare occasion that a pupil is being held back to repeat the Year 2 in academic year 2010/11, they are not counted as leaving Year 2, therefore their results should not be submitted this year, but next year when they leave Year 2.
Pupils moving school Where a pupil moves school during the summer term, either the current school or the new school must submit results depending on when the pupil actually started at their new school: If a pupil starts at their new school prior to 31 May 2010, the new school must report the results to the Local Authority If a pupil starts at their new school on or after 31 May 2010, the previous school must report the results to the Local Authority For further assistance with pupils moving school, please telephone the Professional Support Team helpline on 01772 531555. Newly arrived pupils Where a child has recently arrived from abroad, the school should make every effort to make a teacher assessment of the child and submit the results. If a child arrives too late in the summer term for the assessment to be carried out (after 1 July), then A should be entered for the child to indicate insufficient information to assess. If a late assessment cannot be made as the child does not speak English, W should be reported for English with EAL in the relevant P-Scales, and D should be recorded for Maths and Science.
63
The Westfield Centre – Lancashire County Council
Children with Special Educational Needs Where a pupil is not working at the national curriculum level, it is a statutory requirement for the pupil to be assessed using P-Scales. In Lancashire, many schools use PIVATS to assess pupils, and these PIVATS levels should be converted to P-Scales for the data collection using the Conversion Table. In the main assessment sheet, W should be entered for the national curriculum assessment, and in the separate P-Scales section, the P-Scale scores should be entered. Results cannot be submitted for a pupil where W is given as NC level, but no corresponding P-Scale is given. Absent Pupils Where a valid teacher assessment cannot be made due to long periods of absence, it is possible to submit an A for their assessment. Absent should not be used where the pupil has had short absence covering the tests; as teacher assessment is statutorily required and can be completed based on the pupil's work during class throughout the year, rather than the tasks or tests. Disapplication There are a very small number of pupils who may not be able to access the tasks or the tests, for example due to physical disabilities. These children should not be recorded as D. The tasks and tests make up one piece of evidence towards the teacher assessment; therefore the teacher assessment should be completed through work completed in class throughout the year. In very exceptional circumstances, a pupil may be disapplied from Key Stage 1 and only after discussion with the Assessment Coordinator at Lancashire County Council. For further assistance with disapplied pupils, please telephone 01772 531555.
64
The Westfield Centre – Lancashire County Council
Appendix B - KS1 Acceptable Entries Marksheet KS1 A. Teacher Assessments 2010
KS1 B P Scale Data Entry 2010
KS1 C. Test Outcomes (Optional) 2010
Column Heading EN AT1 Speak and Listen
}
EN AT2 Reading EN AT3 Writing MA TA Maths Subject
} } }
SC AT1 Scientific Enq SC AT2 Life Processes SC AT3 Materials SC AT4 Phys Process
} } } }
Acceptable Entries 6, 5, 4+, 4, 3, 2, 1, W, D, A 6, 5, 4+, 4, 3, 2A, 2B, 2C, 1, W, D, A
6, 5, 4+, 4, 3, 2, 1, W, D, A
P8, P7, P6, P5, P4, EAL P8, P7, P6, P5, P4, EAL P8, P7, P6, P5, P4, EAL P8, P7, P6, P5, P4, EAL P3ii, P3i, P2ii, P2i, P1ii, P1i, EAL P8, P7, P6, P5, P4, EAL P8, P7, P6, P5, P4, EAL P8, P7, P6, P5, P4, EAL P3ii, P3i, P2ii, P2i, P1ii, P1i, EAL P8, P7, P6, P5, P4, P3ii, P3i, P2ii, P2i, P1ii, P1i, EAL 2a, 2b, 2c, 1, W, L, D, A 0 – 29 2a, 2b, 2c, L, D, A, B 0 – 30 3, L, D, A, B 0 – 30 3, 2a, 2b, 2c, L, D, A, B 69 – 141 0–3 0 – 20 0–7
P Scale: Speaking P Scale: Listening P Scale: Reading P Scale: Writing P Scale: English P Scale: Number P Scale: Using & Applying P Scale: Shape Space Meas P Scale: Maths P Scale: Science Reading Task Level Read Test Score Lev 2 Read Test Grade Lev 2 Read Test Score Lev 3 Read Test Grade Lev 3 Read Test Score Read Test Level Read Std Score Handwriting Score Spell Raw Score Spelling Test Mark 65
The Westfield Centre – Lancashire County Council
0 – 18 0 – 12 0 – 40 3, 2a, 2b, 2c, 1, W, D, A 0 – 30 2a, 2b, 2c, 1, W, D, A, L, B 0 – 30 3, D, A, L, B 3, 2a, 2b, 2c, 1, W, D, A, L, B 69 - 141
Writing Long Score Writing Short Score Writing Task Score Writing Task Level Maths Test Score Lev 2 Maths Test Grade Lev 2 Maths Test Score Lev 3 Maths Test Grade Lev 3 Maths Test Level Maths Age Std Score
NOTE: For Maths, Reading and Writing in Key Stage 1 only, the grades 2a, 2b and 2c should be used instead of 2.
66
The Westfield Centre – Lancashire County Council
Appendix C - Setting up Users Through System Manager Your system in school will already hold details of ALL people known to SIMS (i.e. those members of staff who have been entered into STAR or Personnel) including Teaching staff, Administrative staff, Site Supervisors and Cleaners, Pupils and their Contacts. Your first task in System Manager is to give the appropriate people access rights.
Adding existing people Log into SIMS.net as a user who has System Manager access rights. Click Focus | System.
NOTE: If you experience difficulties at this point you may need to contact The Westfield Centre Service Desk on 01772 623222.
67
The Westfield Centre – Lancashire County Council
When System Manager opens, you should see the Welcome screen. If it does not show click on Tools on the menu bar and then select Show Welcome Screen. Select the first option to Add Existing People as Users of the System.
Highlight the relevant user(s) and then click on the Choose button. NOTE: If the required user does not appear in the top half of the screen, you will need to check that they have been entered in the Personnel module of SIMS .net.
The selected names will now appear in the lower window. Click on Update.
68
The Westfield Centre – Lancashire County Council
Assigning Users to Groups If you need to be able to carry out all tasks detailed within this booklet regardless of your role in school, you will need to be a member of the Assessment Co-ordinator User Group. Click on the Browse button to the right of Select a User Group and from the drop-down list select the appropriate User Group e.g. Assessment Co-ordinator or Assessment Operator.
Click on Assign Users to User group.
69
The Westfield Centre – Lancashire County Council
Highlight the relevant user and click on Choose.
Click on Update. Close the Welcome to System Manager screen. Close System Manager.
70
The Westfield Centre – Lancashire County Council
Appendix D – Macro Security Settings For Users of Microsoft Word 2003 Open Microsoft Word 2003 and take route Tools | Macro | Security. Ensure that Medium is selected and click OK.
Close Microsoft Word 2003. When previewng Individual Pupil reports through the Assessment Manager 7 Wizards with Microsoft Word 2003, you may see a screen similar to the one shown below.
You will need to select Enable Macros for the reports to run.
71
The Westfield Centre – Lancashire County Council
For Users of Microsoft Word 2007 Open Microsoft Word 2007 and click on the Office Button Select Word Options
.
from the bottom right-hand corner of the screen.
Select Trust Center from the left-hand side of the screen. Click on Trust Center Settings.
72
The Westfield Centre – Lancashire County Council
Ensure that Macro Settings is selected on the left-hand side of the screen and select Disable all macros with notification under Macro Settings.
Click OK. Click OK a second time. Close Microsoft Word 2007. When previewing Individual Pupil reports through the Assessment Manager 7 Wizards with Microsoft Word 2007, the reports will show on screen but you may see a Security Warning message in the top left-hand corner of the screen. Click Options.
Ensure that Enable this content is selected.
Click OK.
73
The Westfield Centre – Lancashire County Council
Appendix E – P-Scales supplement 5.5 P Scales The use of P Scales have been statutory since 2008 for children with special educational needs who are working below level 1 of the national curriculum. Schools will need to use P Scales to record and report the achievements of those children in the core subjects of English, Mathematics and Science. The P Scales are not to be used to assess children below year 1 whatever their needs or children with English as an additional language (EAL) at any age unless they have additional special educational needs. P Scales are appropriate across key stage 1 and should be applied to children working towards national curriculum level 1 (i.e. level W – for working below the level of the task or test) who have been identified as having special educational needs. The performance descriptions for P1-P3 are common across all subjects. They outline the types and range of general performance that children with learning difficulties who are not working at levels P4-P8 might characteristically demonstrate. The P Scale descriptions can be found on the QCDA website at www.qcda.gov.uk/8541.aspx. The P Scale attainment targets are referred to as P Levels in some guidance and legislation. Using the P Scales DVD is available from the QCDA orderline at http://orderline.qcda.gov.uk or by calling 08700 60 60 15. Further information is available from
[email protected]. This means that if a child is at P1i-P3ii level in English, then reading, writing, speaking or listening levels would not be normally be appropriate, only an overall P-Scale for English. If a child is at an English level higher than P3ii, then the relevant separate levels P4-P8 in reading writing, speaking or listening are appropriate and an overall P-Scale for English is not expected. The position is similar in respect of mathematics, number, using and applying mathematics, and shape, space and measures. For science, a single level from P1i-P8 is appropriate. Extract from: Assessment and Reporting Arrangements (ARA), Foundation Stage / Key Stage 1, Page 25
© Qualifications and Curriculum Development Agency, 2010 For more information, please visit: http://www.qcda.org.uk/
74
The Westfield Centre – Lancashire County Council
Reportable levels for P Scales P Scale Subject
Reportable Levels
English
P1i, P1ii, P2i, P2ii, P3i, P3ii
Reading Writing Speaking
P4, P5, P6, P7, P8
Listening
Mathematics Number Using and applying mathematics Shape, space and measure
Science
P1i, P1ii, P2i, P2ii, P3i, P3ii
P4, P5, P6, P7, P8
P1i, P1ii, P2i, P2ii, P3i, P3ii, P4, P5, P6, P7, P8
Extract from: Assessment and Reporting Arrangements (ARA), Foundation Stage / Key Stage 1, Page 25 © Qualifications and Curriculum Development Agency, 2010 For more information, please visit: www.qcda.org.uk
75
The Westfield Centre – Lancashire County Council
Examples Example 1: Pupil 1 has a statement of SEN for ASD and is expected to perform below level 1, and around P2-P3 level on P-Scales. P-Scales: Pupil 1 has special educational needs, and is performing at the lower end of the PScales. In the main assessment for Key Stage 1, W should be entered for the relevant subjects. Then P Scales for English, Mathematics and Science are to be entered, but no sub levels for English and Mathematics, as the pupil is below P4: Main
English
W
Mathematics
W
Science
W
P-Scales
English
P2ii
Mathematics
P3i
Science
P3i
P-Scales Sub-Levels
Reading Writing Speaking Listening
-----
Number Using and applying Shape, space and measure
----
Example 2: Pupil 2 has varied results at Key Stage 1 and is assessed as level 1 in mathematics and science, but just below level 1 for English. P-Scales: Pupil 2 should be assessed as usual for Mathematics and Science, and the relevant score of 1 entered for each subject. For English in the main assessment the pupil should be marked as W, and then assessed using the sub levels of English if the assessment is between P4 and P8. Main
English
W
Mathematics
1
Science
1
P-Scales
English
--
Mathematics
--
Science
--
P-Scales Sub-Levels
Reading Writing Speaking Listening
P7 P6 P8 P7
Number Using and applying Shape, space and measure
----
76
