Depending on how you have designed your Excel sheet, and on the results it contains, it is possible that you might want to identify the same result details for more than one column.
For example, you might want to identify several columns with the same Aspect and then select each one individually and identify different result dates. Or, you might select a number of columns, each already identified with a different Aspect, and associate the same result set and/or result date with all of them.
NOTE: Map the Aspects before applying a result date or result set. This will ensure that neither is subsequently overwritten by the selection of Aspects.
Click in the first cell of the first required column and drag across and then down the required adjacent columns; alternatively click Shift and then click each required column.
NOTE: If necessary in order to select the required adjacent columns, you can change the order of the columns by clicking in the Header column of the required column, holding down the mouse button and dragging the column to the required location.
Right-click anywhere in the Header rows and select either Aspect, Result Set or Result Date, as appropriate, from the pop-up menu.
Depending on your selection, the Aspect browser, Select Result Set dialog or Select Date dialog is opened. These can be used to map details (please see Mapping Result Columns – Selecting a Single Column on page 246).
Clearing Column Headers
The column header information can be cleared from any column. For example, if you do not wish to import a particular set of results, for the purposes of the current import only, you can delete the mapping information displayed in the header of the column containing those results.
This would not delete the column from the Excel file, so the column and its results will still be there if you import the file again.
Select the first few cells of the relevant column, by clicking in the first cell of the column and dragging downwards.
You can select multiple adjacent columns, if you wish.
Right-click anywhere in the Header rows then select Clear from the pop-up menu.
When asked for confirmation, click the Yes button to clear the column header(s).
If you do not wish to import results for a particular pupil/student, perhaps because the pupil/student has left, you can delete the relevant pupil/student row. As with clearing column headers, the pupil/student and their results will still be there if you import the file again.
You might also wish to tidy up the import by deleting any rows containing information that won’t be imported.
Click in the required row and then right-click in the number column, (the column on the extreme left), and select Delete Row from the pop-up menu.
You can select and delete multiple adjacent rows, if you wish.
When asked for confirmation, click the Yes button to delete the row.
When you have finished working in this page of the wizard click the Next button to continue.
The system will now use UPNs to match pupil/students in the import file with pupil/students in the school database.
For pupil/students unmatched on UPNs, the system attempts to match them on Surname, Forename, Gender and DoB. You can then accept these matches or carry out a manual match. Where a ‘best guess’ match has not been possible, the Students from the database field is blank and you will need to match the pupil/student manually. Where more than one match for a pupil/student is found then you will need to carry out multiple matching.
If no match is found for a pupil/student from the Students from the input file grid, then the corresponding row in the Students from the Database grid is blank.