Transcript SQL SIMS - Somerset County Council elections

An overview of
SQL SIMS
Simon Wood, EdICT
May 2003
SQL SIMS
Simon Wood, EdICT
New Modules
•
•
•
•
•
•
•
Assessment Manager
Attendance
Exams Organiser
Performance Analysis
Profiles
SIMS .NET
System Manager
May 2003
SQL SIMS
Simon Wood, EdICT
Assessment Manager
• Templates
– replace marksheets and group reports
– can be made by LEA and distributed
– aspects still exist, but most schools will no longer
need to have an intimate knowledge of them
• Individual Reports
– based on Word template
• Key Stage Manager
– the new Assessment Manager will replace KSM
May 2003
SQL SIMS
Simon Wood, EdICT
Attendance
• Manual data entry improved
– more efficient
– more flexible
• Reports
– wider range of reports available
• Review Student Marks
– more information presented at student
level
May 2003
SQL SIMS
Simon Wood, EdICT
Attendance Marks
May 2003
SQL SIMS
Simon Wood, EdICT
Summary Information
May 2003
SQL SIMS
Simon Wood, EdICT
Personal Details
Multiple
telephone
numbers
May 2003
SQL SIMS
Simon Wood, EdICT
Performance Analysis
• Replaces, and greatly enhances, AM graphs
• Template-based
– templates will be made by LEA and distributed
• Versatile
– comparatives (e.g.)
• class vs. cohort
• cohort vs. cohort
– value added charts
– target setting
May 2003
SQL SIMS
Simon Wood, EdICT
A Typical Analysis
May 2003
SQL SIMS
Simon Wood, EdICT
SIMS .NET
• Reporting tool
– replaces functionality currently in MIDAS
and RepGen Lite
– reports generated via Word, Excel and
Internet Explorer
• Future releases will replace functionality
in STAR and SENCO (STAR .NET?)
May 2003
SQL SIMS
Simon Wood, EdICT
SIMS .NET
• Protection of sensitive data
– using System Manager, define who sees
what
– essential if data is to be made available
over internet
May 2003
SQL SIMS
Simon Wood, EdICT
SIMS .NET
• Reports
– students, teachers and classes
– can be designed and used immediately,
and saved for future use
– displayed internally, or output to Word,
Excel or Internet Explorer
• Can output to Word as mail merge data file
May 2003
SQL SIMS
Simon Wood, EdICT
Designing a report
How?
What?
Where?
May 2003
SQL SIMS
Simon Wood, EdICT
Report to Excel
May 2003
SQL SIMS
Simon Wood, EdICT
Report to Word
• Select information in SIMS .NET
• Output as Word mail merge data file
• Create letter in Word, drawing on data file as
required:
• Merge to produce letters
• Same facility available within Attendance
May 2003
SQL SIMS
Simon Wood, EdICT
Integrator
• Short-term utility
– Copies data from ‘old’ modules to SQL
modules
– Runs nightly
• needs to be primed at end of each day and
checked following morning
• usually, responsibility of person checking
backups
• Integration problems largely resolved
• Not required once SIMS .NET in use
May 2003
SQL SIMS
Simon Wood, EdICT
The integration process
Core Integrator
nightly @ 9pm
SQL SIMS
‘Old’ SIMS
FMS6
Finance integrator
manually initiated
May 2003
SQL SIMS
Simon Wood, EdICT
The upgrade process
• Installation
– Technician visit
– Takes approximately 3 hours and requires
exclusive use of SIMS
– Visits have been scheduled
– Some schools still need to upgrade their system
• Data-fixing
– Done via proxy connection
– Takes approximately 3 hours and requires
exclusive use of SIMS
– Visits to be scheduled
May 2003
SQL SIMS
Simon Wood, EdICT
Training
• Generally
– Courses at Dillington and Holway for new
modules…
• …however
– individual training visits will be undertaken
where necessary
May 2003
SQL SIMS
Simon Wood, EdICT
Hardware Replacement
• Budget for it!
– Advice still stands to budget for hardware
replacement every 3-4 years
– Some original NGfL server/workstations now 5
years old
• Specifications
– www.six.somerset.gov.uk/six/v.asp?ndid=2201
• “Whole school network”
– Pilots gone well, now in a position to move forward
in Primary schools
– Mike Rothery can advise on purchases
– Update will go out to schools shortly
May 2003
SQL SIMS
Simon Wood, EdICT
NGFL Funding
• Similar to last year
• Schools have received advice - email ref:
– NGfL Funding (Standards Fund 601) for this year
• School ICT Development
Plan
STOP PRESS:
– Updated plan required before funding can be
Schools are not required to submit an ICT
released
Development Plan this year!
– Must utilise new templates available from SiX
• Schools will be notified shortly of the amount
they will receive
May 2003
SQL SIMS
Simon Wood, EdICT