Rock/Paper/Scissor Excel Project
Follow these directions to create a graph using Excel.
1. Open up Microsoft Excel.
2. Put cursor in Cell A1, click and type in “Probability Graph” and your first and last name. Press “enter” when finished.
3. Put the cursor in cell E1 and type the following: “Prediction of what outcomes will be.”
4. Begin in cell A5 and moving down column A, enter the names for each of the events being graphed. So, you will type Rock in cell A5, Paper in cell A6, and Scissor in cell A7.
5. Go to cell B4 and type the heading “Totals” and press enter.
6. Click in cell C4 and type “Trial 1” and press enter.
7. Click back to cell C4. Put your mouse on top of the tiny square in the lower right hand corner. The mouse will change from a fat cross to a skinny cross.
8. While the mouse is skinny, click down and hold the clicker down. Drag the mouse to the right, staying in row 4. As the mouse is dragged, bubble labels will appear reading “Trial 2”, “Trial 3”, and so on. Continue to drag until “Trial 50” can be seen.
9. When the mouse is dragged to the proper cell, let up on the clicker. All 50 cells should be auto-filled with the correct headings.
10. Click in cell B5.
11. Click the “autosum” icon on the tool bar.
12. Click in cell C5, and holding the clicker down, drag the mouse out to the cell below “Trial 50”. The 5th row of cells will have blinking neon lights around it indicating it is selected.
13. Press enter. Cell B5 should display a “0”.
14. Click into cell B5. Click “edit” and “copy”.
15. Click into cell B6, click “edit” and “paste”, then do the same with cell B7. This will copy the formula into the other two cells correctly.
16. When finished, highlight the formula cells and the label cells by clicking in cell A5, holding the clicker down, and dragging the mouse to cell B7. All will be highlighted. Let up on your mouse clicker.
17. Go to the button for charts and click it (this is under the insert section). A dialog box will pop up.
18. Select a pie type chart and pick the chart sub-type that you want.
19. To see a preview, click a sub-type and click the bar which says “press and hold to view sample”. The chart will be empty, of course, since there is no data yet.
20. Click “next” and get a preview of the data.
21. Click “next” again.
22. Click the tab labeled “legend” and click the desired placement of the legend. Pick corner.
23. Click on the tab labeled “titles” and type in the title of the chart again “Probability Graph”. After a split second, the title will appear on the preview.
24. Click the tab labeled “data labels”. Click on “show label and percent”.
25. Click “finish”.
26. Click on the empty pie chart and move the graph down under the rows with the data.
27. Click in a cell that is below row 7 (or the lowest row of your data) and to the right of the graph. Then click “window” and “freeze panes”. Now, the scroll bar at the bottom will scroll the right half of the screen without moving the left half. This way the pie chart will always be visible.
28. Begin playing rock/paper/scissor with a partner. In the column for trial 1, put a number “1” in the correct row for what you chose.
29. As soon as enter is pressed, the pie chart and sums will be updated. If not, you did not follow directions and will have to fix your problems.
30. Continue until all 50 trials are complete.
Customize the pie chart, backgrounds, and text.
1. Click once on one of the pie sections. All sections will have a dot in them.
2. Click in one of the sections a second time so that only it is selected. Then keeping the mouse over the section, right click. A menu will pop up. Or, you can click “format” on the menu bar.
3. Click the option “format data point” using a normal left click.
4. At this point, a different color may be selected for the section.
5. Click the bar with the words “fill effects”.
6. Experiment with the following choices:
*One color. Choose color and mix with light and dark. Try different shading styles.
*Try the same thing with two colors. Again, try different shading styles.
*Click “preset” and look through all of the multi-colored sets. See how they differ with different shading styles.
*Click the tab entitled “texture”.
*Click the tab entitled “pattern” and look at the different patterns of two colors that can be made.
*Click the tab entitled “picture”. Any graphic can be inserted from the bar “select picture” and used in the pie sections.
7. When a color/pattern has been selected for the different sections of the pie chart, carefully click one time background called the plot area. Using the steps above, customize the plot area. When right clicking, “format plot area” will be on the pop up menu. This should be selected.
8. Finally, do the same for “chart area” by carefully clicking one time on the area close to the edge of the chart graphic.
9. All text can be double clicked to get a dialog box of text choices: font, color, size, etc.