Course detail

Computer Basics

CESA-SINFAcad. year: 2024/2025

The course introduces students to basic computer hardware and software. Students will gain theoretical knowledge of hardware components, operating systems, databases, data types, mobile interfaces and applications. Students will gain practical skills in PC hardware configuration, creating and formatting documents in word processors, basic numerical data analysis in spreadsheets, creating and maintaining database systems, and creating simple mobile applications.

Language of instruction

Czech

Number of ECTS credits

4

Mode of study

Not applicable.

Entry knowledge

The student who enters the course should be able to:
- basic operations with a computer, at least at the user level

Rules for evaluation and completion of the course

Students must score a minimum of 50 points out of a total of 100 points in the sub-activities: - Practical exercise: formatting and managing text documents, spreadsheets and MS Office presentations, LaTeX(max 35 points). - Practical exercise: creation of an electronic database in SQLite(max 15 points). - Practical exercise: creating a mobile application in MIT App Inventor (max 30 points). - Intermediate knowledge tests: Data types, systems and logical operations; Probability and decision making (max 20 points).The practical exercises are designed to test the student's ability to use standard software to maintain documentation, manage and analyse data and create simple user applications. The computer exercises are compulsory; duly excused missed exercises may be made up at another time by arrangement with the instructor.

Aims

The aim of the course is to provide students with a basic orientation in the field of computer science, introduce basic computer equipment and practically prepare them for the following courses focused on algorithmization and programming. The graduate of the course: - is able to build a computer from common computer components. - is able to format a text document using self-defined styles. - is able to use advanced MS Word word processing tools to create lists, indexes, tables of contents, and other types of cross-references. - Is able to perform basic analysis of numerical and textual data in MS Excel spreadsheet. - Is able to use different number systems and convert values between them. - is able to create documents and presentations in LaTeX. - is able to edit and interconvert basic data formats. - is able to create a simple database with a user interface, web interface and print output in the SQLite database system. - Can create a simple mobile application for the Android operating system.

Study aids

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

BROOKSHEAR, Glenn J. Informatika. Praha: Computer press, 2013. ISBN 9788025138052. (CS)
DEMBOWSKI, Klaus. Mistrovství v HARDWARE: Nastavení, optimalizace a opravy počítačových komponent. Praha: Computer Press, 2009. ISBN 978-80-251-2310-2. (CS)

Recommended reading

PECINOVSKÝ, Josef. Microsoft Office 2013: podrobná uživatelská příručka. 1. vyd. Brno: Computer Press, 2013. ISBN 978-80-251-4102-1. (CS)

Elearning

Classification of course in study plans

  • Programme SPC-STC Bachelor's 1 year of study, winter semester, compulsory

Type of course unit

 

Computer-assisted exercise

39 hod., compulsory

Teacher / Lecturer

Syllabus

Creating technical texts in MS Word

Processing and visualisation of data and graphs in MS Excel

Creation of technical texts in Latex I.

Creating technical texts in Latex II.

Probability and decision making

Data types, systems and logical operations

Creating databases in SQL I.

Creating databases in SQL II.

Introduction to programming in MIT APP Inventor I.

Introduction to Programming in MIT APP Inventor II. 

 MIT APP Inventor III 

Elearning