Computational Thinking Tools, Python, Spreadsheets and Problem-Solving Steps for SS 1

Class: SS 1
Term: Second Term
Week: 2
Age: 15 years
Duration: 60 minutes
Subject: Digital Technologies
Curriculum Theme: Emerging Technologies
Focal competence: Solving problems through structured logic and programming
Key competencies/values: Communication
Skills:

• Using computational thinking to develop algorithms for problem solving

Previous Lesson: Computational Thinking, Importance and Components
Topic: Computational Thinking (Ct) For Automation: Computational Thinking Tools
Subject Matter: Computational thinking tools, programming tools, (python), analytical tools, (spreadsheets), Steps to solve a problem using computational thinking

Specific Objectives

By the end of the lesson, pupils/students should be able to:

Cognitive Domain

• State the functions of computational thinking tools.
• Describe the steps to solve a problem using computational thinking.

Psychomotor Domain

• Draw basic IPO charts for simple problems.
• Create simple flowcharts to represent problem solutions.
• Write pseudocode for straightforward tasks.

Affective Domain

• Appreciate the importance of structured problem-solving in digital technologies.

Reference Materials

The following resources were used in planning this lesson:

• 2025 New Revised Senior Secondary Education Curriculum (SSEC)
• Relevant State Unified Scheme of Work
• The HeadTeacher Scheme of work For The New Revised Senior Secondary Education Curriculum (SSEC)

Instructional Materials

The teacher will teach this lesson with the aid of:

• Card sheets
• Flowchart templates
• Computers/tablets
• Internet Access
• Whiteboard and markers
• Projector (optional)

Rationale for the Lesson

This lesson is important because it introduces students to the fundamental concepts of computational thinking, which are essential for solving complex problems in the digital age. Understanding these tools and steps helps students develop logical reasoning and prepares them for further studies in programming and data analysis. It builds a foundation for creating automated solutions and understanding how technology works.

Prerequisite/Previous Knowledge

Students should have a basic understanding of what a computer is and how it processes information. They should also be familiar with simple problem-solving in everyday life.

Lesson Content/Board Summary

Computational Thinking (Ct) For Automation: Computational Thinking Tools

Computational Thinking Tools

Computational thinking tools are instruments or methods that help in applying computational thinking principles to solve problems. These tools can be conceptual, programming-based, or analytical, each serving a specific purpose in breaking down, analyzing, and solving problems effectively.

Conceptual Tools

Conceptual tools are abstract ways of representing problems and their solutions without necessarily using a computer language. They help in planning and visualizing the logic before actual implementation.

1. IPO Model (Input-Process-Output): This model is a fundamental concept in computational thinking that describes how a system or program transforms data.
   1. Input: The data or information that is fed into the system.
   2. Process: The operations or steps performed on the input data to transform it.
   3. Output: The result or transformed data produced by the system after processing.

   Example: For calculating the sum of two numbers:

   1. Input: Number A, Number B
   2. Process: Add Number A and Number B
   3. Output: Sum
2. Flowchart: A graphical representation of a process or algorithm, using symbols to show the sequence of operations, decisions, and data flow. Flowcharts are excellent for visualizing the logic and flow of a solution.
   1. Start/End: Oval shape, indicates the beginning or end of the process.
   2. Process: Rectangle shape, represents an action or operation.
   3. Input/Output: Parallelogram shape, represents data input or output.
   4. Decision: Diamond shape, represents a point where a decision is made (e.g., Yes/No, True/False).
   5. Arrow: Line with an arrowhead, shows the direction of flow.
3. Pseudocode: A plain language description of the steps in an algorithm or program. It is not actual programming code but uses a structured format that resembles code, making it easy to understand for both humans and to translate into real programming languages.

Programming Tools (Python)

Programming tools are software applications that help in writing, testing, and debugging computer programs. Python is a popular high-level programming language used for various applications, including automation, web development, data analysis, and artificial intelligence.

1. Python: A versatile and easy-to-learn programming language. In computational thinking, Python is used to implement algorithms designed using conceptual tools. It allows for direct translation of logical steps into executable code, automating tasks and solving problems efficiently.

Analytical Tools (Spreadsheets)

Analytical tools are software applications used to organize, analyze, and visualize data, helping to identify patterns, trends, and insights. Spreadsheets are a common example.

1. Spreadsheets (e.g., Microsoft Excel, Google Sheets): Applications that organize data in rows and columns. They are powerful for:
   1. Data Organization: Storing and structuring large amounts of data.
   2. Calculations: Performing mathematical and logical operations using formulas.
   3. Data Analysis: Identifying patterns, trends, and anomalies through sorting, filtering, and pivot tables.
   4. Visualization: Creating charts and graphs to represent data visually, aiding in understanding and communication.

Functions of Computational Thinking Tools

Computational thinking tools serve several important functions in problem-solving:

1. Problem Decomposition: They help break down complex problems into smaller, manageable parts.
2. Pattern Recognition: They assist in identifying similarities and recurring themes in problems, allowing for reusable solutions.
3. Abstraction: They enable focusing on essential details while ignoring irrelevant information, simplifying the problem.
4. Algorithm Design: They provide structured ways to design step-by-step solutions to problems.
5. Implementation: Programming tools like Python allow the translation of algorithms into executable code.
6. Data Analysis: Analytical tools like spreadsheets help in processing, interpreting, and visualizing data to gain insights and make informed decisions.
7. Communication: Conceptual tools like flowcharts and pseudocode help in clearly communicating problem solutions to others.
8. Evaluation and Refinement: They facilitate testing and improving solutions to ensure they are efficient and effective.

Steps to Solve a Problem Using Computational Thinking

Solving a problem using computational thinking involves a systematic approach, typically broken down into four key stages:

1. Decomposition (Breaking Down the Problem):
   1. Conceptualize a task and represent visually: Understand the overall goal and sketch out the main components.
   2. Break the task into sub-tasks showing dependencies: Divide the big problem into smaller, more manageable parts. Identify how these smaller parts relate to each other and which ones depend on others.

   Example: Preparing a meal can be decomposed into: buying ingredients, washing vegetables, chopping ingredients, cooking, serving.

2. Pattern Recognition (Identifying and Reusing Patterns):
   1. Identify and reuse patterns across tasks: Look for similarities, trends, or repeated elements within the problem or across different problems. Recognizing patterns can lead to more efficient solutions and reusable components.

   Example: If you need to sort a list of names alphabetically and also sort a list of numbers numerically, you recognize the “sorting” pattern, even if the data types are different.

3. Abstraction (Focusing on Essential Details):
   1. Apply abstraction to separate essential details: Filter out unnecessary information and focus only on what is relevant to solving the current problem. This simplifies the problem and makes it easier to manage.

   Example: When designing a navigation app, you focus on routes, distances, and traffic, but ignore the color of cars or the type of trees along the road.

4. Algorithm Design (Creating Step-by-Step Solutions):
   1. Create algorithms for the solution: Develop a step-by-step set of instructions or rules to solve the problem. This algorithm should be precise, unambiguous, and lead to a solution.

   Example: An algorithm for making tea: boil water, put tea bag in cup, pour hot water, add sugar/milk, stir.

   1. Evaluate and refine developed algorithms: Test the algorithm to see if it works correctly and efficiently. If there are errors or inefficiencies, refine and improve the algorithm until it produces the desired outcome.

   Example: After making tea, you might realize adding sugar before hot water makes it dissolve better, so you refine the algorithm.

Teaching Methods/Instructional Techniques

Discussion, Demonstration, Guided Practice, Question and Answer, Explanation, Group Work, Practical Activity

Instructional Procedures

Step 1: Introduction

Time: 5 minutes

Teaching Skill: Explaining/Questioning

Teacher’s Activity: The teacher greets the students and asks them to recall how they solve simple problems in their daily lives, like finding a lost item or planning a trip. The teacher then introduces computational thinking as a structured way to solve problems, especially with computers.

Pupils’ Activity: Pupils respond to the teacher’s questions and share their experiences with problem-solving.

Learning Point: Introduction to problem-solving

Step 2: Introduction to Computational Thinking Tools

Time: 10 minutes

Teaching Skill: Explanation/Demonstration

Teacher’s Activity: The teacher explains what computational thinking tools are and categorizes them into conceptual, programming, and analytical tools. The teacher introduces the IPO model, flowcharts, and pseudocode as conceptual tools, Python as a programming tool, and spreadsheets as an analytical tool.

Pupils’ Activity: Pupils listen attentively and ask questions for clarification.

Learning Point: Types of CT tools

Step 3: Exploring Conceptual Tools

Time: 10 minutes

Teaching Skill: Explanation/Guided Practice

Teacher’s Activity: The teacher explains the IPO model with a simple example (e.g., calculating average score). The teacher then shows basic flowchart symbols and demonstrates how to draw a simple flowchart for a task like “making a phone call” using a template. The teacher also introduces pseudocode with a simple example.

Pupils’ Activity: Pupils observe the demonstrations and attempt to draw simple IPO charts and flowcharts on card sheets or in their notebooks.

Learning Point: IPO, flowchart, pseudocode

Step 4: Exploring Programming and Analytical Tools

Time: 5 minutes

Teaching Skill: Demonstration/Explanation

Teacher’s Activity: The teacher briefly demonstrates Python’s role in executing code (e.g., a simple print statement if possible) and shows how spreadsheets can organize and perform calculations on data (e.g., summing a column of numbers). The teacher highlights their use in solving problems.

Pupils’ Activity: Pupils observe the demonstrations and understand the practical applications of Python and spreadsheets.

Learning Point: Python and spreadsheets

Step 5: Functions of Computational Thinking Tools

Time: 5 minutes

Teaching Skill: Discussion/Brainstorming

Teacher’s Activity: The teacher guides students to brainstorm on the functions of the computational thinking tools discussed, encouraging them to identify how each tool helps in problem-solving. The teacher lists their contributions on the board.

Pupils’ Activity: Pupils actively participate in brainstorming and identify various functions of the tools.

Learning Point: Functions of CT tools

Step 6: Steps to Solve a Problem Using Computational Thinking (Group Activity)

Time: 10 minutes

Teaching Skill: Group Work/Facilitation

Teacher’s Activity: The teacher explains the four steps of computational thinking: Decomposition, Pattern Recognition, Abstraction, and Algorithm Design (including evaluation and refinement). The teacher then divides students into groups and guides them to create an algorithm for preparing instant noodles using these computational thinking steps. Each group should use pseudocode or a simple flowchart.

Pupils’ Activity: Pupils work in groups to apply the computational thinking steps to create an algorithm for preparing instant noodles. They present their algorithms.

Learning Point: Applying CT steps

Step 7: Evaluation/Review

Time: 5 minutes

Teaching Skill: Questioning/Assessment

Teacher’s Activity: The teacher evaluates the learning by asking the following questions:

1. Mention two conceptual tools used in computational thinking.
2. State three functions of computational thinking tools.
3. List the four main steps to solve a problem using computational thinking.
4. Draw a simple flowchart to represent the process of “waking up in the morning.”

Pupils’ Activity: Pupils answer orally and in writing.

Learning Point: Assessment of understanding

Step 8: Note-Taking

Time: 10 minutes

Teaching Skill: Guided Writing

Teacher’s Activity: The teacher guides pupils/students to copy the essential Board Summary notes on computational thinking tools and problem-solving steps into their notebooks.

Pupils’ Activity: Pupils/students copy the notes carefully into their notebooks.

Learning Point: Recording lesson content

Step 9: Conclusion

Time: 5 minutes

Teaching Skill: Summarizing

Teacher’s Activity: The teacher briefly summarizes the key concepts of computational thinking tools and their importance in solving problems systematically. The teacher encourages students to practice applying these steps in their daily lives.

Pupils’ Activity: Pupils listen and ask any final questions.

Learning Point: Consolidation of concepts

Continuous Assessment/Further Study

Type: Homework/Practice Exercise

Instruction: Answer the following questions and complete the task:

1. Define computational thinking and explain why it is important in today’s digital world.
2. Describe the difference between a flowchart and pseudocode, providing a simple example for each to illustrate how to make a cup of tea.
3. Using the computational thinking steps, outline how you would plan a school event (e.g., a debate competition).
4. Research and write a short paragraph on another programming language besides Python that can be used for automation.

Lesson Keywords

• Computational Thinking – A problem-solving process that involves breaking down problems, recognizing patterns, abstracting details, and designing algorithms.
• IPO Model – Input-Process-Output model, a conceptual tool for understanding how a system transforms data.
• Flowchart – A graphical representation of an algorithm or process using symbols.
• Pseudocode – A plain language description of an algorithm’s steps, resembling programming code.
• Python – A high-level programming language used for various applications, including automation.
• Spreadsheets – Analytical tools (e.g., Excel) used for organizing, calculating, and analyzing data in rows and columns.
• Decomposition – Breaking down a complex problem into smaller, manageable parts.
• Pattern Recognition – Identifying similarities or trends within problems.
• Abstraction – Focusing on essential details while ignoring irrelevant information.
• Algorithm Design – Creating a step-by-step set of instructions to solve a problem.

Differentiation

For struggling learners: Provide pre-drawn flowchart symbols and simpler problem scenarios for decomposition and algorithm design. Offer more direct guidance during group activities and provide sentence starters for explaining functions. Pair them with more capable students.

For advanced learners: Challenge them to design a more complex algorithm (e.g., for a simple game or a task with multiple decision points). Encourage them to research basic Python syntax for implementing parts of their algorithms or explore advanced spreadsheet functions for data analysis.

Suggested Lesson Videos

YouTube search: computational thinking tools for beginners SS1
YouTube search: introduction to flowcharts and pseudocode SS1