| Ebacc (Grade 5 or above in En & Ma, 6a or above in Hi/Gg, Sc and one MFL) | English Target End of GCSE Year 9 Targets | English Estimate GCSE Year 9 Data 3 | English Target Comments Year 9 Data 3 | Maths Target End of GCSE Year 9 Targets | Maths Estimate GCSE Year 9 Data 3 | Maths Target Comments Year 9 Data 3 | Science Target Year 9 Targets | Science Estimate Year 9 Data 3 | Science Target Comments Year 9 Data 3 | History Target Year 9 Targets | History Assessment Year 9 Data 3 | History Target Comments Year 9 Data 3 | Geography Target Year 9 Targets | Geography Assessment Year 9 Data 3 | Geography Target Comments Year 9 Data 3 | RE Target EOY9 Year 9 Targets | RE Estimate GCSE Year 9 Data 3 | RE Target Comments Year 9 Data 3 | French Target Year 9 Targets | French Assessment Year 9 Data 3 | French Target Comments Year 9 Data 3 | Arabic Target Year 9 Targets | Arabic Assessment Year 9 Data 3 | Arabic Target Comments Year 9 Data 3 |
| 7 | 7 | = | 7 | 7 | = | 7c | 7c | = | 7c | 7c | = | 7c | 7c | = | B | B | = | 7a | 7a | = |
<tbody>
</tbody>
Hi
I'm hoping someone can help me with this. I need to calculate the Ebacc for our students. Ebacc = level 5 or above in English and Maths, level 6a or above in Science, History, Geography and one MFL.
I need to calculate this per student so the calculation will be per row rather than various columns. Can someone please provide me with some suggestions as to how I can do this.
I've tried countifs but it doesn't seem to work.
Thanks for your help.
Fazila
Last edited:
