Computational Reasoning

Lesson 1: Introduction to Computational Reasoning

• Understand the computational problem-solving process, and able to clearly define objectives to solve problems.
• Understand the obstacles that make it difficult to develop good computational solutions

Lesson 2: What’s Going On and Why? Understanding the Situation and Identifying Problems Using Data Analysis

• Effectively use the various tools of Microsoft Excel to analyse data.
• Identify patterns or breaks in patterns to better understand and describe what is going on in the dataset, and to identify possible causes to problems.
• Distinguish between direct and proxy measures, with the awareness of the problems inherent in using proxy measures.

Lesson 3: How to Effectively Reason with Data

• Identify assumptions underlying proxy measures and evaluate the strength of these assumptions.
• Formulate clear and unambiguous hypotheses based on data and evaluate the strengths of these hypotheses.

Lesson 4: Anyone Can Model: The Fundamentals of Modelling

• Read and comprehend conditionals and nested conditionals in order to organise and sort data on a large scale
• Create accurate classification models based on the processes of pattern recognition and abstraction.
• Appreciate the difficulties in developing abstract models, and identify shortcomings of such models.

Lesson 5: Social Network Analysis: What’s Going on in the Neighbourhood?

• Develop a firm understanding of the concepts of loops and nested loops
• Develop a nuanced understanding of the notion of “importance” in a social network through the concepts of degree centrality and betweenness centrality.

Lesson 6: Greedy Methods: How to Solve Problems in a Fast and Systematic Manner

• Articulate Greedy Rules when attempting to solve problems via the optimisation-approach.
• Evaluate different Greedy Rules to prescribe effective solutions

Lesson 7: A Fun Introduction to Coding with VBA

• Basic knowledge of VBA to automatically navigate around a spreadsheet and manipulate cells and data.
• Apply conditionals in VBA to process rows of information and generate output.
• Competently debug errors in VBA.

Lesson 8: Let’s Up Our VBA Game!

• Apply loops in VBA to process rows of information and generate output.
• Formulate precise conditionals through the exercise of pattern recognition to solve more complex problems.