|
Lecturer(s)
|
-
Klečková Jana, Doc. Dr. Ing.
-
Lenc Ladislav, Ing. Ph.D.
-
König Alex, Ing.
-
Káčereková Zuzana, Ing.
-
Šmíd Jakub, Ing.
-
Krutišová Jana, Ing.
-
Brůha Petr, Ing.
-
Potužák Tomáš, Ing. Ph.D.
|
|
Course content
|
1. Basic concepts of informatics. Data, information, knowledge. Introduction to data processing. 2. Import and export of data using a spreadsheet. 3. Graphs and analytical tools in a spreadsheet environment. 4. Data structures, basic concepts of algorithms and programming. 5. Technical means and software of computers. 6. Computer networks, security and data protection. Related laws.
|
|
Learning activities and teaching methods
|
Individual study, Lecture, Practicum
- Contact hours
- 39 hours per semester
- Preparation for formative assessments (2-20)
- 10 hours per semester
- Preparation for an examination (30-60)
- 30 hours per semester
|
| prerequisite |
|---|
| Knowledge |
|---|
| basic knowledge of computers principle |
| basic knowledge of the user interface of MS Windows |
| knowledge of extracting information from electronic sources |
| basic knowledge of working with a word processor |
| basic knowledge of creating a presentation in the environment of the presentation program |
| Skills |
|---|
| basic skill work with computer |
| backup files |
| use basic safety rules with electronic resources (username, password) |
| basic skills in a word processor environment |
| create a simple presentation |
| Competences |
|---|
| N/A |
| N/A |
| N/A |
| learning outcomes |
|---|
| Knowledge |
|---|
| knowledge of the principle spreadsheet |
| knowledge of the creation of the large document |
| knowledge presentation and visualization of results at the required level |
| good knowledge of fundamental terms in information technology area |
| Skills |
|---|
| calculations using formulas and functions in standard spreadsheet environment |
| create the large document |
| presentation of results in environmental presentation program |
| ability to search and processing data. |
| Competences |
|---|
| N/A |
| teaching methods |
|---|
| Knowledge |
|---|
| Lecture |
| Practicum |
| Individual study |
| Skills |
|---|
| Lecture |
| Practicum |
| Competences |
|---|
| Lecture |
| Practicum |
| assessment methods |
|---|
| Knowledge |
|---|
| Written exam |
| Test |
| Seminar work |
| Skills |
|---|
| Combined exam |
| Test |
| Seminar work |
| Competences |
|---|
| Combined exam |
|
Recommended literature
|
-
BROOKSHEAR. Informatika: Informatika nejen pro studenty informatiky. Computer Press, 2013. ISBN 978-80-2513-805-2.
-
Ignatz Schels. Excel 2007: vzorce a funkce. GRADA, 2008. ISBN 8024720744.
-
Klečková, Jana. Základy informatiky. 3. vyd. Plzeň : Západočeská univerzita, 2002. ISBN 80-7082-910-9.
-
Laurenčík, Marek. Excel 2016 a 2019 : pokročilé nástroje : funkce, databáze, kontingenční tabulky, prezentace, příklady. První vydání. 2020. ISBN 978-80-271-2471-8.
|