Google CPS Login
Description
- You will be completing a spreadsheet project in this unit using the data we collect on the number of student birthdays in each month.
- You will be using the data to create first a bar graph and then a pie chart and a line graph.
- We are using Google Sheets to do this project.
- We are doing this so you know how to represent data with a computer. It will help you with school projects (like the Science Fair) and in your career.
- You know you understand it when you can check off everything in the list under Grading Criteria on this page and you can make tables and graphs on your own as needed in the future.
Essential Question
How can we use the computer to enhance our data collection and presentation?Understandings
Vocabulary
cell, chart, table, Auto Sum, spreadsheet
Placement of tools in Google
Placement of tools in Excel
History of Spreadsheets
Teacher Example
Link to Example
To receive an A+ make sure you have completed all of these points. Each item is worth 1 point, for a maximum total of 6 points. Grades and comments will be done in Schoology.
A+ = 6 pts., A = 5 pts., B = 4 pts., C = 3 pts., D = 2 pts or less
- Table with Data and Sum
- Properly applied fill colors and other formatting
- Pie Chart with correct data series
- Bar graph with correct data
- Line Graph with correct data
- Colors have been changed on charts to demonstrate knowledge of that feature
Step by Step Instructions
We are going to collect data on the number of student birthdays per month and create a table and three graphs, a bar graph, a pie chart, and line graph.
Happy Birthday!
Step by Step Instructions
1. Open Google spreadsheet
2. Click the mouse in cell A1 and type your title.
3.Select A1 and B1 and click on the merge cells icon.
4. Click on the title cell and change the font size to 16. Choose a new font and color if you wish.
5. Click the mouse in cell A3 and type “Month”, click in cell B3 and type “Number.” Change the cell fill, font, or size as desired.
6. Click the mouse in cell A4 and type in “January.” Select the cell and click on the fill icon (bucket) and select a color.
7. Enter in the name of the different Months into cells, A5 - A15. (February, March, April, May, June, July, August, September, October, November, and December)
8. Change the fill for each cell to match the first color.
9. Continue until all the months are entered. Change the font size or color as desired.
10. After you have you entered all your labels, you will need to enter the data recorded for each color. We will fill in data as a class.
11. Change the color or font of the number to what you would like. Change the color name font if you choose.
12. In cell A16 type ‘Total’. Press the AutoSum tool for a total count. Highlight the cells from B4 to B15 and press enter.
13. Once the data is entered, click on cell A4 and drag it to the cell B15. You are making a box around your data.
14. Click on “Insert” and then click on “Chart”. Select the Pie Chart.
15. Click on the Customize tab at the top. Give the chart a title.
16. Scroll down to Slices and select the a different color for each slice if desired.
17. Select your data again and click on insert -> chart. Select the “Switch rows / columns” option, select the “Use column A as headers” option, and the vertical bar graph.
18. Click the Customize tab and name the chart. Scroll down and in the Columns section select different colors for each month if desired.
19. Select your data again and click on insert -> chart. This time select a line graph. Arrange all or your graphs t=so that they don't overlap.
19. Select your data again and click on insert -> chart. This time select a line graph. Arrange all or your graphs t=so that they don't overlap.
20. Make sure to rename your spreadsheet.
21. Share your finished spreadsheet to edsmalling. Make sure you uncheck the "Notify via email" and that you have your room number in the title.
No comments:
Post a Comment