21 Things for Students

  It's Your Party!

Imagine you are having a celebration and you are inviting guests to your party. There are 5 people in your family and all 5 will be attending.  You have invited Grandpa and Grandma, but Grandpa is out of town fishing that day so only Grandma can attend.  Aunt Lucy has 5 people in her family and 3 will be attending.  Uncle Gus and Aunt Francis have 4 in their family however only 2 can attend that day.  You also want to invite all 9 of your cousins and you have let them know they can bring a friend, so 13 people will be attending.  In addition, you can't forget all 12 members on your Ping Pong team plus the 2 coaches so an additional 10 people will be attending.

You could use a spreadsheet to keep track of the data for you and automatically calculate numbers.  We are going to start with a simple spreadsheet that uses a basic SUM formula. Before beginning you will need to know and understand the words cell, row and column.  See image below for guidance:

Terminology

Creating the Basic Spreadsheet

Spreadsheet Image Sample

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  

Resources
    Spreadsheet Help From Google   
     Using Google Spreadsheets from About.com

Check this Quest off your Tracking Document