Informatics in school №03’2013
Journal «Informatics in school» №3’2013
№ 3 (86) April 2013
Contents of issue
Dolgikh E. A.
ROLE-PLAYING GAMES AND SOCIAL ENGINEERING AS THE EXAMPLES OF THE STUDENTS’ RESEARCH ACTIVITIES
The ar ticle analyzes issues of mainstreaming research activities of students through the use of the project method, role-playing games and social engineering. The examples of the of research activities, including the scenario of the role-playing game, which widely uses interdisciplinary connections of informatics, economics, mathematics and literature, are considered in the article.
Keywords: research activities, project method, role-playing game, social engineering, extracurricular activities, interdisciplinary connections.
LESSONS OF COMPUTER SCIENCE
Sizykh E. A.
CREATING A PACKAGE OF DOCUMENTS FOR THE FIRM AS A FORM OF REPETITION THE THEME “INFORMATION TECHNOLOGIES”
The article describes a block of lessons, in which in the form of project activities the theoretical knowledge and practical skills on the theme “Information technology” are repeated and reinforced.
Keywords: project activities, inter-disciplinary connections, information technologies, text editor, image editor, spreadsheets, databases, Internet, company, document.
Batina E. A., Davletbaeva I. Kh.
THE LESSONS ON THE THEME “PROCESSING NUMERICAL INFORMATION”
The article presents four lessons, which are final in studying the theme “Processing numerical information” in the ninth grade: “Using functions in the solution of applied problems in spreadsheets”, “Diagrams in spreadsheets”, lesson-game “Generalization and preparation for the theoretical test”, integrated lesson with the elements of project activities “Computers and professions”.
Keywords: informatics, English, lesson-game, team work, group work, project activities, spreadsheets, MS Excel, functions, diagrams, applied problems, professional self-determination of students.
Pavlova I. B.
PRACTICAL WORK ON THE USING FORMULAS IN SPREADSHEETS
The article presents the informatics lesson on theme “Spreadsheets”, in which students get skills working with formulas in spreadsheets.
Keywords: spreadsheet, practical work, formula manipulation.
Moiseeva N. N.
THEME “DATA BASE MANAGEMENT SYSTEMS” IN INFORMATICS COURSE
The article describes a block of lessons in which on the example of creating the school database and working with it the basic concepts and functions of relational database management is sequentially considered. The basic techniques for creating, modifying, sorting and retrieval of information is considered on the example of MS Access.
Keywords: database, field, record, structure, table, searching, sorting, form, MS Access.
Poryvaeva N. S.
LESSONS ON SOLVING ECONOMIC OPTIMIZATION PROBLEMS BY VARIOUS TOOLS
The ar ticle descr ibes a block of four lessons, each of which considers a certain way of solving economic problems of optimization: using Solver of MS Excel; brute-force attack using a lookup table; using the programming language Visual Basic; using the system Mathcad.
Keywords: interdisciplinary connections, research activities, optimization problem, transportation problem, MS Excel, Solver, brute-force attack, Visual Basic, Mathcad.
METHODICAL PIG BANK
Pshukova M. M.
ORGANIZATION OF PRACTICAL WORK WITH MICROSOFT ACCESS IN PROFILE CLASSES
The article describes the study of MS Access database in the profile course of informatics. The experience in the organization of practical training with databases in the classes of information-technological and socio-economic profiles are considered.
Keywords: profile training, database, database management system (DBMS), MS Access, practical work, information objects, data model, relation.
OLYMPIAD IN INFORMATICS
Belyaev S. N., Laletin N. V.
TASKS OF THE MUNICIPAL STAGE OF RUSSIAN OLYMPIAD IN INFORMATICS AND ICT IN KRASNOYARSK REGION
The article presents tasks (with solutions) provided on the municipal stage of Russian Olympiad in Informatics and ICT in Krasnoyarsk Region.
Keywords: informatics, Olympiads in Informatics, Russian Olympiads in Informatics and ICT (RusOI), task, programming.