Course code InfT1014

Credit points 3

Information Technologies II

Total Hours in Course81

Number of hours for lectures8

Number of hours for seminars and practical classes24

Independent study hours49

Date of course confirmation19.10.2011

Responsible UnitInstitute of Computer Systems and Data Science

Course developer

author Mehānikas un dizaina institūts

Nataļja Vronska

Dr. paed.

Course abstract

The course gives knowledge about information as objects of research in information technology, information units of measure, history of the information processing tools elements of PC, data storage, software, ergonomic, computer virus, computer networks, internet and electronic mail. Students get acquainted with spreadsheet processor MS Excel – use functions, creating charts and work with data base.

Learning outcomes and their assessment

Knowledge about information processing and computer input devices, output devices and software, the internet and computer network, information security and data protection, as well as spreadsheet use for data processing; skills to be able to define and describe the analytical information, problems and solutions in the field of science, using the learned theoretical and practical framework; competence independent access, select and analyse information and use it to make decisions and solve problems in information technology in the field of science, student knows how to use practical skills for spreadsheet application for data processing.

Compulsory reading

1. Aizpuriete V. Microsoft Excel profesionālai izglītībai. Rīga: Mācību grāmata, 2002. 252 lpp.
2. Dukulis I. Apgūsim jauno Excel! Rīga: Turība, 2007. 173 lpp.
3. Ringa E. Excel. MS Office 2007. Strādāsim ātrāk, ērtāk un efektīvāk! Rīga: Turība, 2009. 54 lpp.
4. Walkenbach J. Microsoft Excel 2010 Formulas. USA: Wiley Publishing, 2010.

Further reading

1. Shelly G.B., Quasney J. Microsoft Office Excel 2010. Boston: Cengage Learning, 2011.
2. Волков В. Понятный самоучитель Excel 2010. Санкт-Петербург: Питер, 2010.
3. Фрай К. Microsoft Excel 2010. Шаг за шагом. Москва: Эком, 2011.