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)
Microsoft Excel window view: similarities and differences with others Microsoft programs office.
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)
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)
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.
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:
- Radiation: impact on humans and its consequences;
- Arts and Crafts Download Presentation on Arts and Crafts;
- Presentation on the topic "Addition and subtraction of polynomials" Addition and subtraction of polynomials presentation;
- Radiation: impact on humans and its consequences;
- Open lesson "capacitors" Energy of a charged capacitor application of capacitors presentation;
- Presentation on the topic "Nikolai Nosov "Live Hat"";
- Presentation "globe" presentation for a lesson on the world around on the topic;
- Presentation on the topic: "A walk in kindergarten;