Importing Students into Testwise using the Wonde Portal

Wonde & GL Assessment / GL Education Relationship

Wonde connects to the information that is held within a school’s MIS (e.g. Capita SIMS, WCBS and Engage) and uses this information to produce a CSV to be uploaded into your TestWise account - making the process much easier!

This user guide will give step by step instructions as to how to do this.

Step 1: Contact Us

To start the process, if you have not already done so, please contact GL Assessment / GL Education via one of the following methods stating your interest:

  • E-mail: [email protected] with ‘Wonde’ in the subject heading.
  • Telephone: 0330 123 5375, option 3.

Please provide the following details:

  • School Name
  • Postcode (or City, if you do not have one)
  • Contact Name
    • (please note this should be someone who has the relevant authority to approve access to your school’s Management Information System)
  • Contact E-mail Address Contact Telephone Number

We will then provide support (via e-mail or telephone) to begin the process of creating the connection with Wonde.

Once we have provided that support, you can then move on to Step 2 of the process.

Step 2: Logging Into The Wonde Portal

If you have administrative access to Wonde for your school, you can log in using this link:
https://edu.wonde.com/login

If you are unsure whether you have previously activated your Wonde account or if you would like to set one up, please contact [email protected] who will be happy to help.

From here, you can login by searching for your school.

Search for your school; you can use your school’s postcode or school name:

Login screen for Wonde showng a search box to look up your school and a QR code login

Enter your email address or username and click the ‘Send magic link’ button:

A log in screen asking for username or e-mail or for you to log in with Magic Badge or Emoji password

Check your email and enter the code presented within the e-mail

An e-mail icon confirming a 6-character verification code has been sent to your e-mail address

Step 3: Approving the GL Assessment Connection

Within the Wonde Portal Dashboard, select the GL Assessment tile

The dashboard when you log into Wonde, with the GL Assessments logo

Click on ‘Permissions’

The settings for GL Assessment, showing the Permissions option highlighted

From the permissions page you can take ownership of the data you would like to share with GL Assessment/GL Education.

Clicking the ‘Student’, ‘Groups, Classes & Subjects’ & ‘SEN’ drop downs will show you the specific student data you will be allowing usto access.

Some of these data fields are mandatory in Testwise and they are therefore also mandatory within the Wonde portal.

However, there are optional fields that you can control within the Wonde portal, simply by enabling or disabling fields via the toggle function.

A dropdown to show permissions that can be set for GL Assessments, including "Students", "Groups, Classes & Subjects" and "SEN"
An example of permissions you can grant for GL Assessments

When you are happy with the data you will be providing to GL Assessment/GL Education, click the ‘Approve Access’ button

Highlighting the Approve Access button on the page where you grant GL Assessments permission

And then 'Approve Access' again on the Confirm Action dialogue box

Approve Access confirmation in a pop-up dialogue box

At this point, Wonde will be sent a notification informing them that you have approved access and they will then conduct an internal audit to ensure the connection is in place and the reports are running correctly.

If there isn’t an existing Wonde connection at your school then you will be taken to the following page.

Depending on the MIS your school uses, you may be asked to book an appointment with a member of Wonde’s integration team (these appointments take approximately 15 minutes).

An example form for scheduling the Wonde installation

This audit can take up to a day and you will therefore need to come back to the Wonde portal to download the CSV file once this audit has been completed - please check back after a day has passed.

Step 4: Access Control

Once your school has approved the connection and passed Wonde’s internal audit process (i.e. the connection is in place and the reports are running correctly) both the ‘Access Control’ and ‘CSV Download’ option can then be selected.

The Access Control option allows the school to remove users from the TestWise CSV Dow nload (i.e. if a parent doesn’t want their child ’s details being shared with GL Assessment /GL Education ).

GL Assessments dashboard, with the "Access Control" option highlighted in a red box

You will be presented with 3 options, select which option is most appropriate for your needs:

  • Allow access to all users: This means that all users data will be available to GLAssessment/GL Education.
Radio button selected for "Allow access to all users";
  • Exclude certain users and allow access to all others: This will allow you to exclude studentsfrom the data provided to GL Assessment/GL Education.
Radio button for "Exclude certain users and allow access to all others" selected, with certain students checked to be excluded
  • Allow access to certain users and exclude all others:This will allow you to approve access to only certain studentsand to exclude the remaining students within your school when providing data to GL Assessment/GL Education.
Radio button for "Allow access to certain users and exclude all others" with some names check to include them

Step 5: CSV Download

When a user has approved access to GL Assessment/GL Education they can then download a CSV fileto upload into their Testwiseaccount.

Click ‘CSV Download’ from the Wonde Portal dashboard:

GL Assessments dashboard with the CSV Download option highlighted in a box

From within this section, click the ‘Download CSV’ button

The download CSV button

Identifier

Now you are asked to select a unique identifier for use within Testwise.

If you are a current Testwise user, then it is very important you select the unique identifier you have previously used for your students within Testwise.

If you are new to Testwise, then we would suggest you use the ‘UPN’ value if thisis available to you.

Filter Entries

Now select whether you want to download all students from your school’s Management Information System or only students from a class or group:

A list of options for when you are downloading a CSV

When you click ‘Download’, your file will download and save to your ‘Downloads’ folder on your device.

You can then import the students selected into Testwise.

Step 6: Importing the CSV Into TestWise

  1. Ensure that the students you wish to update are in the file produced within the Wonde portal.
  2. Edit your Student List in the csv file created from the Wonde portal if required.

Note: The unique identifiers in your file must match Testwise to update a student. If a different unique identifier is used then a new student record will be created.

 

  1. Once you are happy with your student list and it is ready to import,click the Students button from the home screen within Testwise.
Students icon
  1. Click the Import Students button to display the Import Students page.
Import Students button
Screenshot of the Import students instructions and the browse button
  1. Click the Browse button to display the Choose File Upload box. Then navigate to the .csv file you have downloaded from the Wonde portalto import and then click the Open button.
  2. Verify the student details on the page and then click the Import button to complete the update process.

Note: Student data included in the csv file will be coloured blue and considered updated even if you have not made any changes to the student record.

Note: If the data has not passed the verification process, then the Import button will change to 'Retry Import'. To correct the errors in the data:

  1. Identify exactly where the errors are by finding the fields highlight in red within the data grid. Scroll through the full list of students to find all theerrors. The data that is missing or incorrect will have a red box around it. To find out more information about each error hover your mouse over the red warning marker shown in the last column of the row.
  2. Open MS Excel (or the CSV editing software), and then open the file that contained the errors.
  3. Correct the errors in the file.
  4. Save the changes you have made.
  5. Click the 'Retry Import' button.
  6. Repeat step 5 (above).
  1. Click Import if the changes highlighted in the summary are correct. Note: If you are not happy with the changes in the summary page you can simply edit the file again and re-upload.
  1. Once your update file has been processed you will be sent an email confirming the success of your upload.
Example of a successful upload e-mail
  1. Now that you have received confirmation of your updates/import you can go back into the Student List and check that the required changes have been made.
  2. To return to the home screen, click the Home button