Course Details
Information Technology
Academic Year 2023/24
MU002 course is part of 1 study plan
B-P-C-MI (N) / MI Summer Semester 1st year
Basic procedures for large data sets processing with using of automated functions, macros and scripting tools in MS Excel. Application of these tools to solve simple problems from the general topics of civil engineering. Course is the extension of the basic course Informatics.
Course Guarantor
Institute
Objective
To get general orientation in information technologies and possibilities of their use at firm’s management. To learn basic tools of system analysis. To acquire skills and ability to model reality during formation of information system.
Knowledge
The ability of automatic data processing, applying makeup and scripting engineering calculations in MS Excel.
Syllabus
1. The environment for developing VBA applications - more than the editor.
2. Basic data types. How to work with them. Variable vs. Excel cell.
3. How affect the processing of orders. Solution conditions and repeated execution of orders.
4. Since scalar variables to fields. Indices, vectors, matrices.
5. What is a macro? Generator of macros in MS Office.
6. Build custom formulas or custom functions.
7. Visual design of the user interface.
8. Proposal forms and event handling.
9. Why were created classes and objects. Definition of simple classes and objects in VBA.
10. How to work with MS Office documents.
11. What is the object model.
12. Example solving optimization problems.
13. Example solving mechanical problems.
2. Basic data types. How to work with them. Variable vs. Excel cell.
3. How affect the processing of orders. Solution conditions and repeated execution of orders.
4. Since scalar variables to fields. Indices, vectors, matrices.
5. What is a macro? Generator of macros in MS Office.
6. Build custom formulas or custom functions.
7. Visual design of the user interface.
8. Proposal forms and event handling.
9. Why were created classes and objects. Definition of simple classes and objects in VBA.
10. How to work with MS Office documents.
11. What is the object model.
12. Example solving optimization problems.
13. Example solving mechanical problems.
Prerequisites
Basic knowledge of MS Excel, English pre-intermediate.
Language of instruction
Czech
Credits
4 credits
Semester
summer
Forms and criteria of assessment
course-unit credit and examination
Specification of controlled instruction, the form of instruction, and the form of compensation of the absences
Extent and forms are specified by guarantor’s regulation updated for every academic year.
Offered to foreign students
Not to offer
Course on BUT site
Lecture
13 weeks, 2 hours/week, elective
Syllabus
1. The environment for developing VBA applications - more than the editor.
2. Basic data types. How to work with them. Variable vs. Excel cell.
3. How affect the processing of orders. Solution conditions and repeated execution of orders.
4. Since scalar variables to fields. Indices, vectors, matrices.
5. What is a macro? Generator of macros in MS Office.
6. Build custom formulas or custom functions.
7. Visual design of the user interface.
8. Proposal forms and event handling.
9. Why were created classes and objects. Definition of simple classes and objects in VBA.
10. How to work with MS Office documents.
11. What is the object model.
12. Example solving optimization problems.
13. Example solving mechanical problems.
Exercise
13 weeks, 2 hours/week, compulsory
Syllabus
1. We use a macro to simplify the work in a spreadsheet
2. Variable vs. constant, assign values to memory.
3. Methods vs. attributes. We learn first automatic steps.
4. Retrieving values from a table and writes the results table.
5. Checking our running macros using conditions.
6. Unlocking our computer through the cycle.
7. Cycles continued.
8. Debugging of our macros.
9. Scripting the numerical series and its suma.
10. Scripting text based data processing and analysis.
11. Scripting numerical solutions of equations.
12. Scripting statistical and optimization tasks.
13. Scripting solution of mechanical tasks.