Course code DatZ1085
Faculty Faculty of Business, Management and Economics
Credit points, number of lectures
Credit points ECTS Credit points Total number of auditorium hours Number of lecture hours Number of student independent work hours
4 6 64 32 96
E-courses 2DAT1085-LV: Economic Informatics I 2DAT1085-EN: Economic Informatics I
Course annotation The course aims to familiarize students with the most recent office level applied software and information system technologies.
The course objective is to teach students to work with office software, acquire professional knowledge in the work with the text editor, table processor, presentation software and web applications.
Course tasks:
1) to acquire professional skills for working with office applications;
2) to enhance computer user level knowledge;
3) to acquire applied information search, processing and saving methods in the Internet;

4) to get acquainted with the designing of electronic documents and using of electronic signature.
Course responsible lecturer Māris Vītiņš
Results After successful acquisition of the course the students will be able to demonstrate the following:
Knowledges:
1.Students will have the understanding about the latest office level business software;
2.Student will understand communication principles in Internet, data searching, analysis process;
3.Understanding of the principles for electronic documents protection

Skills:
1.To carry out professional work in preparing documents, performing analytical calculations;
2.Being able to make decisions and find creative solutions in changing conditions.

Competences:
1.Solve various tasks by collecting, processing and analyzing information;
2.Search and obtain the data necessary for the analysis, process them and present them in a visually appropriate form.
3.Independently choose the most appropriate task solution methods and more rational working methods;

4.Student will be able to participate in the improvement of business management processes.
Course plan 1.Functional scheme of computer and its analysis. System and user software.L2
Introduction to computer network and its functions, establishment of the workplace parameters.Lw2

2.Text editor MS Word. Design of documents in MS Word.L2
Text creation with the help of text editor MS Word, work with the graphical editor in MS Word, file archivation. Lw2

3.Work with tables. Graphical possibilities of the text editor. L2
Work with tables in text editor MS Word.Lw2

4.Creation of serial documents.L2
Creation of serial documents and their linking to data bases, envelope design. Protection of document contents. Lw2

5.Designing of large documents.L2
Designing and formatting of large documents in MS Word. Lw2

6.Spreadsheets and their use. Calculations in MS Excel. L2
Creation and formatting of simple calculations. Lw2

7.Possibilities for designing charts and diagrams.L2
Use of charts and diagrams in MS Excel.Lw2

8.Functions in MS Excel.L2
Application of the most popular functions.Lw2

9.Practical application of MS Excel functions.L2
Examination period result analysis, distribution of the scholarship fund and calculation of the scholarship.Lw2

10.Use of databases in MS Excel.L2
Work with databases. Calculation and consolidation of salary.Lw2

11.Use of pivot tables for data aggregation and analysis.L2
Calculations with the help of pivot tables and pivot charts. Lw2

12.Data analysis with data tools features Solver and Goal Seek. VisualBasic for Application elements and their use.L2
Data analysis with data tools features Solver and Goal Seek. Elements of VisualBasic for Applications and their use. Lw2

13.Fundamentals of building computer networks.L2
Analysis of local and global computer networks.Lw2

14.Tools for searching information in the Internet environment. Data downloading and use.L2
Search for information in the Internet, saving and use of the acquired data.Lw2

15.Communication in the Internet.L2
Use of mail and news servers.Lw2

16.Electronic documents. Electronic signature and its use. L2
Design of electronic documents and use of electronic signature. Lw2

Total:64


Requirements for obtaining credit points Attendance of lectures and laboratory work is compulsory. During the semester there will be 16 lectures and 16 laboratory work assignments. To acquire the credit points all laboratory work assignments must be completed.
The final mark of the course will consist of:
Completed laboratory assignments (60%), 2 tests (20%), examination (20%).

The examination (to be completed on the computer) will contain a test and a task.
Study programmes Business Administration
Economics
Financial Management
Business Administration
Insurance and Finance
International Economics and Commercial Diplomacy
E-Business and Logistics Management Systems
International Economics and Commercial Diplomacy
Accounting, Analysis and Audit
International Economic Relations