155-0597/03 – Introduction to Programming (UDP-ENG)

Gurantor departmentDepartment of Computer ScienceCredits4
Subject guarantorIng. Vítězslav Novák, Ph.D.Subject version guarantorIng. Vítězslav Novák, Ph.D.
Study levelundergraduate or graduate
Study languageEnglish
Year of introduction2014/2015Year of cancellation
Intended for the facultiesEKFIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
NOV21 Ing. Vítězslav Novák, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Examination 2+0

Subject aims expressed by acquired skills and competences

Obtaining the base knowledge in the areas of the programming and Visual Basic for Application programming language. Applying and using the knowledge and skills in the area of basic programs creation.

Teaching methods

Lectures
Tutorials
Project work
Other activities

Summary

The main goals are the programming paradigm and the fundamentals of the Visual Basic for Applications programming language. The aim of this subject is to manage creating a simple program on the spreadsheet environment of Microsoft Excel.

Compulsory literature:

ALEXANDER, Michael a Dick KUSLEIKA. Excel 2016 power programming with VBA. Indianapolis, IN: Wiley, 2016. ISBN 9781119067726. WALKENBACH, John. Excel VBA programming for dummies. 4th edition. Hoboken, NJ: Wiley, 2015. ISBN 1119077397.

Recommended literature:

HARVEY, Greg. Excel 2016 all-in-one for dummies. Hoboken, NJ: John Wiley & Sons, 2016. ISBN 111907715X. WALKENBACH, John. Excel 2013 bible. Indianapolis: Wiley, 2013. ISBN 978-1118490365.

Way of continuous check of knowledge in the course of semester

E-learning

Další požadavky na studenta

No other requirements.

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

1) Modules, variables, data types, procedures, macros. 2) Controlling of program flow. 3) Arrays 4) Forms and their controls. 5) Error handling. 6) Important VBA functions. 7) Excel and its object model.

Conditions for subject completion

Full-time form (validity from: 2014/2015 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Examination Examination 100  51
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner
Incoming students - bachelor study 2019/2020 Full-time English Choice-compulsory 163 - International Office stu. block
Incoming students - bachelor study 2018/2019 Full-time English Choice-compulsory 163 - International Office stu. block
Incoming Students 2017/2018 Full-time English Choice-compulsory 163 - International Office stu. block
Incoming Students 2016/2017 Full-time English Choice-compulsory 163 - International Office stu. block
Incoming Students 2015/2016 Full-time English Choice-compulsory 163 - International Office stu. block