Master class

• INTRODUCTION

  • Introduction

• М1. DATA SCIENCE AND THE POSSIBILITIES FOR APPLICATION AT SCHOOL LEVEL

  • Introduction to the module
  • Introduction to Data Science
  • The importance of Data Science education
  • Technical skills for a data scientist
  • Examples of applications at school level
  • Summary – conclusions, key takeaways, definitions, etc
  • Additional resources
  • Quiz
    6 questions10 min

• М2. BASIC THEORY AND TERMINOLOGY IN STATISTICS, PROBABILITY AND DATA MAPPING

  • Introduction to the module
  • Basics of Statistics
  • Descriptive Statistics
  • Inferential Statistics
  • Basics of Probability
  • Summary – conclusions, key takeaways, definitions, etc.
  • Quiz
    10 questions10 min

• М3. TECHNIQUES FOR WORKING WITH CONVENTIONAL DATA AT THE SCHOOL LEVEL

  • Introduction to the module
  • Tables
  • Graphs and diagrams
  • Other techniques (for example schemes, cartodiagrams, imagines…)
  • Summary – conclusions, key takeaways, definitions, etc.
  • Additional resources
  • Quiz
    9 questions10 min

• М4. DATA ENTRY, DATA CLEANING, DATA VISUALISATION, DATA ANALYSIS

  • Introduction to the module
  • Data entry
  • Data cleaning
  • Data visualisation
  • Data analysis
  • Summary – conclusions, key takeaways, definitions, etc.
  • Additional resources
  • Quiz
    16 questions10 min

• М5. UNDERSTANDING DESCRIPTIVE STATISTICS WITH EXCEL

  • Understanding Descriptive Statistics with Excel
  • Discovering Central Values with Excel
  • Creating Charts in Excel for Data Visualisation
  • Using Excel for School Projects/STEM Projects
  • Summary – conclusions, key takeaways, definitions, etc.
  • Quiz
    18 questions10 min

• М6. PROGRAMMING LANGUAGES AND SOFTWARE USED TO CREATE TASKS FOR STUDENTS

  • Introduction to the module
  • What Is a Programming Language?
  • Platforms and Software for creation of learning tasks
  • Business Intelligence (BI) systems
  • Platforms and Software for Creating Various Educational Tasks
  • Summary – conclusions, key takeaways, definitions, etc.
  • Additional resources
  • Quiz
    10 questions10 min

• М7. HOW TO INTERPRET AND PRESENT RESULTS

  • Introduction to the module
  • How can you interpret research results more effectively?
  • Tips to Effectively Present Data
  • Summary – conclusions, key takeaways, definitions, etc.
  • Additional resources
  • Quiz
    8 questions10 min

• М8. EXAMPLES OF GOOD PRACTICE

  • Data science and the possibilities for application at school level
  • Examples of good practices on how to integrate Data Science at ISCED level 2
  • Summary – conclusions, key takeaways, definitions, etc.
  • Additional resources
  • Quiz
    3 questions10 min

• М9. DESIGNING A LESSON - OBJECTIVES, TASKS AND ACTIVITIES WITH STUDENTS, EXPECTED LEARNING OUTCOMES

  • Structure and design of the lesson
  • Quiz
    4 questions10 min

• М10. LIVING ORGANISMS

  • Introduction to the module
  • Let’s Eat Well and Healthy – 5. grade
  • Let’s Make a Vegetable Garden – 5. grade
  • Can Bacteria Be Our Friends? – 5. grade
  • My Heart – 6. grade
  • Get Strong – 6. grade
  • Nature Wonders – 6. grade
  • Bees – the Rescuers of the World – 7. grade
  • Superfoods – 7. grade
  • Do Mushrooms Bite? – 7. grade

• М11. ATOM TO SPACE

  • Introduction to the module
  • How to Navigate in Nature – 5. grade
  • The Sun and the Weather Forecast – 5. grade
  • The Real Celebrities – The Stars – 5. grade
  • Atmospheric Pressure – 6. grade
  • Get a Piece of Jewellery – 6. grade
  • Dangerous Attraction – 6. grade
  • Make a Wish – 7. grade
  • Gravitational Forces – 7. grade
  • Let There Be Light! – 7. grade

• М12. SUBSTANCES & CHEMICAL REACTIONS

  • Introduction to the module
  • Oxygen – 5. grade
  • Poison for One – Food for Another – 5. grade
  • The Salt Waters – 5. grade
  • Does the Earth Smoke? – 6. grade
  • Iron Man – 6. grade
  • Food for the Cars – 6. grade
  • Chemistry at Home – 7. grade
  • Chemistry Inside of Us – 7. grade
  • Chemical Nostradamus – 7. grade

• М13. ENVIRONMENTAL PROTECTION

  • Introduction to the module
  • Separate Collection and Recycling of Waste – 5. grade
  • Are You Thirsty? – 5. grade
  • Plant a Tree – Make Yourself Air – 5. grade
  • Take Your Bike – 6. grade
  • Be Happy, Be Healthy – 6. grade
  • Human Impact on Climate and Biodiversity – 6. grade
  • Breathe Clean – 7. grade
  • Let’s Save the Ocean – 7. grade
  • Green Energy – 7. grade

• QUESTIONNAIRE

  • Questionnaire for the trainees

• FINAL TEST

  • Final Test

Master class

Back to Course

Creating Charts in Excel for Data Visualisation

You must log in to view this content

Prev Discovering Central Values with Excel

Next Using Excel for School Projects/STEM Projects