Course Details
Data processing and analysis
Academic Year 2024/25
BUA009 course is part of 1 study plan
BPC-EVB Summer Semester 2nd year
Course is focused on acquiring the ability to process large non-homogeneous data files, to use the tools available for their analysis and to present the results according to typographic and graphics rules.
Credits
2 credits
Language of instruction
Czech
Semester
summer
Course Guarantor
Institute
Forms and criteria of assessment
course-unit credit
Entry Knowledge
Technical English basics. Working with MS Word and MS Excel. Working with Google tools (email, cloud storage, calendar).
Basic Literature
Pecinovský Rudolf, Začínáme programovat v jazyku Python, 2020, Grada (cs)
Offered to foreign students
Not to offer
Course on BUT site
Exercise
13 weeks, 2 hours/week, compulsory
Syllabus
- 1. Internet security, cloud technologies.
- 2. Shared documents.
- 3. Basics of working in spreadsheets.
- 4. Data verification, data import.
- 5. Graphical outputs.
- 6. Database applications in spreadsheets (sorting data, pivot tables, DB data filtering, etc.).
- 7. Analytical tools: Solver etc.
- 8. Basics of scripting and efficient data processing.
- 9. Computer typography.
- 10. Processing of technical reports: Formulas, tables, pictures, etc.
- 11. Basics of graphics: Editing images/photos, including them in a document.
- 12. Complex example.
- 13. Complex example.