Course code DatZ2018

Credit points 2

Informatics I

Total Hours in Course80

Number of hours for lectures8

Number of hours for seminars and practical classes24

Independent study hours48

Date of course confirmation20.04.2011

Responsible UnitDepartment of Computer Systems

Course developers

author lect.

Kārlis Veiss

Mg. paed.

author prof.

Ilmārs Dukulis

Dr. sc. ing.

Replaced course

DatZ2044 [GDAT2038] Informatics I

Course abstract

The aim of the study course is to learn 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)

Full time intramural studies:
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).
Part time extramural studies:

All topics specified for full time studies are accomplished, but the number of contact hours is one half of the number specified in the calendar

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.

Notes

The study course is included in the compulsory part of the TF academic bachelor's study program "Agricultural Engineering" and the professional bachelor's study program "Applied Energy Engineering" in full-time and part-time studies.