- Using your Wingsmail go into Google Drive.
- Click the Create button and pick Form.
- Your form should have questions for the following items.
- First name
- Month of birth
- Date of birth
- Year of birth
- Make sure you're using the right question type for each item in the form.
- For example, a question for name should not be multiple choice. A text answer would be appropriate.
- For answers that use numbers a text box would also work, but you could use a multiple choice style question as well.
- Mail this form to enough friends so that you get at least 25 responses.
- Make sure that your responses end up in a spreadsheet.
-
Using one or more functions, create formulas in cells at the bottom of your data. Those formulas should answer the following questions.
-
What is the average age of the people in your birthday chart?
-
In another cell, what is the oldest age of the people in your birthday chart?
-
In another cell, what is the youngest age?
-
Using a function, create a formula in a cell below your list of birthday months.
- What is the most frequently occurring month in your chart?
-
Using a function, create a formula in a cell below your list of birthday dates.
- What is the most frequently occurring date in your chart?
-
Create charts showing the range of birthdates, months, and years.
| Created a form to collect data | /1 | | At least 25 names and birthdates | /1 | | Using a function, finds the average age | /2 | | Using a function, finds the oldest age | /2 | | Using a function, finds the youngest age | /2 | | Using a function, finds the most frequently date of birth (just the date) | /2 | | Using a function, finds the most frequent month of birth | /2 | | A chart showing how many people have each birthdate | /2 | | A chart showing how many people are born in a month | /2 | | A chart showing how many people were born in each year | /2 | | | | | | /18 |
|
 Updating... ĉ James Dykstra, Nov 28, 2014, 7:10 AM
|
