Introduction

In this final example of colours in marksheets we use the NESTED-IF-THEN-ELSE formula to compare a target grade with an actual grade.

• If the actual grade is higher than the target grade we will colour the actual grade green.
• If it's the same as the target grade, yellow.
• If it's less than the target grade we will colour the actual grade red.

Many schools refer to this as a RAG system, short for Red, Amber, Green.

Summary

You now have the skill to create a basic but fully functional assessment system for your school. I've picked the formulas and techniques that are used by 90% of the schools. If you can apply these tools and techniques to your school's requirements you will have a flexible, robust, easy-to-use assessment system built on the powerful SIMS database engine.

Any Questions?

Use the comments section below