Thing+13+Quest+1


 * __ Thing 13 Quest 1 __**

1.Use this Excel spinner template spreadsheet.

2.Work with a partner or by yourself. One of you should open the spreadsheet and **//save it with your name and spinner in the title//** ready to use. The //person operating the spinner should create and open a document (word processing or presentation program) to input screenshots and answers to the questions posed as you go through this Spinner Project.// == 3. The "spinner" member of the group will go to this //(new)// interactive spinner to simulate the colors at the Superb Slushie Company. The other will be the "spreadsheet operator" and record the data into the spreadsheet. ==

[[image:image2.jpg]]
==Notice the numbers in each bar indicate how many times the spinner landed on that color out of the 20 times it spun. ==

[[image:image3.jpg]]
==6. The "spreadsheet operator" should record the results in the Problem 1 section of the spreadsheet, as called off by the "spinner" partner, example shown below. When this is done, click the CLEAR button on the grid. ==

[[image:image4.jpg]]
==7. Spin the spinner another time and record the results. "CLEAR" the grid and do these steps one last time so that you have 3 sets of results. ==

==8. Your next step is to have the spreadsheet add up the totals for you by entering a formula. You can do this by using the SUM function. == ==In the spreadsheet, put your cursor in the Total row under the Purple column (cell B7 in the example shown). Enter the formula to add up the numbers in cells in that column (B4 + B5 + B6). == ==To do this you need to use the equals (=) symbol and the letters SUM "=SUM" followed by an open paren, (, the names of the cells to be added together with a colon between each, and end with closed ). ==

10. //__Problem 2__//:
== Since all the color parts of the spinner are equal sizes, do you think that if you spin the spinner even more times, that the results should be closer to an equal number of hits for each color? Discuss this with your partner. Now change the number of spins to 40 and repeat this same process as before, filling in the information into the Problem 2 section. Take some screenshots as you work and paste them into a word processing or presentation program to use later on. Be sure to make some notes about what you were doing with each screenshot to reference later on in your final Spinner Project report. ==

=Thing 13 Quest : Part 2=

Global collaboration:
Now one person from each team should click this survey link and enter your results into the global survey. Click this link to see the results entered from all the others across the globe.

//__Take a screenshot of the global results and save it in your Spinner report document__.// Jot down the following observations for your report:

// ** 1.The number of total results collected in the global survey. ** //

// 3.As more students enter their results into the global survey, what do you expect to happen to the totals for each color? //
11. Before you document your predictions to the following scenario based on your data in your Spinner Report document: you go on to Problem 3,

If you walked into the Slushie store with 5 friends and you each spun the wheel for a slushie, what color or colors would you expect each of you to receive?

Use the data you collected to predict and then compare with two other groups. Defend how your data supports your answer. Do all of you agree on the answers? Why or why not?

12. The owner was very upset when the next delivery of their slushie mixes arrived. The truck didn't deliver equal amounts of the different color varieties! The delivery company gave them the following number of bottles of each color flavoring: 1 purple, 2 yellow, 3 green, 4 red, and 5 orange. How could they make sure they would use up the colors they had in stock without running out? A student worker in the store came up with a unique solution. The colored slices on the spinner were changed to represent the stock. To see how this idea worked out, you will need to change the spinner properties.

13. Click the button on the spinner to "Change spinner."



== 14. Change the numbers next to the different colors so that the chance of getting a discount on the flavors that are overstocked will be larger. Use the small arrow next to each color choice to change the numbers to the following: ==

[[image:image7.jpg]]
==15. Click on the Apply button so that the spinner color slices are changed. Take a screenshot of your new spinner for your report. ==

16. Now before you repeat your research, your challenge is to make a prediction. Looking at your new spinner, which color will have the highest probability of hits, and which one the lowest out of 20 spins? Write your prediction into your document. Now keep track and spin the spinner 20 spins. Enter your results into your spreadsheet. How did you do? If you spin it more times, will it be closer to your prediction? Do this two more times, remembering to record your data and to CLEAR the results when done. Total your 3 sets of results like you did earlier. Did your prediction come true? Compare your results with other teams to see if their predictions were accurate. Jot these results into your Spinner Report.

17. Answer the following questions by adding them to the report document. When you changed the spinner why did this change the results? Was this a good solution to the problem? Why or why not? How does your data collected support your answer? Check with two other groups in the class to see if they agree or disagree with your findings?