Introduction to Google Sheets

We're going to begin using Google Spreadsheets for the next several weeks. You may already be familiar with using spreadsheets or you may have never used a spreadsheet program before. I'm going to assume that you've never used a spreadsheet before so we'll start off slow. Watch this beginners tutorial on Google Sheets.

Now that you've been introduced to Google Sheets. Try making one yourself. First, create a folder on your Google Drive and call it Spreadsheets. You'll place your work in here for review so please share it with me. Now you won't have to share each individual file. I'll just check your folder to give you your grade so make sure your work with Google Sheets is in this folder! Remember, if I can't see your work, I can't give you credit.

Now, make a class roster using these steps.

1. Create your column headers on row 1. Your headers should be Last Name, First Name, Class, Sex, Height

2. Enter the names of the members of your class in the following rows. If you need to ask their heights just ask.

3. Try using the sort function to sort A-Z for each of the columns. After you sort the selection by sex, proceed to step 4.

 4. Make the following calculations using the function section of the menu.

• calculate the total height of the class in inches
• calculate the average height of the entire class
• calculate the average height of the females 
• calculate the average height of the males 

Use this as your guide.
https://docs.google.com/spreadsheets/d/1tR5ZCUxPYvSHFbi7n8BUSTfytfoGx3SCxGLApUkepiE/pubhtml