The aim of studying and bibliography

The main aim of study: Aligning students' skills in the use of advanced functions of selected application programs (text editor, spreadsheet). To familiarize students with the operation of the database management system (Ms Access). To familiarize students with the basic concepts and concepts of database systems, necessary for the proper design, use and implementation of database systems and their applications.

The general information about the module: The "Introduction to computer science" classes discuss issues related to areas of interest in modern computer science as well as the basics of database design and the use of database management systems.

Bibliography required to complete the module

Bibliography used during lectures

1	R. Kawa, J. Lembas	Wstęp do informatyki. Wykłady z Informatyki	PWN (IBUK Libra).	2017
2	D. Mendrala, M. Szeliga	Access 2016 PL. Ćwiczenia praktyczne	Helion, Gliwice.	2016.
3	A. Tomaszewska	ABC Word 2016 PL	Helion, Gliwice.	2015.
4	M. Aleksander, D. Kusleika	Excel 2016 PL. Formuły	Helion.	2017.

Basic requirements in category knowledge/skills/social competences

Formal requirements: The student was enrolled for the first semester. The student satisfies the formal requirements set out in the study regulations.

Basic requirements in category knowledge: Lack

Basic requirements in category skills: Ability to use a computer - including basic skills related to the creation of text documents and spreadsheets.

Basic requirements in category social competences: The ability to work in a small team.The ability to work with a teacher based on communicating about problems in solving tasks.

Module outcomes

MEK	The student who completed the module	Types of classes / teaching methods leading to achieving a given outcome of teaching	Methods of verifying every mentioned outcome of teaching	Relationships with KEK	Relationships with PRK
01	Knows areas of using a computer as a basic engineer work tool.		written exam	K_W06+ K_W07+	P6S_WG
02	Can use the tools available in the text editor - for advanced text formatting.		written exam project presentation	K_W02+ K_U08+	P6S_UW P6S_WG
03	He can use the functions built into the spreadsheet, with particular emphasis on the functions used to analyze and process various types of data.	lecture, laboratory	project presentation	K_W02+ K_W08+ K_U08+	P6S_UW P6S_WG
04	Knows the basics of database design. Can point out the differences between a spreadsheet and a database. He can design a simple database using the MS Access package.	lecture individual project	project presentation	K_W02+ K_W08+ K_U08+ K_K01+ K_K02+	P6S_KK P6S_KO P6S_UW P6S_WG

Attention: Depending on the epidemic situation, verification of the achieved learning outcomes specified in the study program, in particular credits and examinations at the end of specific classes, can be implemented remotely (real-time meetings).

The syllabus of the module

Sem.	TK	The content	realized in	MEK
1	TK01	Basic concepts of computer science. Construction and operation of a personal computer. Operating system, personal computer software packages.	W1-W2, L1	MEK01
1	TK02	Advanced text formatting methods in text editor. Work with templates, use of styles, automatic numbering of designs, drawings, creating lists of illustrations, tables, tables of contents.	W3, L2-L3	MEK02
1	TK03	Use of spreadsheet for data analysis. Creating charts, working with functions built into the program, with particular emphasis on financial, mathematical and statistical formulas and formulas supporting data processing, creating tables and pivot charts.	L4-L6	MEK03
1	TK04	What are databases? Database design. Relational database model. Algebra of relationships. Basic concepts of databases: tables, keys, relationships, records, queries, forms, reports, modules.	W4-W7, L7-L15	MEK04

The student's effort

The type of classes	The work before classes	The participation in classes	The work after classes
Lecture (sem. 1)	The preparation for a test: 55.00 hours/sem.	contact hours: 15.00 hours/sem.
Laboratory (sem. 1)		contact hours: 30.00 hours/sem.
Advice (sem. 1)		The participation in Advice: 2.00 hours/sem.
Credit (sem. 1)	The preparation for a Credit: 6.00 hours/sem.	The written credit: 2.00 hours/sem.

The way of giving the component module grades and the final grade

The type of classes	The way of giving the final grade
Lecture	Test concerning the content discussed in the lecture.
Laboratory	work evaluation, project presentation
The final grade	The final grade is a weighted average of the grades obtained by the student for passing the laboratories and the lecture. Evaluation weight of projects 0.6; evaluation weight from the lecture test 0.4. The student must obtain at least a "dst" grade from passing the lecture test.

Sample problems

Required during the exam/when receiving the credit
_Nowe karty modułów IiAD-1.pdf

Realized during classes/laboratories/projects
(-)

Others
(-)

Can a student use any teaching aids during the exam/when receiving the credit : no

The contents of the module are associated with the research profile: no