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. If you are using Tracking System 1, the cells should be populated with the grade descriptors that your school uses at KS3 to assess attainment such as ‘Working beyond’, ‘Working at’, ‘Working towards’ etc and these need to be different from your Start Bands. If you are using Tracking System 2, the cells should be populated with the same descriptors/grades used for your Start Bands.
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.
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 ...
Ascent Setup Wizard
When accessing Alps Ascent for the first time, you will be prompted to complete the Setup Wizard. The wizard allows you to select which Ascent Tracking System you are using, configure your Start Bands/Grades and setup any excluded grade values. If ...
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 ...