Student Growth Plans
With the requirements of the student growth plans and pre/post test calculations, Excel is a HUGE time saver! The first thing you will want to do is enter your data into an Excel spreadsheet like the picture below:
The next step is to calculate the percentage of change between the pre and post test. This is calculated by (Post-Pre)/Pre. Let's add that formula to cell D2 for Spider-Man. It will look like this:
*You want to make sure you reference the cells instead of typing in the numbers!! It will save you time later.
*You want to make sure you reference the cells instead of typing in the numbers!! It will save you time later.
You will get a small decimal answer, to change this to percent, click the % symbol up near the top of your screen by the dollar sign. That will convert your number from a decimal to a percent.
To copy this formula for the rest of your students, simply hover your mouse in the lower right hand corner of the cell (D2 in this case) and you will get a small cross hair. Click and drag down, that will copy your formula to the rest of your students.
The FINAL RESULT!! :)
To copy this formula for the rest of your students, simply hover your mouse in the lower right hand corner of the cell (D2 in this case) and you will get a small cross hair. Click and drag down, that will copy your formula to the rest of your students.
The FINAL RESULT!! :)