Below is the link to my Google spreadsheet and an itemized list of answers to the questions. The questions were answered based on the data in the spreadsheet.
http://spreadsheets.google.com/pub?key=pLpsg_-9TutQ93Qv8GHQHOw
Q: What was the overall class average?
A: 85.9333333333334%
Q: Which student had the highest average?
A: Helen Ochallaghan (91.8333333333333%)
Q: Which student had the lowest average?
A: Freta Washington (73.1666666666667%)
Q: Sort the students by average descending with the highest average on top.
A: DONE
Q: Based upon the scores which assignment was the most difficult?
A: The assignment given on 9/19/2008 was probably the most difficult because it had the lowest average score.
Q: Create a visual aide (Chart) to show the averages and student names. Question: How do you graph labels and data in columns that are noncontiguous? As you probably know the ctrl key does this in Excel. Google requires a work around.
A: DONE
Q: Upload and publish your completed document into a sheet in your online spreadsheet. Rename the sheet Grades 1.
A: DONE
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment