--- title: Creating QLA and Smith proformas (England) description: GO 4 Schools --- [Skip to content](https://supporttest.go4schools.com/modular/creating-qla-and-smith-proformas-england#main-content) English - United Kingdom Show submenu for translations ![GO logo](https://supporttest.go4schools.com/hubfs/GO-logo.svg) - Home - Products - Pricing - Blog - Company Open main navigation Close main navigation - Home - Products - Pricing - Blog - Company - English - United Kingdom Show submenu for translations - Contact us Contact us How can we help you? - There are no suggestions because the search field is empty. 1. [GO 4 Schools](https://supporttest.go4schools.com/modular?hsLang=en-gb) 2. [Data Management](https://supporttest.go4schools.com/modular/data-management?hsLang=en-gb) # Creating QLA and Smith proformas (England) #### Introduction Question level analysis (QLA) is carried out following an assessment for which marks are recorded at an individual question level.  It enables middle leaders and class teachers to identify topics/areas of strength and weakness, and carry out targeted intervention, or even plan to re-teach key topics.  You can collect this data in markbooks, which will sum the marks and then convert to a grade using personalised grade boundaries. This guidance document will detail how to create marksheets to collect this type of item level data and will go on to describe how you can then extract this data, either for analysis in an explorer, for downloading to a CSV, or for printing off direct from our postcard view.  It is possible to create a Smith proforma as a form of personalised feedback for students. Using GO 4 Schools markbooks for QLA and Smith proformas should reduce staff workload by preventing the duplication of data entry, particularly if you are tracking QLA in an excel document and then teachers are entering the overall grade for the assessment in GO 4 Schools in preparation for a school snapshot of data. #### Building assessments for effective QLA and targeted intervention When constructing assessments for QLA it is important to consider whether the questions being asked will provide you with data to effectively identify topics or skills that pupils are struggling to grasp.  Exam papers, by their very nature, are designed to separate students at the end of a course and not identify gaps in knowledge or misconceptions as a course is being taught. Therefore, for QLA to have the most impact in the classroom, you will need to consider including diagnostic questions along with past paper questions in an interim assessment, ideally grouped into the topics or skills that have been taught up to this point in your course. #### Constructing QLA marksheets QLA marksheets can be added to any pre-existing subject markbook following these steps (please note you will need curriculum leader access to access the ‘edit markbook’ page): 1. Click ‘Add a new marksheet’. 2. Change the name of the marksheet to match your assessment. 3. Adjust the weighting accordingly, you may wish to change it from the default ‘1’ to 0 if it is not going to contribute to the calculation of the current grade. 4. Click on ‘Add a new assessment or tracking column’. 5. Select ‘Add a new mark assessment’ – you will need to add the same number of assessments as questions.  For a better level of analysis, it is recommended that you have an assessment for each sub-section of the question (as often a question can cover a number of topics). 6. Delete the default ‘grade’ assessment. 7. Choose your preferred display of percentage, mark or grade at sheet level - displaying percentages or marks achieved across tests means the teacher can see subtle differences, and these can  then be drilled into using the marksheet sorting (covered in later section of the document).  Below is an image demonstrating how the three options (grade, mark, percentage) would appear when in the markbook: ![](https://s3-eu-central-1.amazonaws.com/euc-cdn.freshdesk.com/data/helpdesk/attachments/production/80061253751/original/DJMP9LfdH_1KsVQDKW41O24kCvIoOfA98w.png?1639496926) Once this basic set-up is in place you can make the following adjustments: 1. Change the name of the assessments to show the question number and the associated topic/skill. 2. For larger questions you may want to split it up further (if possible). 3. The marks will need adjusting from the default 10 to the total marks available for that question. 4. Click on ‘Change’ and select ‘sum of all assessments’. ![](https://s3-eu-central-1.amazonaws.com/euc-cdn.freshdesk.com/data/helpdesk/attachments/production/80061252217/original/oK6uYxvFHUbAcqy3lqAMddYisgtLtasS1A.jpeg?1639496725) #### Appropriately naming the assessments It is beneficial to name your assessments not only with the question number, but also with the topic, or in the case of the example above, assessment objective.  When you are in a subject explorer this will allow you to search across marksheets for assessments (questions) on the same topic/skill and view them side by side. #### Including a ‘notes’ field to provide written feedback Rather than providing the student with written feedback on the paper (which they may mis-place), or in their books, you could include an open-text field in the marksheet for staff to provide some feedback: 1. Click ‘Add a new assessment or tracking column’. 2. Select ‘Add a new note column’ 3. Rename this assessment to match the schools feedback policy. ![](https://s3-eu-central-1.amazonaws.com/euc-cdn.freshdesk.com/data/helpdesk/attachments/production/80061252206/original/fN8OcBrjoRUSAjxg0FYTJNU9R6AYjuqz9A.jpeg?1639496724) #### Using colours to identify topics or skills You may wish to provide teachers with a visual representation of which questions cover which topics/skills: 1. Click on the image to open the table of available colours 2. Click on the colour you wish to be displayed in the assessment heading. ![](https://s3-eu-central-1.amazonaws.com/euc-cdn.freshdesk.com/data/helpdesk/attachments/production/80061252207/original/qIOQvJm8XWkvxl93XX4NgWN7acw-Oz86sQ.jpeg?1639496724) #### Adjusting the grade boundaries You may wish to adapt the default grade boundaries by clicking on ‘grading scheme’ and adjusting accordingly.  Please read this [article](https://www.go4schools.com/schools/Manage/Markbook.aspx?id=308632)in the help centre, or the [curriculum leaders guide](https://www.go4schools.com/schools/Ashx/GuidanceDocument.ashx?doc_gfi=4&v=2)for further guidance: ![](https://s3-eu-central-1.amazonaws.com/euc-cdn.freshdesk.com/data/helpdesk/attachments/production/80061252214/original/SJgMjoEkBd-XUkMXs_Ui7CjB6DoEuGa5zQ.jpeg?1639496725) #### Visibility of assessments to students and parents The default setting is to show assessments within marksheets to students but not parents, but you may want to adjust this.  It is worth checking whether they are hidden from students, and whether you wish this level of detail to be visible to parents.   ![](https://s3-eu-central-1.amazonaws.com/euc-cdn.freshdesk.com/data/helpdesk/attachments/production/80061252212/original/Se_BB8YkKMnE_OOoSAFAWgHkpxUrOhI-1A.jpeg?1639496725) Once completed the marksheet will appear as below: ![](https://s3-eu-central-1.amazonaws.com/euc-cdn.freshdesk.com/data/helpdesk/attachments/production/80061252209/original/jIY8rcwsbqhT2EH1HjV6k2dZgh5mYaAJqg.jpeg?1639496724) #### Using subject explorers to view QLA data You can access the subject explorer either via the ‘tools’ link in the markbook, or via the link at the top of the subject page: ![](https://s3-eu-central-1.amazonaws.com/euc-cdn.freshdesk.com/data/helpdesk/attachments/production/80061252210/original/-X3EVBmm3DotWXJyuW-mD6yM_B8yC3cmKA.jpeg?1639496724) Once in the explorer you will need to select ‘Add/remove columns’, and then select: Marksheet data \> Assessments \> The title of your markbook (in this example ‘QLA July 2018 Walking, talking mock’)\> Select the second option for each question to display the marks gained (the first option will display the marks for the question converted to a grade, and the third as a percentage, ie. 1 out of a possible 1 marks would display 100%). ![](https://s3-eu-central-1.amazonaws.com/euc-cdn.freshdesk.com/data/helpdesk/attachments/production/80061252213/original/EMMh4O6hqFkPMYwTQfg6gZEUI6yv_vIEwA.jpeg?1639496725) You may also find it beneficial to select the teaching group (in order to apply a filter), and to delete some of the default columns that are not required for this purpose. ![](https://s3-eu-central-1.amazonaws.com/euc-cdn.freshdesk.com/data/helpdesk/attachments/production/80061252215/original/lUXDXGaQuYeVaMs6UmYhTMC6KRKPwU5yFQ.jpeg?1639496725) You will then be able to view the data as below:   ![](https://s3-eu-central-1.amazonaws.com/euc-cdn.freshdesk.com/data/helpdesk/attachments/production/80061252216/original/X63UV78R-BI86wRncAnzUKZOb3OR8oPq9g.jpeg?1639496725) #### Sorting to identify students for targeted intervention *Note: It is possible to sort students either directly in the markbook (viewed either as an individual teaching group, or as an entire subject cohort) or within the explorer.  This section will cover carrying out this analysis within the subject explorer, and using the functionality direct in markbooks will be covered at the end of this guidance document.*  You may wish to apply a sort to any of the columns to view the student that achieved the highest grade in any particular question, or those who achieved the lowest.  Below the column heading you will also find the average marks achieved by students in that question, helping you to swiftly determine whether it was well answered by pupils.  You could also use this functionality to draw up targeted intervention groups. ![](https://s3-eu-central-1.amazonaws.com/euc-cdn.freshdesk.com/data/helpdesk/attachments/production/80061252223/original/sIVanzosYR1E0hLKR_it-dWYuWA57ki5tg.jpeg?1639496726) #### Saving the explorer You can save this explorer to return to at a later date: ![](https://s3-eu-central-1.amazonaws.com/euc-cdn.freshdesk.com/data/helpdesk/attachments/production/80061252197/original/YnADU18DbjSbeMWO-tmBCiflW1Psk32NIA.jpeg?1639496723) There is also the functionality allowing you to save the current sort settings and to share the explorer with others: ![](https://s3-eu-central-1.amazonaws.com/euc-cdn.freshdesk.com/data/helpdesk/attachments/production/80061252199/original/XO63WvQQlgl4-Z6ZrXE3pGBo7N2VOvriIQ.jpeg?1639496723) #### Using ‘postcard’ view to generate a Smith proforma By selecting ‘Student postcard view’ in the top right-hand corner of the explorer you will be able to view a summary which can be printed off and provided to students for them to reply to the feedback provided.  There is a tick-box provided should you wish to remove the photos prior to printing: #### Downloading to a CSV Alternatively, you can download the explorer in CSV format, and then save as a workbook should you wish to apply conditional formatting before printing off for students. ![](https://s3-eu-central-1.amazonaws.com/euc-cdn.freshdesk.com/data/helpdesk/attachments/production/80061252219/original/-93gV_AMZvyK77UErdthNFO2-Vvfoy4uog.jpeg?1639496725) #### Using markbooks to sort students by outcome From the subject page it is possible to either enter an individual class markbook, or to view the whole subject cohort within a single markbook by using the link at the top of the page: ![](https://s3-eu-central-1.amazonaws.com/euc-cdn.freshdesk.com/data/helpdesk/attachments/production/80061252203/original/Tgbx8XF-jkgQrtmuZVgffgm6UP71gjFVXQ.jpeg?1639496723) ![](https://s3-eu-central-1.amazonaws.com/euc-cdn.freshdesk.com/data/helpdesk/attachments/production/80061252222/original/AAB6xrb7q7NcmFQbaB3JiZHSxgdUhu9zEA.jpeg?1639496726)         - [FAQs](https://supporttest.go4schools.com/modular/faqs?hsLang=en-gb) - [Data Management](https://supporttest.go4schools.com/modular/data-management?hsLang=en-gb#main-content) - [Full Module Guide](https://supporttest.go4schools.com/modular/data-management?hsLang=en-gb#full-module-guide) - [General User Guides](https://supporttest.go4schools.com/modular/general-user-guides?hsLang=en-gb#main-content) - [Quick Guides](https://supporttest.go4schools.com/modular/general-user-guides?hsLang=en-gb#quick-guides) - [Curriculum Management](https://supporttest.go4schools.com/modular/curriculum-management?hsLang=en-gb#main-content) - [Quick Guides](https://supporttest.go4schools.com/modular/curriculum-management?hsLang=en-gb#quick-guides) - [Full Module Guide](https://supporttest.go4schools.com/modular/curriculum-management?hsLang=en-gb#full-module-guide) - [Behaviour Module Guides](https://supporttest.go4schools.com/modular/behaviour-module-guides?hsLang=en-gb) - [Attendance Module Guides](https://supporttest.go4schools.com/modular/attendance-module-guides?hsLang=en-gb) - [Student Report Guides](https://supporttest.go4schools.com/modular/student-report-guides?hsLang=en-gb) - [Homework Module Guides](https://supporttest.go4schools.com/modular/homework-module-guides?hsLang=en-gb#main-content) - [FAQs](https://supporttest.go4schools.com/modular/homework-module-guides?hsLang=en-gb#faqs) - [Communications Module Guides](https://supporttest.go4schools.com/modular/communications-module-guides?hsLang=en-gb) - [Consents Module Guides](https://supporttest.go4schools.com/modular/consents-module-guides?hsLang=en-gb) - [Document Management Guides](https://supporttest.go4schools.com/modular/document-management-guides?hsLang=en-gb) - [School Manager Guide](https://supporttest.go4schools.com/modular/school-manager-guide?hsLang=en-gb) - [Mobile App](https://supporttest.go4schools.com/modular/mobile-app?hsLang=en-gb) - [Report Manager Guide](https://supporttest.go4schools.com/modular/report-manager-guide?hsLang=en-gb) - [Seating Plan Guide](https://supporttest.go4schools.com/modular/seating-plan-guide?hsLang=en-gb) - [Detention Manager Guide](https://supporttest.go4schools.com/modular/detention-manager-guide?hsLang=en-gb) - [Welsh General User Guide](https://supporttest.go4schools.com/modular/welsh-general-user-guide?hsLang=en-gb) - [Installation Guide](https://supporttest.go4schools.com/modular/installation-guide?hsLang=en-gb) - [Video Guides](https://supporttest.go4schools.com/modular/video-guides?hsLang=en-gb#main-content) - [Markbooks](https://supporttest.go4schools.com/modular/video-guides?hsLang=en-gb#markbooks) - [Data management](https://supporttest.go4schools.com/modular/video-guides?hsLang=en-gb#data-management) - [Behaviour management](https://supporttest.go4schools.com/modular/video-guides?hsLang=en-gb#behaviour-management) - [Consents](https://supporttest.go4schools.com/modular/video-guides?hsLang=en-gb#consents) - [Reports](https://supporttest.go4schools.com/modular/video-guides?hsLang=en-gb#reports) - [Communications](https://supporttest.go4schools.com/modular/video-guides?hsLang=en-gb#communications) - [General](https://supporttest.go4schools.com/modular/video-guides?hsLang=en-gb#general) - [Seating plans](https://supporttest.go4schools.com/modular/video-guides?hsLang=en-gb#seating-plans) - Home - Products - Pricing - Blog - Company [![GO logo](https://supporttest.go4schools.com/hubfs/GO-logo.svg "GO logo")](https://www.go4schools.com/) [mailto:email@email.com](mailto:email@email.com) Copyright © 2026, GO 4 Schools