Veronika Dropčová
veronika.dropcova(at)gmail.com

   nika.blog.matfyz.sk

Project (spreadsheets)

Your previous homework assignment was to think out 5 questions. Now, the time for these questions has already come and let’s find some answers!

 

1. Create a google form, send it to as many people as you can and collect at least 25 answers to all of your questions. I highly recommed to add a question about a person’s gender (since it can be interesting for data evaluating) and a question about his/her age. (4pts)

 

2. Share this google form also with me, as well as the spreadsheet with results.

 

3. Find averages, maximums and minimums for each of your questions. (4.5pts)

 

4. Find some way how to use IF function or COUNTIF or COUNTIFS or AVERAGEIF or any other more complex function (maybe you will learn to use something new that we didn’t work with at school) at least in four different cases (e. g. you can think out 4 different questions as we did during last lessons – e.g. How many men are taller than your teacher?). (6pts)

 

5. Create at least two charts (with some relevant data shown). (3pts)

 

6. Create the another sheet in your spreadsheet where the description of your results (short conlusions from your small research) will be added. For example: I found out that average number of rooms in houses of my friends is 4, so it means that almost all of them probably have their own room (they do not have to share it with their siblings). (2.5pts)

 

Deadlines

  • group 2A2: November 6, 2016, 11:59pm
  • group 2B1: November 6, 2016, 11:59pm
  • group 2B3: November 15, 2016, 11:59pm
  • group 2B2: November 15, 2016, 11:59pm
  • group 2A3: November 15, 2016, 11:59pm
  • group 2A1: November 27, 2016, 11:59pm