Course: Text Editors and Spreadsheet Processors

« Back
Course title Text Editors and Spreadsheet Processors
Course code KID/PXTEK
Organizational form of instruction Lecture
Level of course Bachelor
Year of study not specified
Semester Winter
Number of ECTS credits 4
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)
  • Greiner Karel, doc. Ing. Ph.D.
  • Drvota Zdeněk, Ing.
Course content
Using editor Word. Basic typography and formatting documents. Styles and templates. Margins and page setup, sections. Tables. Using fields. Working with graphics and charts. Cross-references, captions, and bookmarks. Tables of contents, index, and tables of figures. Equation editor. Mail merge. Sharing information with other people. Using forms, form fields, document protection. Using spreadsheet Excel. Cells, formulas, functions. Working with workbook and worksheet. Circular reference. Validating cell entries. Charts and graphics. Using lists, filtering and sorting data. PivotTable and PivotChart reports. Analyzing data. Solver, what-if analysis, scenarios, statistical analysis tools. Forms, workbook and worksheet protection, data sharing. Macros.

Learning activities and teaching methods
Monologic (reading, lecture, briefing), Demonstration, Projection, Skills training
Learning outcomes
The main goal of the discipline is to familiarise students with the advanced methods of creating documents with text editor Microsoft Word, and working and analyzing data with spreadsheet Microsoft Excel.
After finishing this course student knows most of features of text editor Microsoft Word and spreadsheet Microsoft Excel.
Prerequisites
Assumed a basic knowledge of Microsoft Windows and Microsoft Word and Excel.

Assessment methods and criteria
Written examination

Given assignment confirms that a student has attended lessons to the extent required and fulfilled qualified requirements. Conditions for credit are: active work at exercises, 2 practical tests with PC - student passes if he/she obtains 50 % points of 100 % possible in each test. Form, contents and length of the exam are determined in accordance with Study and Examining Rules of University of Pardubice. The exam consists of a practical test with PC. Student passes successfully if he/she obtains at minimum 50 % of possible points.
Recommended literature
  • Barilla, J., Simr, P., Sýkorová, K. Excel 2013. Podrobná uživatelská příručka. Brno, 2013. ISBN 978-80-251-4114-4.
  • Pecinovský, J. Word 2013. Podrobná uživatelská příručka. Brno, 2013. ISBN 978-80-251-3831-1.


Study plans that include the course
Faculty Study plan (Version) Branch of study Category Recommended year of study Recommended semester
Faculty of Transport Engineering Electrical Engineering and Electronic Systems in Transport (2013) Transportation and communications 2 Winter
Faculty of Transport Engineering Applied Informatics in Transport (2013) Informatics courses 2 Winter
Faculty of Transport Engineering Applied Informatics in Transport (2014) Informatics courses 2 Winter
Faculty of Transport Engineering Electrical Engineering and Electronic Systems in Transport (2014) Transportation and communications 2 Winter