Course code InfT1033

Credit points 2

Application Software

Total Hours in Course80

Number of hours for lectures8

Number of hours for seminars and practical classes24

Independent study hours48

Date of course confirmation16.03.2021

Responsible UnitDepartment of Computer Systems

Course developer

author lect.

Tatjana Tabunova

Mg. paed.

Course abstract

The study course deals 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

knowledge on the using methods of integrated application software packages and language Visual Basic for Applications (VBA); skills in the use of various software applications and macros; competence, of using the information technology facilities for the presentation material processing and of managing them, as well as of convincing others and proving own viewpoint working in group or independently.

Course Content(Calendar)

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

Requirements for awarding credit points

All practical works must be prepared 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 study online learning tools to strengthen knowledge.

Criteria for Evaluating Learning Outcomes

The final assessment consists of the arithmetic mean of all practical work (40%) and all tests (60%).

Compulsory reading

1. Dukulis I. Apgūsim jauno PowerPoint! Microsoft Office PowerPoint 2003. Rīga: Turība, 2006. 144 lpp.
2. Veiss K. Darbs ar operētājsistēmu Windows Vista un pakotne Microsoft Office. Rīga: Apgāds Zvaigzne ABC, 2009. 128 lpp
3. McFedries P. VBA for the 2007 Microsoft® Office System. Que Publishing, 2007. 432 p.
4. Walkenbach J. Excel 2010 Power Programming with VBA (Mr. Spreadsheet's Bookshelf). Wiley, 2010. 1080 p.

Further reading

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

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.