¹
 Name
 page

Lectures

 Topic 1. The basic concepts of computer science.
Informatics as a unity of science and technology. The structure of modern science. The place of informatics in the sciences. Social aspects of informatics. Law aspects of informatics. Ethical aspects of informatics. Information, its types and properties. Information representation options in the Computer. The continuous and discrete information. Data media.


 Topic 2. Bases of discrete mathematics.
Relation and set functions. Bases of logic, logician of statements, logic sheaves, validity tables


 Topic 3. Main concepts of architecture of the computer.
Review and history of computers architecture. Logic elements of the computer. Submission of numerical data and notation. Sign representations and representations in an additional code


 Topic 4. The machine organization.
Von Neumann's principles, the control device, instruction sets and types of commands. Inputoutput and interruptions. Devices of storage of the computer. Memory hierarchy. The base memory and operation organization. Virtual storage. Inputoutput devices. The review of the modern hardware support


 Topic 5. Algorithmic solution of tasks, analysis of algorithmic complexity.
Strategy of the solution of tasks. Algorithms and search of decisions. Concept and properties of algorithms. Strategy of realization of algorithms. Structures of data. Block diagrams as graphic realization of algorithms. Main computing algorithms. Analysis of algorithms: standard classes of complexity, an expense on memory size and time


 Topic 6. Acquaintance to programming languages.
Review of programming languages. Main designs of programming. Variables, expressions and giving, the elementary inputoutput, operators of branching and iterative operators. Programming paradigms. Procedural programming. Objectoriented programming


 Topic 7. Bases of operating systems and networks.
Review of the modern application software. Main concepts of operating systems. History of development of operating systems. Functioning of a typical operating system. Decomposition techniques of an operating system. Control of processes. Planning and dispatching. File systems. Utilities. Drivers. Networks and telecommunications. Network safety.


 Topic 8. Graphics and Internet.
Hierarchy of the graphic software. Simple color models. Graphic systems. Systems of bitmap and vector graphics. Video information output devices. Graphic editors. Graphic communications. History and sources of Internet. Theoretical bases of the Internet. Internet services. Information security and its components. Archives. Antivirus programs.


Laboratory researches


 MS Excel. Organization workbooks. Organization of calculation


 MS Excel. Formatting. Design of tables. Use of functions


 MS Excel. Using the formulas in absolute and relative references. Linking worksheets.


 MS Excel. Graphic features


 MS Excel. AutoComplete. Auto Completion. Working with lists. Create custom lists. Using cell names in formulas.


 MS Excel. Using mathematical and statistical functions. Worksheet protection.


 MS Excel. Using a spreadsheet as a database. Using the functions of category «Date and time»


 MS Excel. Sort and list processing. AutoFilter and Advanced Filter.


 MS Excel. Organization workbooks. List processing.


 MS Excel. Calculating totals. Data consolidation.


 MS Excel. A hierarchical structure of the electronic table.


 MS Excel. Database in Excel. Processing data using forms. Data analysis


 MS Excel. Creation of schedules. Creation of function graphs with two conditions


 MS Excel. Bitbybit addition, subtraction, multiplication and division of two massifs. Decision of system of the linear equations


 MS Excel. VBA. User functions of a work sheet and procedure


 MS Excel. Automation of calculations


 Independent work of the student ¹ 1


 Independent work of the student ¹ 2


 The used literature and sources


 Glossary

