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

Using Excel for School Projects/STEM Projects

You must log in to view this content

Prev Creating Charts in Excel for Data Visualisation

Next Summary – conclusions, key takeaways, definitions, etc.