Course Unit Code | 205-0301/02 |
---|
Number of ECTS Credits Allocated | 3 ECTS credits |
---|
Type of Course Unit * | Optional |
---|
Level of Course Unit * | Second Cycle |
---|
Year of Study * | |
---|
Semester when the Course Unit is delivered | Winter, Summer Semester |
---|
Mode of Delivery | Face-to-face |
---|
Language of Instruction | Czech |
---|
Prerequisites and Co-Requisites | Course succeeds to compulsory courses of previous semester |
---|
Name of Lecturer(s) | Personal ID | Name |
---|
| JUR64 | Mgr. Lenka Jurčíková, Ph.D. |
Summary |
---|
The main content of this course is to work with PC skills necessary for construction practice, including the creation of algorithms and programming fundamentals.
Emphasis is placed on the basics of typography, automatic generation of text fields, edit and change the look of text books, including a large graphic elements.
In the field of Engineering explains the concept of algorithms, basic programming, use spreadsheet functions to create graphs, sorting and evaluating the collected data, programming is used to create macros in Visual Basic.
All findings are applied to the task of building practice examples of specific applications.
|
Learning Outcomes of the Course Unit |
---|
Through computer technology to solve examples from engineering practice.
Apply attained knowledge in a particular software task of building fields.
Using software to sort, categorize, compare and illustrate the data.
Meet with the concept of algorithm, a solution of the algorithm of construction practice and use it in a programming language. |
Course Contents |
---|
1st Logging into the school's internal network, write to the LMS, network drives, basic principles of networking, basic e-mail. Fundamentals of typography, editing text, including a large graphic elements.
2nd Working with text larger scale, especially for creating tables, writing and editing mathematical formulas and symbols through the Equation Editor, inserting objects, rules for the use of graphics, categorization, creation of active content, all through a text editor, the highest version.
3rd Basics spreadsheet highest version. Principles of developing active rasters using internal commands and formulas, formatting, grids, creation, editing and use of lines to practical problems.
4th Matrix in a spreadsheet - addition, matrix multiplication, inverse and transpose of a matrix, determinant calculation.
5th Creating different types of graphs for the purpose of solving practical problems and to present results of the work, solving problems of geotechnical engineering and building materials, functions and formulas spreadsheet highest version, especially statistical functions.
6th Classification and evaluation of experimental data in connection with applications for further processing.
7th Programming and algorithm - concept flow chart creation process simple algorithms, an overview of programming languages.
8th Algorithms more complex processes, conditions, loops,
9th Structures, arrays.
10th The programming language - Visual Basic, introduction, basics, types of variables, basic commands, the structure of programs.
11th Macros, simple recording, editing, programming new ones.
12th Submission and evaluation of the semester.
13th Verification of knowledge based on written tests and final evaluation. |
Recommended or Required Reading |
---|
Required Reading: |
---|
http://office.microsoft.com/en-us/office-online-help/get-started-at-office-com-HA101785172.aspx
http://mdg.vsb.cz/M/ |
Jurčíková L.: Základy práce s PC- Elektronické učební texty VŠB – TU Ostrava, Ostrava 2003. (http://fast10.vsb.cz/studijni-materialy/pocitacove-praktikum/)
Krček, B. - Kolomazník, I. : Algoritmy a datové struktury. Elektronické učební texty VŠB, Ostrava 2007. ( http://mdg.vsb.cz/M/ )
|
Recommended Reading: |
---|
http://office.microsoft.com/en-us/office-online-help/get-started-at-office-com-HA101785172.aspx
http://mdg.vsb.cz/M/ |
Jurčíková L.: Základy práce s PC- Elektronické učební texty VŠB – TU Ostrava, Ostrava 2003. (http://fast10.vsb.cz/studijni-materialy/pocitacove-praktikum/)
Krček, B. - Kolomazník, I. : Algoritmy a datové struktury. Elektronické učební texty VŠB, Ostrava 2007. ( http://mdg.vsb.cz/M/ ) |
Planned learning activities and teaching methods |
---|
Lectures, Tutorials, Project work |
Assesment methods and criteria |
---|
Task Title | Task Type | Maximum Number of Points (Act. for Subtasks) | Minimum Number of Points for Task Passing |
---|
Graded credit | Graded credit | 100 | 51 |