ICTinspires Computing Assessment is designed to accompany the ICTinspires Computing Curriculum. It is a quick and easy method of recording and reporting pupil assessments, measuring against ICTinspires Computing Curriculum guidelines and against National Curriculum objectives.
ICTinspires Computing Assessment is an in-house Excel based product using macros that allows users to import and maintain basic pupil information, create classes, attach pupils to classes and assess pupils against ICTinspires guidelines and National Curriculum objectives.
The system will store assessment information from EYFS to Year 6 to enable assessment history to be viewed and performance gauged. Emerging, Expected and Exceeding levels are recorded against each strand and sub-strand of the ICTinspires Computing Curriculum to facilitate a clear strategy in making teachers aware of individual pupil progress and adjusting teaching methods accordingly.
The program is designed to be intuitive and this help file breaks down each module into its basic operation. The Main Menu section is laid out as it appears on the screen and each topic hyperlinks to detailed help sections.
You will receive your licenced copy of the program via email. The email will provide detailed installation instructions.
|Change My Password||User Maintenance|
|Exit Program||View Pupil Assessment History|
Because this is an Excel based program you may well be using Excel to do other tasks. This is fine but occasionally Excel will drop necessary information required to run this program. If this happens, you will be prompted for your username and password. Alternatively, you can click this button to login. You would do this if you were sharing users on the same device.
User Maintenance (Administrators only):
By default, installation creates a user called ‘Administrator’ with the password ‘admin’. This enables initial access to the system and can be disabled once regular users are set up.
There are two tabs, ‘Amend an existing record’ and ‘Add a new record’.
Amend an existing record
Unticking the ‘Active User’ tick box will stop the username appearing in the drop-down box when logging in. It will still appear in ‘User Maintenance’ should you wish to reinstate the user. Click ‘Update Record’ to save changes and select ‘Main Menu’ to exit.
Add a new record
The ‘Admin Access’ tick box, if ticked, will allow access to ‘User Maintenance’. All other aspects of the program are open to all users.
Change My Password:
From time to time it may be necessary to change your password. This is a simple process and requires you to enter your current password, new password, repeat this then press ‘Ok’.
There are two tabs, ‘Amend an existing class’ and ‘Add a new class’.
Add a new class
Classes are an important link between pupils and assessments. A pupil is attached to a class and the class holds the year group so it is essential that the year group assigned to a class is correct. All the assessment criteria will be aimed at the relevant year group for the class. The class ‘Description’ is optional.
Amend an existing class
To delete a class, untick the ‘Active User’ box and click ‘Update Record’. Select ‘Main Menu’ to exit.
Pupils can be added in two ways, either individually via Pupil Maintenance or by bulk upload via ‘Import Pupil Data’.
Import Pupil Data
To upload pupil data, the input file must be laid out as shown in the example. The format can be .csv, .txt or Excel.
Once the input file is ready, click on ‘Import’ and a file selector window will open allowing you to navigate to the prepared file. Click ‘Open’. The program will perform a number of checks to ensure the data is valid and any discrepancies will be reported. The program will abort to enable you to rectify the problem.
Once the data is validated the program will APPEND the imported pupils to your existing data file. This enables you to repeat this process each school year to minimise time spent keying in.
N.B. If you are not a local authority maintained school UPN refers to any unique pupil number. It does not need to be 13 digits or alphanumeric but must be unique to the pupil.
Fields with a red border are mandatory. You will note ‘Class’ is not a mandatory field as you may need to add a pupil before knowing which class they will belong. However, no assessments can be carried out until the pupil is added to a class.
There are two ways to delete a pupil. Using ‘Pupil Maintenance’, untick the ‘Active Pupil’ box and ‘Update Record’. The second method will be explained later ‘EOY Pupil Class Change’ and it is left to the user to consider the most appropriate method.
Click ‘Update Record’ to add the pupil or save amendments.
On occasion it may be necessary to change a pupil’s surname. In the ‘Amend an existing record’ section you will see the ‘Amend Surname’ button. Clicking on this will open a small window in which you key in the new surname. After confirming, the program will update the pupil and assessment databases.
Although pupils can be allocated a class via ‘Pupil Maintenance’ or via ‘Import Pupil Data’, Pupil/Class Allocation gives the overview of the whole school and amendments can also be made.
N.B. Pupils can only be allocated to one class.
The left-hand window displays all pupils in the school in alphabetical order by surname, the total number is shown beneath the window (373 in the example).
The middle window shows all classes within the school. When a class is selected, the pupils allocated to that class are shown in the window at bottom right.
Pupils allocated to class
The pupils within the selected class will be shown here. The example shows 29 pupils allocated to Class1.
Pupils with no allocation
The top right window should be empty but will display any pupils that have not been allocated a class (in the example there are 10).
To allocate a class to a pupil, first select the required class then either scroll down the ‘Pupil List’ or select from the ‘Pupils with no allocation’. Double click the pupil and they will be added to the pupils in the ‘Pupils allocated to class’ window. The pupil will disappear from the ‘Pupils with no allocation’ window and the new class will be added to the pupil in the ‘Pupil List’ window. To de-select a pupil, simply double click from the ‘Pupils added to class’ window and the process will be reversed.
A form will open asking you for the class you wish to assess. Make your selection and press ‘Ok’. This is quite a busy screen, so we’ll cover each section.
At any time, you can press the ‘Main Menu’ button to return to the main selection screen.
Listed down the left-hand side are all the pupils allocated to your class selection. At the top right of the screen you will see both class and year group.
The column headings are mapped to ICTinspires Computing Curriculum with each strand and sub-strand colour keyed to match.
By clicking on each sub-strand, Assessment Criteria will be displayed under the heading (in the example ‘Design, write and decompose’). In the case of KS1 both Approximate Year 1 and Year 2 levels are shown.
At any time, you can click on the ‘Show National Objectives’ button to show the overarching NC objectives. This is colour coordinated to the ICTinspires Computing Curriculum strands.
Pupils can be assessed individually by clicking on the required cell. Each click will cycle through the options; first click is ‘Emerging’, second click is ‘Expected’, third is ‘Exceeding’ and another click will go back to a blank cell.
Assessments can also be made in bulk by row, column or whole class. You will notice chevrons along each column heading, down the left-hand side to the right of the pupil names and at the top, left of the assessment area. Clicking on any of these will add assessments accordingly. Take some time to select various options, nothing is committed until you press the ‘Save Assessments’ button.
By assessing the whole class as ‘Expected’ you have a starting point from which to select pupils individually who are ‘Emerging’, ‘Exceeding’ or who missed the assessment ‘blank’.
The ‘Reset’ cell to the right of the ‘Assessment Criteria’ heading will reset the entire screen.
N.B. If you click too quickly you may receive an error message. Simply click the ‘OK’ button and continue with your assessments.
Once you have completed your class assessment, select the ‘Save Assessments’ button.
Load Previous Assessments
This button will load the last assessment within the academic year for the class. There can be a large amount of data to load so this may take a little time. Once loaded, you will see the cell colours are slightly muted to differentiate between previous and new assessments. Hovering over a cell displays a comment showing the date and time of the last assessment and the name of the assessor. Any cell can be changed as above in ‘Assessing pupils’ and will display in the brighter colours and can be saved via the ‘Save Assessments’ button. In fact some teachers may take the approach of loading previous assessments as a base for making the current assessment.
Pupil Progress Chart
Clicking on individual children from the class list on the left will display a thumbnail of the ‘Pupil Progress Chart’ near the top of the screen. Clicking on the thumbnail will open a larger image of the chart showing the pupil’s achievement against class average. The nearer the perimeter of the circle denotes a higher level of achievement. In the example Robert is well above class average in Logical Reasoning, Electronic Communication and Digital photographs & video but well below class average in five areas; input, output & variables, spreadsheets, graphics, data handling and conduct within online safety.
Detailed Assessment View
The ‘Detailed Assessment View’ displays the assessment history for the child, term by term and year by year, both by ICTinspires Computing Curriculum objectives and National Curriculum objectives. An overall summary achievement is given by algorithm. The child in the example has completed KS1 with an overall achievement of ‘Expected’. Charts above and below would show EYFS and KS2 assessments where applicable.
Assessment for each module is calculated as 1=Emerging, 2=Expected, 3=Exceeding. When grouping these figures for National Curriculum comparisons the results are not whole numbers. It is therefore necessary to band achievement levels for a meaningful report. The default bandings used are 1.8 and 2.3. This means an achievement between 1.8 and 2.3 will be considered Expected. Below or above these figures will be considered Emerging and Exceeding respectively. If you would like to change these bandings, you can do so by amending the figures and clicking ‘Update Bandings’.
The ‘Show NC Progress’ button displays an overview of the whole class against Computing National Curriculum objectives to ensure pupils are on target for their year. The coloured cells display the child’s overall assessment for each objective.
To break down the National Curriculum objectives into more manageable modules an NC objective can be a combination of several sub-strands within the ICTinspires Computing Curriculum. Selecting a cell will display a breakdown of the attainments for each sub-strand. We can see from the example that Robert’s overall assessment as ‘Expected’ in one NC objective is made up of two areas in which he is ‘Exceeding’ and two ‘Emerging’. His teacher can clearly see the areas of weakness.
View Pupil Assessment History:
This is a quick and easy method of viewing any pupil’s assessment history. Enter the Pupil’s name and select a curriculum strand from the drop-down box below, then press ‘List Assessments’.
The list will show class history, all assessments, their dates, assessor, sub-strand and Assessment.
EOY Pupil Class Change:
At the end of each year it will be necessary to re-allocate pupils to different classes. This module will allow bulk class changes or individual pupil changes. First ensure all the classes for the new year are correct in ‘Class Maintenance’. Select the ‘Existing class’ and the ‘New Class’ and either double click individual children to move them or ‘Move Whole Class’. A warning message will ask if you have already moved pupils out of the new class as it would be time consuming to move them after re-allocating new pupils. It will also warn if a pupil is being moved into a younger age group. Both warnings can be ignored and pupils can still be moved.
There is also a special ‘Leavers’ option in ‘New Class’ for pupil moving school who will no longer be part of this assessment process. Moving a pupil or class to this selection will remove the pupil from the pupil database to an archive file. It will also remove all assessment history from the assessment database to an archive file. These records will no longer be available to this program. As stated earlier, this is an alternative method of removing a pupil and is more complete in that all records are removed from the database. Using ‘Pupil Maintenance’ renders the pupil ‘Inactive’ and whilst he is not available to the system, any assessments will remain in the database.
As a suggested end of year routine, schools should move their year 6 class pupils to ‘Leavers’ thereby leaving the year empty for moving the year 5 class pupils into year 6. Repeating the process will enable all pupils to me moved in the space of a few minutes.