Course detail
Data processing and analysis
FAST-BUA009Acad. year: 2024/2025
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.
Language of instruction
Czech
Number of ECTS credits
2
Mode of study
Not applicable.
Guarantor
Department
Institute of Computer Aided Engineering and Computer Science (AIU)
Entry knowledge
Technical English basics. Working with MS Word and MS Excel. Working with Google tools (email, cloud storage, calendar).
Rules for evaluation and completion of the course
Extent and forms are specified by guarantor’s regulation updated for every academic year.
Aims
Not applicable.
Study aids
Not applicable.
Prerequisites and corequisites
Not applicable.
Basic literature
Pecinovský Rudolf, Začínáme programovat v jazyku Python, 2020, Grada (CS)
Recommended reading
Not applicable.
Classification of course in study plans
Type of course unit
Exercise
26 hod., compulsory
Teacher / Lecturer
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.