Manual for a computer science teacher: 3rd grade, 1st quarter

Objective of the lessons : To consolidate basic skills in working with a computer, text and files, to deepen knowledge of text formatting, to teach the basics of working with tables and to develop logical thinking through interactive tasks and games.

Lesson plan

Lesson 1: Review of the basics of working with a computer and file system

Topic : Updating knowledge about files and folders

Objectives:

Review the basic elements of working with a computer (files, folders, operating system).
Teach children to create, move and delete files and folders.

Materials:

Computers with an operating system installed.
Demonstration files and folders for work.

Lesson plan:

Introduction (5 minutes)
- Discuss how files are organized on a computer, what folders are and why they are needed.
Practical demonstration (10 minutes)
- Show how to create folders, move and copy files.
Practical part (20 minutes)
- Children create their own folders, copy files, move them, and delete unnecessary items.
Conclusion (5 minutes)
- Discuss the importance of keeping files organized for quick access.

Lesson 2: Advanced Text Work

Topic : Creating short documents and formatting text

Objectives:

Strengthen your typing skills.
Learn to format text: change font, bold, italic, change text color.

Materials:

A text editor (such as Word or Google Docs).

Lesson plan:

Introduction (5 minutes)
- Discuss how formatting helps make text more understandable and expressive.
Practical demonstration (10 minutes)
- Show basic text formatting elements: changing font size, highlighting, underlining, italics, bold.
Practical part (20 minutes)
- Children create short documents (for example, about themselves or their hobbies) and apply different formatting elements to them.
Conclusion (5 minutes)
- Discuss how and why formatting is used in texts (for example, in academic papers).

Lesson 3: Working with Tables – Entering Data

Topic : Basics of working with tables

Objectives:

Teach children the basics of working with tables.
Introduce the concept of a cell, row, column.

Materials:

A spreadsheet program (such as Excel or Google Sheets).

Lesson plan:

Introduction (5 minutes)
- Explain what a table is and what it is used for (making it easier to work with data).
Practical demonstration (10 minutes)
- Show how to enter data into tables, navigate cells, and work with rows and columns.
Practical part (20 minutes)
- Children create a simple chart, for example, with their daily schedule or a list of their favorite games.
Conclusion (5 minutes)
- Discuss how tables can help organize information.

Lesson 4: Basics of Calculations in Spreadsheets

Topic : Simple calculations in tables

Objectives:

Teach children to perform simple calculations (addition, subtraction) in tables.
To consolidate the concept of formulas.

Materials:

Spreadsheets (Excel or Google Sheets).

Lesson plan:

Introduction (5 minutes)
- Explain that tables can not only store data, but also perform calculations.
Practical demonstration (10 minutes)
- Show how to enter simple formulas to add and subtract data in cells.
Practical part (20 minutes)
- Children create a table of numbers (for example, purchases at the store) and perform calculations.
Conclusion (5 minutes)
- Discuss how calculations in tables make it easier to work with numbers.

Lesson 5: Interactive logic problems

Topic : Logical games for developing thinking

Objectives:

To develop logical thinking in children through interactive tasks and games.
Teach how to solve problems step by step, following sequences.

Materials:

Computers with logic games installed (for example, puzzles or brain teasers).

Lesson plan:

Introduction (5 minutes)
- Discuss the importance of logical thinking and how it helps in everyday life.
Practical demonstration (10 minutes)
- Show an example of a logic problem or game.
Practical part (20 minutes)
- Children play games, solve puzzles or work on interactive tasks that develop logic.
Conclusion (5 minutes)
- Discuss how logic problems help to better understand sequences and cause-and-effect relationships.

Lesson 6: Solving interactive problems with programming elements

Topic : Logical problems with elements of algorithms

Objectives:

Continue to develop logical thinking through interactive tasks with elements of programming.
Introduce the concept of simple algorithms.

Materials:

A program with elements of visual programming (for example, Scratch Junior or similar).

Lesson plan:

Introduction (5 minutes)
- Explain what an algorithm is and how it helps solve problems step by step.
Practical demonstration (10 minutes)
- Show how to create a simple algorithm (for example, to control a character in a game).
Practical part (20 minutes)
- Children solve problems using simple algorithms, creating sequences of actions to achieve a goal.
Conclusion (5 minutes)
- Discuss how algorithms help organize actions in life and in programming.

Lesson 7: Reinforcing table skills

Topic : Exercises on working with data and simple formulas

Objectives:

To review and consolidate knowledge about entering data and performing simple calculations in tables.

Materials:

Spreadsheets (Excel or Google Sheets).

Lesson plan:

Introduction (5 minutes)
- Briefly review what tables are and how calculations are performed.
Practical demonstration (10 minutes)
- Show additional examples of working with tables and formulas.
Practical part (20 minutes)
- Children complete more complex tasks in tables, such as calculating the sum or difference of several rows of data.
Conclusion (5 minutes)
- Discuss how using tables and formulas helps automate calculations.

Lesson 8: Summing up and checking knowledge

Topic : Final lesson on the topic of the quarter

Objectives:

Test the acquired knowledge and skills on the topics of the quarter.
To strengthen children’s confidence in their ability to work with texts, tables and logical problems.

Materials:

Tests or practical tasks.

Lesson plan:

Review of material (10 minutes)
- Brief overview of topics: working with text, tables, interactive tasks.
Practical part (25 minutes)
- Conducting a test or assignment where children must demonstrate their knowledge of all the topics covered.
Conclusion (5 minutes)
- Debriefing: Discussion of each child’s results and progress.