# A manual for a computer science teacher

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

**Topics:**

- Programming: Create complex programs using functions, parameters, loops, nested conditions, and data arrays.
- Introduction to databases: the basics of working with relational databases, creating and using simple SQL queries.
- Working with tables: data analysis, complex formulas, creating graphs and charts to analyze information.

**Lesson 1: Review of Functions and Parameters**

**Objective:**

To reinforce the concept of functions and parameters and to demonstrate more complex programs using these concepts.

**Lesson plan:**

**Review of functions and parameters**(10 min).- Brief explanation of the function, parameters, return values.

**Using functions in complex problems**(15 min).- An example of a program that uses multiple functions to solve a complex problem.

**Practical work**(20 min).- Writing a program that contains several functions with parameters and solves a mathematical problem, for example, calculating the average value of an array of numbers.

**Homework:**

Create a program that uses functions to perform calculations with different types of data (e.g. text strings, numbers).

**Lesson 2: Working with Loops and Arrays**

**Objective:**

To deepen knowledge about cycles and data arrays, to show how to work with multidimensional arrays.

**Lesson plan:**

**Repeating work with cycles**(10 min).- Introduction to multidimensional arrays and their uses.

**Working with arrays and loops**(15 min).- An example program that uses loops to process data in multidimensional arrays, such as a data table.

**Practical work**(20 min).- Writing a program that works with an array of data, such as calculating the average value for each row in a table.

**Homework:**

Create a program that uses arrays to work with large amounts of data, such as student grades.

**Lesson 3: Introduction to Databases**

**Objective:**

To introduce students to the concept of a database, to show how relational databases and simple SQL queries work.

**Lesson plan:**

**What is a database?**(10 min).- The concept of a database, why they are needed, examples of databases (data tables, records).

**Fundamentals of Relational Databases**(15 min).- Structure of relational databases: tables, rows, columns, keys.

**Practical work**(20 min).- An example of creating a database using SQL, adding records and performing simple queries (for example, selecting all records from a table).

**Homework:**

Create a simple database (eg a list of students) and write an SQL query to retrieve the data.

**Lesson 4: SQL Queries and Working with Data**

**Objective:**

To teach basic SQL queries for working with data in a relational database.

**Lesson plan:**

**Databases and queries review**(10 min).- A reminder of the basic concepts of databases and SQL.

**Simple SQL queries**(15 min).- Examples of queries: data selection, filtering by conditions, sorting records.

**Practical work**(20 min).- Create a program that executes SQL queries and displays the results on the screen (for example, selecting all students with a grade above 90).

**Homework:**

Write SQL queries to filter and sort data in the database.

**Lesson 5: Working with Tables – Advanced Functions**

**Objective:**

To teach students to apply complex formulas in tables and construct graphs.

**Lesson plan:**

**Repetition of work with tables**(10 min).- Explanation of more complex functions (eg,
`IF`

,`SUM`

,`AVERAGE`

).

- Explanation of more complex functions (eg,
**Construction of diagrams and graphs**(15 min).- Examples of using table data to create charts.

**Practical work**(20 min).- Plotting a graph to analyze data (e.g. growth/decline in academic performance).

**Homework:**

Create a table with data and build a chart to visualize it.

**Lesson 6: Analyzing Data in Tables**

**Objective:**

To demonstrate to students how to analyze data in tables using complex formulas and sorting and filtering tools.

**Lesson plan:**

**Complex formulas and data filtering**(10 min).- Application of formulas for data analysis, example of calculating median, mode.

**Sorting and filtering data**(15 min).- How to apply filters to search data, sorting by different criteria (for example, alphabetically or numerically).

**Practical work**(20 min).- Create a table with data filtering, sorting and data analysis using complex formulas.

**Homework:**

Create a table with data and apply filters to it for analysis.

**Lesson 7: Wrap Up and Mini Project**

**Objective:**

To consolidate acquired knowledge, prepare students for the practical application of knowledge through the completion of a mini-project.

**Lesson plan:**

**Review of key topics**(10 min).- A quick review of key topics related to programming, databases, and working with spreadsheets.

**Getting Started with a Mini Project**(25 min).- Project Development: Students create a program that uses databases and produces data analysis (e.g. a system for keeping track of grades in a class).

**Homework:**

Continue working on the mini-project and prepare it for the next lesson.

**Lesson 8: Presentation of mini-projects**

**Objective:**

To give students the opportunity to present their projects, discuss the results obtained and consolidate their knowledge.

**Lesson plan:**

**Presentation of projects**(30 min).- Students present their projects to the class, explaining how they work and what was done.

**Discussion and feedback**(10 min).- The teacher and students discuss the completed work and share their experiences.

**Homework:**

Finish the project and prepare it for submission.