Course: Data Computer Processing

« Back
Course title Data Computer Processing
Course code USII/PZDE
Organizational form of instruction Lecture + Lesson
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)
  • Jonášová Hana, Ing. Ph.D.
  • Novák Martin, Ing.
  • Horák Oldřich, Mgr. Ing. Ph.D.
  • Petr Pavel, doc. Ing. Ph.D.
  • Hub Miloslav, doc. Ing. Ph.D.
  • Ibl Martin, Ing. Ph.D.
  • Kašparová Miloslava, Ing. Ph.D.
  • Panuš Jan, Ing. Ph.D.
  • Šanda Martin, Ing.
  • Čermáková Ivana, Ing.
  • Máchová Renáta, Ing. Ph.D.
  • Bílková Renáta, 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 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 2010 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). Examination: written - elaboration of practical tasks on PC. Detailed information will be provided during the first lecture and in Stag.
Recommended literature
  • Brož, M. Microsoft Excel pro manažery a ekonomy. Computer Press. ISBN 80-251-1307-8.
  • Jonášová, Hana. Zpracování dat v Excelu. Pardubice: Univerzita Pardubice, 2009. ISBN 978-80-7395-192-4.
  • Laurenčík, M. EXCEL pro management, ekonomy a podnikatele.. Computer Media, 2012. ISBN 978-80-7402-096-4.
  • Mark Dodge, Craig Stinson Douglas. Mistrovství v Microsoft Excel 2010. COMPUTER PRESS, 2011. ISBN 9788025133545.
  • Šťastný Z. Matematické a statistické výpočty v Microsoft Excelu. Praha: Computer Press, 1999. ISBN 80-7226-14149-X.


Study plans that include the course
Faculty Study plan (Version) Branch of study Category Recommended year of study Recommended semester
Faculty of Economics and Administration Informatics in Public Administration (2015) Economy 1 Summer
Faculty of Economics and Administration Management of Financial Risks (2015) Economy 1 Summer
Faculty of Economics and Administration Security Management in Enterprises (2016) Economy 1 Summer
Faculty of Economics and Administration Enterprise Management (2016) Economy 1 Summer
Faculty of Economics and Administration Enterprise Management (2015) Economy 1 Summer
Faculty of Economics and Administration Economics and Operation in Enterprises (2016) Economy 1 Summer
Faculty of Economics and Administration Economics and Operation in Enterprises (2013) Economy 1 Summer
Faculty of Economics and Administration Public Economics and Administration (2013) Economy 1 Summer
Faculty of Economics and Administration Informatics in Public Administration (2013) Economy 1 Summer
Faculty of Economics and Administration Information and Security Systems (2013) Economy 1 Summer
Faculty of Economics and Administration Security Management in Enterprises (2013) Economy 1 Summer
Faculty of Economics and Administration Enterprise Management (2016) Economy 1 Summer
Faculty of Economics and Administration Economics and Operation in Enterprises (2015) Economy 1 Summer
Faculty of Economics and Administration Regional and Information Management (2015) Economy 1 Summer
Faculty of Economics and Administration Regional and Information Management (2013) Economy 1 Summer
Faculty of Economics and Administration Management of Financial Risks (2013) Economy 1 Summer
Faculty of Economics and Administration Public Economics and Administration (2015) Economy 1 Summer
Faculty of Economics and Administration Information and Security Systems (2015) Economy 1 Summer
Faculty of Economics and Administration Public Economics and Administration (2015) Economy 1 Summer
Faculty of Economics and Administration Enterprise Management (2013) Economy 1 Summer
Faculty of Economics and Administration Enterprise Management (2015) Economy 1 Summer
Faculty of Economics and Administration Enterprise Management (2013) Economy 1 Summer
Faculty of Economics and Administration Public Economics and Administration (2013) Economy 1 Summer
Faculty of Economics and Administration Security Management in Enterprises (2015) Economy 1 Summer