How to show percentage attendance within a marksheet

FAQ – To show percentage attendance within a marksheet

 

To enable you to colour code the percentage attendance within a marksheet as it is not possible to colour code Additional Student columns

 

Above 95% is green

Between 90%-95% is yellow

Below 90% attendance is red

  1. Create an aspect called “Percentage Attendance” (Focus/Assessment/Aspect and click on new) . Choose Type: marks decimal.

Min value = 0.00

Max value = 100.00

 

  1. Open the template and click on New to create a new column.

 

3.    Choose “Add columns for additional Student information”

 

  1. Tick “Percentage attendance”

 

  1. Add a column to the template using “Add column for data entry“.

 

  1. Use Next to go past the Result Set and click on Next again

 

  1. Select the aspect created “Percentage Attendance

 

  1. Select Finish

 

  1. Save the template

 

  1. Move this column up so that is underneath the additional student column- percentage attendance.

 

  1. Add another column using “Data review using formula” Select Next

 

  1. Enter a Heading for the Column – RAG percentage attendance

 

  1. Choose Formula Type = Nested if then else

 

(see screenshot below showing how to configure the IF, THEN, ELSE formula)

 

.Percentage Attendance

14. Select Finish

15.Save the template

16.Move the RAG Percentage Attendance column next to the other two percentage attendance columns and Save.

17.Open the marksheet

18. Copy the entries from the Percentage Attendance Column (pre-defined column) into the newly created Percentage Attendance Column and then select Calculate.

 

Reviewed 21/02/2018

Posted in SIMS.net and tagged , , , , , .