|
Lesson plans :: Mathematics, physics, electrical engineering, computer science, information technology
Dynamic capabilities (electronic) tables
Plan for open classes
discipline:
Science and ICT
section:
Technology creation and transformation of information objects.
topic:
Dynamic capabilities (electronic) tables. Mathematical processing of numerical data.
Type of activity:
combined lesson.
Purpose:
acquaint with the appointment of a spreadsheet (ET), their basic concepts and methods of work in the simplest ET.
objectives:
didactic:
introduce the basic concepts of spreadsheets; talk about the possibilities of their application
overall control on "Text Editors"
developing:
formation of a scientific outlook of the pupils to demonstrate the possibility of using computers, in particular ET for various tasks
development of logical thinking, attention, imagination
educational:
information culture formation, needs to acquire knowledge
education skills to think logically, to allocate most importantly, a significant
Equipment lesson:
personal computers with MS Windows operating system and spreadsheet MS Excel;
presentation by the program MS PowerPoint;
job with the tests.
PROCEDURE
I.Organizatsionny time - to check if the group contribute written accessories form.
II.Proverka knowledge
survey of slide with questions and answers prepared presentation Universe
Testing on "Text Editors" (see Appendix 1)
III.Soobschenie threads purpose.
IV. Presentation of new material (see Appendix 2).
Explaining the new material is accompanied by a demonstration of Sly-rows presentation prepared by the program MS PowerPoint. Slides presented the basic concepts of the subject, as well as examples.
These topics:
1.There of Microsoft Excel
2.Zapusk program
3.Main objects ET
4.Osnovnye types of data stored in cells ET
5.Redaktirovanie data ET
6.Vydelenie multiple cells
7.Funktsii EXCEL.
8.Kopirovanie, move, delete cells in EXCEL.
9.Postroenie diagrams.
VI.Zakreplenie new material (work with summaries and multimedia-presentation diynoy)
VII.Podvedenie outcome.
VIII.Zadanie home: synopsis.
|
|
