Course code InfT1026

Credit points 3

Information Technology

Total Hours in Course81

Number of hours for lectures8

Number of hours for seminars and practical classes24

Independent study hours49

Date of course confirmation16.03.2021

Responsible UnitInstitute of Computer Systems and Data Science

Course developer

author lect.

Ilona Odziņa

Mg. sc. ing.

Course abstract

The aim of the study course is to acquire the necessary skills with a field computer in production conditions and to work with the WEB and GEODS versions of the MF GEO forest management support system, the course deals with the integrated application software packages usage in different types of text documents, spreadsheets and presentations, as well as development of capacity-building applications usage applying the programming language Visual Basic for Applications capabilities.

Learning outcomes and their assessment

As a result of the study course the student:
• know application methods and programming language Visual Basic for Application (VBA) (tests and practical assignments);
• are able to use applications in large-scale text processing, processing of data obtained in research, preparation of different types of presentation materials and use of macro applications in expansion of applications (test, practical assignments, homework);
• are able to work in a group or do work independently to acquire, select, analyse, and process information using application software packages (practical assignments, homework).

Course Content(Calendar)

1. Application of GIS in the specialty (Lecture - 2h, Practical assignment – 3h)
2. Large document processing. Placing objects in the document their numbering. Creating different lists. Form fields. Character replacement. Spell check. Document templates, printouts, protection, sharing. (Lecture - 2h, Practical assignment – 3h)
3.Substantiation of the Need for Macro Use, Protection Levels, Recording and Verification Steps. Macro Attachment/Addition. (Practical assignment - 1 h)
4.Test: Preparation of documents in a word processing application (2 h)
5.Creating various complex compound functions using relative, absolute, mixed addresses. User data series. Assigning titles. Usage of assigned names in calculations. Links. Creating and using a database in a spreadsheet application. Data sorting, filtering. Intermediate results. Data analysis tools such as Goal Seek, Solver and Data Analysis, Scenario. Consolidation. User-generated number formats. Conditional formatting options. Special pasting options. Data auditing. Creating Different Complex Charts. Adding options to other apps. Creating cross-section tables and charts, changing appearance. Templates. Workbook Protection. (Lecture - 2h, Practical assignment - 6h)
6.Substantiation of the Need for Macro Use, Protection Levels, Recording and Verification Steps. Macro Attachment/Addition. (Practical assignment - 1 h)
7.Test: The spreadsheet application usage (2 h)
8.Presentation and word processing app objects and actions with them in the Visual Basic for Aplications environment. (Lecture - 1h, Practical assignment - 2h)
9.Database management systems (database applications). Microsoft Access Usage. Reviews. Output of database objects. (Lecture - 1h, Practical assignment - 4h)

Requirements for awarding credit points

In order to receive a test score, all practical works and successful tests must be developed. Score is the average arithmetic mark of test marks, home work and test and accept Independent work.

Description of the organization and tasks of students’ independent work

Completion of tasks to be performed in practical work. Execution of additional tasks before taking the test, strengthening the acquired knowledge. Homework. At home, you need to create a Microsoft PowerPoint presentation on a topic related to GIS application
specialty. The presentation should include different types of objects (table, chart, pictures, etc.) and use available presentation design tools. The homework should be submitted to the supervisor in electronic form (volume 10-15 slides). A 10-point scale is used to assess the work. The independent work includes the acquisition of the necessary skills with a field computer in forest conditions and work with the WEB and GEODS versions of the MF GEO forest management support system.

Criteria for Evaluating Learning Outcomes

A 10-point scale is used to assess the tests and homework. The grading of the study course is assessed as the arithmetic mean from three components and accept Independent work:
1. Test Nr.1
2. Test Nr.2
3. Homework

Compulsory reading

1. Augucēvičs J. Word: Microsoft Office 2013. Rīga: Biznesa augstskola "Turība", 2015.
2. Nāgelis, J. Microsoft Access 2000 -- no A līdz Z. Rīga: Datorzinību centrs, c2000, 181 lpp.
3. Kristapsone, S. Statistiskās analīzes metodes pētījumā. Rīga: Biznesa augstskola "Turība", 2020, 477 lpp.
4. Wood, Matt A. Python and Matplotlib Essentials for Scientists and Engineers. CA: Morgan un Claypool Publishers, 2015. 138 lpp.

Further reading

1. Augucēvičs J. Word: Microsoft Office 2010. Rīga: Biznesa augstskola "Turība", 2013.
2. Ringa E. MS Office 2007 Excel: strādāsim ātrāk, ērtāk un efektīvāk! Rīga: Turība, 2009. 54 lpp.
3. Veiss K. Darbs ar operētājsistēmu Windows Vista un pakotni Microsoft Office. Rīga: Apgāds Zvaigzne ABC, 2009. 127 lpp.
4. Žemaitis V., Jurēnoks A. Microsoft Word. No iesācēja līdz lietpratējam: mācību līdzeklis. Rīga: Zvaigzne ABC, 2001. 165 lpp.

Periodicals and other sources

1.Darba sākšana programmā MS Office 2016/2019 [tiešsaiste]. Pieejams: