| ¹
| 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. Input-output and interruptions. Devices of storage of the computer. Memory hierarchy. The base memory and operation organization. Virtual storage. Input-output 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 input-output, operators of branching and iterative operators. Programming paradigms. Procedural programming. Object-oriented 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. Anti-virus 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. Bit-by-bit 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
|
|
