Spreadsheets


 * ==Spreadsheets==

 Part 1: Creating a Spreadsheet Open up a new spreadsheet on your Google Drive account


 * Step 1 - Open a new Google Spreadsheet and name it: Party Planner. **
 * Step 2 - Title three columns - Name, # Invited, # Attending (make sure all of the titles are capitalized). This is called a Header Row. **
 * Step 3 - List all of the families, neighbors, and groups invited under NAME. You will need to adjust the column width to fit the name of the people invited. **
 * Step 4 - List the number of people invited under # INVITED **
 * Step 5 - List the number of people attending under # ATTENDING **

 Part 2: Formatting the spreadsheet Step 1 - Open the existing Party Planner spreadsheet. Step 2 - Align the text for column B and C so it is in the center. Step 3 - Highlight column A and color it light blue, highlight column B and color it light green, and highlight column C and make it light pink. Step 4 - Put a border around each cell. Step 5 - Have a row labeled TOTALS in cell A9 and make it bold. Step 6 - Make the header row bold.



 Part 3: Insert and Merge Step 1 - Highlight row 1, go to INSERT on the menu bar and select ROW ABOVE Step 2 - In Cell A1 put your name and the type of party you are planning. Step 3 - Highlight Cells A1, B1, and C1. Step 4 - Click on the Merge Cells Button. Step 5 - Make the font for this row size 14, change the font color to blue, and align center.

 Part 4: Formulas

Step 1 - Put an addition formula in the cell B10 adding the # of people invited. The formula should look like one of these: > =B3+B4+B5+B6+B7+B8 or = SUM(B3:B8) > Step 2 - Put an addition formula in the cell C10 adding the # of people attending. The process is the same as above. You may also experiment with using the FUNCTIONS button on the toolbar.

Step 3 - When you click off of the formula it should automatically add the numbers. To see the formula again go to VIEW in the menu and select ALL FORMULAS. This shows you all of the formulas on the sheet.

Step 4 - Take a screen shot of your spreadsheet with ALL FORMULAS showing. - put this onto your wiki Step 5 - To not see all of the formulas go back to VIEW in the menu and select ALL FORMULAS and it will return to numbers in the columns.



 Part 5: Charts

=
Step 2 - Select the chart button on the tool bar or INSERT then CHART from the menu. Choose the kind of chart that you feel would display the information the best. Also USE ROW 2 AS HEADERS should be selected. ======

=
Step 5 - Drag the chart so you can see it under the spreadsheet OR move it to a different sheet. Hint: Move your mouse around in the top right corner until you see a triangle drop down menu, then select MOVE TO NEW SHEET. ======  || Links to different parts of this assignment: ~Creating a Spreadsheet ~Formatting the Spreadsheet ~Insert and Merge ~Formulas ~Charts ~What needs to be on your wiki for spreadsheets || 8th Grade Page 21 Things page What you need on your pages || What needs to be on your wiki for this part of things five
 * 

On your Thing 5 page insert an new horizontal line and underneath put Spreadsheets.
Like this:

Spreadsheets

Embed your spreadsheet
 * 1) click on File and choose Publish to the Web
 * 2) Change Get a link to the published data - where it says web page
 * change this to html and copy that code
 * 1) On your wiki insert a widget
 * 2) Choose spreadsheet and Choose Google Spreadsheet
 * 3) Paste the code into the box and click on save

media type="custom" key="21346050" ||  ||   ||