1. Home
  2. Assessment
  3. How to Import Assessment Data from a CSV

How to Import Assessment Data from a CSV

Note: All pages below are subject to having relevant Roles and Permissions. 

This guide will show you how to Import Assessment data using a CSV File.

This might be relevant if you have a large amount of data from CAT’s Testing, FFT or GCSE Exam Results for Year 12 Students who took exams at another school that you wish to Import into Bromcom for analysis or to use on Teacher Marksheets; or you may be migrating from another system. 

If you have a smaller dataset you want to import into a marksheet, please see How To Import Assessment Data Using a Marksheet.

Pre-requisites: You must first have setup Grade Sets and Assessment Types that are suitable for the Data you wish to Import. 

To start from the left Menu go to Modules > Assessment > Manage Data 

Click on Actions > Import Assessment Data 

Select the File you wish to Import, tick the options and click Next 

Then Select whether you want to Complete the Blanks or Update data already there etc 

To Match the data Tick the boxes and Select the correct field to match it to from the dropdown.  

Macintosh HD:Users:louise:Desktop:Screen Shot 2021-01-07 at 15.47.14.png

Then Select the data you wish to Import using the final dropdown at the Bottom.

Single Record per Student is selected by default, select this if the sheet being imported has one row per Student, if the sheet has multiple rows per Student select Multiple records per student, click the Next button.

Macintosh HD:Users:louise:Desktop:Screen Shot 2021-01-07 at 15.55.04.png

Tick the boxes on the left to select or tick the box top left to select ALL, then select from the Assessment Type, Term and Year Group dropdowns to flood fill the data, finally select the Subject. Depending on your selections from the left tick boxes you can select the Subject and flood fill or select each individually from each row. When done click Next

The Student Mapping will then be displayed, the Mapping Type will display All for those matched and selecting Exception will show those who are not matched.

Click Next and it will bring up the final page where you can see all the Assessment Types listed, the data that is in the system and what is being Imported.  

If you are happy that all is correct and as you expected – please click Import.  

You will then be asked to Confirm and Proceed.  

Finally, you will get a message saying import has been successful.  

Updated on November 5, 2021

Was this article helpful?

Related Articles

Noticed a Missing Guide?
Can't find the guide you need?
Email Us

Comments

  1. Can someone please advise what the difference is between the Assessment Results and Curriculum Assessment results are please and then what a topic result and statement result is.

    Thank you

    1. Hi Rebecca
      Assessment results are the basic form of results that teachers will enter for students that teachers enter into marksheets where as Curriculum Assessment is more for Primaries and use statements for their assessment model.
      Kind Regards
      Bromcom Training

  2. It would be really helpful to know the difference between Single Record Per Student and Multiple Records Per Student. Thanks.

    1. Hi Sarah
      Thank you for your comments.
      Single record per student is selected by default, select this if the sheet being imported has one row per student, if the sheet has multiple rows per student select multiple records per student.
      I have updated the guide
      Kind Regards
      Bromcom Training

  3. It would appear that there is a method of import that avoids step 3 – where you must ensure that your csv is in the format as explained in the bromcom windom:

    If your import file has column headers that follow the structure $ $ $ then it will be able to automatically map the various elements.

    I cannot get this to work – can you help or clarify?

    1. Hi Craig
      Thank you for your comments, can you contact the Help Desk who will assist you.
      Kind Regards
      Bromcom Training

  4. How can you import CAT data which isn’t linked to any particular subject?

    1. Hi Mukesh
      Thank you for your comments. When importing data you do need to assign this to a subject. As a suggestion you could create a subject called CAT in Groups.
      Kind Regards
      Bromcom Training

Leave a Comment