Step 6 - Creating the results page
The final few steps are to create comments and produce a results page. The comments will be the feedback to the user to say how well they have done in the quiz. It will also provide the basis of the search in the database task.
 |
The analysis will effect at least one of your publications. If you make mistakes here then the publications will not be correct. You could end up loosing marks in strand D and strand C. |
The image above shows a comment table for fitness. Have a look at the example spreadsheet for more details. The scores on the left range from the smallest score for fitness to the largest. You do not need to create a comment for every score but you DO need to start from the lowest and end in the highest score.
A VLOOKUP will then be used to produce a comment for the user. The comments need to be suited to the auidence. Watch this video for more details on how to do this.
The results page will be designed EXACTLY like your questions page. Look at the example spreadsheet to see what we mean.
|
To copy information in Excel you need to type in "=" and then click on the cell you want to copy. This means that if the origonal cell changes then the copy will as well. |