© Crown copyright 2008
RAISEonline
Question Level Analysis
February 2008
© Crown copyright 2008
Data management to support QLA• The role of data management within RAISEonline to
support QLA• Entering the pupils into the system with common transfer
files (CTF) This should be carried out using a CTF produced from the schools own
MIS
• Common CTF difficulties experienced by schools Most problems begin with schools MIS data sets Incomplete data sets Conflicting data sets Confused data sets
• Copying school cohorts using the data management functionality
Not advised as the best practice because pupil characteristics and context may change even if pupils remain the same
© Crown copyright 2008
QLA Templates• Downloaded from RAISE• Cohorts must be uploaded first using a CTF• Item level responses entered into the template• Enabling macros
These must be enabled to ensure correct upload of QLA data
• Entering item level responses into the mark templates Type in marks as though to a spreadsheet
• Entering blank responses These must be entered as N Note that blanks will not be uploaded to the system
• Uploading populated QLA templates
© Crown copyright 2008
To download the QLA template click on ‘Import data’, then ‘Download example templates’ then ‘QLA’
© Crown copyright 2008
Question Level Analysis templates can be found in here
© Crown copyright 2008
Macros must be enabled to ensure data is uploaded into RAISE
© Crown copyright 2008
All marks must be entered, if there are any blanks the results will not be uploaded into RAISE
Where a pupil didn’t attempt a question ‘N’ must be entered
© Crown copyright 2008
An error message will be displayed if an incorrect character is entered
© Crown copyright 2008
If there are blanks in the template an error message will be displayed when trying to save the document
© Crown copyright 2008
To import the QLA template click on ‘Import data’
© Crown copyright 2008
Click on Question Level Analysis
© Crown copyright 2008
Use the ‘Browse’ button to navigate to the QLA template
© Crown copyright 2008
When you have navigated to the QLA template click on ‘Open’
© Crown copyright 2008
Click on ‘Upload File’
© Crown copyright 2008
The page will refresh and you can ‘View Report’
In this case the message displays ‘Completed with result type No’
© Crown copyright 2008
© Crown copyright 2008
This time the message displays ‘Completed with result type Yes’
© Crown copyright 2008
© Crown copyright 2008
We can now use the QLA wizard to navigate to Question level reports and graphs
© Crown copyright 2008
In this example we have navigated to a KS2 2006/07 Maths test A topic report
© Crown copyright 2008
This graph is displayed at the top of the screen and shows the % Correct Responses for each topic for Maths test A for both School and National
© Crown copyright 2008
Underneath the graph this table is displayed which shows the school data and compares this with National data showing the ‘% Differences from National’
© Crown copyright 2008
When we choose the Pupil List report from the QLA wizard it displays the ‘% Correct responses’ for each pupil broken down by topics also showing the overall ‘% Correct Response’
© Crown copyright 2008
When clicking on a pupils % correct response figure we are shown a radar graph showing that pupils performance
© Crown copyright 2008
This information is also shown in a table below the radar graph also showing the differences from National
© Crown copyright 2008
Training and Support is provided through...
• System tutorials, help pages and FAQs
• System [email protected]
• eLearning materialwww.standards.dcsf.gov.uk/esp
www.nationalstrategiescpd.org.uk/course/view.php?id=76
• New home page with easy-to-access news headlines
© Crown copyright 2008
Crown Copyright Statement• The content of this publication may be reproduced free of charge by schools and
local education provided that the material is acknowledged as Crown copyright, the publication title is specified, it is reproduced accurately and not used in a misleading context. Anyone else wishing to reuse part or all of the content of this publication should apply to OPSI for a core licence.
• The permission to reproduce Crown copyright protected material does not extend to any material in this publication which is identified as being the copyright of a third party.
• Applications to reproduce the material from this publication should be addressed to:OPSI, The Information Policy Division,St Clements House,2–16 Colegate, Norwich NR3 1BQFax: 01603 723000e-mail: [email protected]