SISRA Analytics| KS4 Getting Started - Legacy Mode
KS4 Getting Started (Legacy mode) This is an introductory guide, which aims to walk you through how to set up a KS4 cohort within Analytics for the first time.
Table of Contents Logging In....................................................................................... 2 Introduction to Key Stage 4 ......................................................... 3 HELP & Live Chat ........................................................................... 4 Step One – Student Data Profile ................................................. 5 Create your Student Data Filters............................................ 6 Define your Student Data Profile ........................................... 7 Step Two – Student Data .............................................................. 8 Preparing the Student Data (Excel Add-In) .......................... 9 Student Data Collections ...................................................................................................................... 10 What is a Collection?............................................................................................................................. 10 Creating a Collection ............................................................................................................................ 10 Uploading Student Data ....................................................................................................................... 12 Overview of Student Data Collections ........................................................................................................ 14 Step Three – Grades Data.............................................................................................................................. 15 Format Grades Data Files ...................................................................................................................... 15 Uploading Exam/Other Grades Data Files *this process is different for Assessments18 Uploading Assessment Grades Data Files ............................................................................................ 21 KS2 / Baselines................................................................................................................................................. 24 Example File -.......................................................................................................................................... 24 Uploading KS2 Data............................................................................................................................... 25 Setting Up KS2 / Baseline Data .............................................................................................................. 26 Step Four – The Matching Process ................................................................................................................ 28 Step Five – Grades Management................................................................................................................. 32 Step Six – Publish your Reports ....................................................................................................................... 33 Publish Queue & the Reports ......................................................................................................................... 36 How to Create a User ..................................................................................................................................... 37
Last Updated: 20/12/2016
Page 1 of 37
SISRA Analytics | KS4 Getting Started - Legacy Mode
Logging In You can log into SISRA Analytics via www.sisraanalytics.co.uk. Enter your Username (A1), Password (A2) and click the Log In button (A3) at the bottom. These should have been sent to you via email to your registered email address. If you have forgotten your login details then you can have your details re-sent by clicking on the “Forgotten your login details?” (A4) link at the bottom of the page, then entering your registered email address. You will then be emailed instructions on how to change your login details.
Last Updated: 20/12/2016
Page 2 of 37
SISRA Analytics | KS4 Getting Started - Legacy Mode
Introduction to Key Stage 4 This guide aims to provide you with the main steps for setting up your Key Stage 4 data and publish your first reports in Analytics. Please note that this is by no means a comprehensive guide for all of the features and functionality available in SISRA Analytics. IMPORTANT: When you click ‘DATA’ you will be given the option of Legacy or EAP mode. This guide covers Getting Started in Legacy mode. Legacy should only be used for Y11 (16/17) or previous cohorts. You should use EAP mode for Y10 (17/18) cohorts onwards (please see the appropriate Getting Started guide in HELP > Videos & Guides > KS3/4 EAP Admin).
When you begin, you should upload your last year’s leavers. The main reason for this is that you already have the published finalised figures. You can compare these to those being generated in your reports to help troubleshoot issues in the setup and get used to how Analytics works. As an overview, the main outcome of using Analytics is producing a set of reports which your users can analyse. As the SISRA Administrator for your school, to produce these you must upload: A. Student Data (this has 10 columns by default and contains the students individual details, like classes, class codes and filter values like SEN, Ever6 etc.). However, your profile can be amended to add 10 additional custom filters that you may want to analyse at school, such as Pupil Premium, Attendance etc. You would need to extract this Student Data from your MIS into Excel, to format into the expected order and upload into Analytics. Student Data is collection based, which is explained throughout the guide, but in brief this means that each time you collect student data in school, you must firstly create a collection that relates to that time in school – e.g. in Y11 Autumn, create a collection, upload your autumn student data, then repeat when you roll into Spring. Doing this also creates an area where you can upload the assessment grades that relate to that time in school, e.g. the Y11 Autumn assessment grades, then Y11 Spring. B. Grades Data (These data sets are not collection based.) In Analytics, you have access to 5 standalone data sets where you can upload your students KS4 grades. These are split into two areas; Exams and Other Grades. Under Exams, you should only ever upload banked exam results (we recommend uploading these throughout the year, as and when they come into school to make it easier for you). You can upload your other 4 data types under Other Grades - Targets, Mocks, Data Set 3 and Data Set 4. These can contain a single set of grades in each, and can be renamed to make it obvious what data is inside. You also have access to 1 ‘Assessment Tracker’. This is different to the standalone data sets as these can contain more than 1 assessment collection of grades, and allow users to track these side by side in the Reports. Due to this, it should be used for one type of data. For example, some of our schools choose to track current working at grades.
Last Updated: 20/12/2016
Page 3 of 37
SISRA Analytics | KS4 Getting Started - Legacy Mode
You can also upload KS2 Data into KS4 to produce progress related figures in the Reports, such as Progress 8, Value Added and more.
Once you have uploaded your student and grades data, you need to link your qualifications to the classes that took them, and tell Analytics the type of qualification/s and how these should be treated in the Reports. This is done via the Matching page. You can then check Grades Management to make sure there are no obvious setup issues being flagged by Analytics, such as missing classes or invalid grade formats, which would mean inaccurate figures in the reports.
When you have resolved all of these issues, you can publish your first set of results.
HELP & Live Chat HELP Area For further information you can click the yellow HELP button (A5) on the left hand side of Analytics. This will expand, giving you access to the different HELP sources available, in one place. Including: Videos & Guides - Here you can access Admin and Report resources for ‘Legacy’ mode of SISRA Analytics. Alongside Useful Links, Downloads, Results Day Preparation etc.
Email Support – to email the Support Team for help, we will respond to these as soon as possible but this will take longer than online chats. Live Chat – contact a member of the Support Team for assistance over an online chat facility. See more information regarding this below.
Live Chat If you get stuck or have any questions regarding SISRA Analytics then don’t hesitate to pop onto Live Chat - we’re always happy to help! You can chat using HELP > ‘Live chat’ as shown above. If we’re not available (either during particularly busy periods or outside of working hours) the button may turn red. Feel free to click this to leave a message and we’ll get back to you via email as soon as we’re available. Be sure to provide as much detail as possible regarding your query to help us to look into it for you.
Last Updated: 20/12/2016
Page 4 of 37
SISRA Analytics | KS4 Getting Started - Legacy Mode
Step One – Student Data Profile Before you can upload any results (such as Exams, Mocks, Assessments), you MUST upload Student Data, by default this is 10 columns, as shown below. One of the added functionalities of Analytics is the ability to define custom filters (up to 10 more), and upload this data in your Student Data file, so your first step is to create and define your Student Data Profile. Before doing this, we recommend checking your MIS or with your SLT to decide which filters you want to include, as this is a global action which would affect all cohorts / key stages you plan to upload data for.
We’ve included some examples of filters below: Pupil Premium Registration Group Travellers EAL Students Armed Forces Attendance Group (You should group attendance filters, rather than uploading individual decimalised values for attendance, this improves the speed and performance of publishing your reports and browsing for your users. For information on this, see page 8 of our Student Data Profile Guide in HELP > Videos & Guides or click here.) Houses If you add additional student data filters to your Student Data Profile you will need to manually edit the Report Definition for your MIS to extract this data into Excel. For assistance in this area, you can contact
[email protected] who have MIS knowledge. The support team will be unable to provide you with MIS support and will direct you to the email address above.
You’re now ready to create filters and define your Student Data Profile.
Last Updated: 20/12/2016
Page 5 of 37
SISRA Analytics | KS4 Getting Started - Legacy Mode
Create your Student Data Filters Editing your Student Data Profile is a two-step process, first you must create the additional filters you’re interested in, then define which ones you would like to use in your student data profile. To create a filter click CONFIG (B1) > Student Data > Filter Management (B2) > Create Filter (B3).
Enter a Filter Name (B4) (as you would like the filter to appear in the reports, such as Attendance Group or Pupil Premium) and enter a Default Value (B5). This is the value that Analytics will specify where there is none for a student in your Student Data Files later on, then click Create (B6). You should then see the newly-created filter on the Student Data Filters list. You can then repeat this process for any further filters you want to add.
If you click on any of the Alias Count (B7) numbers next to a filter you can add a ‘Filter Alias’, this will allow you to set how you want a filter value to appear in the Reports. For example, if your SEN Code is uploaded as ‘K’ you can set this to appear as ‘SEN Support’ in the Reports, making it more user friendly. For a detailed look at creating Filter Aliases and setting up your Student Data Profile click here: http://www.sisraanalytics.com/downloads/sa/admin/StudentDataProfile.pdf
Last Updated: 20/12/2016
Page 6 of 37
SISRA Analytics | KS4 Getting Started - Legacy Mode
Define your Student Data Profile Next, you will need to tell Analytics which filters you would like to use by defining them as part of your ‘Student Data Profile’. To do this, click Student Data Profile (C1), then click the Edit Columns button (C2) in the right hand corner.
Your new filter/s should then be available for selection from the drop-down menus. When you have finished defining your filters, click Save (C3).
If you scroll down to the bottom of the page you will see the new required format for your student data files, with any new filters included (C4).
Last Updated: 20/12/2016
Page 7 of 37
SISRA Analytics | KS4 Getting Started - Legacy Mode
Step Two – Student Data Before you can go ahead and upload any results (such as Exams, Mocks, Targets, Assessments) you MUST upload Student Data. This will need to be extracted from your MIS into Excel, then ran through the Analytics Excel Add-In to ensure it is in the correct format for upload. We have provided some files to help you do this and you can download these from HELP (D1) > Videos & Guides (D2).
Click Downloads (D3).
1. SIMS/CMIS/Bromcom Report Definition File for Student Data (D4) We have provided Student Report Definition files for SIMS, CMIS and Bromcom (and a Help sheet) to help you extract your student data into Excel for formatting. You will need to manually edit the Report Definition if you would prefer to use different Student ID’s or if you would like to extract additional filters. You will need to ensure you are consistent with the Student ID you use when extracting Student and Grades data (such as Exams, Targets, Mocks, and Tracker data) in order for Analytics to link your data together. Unfortunately if you experience problems it may be worthwhile contacting your MIS support as we’re unable to provide comprehensive support for MIS. 2. SISRA Analytics Excel Add-In (D5) You can download the Analytics Excel Add-In here too (used to format your file in Excel, for upload into Analytics). You will also find your school’s unique Add-In code which you will need when setting up the Excel Add-In. Please see our Excel Add-In Guide, which will explain how to set up the Excel Add-In for the first time, using your School’s Code (including troubleshooting tips).
Last Updated: 20/12/2016
Page 8 of 37
SISRA Analytics | KS4 Getting Started - Legacy Mode
Preparing the Student Data (Excel Add-In) Once you have extracted your Student Data from your MIS into Excel, you need to run it through the Excel Add-In. In Excel, click the SISRA tab (E1), then Prepare Student Data (E2). If you need help setting up the Add-In please see our guide: http://www.sisraanalytics.com/downloads/sa/admin/InstallingAndManagingAnalyticsAddIn.pdf
A pop up menu should appear allowing you to select the columns you want to prepare as part of your Student Data file. The filter selections shown relate to the Student Data Profile that you have set up in SISRA Analytics (unless you’re using Offline Mode). This should update automatically, for example our additional Attendance filter has pulled through below (E3).
However, if you’re using Offline Mode (in which case the top banner will say ‘Offline School’) you will need to ensure you have manually set up the filters as these will not feed through automatically – Please see our Excel Add-In Guide above to set this up correctly. If Analytics is unable to identify the column or it is blank then the associated drop down will be flagged and highlighted. You can hover over the icons for a handy tooltip. You must double check the selections to ensure correct columns have been selected. When you’re ready, click Prepare Data (E4). You will be prompted to save the file, and this will automatically select to save this as a CSV (MS DOS), which is the file format required for all uploads. Give your file an appropriate name, browse to a suitable location on your computer and click Save. If you are unable to use the Analytics Excel Add-in (for example this is not compatible with Office 365), you can format your data manually within Excel. This should be saved as a CSV (MS DOS) file which can then be uploaded into Analytics. You would also need to ensure that the file contains all of the columns in the exact order they appear within your student data profile.
Last Updated: 20/12/2016
Page 9 of 37
SISRA Analytics | KS4 Getting Started - Legacy Mode
Student Data Collections Before you can upload your prepared Student Data file into Analytics, you must create a Collection.
What is a Collection? A Collection is a time-stamped collection point, into which you would upload all/any student data relevant to that collection time in school. Generally we would expect a school to create a Collection in Analytics for each Assessment Grade Collection they complete within school. For example 1 collection for Y10 Autumn, one for Y10 Spring another for Y10 Summer etc. (depending on how you label and collect your data in school). The first student data upload into a collection outlines the student data profile format used for that collection, and any subsequent student data uploaded into the Collection must be in this format (i.e. contain the same amount of columns). Every collection you create here will also be mirrored in the Assessments section (on the left), and this is because Analytics uses collections to determine which assessment grades files should be treated as which assessment point. This therefore means that each time you want to upload a new set of assessment grades into Analytics, you will need to create a NEW collection first and upload a student data file.
Please note - there is no limit on the number of collections you can create (you do NOT need to remove old collections) or on sets of assessment grades that you can upload, but it is only possible to publish up to 6 assessment points at a time in the reports for each cohort.
Creating a Collection To create a new collection, click on DATA (F1), in Legacy mode select the Keystage and Year (F2) > Uploads tab (F3). If you’re new to SISRA Analytics, we recommend uploading your previous Year 11’s Exam results first. This is a great way of getting used to the way Analytics works, as you can compare the figures in the Reports to your final figures to find anomalies in the setup. You will notice that you are currently only able to click on “Student Data” under the Uploads tab, but once you have created a Collection and uploaded a student data file you will then have access to the other upload areas. To create a Collection click into the Student Data section (F4), then click Create Collection (F5).
Last Updated: 20/12/2016
Page 10 of 37
SISRA Analytics | KS4 Getting Started - Legacy Mode
A pop up window should then appear, allowing you to enter a suitable Collection Name (F6) relating to that collection of data e.g. “Y11 Autumn” or similar. This is important as this will also form the Assessment Point name for any Assessment Grades you upload for this collection later on. Next, enter a Date (F7), which should be relevant to the time that data was collected in your school, add a description if necessary then click Create (F8).
This will then take you to the STUDENT DATA UPLOADS page, where you can see your newly-created collection. Here you can edit the details of the collection (F9) (such as the Name, Date etc.) or delete the collection, (G1) if necessary.
You are now ready to upload your Student Data file.
Last Updated: 20/12/2016
Page 11 of 37
SISRA Analytics | KS4 Getting Started - Legacy Mode
Uploading Student Data With the appropriate Key Stage and Year selected in Legacy mode (H1), click the Uploads tab (H2) then Student Data (H3), ensuring you have the relevant collection open, click Upload Student File (H4). You will be taken to the UPLOAD FILE page (as we created our Collection earlier).
This will show you an example of the format the upload should take, including any additional student data filters that have been set up in the Student Data Profile. As you can see, our school set up an additional ‘Attendance Group’ filter. You must ensure your file matches the columns and order of the example shown in your Analytics school.
Click on Choose File to select your CSV file, enter a suitable file name (H5) and click Upload (H6). The file name is internal (displayed in DATA only) as the Collection name will be the report name.
Refreshing Student Data OR Uploading Assessments? If you need to refresh your Classes and student filter statuses (e.g. SEN) or upload your next set of assessment levels (e.g. Y11 Winter), then you must create a NEW collection and upload your up-to-date student data file into the new collection. DO NOT remove your existing student data collections as these can be stored as historical data.
Last Updated: 20/12/2016
Page 12 of 37
SISRA Analytics | KS4 Getting Started - Legacy Mode
Shortly after you will then be taken to the File Health Check. This will check the file you have selected and highlight any issues with the data (H7). You will also see an Upload Summary (H8) which will show the number of students and qualifications uploaded. If the Health Check highlights any issues you need to resolve click “Cancel the Upload” (H9), address any issues and then upload the amended file. If you are happy to continue (or want to address the issues in SISRA Analytics)you can click the “Complete the Upload” button (I1).
You should now be on the STUDENT DATA UPLOADS page, and see your new file. You can now use the Actions on the right hand side to manage your file (I2) (like view a sample of the data within by clicking the eye icon) and gain access to the other data upload areas on the left (I3), such as Assessment Grades. In Assessments, you will find that any collections you just created in Student Data, are also mirrored there. This is because Analytics uses a collection to determine which grades files form which assessment point in a school. Each time you want to upload Assessment Grades you will need to create a new collection and upload a student data file.
You are now ready to prepare grades data!
Last Updated: 20/12/2016
Page 13 of 37
SISRA Analytics| KS4 Getting Started - Legacy Mode
Overview of Student Data Collections Each time you want to refresh student data or upload a new set of Assessments you must create a new student data collection to store your file. All reports published e.g. historic assessments or Exams, will use the student data filters uploaded in the ‘Current Collection’ only. The ‘Current Collection’ will be the collection with the latest date.
The collection name will form the name of your Assessment in the REPORTS area.
Analytics will pull through old classes from student data in historical collections if the student is missing that class in the ‘Current Collection’.
You should roughly end up with the same amount of collections as you have assessment data collections in your school (if not more). You do not have to upload grades under each collection.
Last Updated: 20/12/2016
Page 14 of 37
SISRA Analytics| KS4 Getting Started - Legacy Mode
Step Three – Grades Data We do not provide report definitions for extracting Grade Data from your MIS. In KS4 of Analytics you have access to the following grades data sets: 1 x Assessment Tracker - allows you to view assessment points side by side to track. You should only upload one type of data into your Assessment Tracker, for example if you collect Current Grades and Predictions, you should choose ONE of these to upload into the Tracker. Exams – This should only be used to store final, banked exam grades for that cohort. Other Grades o This gives you access to 4 standalone data sets, meaning you can upload 1 full set of grades into each. For example, you might use one each for a set of Targets, Mocks, Predictions and Estimates. Or, you might use one for their Targets from when they were in Y10, their Y11 Targets, Y10 Predictions and Y11 Predictions. This may just depend on what data you analyse in school. NOTE: You should always upload qualifications with different QAN codes as separate qualifications with unique names. For example ‘English’ (combined), ‘English Literature’ and ‘English Language’ should be three separate qualifications if you have students taking these.
Format Grades Data Files Once you have extracted the grades data from your MIS into Excel (regardless of whether this is Assessment Grades, Targets or Exams etc.) you will need to run the Analytics Excel Add-in over your file to ensure it is in the correct format for upload. The Add-in will convert broadsheet and lists into the required 4 column list as shown below.
To help you format your grades file, the Analytics Excel Add-In provides two options: “Prepare from Broadsheet” – This option allows you to format a broadsheet into a 4 column list ready for upload into Analytics. An example of a broadsheet has been included below. For further information on this please see page 16.
Last Updated: 20/12/2016
Page 15 of 37
SISRA Analytics | KS4 Getting Started - Legacy Mode
“Prepare from Grade List” – This option has been included for schools who export their grades data from their MIS in a list (generally a 5 column list as shown below but this option can actually convert any list which has at least 4 columns). To use this, please view page 17.
Excel Add-In: Prepare from Broadsheet We know that most schools export their grades data in broadsheet format (shown below), so this will need to be converted into a 4 column list (saved as a CSV (MS DOS)) before it can be uploaded into Analytics. Click the SISRA tab (I1), then select the Prepare from Broadsheet option (I2).
In the pop up window, you need to select the row showing your qualification names. Then select (or type in) the first and last qualification column you want to include in your file, check the options and click Prepare Data (I3).
Your file should be in a four column list (as shown to the right) and you should then be prompted to save it as a CSV (MS DOS), the file format required in SISRA Analytics. You should give your file a name and browse to a suitable location on your PC, then click Save. You’re now ready to upload your grades file into Analytics (page 18).
Last Updated: 20/12/2016
Page 16 of 37
SISRA Analytics | KS4 Getting Started - Legacy Mode
Excel Add-In: Prepare from Grade List If your file is exported from your MIS already in a list (shown below), then you can use the Add-In’s “Prepare from List” option. To run the Excel Add-in, click the SISRA tab (I4), then select the Prepare from Grade List option (I5). (Please ensure when using this option to save your original file first, as this will close after preparation)
A pop up window should then appear. The column in your file which contains your Qualification Names should be selected in the ‘Qualification Name’ drop down. You then need to select the column containing the students’ grades or levels in the ‘Grade / Level’ drop down, then click Prepare Data (I6).
Your file should be in a four column list (as shown below) and you should then be prompted to save it as a CSV (MS DOS), the file format required in SISRA Analytics. You should give your file a name and browse to a suitable location on your PC, then click Save.
You’re now ready to upload your grades file into Analytics (page 18)
Last Updated: 20/12/2016
Page 17 of 37
SISRA Analytics | KS4 Getting Started - Legacy Mode
Uploading Exam/Other Grades Data Files *this
process is different for
Assessments
After you have prepared your grades, you can upload your file into Analytics. The process for uploading into Exams or any data set under “Other Grades” (such as Targets, Mocks) is similar, however this does vary slightly for Assessments (this is explained in detail further on within this guide). As explained in the Introduction, you have access to 5 standalone data sets, one of these being Exams, as well as 4 others under ‘Other Grades’. These data sets are not collection based, and will use the student data from your latest / current student data collection. Other Grades There are four, re-nameable, standalone datasets per cohort, which are each designed to hold one grade, per student, per qualification. These data sets can be renamed in the CONFIG section, under Data Sets.
You can upload multiple files, but this should only be for missing grades. If you collect a new set of Target Grades, you should upload the new file and remove the old, so there is only ever 1 full set of grades. This is because if a student has multiple grades for the same qualification, Analytics will take the first entry as per DfE guidance – but you might want it to take the latest.
Exams
The Exams data set should only be used to store official Exam Grades. You should upload exam grades as and when you get them in school (rather than waiting until the end of the year). You DO NOT need to remove previous exam results, as Analytics will know which grades to use. During the upload, please ensure that you enter an accurate ‘Exams Date’ of when the students sat the exams, in order for First Entry to be applied correctly in the Summer.
The Exams Date should reflect the time that the students sat the exam, so you’ll need to ensure the grades files are split out appropriately. Analytics calculates First Entry logic discounting based on the Dates (2014 Onwards)
Last Updated: 20/12/2016
Page 18 of 37
SISRA Analytics | KS4 Getting Started - Legacy Mode
With the appropriate Keystage and Year selected in Legacy mode (I8), click the Uploads tab (I9), then expand Exam Grades or Other Grades (J1). If you are uploading into Other Grades, you will need to click on the appropriate datasets e.g. Targets/Mocks/Data Set 3 etc. Please note - you can rename additional data sets in the CONFIG area, under Data Sets!
0
To upload a grades file, click on Upload Grade File (J2) and this should display an example of the format the Grades file should take (4 column list: Student ID, Student Name, Qual and Grade). Ensuring your file is saved as a CSV (MS DOS), you can then click Choose File (J3) to browse for the file to upload. Once you have done this, enter an accurate date of when the Exams were sat (J4), then enter a File Title to help you identify the contents of the upload (J5) and click Upload.
It is vital that accurate dates are used when uploading Exams to ensure first entry discounting is applied on appropriate KS4 cohorts. You can put exams results from the same season in the same file, and give this an accurate date, for example, November season results in a file dated 1st Nov. If you’re uploading into Other Grades (e.g. Targets), you don’t need to worry about specific dates. If you have students taking multiple qualifications from related subjects then you may need to split your results into more files for upload. An example of this is a student taking English GCSE, and either English Language or English Literature during the same season but after the 29th September 2013. For further information on uploading Exams accurately, please read the following document: http://www.sisraanalytics.com/downloads/sa/resultsday/16/KS4_Exams_FirstEntry.pdf
Last Updated: 20/12/2016
Page 19 of 37
SISRA Analytics | KS4 Getting Started - Legacy Mode
During the upload Analytics will perform a “File Health Check” which will tell you if there are any issues with the uploaded file. If the Health Check highlights any issues that you need to resolve click “Cancel the Upload”, address any issues and then upload the amended file. If you are happy to continue (or if you want to address the issues in SISRA Analytics, where possible), you can click the “Continue With The Upload” button.
We recommend checking the number of students and Qualifications uploaded – to make sure it’s what you expect.
When the upload is complete, you will be redirected back to the appropriate Dataset to see a summary of your uploaded file(s). Below you can see what it might look like with a few exam grades files uploaded. There is also an Actions column (J6) where you can manage your files and an Export button, which allows you to export uploaded files to Excel (J7).
Next time you upload grades… The next time you upload grades (for the same cohort), Analytics will perform a check on your qualification names to find any discrepancies. If the qualification names you’re uploading already exist on your Matching page, it will merge these for you. If it identifies a new qualification name (or if the name in your file differs slightly), it will allow you to select whether this is a new qualification, or whether you would like to merge this with an existing qualification from a drop down list. Please ensure you’re merging the correct qualifications. Any new qualifications will appear as separate rows on your Matching page and any existing qualifications will appear under the qualification name you selected.
Last Updated: 20/12/2016
Page 20 of 37
SISRA Analytics | KS4 Getting Started - Legacy Mode
** NEW TARGETS / MOCKS ** If you need to refresh grades under ‘Other Grades’, for example, you already have a set of Y10 Targets but would like to refresh these with a new set of their Y11 Target grades, then you should upload the new set of grades and remove the old file. This is because there should only be 1 set of grades uploaded in each of the ‘Other’ Data Sets (either ‘new’ Y11 Targets OR ‘old’ Y10 Targets).
Uploading Assessment Grades Data Files The Assessments area works slightly differently in Analytics as this is ‘collection based’, which means that you need a separate collection (created in the Student Data area) for each set of Assessment Grades that you plan to upload. You can get to the Assessments area within Analytics with the appropriate Keystage and Year selected in Legacy mode > Uploads tab > expand Assessment Grades (K1).
When you click into Assessments, you should see that all of the collections that have been created previously, in Student Data, are mirrored here. This is because Analytics uses Collections to determine which groups of grades files should be treated as one separate Assessment Point.
** In the example above, assessment grades are being uploaded into the ‘Y11 Autumn’ collection. Any grades uploaded into this collection will then form our ‘Y11 Autumn’ Assessment Point.
**
Each time you wish to upload grades for a new assessment point, you must create a new collection and upload a new student data file. In the appropriate collection (you’ll notice this has the same name as the collection you created earlier for your Student Data), click the "Upload Grade File" (K2) button. Here you will be shown an example of the format that the Grades file should take - 4 column list in Excel including Student ID, Student Name, Qualification and Grade saved as a CSV (MS-DOS).
Last Updated: 20/12/2016
Page 21 of 37
SISRA Analytics | KS4 Getting Started - Legacy Mode
To upload your Assessment Grades, next click Choose File (K3) to select the file for upload, enter an appropriate File Title to help you identify the contents of the upload (K4) and click Upload (K5).
During the upload, Analytics will perform a “File Health Check” which will tell you if there are any issues with the uploaded file. If the Health Check highlights any issues (you can view further details of the issues by clicking “Show/Hide Warnings”), click “Cancel the Upload” to address these and then upload the amended file. If you’re happy with the file (or would prefer to address issues in SISRA Analytics where possible) and you have checked the Upload Summary, click “Continue With The Upload” (K6).
If this is not your first grades upload for this cohort, after clicking continue Analytics will check to ensure it recognises all qualification names. Any that are not recognised will be listed on the Confirm Upload Qualification Names page and you must tell Analytics whether these are new qualifications or identify them as existing, so that Analytics can rename them for you (this is to ensure consistency). Click here for our guide. When the upload is complete, you will be redirected back to your Assessments dataset, where you will see a summary of your uploaded file(s) alongside an Actions column (K7) and an option to export the file to Excel (K8). You will also see a red banner appear to prompt you to publish your Reports, as Analytics can see you have made changes however you will need to match your data first. As you can see below, our new assessment grades file will now form our “Y11 Autumn” assessment point within the Reports (when published).
Last Updated: 20/12/2016
Page 22 of 37
SISRA Analytics | KS4 Getting Started - Legacy Mode
Your Next Assessment Point… Each time you want to upload a set of Assessment Grades for a cohort, you will need to create a new collection and upload a new set of student data relevant to this point in the year. You can then upload the Assessment Grades that relate to this, into that collection. Analytics then uses the collection that they have been uploaded into to identify which files relate to which individual Assessment Points. At the end of an Assessment cycle, depending on your Assessment Names and how many you collect, you may find that your Assessments area looks similar to the screenshot below. Here you can see separate Assessment collections (which have been set up under Student Data) from Y10 Autumn, through to Y11 Summer collections of data.
In our example above, we have uploaded our Y11 Summer Assessment Grades into the Y11 Summer Collection. Our historical Y10 Autumn Assessment Grades, have been uploaded into our historical Y10 Autumn collection. You may find that yours may vary slightly to our example, as your school may not use the same naming structure or collection cycle. You should upload the Assessment Grades data into the collection that relates to that data.
Last Updated: 20/12/2016
Page 23 of 37
SISRA Analytics | KS4 Getting Started - Legacy Mode
KS2 / Baselines KS2 Data must be set up as described below, to be in line with the DfE. If not, you will not have accurate figures in the reports. Please read the information below carefully. You can use KS2 data in two different ways, within Analytics. One way is for accurate headline schools performance measures, and this uses your Core KS2 Subjects to calculate figures such as Progress 8 and Banding. The other is for flexible internal analysis of individual, non-core qualifications and Analytics allows you to choose what KS2 data you’d like to use for these calculations.
1. KS2 Subjects Within Analytics, you can upload KS2 levels for the core subjects for the year group you’re working with. Core subjects are defined by the DfE and can change each year. For example, Y11 14/15 used English and Maths, whereas Y11 16/17 use Reading and Maths (stated here). You can also upload your own baseline levels for other subjects. For example, if you have subjectspecific levels you would like to use for individual subjects such as Art, Science, Technology etc. then you can upload these. Analytics will then allow you to use the appropriate ‘Core’ KS2 Subjects the DfE use, in Headline School Performance Measures, but your own baselines for internal analysis.
2. KS2 Levels In regards to the KS2 levels, you can upload either of the following for a KS2 Subject: Whole levels (such as 3, 4, 5 etc.) and Sub levels (such as 3a, 3b, 3c, 4a, 4b, 4c etc.) or, Fine levels to two decimal places (such 3.11, 3.22, 3.33, 4.67 etc.). For your figures to be accurate and in line with the DfE, you MUST upload fine levels to 2dp. As an example, you may want to upload Fine Levels to 2dp for English and Maths KS2 Subjects in 14/15, but sub levels for other baselines you want to use for internal analysis. Please bear in mind that Fine Levels provided by FFT can vary slightly to those the DfE would award, generating incorrect figures. If you’re unsure how to calculate your student’s fine levels, see our guide which explains converting raw KS2 test scores, into fine level to 2dp, by clicking here.
Example File In Excel, your file will need to be in the usual 4 column list, including Student ID, Student Name, Subject and Level, saved as a CSV (MS DOS).
As you can see, in our file we’ve included the ‘type’ of levels we’re uploading for each subject in the name, making it easier for us later on. For example, we have English Fine (for DfE measures) and English Sub (for internal analysis). This may depend on what you want to analyse in school.
Last Updated: 20/12/2016
Page 24 of 37
SISRA Analytics | KS4 Getting Started - Legacy Mode
Uploading KS2 Data When your file is ready, with the appropriate Key Stage and Year selected in Legacy mode (L1) > click the Uploads tab (L2) > select KS2 / Baseline (L3) and click Upload Levels File (L4).
On the KS2 / Baselines upload page, you will see an example of the file format expected (4 column list in Excel, saved as a CSV (MS DOS) file). Next, click Choose File (L5) to select the file for upload, enter a File Title (L6) to help you identify the contents of the upload and then click Upload (L7). During the upload Analytics will perform a “File Health Check”, which will tell you if there are any issues with the uploaded file. If there are, click “Cancel The Upload”, address any issues and reupload the file. If you’re happy with the file (or want to address issues in Analytics, where possible) and you have checked the Upload Summary, click “Continue With The Upload”.
Last Updated: 20/12/2016
Page 25 of 37
SISRA Analytics | KS4 Getting Started - Legacy Mode
Setting Up KS2 / Baseline Data You must complete the setup below for your figures to be calculated in the Reports. Once uploaded, you need to setup your KS2 Data to tell Analytics which of the KS2 subjects you uploaded, should count towards School Performance Measures and the type of levels you have. With the appropriate Key Stage and Year selected (M1), click the Data tab (M2), and then KS2/Baselines (M3). To amend the set-up you can click the blue ‘Edit’ (M4) button on the right.
You then need to set the following: Level Type (M5) – In this drop-down, you must select the type of levels you have uploaded into each KS2 subject. This tells Analytics what to expect and therefore what points to associate to the levels uploaded. By default, this is set to Whole/Sub, and you can select either: o NC Whole / Sub levels (for example, 3, 4, 5 or 3a, 3b, 3c etc.) o NC Fine levels (for example, 5.14, 4.37, 5.43 etc.) Core (M6) – The ‘Core’ column is used to tell Analytics which KS2 Subjects should count towards KS2 related school performance measures in the reports. For example, Progress 8 and Banding. In order for this to be accurate you must nominate the KS2 Subjects that the DfE consider as core subjects for the specific cohort you’re working with (as the subjects can change each year). For example, Y11 14/15 used English and Maths, so you would only set ‘English’ in the Core column and ‘Maths’. You can double check which KS2 subjects count for the cohort you’re working with, using the RAISE FAQS here: https://www.raiseonline.org/contact/faqData.aspx?faqId=49, underneath ‘KS2 Prior Attainment’. We’ve also included a table for your convenience:
Last Updated: 20/12/2016
Page 26 of 37
SISRA Analytics | KS4 Getting Started - Legacy Mode
KS4 Cohort 2014 2015 2016 2017 2018
KS2 Cohort 2009 2010 2011 2012 2013
KS2 Subjects English, Maths, Science English, Maths English, Maths Reading, Maths Reading, Maths
When you have finished setting up your KS2 Data, click Save (M7). Ensure the Level Type meets the type of levels you uploaded for that subject Only nominate the ‘core’ subjects for that year group and only nominate one of each core subject. For example, if ‘English’ is a core subject, only ONE of your KS2 Subjects should be nominated as English in the Core Column. Here you can check / edit the Subject Name to make these clear, as well as the number of levels uploaded.
For more information on KS2 data in Analytics, such as setting up KS2 Baseline data for internal analysis, please see our guides: http://www.sisraanalytics.com/downloads/sa/admin/KS2SetUp.pdf
Last Updated: 20/12/2016
Page 27 of 37
SISRA Analytics | KS4 Getting Started - Legacy Mode
Step Four – The Matching Process Once you have uploaded student data and grade data for a cohort, the Matching page will be available in the Data tab. You can get to the Matching page by selecting the appropriate Key Stage and Year in Legacy mode (N1), under the Data tab (N2), expand Matching (N3). The Matching page is used to match your qualifications (grades data) to the classes that took them (student data) so that they can pull through to the reports. It’s also where you tell Analytics how to treat qualifications, such as the type of qualification, grades method etc. You’ll notice down the left hand side that you have multiple options available for managing your data. For more information on these areas feel free to take a look at our other admin guides and tutorials available by clicking the HELP button on the left, then ‘Videos & Guides’.
On the Matching page there are three “Display Mode” options (N4). Feel free to hover / click through each of these icons to find the layout most suitable for you. If this is the first time you’ve uploaded grade data for the cohort, you will be presented with a red table. The rows of this table will correspond to the qualifications for which grades have been uploaded. Red rows on the matching table indicate that those qualifications will not be included in the reports.
The next few pages aim to explain the different columns on the Matching page and what information they relate to. Last Updated: 20/12/2016
Page 28 of 37
SISRA Analytics | KS4 Getting Started - Legacy Mode
Qual Name (N5) – The qualification name is taken from the data uploaded in your Grades file. We’d recommend using clear, generic names for GCSE qualifications, such as “Art” or “Biology” to make these easily identifiable to your staff (NOT 2 letter codes). For Non-GCSEs like BTECs, it’s also best practice to include the type / size in the name, for example ‘BTEC Science Single’. One thing to bear in mind, is that the Qualifications Report in Analytics is ordered alphabetically, so you can use the name to group qualifications together. For example, if you have a few BTEC qualifications, they would all be grouped together if they have ‘BTEC’ at the start of their name. Another example is if there are a large number of science qualifications, you could enter ‘Sc’ or ‘SCI’ before each of their qualification names, (SCI Biology, SCI Chemistry etc.) which will ensure they’re grouped in the Reports. You can edit the name of a qualification by clicking in the ‘Qual Name’ text box for a qualification and typing in your changes. Please note – You should not include the QAN code or assessment name in the Qual Name! Each row houses grades for that qualification in all reports (such as Targets, Exams, and Assessments).
Classes (N6) – This allows you to select the Sets of Classes that are associated with each qualification. The ‘Classes’ available to select here correspond to the ‘Subject’ column from the Student Data files that have been uploaded for the cohort. You must match each qualification to a set of classes here, in order for it to be included in the reports. You can match two or more qualifications to the same set of Classes. For example, English, English Language and English Literature could ALL be matched to the same ENGLISH set of classes. As the reports are qualification driven, Analytics will accurately show the appropriate students / grades in the appropriate classes.
Analytics is grade driven, NOT class driven, which means that each qualification in the reports will only show students or classes who have a grade uploaded for that actual qualification.
Please note – The qualification names do not have to match the class names! Measure (N7) – Here you can set the qualification type, which will ensure that the qualification counts towards the appropriate headline measures in the reports. For example, you can set a qualification to any one of the following – GCSE GCSE (Applied) iGCSE (GCSE)*
iGCSE (Non-GCSE)* AS Level Non-GCSE
L3 FSMQ L3 Asset Lang Unapproved
iGCSE (GCSE) should be used for any iGCSE qualifications for Current Y11 (14/15) onwards. For Y11 Leavers (13/14) however, you must select the appropriate measure for the iGCSE your students study. See our IGCSE Guide: http://www.sisraanalytics.com/downloads/sa/admin/iGCSEs.pdf
Last Updated: 20/12/2016
Page 29 of 37
SISRA Analytics | KS4 Getting Started - Legacy Mode
Method (N8) – This column is used to identify a particular Grade Method for a qualification, and is set to ‘GCSE Single’ by default. The Grades Method identifies the award size of the qualification and assigns the grades the appropriate point values in the reports, for example, a single award qualification with A*=58 points etc. You can check the point values and valid grades for each Grade Method in the CONFIG area, under Grade Methods. You are also able to create new (for example, BTEC Single) or edit manually created methods in this area. However, for this to be accurate you would need the QAN code. For information on creating and managing Grades Methods, please see our guide; http://www.sisraanalytics.com/downloads/sa/admin/KS4GradesMethods.pdf
Faculty (N9) - In Analytics, you can set up Faculties within your school to group qualifications together. For example, you could create a Science Faculty to group all of the different Science qualifications together, which would then allow you to analyse these as a group in the reports, viewing their individual figures and a set of summary figures. The Faculty column on the Matching page will remain greyed out until faculties have been created within the CONFIG area. Once created, you should be able to select which faculty a qualification belongs to via the dropdown boxes in this column. For information on creating and managing Faculties, please see our guide; http://www.sisraanalytics.com/downloads/sa/admin/DatasetsandFaculties.pdf
Special (O1) – You should use this column to identify which qualifications should count towards which subject specific performance measures, for example 5 A*-C Inc. Eng & Mat. You should also specify here if qualifications are part of the single sciences group (Bio/Chem/Phys) or linked pairs (English Lang/Lit). Nominating these accordingly will ensure that these count towards appropriate measures and discount other pathways, where applicable. Please note - We recommend using the DfE’s List of Qualifications that Count in the Ebacc document to ensure this column is nominated correctly. You can find this referenced and explained in our Specials Guide: http://www.sisraanalytics.com/downloads/sa/admin/Specials.pdf
Progress (O2) - This column is 'greyed out' and will be unavailable until a KS2 levels file is uploaded. Once accessible, this will allow you to set the non-core KS2-4 progress baseline for each separate qualification (this is different to the Headlines Progress Measures). In this column, you are able to set individual KS2 subjects as a baseline for the qualification, or alternatively you could select progress baseline groups which have been set up.
Last Updated: 20/12/2016
Page 30 of 37
SISRA Analytics | KS4 Getting Started - Legacy Mode
For example, if you have uploaded English Reading and Maths Levels and you wanted to use the average of these for the starting point for History, then you could create a baseline group (via the KS2 / Baselines Area, under DATA tab) and then assign this to History via the ‘Progress’ column on the Matching page. For further guidance on KS2 Baselines, please see our guide; http://www.sisraanalytics.com/downloads/sa/admin/KS2Setup_Step2.pdf
Bar. Code (O3) – In brief, if two or more qualifications are affected by discounting, for example if a student takes PE and PE BTEC, then you should apply identical discount codes to these qualifications in this column. These codes do not have to be official and you can check whether any of your qualifications share the same discount code using the RAISE Online Discount spreadsheet in HELP, under Useful Links. Unfortunately discounting is too complex to cover adequately in a brief guide, therefore for further guidance on this please refer to the appropriate, extensive guide: 2014 cohorts, onwards: http://www.sisraanalytics.com/downloads/sa/admin/2014Onwards_Discounting.pdf Pre-2014 cohorts: http://www.sisraanalytics.com/downloads/sa/admin/Pre-2014_Discounting.pdf
Include (O4) – This column indicates whether the qualification will be included in the Reports. This is automatically set to NO until the qualification has been matched to a set of classes. When the qualification is matched to a set of classes and saved, this will automatically revert to ‘Yes’, the row will turn green, this means Analytics will try to include the qualification in the reports. If you would like to exclude a qualification from the reports, you can manually set this column to NO. Please Note - If a qualification should appear in the reports but not affect the Headlines report then you need to set the “Measure” column to “Unapproved” and keep the “Include” column to “Yes”.
Once you have clicked SAVE CHANGES, the page will refresh and you will see that all qualifications that have been matched to Classes are now green. This does not indicate that the information you have selected is correct but is simply an indication that you wish for it to be included in the reports.
ANY CHANGES YOU MAKE ARE HIGHLIGHTED YELLOW, BUT YOU MUST REMEMBER TO CLICK SAVE IN ORDER FOR THE CHANGES TO BE REMEMBERED. Once you have completed the Matching Process, you MUST then check the GRADES Management area to resolve any setup issues being flagged (SEE NEXT PAGE).
Last Updated: 20/12/2016
Page 31 of 37
SISRA Analytics | KS4 Getting Started - Legacy Mode
Step Five – Grades Management *IMPORTANT The Grades Management area will become available once you have matched that cohort’s data for the first time. This area displays information, such as grade counts for each qualification in each data set and also performs checks on your data to identify setup issues. To access this area, click DATA, select the Key Stage and Year in Legacy mode (P1), then under the Data tab, expand Grades (P2). You can then click into each data set (Exams, Assessments or Other Grades) to check the data uploaded. For this example, we have clicked into Exams. Here you can see the qualifications uploaded (P3) for the selected data set listed on the left hand side and the classes (P4) that each qualifications are matched to. This allows you to double check if each class has been matched correctly. Clicking into a grade count (P5) takes you to the “Grades Management Detail” page for that qualification, which provides additional functionalities such as viewing the list of students and their grades uploaded into that qualification as well as adding, moving, editing and deleting grades.
When SISRA Analytics identifies issues with your data, it will display the appropriate warning icon/s next to the grade count for the affected qualification. You can find a key for these at the top right of the page (P6) and we’ve included a brief description of issues that can be flagged below. Missing Student Data – This indicates that at least 1 student has a grade uploaded for a qualification, but they do not exist in your student data (at all). Analytics uses the Student ID to link student and grades data together. Missing Class Data – This shows that at least 1 student has a grade uploaded for a qualification, but does not have the relevant class data. Grade Not In Method – This implies at least one grade uploaded for the qualification is either invalid or not supported by the selection in the METHOD column on the Matching page. You should resolve issues before publishing your Reports. For further information on addressing these please see our ‘Identifying and Addressing Warning Icons’ video in HELP > Admin Videos.
Last Updated: 20/12/2016
Page 32 of 37
SISRA Analytics | KS4 Getting Started - Legacy Mode
Step Six – Publish your Reports When you have completed the matching process and checked the Grades Management area, you are able to publish your data to view this in the reports. By clicking DATA (Q1) you will see a box labelled PUBLISH LIST (Q2), which details the key stages and years in which changes have been made and that therefore need to be published in order for these to be reflected in the reports. To view the Publish Reports for a specific year, you can click the appropriate publish button in this list, for example, Publish 2013/14 Leavers (Q3). Alternatively you can expand Publish Reports on the left hand side (Q4).
Here you can select the settings that should apply to your data when it is published. Extra columns may appear on this page, depending on which Key Stage you are working with and these are explained below for KS4.
Tick boxes (Q5) - The tick boxes allow you to select which data sets you want to be published (highlighted in green). By default all data sets with grades uploaded will be selected. If you have updated student data, we would recommend re-publishing ALL datasets for that cohort, in order for the classes / filters values to be updated across all of the reports.
Dataset (Q6) – This shows the data sets that are available to publish in that cohort as they have at least one grade. Logic (Q7) - The ‘Logic’ that you select when publishing determines the performance table rules that are applied to the figures in the Reports. You must select the appropriate year for each KS4 cohort, depending on the year that they will be reported on. For example, for 2014/2015 Leavers, as they’re reported on in 2015, you should use 2015 logic. 2015/2016 Y11 are reported on in the summer of 2016, so you would select 2016, and so forth. For further information on the different rules applied under each logic, see our guide below; http://www.sisraanalytics.com/downloads/sa/reports/Logic_PerfTableRules.pdf
Last Updated: 20/12/2016
Page 33 of 37
SISRA Analytics | KS4 Getting Started - Legacy Mode
VA Methodology (Q8) – This is where you select the estimates/methodology that should be applied when calculating Value Added for that specific cohort of students. For 2012 and earlier years you should use the 2012 VA methodology, which includes the shrinkage factor and the relevant coefficients for that year. The 2013 cohort should use the 2013 VA Methodology, and the 2014 cohort should use the 2014 VA Methodology. For the 2015 cohort you can use the updated 2015 VA methodology with the relevant estimates, after 2015 VA will no longer be officially reported on, so we do not believe the DfE will release new estimates going forward. For further information on each VA Methodology, see our guides below; 2013 - http://www.sisraanalytics.com/downloads/sa/reports/VA.pdf 2014 onwards - http://www.sisraanalytics.com/downloads/sa/reports/VA_2014.pdf
Attainment 8 Estimates (Q9) – You can select between 2014, 2015 and 2016 estimates for Attainment 8, and should select the year that relates to when those students will be officially reported on, at the end of Y11. The estimates determine ‘the average Attainment 8 score of all pupils nationally in the same key stage 2 prior attainment fine level band’. Please note that 2015 estimates are based on data from a year group where some KS2 tests were boycotted. Therefore, you may want to use your own judgement as to which estimates you would like to use for current cohorts until the appropriate option is available (usually after their summer results). For 15/16 Leavers you would select 2016 in the Attainment 8 Estimates column, as they are reported on in 2016. You can find out more in our Attainment 8 guide: http://www.sisraanalytics.com/downloads/sa/reports/A8P8_Calcs.pdf Status (R1) – Here you can select the status to publish each report with. The options available are:
Locked – This will ensure the reports are viewable to only selected users who have access to ‘View Locked Reports’ (by default, these are individuals with ‘Admin’ authority) Checked and Unchecked – This will allow all users to view the reports (where applicable) but Checked is usually used to suggest that the data is complete and that the report has been checked by your SISRA Administrator to be accurate. Whereas Unchecked might suggest the data is incomplete, perhaps due to setup or some grades are missing/yet to be added
Note (R2) – This enables you to add an annotation to each report which will feature alongside the reports list, allowing users to identify between reports. For example, if you have set the reports to ‘unchecked’ you might want to add a note to explain why, for example, ‘Y10 Banked Results Only’. Last Published (R3) - This shows the date and time of when that specific data set was last published for that cohort. If it has not been published yet, this column will show ‘Not Published’.
Last Updated: 20/12/2016
Page 34 of 37
SISRA Analytics | KS4 Getting Started - Legacy Mode
When you’re finished click the green “Save Changes and Add to Publish Queue” button (R4) at the bottom of the page. Analytics will then attempt to publish your Reports in the publish queue and overwrite any previously published reports for that cohort
Publishing Assessments Analytics allows you to select up to 6 Assessment Points to publish in chronological order (1 being the earliest point, and 6 being the most recent) in the “Assessment Point” (R5) drop down menus. The chosen assessments will then form part of the ‘Tracker’ in the Reports, allowing you to analyse them individually, or side by side to track / compare performance. If you have one assessment (until you have collected your next set), you can select this in Assessment Point 1, working down as you add sets of assessment grades into Analytics. When you have selected one you will gain access to the Status and Note options explained above. You do not have to select your individual data sets as part of the tracker (such as Exams, Targets or Mocks), as these will automatically be published as a separate report regardless. If you were to do this, they would appear in the Reports twice and one of these would show as part of the Tracker Report. The Status and Note will then be taken from the selections you made in their publish rows above. However, we would only ever recommend adding one of these as the last Assessment (assessment point 6), such as Exams.
Once all of your relevant assessment points have been selected in the relevant drop down menus (R6), click the green “Save Changes And Add To Publish Queue” button (R7) at the bottom of the page. Analytics will then attempt to add your Reports into the publish queue and overwrite any previously published reports for that cohort. For information on the publish queue, please see the next page.
Last Updated: 20/12/2016
Page 35 of 37
SISRA Analytics | KS4 Getting Started - Legacy Mode
Publish Queue & the Reports While there are reports in the publish queue, you are still able to access other cohorts data and reports, or even log out of Analytics as the process continues in the background. However, the cohort being published and the CONFIG area will be locked until the publishing has finished. If you add another cohort’s set of reports to the publish queue, these will be queued and will not begin publishing until the first set has completed.
Check its progress!
Cancel (R8) - This allows you to remove a set of reports from the publish queue (if it has not begun the publishing process and is still queued). You may want to use this if you’ve added them to the queue by mistake, or realise you need to make another change before publishing. The Publish Queue bar on the right hand side of the DATA page will turn green once completed. You are able to then click on the green publish bar to view the newly published reports for that cohort or alternatively, click the REPORTS button at the top (S1). Once on the REPORTS homepage, you can switch between key stages using the key stage tabs (S2) at the top of the page (if you have these published). The individual, current cohorts will be displayed on the left (S3) and leavers cohorts (year groups which have left) will be displayed on the right (S4). Information is displayed underneath each data set, including the Status, Note, Publish Date and any other information specified during the publishing process (S5).
Assessments and reports published in the Tracker
Standalone data sets
To access a Report, you can click on the Dataset name e.g. Targets or Y11 Summer, to reveal the report areas. You can then click the relevant button to view the Report - Headlines, Qualifications and Students (S6).
Last Updated: 20/12/2016
Page 36 of 37
SISRA Analytics | KS4 Getting Started - Legacy Mode
How to Create a User If you’re happy with your first set of reports, and want to set up users to start accessing Analytics and viewing the Reports, click USERS (T1). You can create users manually using ‘Create User’ (T2), or you can bulk upload users (in an Excel file) in Upload Users (T3).
When creating/uploading users you will need to select an ‘Authority Group’ for them, which defines what they can access in Analytics. We provide 2 default groups explained briefly below, but you can check these and create your own groups in Groups (T4). Admin – Can access all areas of Analytics, including DATA, all REPORTS and Locked Reports. User – Does not have access to DATA or Locked Reports, but can view standard Headlines, Qualifications and Students Reports.
Creating a User Manually If you click Create User (T2) you will need to enter their First name, Last Name and Email Address, followed by choosing an Authority Group. Shortly after you click Create New User, Analytics will automatically send out an email containing their login details to access the service. They can edit these once they login, using the accounts settings in the top right available by clicking the 3 horizontal lines next to their name and school (T5).
Uploading Users (T3) If you choose to upload your users, you would need to produce a 3 column list in Excel, including details for each of your users in the following order: First Name, Last Name and Email, saved as a CSV (MS DOS). During upload you will be asked to confirm the details and set their Authority Group. Once confirmed, an email will be sent to each of your users, containing their login details. Important: Before uploading your file, you should check with your local IT department and ensure that the bulk/spam filter can accept / receive emails from addresses ending in: @sisra.com
Please ensure that the email addresses you enter are correct, as Analytics will immediately send out username and password details to the specified address. If you want to learn more about Users then you can check out our ‘Users’ guide here: http://www.sisraanalytics.com/downloads/sa/admin/Users.pdf
We hope this has helped you to set up your first set of Reports, however if you need further help feel free to use HELP > Videos & Guides, or use Live Chat. Thanks for reading! SISRA Support Team
Last Updated: 20/12/2016
Page 37 of 37
These steps can be found in the KS4 Getting Started Guide in HELP > Videos & Guides
(HELP > Videos & Guides > Downloads)
* Some actions may only need to be carried out once, depending on whether updates have been released
(HELP > Videos & Guides > Downloads)
