|
Lecturer(s)
|
-
Urbánek Tomáš, Ing. Ph.D.
-
Kunčar Aleš, Ing.
|
|
Course content
|
The basic rules and principles of working with data: key concepts, design and creation of data structures, relationships, acquisition, editing and storage of data, data security, etc. Obtaining information and data analysis: calculations and functions, sorting, simple and advanced filtering, subtotals, pivot tables, etc. Evaluation and presentation of outcomes: forms, reports, charts, pivot charts, exports, etc. Effective evaluation and increasing of productivity: the choice of optimal instruments for the task, automation of evaluation, control objects, definition of terms, etc.
|
|
Learning activities and teaching methods
|
Exercises on PC, Practice exercises
- Participation in classes
- 26 hours per semester
- Preparation for course credit
- 36 hours per semester
- Home preparation for classes
- 13 hours per semester
|
| learning outcomes |
|---|
| Knowledge |
|---|
| Defines key concepts of data analysis |
| Defines key concepts of data analysis |
| Explains the concept of data processing |
| Explains the concept of data processing |
| Clarifies the difference between distinct types of database systems |
| Clarifies the difference between distinct types of database systems |
| Describes the principle of creation a relational database |
| Describes the principle of creation a relational database |
| Clarifies the difference between spreadsheets and database systems |
| Clarifies the difference between spreadsheets and database systems |
| Skills |
|---|
| Imports data from an external source |
| Imports data from an external source |
| Creates a chart in the MS Excel |
| Creates a chart in the MS Excel |
| Summarizes data using a pivot table or graph |
| Summarizes data using a pivot table or graph |
| Creates a relational database |
| Creates a relational database |
| Decides which type of query to use for data analysis |
| Decides which type of query to use for data analysis |
| teaching methods |
|---|
| Knowledge |
|---|
| Exercises on PC |
| Exercises on PC |
| Practice exercises |
| Practice exercises |
| assessment methods |
|---|
| Analysis of the student's performance |
| Grade (Using a grade system) |
| Analysis of the student's performance |
| Grade (Using a grade system) |
|
Recommended literature
|
-
Knight, Gerald. Analyzing business data with Excel [elektronický zdroj]. Sebastopol, CA : O´Reilly Media, 2006. ISBN 978-0-596-10073-5.
-
MacDonald, Matthew. Access 2007 [elektronický zdroj]. Farnham : O´Reilly,, 2007. ISBN 978-0-596-52760-0.
-
MacDonald, Matthew. Excel 2007 [elektronický zdroj] : the missing manual. Sebastopol, CA : Pogue Press/O´Reilly, 2007. ISBN 978-0-596-52759-4.
-
Remenyi, D., Onofrei, G., English, J. An introduction to statistics using Microsoft Excel. UK: Academic Publishing, 2010. ISBN 978-906638-55-9.
-
Salkind, N. J. Excel statistics: a quick guide. Los Angeles: SAGE, 2016. ISBN 978-1-4833-7404-8.
-
Triola, Mario F. Elementary statistics using Excel. 4th ed. Boston : Addision-Wesley, 2010. ISBN 978-0-321-56496-2.
|