Course code DatZ2050

Credit points 3

Informatics I

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 developers

author prof.

Ilmārs Dukulis

Dr. sc. ing.

author lect.

Kārlis Veiss

Mg. paed.

Course abstract

During the study course, students 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.

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.

Notes

The study course is included in the compulsory part of the TF 1st level professional higher education study program “Technical Expert”.