University of West Bohemia
Study programmes & Course catalogue
for academic year 2024/2025
University of West Bohemia
Česky
Search
FAQ

Course: Data Processing

« Back
Course title Data Processing
Course code KVD/ZPD
Organizational form of instruction Not exists + Seminar
Level of course Bachelor
Year of study 1
Semester Winter and summer
Number of ECTS credits 3
Language of instruction Czech
Status of course Compulsory, Compulsory-optional
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
Lecturer(s)
  • Benediktová Lenka, Mgr. Ph.D.
  • Mainz Denis, PhDr. Ph.D.
  • Filipi Zbyněk, PhDr. Ph.D.
  • Baťko Jan, Mgr. Ph.D.
  • Grolmus Petr, Ing.
Course content
- File formats of spreadsheet data, import and export of spreadsheet data. - Forms and their creation with a direct link to spreadsheets and calculators. - Options and ways of displaying, formatting, and conditional formatting of spreadsheet data. - Sort, filter and summaries of table data. - Addressing, counting operations, formulas, mathematical functions, generating values. - Functions for text value operations in tables. - Search function of table data. - Graphic presentations, type of graphs and charts, and policies for their use. - Pivot tables and pivot charts. - Principles of using spreadsheets and calculators modules and add-ons. - Table data analysis, analysis tools of spreadsheet. - Statistical processing of spreadsheet data. - Principles of use and creation of macros, programmable modules of spreadsheet and calculators.

Learning activities and teaching methods
Lecture with practical applications, E-learning, Skills demonstration, Seminar classes, Individual study, Lecture with visual aids
  • Contact hours - 26 hours per semester
  • Practical training (number of hours) - 26 hours per semester
  • Preparation for formative assessments (2-20) - 10 hours per semester
  • Preparation for comprehensive test (10-40) - 20 hours per semester
prerequisite
Knowledge
explain basic concepts related to the creation of tables on the computer.
Skills
create and manipulate folders and files.
perform basic editing a spreadsheet.
Competences
N/A
learning outcomes
Knowledge
explain the principles used in acquiring, viewing, organizing, formatting, analysis, representation and storing tabular data in one of several commercial and freely available software tools.
Skills
to process the data efficiently using software tools known as spreadsheets.
check processing principles tabular data on practical examples, thanks to which you will learn workflows leading to effective use of this type of software in the study of the teaching field or a combination of sectoral and subsequently in teaching practice.
use supported modules and functions chosen spreadsheet program for data processing for finding optimal solutions to specific problems arising from the discussed topic.
Competences
N/A
N/A
N/A
teaching methods
Knowledge
Lecture with visual aids
E-learning
Skills demonstration
Individual study
Interactive lecture
Seminar classes
Skills
Interactive lecture
Seminar classes
Individual study
Skills demonstration
E-learning
Lecture with visual aids
Competences
Lecture with visual aids
Skills demonstration
E-learning
Individual study
Interactive lecture
Seminar classes
assessment methods
Knowledge
Test
Skills demonstration during practicum
Continuous assessment
Skills
Continuous assessment
Skills demonstration during practicum
Test
Competences
Skills demonstration during practicum
Test
Continuous assessment
Recommended literature
  • Calc Guide: Working with Spreadsheets.
  • Bártek, Květoslav; Kubrický, Jan. Pokročilé použití MS Excel při tvorbě elektronických výukových materiálů. 1. vydání. 2015. ISBN 978-80-244-4559-5.
  • Cuesta, Hector. Analýza dat v praxi. 1. vydání. 2015. ISBN 978-80-251-4361-2.
  • Holzner, S. a N. Holzner. Google Docs 4 everyone. Indianapolis, 2009. ISBN 07-897-3936-4.
  • Laurenčík, Marek. Excel - pokročilé nástroje : funkce, marka, databáze, kontingenční tabulky, prezentace, příklady. První vydání. 2016. ISBN 978-80-247-5570-0.
  • Navrátil, P. a M. Jiříček. OpenOffice.org Calc. Kralice na Hané: Computer Media, 2007. ISBN 978-80-86686-74-5.
  • OČENÁŠEK, Vladimír et al. Řešené příklady pro MS Excel 2013: podle konceptu European Computer Driving Licence - Advanced (profesionální uživatelské znalosti a dovednosti). Praha, 2015. ISBN 978-80-87994-55-9.
  • Pecinovský, J. 333 tipů a triků pro Microsoft Excel 2013: [sbírka nejužitečnějších postupů a řešení]. Brno: Computer pess, 2014. ISBN 978-80-251-4130-4.
  • Pírková, Kateřina. Microsoft Office Word 2007 : podrobná uživatelská příručka. Vyd. 1. Brno : Computer Press, 2007. ISBN 978-80-251-1571-8.


Study plans that include the course
Faculty Study plan (Version) Category of Branch/Specialization Recommended year of study Recommended semester
Faculty: Faculty of Education Study plan (Version): Information Technologies in Education (18) Category: Informatics courses 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Information Technologies in Education (19) Category: Informatics courses 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Studies in Mathematics (19) Category: Mathematics courses 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Studies in Mathematics (18) Category: Mathematics courses 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Technology and Design in Education (19) Category: Pedagogy, teacher training and social care 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): English Language in Education (19) Category: Pedagogy, teacher training and social care 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): English Language in Education (18) Category: Pedagogy, teacher training and social care 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Geography in Education (16) Category: Pedagogy, teacher training and social care 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Biology in Education (15) Category: Biology courses 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Information Technologies in Education (16) Category: Informatics courses 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Biology in Education (19) Category: Biology courses 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Geography in Education (19) Category: Pedagogy, teacher training and social care 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Russian Language in Education (19) Category: Pedagogy, teacher training and social care 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Chemistry in Education (17) Category: Chemistry courses 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Technology and Design in Education (17) Category: Pedagogy, teacher training and social care 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Physics in Education (19) Category: Physics courses 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Geography in Education (18) Category: Pedagogy, teacher training and social care 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Russian Language in Education (17) Category: Pedagogy, teacher training and social care 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): History in Education (17) Category: History courses 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Information Technologies in Education (19) Category: Informatics courses 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Information Technologies in Education (18) Category: Informatics courses 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Chemistry in Education (19) Category: Chemistry courses 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Technology and Design in Education (16) Category: Pedagogy, teacher training and social care 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Physical Education in Education (16) Category: Physical education and sport 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Information Technologies in Education (17) Category: Informatics courses 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Biology in Education (18) Category: Biology courses 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Technology and Design in Education (18) Category: Pedagogy, teacher training and social care 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Russian Language in Education (18) Category: Pedagogy, teacher training and social care 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): History in Education (18) Category: History courses 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Physical Education in Education (17) Category: Physical education and sport 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Chemistry in Education (16) Category: Chemistry courses 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Biology in Education (16) Category: Biology courses 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Geography in Education (1) Category: Pedagogy, teacher training and social care 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Information Technologies in Education (17) Category: Informatics courses 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Information Technologies in Education (16) Category: Informatics courses 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Chemistry in Education (18) Category: Chemistry courses 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Physical Education in Education (18) Category: Physical education and sport 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Geography in Education (17) Category: Pedagogy, teacher training and social care 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Information Technologies in Education (15) Category: Informatics courses 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Biology in Education (17) Category: Biology courses 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): English Language in Education (17) Category: Pedagogy, teacher training and social care 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Geography in Education (15) Category: Pedagogy, teacher training and social care 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Physics in Education (15) Category: Physics courses 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Studies in Mathematics (17) Category: Mathematics courses 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Physics in Education (17) Category: Physics courses 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Physics in Education (16) Category: Physics courses 1 Recommended year of study:1, Recommended semester: Winter
University of West Bohemia, date of update: 05.10.2024 23:52. Data created for academic year 2024/2025