What happens in the spreadsheet as a result. Questions and tasks

What's going on in 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?

Topic and lesson number in the topic: Tabular calculations on a computer, lesson number 2

wehqiowueh2323f.doc Lesson topic: Introduction to spreadsheets. Table filling rules.

Subject: Informatics

Keywords: computer science, grade 9, spreadsheet, didactic material, handout, visualk, Microsoft Excel

Lesson type: a lesson in the formation of new knowledge

Forms of work: frontal, individual work on the computer

The purpose of the lesson: the formation of the ability to use spreadsheets for simple calculations.

Lesson objectives:

educational

Formation of ideas about ET;

Formation of the simplest skills of data entry and obtaining results using formulas in ET Microsoft Excel;

developing

Development of thinking;

Developing the ability to act independently when performing practical work;

educational

Development of cognitive interest in the subject;

Formation of aspiration to high quality of results of work.

Necessary Technical equipment: teacher's computer, interactive whiteboard, projector, students' computers.

Necessary software: Microsoft Office Power Point , Microsoft Office Excel , Flash

Handout: (or see Appendix 1)

The summary of the lesson is posted on the site "Electronic educational resources"

    Formation of new concepts and methods of action.

    More recently, no more than 30 years ago, a slide rule was used to process the results of physical and other experiments. At school, they are still learning to use the Bradis table. Then there were simple and engineering calculators. As you know, the first computing devices, incl. and computers (computers), were invented to facilitate human computing work. Gradually, these devices improved. For computers, they began to come up with programs with which you can perform calculations.

    In 1979, Daniel Bricklin and Robert Frankston created the world's first spreadsheet "VIZIKALK" (visual calculator). For the sake of this program, people bought computers. Economists wrote with delight that with the help of it you can almost instantly determine the company's profit, calculate losses, etc. Based on it, the well-known Bill Gates created the Microsoft Excel program. What opportunities does it give us?

    Consider example 1: payroll.

    Consider Example 2: Dairy Sales Accounting (p. 106) - Demo Spreadsheet

    Introduce the concept of a spreadsheet.

ET is an interactive application that stores and processes data in rectangular tables.

Compare with textbook definition p. 107

    Introduce the concepts of input data and results based on the examples discussed above.

Initial data - information that is entered in the table (independent information)

Results - data resulting from the execution of formulas (dependent information)


THE MAIN THING! When you change the source data, all results are automatically recalculated and changed right before your eyes.

(Using the example of "Accounting for the sale of dairy products" to show the change in results when the initial data changes)

    1. Microsoft Excel window view: similarities and differences with others Microsoft programs office.

    1. A cell is the intersection of a column and a row. Introduce the concepts of a cursor frame and a fill marker (demonstration on a computer using interactive whiteboard)

      ET structure (see textbook p. 107)

    1. The main types and formats of data in cells:

    NUMBER (eg, 257; -145.2; 4.890) By default, numbers are right-aligned in a cell.

### - the number did not fit in the cell.

    TEXT (N-p, 22 MB, A2+C3) By default, text is left-aligned in a cell.

    FORMULA (H-p, \u003d A2 + C3, \u003d A1 * 5)

    1. Formatting cells (demonstration by the teacher using an interactive whiteboard): 1) Select cells; 2) Format... Cells...

    Formation of skills and abilities to work on a computer.

Each student receives a set of tasks. (See Appendix - "Didactic material on ET" )

    Demonstration by the teacher of the task number 1.

    Students performing tasks No. 1,2 on computers (Handout didactic material)

    Summary of the lesson. Purpose and possibilities of the spreadsheet.

    1. What is the essential difference between a spreadsheet and a relational database table?

      What is a spreadsheet processor? (THIS)

      What is a cell? What are table cells called? What information can be stored in cells?

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

    Homework: items 18-19, prepare information about your family's electricity bill. (task number 6 p. 19)

Annex to the lesson plan

wehqiowueh2323f.doc«Introduction to spreadsheets. Table filling rules»

LIST OF EER USED IN THIS LESSON

Resource name

Type, type of resource

Information submission form(illustration, presentation, video clips, test, model, etc.)

Demo Spreadsheet "Sale Dairy Products"

informational

spreadsheet

Microsoft Excel Spreadsheet Window Interface

informational

flash animation

ET structure

informational

presentation

Didactic material on spreadsheets

The purpose and capabilities of spreadsheets

information pps

presentation

References:

Textbook Informatics and ICT Grade 9 I. G. Semakin, L. A. Zalogova, S. V. Rusakov, L. V. Shestakova

ESM: Unified Collection of Digital educational resources for institutions of general and primary vocational education. Kit digital resources to the textbook "Computer Science-Basic Course", Grade 9, Semakina I., Zalogovoy L., Rusakova S., Shestakova L. Chapter 4. Tabular calculations on a computer.

| 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 a 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 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.

 

It might be useful to read: