Spreadsheet 3: AR Spreadsheet

You can all now view my AR Spreadsheet in Google Docs! It has taken me quite a while to complete this assignment! I was very confused and finally asked a collaborative teacher I work with to give me some assistance with creating functions. I did complete the assignment in MS Excel, and I feel that it is better late than never! I did learn so many new things from completing this assignment. I learned how to create and use new functions that I had not previously known about or ever used, that I can remember!

After uploading the assignment to Google Docs, I noticed that the "averageif" formula does not transfer to Google, as well as, the charts and graphs I spent so much time completing! So, I uploaded my document and I am going to show some clips of my results in this blog post so that everyone can see that I did work hard to complete/use the functions and charts/graphs!

Research Questions:
1. I did not see where gender (male/female) scores impacted initial grade averages. The averages were very close for the pretest and post test scores. They were only a few points off from one another.

2. Classification (traditional/non traditional) impacted initial grade averages just a bit. The traditional pretest scores were somewhat higher than the non traditional (14 points), but the post test scores were only 3 points apart for each of the classifications.

3. The action research intervention did improve student learning. The post test scores were significantly higher than the pretest scores, for the gender and classification groups. The scores jumped 50 points or more for each of the groups.

I created six charts/graphs to go along with the AR Spreadsheet. Each of the charts relates to a specific criteria. The first 2 charts/graphs I completed were for the differences between gender distribution and class distribution. I had a hard time completing the charts/graphs until the first one was finished. Once I figured out how to get all the information I needed into the chart/graph, it was a breeze! The second 2 charts/graphs I created were the differences between the male/female pretest and post test scores, as well as, the differences between the traditional/non traditional pretest and post test scores. I tried to use a variety of charts/graphs to complete the assignment. The last 2 charts I completed were the gain/loss or difference between the pretest and post test scores for every student.

I did find that you can copy and past formulas and/or functions and you can use the little black handle at the bottom of the cell once you have completed a formula/function to carry it on to the next cell, eliminating you having to put the formula/function 213 times!

The Spreadsheet 3: AR Spreadsheet assignment closely relates to the ISTE.NETS Standard 3: Model Digital-Age Work and Learning because as educator's we are modeling and using current and emerging digital tools to better our technological abilities. By learning how to efficiently work through MS Excel, I will have the knowledge to pass these skills on to my students and co-workers.