Today we worked more in Excel, using more complex formulas and the IF function, once again using student test scores for our data. I learned that a function is different than a formula because it is built in; you don't have to type it in. First we used the average function to average each assignment, which didn't take very long because we used the fill handle to copy the function so we only had to do it once. We used the same technique with the Min and Max functions, and then composed a formula to find the range between the two. Then we composed a formula to calculate the final grade. We added the assignments together, divided by 2, and multiplied that by .25 (assignments were 25% of their final grade). We did the same thing for the project, and for the tests, except for the tests we used .5 because they were 50% of the final grade, and then we added them all together. We typed a long formula into the formula bar and got the weighted average. Then we used the help menu to learn how to use the IF function to assign the weighted average a letter grade. This was great beacuse this time we copied and pasted the formula from the help menue and just changed a few things. Finally, we formatted our spreadsheet, added a background color, and uploaded it to Google Docs. Whew!
I think today's activity promotes Teaching Standard 1D. because in it we learned to use digital tools and resources to explore the real-world issue of student testing trends. Also, I know it is important for teachers to know how to analyze and understand test scores.
No comments:
Post a Comment