Iain McBride
New Member
- Joined
- Aug 17, 2018
- Messages
- 38
A colleague has asked to see if there a way of creating a formula to calculate the progression that a group of young people have made through a survey folllowing a short course.
The table below shows 9 young people and where they gauged their level of understanding before and after the session (1 being not at all and 4 completely understand)
<tbody>
</tbody>
Is there a formula that will calculate the difference that each student has made (ie post-pre = progression)?
Thanks
Iain
The table below shows 9 young people and where they gauged their level of understanding before and after the session (1 being not at all and 4 completely understand)
1 | 2 | 3 | 4 | ||||||
pre | post | pre | post | pre | post | pre | post | progression | |
1 | 1 | 1 | |||||||
2 | 1 | 1 | |||||||
3 | 1 | 1 | |||||||
4 | 1 | 1 | |||||||
5 | 1 | 1 | |||||||
6 | 1 | 1 | |||||||
7 | 1 | 1 | |||||||
8 | 1 | 1 | |||||||
9 | 1 | 1 |
<tbody>
</tbody>
Is there a formula that will calculate the difference that each student has made (ie post-pre = progression)?
Thanks
Iain