Basics of computer science and programming - GIXCS1EBNF

Academic year/semester: 2024/25/1

ECTS Credits: 5

Available for: Only for the faculty’s students

Lecture hours: 1
Seminarium:0
Practice: 0
Laboratory: 3
Consultation: 0

Prerequisites: -

Course Leader: Dr. Ádám Béla Horváth

Faculty: Keleti Károly Faculty of Business and Management, 1084 Budapest, Tavaszmező utca 17.

Course Description:
The aim of the course is to provide students with the basic IT skills required to complete the course (Operating Systems, Office - word processing, spreadsheet, presentation software), basic database (SQL) and programming skills (variables, branches, loops). Basics of programming, algorithm writing tools. Creating simple algorithms using algorithm description tools (independent of programming language). Programming languages, their classification. Steps of programming. Concepts of information, system, information system. Definition of database, database management system. Definition, elements, relationship of data model.

Competences:
-

Topics:
1. Document and paragraph formatting, basics of fonts, file saves doc(x), pdf. Pdf file format basics
2. Inserting images and image formats. Tables and references (table of contents, list of figures)
3. University-level document creation: source-criticism and references, use of a selected reference system. (external-internal link manager)
4. Workbook and worksheet structure, link types, structure of functions
5. aggregate functions (SUM, MIN, MAX), IF function
6. basics of diagramming
7. Slide structure, transitions and animations: an introduction to the basic functions of Powerpoint
8. \"Branding\" in the presentation, planning a permanent appearance, presentation technique training (+printing customizations)
9. Excel and R: Introducing R, the main data types.
10. basic commands and loops (for, while)
11. data exchange with Excel (BERT), basic problems that can be automated, additional commands
12. technical and legal aspects of intellectual property protection
13. Organizational problems of creative group work, mini \"project management\"
14. Advantages and disadvantages of other presentation options (Canva, Latex, Prezi).

Assessment: The signature requirement, the method used to form an exam mark: - Not exceeding the absence limit in exercises according to the regulations - Obtaining 50% of the points available for the practical part Midterm papers, exams, submissions: Week 7 1-6. material of weeks Week 13 7-12. material of weeks Week 14 Topic of the supplementary test

Exam Types:

Written Exam

Test Exam

Mid Term Exam

Compulsory bibliography: David T. Bourgeois-James L. Smith-Shouhong Wang-Joseph Mortati: Information Systems for Business and Beyond. Saylor Foundation, 2014. Open Access: https://open.umn.edu/opentextbooks/textbooks/information-systems-for-business-and-beyond

Recommended bibliography: -

Additional bibliography: -

Additional Information: Practical exercises: Submitted Word document demonstrating basic competences in source processing and word processing A set of tasks solved in Excel in class Short R algorithm developed in class