Education - developing computational thinking skills

According to a paper published by Professor Jeannette Wing in 2006, Computational thinking (CT) should be the fourth fundamental skill, along with Reading, wRiting, and aRithmetic (3R). From an education perspective, computational thinking encourages educators of all subjects and at all levels to engage in and support students in developing the ability to solve complex problems in a systematic way. Core to computational thinking is the ability to break down complex problems, identify patterns, focus on relevant detail, and develop systematic solutions. Spreadsheet skills are closely aligned to this.

Relevant competencies

All the listed competencies can be related to students’ interests to varying degrees. Students should learn how to analyse and convert real-world data tables to spreadsheet tables, using both traditional and AI-supported approaches. They should be able to understand and explain problems connected to spreadsheet formulas. Solutions should feature spreadsheet functionality that demonstrates clarity of thought. In general, solutions should be programming-oriented where the fundamental principles of computer science and data analytics can be introduced and later transferred to more advanced environments, applying concepts of end-user data management. 

The competency framework

The framework is colour coded to illustrate the relevance of each competency.

• Core competencies form the essential Excel knowledge required for this job role.
• Beneficial competencies are additional skills individuals may choose to develop to strengthen their capability.
• Less relevant competencies remain useful Excel skills but are not as directly applicable to the role and therefore may be given lower priority.

Below is an interactive summary of the core competencies, as well as those beneficial to develop further capabilities, for this job role. Click through each section, in the left-hand column, to explore the framework.