# A manual for a computer science teacher

## 6th grade, 2nd quarter (7-8 lessons)

**Topics:**

- Programming: Introduction to text-based programming languages (such as Python or HTML/CSS) – basic syntax, variables, loops, branching.
- Working with tables: creating complex formulas, working with data in the context of finance (budgeting, calculations), creating diagrams.
- Cybersecurity Basics: Internet threats, cyberattacks, security measures when working on the Internet, creating and using complex passwords.

**Lesson 1: Programming Basics – Introduction to Syntax**

**Objective:**

To introduce students to the basics of text-based programming languages (Python or HTML/CSS) and teach basic syntax.

**Lesson plan:**

**Introduction to text-based programming languages**(10 min).- What is Programming? Introduction to Python or HTML/CSS.
- Basic concepts: syntax, variables, input/output commands.

**Practical work**(25 min).- Students create a simple program to print text and work with variables (for example, a Python program that prints a greeting).

**Discussion of results**(10 min).- Analysis of the program, discussion of errors.

**Homework:**

Try writing a program that displays a personalized message (depending on the name entered).

**Lesson 2: Programming Basics – Variables and Data Types**

**Objective:**

To teach how to work with variables and different types of data.

**Lesson plan:**

**Variables and data types**(10 min).- What is a variable? Basic data types: integers, fractions, strings.

**Practical work**(25 min).- Students create programs that use different data types and variables (for example, a calculator with basic addition and subtraction operations).

**Discussion of solutions**(10 min).- What types of data were used, what difficulties arose?

**Homework:**

Write a program that takes two numbers and outputs their sum, difference, and product.

**Lesson 3: Programming – Loops and Branching**

**Objective:**

To study loops and branches in programming and their use to create logic.

**Lesson plan:**

**Cycles and Branching**(10 min).- What are loops (for, while)? How do branches (if-else) work?

**Practical work**(25 min).- Students create programs with loops and branches (for example, a program that calculates the sum of numbers from 1 to 10 or checks whether a number is even).

**Discussion of the program operation**(10 min).- Questions: “Which type of cycle was easier to use?”

**Homework:**

Create a program that asks the user for a number and prints out all the numbers from 1 to that number, separated by commas.

**Lesson 4: Working with Tables – Complex Formulas and Calculations**

**Objective:**

To teach how to create complex formulas in spreadsheets and apply them to solve financial problems.

**Lesson plan:**

**Complex formulas in tables**(10 min).- How to create formulas to perform complex calculations? Examples of formulas for financial calculations (sum, average, percentage calculations).

**Practical work**(25 min).- Students create a spreadsheet to calculate a simple budget (income and expenses) and use complex formulas to calculate totals.

**Discussion of tables**(10 min).- Questions: “Which formula was the most difficult to implement?”

**Homework:**

Think through and develop your own example budget with income and expense calculations.

**Lesson 5: Working with Data – Charts and Visualization**

**Objective:**

To teach students to create charts to visually represent data.

**Lesson plan:**

**Introduction to diagrams**(10 min).- Types of charts: bar, pie, line. When and why to use charts?

**Practical work**(25 min).- Students create charts for their budget project or other data (such as school grades or the weather for the week).

**Discussion of diagrams**(10 min).- Questions: “How does a chart help visualize data?”

**Homework:**

Create a chart for the data they collected at home (e.g. weekly expenses).

**Lesson 6: Cybersecurity Basics – Internet Threats and Data Protection**

**Objective:**

To introduce students to the main Internet threats and methods of data protection.

**Lesson plan:**

**Internet threats**(10 min).- Introduction to cyber threats: viruses, phishing, cyber attacks. How do viruses work and how do they spread?

**Practical work**(25 min).- Students discuss real-life examples of online threats and develop a plan of action to prevent threats (e.g. what to do if you receive a suspicious email).

**Discussion of safety measures**(10 min).- What methods of protection are used most often and why?

**Homework:**

Write an online safety plan and present it to the class.

**Lesson 7: Cybersecurity – Strong Passwords and Data Protection**

**Objective:**

To teach how to create complex passwords and manage account security.

**Lesson plan:**

**Creating complex passwords**(10 min).- What is a complex password? How to create one? How often should passwords be changed?

**Practical work**(25 min).- Students create examples of complex passwords and test them using online password testing services (if available in class). Discussion of password storage.

**Discussion of account security**(10 min).- Questions: “Why can’t I use the same password for all services?”

**Homework:**

Create several unique passwords for different accounts and think of a system for storing them.

**Lesson 8: Final Lesson – Programming and Data Security**

**Objective:**

To consolidate acquired knowledge of programming and cybersecurity.

**Lesson plan:**

**Solving a practical programming problem**(10 min).- Students are given an assignment: to create a program that solves a specific problem using variables, loops and branching.

**Practical work**(25 min).- Implementation of the program and discussion of approaches to its solution. Discussion of security when working with program code.

**Discussion of data protection**(10 min).- Final discussion on the topic of cybersecurity. Analysis of the most important aspects of data protection.

**Homework:**

Prepare a mini-project on the topic “How to protect yourself on the Internet”, including elements of cybersecurity and programming.

**Conclusion**

The manual is designed for 7-8 lessons, during which students learn the basics of programming, work with tables and data, and also delve into the basics of cybersecurity. The lessons are focused on the practical application of knowledge and reinforcement of skills through projects and tasks.