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 confirmation26.09.2017

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.

Compulsory reading

1. Dukulis I. Apgūsim jauno PowerPoint! Microsoft Office PowerPoint 2003. – R.: Turība, 2006. 144 lpp.
2. Veiss K. Darbs ar operētājsistēmu Windows Vista un pakotni Microsoft Office. – R.: 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.