| Lesson planning and lesson materials | 8 classes | Lesson planning for the school year | Spreadsheet calculations and spreadsheets

Lesson 29
Tabular calculations and spreadsheets. Spreadsheet structure
Data in a spreadsheet: numbers, texts, formulas. Rules for filling tables
Working with the finished spreadsheet: adding and deleting rows and columns, changing formulas and copying them

The main topics of the paragraph:

- the structure of the spreadsheet;
- data in a spreadsheet;

What is a spreadsheet. Questions and tasks

What is a spreadsheet
Questions and tasks

Briefly about the main

Spreadsheets designed to organize tabular calculations on a computer. Application programs that work with spreadsheets are called spreadsheet processors.

The smallest structural unit of a spreadsheet is a cell. The cell name is composed of the literal column name and the row number.

The cell can contain text (character sequence), number, formula.

The cells in which the user enters numbers contain the initial data for calculations. In cells with formulas, the results of calculations are obtained.

Changing the source data instantly leads to the recalculation of formulas in which this data is included.

Spreadsheets (as well as databases) can be thought of as information models of real objects.

Questions and tasks

1. What is a spreadsheet processor?

2. What are table cells called? What information can be stored in cells?

3. What is the difference between formula display mode and value display mode?

4. What happens in a spreadsheet when a number in a cell is replaced with a new value?

5. What is the essential difference between a spreadsheet and a relational database table? Prepare a post with examples.

What happens in the spreadsheet as a result of replacing a number with a new value?

Answers:

Recalculation of the formulas associated with this cell, in addition, the Private Sub Worksheet_Calculate () event occurs in VBA, as well as Private Sub Worksheet_SelectionChange (ByVal Target As Range)

Similar questions

• Guys urgently! I beg you! 1) What sign in transcription denotes the 1st prestressed syllable? 2) What speech is called monologic, and what is dialogic? 3) What are vowel sounds? 4) What are consonant sounds? 5) Name always hard consonants 6) Name always soft consonants 7) What syllable is called open? 8) What syllable is called closed? 9) Give an example of assonance 10) Give an example of alliteration 11) What is a text? 12) What is the topic of the text? 13) What conveys the main idea of ​​the text? 14) In what cases is a soft sign written? 15) In what cases is a soft sign not written? 16) In what cases is the dividing b and dividing b written?
• Help! Solve the problem, and write down a short note. On the first day, 325 swallows flew out of the city to the south, and on the second, 46 more than on the first, and on the third, 186 less than on the first and second together. How many swallows flew out on the third day? Here's another one from a short note, and decide. 42 bags of juice and 54 bags of yogurt were put into boxes of 6 pieces each. How many more boxes of yogurt were there than boxes of juice?

Lesson 4

Subject: « Spreadsheets. Purpose and main functions . Basic Spreadsheet Options»

Lesson type: Lesson of new knowledge and skills development

The purpose of the lesson: To acquaint students with the purpose and basic functions of a spreadsheet, with the structure of ET.

Enter the concepts of row, column, cell, cell name, range of cells.

Required TSO: video projector, screen, PC,

reference notes for students.

Requirements for knowledge and skills

The student must know:

Application software for processing numerical information

Purpose and main functions of ET

ET structure

Students should be able to:

Distinguish dependent and independent fields in ET

Be able to define a range of cells

Know the names of cells, rows and columns of ET

Lesson plan:

Organizing time. 1 minute

Examination homework 5 minutes

Knowledge test 10 minutes

Explaining new material 20 minutes

Consolidation of new material. 7 minutes

Homework. 2 minutes

During the classes

Organizing time(1 min)

The teacher greets the students.

Checking homework(5 minutes)

Doing homework at the blackboard

Discuss at the board the solution of problems that caused difficulty in solving.

3 . Check of knowledge(10 minutes)

Work on performing arithmetic operations in binary SS

Students receive assignments

Presentation of new material(20 minutes)

The study of the topic is supposed to begin with a presentation, detailed description which is presented in the table below.

Theoretical material of the lesson

Appearance slide

Slide notes

Teacher:

The topic of today's lesson« Spreadsheets. Purpose and main functions. ET Structure»

The teacher asks to write down the topic of the lesson in a notebook.

Teacher:

Pay attention to the abbreviations that we will use in today's lesson.

Teacher:

IN modern world most of the tables are created in in electronic format using a PC.

There have been a number of application programs(PP), called spreadsheets (ET). The purpose of ET is to make it convenient and less time-consuming to work with large arrays of numerical information.

ET is a handy tool for engineers, scientists, economists, accountants, etc. These programs allow you to create dynamic tables, i.e. contain the so-called calculated fields, whose values ​​are automatically recalculated according to the specified formulas when the values ​​of the source data contained in other fields change.

More powerful ETs are called tabular processors (TPs).

Teacher:

The main elements of ET are: cell, row and column.

The teacher, as the topic is explained via a hyperlink, goes to the slides that reflect information about each element separately, and then each time returns to the slide "The main elements of ET"

Teacher:

The main element of ET is a cell.

The intersection of rows and columns forms cells called table cells. It is used to identify a cell. address A consisting of a column name and a row number. For example: the very first cell has address A 1; examples of other cell addresses B 3, DL 25, etc.

The cell in which the cursor is located and which is highlighted by the frame is called active cell . Data is entered into the active cell via the keyboard.

Teacher:

The ET working field is divided by lines horizontally into lines (rows are denoted by the numbers 1, 2, 3, ..., 65356).

Teacher:

The ET working field is divided vertically by lines into columns (columns are denoted by Latin lettersA , B , C , …, AB , …< IV , there are 256 in total),

Teacher:

As a holistic object can be used and cell range , which is denoted by the top left cell name and the bottom right cell name, separated by a colon(e.g. A 1:B 5).

Teacher:

So, let's imagine that you and I are the owners of a small shop that sells dairy products. You have to keep a variety of forms of accounting for goods.

Let's imagine one of the accounting documents, which should look like this (look at the reference note, and then at the screen). This is a regular rectangular table.

But pay attention to the peculiarity of this table. It has fields whose value is calculated through the values ​​of other fields. Such fields are the fields "Revenue", "Remaining". Such fields will be called calculated or dependent. The fields "Product", "Price", "Supplied", "Sold" are independent. The independent fields contain the initial data for the calculation.

Teacher:

The main information objects processed by ET are the following types of data:

Number;

Text:

Formula.

Number

Entered numbers can be integer and real, in real numbers the integer part from the fractional part is separated by a comma.

Before entering numbers, you need to set the format of the entered numbers, for this you need to:

Select a range of cells;

Choose FORMAT/CELLS;

In the window that appears, set the required parameters.

For number formats, you can also set the number of decimal places, you can select currency and financial formats, etc.

To properly manipulate data, you must always set the cell format before entering numbers.

Text

Text - a set of symbols used to design the table (headings, explanations, etc.)

Formula

Formula is an expression that specifies a hint for mathematical calculations. An expression begins with an equal sign (=), which allows the program to distinguish the formula from other data.

Teacher:

Among the users of IBM-compatible computers, the most famous are ET Microsoft Excel, Lotus 1-2-3, as well as tables from the integrated package MS Works.

ET serves for:

Processing of numerical information presented in the form of a table.

Saving tables on disk.

To print a document.

ET features:

Entering and editing data.

Formula calculations.

Table formatting.

Construction of graphs and diagrams.

Sorting data.

Working like a database.

Preview document before printing.

Printout, etc.

Consolidation of the studied material(7 minutes)

Frontal survey

1. What are ETs used for?

   What is the essential difference between ET and relational databases?

   What is a spreadsheet processor?

   Which fields in ET are called dependent and which are independent?

   What is the main element of ET?

   How is the cell address determined?

   What information can be stored in cells?

   What happens in ET as a result of replacing a number in a cell with a new value?

Homework(2 minutes)

Learn all the basic concepts that you learned in the lesson.

N. D. Ugrinovich, Informatics and ICT Grade 9, p. 3.2.1, 3.2.2

Answer the questions at the end of paragraph p. 86, p. 89.

Tasks for self-fulfillment p. 86 No. 3.8 p. 89 No. 3.9