Today in class we did our third spreadsheet assignment. We used basic formulas such as addition and division then also used more complex formulas such as COUNTIF and AVERAGEIF. In this activity we used accumulated data to determine what gender had the greatest improvement and also what type of student(traditional or non-traditional) had the greastest improvement. We came to the commclusion based on the Pretest and Posttest scores that females and traditional students had the highest Pretest scores, while males and non-traditional students had the highest post-test scores. This being known, males and non-traditional students had the greatest difference between the Pretest and the Post Test. We also learned how to insert a chart by using data on our spreadsheet and place them on a seperate page. The charts we made included gender distribution, class distribution, average gender gain, and average class distribution gain.
Certain formulas and functions are not available in google docs so in order to use the document next class, I have mailed the file to myself.
No comments:
Post a Comment