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

What happens in a spreadsheet when a number is replaced 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 the Private Sub Worksheet_SelectionChange (ByVal Target As Range)

Similar questions

  • Guys urgently! I beg you! 1) What is the sign in the transcription for the 1st pre-stressed syllable? 2) Which speech is called monologic and which is dialogical? 3) What are the vowel sounds? 4) What are the consonant sounds? 5) Name the always hard consonants 6) Name the 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 text? 12) What is the subject of the text? 13) What does the main idea of \u200b\u200bthe text convey? 14) When is a soft sign written? 15) In what cases is a soft sign not written? 16) In what cases are dividing b and dividing b written?
  • Help! Solve the problem, and write a short note. On the first day, 325 swallows flew south from the city, and on the second, 46 more than on the first, and on the third, 186 less than on the first and on the second together. How many swallows flew on the third day? Here's another one with a short note, and decide. 42 bags of juice and 54 bags of yoghurt were packed into boxes of 6 each. How many more boxes of yoghurt were there than of juice?

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

wehqiowueh2323f.doc Lesson topic: Introduction to spreadsheets. Rules for filling in the table.

Subject: Computer Science

Keywords: informatics, grade 9, spreadsheet, didactic material, handouts, visualization, Microsoft Excel

Lesson type: 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 the simplest calculations.

Lesson Objectives:

teaching

Formation of an understanding of ET;

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

developing

Development of thinking;

Development of the ability to act independently when performing practical work;

educational

Development of cognitive interest in the subject;

Formation of striving for high quality of labor results.

Necessary technical equipment: teacher's computer, interactive whiteboard, projector, student 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 website "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 and now they are 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 computational work. These devices were gradually 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, VISICALK (visual calculator). For 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. On the basis of it, Bill Gates, known to us, created the Microsoft Excel program. What opportunities does it provide us?

    Consider example 1: Payroll.

    Consider example 2: Accounting for the sale of dairy products (page 106) -Demonstration spreadsheet

    Introduce the concept of a spreadsheet.

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

Compare with definition in tutorial page 107

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

Initial data - information that is entered into a table (independent information)

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


THE MAIN THING! When the initial data changes, all results are automatically recalculated and changed right before our eyes.

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

    1. Microsoft Excel Window View: Similarities and Differences with Others microsoft programs Office.

    1. 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 an interactive whiteboard)

      ET structure (see tutorial page 107)

    1. Basic 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 (eg, 22 MB, A2 + C3) By default, text is aligned to the left in a cell.

    FORMULA (Nr, \u003d A2 + C3, \u003d A1 * 5)

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

    Formation of computer skills and abilities.

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

    Demonstration by the teacher of the task # 1.

    Students completing assignments on computers No. 1,2 (Handout didactic material)

    Lesson summary. Purpose and capabilities of the spreadsheet.

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

      What is a table processor? (ET)

      What is a cell? How are table cells named? 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: p. 18-19, prepare information on payment for electricity by your family. (task number 6 p. 19)

Appendix to the lesson outline

wehqiowueh2323f.doc “Introducing Spreadsheets. Rules for filling out the table "

LIST OF EOR USED IN THIS LESSON

Resource name

Type, kind of resource

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

Dairy Sales Demo Spreadsheet

informational

spreadsheet

Microsoft Excel Spreadsheet Processor Window Interface

informational

flash animation

ET structure

informational

presentation

Didactic material on spreadsheets

Purpose and capabilities of spreadsheets

informational pps

presentation

References:

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

EOR: Unified Collection of Digital educational resources for general and primary institutions vocational education... A set of digital resources for the textbook "Informatics-basic course", grade 9, Semakina I., Zalogovoy L., Rusakova S., Shestakova L. Chapter 4. Table calculations on a computer.

| Lesson Planning and Lesson Materials | 8 classes | Planning lessons for the academic year | Spreadsheets and spreadsheets

Lesson 29
Spreadsheets and spreadsheets. Spreadsheet structure
Data in a spreadsheet: numbers, texts, formulas. Rules for filling tables
Working with a finished spreadsheet: add and remove rows and columns, change formulas and copy 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 are intended for organizing tabular calculations on a computer. Spreadsheet applications are called tabular processors.

The smallest structural unit in a spreadsheet is a cell... The cell name consists of the alphabetic column name and the row number.

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

The cells into which the user enters numbers contain the initial data for the calculations. Calculation results are obtained in cells with formulas.

Changing the original data instantly recalculates formulasin which this data is included.

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

Questions and tasks

1. What is a table processor?

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

3. What is the difference between displaying formulas and displaying values?

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

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

 

It might be helpful to read: