Copying instructions to a blank Google Doc 1:18
Go to Google Classroom to get your data!
Copying and pasting Data 3:30
Moving your data to the correct location 3:15
Heading 3:43
Merging and Centering 4:01
Moving the rest of the data 4:51
Creating Subheading and Merging and Centering 5:16
Spell Checking document 6:01
Resetting the days of the week with the fill handle 7:22
Formula Column B 8:40
Formula Column C 9:40
Formula Column D 10:10
Adding the rows Function key and Fill Handle 10:53
Adding the columns function and fill handle 11:30
Creating the chart 12:10
Inserting the Cougar Paw inside Google Sheets 13:40
Wrap up all the rest!
PO 3: Produce simple charts and graphs from data in a spreadsheet.
Directions: copy and paste this data onto a blank DOCS document. Then delete each step as you complete it!
1. In a Chrome browser Go to Lynch Site > Tech Assignments > Sheets4
2. Open a blank workbook (page) in Sheets.
3. Go to Google Classroom and open Google Sheets 4 Data - Copy and paste data onto the sheets document.
4. Save as: 6Sheets4 your name
5. Starting with the heading make the following changes: Your name.. and Cougar Cakes
a. Merge and Center from A1 to E1
b. Change the Font to another stylish (not blocky) Font.
c. Change the Font Color to something other than White, Black, or some light color.
6. Highlight the rest of the data under A1 and move it down to A3.
7. Retype the subheading to say: 2 Week Profit. Remove the old incorrect subheading from A3 Merge and Center the same as the heading.
8. Redo the days of the week to display Monday as the beginning of the week and Sunday ending the week.
9. Make sure you include 2 weeks.
10. Check spelling if you did not redo the entire set of data.
11. Starting in cell B3-D3 your column headings should be Cougar PawCakes, Cougar CupCakes, Cougar FaceCake.
12. Cougar PawCakes data column should start with $10.00 it should then raise in increments of $10.00 per day. In cell B5 type the following formula: = B4+10 press either Return or Tab then click back on cell B5 and use the fill handle to complete the rest of your data.
13. Cougar CupCakes increments should start with $20.00 dollars and rise in increments of $20.00 per day. In cell C5 type the following formula: =C4+20 then either press Enter or Tab and use the fill handle to complete the rest of your data.
14. Cougar FaceCake increments should start with $30.00 dollars and rise in increments of $30.00 per day. In cell D5 type the following formula: =D4+30 then either press Enter or Tab and use the fill handle to complete the rest of your data.
15. Totals column and Total row. Using Functions key add the column and row totals.
16. Highlight the data (without the totals), create a chart that you have not already used on a previous assignment.
17. Insert 1 clip art of a cougar paw from inside Google Sheets!
18. Ensure proper spelling, grammar, and other changes. Show me > MFT