155-1353/01 – Data processing on PC (ZD)

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 languageCzech
Year of introduction2013/2014Year of cancellation
Intended for the facultiesEKFIntended for study typesBachelor
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit 1+2

Subject aims expressed by acquired skills and competences

To be able to process larger amounts of data using totals or pivot tables of Microsoft Excel. To understand the difference between a databases in Microsoft Excel and Access. To design relational databases. To use statements SELECT, INSERT, UPDATE and DELETE of SQL language. To create database applications in Microsoft Office Access.

Teaching methods

Lectures
Tutorials

Summary

The aim of subject is to extend the knowledge and skills in the areas of data processing on a PC using a spreadsheet and DBMS (using of MS Excel and MS Access is supposed). In MS Excel, students will be introduced to the processing of large amounts of data using sorting, filtering, or totals, or with their processing using pivot tables or charts. In Microsoft Access, students will be learned to create a databases, to query data of the databases or to create a simple graphical user interface.

Compulsory literature:

WALKENBACH, John. Excel 2010 bible. Indianapolis, IN: Wiley Publishing, 2010. ISBN 978-0470474877. GROH, Michael R. Access 2010 bible. Indianapolis, IN: Wiley Publishing, 2010. ISBN 978-0470475348.

Recommended literature:

FRYE, Curtis. Microsoft Excel 2010: step by step. Redmond, Wash.: Microsoft Press, 2010. ISBN 978-0735626942. COX, Joyce a Joan LAMBERT. Microsoft Access 2010: step by step. Redmond, Wash.: Microsoft Press, 2010. ISBN 978-0735626928.

Way of continuous check of knowledge in the course of semester

Hodnocení nabytých vědomostí a dovedností je ověřováno dvěma projekty v průběhu semestru. První projekt ověřuje pochopení látky po přednášce Kontingenční tabulky a grafy MS Excelu. Úkolem je zpracování seznamu dat pomocí kontingenční tabulky. Druhý projekt ověřuje pochopení látky celého předmětu. Úkolem je implementace jednoduché databázové aplikace na MS Accessu. Je odevzdáván v zápočtovém týdnu nebo později.

E-learning

Přednášky a cvičení jsou ve formátu PDF v LMS Moodle.

Další požadavky na studenta

No other requirements.

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

Lectures: 1) Working with lists in MS Excel. 2) Pivot tables and charts in MS Excel. 3) Design of relational databases. 4) Creating tables in MS Access. 5) Querying in MS Access. 6) Creating graphical user interface in MS Access. 7) Cooperation between MS Excel and MS Access.

Conditions for subject completion

Full-time form (validity from: 2013/2014 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Exercises evaluation Credit  
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2013/2014 (B6208) Economics and Management (6208R037) Management P Czech Ostrava 3 Choice-compulsory study plan
2013/2014 (B6208) Economics and Management (6208R037) Management (00) Management P Czech Ostrava 3 Choice-compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner