The first thing I did for this activity was to open Excel and install the analysis tool pack. I opened the shared Google Doc and saved it in Excel. I changed the variables to numeric codes by using the find/replace options. I sorted by ascending/descending order and then by levels. The average for the blog posts was calculated. Apparently I am below average, which is disappointing because I have done the required amount of posts.
This activity was easy enough. I don't have much experience with Excel but all I had to do was play around with the program to find what I needed.
The standard addressed would be #5 Engage in Professional Growth and Leadership. Using Excel to manipulate data would allow teachers to make effective use of digital tools and resources.
No comments:
Post a Comment