1

Importing Data from Excel into SIMS Assessment

One of my most frequently asked questions is ‘how do I import grades from an Excel spreadsheet into SIMS Assessment Manager. Here’s how: Step 1: Clean the Excel File Ready for Import Open your Excel file and check that the columns you want to import contains the forename and surname of each pupil, preferably in two separate columns. Ideally the spreadsheet should also contain the pupil UPN numbers too, though this is not essential, it will...

KS4 Targets from KS2 Scaled Scores 0

Calculating KS4 Targets from KS2 Scaled Scores using SIMS

Calculating KS4 targets from KS2 scaled scores is something many schools are starting to consider since the new format KS2 results were published in July. Here’s a video demonstration showing how you can use SIMS Assessment to calculate a KS4 target from a KS2 scaled score. The example is based on the blog post by Peter Atherton in his DataEducator blog. Read the post first, and remember that the targets Peter sets in the post are tailored for...

Making sense of progress 8 2

Making sense of progress 8

Over the last few months many schools have been obsessing about progress 8 scores and I’ve watched a few schools get worked-up if the value of progress 8 was one decimal point above or below a specific value. That’s why it was reassuring to see advice from David Blow in Schoolsweek, Leading Learner and from Data Educator that any calculation of P8 was inherently flawed: all calculations are currently based on the 2015 attainment 8 estimates. The clue...

SIMS: Helping schools inspire 2

Setting up marksheets for the new academic year

Many assessment systems have grown ‘like topsy’ over the years, often containing thousands and thousands of marksheets that can make finding the right marksheet very difficult. Here’s how to set up your marksheets for the new academic year so that your teachers just see most recent marksheets. You’ll find that marksheets based on whole year groups work fine at the start of the new academic year. That’s because SIMS promotes pupils from one year to the next...

6

Coming soon: SIMS interventions

Interventions make a difference – prove it! As well as working with school assessment systems, I’m a school governor for a medium-sized primary school in a deprived area near Manchester. Not surprisingly I’m keen that our school uses SIMS to best effect and was pleased to talk  with Lucy Crawford at this year’s SIMS annual conference. Lucy is the product manager for SIMS Interventions, a new module currently in development by Capita. She describes SIMS...

0

Exam Results Analysis: Top Tips

With GCSE Results Day 2016 fast approaching I thought it’s a good time to look at how assessment manager experts like us can get the most out of exam results analysis on the big day itself and during the following few days. I don’t count myself an expert when it comes to Exams, and I’m definitely not a Exam Organiser ninja but, over the years, I have been able to help many schools integrate Exam Organiser and Assessment Manager...

SIMS: Helping schools inspire 2

New SIMS KS4 resources are a ‘must have’ for schools

At the recent SIMS Annual Conference I was talked to lots of Capita people about the exciting things happening in SIMS over the next few years. I’ll be blogging about the New SIMS Interventions module later but, for now, I want to blog about the new SIMS KS4 Resources. The KS4 resources are a set of extra marksheets and reports that take the strain out of data analysis using SIMS. They provide an easy set of...

SIMS Assessment Manager Summer School 0

Announcement: Summer School 2016

I’m very excited to let you know that I’m planning a 2016 Summer School for SIMS Assessment. The summer school is aimed at anyone in the primary or secondary sector who has the responsibility to develop their assessment system over the summer months, but who needs a little bit of extra support. You might be an existing user of SIMS Assessment Manager who needs a little bit of extra help, or you might be completely...

19

New KS4 Resources Part 2: KS2 Fine Level and Grade

Introduction In my previous post I showed you how to install the new templates and map your assessment data into the standard aspects provided by Capita. In this post I want to emphasise the importance of getting your data just right. In part 3 we’ll look at the analysis provided by the marksheets, the excel report and by SIMS Discover. Getting Your Data Sorted You’ve probably already read the latest P8 Technical Guidance document from the...