Course detail

Computer Technology II

FAST-UD2Acad. year: 2021/2022

Primary spreadsheet commands (cells organization, enter data in worksheet, block access)
Formatting cells
Calculations on a worksheets (formulas generation, predefined formulas)
Elementary technical applications of spreadsheets
Charts - generation, application and modification
Database application in spreadsheets
Some of data analysis implements

Language of instruction

Czech

Number of ECTS credits

3

Guarantor

RNDr. Helena Novotná

Department

Institute of Computer Aided Engineering and Computer Science (AIU)

Learning outcomes of the course unit

Not applicable.

Prerequisites

Basic knowledge and using of operation system, especially filesystem

Co-requisites

Not applicable.

Planned learning activities and teaching methods

Not applicable.

Assesment methods and criteria linked to learning outcomes

Not applicable.

Course curriculum

1.-2. Basic spreadsheet control: insert and edit, data types of cell values, cell manipulation, windows, worksheets.
3.-4. Cells formating, elementary formulas, relative and absolut addresses.
5.-6. Advanced formulas, functions.
7.-8. Charts, individual project setting.
9. Mattrix operations, solver, data import.
10. Data manipulation, contingent tables.
11. Design of macros, complex example include printer output.
12. Individual project consultation.
13. Test and exam.

Work placements

Not applicable.

Aims

Features and using of spreadsheets in engeneering practices

Specification of controlled education, way of implementation and compensation for absences

Extent and forms are specified by guarantor’s regulation updated for every academic year.

Recommended optional programme components

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

William J. Orvis: Excel pro vědce a inženýry. Computer Press 1996

Recommended reading

Josef Pecinovský: Excel v příkladech. Grada 2001

Type of course unit

 

Exercise

26 hours, compulsory

Teacher / Lecturer

RNDr. Helena Novotná