Welcome to the SIMS Software Update Seminar 2007

1. Welcome to the SIMS Software Update Seminar 2007 Pat Webb National Customer Services Manager

2. Housekeeping

3. Core and Attendance Update

4. So far this Year�. May 2007 Attendance 7 Lesson Monitor 7 Home Page UDF Movement Report Card August 2007 Attendance Statutory Changes Lesson Monitor Reports Quick Letter Parental Consent CBDS changes Every day an astonishing 400,000 pupils are not in school Pause on first bullet and 10% of those are absent without school permission/knowledge. Forward next 3. The short term impact of that is their attainment is lower than their class mates. Forward Slide The long term impact is that they have a bleak future, they do less well in exams, are less likely to secure a good job and ultimately more likely to be come involved with crime. Every day an astonishing 400,000 pupils are not in school Pause on first bullet and 10% of those are absent without school permission/knowledge. Forward next 3. The short term impact of that is their attainment is lower than their class mates. Forward Slide The long term impact is that they have a bleak future, they do less well in exams, are less likely to secure a good job and ultimately more likely to be come involved with crime.

5. Attendance Changes�.. Statutory Changes Recording �Exceptional Circumstances� Recording a reason for a change of a reason for absence. So how can electronic registration help. It�s a well recognised fact that students in school do better � certainly they learn different things! It has also been proven that recording lesson attendance has a positive impact on attendance, indeed reducing unauthorised attendance by a staggering 10% over 2 years. If implemented well and used effectively.So how can electronic registration help. It�s a well recognised fact that students in school do better � certainly they learn different things! It has also been proven that recording lesson attendance has a positive impact on attendance, indeed reducing unauthorised attendance by a staggering 10% over 2 years. If implemented well and used effectively.

6. The Rest of the Year�� November 2007 Address Tidy functionality Report Card data in Report Dictionary Quick Letter February 2008 OMR Functionality Bulk Address Validation Document Manager Server ATF statutory changes Every day an astonishing 400,000 pupils are not in school Pause on first bullet and 10% of those are absent without school permission/knowledge. Forward next 3. The short term impact of that is their attainment is lower than their class mates. Forward Slide The long term impact is that they have a bleak future, they do less well in exams, are less likely to secure a good job and ultimately more likely to be come involved with crime. Every day an astonishing 400,000 pupils are not in school Pause on first bullet and 10% of those are absent without school permission/knowledge. Forward next 3. The short term impact of that is their attainment is lower than their class mates. Forward Slide The long term impact is that they have a bleak future, they do less well in exams, are less likely to secure a good job and ultimately more likely to be come involved with crime.

7. STAR 2008 � Document Manager Server Permissions on the Documents House Keeping SIMS Home Page�. Assessment Data Behaviour and Achievement Data SIMS Alerts�. Ability to send to a group of people Ability to send to people associated with a pupil Ability to send by role Schedule reports � last X days Message by email Teachers Student View

8. Assessment Data on the Home Page

9. Attendance 2008 � Take Register� Use of any Key on the Keyboard. Offline Working? Switch between Register and the Mark sheet for the Class. Extra Identifiers (SEN, G&T, Behaviour incident today) Toggle between codes. Attendance 34 Attendance Reports Attendance Setups DCSF Codes

10. Individual Report Full Register Report Individual�s Subject Attendance Summary Student Lesson Attendance by Class Percentage Lesson Attendance Report Student Weekly Lesson Attendance Report Group Lesson Attendance by Category Report Group Weekly Lesson Attendance Report Lesson Absence Report Minutes Late report Comparison report Lesson Monitor Reports��

11. Comments Report Class Register Student Lesson Attendance by Subjects Student Lesson Attendance by Category Today�s Register Report New Absentee�s report Periods with chosen code Report Post Registration Absence Report Registers with missing Marks report History of Changes Report More Reports��

12. Performanceand CurriculumSuites

13. August 07

14. Allow Editing Results Sets in a Template SIMS Assessment Manager 7Polishing Project

15. Improved Assessment Manager Link from Student Details By displaying Aspects, duplicates can be identified and suppressed. SIMS Assessment Manager 7Polishing Project

16. Additional Attendance data items in AM 7 reports Lesson attendance Minutes Late Lessons Late Behaviour points Achievement points SIMS Assessment Manager 7Polishing Project Added Class and Teacher Name Sort options by Class Teacher or Name Global ReportAdded Class and Teacher Name Sort options by Class Teacher or Name Global Report

17. Notes in Marksheet Hover over the red triangle to display the Note Ability to edit saved Notes Ability to add a Note to saved data SIMS Assessment Manager 7Polishing Project

18. November 07

19. Assessment Manager 6 will disappear. Assessment Manager 7 will show in the Focus Menu. AM6 Individual Report Templates will still be able to be converted. Schools must clone any Capita Report Templates that they use before November AM5 data that has not been converted to AM6 will not be available in AM7, convert this to AM6 before November SIMS Assessment Manager 7Polishing Project Have you moved to AM7Have you moved to AM7

20. Enhancements to Marksheet Printing Select Font Size Fit to Page Print Preview Enhancements to Bulk Marksheet Printing Select Font Size Fit to Page Print Summary Rows SIMS Assessment Manager 7Polishing Project

21. Free MS Word 2003 Viewer to work without Office 2003 With Word Viewer 2003, you can view, print, and copy document contents to another program. However, you cannot edit an open document, save a document, or create a new document. SIMS Assessment Manager 7Polishing Project

22. Reduce the number of clicks when moving aspects SIMS Assessment Manager 7Polishing Project

23. PA7 Graphing Tool to show Multiple Pie Charts SIMS Assessment Manager 7Polishing Project

24. PA7 Graphing � All Series to change type at once. SIMS Assessment Manager 7Polishing Project Do you use the Analysis Screens (PA7)?Do you use the Analysis Screens (PA7)?

25. February 08

26. Profiles 7 Checking Screen

27. Review Show all text written for student. Check Spell Check. Edit text. Add own comments in Pastoral Overview Area. Approve Mark report as approved. Notify teacher of Non Approved reports via Alerts. Run a report to list Non Approved Sections

28. May 08

29. Cover 7 New Features Classroom Staff absence recorded in Cover Management is automatically included in P7�s staff absence data. Intuitive Cover Diary display shows the day�s absences and room closures and the resulting cover requirements, and suggests which resources to assign according to rules set up by the school. Unlimited �knock-on� cover arrangements. Assign additional resources (staff and rooms) to lessons

30. Cover 7 New Features Supply staff booking system Assign external volunteers and students (e.g. parents) to lessons in the same manner as staff. Accurately tally cover done by staff in terms of time, in support of the Workforce Reform 37 hour cover limit.

31. Cover 7 New Features Student impact analysis takes in to account student attendance! Suspend classes for individual periods, not just whole days. �Semi-automatic� cover mode suggests the teacher/room to use then moves on to the next problem to solve.

32. Cover 7 Links Cover 7 reads the timetable imported from Nova T4/T6 Cover 7 reads classroom staff absences entered through P7 Cover 7 writes classroom staff absences to P7 Proposed Cover 7 writes Service Agreements to P7 when Supply staff are booked Home Page Timeline shows Cover data (and in future any 3rd part timetabling software which submits data to the Curriculum Matching wizard.) (and in future any 3rd part timetabling software which submits data to the Curriculum Matching wizard.)

33. AcademicManagementAlternativeCurriculum

34. Academic ManagementAlternative Curriculum Assigning particular students to activities outside of their normal eligibility structure These activities may be part of a special area of the curriculum plan, eligibility for which does not derive from membership of a school year and band. A typical feature of alternative curriculum is that the amount of time a particular student spends doing an activity will vary.

35. Academic ManagementAlternative Curriculum The process of creation and maintenance of student timetables becomes; Assign students to �normal� activities (classes) Immediately, or at some later time, assign students to alternative curriculum activities Identify and resolve clashes at affected periods as required.

36. Nova-T Printing Reports (General Student reports and Class lists) Death dates for Nova T4 are: For Timetable construction Sept 2008 For Cover Feb 2009 For Reporting 12 months from replacement Replacement of Nova-T4

37. A Primary School Vision for SIMS

38. Agenda Developments to support use of SIMS in the primary school classroom Primary Review Project Dinner Money 7 Primary Curriculum Solution Training and Documentation

39. Primary Review Project  Key Features and Benefits Create a simpler interface for classroom use; Improve marksheet features; Provide new Pupil Tracking Marksheets and Reports; AMPA to be upgraded by release; Quicker and easier to understand and use. Simplify data interrogation and analysis. Encourage effective use of data. Avoid use of out-dated, invalid grade sets.

40. We plan to include as filters the above RAISEonline filters, including term of birth (not currently available in SIMS). We plan to include as filters the above RAISEonline filters, including term of birth (not currently available in SIMS).

41. At the moment a right-click on a result columns will give access to a table showing the distribution of grades in that column. We plan to take this a stage further and provide a graph of the grade distribution.At the moment a right-click on a result columns will give access to a table showing the distribution of grades in that column. We plan to take this a stage further and provide a graph of the grade distribution.

42. There will be options to customise the graph format and to print it. The new filtering options will be applicable to the graphing functions, to make it more useful as an analysis tool within the marksheet.There will be options to customise the graph format and to print it. The new filtering options will be applicable to the graphing functions, to make it more useful as an analysis tool within the marksheet.

43. Example pupil tracking grid introduced by the Primary National Strategy as part of the Intensifying Support Programme. Often used on a termly basis to track all pupils� progress in all years, to ensure none go unnoticed, with the names typed into Word or Excel or handwritten.Example pupil tracking grid introduced by the Primary National Strategy as part of the Intensifying Support Programme. Often used on a termly basis to track all pupils� progress in all years, to ensure none go unnoticed, with the names typed into Word or Excel or handwritten.

44. Once the data is in the tracking marksheets the tracking reports can be populated instantly, to give an immediate visual understanding of individual pupils� progress. The reports will be set up ready to use with the marksheets, but LAs/schools will be able to customise them. There will be a number of output options for these reports, including yearly and termly progress, and also what in Performance Analysis are called �Chance Analysis�, which shows each pupil�s current progress against their expected progress based on previous SATs results.Once the data is in the tracking marksheets the tracking reports can be populated instantly, to give an immediate visual understanding of individual pupils� progress. The reports will be set up ready to use with the marksheets, but LAs/schools will be able to customise them. There will be a number of output options for these reports, including yearly and termly progress, and also what in Performance Analysis are called �Chance Analysis�, which shows each pupil�s current progress against their expected progress based on previous SATs results.

45. Primary Curriculum solution Key Features and Benefits Allows primary schools to create Teaching Groups from combined Registration Groups Create Marksheets for these Teaching Groups; Assign Teaching Plans to Teaching Groups; Generate reports for each Teaching group.

47. SIMS Technical Briefing Jonathan Wood Product Manager (Technical and Releases)

48. Technical Briefing Summary This year has seen a number of Technical changes Migrations Move to Personnel 7 Move to FMS on a Microsoft SQL Server Platform Move to Microsoft SQL Server 2005 from 2000 System Manager Trusted User logon Support Vista Office 2007

49. Personnel 7 Conversion Conversion from Personnel 5 to Personnel 7. In SIMS .net Uses SQL Server Conversion steps Run Data Check to authenticate the data Run P5 migration licence Run P5 conversion utility to migrate the data. Can convert up until 31st December 2007 41 working days left to convert before Capita Support ends

50. FMS SQL Migration Moving to SQLServer2005 from Sybase SQLAnywhere Benefits Industry strength database More maintainable and easier to support. Steps to convert Upgrade to FMS6.85 (on the August release) Apply the migration licence patch Run DBValid to authenticate the data Run FMSMigration utility to migrate the data FMS version is now 6.91 using Microsoft SQL2005! Can convert until August 2008 or until the CFR is due. Maximum of 208 working days left before Capita Support ends

51. SIMS SQL 2005 Migration Move from Microsoft SQL Server 2000 to SQL Server 2005 Why did we Change? Microsoft support for MSSQL 2000 has stopped Increased maximum Storage space Better Multi-user performance What is the change? Beta released in July. Moving SQL 2000 to SQL 2005 Moving MSDE to SQL Express 2005

52. SIMS SQL 2005 Timescales How to convert Upgrade to SIMS August 2007 or SIMS September 2007. Use the SIMSSQL2005.exe tool to install SQL2005 and convert. The original SQL Server is still intact Primary Schools Can convert after August 2007 and before applying February 2008. Minimum of 64 working days left. Secondary Schools Can convert after August 2007 and before applying November 2007 Main releases. Minimum of 4 working days left.

53. System Manager 6.9 Released in August 2007 Ability to setup your logon to use Trusted logon SIMS will use your windows logon to authenticate the user. Less passwords to remember Can be setup to be workstation specific ConnectionType=Trusted / SQL

54. Trusted Login Setup user as trusted in system manager Login as Trusted

55. Changes to Supported Operating Systems The following Operating Systems are Supported Workstation Windows Vista (New) Windows XP Windows 2000 (until February 08) Microsoft Office 2003 Microsoft Office 2007 (New)

56. SIMS Installable Release Released on 3rd October. Sent on DvD to all LA�s. Replaces the last installable from February 2006 We plan to have 1 installable release a year Installs the SIMS 2007 September Update release. Contains SQL2005 Express.

57. Forthcoming Year Windows Server 2007/2008 (Longhorn) is released SIMS Support date to be decided Will replace support for Windows 2000 Server Update to Hardware Requirements Document SIMS Installation/Updates Aim to reduce the footprint of the client update Investigate mechanisms for auto update of client workstations

58. Projects Moving the Reporting Engine to use Microsoft SQLServer 2005 Reporting Services. Increases performance and maintainability Should allow more complex reports Enabled by move to SQL2005 Released 2009 System Manager 7 System Manager in .NET Supports multiple SIMS Databases Released August 2008

59. Planning for 2008 SQL/FMS6 upgrades Windows 2000 workstations Windows 2000 servers Parental access to attendance data and reports School Workforce Census � data collection and entry in Personnel 7 SIMS in the classroom Off site access to SIMS Key DCFS returns