Lesson on the topic “Information technologies and the evolution of their development. Lesson summary on the topic “Information technology Lesson summary on the topic information technology

Frontal survey of acquired knowledge

Establish the correctness and awareness of the knowledge acquired in previous lessons, as well as eliminate gaps in knowledge.

1. Establish the correctness and differences of terms.

2. Identify common errors in terminology during the survey.

3. Promote repetition of the material covered.

4. Make timely corrections in knowledge and skills.

5. Conduct a brief safety briefing.

1. Frontal survey.

1. Reinforce the concepts covered in the last lesson.

2. Learn to answer questions in professional language.

Explanation, story

What is a database?
How many ways to create tables in Access do you know? Which method is the most professional, from your point of view?
Why are drop-down lists needed when filling out tables?

This is various data collected in one place. Slide 5
2 ways to create tables, using data entry and using the table creation designer. The most professional way is to use the table designer; it allows you to construct and define fields and their data types yourself, and set drop-down lists of fields.
To simplify data entry for the user

Ensuring perception, comprehension and primary memorization of knowledge and methods of action learned in this lesson

1. Give a specific idea of creating tables using the designer, setting additional field properties

2. To promote the perception of primary memorization of such concepts as “key field”, “field properties”, “data types”, “input mask”, “relationship between tables”.

3. Systematize knowledge and skills on the material covered at this stage.

Reproductive conversation using screen demonstrations of examples of creating tables.

Explanatory and illustrative.

1.Familiarize yourself with the concepts of “key field”, “field properties”, “data types”, “input mask”, “relationship between tables.

2. Be able to enter and create tables using Access tools.

3. Establish connections between tables.

3. Take notes carefully.

1. Conversation

2. Educational practice.

3. Note-taking.

(Slide 5)

In your professional activities, you will encounter various databases. During your internship, you will repeatedly have to develop databases in your subject area yourself.

Creating a database table consists of two steps:

At the first stage, its structure is determined: the composition of the fields, their names, the data type and size of each field, keys, table indexes and other field properties;

The second stage involves creating table records and filling them with data. Slide 6

Technology means a set of methods, methods and techniques used to obtain a certain type of product. With the development of material production, production technologies were created and developed in industry and agriculture.

Information technology refers to the field of information activities of people. Book publishing, television and radio broadcasting, newspaper publishing, librarianship and much more have created their own technologies. Any education, including school education, requires special techniques, that is, technology.

Download:

Preview:

Lesson summary on the topic

"Information Technology"

9th grade

Technology meansa set of methods, methods and techniques used to obtain a certain type of product. With the development of material production, production technologies were created and developed in industry and agriculture.

Technology - it is a precisely calculated process of obtaining a predictable (predetermined) result. This Property is the most important characteristic of technology, distinguishing it from other processes, for example, an experiment, where the result cannot be predetermined, etc.

Information technologies based on modern computer technology are often called new information technologies (NIT). NIT arise at the crossroads of traditional (non-computer) technologies and computer methods of information processing.

Let us list some NITs that are widely used today.

Preparation of documents

Almost any business area is associated with the preparation of documentation: reporting, directive, reference, accompanying, etc. The use of computers for these purposes has become ubiquitous.

A computer in an office performs many jobs, which can be divided into two categories: regulated and unregulated. Regulated ones are those that are regularly repeated, producing documents of the same type that differ from each other in sets of numerical data or text fragments. Examples include a salary slip, a class magazine, a company's monthly financial report, etc. To prepare each of these documents, a special program is used, which automatically (from the database) enters new information into pre-prepared standard forms.

Unregulated work is more varied in nature; it is impossible to stock up on special programs for it and they are performed, as a rule, using general-purpose office software (word processors, graphic editors, presentation preparation programs, etc.).

Search for information

Anyone who has been and worked in a large library knows how difficult it can sometimes be to find the book you need, especially if the exact bibliographic data is not known, but only the subject is known. Modern information retrieval systems have completely transformed the technology of information retrieval. Computer systems for searching books and magazines have become quite common in libraries. In the process of preparatory work, electronic card indexes are created, and upon request by topic, a list of selected books appears on the library computer screen.

If we are looking for information outside the library, we turn to modern search engines, usually working through computer networks. Search engines on the Internet often find so much information on request that it becomes a problem to select the most relevant information for the client. Moreover, unlike libraries, we are talking not only about books, but also about information presented in any other sources and in a wide variety of forms (including audio).

New technologies for data retrieval have also given rise to new forms of description and systematization of data. Thus, computer search systems widely use indexing - ordered lists by different keys. Traditional digital classification systems (UDC - universal decimal classification) continue to be used. Index lists based on keywords and thesaurus are used.

Thanks to the high speed of modern computers, it is possible to search through all texts stored in the system (for the presence of the requested word or group of words).

Assistance in making management decisions

Twenty years ago, many enterprises in the country began to introduce automated control systems - ACS. However, initially they were not very effective. To date, great changes have occurred in this area: new concepts have emerged, the technical and software information base has changed. As a result, the efficiency of using automated control systems has increased significantly.

A classic automated control system includes an information collection system, a database, an information processing and analysis system, and a system for generating output information. The information processing and analysis unit is central. He solves the problems of assessing and forecasting the activities of an enterprise, responding to unforeseen and disruptive situations that require immediate action, performing design, technological and financial accounting calculations, etc. His work is based on an economic and mathematical model of an enterprise, which is of an optimization nature. As a rule, automated control systems operate on the basis of an enterprise local computer network, which gives the system flexibility and efficiency.

Process control

Thanks to microprocessor technology, it has become possible to create systems that take control of individual mechanisms and even entire technological processes. At the same time, there are automated systems in which a person is directly involved in the technological process, and automatic ones in which a person is practically removed from control.

The problem of direct human participation in technological process control is most often associated with the speed of this process. If the speed exceeds human capabilities, then the operation of such systems is completely automated. For example, when launching a spacecraft, hundreds of sensors transmit information about the progress of the flight to the ground-based computer complex, and in case of problems, there may be a split second left to make a decision, that is, a person simply will not have time to react. In this case, the program (which, of course, was compiled by people) reacts.

Computer-aided design

Informatization has produced another extremely important technology - computer-aided design (CAD) systems.

Design includes the creation of sketches and drawings, economic and technical calculations, work with documentation, modeling, etc.

Modern CAD is a highly professional program that takes on many of these activities.

There are two types of CAD systems: drawing and specialized for certain types of products. Drawing CAD systems are universal; they allow you to create complex drawings in any area of technical design. Specialized CAD, for example, for the design of residential buildings, contains in the database all the necessary information about building materials - both technical and economic, about standard building structures, foundations, etc. The design engineer creates an image of the house, its technical and economic calculations, drawings without the once familiar drawing board and drawing tools. All this radically improves the design process.

Geoinformation technologies

This is the name of the latest information technologies, which led to the creation of the most modern class of information systems - Geographic Information Systems (GIS). These systems store data linked to a geographic map of the area (district, city, country, etc.).

For example, a municipal GIS stores in its databases the information necessary for all services that support the life of the city: city authorities, energy workers, water management specialists, communications specialists, tax authorities, social security authorities, police, medical services, etc. All this heterogeneous information is linked to the city map, which is the organizing basis of the GIS. Thanks to special technological techniques, this map can be scaled, that is, you can “cut out” a piece from it (simply by tracing it on the screen with a mouse) and enlarge it. By clicking on an object on the screen, instead of a map, we get a database with a description of this object.

There are GIS on a much larger scale: regional, national, international. For example, through the efforts of a number of states, the Black Sea GIS was created. It should be understood that creating a GIS is labor-intensive and expensive, but the effectiveness of its use is extremely high.

Information technologies in education

Training reaches millions of people. There are systems of secondary, higher, and additional education, systems of advanced training, retraining of personnel, etc. A specialist of the 21st century will be placed in conditions where he will almost constantly have to learn something. Society is faced with the task of creating a system of continuous education that will serve a significant part of the population.

Learning technologies have changed little over the past 100 years. So far, the method of collective teaching is mainly in effect: one teacher per group of students. This method of training does not always give good results. The reason lies in the differences in individual abilities and capabilities of students.

The path to improvement lies through the individualization of learning. Already now, NIT teaching tools are helping to solve this problem:

Individual use of special programs (training, training, monitoring, etc.). The combination of such programs for a specific subject (or section) forms what is called an electronic textbook. Multimedia technologies are widely used when creating electronic textbooks.

Another problem of the education system (most of all this applies to higher and special education) is the unequal conditions for people in the opportunity to receive a quality education due to geographic distance from educational centers, due to the limited capacity of universities, etc. Help in solving this problem a new form of learning is coming:

Distance education using computer networks. There are several distance education technologies that are currently competing with each other and being tested.

Questions and tasks

What do the terms “technology”, “information technology”, NIT mean?

List the main problems solved by means of NIT.

What forms of NIT have you dealt with? Note their positive aspects and possible disadvantages.

Lesson 1. Information technologies in society.

Date of:_______

Lesson type: discovery of new knowledge.

Planned educational results:

Subject:

formation of general ideas aboutthe role of information technology in society, stages and prospects of its development;

Metasubject:

be able to bind educational content with your own life experience and understand the significance of the subject in the modern information society

Personal:

development of speech, thinking, imagination of schoolchildren;

students' desire to improve their communication skills;

formationcommunication and teamwork skills.

Lesson objectives:

1) introduction of students with the concept of information technology in society ;

2) studying the rules and norms of behavior when communicating on the Internet;

3) acquaintance with laws of information technology development ;

Technology used: system-activity approach.

Organizational forms of training: group, frontal.

Teaching methods: research, visual and illustrative.

Lesson steps

Organizational. (3 minutes)

Updating knowledge (7-10 minutes)

Introduction of a new topic (15-18 minutes)

Reflection (4-7 minutes)

homework (2-3 minutes)

During the classes

III. Introduction of a new topic (15-18 min. T)

Human society has constantly developed and changed throughout its history. The rules and norms of communication between people also vary depending on the historical era, customs and traditions of a particular people. Do you think the development of the Internet and the introduction of information technology into the everyday life of people has brought certain changes in society?

Concept Information society inextricably linked with technological level of development. In an information society, the main resource is information; in such a society, most people are overwhelmed by the production, storage, processing and transmission of information.

What signs of the information society do you know?

availability of computers;

level of development of computer networks;

the share of the population employed in the information sector, as well as using information technologies in their daily lives.

Currently, no state can be called an information society, but some have approached this. What countries do you think these are? ( Japan, USA and some countriesEuropean Union).

In the information society, human activity will be
largely depend on the ability to effectively use existing
information.

So, you and I now know what the information society is. Let us now formulate the concept of information technology in society.

Information technology (IT) is a process that uses a set of methods and software and hardware to collect, process, store, transmit and present information in order to obtain information of new quality, reduce labor intensity and increase the efficiency of the processes of using information resources.

The use of computers in all spheres of human activity will allow:

provide access to reliable sources of information;

relieve a person from routine work;

speed up making optimal decisions;

Aautomate information processing.

As a result, the production of information products will become the main sphere of human activity. This process will lead to the creation of an information society in which knowledge and intelligence will play a major role.

The creation of the international computer network Internet played a huge role in the advancement of humanity along the path to the information society. Today it is a colossal and rapidly growing system.

Now we see signs everywhere that our society is approaching an information society. Everyone has a TV, a telephone at home, most have a computer connected to the Internet, and a mobile phone. New professions have appeared, such as programmer and system administrator. Many professions have changed greatly with the advent of computers.

Do you think there are rules and norms for communication on the global Internet?

In social networks, forms and various chats, which are abundant on the global network, people communicate and exchange information, just as in everyday life. Therefore, you should not forget about communication etiquette if you are typing a message on a social network to your classmate or sending an email with business content. I present to you the Ten Commandments of Internet Etiquette. Let's discuss them and imagine how people communicate without following these rules.

1.Remember the person! Don’t forget that even through a dead Internet and a computer crammed with electronics, you are communicating with a living person. And often - with many people at the same time... Don’t let yourself be fooled by the atmosphere of anonymity and permissiveness - remember that on the other end of the line there is a person just like you... When composing an email, imagine that you are saying all this to the person directly in the face - and try not to be ashamed of your words. Hence the second rule:

2.Follow the same rules online that you follow in real life. Violating the laws of human communication, moral rules or norms of social life on the Internet may be relatively unpunished for you... But will your conscience be clear? However, do not forget about the third rule:

3.Remember that you are in cyberspace! Its boundaries are much wider than the boundaries of the human society we are accustomed to, and different parts of it may have their own laws. Therefore, when faced with a new type of communication on the Internet, study its laws and recognize their priority. For example, any newsgroup, forum or even IRC channel has its own, local rules (rules) - check them out before sending your first message! And most importantly, remember the unwritten rules: for example, rule four:

4. Be careful with the time and opinions of other people! Ask for help only when it is really necessary - and in this case you can always count on the help and support of your colleagues. However, do not bother other users over trifles - otherwise, in the end, they will simply stop communicating with you. Remember that network time is not only limited, but also quite expensive for many! And, in addition to your problems, your interlocutors may also have their own... However, this principle also has a downside, recorded in rule five:

5. Try to look decent in the eyes of your interlocutors! Don't save your time on "conventions" such as rules of good manners or, say, rules of grammar and spelling. Even compliments lose weight and persuasiveness when embodied in this form:

"Hey dude, I'm crazy about you and your books, write cool"

Rule six follows from this rule:

6.Do not neglect the advice of experts and share your knowledge with others! Be grateful to those who spend their time answering your questions. But even if you receive a letter with a question from another user, do not rush to send this message to the trash bin, no matter how ridiculous and naive it may seem. Hence the seventh rule:

7.Contain passions. No etiquette prohibits entering into discussions, but do not stoop to swearing and swearing - even if your counterpart deliberately provokes you to do so.

8. Respect not only your own, but also other people’s privacy! If for some reason you want to remain anonymous on the Internet, recognize these rights as your interlocutor. Moreover, he has the right to anonymity and privacy, even if you speak “with an open visor.” A side consequence of this rule: do not publish information from your private letters without the consent of their senders, do not delve into other people's mailboxes and, ultimately, in other people's computers! Gentlemen, hackers, this applies directly to you... As does the following rule:

9. Do not abuse your power and influence on the Internet! Gaining trust is difficult, but losing it is so easy!
And finally - the last, most important rule:

10. Be tolerant of the shortcomings of the people around you! Don’t look at whether your interlocutors follow the rules of netiquette or not, follow them yourself! In the end, very politely recommend that the interlocutor familiarize himself with these rules...

REGIONAL STATE BUDGETARY PROFESSIONAL EDUCATIONAL INSTITUTION "ALTAI INDUSTRIAL AND ECONOMIC COLLEGE"

PLAN

lesson in the discipline “Information technologies in professional activities”

for specialty 38.02.01 Economics and Accounting

(by industry)

Barnaul 2015

Agreed

Chairman of the PCC of accounting and economic disciplines

L. V. Besedina

"___"_______________2015

Agreed

Deputy Director for SD

O.Yu. Govorova “____”_______________2015

Teacher: Chernyshova T.V.

Subject: Numerical information processing technology

Lesson topic: Designing and filling out a spreadsheet document. Creating and copying formulas. Using absolute links. Business graphics in a spreadsheet

Group: 9B141

Lesson date:

Lesson type: Combined lesson

Lesson type: Practical lesson

Lesson objectives:

Educational:

Developmental:

Educational

Lesson objectives:

Information and methodological support:

Technical teaching aids: personal computer, projector; software: Windows OS, MS Excel program; didactic material: presentation for the lesson, guidelines for practical work, test assignments on the topic of the lesson.

List of sources used:

1 Zhumenko, V.N. Computer for accountants and auditors: a practical guide / V.N. Zhumenko. - Rostov-n/D: Phoenix, 2011. – 509 p.

2 Mikheeva, E.V. Workshop on information technologies in professional activities: textbook. aid for students avg. prof. education / E.V. Mikheeva. – M.: Publishing Center “Academy”, 2010. – 256 p.

3 Absolute and relative cell addresses in MS Excel 2010 [electronic resource]//access mode -

Algorithm for conducting a lesson

Table 1

№p/p

Time

Stages of implementation

Teacher's activities

Student activities

5 minutes

Organizational moment, preparation of equipment for work

Conducts group roll call, identifies absentees, turns on PC, loads presentation

Prepare for class: turn on the PC, download the program

5 minutes

Goal setting

Informs the topic and plan of the lesson, activates the setting of goals and objectives of the lesson

Discuss the goals and objectives of the lesson

30 min

Presentation of new material

Explains new material

Listen to the teacher, write down basic definitions, apply theoretical knowledge in practice

5 minutes

Physical education minute

Conducts physical culture for a minute

Repeat the exercises after the teacher

5 minutes

Introduction to the practical work assignment

Issues assignments for practical work, answers students’ questions

Get acquainted with the task to be completed, ask questions of interest

20 minutes

Consolidation of the studied material during practical work

Provides individual consultations to students as they progress through their work.

Do practical work

10 min

Checking your understanding of the material during testing

Provides instructions on how to complete a test task

Get acquainted with the content of the task and complete it

5 minutes

Issuing homework

Gives out homework

Write down homework

5 minutes

Summing up the lesson

Summarizes the lesson and gives grades

Shut down PCs and clean up workspaces

Teacher _____________ Chernyshova T.V.

Lesson outline:

1 Organizational moment, preparing equipment for work (5 min)

Greeting, identifying absentees by conducting roll call. Checking readiness for the lesson.

2 Goal setting (5 min)

MS Excel is one of the most popular spreadsheets today. It is used by scientists and business people, accountants and journalists; with its help, various tables, lists and catalogs are maintained, financial and statistical reports are compiled, the state of a trading enterprise is calculated, the results of a scientific experiment are processed, records are kept, and presentation materials are prepared. Excel's capabilities are very high. In this regard, we are starting the topic: Designing and filling out a spreadsheet document. Creating and copying formulas. Using absolute links. Business graphics in a spreadsheet processor.

Work plan:

1 Purpose and main capabilities of the Excel spreadsheet processor;

2 Basic objects and data types;

3 Editing table data, creating and copying formulas;

4 Absolute and relative links;

5 Construction of charts and graphs.

At today's lesson the following goals and objectives will be set:

Educational: consolidate knowledge about the MS Excel spreadsheet processor, form an understanding of calculations in spreadsheets as an important and widely used structure in practice;

Developmental: create conditions for developing the ability to apply knowledge to solve problems using spreadsheets, develop skills in individual practical work;

Educational: create conditions that ensure the development of accuracy and attentiveness when performing work using a personal computer.

Lesson objectives:

1 Show the purpose and main capabilities of the Excel spreadsheet processor;

2 Introduce its objects and data types;

3 Learn to edit table data, create and copy formulas;

4 Explain the differences between absolute and relative links;

5 Teach the construction of charts and graphs.

3 Presentation of new material (30 min)

1 Purpose and main capabilities of the table processor.

What is Excel?

Excel is a spreadsheet processor. A spreadsheet processor is an application program that is designed to create spreadsheets and automated processing of tabular data.

A spreadsheet is a regular table consisting of rows and columns, at the intersection of which there are cells containing numerical information, formulas, and text.

Appendix 1. Slide 2

The main features of spreadsheets include:

automation of all final calculations;

the same type of calculations can be performed on large data sets;

you can solve problems by selecting values with different parameters;

you can process the results of experiments;

tabulate functions and formulas;

prepare tabular documents;

search for the most optimal values for the selected parameters;

build graphs and diagrams based on already entered data.

Learning to work with Excel must begin with studying the Excel application window. When you launch Excel, the application window opens, displaying a new workbook – Workbook 1.

2 Basic objects and data types When working on a computer, a spreadsheet exists in the form worksheet , which has a name (for example, Sheet1). Workbook sheets can be renamed. To do this, you need to right-click on the book sheet, select the rename menu item and enter a new name.

Worksheets are organized into workbooks that can be added (context menu/add), removed (context menu/delete), and rearranged (context menu/move).

The Excel application window has five main areas:

Menu bar;

Toolbars;

Status bar;

Input line;

Workbook window area.

Appendix 1. Slide 3

Let's look at the main elements of spreadsheets in more detail. Cell

– an elementary spreadsheet object located at the intersection of a column and a row. Line

– all cells located on the same horizontal level. Column

– all cells located in one vertical row of the table. Cell range

– a group of adjacent cells, which can consist of one cell, a row (or part thereof), a column (or part thereof), or a collection of cells covering a rectangular area of the table.

Appendix 1. Slide 4

The main elements of spreadsheets have names. Line:

Row headers are represented as integers, starting with 1. column headings are given by letters of the Latin alphabet, first from A to Z, then from AA to AZ, from BA to BZ, etc.

Cell: The address of a cell is determined by its location in the table, and is formed from the headings of the column and row at the intersection of which it is located. The column heading is written first, followed by the row number. For example: A3, D 6, AB46, etc.

Cell range: is specified by indicating the addresses of its first and last cells, separated by a colon. For example: the address of the range formed by part of line 3 - X 3: Z 3 ; address of a range that looks like a rectangle with an initial cell
F 5 and end cell G 8 – H 5: L 8 .

Appendix 1. Slide 5

3. Editing table data, creating and copying formulas

In addition to the name, the main elements of spreadsheets have such a property as a data type.

Appendix 1. Slides 6-9

Creating formulas

Let's begin our consideration of this issue by constructing a simple numerical table and formulate the task.

Task. Suppose you need to calculate the totals of rows and totals of columns in a table

table 2

Bottom line

We will calculate the row totals manually. To do this, enter the following formula in line E3 =B 3+C 3+D 3 Enter key. Then we expand the formula across the columns. The totals for the columns will be calculated using a formula. Press the f (x) key, select the SUM formula, and in the corresponding window select the data range (B3:B5) and similarly stretch the formula along the line.

By specifying the cell address in a formula, we give the computer a reference to the cell that needs to be added, multiplied, etc. When writing a formula, relative references are automatically used.

4 Absolute and relative links

Appendix 1. Slide 11

But, sometimes you need the links in the cells to remain unchanged, i.e. The cell address did not change. Then you have to use absolute links. Absolute link– a link that does not change when copying the formula.

An absolute reference is written in a formula if, when copying it, should not change both parts: column letter and row number. This is indicated by using the $ symbol, which is placed before both the column letter and the row number.

Appendix 1. Slide 13

Mixed link is used when, when copying a formula, only one part of the link can change - either the column letter or the row number. In this case, the $ symbol is placed before that part of the link that should remain unchanged.

Appendix 1. Slide 15

5 Building charts and graphs

Charts are used to present series of numerical data in a graphical format that makes it easier to understand large amounts of information and the relationships between different data series.

To create a chart in Excel, first enter numeric data into a worksheet. You can then build a chart based on them by selecting the desired chart type on the tabInsert in Group Diagrams .

Appendix 2. Slide 1-12

4 Physical education minute (5 min)

Training sessions that combine mental and static loads on individual organs and the entire body as a whole require physical education classes to relieve local fatigue..

Conducting general physical education.

Appendix 3

Carrying out a set of gymnastics exercises for the eyes.

Appendix 4

Introduction to the practical work task (5 min)

Instructions for students to perform practical work.

(Appendix 5)

Consolidation of the studied material during practical work (20 min)

After completing the practical work, each student must present the finished product (Appendix 6) on the monitor of his work computer.

Checking your understanding of the material during testing (10 min)

Issuing a test task (Appendix 7). Read the test questions carefully. For each of the ten questions, choose one correct answer.

Criteria for evaluation:

A score of “2” is given for one to four correct answers.

A score of “3” is given for five to six correct answers.

A score of “4” is given for seven to eight correct answers.

A score of “5” is given for nine to ten correct answers.

Handing out homework (5 min)

Learn the lecture material. Compose a crossword puzzle based on the concepts of a table processor in MS Excel.

Summing up the lesson (5 min)

Generalizing point - conclusions are formulated on achieving the goals of the lesson. Grades are given.

Gainutdinova Olga Evgenievna, State Autonomous Educational Institution “Kazan Energy College”

Technological lesson map

Information technologies in professional activities, group 14-11, 3rd year

Lesson topic: "Database. Database management systems"

Lesson type: lesson of studying and primary consolidation of new knowledge

The purpose of the lesson: Study of databases, tabular databases, database management systems.

Tasks:

Educational: introduce students to the concepts: types of databases, database management system, DBMS objects; provide initial knowledge of working with a Microsoft Access database.
Developmental : develop algorithmic thinking and creative abilities of students.
Educational: cultivate cognitive interest in the subject of computer science with the help of practical tasks; To develop in students the ability to solve problems independently, as well as to work in a group.

Teaching methods: reproductive, problematic, heuristic.

Forms of organization of students’ cognitive activity: collective, individual.

Means of education: computers, projector, lecture material, presentation.

UMK :

Shafrin Yu.A. Computer science. Information Technology. Volume 1-2. - M: Binom. Knowledge Laboratory, 2013.
Ugrinovich N.D. and others. Workshop on computer science and information technology 10-11 grades. - M.: BINOM. Knowledge Laboratory, 2014.
Semakin I.G., Henner E.K. Computer science. Problem book-workshop for grades 8-11. (in 2 volumes). - M., 2011.
Databases: textbook / L.I. Shustova, O.V. Cockroaches. - M.: NIC INFRA-M, 2016. - 336 pp.: 60x90 1/16. - (Higher education: Bachelor's degree) (Binding 7BC) ISBN 978-5-16-010485-0, 500 copies.
Databases: Textbook / O.L. Golitsyna, N.V. Maksimov, I.I. Popov. - 2nd ed., rev. and additional - M.: Forum: INFRA-M, 2009. - 400 pp.: ill.; 60x90 1/16. - (Professional education). (hardcover) ISBN 978-5-91134-098-8, 3000 copies.

Didactic structure of the lesson	Time	Teacher activities	Student activities	Students’ tasks, the completion of which will lead to the achievement of planned results	Planned results
Didactic structure of the lesson	Time	Teacher activities	Student activities		Subject	UUD
Organizing time	10 min	Greeting, checking those present, preparing a journal, reports, introducing the goals and lesson plan, asking problematic questions.	Immersion in the topic, Setting goals for the lesson, according to the goal.	Challenge questions that students can answer: 1) What is information retrieval system? 2) What is called database? 3) What is database management system?		Regulatory: volitional self-regulation; goal setting as setting a learning task. Personal: meaning making; Communicative: planning educational cooperation with the teacher and classmates.
Updating knowledge	5 minutes	The teacher asks questions and tasks. Guides student responses	Analytical. Answer questions asked		To form a concept of a database management system as a program that allows you to process and store a large amount of information	Cognitive:
Learning new material	30 min	Controlling and guiding	Search and research.		Learn to work with theoretical material	Regulatory: predicting results. Cognitive: the ability to consciously and voluntarily construct speech statements in oral and written form.
Consolidating new material	40 min	The teacher gives assignments for practical work	Analytical.	Practical work assignments	Develop an understanding of the database and basic concepts	Cognitive: the ability to structure knowledge, the ability to transform models in order to identify general laws, constructing a logical chain of reasoning
Bottom line	5 minutes	Formulation of homework, instructions on how to complete it	Listen to the teacher and write down your homework	Repetition of basic definitions from the presentation.		Communicative: ability to listen to the teacher. Cognitive: highlighting essential information from the teacher’s words