Find which students need extra help from a marks sheet
Spot who is slipping, in which subject, before the exam.
- ForClass teachers and coaching centres.
- HelperNone needed
- ModeBerri Mango 1
- AttachExcel sheet
Copy the prompt
This sheet has marks for [number] students across [tests]. Find students below [percent] in any subject or falling across tests, and suggest a simple plan for each group.
Change the words in [brackets] to your own.
What to attach
An Excel sheet (.xlsx). Berri reads the first sheet, so keep the data there.
Run it
Berri opens with the prompt filled in. Nothing is sent until you press send.
Run this in BerriTips
- Use roll numbers instead of names when you share marks.
- Ask Berri to draft a short, kind note to parents.
Find which students need extra help from a marks sheet
XLSmarks-term1.xlsx
This sheet has marks for 42 students across three unit tests. Find students below 40% in any subject or falling across tests, and suggest a simple plan for each group.
Reading marks-term1.xlsx
9 of 42 students need help:
| Group | Students | Plan |
|---|---|---|
| Below 40% in maths | 5 | Two extra periods a week |
| Falling in science | 3 | Pair with a strong student |
| Below 40% in two subjects | 1 | Talk to parents this week |
Roll numbers for each group are listed below.
Figures here are made up to show the shape of the answer. Yours come from your own file and words.