Hello,
I came up with a way of gauging student progress, and I’m trying to write a formula for that purpose, so I can test the method in larger scale to see if it’s any good at all. Here is what I do: I take each student’s week 1 score and subtract it from the week 5 score (e.g. 88-76), and so there is an improvement of 12 points over 5 weeks, or 2.4 points per week, for this example (table 1).
Now, the question I want to ask is, at any given week, how many weeks does it take for the student’s score to intersect the predicted score, which is the score of that week plus 2.4 x #weeks of passed? I calculated manually as shown in table 2, so for example, for week 1, it takes 2 weeks (table 3) for the score to intersect week3 score (i.e. 81 is greater than 76+2.4+2.4). And at week2, it takes 1 week for the score (81) to intersect the predicted score (80.4).
I need a formula that would calculate this without the need to make the extra table 2 of predictions.
Thanks for any input!!!
Table1:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Week1[/TD]
[TD]
[TD]<strike></strike>
[TD]<strike></strike>
[TD]<strike></strike>
[TD]<strike></strike>
[TD]<strike></strike>
[TD]<strike></strike>
[TD]<strike></strike>
[TD]<strike></strike>
[/TR]
[TR]
[TD]Student1[/TD]
[TD]76[/TD]
[TD]78[/TD]
[TD]81[/TD]
[TD]79[/TD]
[TD]88[/TD]
[TD]86[/TD]
[TD]90[/TD]
[TD]83[/TD]
[TD]91[/TD]
[TD]95[/TD]
[/TR]
[TR]
[TD]etc.[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
<strike></strike>Table2 (predicted scores):
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Week1[/TD]
[TD]
[TD]<strike></strike>
[TD]<strike></strike>
[TD]<strike></strike>
[TD]<strike></strike>
[TD]<strike></strike>
[TD]<strike></strike>
[TD]<strike></strike>
[TD]<strike></strike>
[/TR]
[TR]
[TD]W1pred.[/TD]
[TD][/TD]
[TD]78.4[/TD]
[TD]80.8[/TD]
[TD]83.2[/TD]
[TD]85.6[/TD]
[TD]88[/TD]
[TD]90.4[/TD]
[TD]92.8[/TD]
[TD]95.2[/TD]
[TD]97.6[/TD]
[/TR]
[TR]
[TD]
[TD]<strike></strike>[/TD]
[TD][/TD]
[TD]80.4[/TD]
[TD]82.8[/TD]
[TD]85.2[/TD]
[TD]87.6[/TD]
[TD]90[/TD]
[TD]92.4[/TD]
[TD]94.8[/TD]
[TD]97.2[/TD]
[/TR]
[TR]
[TD]
[TD]<strike></strike>[/TD]
[TD][/TD]
[TD][/TD]
[TD]83.4[/TD]
[TD]85.8[/TD]
[TD]88.2[/TD]
[TD]90.6[/TD]
[TD]93[/TD]
[TD]95.4[/TD]
[TD]97.8[/TD]
[/TR]
[TR]
[TD]
[TD]<strike></strike>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]81.4[/TD]
[TD]83.8[/TD]
[TD]86.2[/TD]
[TD]88.6[/TD]
[TD]91[/TD]
[TD]93.4[/TD]
[/TR]
[TR]
[TD]
[TD]<strike></strike>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]90.4[/TD]
[TD]92.8[/TD]
[TD]95.2[/TD]
[TD]97.6[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]
[TD]<strike></strike>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]88.4[/TD]
[TD]90.8[/TD]
[TD]93.2[/TD]
[TD]95.6[/TD]
[/TR]
[TR]
[TD]
[TD]<strike></strike>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]92.4[/TD]
[TD]94.8[/TD]
[TD]97.2[/TD]
[/TR]
[TR]
[TD]
[TD]<strike></strike>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]85.4[/TD]
[TD]87.8[/TD]
[/TR]
[TR]
[TD]
[TD]<strike></strike>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]93.4[/TD]
[/TR]
</tbody>[/TABLE]
Table3 (# of weeks taken for the actual score to intersect the predicted score):
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Week1[/TD]
[TD]
[TD]<strike></strike>
[TD]<strike></strike>
[TD]<strike></strike>
[TD]<strike></strike>
[TD]<strike></strike>
[TD]<strike></strike>
[TD]<strike></strike>
[TD]<strike></strike>
[/TR]
[TR]
[TD]Student1[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]never[/TD]
[TD]1[/TD]
[TD]never[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]n/a[/TD]
[/TR]
</tbody>[/TABLE]
I came up with a way of gauging student progress, and I’m trying to write a formula for that purpose, so I can test the method in larger scale to see if it’s any good at all. Here is what I do: I take each student’s week 1 score and subtract it from the week 5 score (e.g. 88-76), and so there is an improvement of 12 points over 5 weeks, or 2.4 points per week, for this example (table 1).
Now, the question I want to ask is, at any given week, how many weeks does it take for the student’s score to intersect the predicted score, which is the score of that week plus 2.4 x #weeks of passed? I calculated manually as shown in table 2, so for example, for week 1, it takes 2 weeks (table 3) for the score to intersect week3 score (i.e. 81 is greater than 76+2.4+2.4). And at week2, it takes 1 week for the score (81) to intersect the predicted score (80.4).
I need a formula that would calculate this without the need to make the extra table 2 of predictions.
Thanks for any input!!!
Table1:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Week1[/TD]
[TD]
Week2
[/TD][TD]<strike></strike>
Week3
[/TD][TD]<strike></strike>
Week4
[/TD][TD]<strike></strike>
Week5
[/TD][TD]<strike></strike>
Week6
[/TD][TD]<strike></strike>
Week7
[/TD][TD]<strike></strike>
Week8
[/TD][TD]<strike></strike>
Week9
[/TD][TD]<strike></strike>
Week10
<strike></strike>[/TD][/TR]
[TR]
[TD]Student1[/TD]
[TD]76[/TD]
[TD]78[/TD]
[TD]81[/TD]
[TD]79[/TD]
[TD]88[/TD]
[TD]86[/TD]
[TD]90[/TD]
[TD]83[/TD]
[TD]91[/TD]
[TD]95[/TD]
[/TR]
[TR]
[TD]etc.[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
<strike></strike>Table2 (predicted scores):
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Week1[/TD]
[TD]
Week2
[/TD][TD]<strike></strike>
Week3
[/TD][TD]<strike></strike>
Week4
[/TD][TD]<strike></strike>
Week5
[/TD][TD]<strike></strike>
Week6
[/TD][TD]<strike></strike>
Week7
[/TD][TD]<strike></strike>
Week8
[/TD][TD]<strike></strike>
Week9
[/TD][TD]<strike></strike>
Week10
<strike></strike>[/TD][/TR]
[TR]
[TD]W1pred.[/TD]
[TD][/TD]
[TD]78.4[/TD]
[TD]80.8[/TD]
[TD]83.2[/TD]
[TD]85.6[/TD]
[TD]88[/TD]
[TD]90.4[/TD]
[TD]92.8[/TD]
[TD]95.2[/TD]
[TD]97.6[/TD]
[/TR]
[TR]
[TD]
W2pred.
<strike></strike>[/TD][TD]<strike></strike>[/TD]
[TD][/TD]
[TD]80.4[/TD]
[TD]82.8[/TD]
[TD]85.2[/TD]
[TD]87.6[/TD]
[TD]90[/TD]
[TD]92.4[/TD]
[TD]94.8[/TD]
[TD]97.2[/TD]
[/TR]
[TR]
[TD]
W3pred.
<strike></strike>[/TD][TD]<strike></strike>[/TD]
[TD][/TD]
[TD][/TD]
[TD]83.4[/TD]
[TD]85.8[/TD]
[TD]88.2[/TD]
[TD]90.6[/TD]
[TD]93[/TD]
[TD]95.4[/TD]
[TD]97.8[/TD]
[/TR]
[TR]
[TD]
W4pred.
<strike></strike>[/TD][TD]<strike></strike>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]81.4[/TD]
[TD]83.8[/TD]
[TD]86.2[/TD]
[TD]88.6[/TD]
[TD]91[/TD]
[TD]93.4[/TD]
[/TR]
[TR]
[TD]
W5pred.
<strike></strike>[/TD][TD]<strike></strike>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]90.4[/TD]
[TD]92.8[/TD]
[TD]95.2[/TD]
[TD]97.6[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]
W6pred.
<strike></strike>[/TD][TD]<strike></strike>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]88.4[/TD]
[TD]90.8[/TD]
[TD]93.2[/TD]
[TD]95.6[/TD]
[/TR]
[TR]
[TD]
W7pred.
<strike></strike>[/TD][TD]<strike></strike>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]92.4[/TD]
[TD]94.8[/TD]
[TD]97.2[/TD]
[/TR]
[TR]
[TD]
W8pred.
<strike></strike>[/TD][TD]<strike></strike>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]85.4[/TD]
[TD]87.8[/TD]
[/TR]
[TR]
[TD]
W9pred.
<strike></strike>[/TD][TD]<strike></strike>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]93.4[/TD]
[/TR]
</tbody>[/TABLE]
Table3 (# of weeks taken for the actual score to intersect the predicted score):
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Week1[/TD]
[TD]
Week2
[/TD][TD]<strike></strike>
Week3
[/TD][TD]<strike></strike>
Week4
[/TD][TD]<strike></strike>
Week5
[/TD][TD]<strike></strike>
Week6
[/TD][TD]<strike></strike>
Week7
[/TD][TD]<strike></strike>
Week8
[/TD][TD]<strike></strike>
Week9
[/TD][TD]<strike></strike>
Week10
<strike></strike>[/TD][/TR]
[TR]
[TD]Student1[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]never[/TD]
[TD]1[/TD]
[TD]never[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]n/a[/TD]
[/TR]
</tbody>[/TABLE]
Last edited: