Name
Statistics and spreadsheet
Topic
Maths
Learning time
2 hours
Designed time
3 hours and 10 minutes
Size of class
28
Description
Aims
The aim is to make students aware that a massive database is not understandable and needs to be sorted. They will see how.
Outcomes
Comprehension, Knowledge, Analysis, Application
Editor
smaillard
Edit
A real-life big dataset
60 minutes)
  • Discuss
    10
    4
    1
    A big dataset concerning our students' water consumption habits is projected (see attachement). Open question : what can you say about it? Projector HD allows to see more precisely and zoom if necessary in the large amount of data for students situated at the back of the classtoom. Brightness and sharpness are so good that no need to use the curtains and switch off the light
  • Collaborate
    20
    4
    0
    Each group decides and writes a post on Padlet (that is projected in live) explaining why such database is not convenient to exploit the information.
  • Investigate
    30
    2
    1
    Via GoogleDrive, students download the dataset and decide ONE column to be sorted and also decide the way they want to show results. They start learning by themselves how to use a spreadsheet (see attachement)
  • Produce
    0
Notes:
Resources linked: 0
How to use a spreadsheet ?
40 minutes)
  • Investigate
    40
    1
    0
    At home, students investigate on the Web how to use a spreadsheet (video tutorials or other ways). A bank of resources is given if needed
Notes:
Resources linked: 0
Producing a analyzing
60 minutes)
  • Collaborate
    30
    2
    0
    Using the online spreadsheet : Students sort one column of the dataset, calculate percentage for each given answer and create a graphic (they decide which one is the best)
  • Produce
    30
    0
    A shared slideshow tool (Google) is projected. Each group pastes in it the graphic they have done. They also analyze the result and write a sentence about it. Projectot HD displays a large image allowing to present them all
Notes:
Resources linked: 0
Use of the product (slideshow) in another subject
30 minutes)
  • Discuss
    30
    5
    0
    Students observe the graphics created in math lesson and discuss ideas for a better water consumption using "Tricider"Web tool to decide the most relevant proposals for the next step
  • Produce
    0
    Students produce an online leaflet of better water consumption tips
Notes:
Resources linked: 0

Learning Experience

One or more graphs might not display correctly, because one or more learning types do not have duration set.
Social learning graph will not display correctly, because no class size is set.
Social learning graph will not display correctly, because one or more learning types do not have group size set.