Data Analysis and Computational Thinking
  • Canvas: enrolled students
  • 2026–2027 syllabus
  1. Data Analysis and Computational Thinking
  • Data Analysis and Computational Thinking
  • Start here: enrolled students
    • DACT 2026–2027 syllabus
    • How to learn with this course
  • Computational thinking and algorithm design
    • Computational thinking
    • Designing algorithms
    • Tracing, Testing, and Improving Algorithms
  • Excel for data analysis
    • Excel basics and data tables
    • Formulas, functions, and lookups
    • Import and clean data with Power Query
    • PivotTables, charts, and dashboards
    • Practice: warehousing sales analysis
    • Practice: NYC taxi ride analysis
  • Python foundations
  • Functions and decisions
  • Sequences and loops
  • Records and files
  • Building Reliable Programs
  • Resource Compendium
    • Excel shortcuts
    • Excel reference
    • Additional Excel questions
    • Additional Excel practice
    • Glossary

Data Analysis and Computational Thinking

Computational thinking with algorithms, Python, Excel, data analysis, testing, and reliable programs

A beginner course in computational thinking, Python programming, Excel data analysis, testing, and reliable problem solving.
Author

Breno Alves Beirigo

Beginner course | 3 EC | 7 modules

Data Analysis and Computational Thinking

Learn to turn an unclear problem into a computational solution that another person can inspect, test, and improve.

I’m enrolled: start here 2026–2027 syllabus

Beginner level No programming prerequisite

Python The reference programming language

Excel Tabular analysis, checking, and communication

7 modules One cumulative learning path

What this course covers

DACT combines computational thinking, Excel data analysis, and Python programming. You will define problems, design algorithms, work with tabular data, write and test programs, and explain the assumptions and limits of your results.

The course moves from problem formulation and algorithm design through Excel and Python to records, files, simulation, testing, and reliable programs. The underlying ideas transfer to other domains, languages, and computational tools.

Modules

Module 1

Computational thinking and algorithm design

Formulate computational problems and design, trace, test, and improve algorithms before programming.

Module 2

Excel for data analysis

Structure, calculate with, refresh, summarize, and communicate changing tabular data.

Module 3

Python foundations

Translate algorithms into Python programs and explain their values, calculations, and changing state.

Module 4

Functions and decisions

Build reusable behaviour and explicit decision rules.

Module 5

Sequences and loops

Build a reproducible minimum viable simulation and inspect its results in Excel.

Module 6

Records and files

Represent, validate, process, and export persistent records.

Module 7

Building Reliable Programs

Validate, test, and improve a complete simulation-based solution.

Where to go next

University of Twente students can find Canvas, the timetable, and the materials released for the current week in the enrolled-student guide.

For course outcomes, assessment, workload, and policies, consult the 2026–2027 syllabus. Independent learners can follow the course learning guide.

Start here: enrolled students