Data Analysis and Computational Thinking
  • Canvas: enrolled students
  • 2026–2027 syllabus
  1. Start here: enrolled students
  2. Home
  • Start here: enrolled students
    • Home
    • 2026–2027 syllabus
    • How to learn with this course
  • 1. Computational thinking and algorithm design
    • 1.1 Computational thinking
    • 1.2 Designing algorithms
    • 1.3 Tracing, testing, and improving algorithms
  • 2. Data analysis with Excel
    • 2.1 Welcome to Excel
    • 2.2 Why Excel conquered the world
    • 2.3 Set up Excel
    • 2.4 Step-by-step tutorial
    • 2.5 Importing and refreshing data
    • 2.6 Further Excel techniques
    • 2.7 Excel multiple-choice questions
    • 2.8 Excel reference
  • 3. Programming foundations
    • 3.1 From algorithms to programs
    • 3.2 Why Python?
    • 3.3 Setting up Python
    • 3.4 Running Python code
    • 3.5 Variables, values, and data types
    • 3.6 Operators and expressions
    • 3.7 Defining and using functions
  • 4. Decisions and debugging
    • 4.1 Making decisions with conditionals
    • 4.2 Debugging and error handling
    • 4.3 Comments and readable code
  • 5. Lists and loops
    • 5.1 Lists
    • 5.2 Loops
    • 5.3 Randomness
  • 6. Records and files
    • 6.1 Tuples
    • 6.2 Sets
    • 6.3 Dictionaries
    • 6.4 Manipulating files
  • 7. Building reliable programs
    • 7.1 Data structures and performance
    • 7.2 Modules and packages
    • 7.3 Virtual environments
    • 7.4 Testing code
    • 7.5 Version control systems

  • Practice
    • Question atlas
    • Practical exercises
    • Exercise papers
  • Glossary
  1. Start here: enrolled students
  2. Home

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

Data analysis with Excel

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

Module 3

Programming foundations

Translate algorithms into Python programs, build small reusable functions, and explain their values, calculations, and changing state.

Module 4

Decisions and debugging

Express rules as conditional logic, and locate and correct defects in a program.

Module 5

Lists and loops

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

Module 6

Records and files

Use collections and read, write, and manage files.

Module 7

Building reliable programs

Choose data structures, organize a program, recreate its environment, test its behavior, and manage its changes.

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
2026–2027 syllabus