using sheets to help with data. sheets is a spreadsheet program that can interface with forms, docs,...
TRANSCRIPT
![Page 1: Using Sheets To help with data. Sheets is a spreadsheet program that can interface with forms, docs, or presentations. A spreadsheet program has cells](https://reader035.vdocuments.us/reader035/viewer/2022062805/5697c02b1a28abf838cd8aab/html5/thumbnails/1.jpg)
Using SheetsUsing SheetsUsing SheetsUsing Sheets
To help with dataTo help with data
![Page 2: Using Sheets To help with data. Sheets is a spreadsheet program that can interface with forms, docs, or presentations. A spreadsheet program has cells](https://reader035.vdocuments.us/reader035/viewer/2022062805/5697c02b1a28abf838cd8aab/html5/thumbnails/2.jpg)
• Sheets is a spreadsheet program that can interface with forms, docs, or presentations.
• A spreadsheet program has cells (little blocks) that we can put information and then relate the cells to each other.
![Page 3: Using Sheets To help with data. Sheets is a spreadsheet program that can interface with forms, docs, or presentations. A spreadsheet program has cells](https://reader035.vdocuments.us/reader035/viewer/2022062805/5697c02b1a28abf838cd8aab/html5/thumbnails/3.jpg)
• We can add text, numbers, or calculations
• To open Sheets, click on the “Drive” in the menu bar of Gmail.
![Page 4: Using Sheets To help with data. Sheets is a spreadsheet program that can interface with forms, docs, or presentations. A spreadsheet program has cells](https://reader035.vdocuments.us/reader035/viewer/2022062805/5697c02b1a28abf838cd8aab/html5/thumbnails/4.jpg)
• Click on “Create” then “Spreadsheet”
![Page 5: Using Sheets To help with data. Sheets is a spreadsheet program that can interface with forms, docs, or presentations. A spreadsheet program has cells](https://reader035.vdocuments.us/reader035/viewer/2022062805/5697c02b1a28abf838cd8aab/html5/thumbnails/5.jpg)
• Notice across the top are letters, and along the left side are numbers
• Each cell has its own address such as C14
![Page 6: Using Sheets To help with data. Sheets is a spreadsheet program that can interface with forms, docs, or presentations. A spreadsheet program has cells](https://reader035.vdocuments.us/reader035/viewer/2022062805/5697c02b1a28abf838cd8aab/html5/thumbnails/6.jpg)
• Let’s start by typing “Distribution of Hair Color by Class” in B4
• Create a table as shown
![Page 7: Using Sheets To help with data. Sheets is a spreadsheet program that can interface with forms, docs, or presentations. A spreadsheet program has cells](https://reader035.vdocuments.us/reader035/viewer/2022062805/5697c02b1a28abf838cd8aab/html5/thumbnails/7.jpg)
• Click and hold the mouse on cell B5 and drag it to E9. There should be a block surrounding B5-E9
![Page 8: Using Sheets To help with data. Sheets is a spreadsheet program that can interface with forms, docs, or presentations. A spreadsheet program has cells](https://reader035.vdocuments.us/reader035/viewer/2022062805/5697c02b1a28abf838cd8aab/html5/thumbnails/8.jpg)
• It may be important to know how many students there were total. – Click on E10 and type “=SUM(“ – You can now drag a box around all
the cells you want to add up. Drag from C6 to E9
![Page 9: Using Sheets To help with data. Sheets is a spreadsheet program that can interface with forms, docs, or presentations. A spreadsheet program has cells](https://reader035.vdocuments.us/reader035/viewer/2022062805/5697c02b1a28abf838cd8aab/html5/thumbnails/9.jpg)
– Type “)” to close the parentheses– Press the Enter key
• Total students should show as 82
![Page 10: Using Sheets To help with data. Sheets is a spreadsheet program that can interface with forms, docs, or presentations. A spreadsheet program has cells](https://reader035.vdocuments.us/reader035/viewer/2022062805/5697c02b1a28abf838cd8aab/html5/thumbnails/10.jpg)
• Let’s average each type of hair color– Click on F6 and type “=AVERAGE(“
and drag a box from C6 to E6– Type “)” to close the parentheses– Press the Enter key
![Page 11: Using Sheets To help with data. Sheets is a spreadsheet program that can interface with forms, docs, or presentations. A spreadsheet program has cells](https://reader035.vdocuments.us/reader035/viewer/2022062805/5697c02b1a28abf838cd8aab/html5/thumbnails/11.jpg)
Pretty Cool huh?
![Page 12: Using Sheets To help with data. Sheets is a spreadsheet program that can interface with forms, docs, or presentations. A spreadsheet program has cells](https://reader035.vdocuments.us/reader035/viewer/2022062805/5697c02b1a28abf838cd8aab/html5/thumbnails/12.jpg)
• Instead of typing that for each hair color, let’s copy the formula. The program will automatically adjust for the other rows.– Click in F6 – Click “Edit” from the menu at the top– Click “Copy”– Drag a box around the empty cells F7 to F9– Click “Edit” then “Paste”
![Page 13: Using Sheets To help with data. Sheets is a spreadsheet program that can interface with forms, docs, or presentations. A spreadsheet program has cells](https://reader035.vdocuments.us/reader035/viewer/2022062805/5697c02b1a28abf838cd8aab/html5/thumbnails/13.jpg)
• Make a column that totals each of the hair types from G6 to G9
• This is discrete data that requires what kind of chart?– That’s right, a bar chart– In Sheets, they call it a column chart
![Page 14: Using Sheets To help with data. Sheets is a spreadsheet program that can interface with forms, docs, or presentations. A spreadsheet program has cells](https://reader035.vdocuments.us/reader035/viewer/2022062805/5697c02b1a28abf838cd8aab/html5/thumbnails/14.jpg)
• Highlight F5-F9 and click on the “Charts” icon in the upper right
![Page 15: Using Sheets To help with data. Sheets is a spreadsheet program that can interface with forms, docs, or presentations. A spreadsheet program has cells](https://reader035.vdocuments.us/reader035/viewer/2022062805/5697c02b1a28abf838cd8aab/html5/thumbnails/15.jpg)
• Choose “Column Chart”• Click “Insert”
![Page 16: Using Sheets To help with data. Sheets is a spreadsheet program that can interface with forms, docs, or presentations. A spreadsheet program has cells](https://reader035.vdocuments.us/reader035/viewer/2022062805/5697c02b1a28abf838cd8aab/html5/thumbnails/16.jpg)
• You now have a chart• Click on “Chart Title” to edit• Click on other parts to edit labels
![Page 17: Using Sheets To help with data. Sheets is a spreadsheet program that can interface with forms, docs, or presentations. A spreadsheet program has cells](https://reader035.vdocuments.us/reader035/viewer/2022062805/5697c02b1a28abf838cd8aab/html5/thumbnails/17.jpg)
How Awesome is that?!