Tracking learner performance per term and across the grades

Tracking learner performance per term and across the grades

GDE has issued an availability of management documents task for schools.

One of these requires a learner academic and attendance tracking tool.

It must have the child's Term 4 end of year mark and level and then same for the new year term 1, term 2, term 3 and 4. it must show their attendance as well.

See my excel sample. This took a long time to create so I would like a similar report I can draw from d6.

Thank you