We donít have ticks but instead have shaded boxes. You could easily adjust it but I prefer the shaded boxes!
| || ||Support Required ||Slightly Below ||At Expected ||Slightly Above ||Above |
|Handwriting ||1 ||SHADED || || |
|Spelling ||3 || || ||SHADED || || |
|Grammar ||4 || || || ||SHADED || |
In the second column is the data from SIMS, that teachers enter on their mark sheet. I set the formatting on the font so it is very small and white and I format the table so that it doesnít look like that column is there.
Then, in the Individual Report, you need to insert the macro that Iíve pasted below. What it does is:
1. Count how many tables there are and loop the code around each one in turn. For each table:
a. Count how many rows there are and loop around the rows in turn. For each row:
i. Look at the value in column 2 and take the first digit (just to clean it up a bit)
ii. Based on that value, shade in a specific cell.
It goes in here:
- Microsoft Word Objects
- This Document
∑ You must have Macros fully enabled.
∑ The colouring in script runs when word opens. This means that it colours in when you go to Preview, or Print. If you save then it will run when you double click on the document.
If you press upload, then it does not store it Ďcoloured iní. In theory, it should work when you open it. However, currently this is broken! I havenít looked at this yet, but if anyone has a solution please let me know!