|
Lecturer(s)
|
-
Lenc Ladislav, Ing. Ph.D.
-
Klečková Jana, doc. Dr. Ing.
-
Hubková Helena, Mgr.
|
|
Course content
|
Characteristics of spreadsheets. Adding data to a spreadsheet. Cell adressing. Adding the Date and a Range Name. Adding formulas. Applying styles. Changing data alignment in cells. Number formatting - percent and currency Changing font color. Graphs. Filter, database functions. Agregate. Pivot table. Cooperation with other applications.
|
|
Learning activities and teaching methods
|
Practicum
- Practical training (number of hours)
- 26 hours per semester
- Preparation for comprehensive test (10-40)
- 26 hours per semester
|
| prerequisite |
|---|
| Knowledge |
|---|
| Basic knowledge of using a computer. |
| knowledge of extracting information from electronic sources |
| basic knowledge of the user interface of MS Windows |
| Skills |
|---|
| basic skill work with computer |
| use basic safety rules with electronic resources (username, password) |
| backup files |
| Competences |
|---|
| N/A |
| learning outcomes |
|---|
| Knowledge |
|---|
| knowledge fundametals of data processing |
| knowledge basic structure of data types |
| Skills |
|---|
| the ability to implement data structures in a spreadsheet environment |
| the ability to create presentations |
| the ability of more complex data processing |
| Competences |
|---|
| N/A |
| teaching methods |
|---|
| Knowledge |
|---|
| Practicum |
| assessment methods |
|---|
| Test |
| Skills demonstration during practicum |
| Skills |
|---|
| Continuous assessment |
|
Recommended literature
|
-
Voglová, Blanka. Excel a Access : efektivní zpracování dat na počítači. Praha : Grada Publishing, 2004. ISBN 80-247-0703-9.
-
Zapawa, T. Microsoft Excel: získávání, analýza a prezentace dat. Computer Press, 2007.
|