It is possible to add a note to any result displayed in a marksheet. These notes are used for information relating to the result itself, including why a result has changed or perhaps why the performance was not as expected (e.g. poor health, bereavement, etc.). You can also edit an existing note.
Select the required marksheet (please see Selecting Marksheets on page 8).
Right-click the result cell to which you wish to add or edit the note and select View/Edit Notefrom the pop-up menu to display the Edit Notesdialog.
Enter/edit the note as required.
Click the Updatebutton to return to the Marksheet Entryform.
NOTE: If you have appropriate permissions, you can also edit the content of a saved note via the result history (please see Editing Existing Results in Marksheets on page 44).
Marksheets can include columns that calculate data based on the contents of other columns. For example, one column could display the mean of three other columns displayed in the marksheet. Such columns are usually read-only, but can sometimes be set up so that you can overtype the calculated result, if required.
Columns containing formulae can be identified by the presence of an fsymbol in the top right of the column heading.
NOTE: To make sure calculations are meaningful, it is advisable to calculate only when all results have been entered in the marksheet.
Marksheets can be set to calculate results automatically on data entry. If the Calculate on Data Entry check box is selected in the template from which the marksheet was created, results are calculated for all summary rows and formula columns when you press the Enter key or when the cursor leaves the current cell. Calculations are carried out only when marksheet data is changed.
Calculating All Columns
To calculate all the columns on the marksheet, click the Calculate Allbutton. Columns are calculated from left to right using the default column order.
Calculating a Single Column
There may be occasions when you wish to calculate one column at a time. This is achieved by right-clicking the required column heading and selecting Calculate Columnfrom the pop-up menu.
Overwriting Calculated Results
Unless a formula column is read-only (pale green background), you can, if necessary, overwrite a calculated result. This may be required for example, if a formula was used to predict a result that you feel is inaccurate.
Position the cursor in the required cell and overtype the calculated result.
NOTE: If you calculate again, your overwritten result is replaced by the newly calculated result. You must therefore make sure that you save a required overwritten result before performing any subsequent calculations.
Viewing Additional Pupil/Student Information
To access individual pupil/student information, click a pupil/student’s name on the left-hand side of the marksheet to display the Teacher View page, which displays an ‘at a glance’ summary of their attendance, behaviour, achievements, etc. For more information on using the Teacher View page, please refer to the Using the Student Teacher View chapter of the Managing Pupil/Students in SIMS handbook. All handbooks can be accessed from the Documentation Centre, which is launched by clicking the Documentationbutton on the Home Page in SIMS. Once open, click the Handbooksbutton, select the required category, then click the required handbook from the Handbookspage.
Click the Savebutton on the Focus Bar to save the results entered/edited in the marksheet.
Clicking the Save button will automatically calculate and then save. If the marksheet contains Formula columns for data review, you will then need to click the Calculate button in order to view the output of those columns after saving (for example, to see the Missing Entry results in a Key Stage marksheet).
Considerations Before Saving
Marksheets are simply the mechanism for entering results. All results entered in a marksheet are displayed in red until you save, when they are stored in a database independently of the marksheet.
Depending on the way the marksheet has been set up, the entered results will either append to an existing result history or overwrite an existing result if the result is associated with a result set (which is usually the case for exam or Key Stage results, where only one result needs to be stored).
IMPORTANT NOTE: Results are appended each time a result is entered for the same aspect and Pupil/Student, but with a different result date. This enables you to correct any errors on a marksheet entered on the same day.
It is important to note that the date selected in the Result Datedrop-down list is the date of attainment (i.e. the date the result was awarded), not the date the results are entered. You will need to be aware of the impact this date has on the saving of results when a marksheet is saved.
When you enter a result in a marksheet that is subsequently saved, the result is essentially saved as follows:
If you reopen the marksheet and elect to change the result for John Smith, but the result date remains at 05/05/07, you will overwrite the result that was recently saved. This is because there can be only one result per aspect, per pupil/student per result date.
If you wish to retain the original result and append a result of 85 for example, you MUST select a different result date. Two separate results will then be recorded, indicating that two results were attained.
This becomes a particularly important factor when you have partially completed a marksheet on one day and wish to update and add some results the following day. In this situation, you would have to change the result date to the date used the previous day to make sure that any edits made to the results overwrite those stored yesterday.
To enter results for an entire column with a new result date, right-click in the column heading, select Blank Column, enter the results as normal and save the marksheet. The changed results are saved with a new result date.
To enter an individual grade result with a new result date, right-click in the cell and choose Select Grade for Celland save the marksheet. Alternatively, for any result type, delete the cell content, enter the new result and save the marksheet. In each case, the new result is appended with its result date to the result history. To confirm that the changes have been made, right-click in the cell and select the View/Edit Result History option.
A marksheet can be flagged as a favourite, so that it can be accessed from the Favourites shortcut panel in SIMS. This provides quick access to frequently used marksheets, avoiding the need to search for the marksheet using the Find Marksheetbrowser (please see Selecting a Marksheet from the Favourites Shortcut Panel on page 9).
Select the required marksheet (please see Selecting Marksheets on page 8).
Click the Favourites button on the toolbar to add this marksheet to the Favourites shortcut panel.
Repeat this process for any other marksheets you wish to add to the Favourites shortcut panel.
Renaming a Marksheet’s Display Name in the Favourites Shortcut Panel
The display name of a marksheet displayed in the Favourites shortcut panel can be changed. This enables you to provide a more easily recognisable name for a marksheet you use on a regular basis.
NOTE: Only the shortcut link in the Favourites shortcut panel is renamed. The name of the marksheet (as displayed in the Find Marksheet browser and on the marksheet title bar) is unaffected by this change. Any renaming of the marksheet shortcut affects that user only.
Removing a Marksheet from the Favourites Shortcut Panel
In the Favourites shortcut panel in SIMS, right-click the marksheet you wish to remove as a favourite and select Remove from the pop-up menu.
Repeat this process for any other marksheets you wish to remove from the Favourites shortcut panel.