Contents x
    How to export and import student data
      • Print
      • Dark
        Light
      • PDF
      Contents

      How to export and import student data

        • Print
        • Dark
          Light
        • PDF
        Article summary

        Student attainment data is stored within aspects and result sets in ProgressTeaching. This allows schools to store and analyse different types of data such as:

        • Targets
        • Current & Predicted grades
        • KS2 scaled scores
        • Reading ages
        • CATs scores

        There are two ways to upload data into ProgressTeaching.

        1. Excel spreadsheet - this involves building your own spreadsheet.
        2. Export sheet - this involves exporting aspects from ProgressTeaching.

        Video guide

        Uploading via Excel spreadsheet

        This is an alternative way to upload data into the system that allows users to build their own spreadsheet from scratch.

        1. Start with a blank spreadsheet, and insert student UPN data going down the sheet from cell A4.

        2. Enter the aspect that you want to upload data for in cell B1, as well as the result set directly under it.

        2023-02-08_10-59-13.png

        1. Change cell B3 to a text type field.

        2023-02-08_11-01-55.png

        1. Enter the date of the result in cell B3 in the format YYYY-MM-DD.

        2. If you want to add data for additional aspects and result sets, repeat the above steps going across the sheet.

        3. When ready, copy the student data in.

        4. Access the Admin area.

        5. Select Progress > Student Result from the menu.

        6. Select Import V2 from the page.

        7. Browse for and upload your file. Select Import when ready. This page should refresh and display a message saying that it was successfully uploaded.

        Uploading via Export sheet

        1. Access the Admin area.

        2. Select Progress > Student Result from the menu.

        3. Select 'Export'.

        4. At the top of the page, choose the year group.

        5. Click the plus icon to add a new line to your export sheet. Multiple lines can be added.

        6. Enter the aspects and result sets, and export when ready.

        If you will be using this export sheet again, you can save it as a template. To do this, select Save Template.

        Templates can be loaded by expanding the area Templates.
        2023-01-05_10-55-43.png

        1. Once exported, any lines that you added to the export sheet will display in column M onwards.

        2023-01-05_10-57-46.png

        The exported spreadsheet has hidden identifiers in certain cells that need to be kept in place so that the sheet can be imported correctly back into the system.
        2023-02-01_14-42-32.png

        Due to this, please use VLOOKUP formulae when uploading data and please refrain from adjusting the first three rows of the spreadsheet in any way.

        1. if you want to make changes and upload the data back into PT, access the Admin area again.

        2. Select Progress > Student Result from the menu.

        3. Select 'Import'.

        4. Browse for and upload your file. Select Import when ready. This page should refresh and display a message saying that it was successfully uploaded.

        Was this article helpful?
        What's Next
        Example form