University of Pardubice
Study programmes & Course catalogue
University of Pardubice
Česky
Search
FAQ

Course: Data Computer Processing

« Back
Course title Data Computer Processing
Course code USII/KZDE
Organizational form of instruction Lecture
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)
  • Petr Pavel, doc. Ing. Ph.D.
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 the contingency chart. Information mining, databases and lists. Introduction to working with conditional functions. Using Excel in decision support.

Learning activities and teaching methods
Monologic (reading, lecture, briefing), Dialogic (discussion, interview, brainstorming), Work with text (with textbook, with book), Methods of individual activities
Learning outcomes
The course focuses on consolidation of knowledge from previous types of study in working with MS Excel application and with its collaboration with other applications. Attention will be paid to basic data processing principles using standard functions.
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
unspecified

Assessment methods and criteria
Written examination, Home assignment evaluation

Assignment: successful elaboration of given tasks (provided in Moodle). Examination: written - elaboration of practical tasks on PC. Detailed information will be provided during the first lecture and in Moodle.
Recommended literature
  • Brož, M. Microsoft Excel pro manažery a ekonomy. Computer Press. ISBN 80-251-1307-8.
  • Brož, M. Microsoft Office Excel 2007, Podrobná uživatelská příručka, Computer Press, 408 stran.. Computer Press, 2007. ISBN 9788025118221.
  • Jonášová, Hana. Zpracování dat v Excelu. Pardubice: Univerzita Pardubice, 2009. ISBN 978-80-7395-192-4.
  • Laurenčík, M., Jurák, Z. EXCEL pro management, ekonomy a podnikatele. Computer Media. ISBN 80-86686-64-7.
  • Šťastný Z. Matematické a statistické výpočty v Microsoft Excelu. Praha, 1999. ISBN 80-7226-14149-X.


Study plans that include the course
Faculty Study plan (Version) Category of Branch/Specialization Recommended year of study Recommended semester
Faculty: Faculty of Economics and Administration Study plan (Version): Enterprise Management (2015) Category: Economy 1 Recommended year of study:1, Recommended semester: Summer
Faculty: Faculty of Economics and Administration Study plan (Version): Public Economics and Administration (2015) Category: Economy 1 Recommended year of study:1, Recommended semester: Summer
Faculty: Faculty of Economics and Administration Study plan (Version): Regional and Information Management (2015) Category: Economy 1 Recommended year of study:1, Recommended semester: Summer
Faculty: Faculty of Economics and Administration Study plan (Version): Enterprise Management (2013) Category: Economy 1 Recommended year of study:1, Recommended semester: Summer
Faculty: Faculty of Economics and Administration Study plan (Version): Public Economics and Administration (2015) Category: Economy 1 Recommended year of study:1, Recommended semester: Summer
Faculty: Faculty of Economics and Administration Study plan (Version): Information and Security Systems (2013) Category: Economy 1 Recommended year of study:1, Recommended semester: Summer
Faculty: Faculty of Economics and Administration Study plan (Version): Security Management in Enterprises (2016) 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): Informatics in Public Administration (2015) 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 (2013) Category: Economy 1 Recommended year of study:1, Recommended semester: Summer
Faculty: Faculty of Economics and Administration Study plan (Version): Security Management in Enterprises (2013) Category: Economy 1 Recommended year of study:1, Recommended semester: Summer
Faculty: Faculty of Economics and Administration Study plan (Version): Regional and Information Management (2013) Category: Economy 1 Recommended year of study:1, Recommended semester: Summer
Faculty: Faculty of Economics and Administration Study plan (Version): Information and Security Systems (2015) Category: Economy 1 Recommended year of study:1, Recommended semester: Summer
Faculty: Faculty of Economics and Administration Study plan (Version): Enterprise Management (2013) Category: Economy 1 Recommended year of study:1, Recommended semester: Summer
Faculty: Faculty of Economics and Administration Study plan (Version): Enterprise Management (2015) Category: Economy 1 Recommended year of study:1, Recommended semester: Summer
Faculty: Faculty of Economics and Administration Study plan (Version): Enterprise Management (2016) 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 (2016) Category: Economy 1 Recommended year of study:1, Recommended semester: Summer
Faculty: Faculty of Economics and Administration Study plan (Version): Informatics in Public Administration (2013) Category: Economy 1 Recommended year of study:1, Recommended semester: Summer
Faculty: Faculty of Economics and Administration Study plan (Version): Enterprise Management (2016) Category: Economy 1 Recommended year of study:1, Recommended semester: Summer
Faculty: Faculty of Economics and Administration Study plan (Version): Security Management in Enterprises (2015) Category: Economy 1 Recommended year of study:1, Recommended semester: Summer
Faculty: Faculty of Economics and Administration Study plan (Version): Public Economics and Administration (2013) Category: Economy 1 Recommended year of study:1, Recommended semester: Summer
University of Pardubice, date of update: 27.05.2024 23:50.