Course title | Word and spreadsheet processors |
---|---|
Course code | KRP/ITETP |
Organizational form of instruction | Lecture + Tutorial |
Level of course | Bachelor |
Year of study | 1 |
Semester | Summer |
Number of ECTS credits | 4 |
Language of instruction | Czech |
Status of course | Compulsory-optional |
Form of instruction | Face-to-face |
Work placements | This is not an internship |
Recommended optional programme components | None |
Lecturer(s) |
---|
|
Course content |
Word - the use and creation of styles, templates, outline. The meaning and use partitions. Indexing, content, using automated tools. Creating bookmarks, cross, hyperlinks. Mail merge. Creating and integrating of macros. Excel - database tasks with text data, creation and use of summaries, sorting, filtering. Contingency tables, merging and reports, sensitivity analysis, scenario. Solver. Creating database forms (locking cells, sheets, links between sheets, conditional formatting, data control). Calculations using Excel, evaluation of experimental data (basic statistics, nonlinear equations, solving systems of linear equations, matrices, regression analysis). Optimization calculations, linear programming. Superequations. Creation of test forms. Import and export data.
|
Learning activities and teaching methods |
Monologic (reading, lecture, briefing), Dialogic (discussion, interview, brainstorming), Work with text (with textbook, with book), Demonstration, Projection, Skills training |
Learning outcomes |
To improve the application of the text editor so that the student was able to independently generate extensive technical documents (bachelor's, master's thesis) conform to the relevant standards and contain all relevant structures. To improve the application of the spreadsheet for processing and evaluation of experimental data using various kinds of tools offered by MS Excel.
Students will obtain knowledge and skills when working with a text editor, can effectively use, especially editing (warp, bookmarks, links, ...), proofreading and automatic options making some structures (contents, index, lists of images ...) when processing complex document type theses. |
Prerequisites |
Student must have good basic knowledge about text and tabular editors gained in previous studio.
|
Assessment methods and criteria |
Oral examination, Home assignment evaluation
Participation in seminars and lectures is mandatory. Written verification of knowledge of the subject matter is a test in the 9th and 13 week of the semester. Reviews written tests must be at least 60% of the total. In the case of excused absence, the student will write alternative test. Minimum success of this test shall be 50%. In the case of non-compliance for credit must complete a written test with a minimum success rate of 50%. |
Recommended literature |
|
Study plans that include the course |
Faculty | Study plan (Version) | Category of Branch/Specialization | Recommended semester | |
---|---|---|---|---|
Faculty: Faculty of Electrical Engineering and Informatics | Study plan (Version): Communication and Microprocessor Technology (2015) | Category: Electrical engineering, telecommunication and IT | 1 | Recommended year of study:1, Recommended semester: Summer |
Faculty: Faculty of Electrical Engineering and Informatics | Study plan (Version): Information Technology (2015) | Category: Informatics courses | 1 | Recommended year of study:1, Recommended semester: Summer |
Faculty: Faculty of Electrical Engineering and Informatics | Study plan (Version): Information Technology (2013) | Category: Informatics courses | 1 | Recommended year of study:1, Recommended semester: Summer |
Faculty: Faculty of Electrical Engineering and Informatics | Study plan (Version): Process Control (2014) | Category: Special and interdisciplinary fields | 1 | Recommended year of study:1, Recommended semester: Summer |
Faculty: Faculty of Electrical Engineering and Informatics | Study plan (Version): Communication and Microprocessor Technology (2014) | Category: Electrical engineering, telecommunication and IT | 1 | Recommended year of study:1, Recommended semester: Summer |
Faculty: Faculty of Electrical Engineering and Informatics | Study plan (Version): Process Control (2013) | Category: Special and interdisciplinary fields | 1 | Recommended year of study:1, Recommended semester: Summer |
Faculty: Faculty of Electrical Engineering and Informatics | Study plan (Version): Process Control (2016) | Category: Special and interdisciplinary fields | 1 | Recommended year of study:1, Recommended semester: Summer |
Faculty: Faculty of Electrical Engineering and Informatics | Study plan (Version): Communication and Microprocessor Technology (2016) | Category: Electrical engineering, telecommunication and IT | 1 | Recommended year of study:1, Recommended semester: Summer |
Faculty: Faculty of Electrical Engineering and Informatics | Study plan (Version): Information Technology (2016) | Category: Informatics courses | 1 | Recommended year of study:1, Recommended semester: Summer |
Faculty: Faculty of Electrical Engineering and Informatics | Study plan (Version): Information Technology (2014) | Category: Informatics courses | 1 | Recommended year of study:1, Recommended semester: Summer |
Faculty: Faculty of Electrical Engineering and Informatics | Study plan (Version): Process Control (2015) | Category: Special and interdisciplinary fields | 1 | Recommended year of study:1, Recommended semester: Summer |