|
Lecturer(s)
|
-
Semeniuk Martin, doc. Ing. Ph.D.
|
|
Course content
|
1. Information systems in education - an introduction to the issues 2. Users, activities, rights, data structure in information systems 3. Data and user protection, purpose of information systems 4. Formulation of requirements for data design and recording 5. Bulk data processing using Power BI tool 6. Design of tables and types of data contained in them 7. Working with database records, rules and restrictions 8. Checking the correctness and usability of the structure, set rules 9. Functions and formulas, working with strings in bulk data processing 10. Sorting, filtering, data visualization 11. Information systems in the RVP for the 2nd level of primary school 12. Examples of learning activities for teaching information systems at the 2nd level of primary school
|
|
Learning activities and teaching methods
|
E-learning, Multimedia supported teaching, Students' portfolio, Skills demonstration, Task-based study method, Seminar
- Contact hours
- 39 hours per semester
- Presentation preparation (report) (1-10)
- 5 hours per semester
- Preparation for comprehensive test (10-40)
- 10 hours per semester
- Individual project (40)
- 30 hours per semester
|
| prerequisite |
|---|
| Knowledge |
|---|
| knowledge at the level of the course Databases and Database Systems for Education from the bachelor study |
| Skills |
|---|
| skills at the level of the course Databases and Database Systems for Education from the bachelor study |
| Competences |
|---|
| N/A |
| learning outcomes |
|---|
| Knowledge |
|---|
| explain what an information system is and what it is used for |
| knows the basic rules and constraints for designing tables |
| Skills |
|---|
| formulates the problem and requirements for its solution, specifies and defines IS requirements |
| design data processing processes and roles of individual users |
| sets the display, sorting and filtering of data in the table to answer the question |
| on the basis of the recommended and own design, create a table (or linked tables) for data records and set up rules and procedures for working with records |
| Competences |
|---|
| N/A |
| teaching methods |
|---|
| Knowledge |
|---|
| Seminar |
| Multimedia supported teaching |
| Task-based study method |
| Students' portfolio |
| Skills |
|---|
| Seminar |
| Individual study |
| Skills demonstration |
| Students' portfolio |
| Task-based study method |
| Project-based instruction |
| Competences |
|---|
| Seminar |
| Self-study of literature |
| assessment methods |
|---|
| Knowledge |
|---|
| Test |
| Seminar work |
| Individual presentation at a seminar |
| Skills |
|---|
| Skills demonstration during practicum |
| Seminar work |
| Competences |
|---|
| Individual presentation at a seminar |
|
Recommended literature
|
-
Deckler, Greg. Learn Power BI : a comprehensive, step-by-step guide for beginners to learn real-world business intelligence. Birmingham. 2021.
-
Hernandez, Michael J. Návrh databází. 1. vyd. Praha : Grada, 2006. ISBN 80-247-0900-7.
-
Chmelár, Michal. Reporting v Power BI, PowerPivot a jazyk DAX. Prvé vydanie. 2018. ISBN 978-80-973078-0-6.
|