Загрузка
UP

A manual for a computer science teacher

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

Topics:

  1. Programming: Create complex programs using functions, parameters, loops, nested conditions, and data arrays.
  2. Introduction to databases: the basics of working with relational databases, creating and using simple SQL queries.
  3. 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:

  1. Review of functions and parameters (10 min).
    • Brief explanation of the function, parameters, return values.
  2. Using functions in complex problems (15 min).
    • An example of a program that uses multiple functions to solve a complex problem.
  3. 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:

  1. Repeating work with cycles (10 min).
    • Introduction to multidimensional arrays and their uses.
  2. Working with arrays and loops (15 min).
    • An example program that uses loops to process data in multidimensional arrays, such as a data table.
  3. 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:

  1. What is a database? (10 min).
    • The concept of a database, why they are needed, examples of databases (data tables, records).
  2. Fundamentals of Relational Databases (15 min).
    • Structure of relational databases: tables, rows, columns, keys.
  3. 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:

  1. Databases and queries review (10 min).
    • A reminder of the basic concepts of databases and SQL.
  2. Simple SQL queries (15 min).
    • Examples of queries: data selection, filtering by conditions, sorting records.
  3. 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:

  1. Repetition of work with tables (10 min).
    • Explanation of more complex functions (eg, IF, SUM, AVERAGE).
  2. Construction of diagrams and graphs (15 min).
    • Examples of using table data to create charts.
  3. 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:

  1. Complex formulas and data filtering (10 min).
    • Application of formulas for data analysis, example of calculating median, mode.
  2. Sorting and filtering data (15 min).
    • How to apply filters to search data, sorting by different criteria (for example, alphabetically or numerically).
  3. 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:

  1. Review of key topics (10 min).
    • A quick review of key topics related to programming, databases, and working with spreadsheets.
  2. 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:

  1. Presentation of projects (30 min).
    • Students present their projects to the class, explaining how they work and what was done.
  2. 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.