Course title | Data Computer Processing |
---|---|
Course code | USII/PZD |
Organizational form of instruction | Lecture + Tutorial |
Level of course | Bachelor |
Year of study | 1 |
Semester | Summer |
Number of ECTS credits | 3 |
Language of instruction | Czech |
Status of course | Compulsory |
Form of instruction | Face-to-face |
Work placements | This is not an internship |
Recommended optional programme components | None |
Lecturer(s) |
---|
|
Course content |
Key concepts and working with the table processor. Basic information on formulas, functions, working with names. Working with graphs. Handling text and data. Summary calculations, working with pivot tables. Information mining, databases and lists. Introduction to working with conditional functions.
|
Learning activities and teaching methods |
Monologic (reading, lecture, briefing), Dialogic (discussion, interview, brainstorming), Work with text (with textbook, with book), Methods of individual activities, Laboratory work |
Learning outcomes |
The goal is introduction to tools of MS Excel 2007 to a level that the student he was able to use effectively in practice.
Students will be introduced to main examples of all function types and will be able to decide on the suitable use of these functions in specific situations. They will be capable of working with large-scale documents, to edit data as they wish, to prepare graphs for visual presentation and to analyse data. |
Prerequisites |
Basic skills in PC and MS Excel utilization.
|
Assessment methods and criteria |
Written examination, Systematic monitoring
Assignment: - successful elaboration of given tasks (provided in Stag). - written - elaboration of practical tasks on PC. Detailed information will be provided during the first lecture and in Stag. |
Recommended literature |
|
Study plans that include the course |
Faculty | Study plan (Version) | Category of Branch/Specialization | Recommended semester | |
---|---|---|---|---|
Faculty: Faculty of Economics and Administration | Study plan (Version): Enterprise Management (2014) | Category: Economy | 1 | Recommended year of study:1, Recommended semester: Summer |
Faculty: Faculty of Economics and Administration | Study plan (Version): Enterprise Management (2014) | Category: Economy | 1 | Recommended year of study:1, Recommended semester: Summer |
Faculty: Faculty of Economics and Administration | Study plan (Version): Management of Financial Risks (2014) | Category: Economy | 1 | Recommended year of study:1, Recommended semester: Summer |
Faculty: Faculty of Economics and Administration | Study plan (Version): Security Management in Enterprises (2014) | Category: Economy | 1 | Recommended year of study:1, Recommended semester: Summer |
Faculty: Faculty of Economics and Administration | Study plan (Version): Public Economics and Administration (2014) | Category: Economy | 1 | Recommended year of study:1, Recommended semester: Summer |
Faculty: Faculty of Economics and Administration | Study plan (Version): Informatics in Public Administration (2014) | Category: Economy | 1 | Recommended year of study:1, Recommended semester: Summer |
Faculty: Faculty of Economics and Administration | Study plan (Version): Public Economics and Administration (2014) | Category: Economy | 1 | Recommended year of study:1, Recommended semester: Summer |
Faculty: Faculty of Economics and Administration | Study plan (Version): Economics and Operation in Enterprises (2014) | Category: Economy | 1 | Recommended year of study:1, Recommended semester: Summer |
Faculty: Faculty of Economics and Administration | Study plan (Version): Regional and Information Management (2014) | Category: Economy | 1 | Recommended year of study:1, Recommended semester: Summer |
Faculty: Faculty of Economics and Administration | Study plan (Version): Information and Security Systems (2014) | Category: Economy | 1 | Recommended year of study:1, Recommended semester: Summer |