Uploading Ascent KS3 Gradepoints

Preparing Data

To import monitoring data into Alps Ascent, you will need to prepare a .csv file structured as follows: one column for Student ID, then one column per Subject. Each row should represent one student and their grade/performance in each subject for that Gradepoint. The cells should be populated with the score mappings that your school uses at KS3 to assess attainment such as ‘Working beyond’, ‘Working at’, ‘Working towards’ etc.

To access our Gradepoint template file, navigate to the Data Management tab, select Gradepoints and click the Template File button to download. 

Example Gradepoint Files

Below are two example of Gradepoint files: 

Uploading Gradepoint Files

To import your Gradepoint file, navigate to Gradepoints in Data Management and click Upload File. In step 1 of the import page, select the academic year and year group, then click next: 

In step 2, select your Effective On date. This will be displayed as the Gradepoint's name across Ascent, it can be a date in the past or future. 

In step 3, select the .csv file you wish to import and click Upload. The file will be validated and a green notification will appear when uploaded successfully:

Fixing Errors

If any errors are identified in the import validation, e.g. a duplicate Student ID or a Student ID that has not been import in your Student File, an alert will appear. To see what the error is, click View Issues

This will open the errors page which identifies the error found and which row of the file it is located on:

 

To fix errors, you can delete the Gradepoint file and reimport the corrected file.

Attainment Grade Mappings

After importing your first grade file, navigate to the Settings tab and click Grade Mappings. 

In the Grade Mappings page, the table shows the grade values imported. Drag and drop the values to order the table so your highest grade is at the top and lowest is at the bottom. In the Expected Grade column, select your 'on track' grade, this will be your zero point with grades above scoring positively and grades below scoring negatively. 

If you have any values that aren't a grade, e.g. 'Absent', 'N/A', click the relevant tick box in the Excluded column.

• Related Articles

• Uploading Ascent KS3 Students File

  Preparing Data To import students into Alps Ascent, you will need to prepare a .csv file structured with the following columns in order: Student ID, Forename, Surname, Gender, Disadvantage, SEND and EAL. To access our Student template file, navigate ...

• Uploading Ascent KS3 Start Bands

  Preparing Data In Alps Ascent, students require a starting point from which progress is measured. This is called the Start Band. At the beginning of KS3, each student is assigned a start band based on available prior attainment data, this might be ...

• Introducing Alps Ascent: Key Stage 3 Tracking and Analysis

  Product Overview Alps Ascent is a brand new Key Stage 3 tracking and analysis platform designed to help schools monitor student progress and attainment across the Key Stage 3 curriculum. Built on a flexible start band model, it gives KS3 leaders a ...

• Alps Ascent KS3 Tracking Systems

  Understanding KS3 Tracking Systems in Alps Ascent Before getting started with Alps Ascent, it's essential schools check which tracking system best suits how they monitor and report student progress across Key Stage 3. From our market research, we ...

• Editing Grades

  This article will show you how to edit the grades you have already imported into Connect Data, including examination results, monitoring grades and personalised targets. You can edit grades individually, or make bulk edits - this is also how you can ...