545-0495/04 – Application of Computer Technique in Economic Practice (AVT)

Gurantor departmentDepartment of Economics and Control SystemsCredits5
Subject guarantorIng. Oldřich Vlach, Ph.D.Subject version guarantorIng. Oldřich Vlach, Ph.D.
Study levelundergraduate or graduateRequirementCompulsory
Year3Semesterwinter
Study languageCzech
Year of introduction2008/2009Year of cancellation2011/2012
Intended for the facultiesHGFIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
SOU70 RNDr. Radmila Sousedíková, Ph.D.
VLA26 Ing. Oldřich Vlach, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit and Examination 2+2
Part-time Credit and Examination 6+6

Subject aims expressed by acquired skills and competences

Students apply computer technology in practical problem solution and thus they deeply understand economic regularity.

Teaching methods

Lectures
Tutorials
Project work

Summary

The course covers basic user computer systems, network OS, work with tables and texts. Using mail merge, desktop publishing equipment. Components of computer networks, central computers, servers, use the Internet, IP version 4 and 6. Familiarization with new technology hardware. GIS, GPS, GSM. Using MS Excel decision-making and economic applications in the company. Protection against viruses, use maker. MS Powerpoint, web page creation, building calculations.

Compulsory literature:

Texty předané vyučujícím, Brož, Milan. Microsoft Office Word 2003: Podrobná uživatelská příručka. Vyd. 1.. Brno: Computer Press, 2004 - viii, 392 s. : il. ISBN 80-251-0140-1 Brož, Milan. Microsoft Excel pro manažery a ekonomy 4. aktualiz. vyd.. Brno: Computer Press, 2006 - 430 s. : il. + 1 CD-ROM ISBN 80-251-1307-8 případně jiné manuály k výše uvedeným softwarovým produktům PC World, SW noviny, články z dalších počítačových časopisů stav prosinec 2007

Recommended literature:

Way of continuous check of knowledge in the course of semester

Regular feedback on the progress of knowledge during the current term is provided by seminar works, semester projects, and knowledge check

E-learning

Other requirements

Project development.

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

1. Users of computer systems in business practice 2. Working with texts in economic practice, the principle of processing, desktop publishing equipment 3. MS Word, mail merge, using elements from databases 4. Working with tables, graphs, writing formulas 5. Network Nowell NetWare operating system, e-mail 6. Principle work computer and its main components 7. Introduction to creating web pages 8. The world computer network Internet, principles of 9. Software for access to the Internet. 10. Acquisition of economic data from the Internet, their further processing 11. GIS, GPS, GSM 12. Mainframes 13. MS Excel, its use in economic practice 14. Methods of regression and correlation analysis 15. Programs for presentation, MS Powerpoint 16. New technology (hardware) PC 17. Viruses, viruses, antivirus resources 18. Budgeting, building calculations

Conditions for subject completion

Full-time form (validity from: 1960/1961 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of pointsMax. počet pokusů
Exercises evaluation and Examination Credit and Examination 100 (100) 51 3
        Exercises evaluation Credit 33 (33) 0 3
                Other task type Other task type 33  0 3
        Examination Examination 67 (67) 0 3
                Written examination Written examination 32  0 3
                Oral Oral examination 35  0 3
Mandatory attendence participation:

Show history

Conditions for subject completion and attendance at the exercises within ISP:

Show history

Occurrence in study plans

Academic yearProgrammeBranch/spec.Spec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2011/2012 (B2102) Mineral Raw Materials (2102R003) Commerce Engineering in Raw Materials Treatment Industry P Czech Ostrava 3 Compulsory study plan
2011/2012 (B2102) Mineral Raw Materials (2102R003) Commerce Engineering in Raw Materials Treatment Industry K Czech Ostrava 3 Compulsory study plan
2010/2011 (B2102) Mineral Raw Materials (2102R003) Commerce Engineering in Raw Materials Treatment Industry P Czech Ostrava 3 Compulsory study plan
2010/2011 (B2102) Mineral Raw Materials (2102R003) Commerce Engineering in Raw Materials Treatment Industry K Czech Ostrava 3 Compulsory study plan
2009/2010 (B2102) Mineral Raw Materials (2102R003) Commerce Engineering in Raw Materials Treatment Industry P Czech Ostrava 3 Compulsory study plan
2009/2010 (B2102) Mineral Raw Materials (2102R003) Commerce Engineering in Raw Materials Treatment Industry K Czech Ostrava 3 Compulsory study plan
2008/2009 (B2102) Mineral Raw Materials (2102R003) Commerce Engineering in Raw Materials Treatment Industry P Czech Ostrava 3 Compulsory study plan
2008/2009 (B2102) Mineral Raw Materials (2102R003) Commerce Engineering in Raw Materials Treatment Industry K Czech Ostrava 3 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner

Assessment of instruction



2009/2010 Winter