Login to start course
This course includes
9 Activities
Individual work

Data Analysis and Visualisation

This course introduces students to data analysis using pivot tables and pivot charts. Through hands-on computer work, students learn how to organize, group, filter, and visually present data, as well as how to draw conclusions from it. During the course, students will notice the differences between regular and pivot tables and charts, and gradually build confidence in data analysis through collaborative work.

Creative Commons License
This course was published by Petlja Foundation under the Creative Commons Attribution 4.0 International License (CC BY 4.0).

Тим фондације Петља
Login to start course

Course content

Data Analysis and Visualisation
Introduction
Pivot Tables
Task and Knowledge Check
Attachments and Links

You will learn

  • What a pivot table is and how it differs from a regular table
  • How to create and set up a pivot table
  • How to use rows, columns, values, and filters
  • How to create a pivot chart and visualize results
  • How to interpret data and formulate conclusions
  • How to collaboratively analyze data and present results

Needed for the course

  • A computer with Microsoft Excel installed or access to Google Sheets

Course content

Introduction 3 Activities
Pivot Tables 3 Activities
Task and Knowledge Check 2 Activities
Attachments and Links 1 Activity