Course code InfT1026

Credit points 2

Information Technology

Total Hours in Course32

Number of hours for lectures8

Number of hours for seminars and practical classes24

Date of course confirmation10.02.2015

Responsible UnitDepartment of Computer Systems

Course developer

author Datoru sistēmu katedra

Ilze Kozele

Bc. agr.

Course abstract

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 will get:
• Knowledge of application methods and programming language Visual Basic for Application (VBA) (tests and class assignments);
• skills 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, class tasks, homework);
• competencies working in a group or doing work independently to acquire, select, analyse, and process information using application software packages (classroom tasks, homework).

Course plan

1 Large document processing. Placing objects in the document their numbering. Creating different lists.
2 Form fields. Character replacement. Spell check. Document templates, printouts, protection, sharing.
3 Creating various complex compound functions using relative, absolute, mixed addresses.
4 User data series. Assigning titles. Usage of assigned names in calculations.
5 Links. Creating and using a database in a spreadsheet application. Data sorting, filtering. Intermediate results.
6 Data analysis tools such as Goal Seek, Solver and Data Analysis, Scenario. Consolidation.
7 User-generated number formats. Conditional formatting options. Special pasting options. Data auditing.
8 Creating Different Complex Charts. Adding options to other apps.
9 Creating cross-section tables and charts, changing appearance. Templates. Workbook Protection.
10 Using Slides of Different Layouts. Design templates, slide transitions, object animations, slideshow control, etc.
11 Grounds for Macro Use Needs, Protection Levels, Recording and Verification Steps. Macro Attraction.
12 Creating a New Toolbar and Button. Macro attachment, parameter change. Editing recorded macros.
13 Spreadsheet app objects and actions with them in the Visual Basic for Aplications environment. User-created functions.
14 Presentation and word processing app objects and actions with them in the Visual Basic for Aplications environment.
15 Database management systems (database applications). Using Microsoft Access. Reviews. Output of database objects.
16 Theoretical and practical knowledge of the application of geographic information systems in the industry. Insight into Quantum GIS.

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.

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 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.

Criteria for Evaluating Learning Outcomes

Test. A 10-point scale is used to evaluate the work.
The tests must be arranged and their assessment is 60% of the final grade, the homework must be submitted and presented and the assessment is 20% of the final grade, the class works must be submitted and the assignments are evaluated with a set or not. It is possible to get two points from the final mark for all submitted and passed tasks, but if the tasks are not submitted or the final mark is unsuccessful, it is reduced in proportion to the amount of unsuccessful or unsuccessful work, which in total amounts to 20% of the total.

Compulsory 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.

Further reading

1. Dixon H. Excel 2007: beyond the manual Berkeley: Apress, 2007. 417 p. 2. Morrison C. Word 2007: beyond the manual. Berkeley: APress, 2007. 297 p. 3. Меженный О.А. Microsoft Office 2010: краткое руководство. Москва [и др.]: Диалектика 2011. 367 c.

Periodicals and other sources

1. Darba sākšana programmā Excel 2010 [tiešsaiste]. Pieejams: https://support.office.com/lv-LV/article/Darba-s%C4%81k%C5%A1ana-programm%C4%81-Excel-2010-d8708ff8-2fbd-4d1e-8bbb-5de3556210f7?ui=lv-LV&rs=lv-LV&ad=LV. 2. Darba sākšana programmā Word 2010 [tiešsaiste]. Pieejams: https://support.office.com/lv-LV/article/Darba-s%C4%81k%C5%A1ana-programm%C4%81-Word-2010-3890f358-ef22-4409-8aac-927895548796. 3. Darba sākšana ar PowerPoint 2010 [tiešsaiste]. Pieejams: https://support.office.com/lv-LV/article/Darba-s%C4%81k%C5%A1ana-ar-PowerPoint-2010-cf58370c-11fa-4834-9847-e9d7a3c4ca5b?ui=lv-LV&rs=lv-LV&ad=LV.