Course title Informatics I
Course code DatZ2044
Credit points 2
ECTS creditpoints 3
Total Hours in Course 80
Number of hours for lectures 8
Number of hours for seminars and practical classes 24
Independent study hours 48
Date of course confirmation 16/03/2021
Responsible Unit Department of Computer Systems
Course developers
Mg. paed., vieslekt. Kārlis Veiss
Dr. sc. ing., prof. Ilmārs Dukulis

There is no prerequisite knowledge required for this course
Replaced course
DatZ2018 [GDAT2018] Informatics I
Course abstract
The aim of the study course is to learn how to perform calculations, create diagrams and analyze and model data using a spreadsheet program; creating and displaying complex slide sets using a slide presentation program. The acquired knowledge and skills are necessary for the development and design of study papers, as well as for the performance of professional activities.
Learning outcomes and their assessment
Knowledge of the use of spreadsheet programs in data processing and the use of slide presentation programs in the demonstration of ideas and projects. Knowledge is assessed in Test 1.
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. Creation of data series, data entry and design of calculation tables (Lecture - 1 h, practical work - 3 h).
2. Use of absolute, relative and mixed cell addresses in calculations (Lecture - 1 h, practical work - 2 h).
3. Use of functions in solving different types of tasks (Lecture - 1 h, practical work - 4 h).
4. Creating diagrams (Lecture - 1 h, practical work - 3 h).
5. Data sorting and filtering (Lecture - 1 h, practical work - 2 h).
6. Use of data analysis tools and creation of pivot tables (Lecture - 1 h, practical work - 3 h).
7. Creation of various objects (tables, diagrams, schemes) on slides (Lecture - 1 h, practical works - 4 h).
8. Editing the main slide, using hyperlinks and control buttons (Lecture - 1 h, practical work - 3 h).
Requirements for awarding credit points
Test. The assessment of the test consists of:
• all practical works have been developed;
• two tests have been successfully written - Test 1: Using the spreadsheet application; Test 2: Creating presentations.
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
Both tests have been successfully passed.
Compulsory reading
1. 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.
2. Veiss K. Darbs ar operētājsistēmu Windows Vista un pakotni Microsoft Office. – R.: Apgāds Zvaigzne ABC, 2009. 126 lpp.
3. Dukulis I. Apgūsim jauno Excel! Rīga: Turība, 2007. 173 lpp.
4. Frye C. (2015) Microsoft Excel 2016 Step By Step. Microsoft Press, 544 p.
5. Lambert J. (2015) Microsoft PowerPoint 2016 Step By Step. Microsoft Press, 512 p.
Further reading
1. Shelly G.B., Quasney J. Microsoft Office Excel 2010. Cengage Learning: 2011. 328 p.
2. Несен А. Microsoft Word 2010: от новичка к профессионалу. Москва: ДМК-Пресс, 2011. 443 с.
Periodicals and other sources
1. PowerPoint palīdzība un apmācība: https://support.microsoft.com/lv-lv/powerpoint.
2. Excel palīdzība un apmācība: https://support.microsoft.com/lv-lv/excel.
The study course is included in the compulsory part of the TF professional bachelor study program "Machine Design and Manufacturing".