Computer Science KN02006

Course content: data types, their entry and editing, formatting numeric data, basic operations on cells, by using simple formulas, learning simple mathematical functions and methods of addressing cells; calculation worksheets using the logic functions, calculation worksheets using the search function, calculation sheets with some financial functions, the basic techniques of data presentation graficnej, lists and operations on lists - sorting, filtering, array formulas and their application; analysis of "what-if" - data tables and scenarios, analysis of data by using the "solver" and "search result" analysis using pivot tables, designing simple forms in Excel.

Learning outcomes: The student knows the functions and capabilities of spreadsheets Student acquires the ability to present data, prepare reports in tabular and graphical form