Computer Science KS02006

Course content: To familiarize students: data types, methods of addressing the basic operations of cells and on cells, the calculations in spreadsheets by using formulas and logic functions and search and selected financial functions of the basic techniques of graphic presentation of data, formulas tablicowymi, data analysis of "what -if "tool support for a" solver "and" search result ", the analysis using pivot tables and simple design forms in Excel.

Learning outcomes: Ability to use Microsoft Excel spreadsheets perform calculations using their own formulas, logical functions, search, and financial exploitation of a graphical representation of data, consolidating sheets, the use of array formulas, lists, tables of data, scenarios, use Solver, pivot tables and simple forms .