Contents
- About the course
- Module 1 Basic concepts and definitions, general information about information and information processes. Fixed assets of office software for creating electronic documents in various formats and working with text, tabular and graphic information. Document protection tools in office applications
- Topic 1 Introduction. The concept of information and information processes. Tools for processing and storing electronic information.
- Lecture
- 1.1 Introduction
- 1.2 The concept of information and information process
- 1.3 Encoding of text information
- 1.4 Encoding of numerical information
- 1.5 Measuring the amount of information
- 1.6 Data representation models
- 1.7 The concept of an information system
- 1.8 Classification of software
- 1.9 Classification of programming languages
- 1.1 Introduction
- Practical assignment 1
- Test to the topic 1
- Lecture
- Topic 2 MS Word tools for creating, editing, and formatting documents; MS Word tools for working with large text documents; Word document protection tools.
- Topic 3 Calculations in spreadsheets, solving mathematical problems using Excel, presenting data in graphical form.
- Topic 4 Working with complex conditional statements. Ways to organize and filter data. Functions necessary for working with databases and lists.
- Topic 5 Creating interactive tables for data search. Pivot tables for analysis. Data consolidation and protection.
- Topic 1 Introduction. The concept of information and information processes. Tools for processing and storing electronic information.
- Module 2 Office programming. VBA programming in office applications. Working with MathCad.
- Topic 6 Operators and software tools in the VBA language.
- Topic 7 Creating macros in office applications.
- Topic 8 Working with MathCad.
- Lecture
- 8.1 Mathcad
- 8.2 Mathcad interface
- 8.3 Working with the matrices
- 8.4 Defining functions in Mathcad
- 8.5 Plotting functions
- 8.6 Plotting surfaces
- 8.7 Solving systems of linear equations
- 8.8 Solving systems of nonlinear equations
- 8.9 Solving a nonlinear equation
- 8.10 Symbolic calculation
- 8.11 Calculating sums, products of series, limits, integrals, derivatives
- 8.12 Solving differential equations
- 8.1 Mathcad
- Practical assignment 15
- Practical assignment 16
- Test to the topic 8
- Lecture
- Individual Assignments
- Final Quizz