Grade Spreadsheet 2

The grade spreadsheet was a good way for me to brush up on my excel formulas. I had forgotten how to weight grades using excel. When I first started teaching, a lot of the older teachers would come in my room and want to know how I was averaging grades so quickly. I had set up my own excel spreadsheets to use at that time. Since then, the software program Grade Quick has become really popular. The school where I am currently working is requiring all of its teachers to use Grade Quick for this second semester.

Grade Sheet

Spreadsheet 1

I probably should not admit that I had an excel course at FSU a few years ago. I only had problems when I was trying to sort. At first I copied each terms averages into the semester 1 sheet and averaged the three columns. However, I could not sort the information the way I needed it to be sorted. I kept getting value errors. I looked at the discussion board and realized that I could just put all the terms averages and divide by three in one column and then sort. That worked for this assignment.

Grades

Google Forms

I liked this assignment. I think this assignment could be really useful. I wish I would have known how to be able to create forms like this many years ago. What a great way to obtain information very quickly. The person who created this was a genius.


Google Forms

Zoomerang / Blog Poll

This assignment was fun. I think that I could really use the survey to gain feedback from students about specific assignments, classroom design, or their classroom experience. The blog poll is just for fun. I am not sure how I will be able to use this in the classroom and put into real practice. I am still contemplating the poll.

Zoomerang Survey

Graphing Tools

I am hoping that I have completed this assignment correctly. I found this assignment to be a little tricky with publishing the document and trying to find the right information on the website we were given with the testing data. Then I found writing an executive summary to be a little vague considering the data was not broken down into exact problem areas and there was not an item analysis.

Published Document
Graphing Tool
WV NAEP Scores

Wordle

I enjoyed the Wordle assignment. I am going to use this Wordle on my bulletin board at school.

Wordle

Batchgeo Map

This project was interesting. I had no idea that you could create a map. This assignment was fun.

Batchgeo map