LV EN RU DE FR

Informatics II

Course developer

Prior knowledge

DatZ2044, Informatics I

Replaced course

DatZ2045 [GDAT2039] Informatics II

Course abstract

The purpose of the study course is to learn in depth the creation of large-volume documents using a word processing program; recor, editing and programming macros using Visual Basic for Applications. The acquired knowledge and skills are necessary in the development and design of study works, as well as in the performance of professional activities.

Learning outcomes and their assessment

Knowledge of using word processing programs and extending the usability of application software packages using Visual Basic for Applications. Knowledge is assessed in Test 3.
Skills to analyze and evaluate the information relevant to the problem to be solved and to process data using appropriate software. Skills are assessed in practical works and tests 1 and 2.

Competences to independently acquire, select and analyze information and, using information technology, to make decisions and solve problems in the field of one's professional activity. Competences are assessed in tests 1 and 2.

Course Content(Calendar)

1. Formula and form creation, document design (Lecture - 1 h, practical work - 1 h).
2. Use, modification and definition of styles in designing large documents (Lecture - 1 h, practical works - 2 h).
3. Insert bookmarks. Automatic numbering of figures and tables, insertion of references in the document (Lecture - 1 h, practical works - 2 h).
4. Creating a table of contents and an alphabetical index of subjects; automatic creation of lists of figures and tables (Lecture - 1 h, practical works - 2 h).
5. Save, edit, and use macros in a spreadsheet application (Lecture - 1 h, practical works - 2 h).
6. Record, edit, and use macros in a word processing application (Lecture - 1 h, practical works – 2 h).
7. Record, edit, and use macros in the presentation application (Lecture - 1 h, practical work - 1 h).
8. Creation and use of user functions in calculations. (Lecture - 1 h, practical works - 2 h).

Requirements for awarding credit points

The assessment of the test consists of:
• all practical works have been developed;
• Three tests have been successfully written - Test 1: Using a word processing application; Test 2: Creating macros and user functions. 3. Test: Test on the considered theoretical questions.

Each test is evaluated in a 10-point system.

Description of the organization and tasks of students’ independent work

Preparation for practical work and tests.

Criteria for Evaluating Learning Outcomes

Laboratory works have been passed and tests have been passed successfully.

Compulsory reading

1. Augucēvičs J. Word: Microsoft Office 2010. Rīga: Biznesa augstskola "Turība", 2013. 63 lpp.
2. Ringa E. Microsoft Office 2007 Excel: strādāsim ātrāk, ērtāk un efektīvāk! Rīga: Biznesa augstskola “Turība”, 2009. 54 lpp.
3. Mansfield R. Mastering VBA for Microsoft Office 2007. – Sybex, 2008. (Pieejama pie kursa atbildīgā mācībspēka).
4. Lambert J. (2015) Microsoft Word 2016 Step By Step. Microsoft Press, 624 p.
5. Frye C. (2015) Microsoft Excel 2016 Step By Step. Microsoft Press, 544 p.

6. Lambert J. (2015) Microsoft PowerPoint 2016 Step By Step. Microsoft Press, 512 p.

Further reading

1. Walkenbach J. Excel VBA Programming For Dummies (For Dummies (Computer/Tech)) . – For Dummies, 2010. (Pieejama pie kursa atbildīgā mācībspēka)

2. Shepherd R. Excel 2007 VBA Macro Programming. – McGraw-Hill Osborne Media, 2009. (Pieejama pie kursa atbildīgā mācībspēka)

Periodicals and other sources

1. Getting started with VBA in Office: https://docs.microsoft.com/en-us/office/vba/library-reference/concepts/getting-started-with-vba-in-office.

Notes

The study course is included in the mandatory part of the IITF professional bachelor's study program "Machine design and production" in full-time studies and part-time studies.