I have worked with spreadsheets before. I took computers and advanced computers in high school, as well as a computer class in college. We covered spreadsheets, so I actually knew what I was doing a little better this week. Spreadsheets are a bit easier to grasp, I think. Of course, I have been having trouble embedding the file, as per usual, but I will get it! And, I did! Finally!
https://docs.google.com/spreadsheet/pub?key=0AuOvS6f3YzWidGZIczdVZV9sRTVObXpUVDRwMFVxbXc&output=html
Most of the kids saw quite a bit of growth between their PreTest scores and their PostTest scores. One student's score did go down, though. However, all the other students saw an increase of ten percent or higher. Many of the formative assessment percentages stayed quite similar for all three assessments. A lot of the students had nearly the same score for all their assessments, but there were a couple who did have one assessment with a noticeably better score. The assessment percentages probably did not change much because there were not many points possible on any of the assessments. As a result of these scores, I would continue to try to get the students to improve. I would possibly review some of the material the students were finding tricky, especially for the student who did not improve between their PreTest and PostTest.
Great start on this project, and glad it went a little easier for you than last week. A few items to tweak:
ReplyDelete- double check the logic of the calculated values in the % of Growth column. Estimate a few, then revisit the formulas. For example, Victor went from 3.8% up to 73%, so his % of growth is probably greater than 69%.
- on chart3, what do the blue, red, and orange represent (legend). I think they are Formative #1, 2 and 3.
- on chart2, is the data representing a TREND over time, or COMPARISON? Based on your decision, which type of chart might one want to switch to?
- on chart1, what is the legend (red and blue) represent?
- on chart1, what are the 13 pairs of bars? Should the students be there so we can actually discuss them later in analyzing?
So, just some minor tweaking should do the trick. And check out the EMBED video clip I sent in an earlier email. So far it seems to be working for everyone.
Let me know if you need assistance.