LV EN RU DE FR

Application Software

Course developer

Course abstract

The aim of the study course is to deal with the use of the integrated application software packages in document, spreadsheet and presentation processing. The possibilities of software’s usage are extended by recording, testing and editing of macroses as well as by using programming in Visual Basic for Applications, different control elements, structures and dialog boxes.

Learning outcomes and their assessment

1. Knows how to use methods of integrated application software packages – 1st and 2nd test;
2. Knows the use of Visual Basic for Applications (VBA) language – 3rd test;
3. Is able to put into practice a variety of interconnected applications and use macros - practicals;
4. Is able to work in a group or work independently, use information preparation and processing tools, prepare and manage presentation materials and events, as well as persuade others and argue their opinion – home tasks.

Course Content(Calendar)

1. Usage of control buttons and hyperlinks in the presentation processing application. Creation of presentation templates. Saving the presentation in other file formats – 2h.
2. Preparing the forms in the text processing application – 1h.
3. Creation and usage of styles. Automatic numbering of images, tables and formulas. Formatting of the large-scale documents – 2h.
4. 1st test: Preparing of the large-scale documents in the text processing application – 1h.
5. Calculations and charts in the spreadsheets. Usage of different functions – 2h.
6. Usage of absolute and mixed references. Defining and usage of the cell and cell area names – 1h.
7. Pivot tables and pivot charts. Formatting of the tables – 1h.
8. 2nd test: Working with the spreadsheets – 1h.
9. Working with macros (creation, editing, and usage) in the spreadsheet, word processing and presentation processing application. Creation and usage of user functions – 1h.
10. VBA: operations with the spreadsheet objects – 2h.
11. VBA: management structures. Usage of standard and predefined dialog boxes – 1h.
12. Creation of the user dialog box in VBA. Creation of the user dialog box in the special dialog box creation page – 2h.
13. Inserting of control elements in the document and the worksheet – 1h.
14. Creation of the order and bill forms in the spreadsheet – 2h.
15. Creation of the test task in the presentation processing application. Creation of the user task by using user created VBA codes – 4h.
16. 3rd test: Usage of Visual Basic for Applications – 2h.

Requirements for awarding credit points

All practical works must be prepared and accepted.
Must have successfully passed all tests based on topics discussed in the lectures.

Description of the organization and tasks of students’ independent work

The student should study online learning tools to strengthen knowledge.

Criteria for Evaluating Learning Outcomes

The grade of the study course depends on the evaluation of the study course tests and homeworks.
The grade of the study course consists of the arithmetic mean of all practical works (40%) and all tests (60%).

Compulsory reading

1. Walkenbach J. Excel 2010 Power Programming with VBA. Wiley, 2010. 1080 p. (Mr. Spreadsheet's Bookshelf).
2. Alexander M., Kusleika D. Excel®2019 Power Programming with VBA. Wiley, 2019. 741 p.
3. Van Niekerk M. VBA Automation for Excel 2019 Cookbook. Packt, 2020. 356 p.
4. Foulkes L. Learn Microsoft Office 2019. Packt, 2020. 768 p.

Further reading

1. Shepherd R. Excel 2007 VBA Macro Programming. McGraw-Hill Osborne Media, 2009. 416 p.
2. Jelen B., Syrstad T. VBA and Macros: Microsoft Excel 2010. Que, 2010. 656 p. (MrExcel Library)

Notes

For students of ITF professional higher education bachelor study programs Information Technologies for Sustainable Development and ITF academic bachelor study programs Computer Management and Computer Science.