Week - 1 |
Introduction to spreadsheets; Workbook, worksheet, cell, cell addressing system. |
Week - 2 |
Data entry in the spreadsheet; Data types, manual data entry, data binding from multiple workbooks, import data from the external environment, export data to the external environment. |
Week - 3 |
Graphics in spreadsheets; Adding and editing graphics. |
Week - 4 |
Graphics in spreadsheets; Adding and editing graphics. |
Week - 5 |
Introduction to programming in spreadsheets; Variable and data types, procedure types, user-defined functions, forms and other control objects. |
Week - 6 |
Application examples of calculations with the user-defined function. |
Week - 7 |
Application examples of graphics with the user-defined function. |
Week - 8 |
Introduction to databases; Tables, data types, manual data entry, import data from the external environment, export data to the external environment. |
Week - 9 |
Create a new database and table in the database. |
Week - 10 |
Create and execute queries in databases. |
Week - 11 |
Creating interfaces in the database; Design and use of forms. |
Week - 12 |
Reporting in the database; Design and use of reports. |
Week - 13 |
Application examples of databases. |
Week - 14 |
Application examples of databases. |