541-0277/06 – Computer Practice (PP)

Gurantor departmentDepartment of Geological EngineeringCredits2
Subject guarantorIng. Michal Matloch Porzer, Ph.D.Subject version guarantorIng. Michal Matloch Porzer, Ph.D.
Study levelundergraduate or graduateRequirementCompulsory
Year1Semesterwinter
Study languageEnglish
Year of introduction2016/2017Year of cancellation
Intended for the facultiesHGFIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
POR041 Ing. Michal Matloch Porzer, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit 0+2

Subject aims expressed by acquired skills and competences

This course is dedicated to fundamentals of operating systems, computer networks, creation of documents in the text editor and use of spreadsheets for creation of tables and graphs. These problems can arise from other courses as well as from practice.

Teaching methods

Tutorials
Project work

Summary

Algorithm – processor – computer. Hardware and software of personal computer. The development of operating systems – MS DOS, MS Windows. Computer networks – the Internet, World Wide Web. The creation documents in the text editor MS Word. Use of spreadsheets (MS Excel) for creation tables and graphs.

Compulsory literature:

Up-to-date computer literature (MS Windows, MS Word and MS Excel).

Recommended literature:

MS Office programs books http://bookboon.com/en/office-ebooks

Way of continuous check of knowledge in the course of semester

Písemné testy.

E-learning

Other requirements

Active participation in seminars and successful completion of written tests.

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

1. Implementing an algorithm on a computer. 2. How a computer works -- the principle of a digital computer. 3. Personal computer hardware. 4. Personal computer software. 5. Operating Systems - MS DOS. 6. Operating Systems - MS Windows. 7. Local and remote computer networks. The Internet and its services, the World Wide Web. 8. Writing and processing texts in MS Word text editor – basic controls, working with files. 9. MS Word – working with blocks, formats. 10. MS Word – working with styles, tables, etc. 11. Creating tables and charts in MS Excel. 12. MS Excel - basic controls, writing data, formulas, working with files. 13. MS Excel– editing a table, working with blocks, formats. 14. MS Excel– Table Appearance, Charting.

Conditions for subject completion

Full-time form (validity from: 2016/2017 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Credit Credit 85  85
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2021/2022 (B2110) Geological Engineering (2101R003) Geological Engineering P English Ostrava 1 Compulsory study plan
2020/2021 (B2110) Geological Engineering (2101R003) Geological Engineering P English Ostrava 1 Compulsory study plan
2019/2020 (B2110) Geological Engineering (2101R003) Geological Engineering P English Ostrava 1 Compulsory study plan
2018/2019 (B2110) Geological Engineering (2101R003) Geological Engineering P English Ostrava 1 Compulsory study plan
2017/2018 (B2110) Geological Engineering (2101R003) Geological Engineering P English Ostrava 1 Compulsory study plan
2016/2017 (B2110) Geological Engineering (2101R003) Geological Engineering P English Ostrava 1 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner