SPORCLE quiz results line graph
For the next few days we'll be working on creating a line graph with a spreadsheet. Line graphs are great for showing how data changes over a period of time.
In our case, we'll be tracking our quiz scores on some Sporcle quizzes over the course of five class periods. At the end of the week we'll take our information and transfer it over to a line graph.
Here's what we need to do.
1. Open up a spreadsheet in Excel.
2. You'll have to adjust the lengths of the cells, but type this information in the following cells:
1A "Quiz Title"
1B "Day 1 Score"
1C "Day 2 Score"
1D "Day 3 Score"
1E "Day 4 Score"
1F "Day 5 Score"
2A "US States"
3A "Minute Math"
4A "Most Populous Countries"
5A "Famous Faces"
6A "Cartoons"
3. Take the following quizzes. When you are done, type how many answers you got correct in your spreadsheet underneath "Day One Score." I'd open these in a new tab or new window.
RIGHT CLICK HERE FOR THE US STATES QUIZ
RIGHT CLICK HERE FOR THE MINUTE MATH QUIZ
RIGHT CLICK HERE FOR THE MOST POPULOUS COUNTRIES QUIZ
RIGHT CLICK HERE FOR THE FAMOUS FACES QUIZ
RIGHT CLICK HERE FOR THE CARTOONS QUIZ
4. Save your spreadsheet (with your scores) in the Thaw Space.
5. If you have any extra time, you can play any other appropriate quizzes on Sporcle.
In our case, we'll be tracking our quiz scores on some Sporcle quizzes over the course of five class periods. At the end of the week we'll take our information and transfer it over to a line graph.
Here's what we need to do.
1. Open up a spreadsheet in Excel.
2. You'll have to adjust the lengths of the cells, but type this information in the following cells:
1A "Quiz Title"
1B "Day 1 Score"
1C "Day 2 Score"
1D "Day 3 Score"
1E "Day 4 Score"
1F "Day 5 Score"
2A "US States"
3A "Minute Math"
4A "Most Populous Countries"
5A "Famous Faces"
6A "Cartoons"
3. Take the following quizzes. When you are done, type how many answers you got correct in your spreadsheet underneath "Day One Score." I'd open these in a new tab or new window.
RIGHT CLICK HERE FOR THE US STATES QUIZ
RIGHT CLICK HERE FOR THE MINUTE MATH QUIZ
RIGHT CLICK HERE FOR THE MOST POPULOUS COUNTRIES QUIZ
RIGHT CLICK HERE FOR THE FAMOUS FACES QUIZ
RIGHT CLICK HERE FOR THE CARTOONS QUIZ
4. Save your spreadsheet (with your scores) in the Thaw Space.
5. If you have any extra time, you can play any other appropriate quizzes on Sporcle.