820045 :Inleiding Data-Analyse CIW
(Introduction to Data-Analysis CIS)

General info

Instruction language Dutch
Type of Instruction 7 one hour lectures and 7 two hour computer practicals (Lecture schedule)
Type of exams computer exam (Examination schedule)
Course load:3 ECTS credits
Registration:Enrolment via Blackboard before start lectures
Blackboard InfoLink to Blackboard (When you see 'Guest are not allowed in this course', please login at Blackboard itself)


drs. J.M. Dake (coordinator)

dr. J.A.A. Engelen


At the end of this course, students will be able to:
  • organize the workspace in Excel (e.g. set colomn width and row height, freeze rows/columns, set cell properties);
  • open a file with research data in a spreadsheet and split the data correctly into multiple columns;
  • handle different data types (e.g. number, text, dates) in a spreadsheet;
  • make a legend for a data file;
  • check the quality of research data and remove and/or correct faulty data;
  • edit research data (e.g. construct or join research variables and reverse scales);
  • summarize research data with elementary descriptive statistics (e.g. average, standard deviation, frequencies, cross tables);
  • apply the necessary formulas in Excel (e.g. Sum, Count, If, Averageifs, Vlookup);
  • visualize research data in various ways.


During your studies (and probably in your career later on) you will conduct research. Research yields all kinds of data, for example, the enormous amount of tweets with meta-information about the tweets in a study on sentiment analysis, or the many transcriptions of recordings in a study on the communication between physicians and patients, just to name a few. In both cases, you will have to process the data to gain insight into their meaning and to make them suited for statistical testing. The amount of data is typically large, making manual analysis infeasible. This course teaches you the skills and tools to perform these tasks.


Testing is done by weekly assignments and a practical computer exam at the end of the course. Deadlines are binding: handing in assignments on time is a pre-condition for passing the course.
We will be using Excel 2013, English edition. This will also be used for the computer exam.

Additions/modifications in the course will be communicated through Blackboard. Students will have to check Blackboard regularly.


Compulsory Reading

  1. Literature will be announced via Blackboard during the course.

Recommended Reading

  1. The literature for the course will be published on Blackboard.

Compulsory for

  • Business Communication and Digital Media ( 2015, 2016, 2017 )
  • Human Aspects of Information Technology ( 2015, 2016 )
  • Bachelor CIW: New Media Design ( 2017 )
  • Text and Communication ( 2015, 2016, 2017 )
  • Bachelor Communicatie- en informatiewetenschappen: Leraar Nederlands ( 2016, 2017 )