Information technology 2600-TI-1-SJ

The classes are conducted in the form of laboratory sessions in a computer lab. Students work at individual workstations. The classes equip students with the skills to use basic computer software. They begin with an introduction to the topic of computer systems. Then, students are taught:
a) managing the personal computer operating system (MS Windows), effectively securing it against virus infections and hacking attempts,
b) data processing in a spreadsheet (calculations, statistical processing, charts, tables),
c) managing databases for data collection, storage, analysis, and presentation,
d) searching for information on the internet, using publicly available databases, and electronic literature databases,
e) preparing presentations.
Teaching methods: under the guidance of the instructor, students independently complete specific tasks based on prepared instructions for these classes.

Topic of class 1: Organizational matters. Basic information about hardware and software.
Topic of class 2: Word processor.
Topic of class 3: Using bibliometric and abstract databases, electronic journals, and other information resources available on the Internet.
Topic of class 4: Preparing a multimedia presentation.
Topic of class 5: Preparing a multimedia presentation.
Topic of class 6: Spreadsheet.
Topic of class 7: Spreadsheet.
Topic of class 8: Spreadsheet.
Topic of class 9: Spreadsheet.
Topic of class 10: Spreadsheet.
Topic of class 11: Working with data warehouses.
Topic of class 12: Preparing a reference database and bibliography.
Topic of class 13: Data extraction from publications and databases.
Topic of class 14: Data extraction from publications and databases.
Topic of class 15: Class completion (final exam).

Total student workload

Hours completed with the participation of instructors (30 hours) (1.2 ECTS): - Laboratory sessions: 30 hours Time dedicated to individual student work (20 hours) (0.8 ECTS): - Preparation for assessments: 10 hours - Preparation for laboratory sessions: 5 hours - Consultations: 5 hours Total: 50 hours (2 ECTS)

Learning outcomes - knowledge

W1 – The student is familiar with basic and selected specialised computer programs and explains their potential use in processing laboratory research results – K_W49

Learning outcomes - skills

U1 – The student uses a computer as needed for creating databases, analysing data, preparing reports, and presenting results – K_U51 U2 – The student processes measurement results and laboratory research outcomes using spreadsheets - K_U51, U3 – The student uses available databases and independently creates databases, enters measurement results and research outcomes into them, and analyses them – K_U51

Learning outcomes - social competencies

K1- Demonstrates a willingness to expand knowledge and skills in the field of information technology - K_K08

Teaching methods

The student, under the guidance of the instructor, independently performs specific tasks related to the processing and presentation of data using appropriate programs and computer tools, based on the instructions prepared for these classes.

Exploratory teaching methods

- laboratory

Type of course

compulsory course

Prerequisites

The curse conducted in the 1st semester of the 1st year. Prerequisites include knowledge and practical skills in the field of 'Computer Science' at the high school level.

Course coordinators

Andrzej Grzywacz

Assessment criteria

Grading of individual thematic blocks of laboratory classes (completed tasks are assessed) and the final exam (the student draws a set of ten practical tasks and performs them; for each task, 1 point can be awarded for correct execution or 0 points for incorrect execution). Grading methods: Practical exam – W1, U1, U2, U3 Exercise reports – U1, U2, U3 Activity – K1
In terms of knowledge and skills: passing the individual thematic blocks of the course and the final exam:
Niedostateczny <60% of tasks
Dostateczny 60-70% of tasks
Dostateczny plus 71-80% of tasks
Dobry 81-87% of tasks
Dobry plus 88-94% of tasks
Bardzo dobry powyżej 94% of tasks

In terms of social skills: the student's activity during classes and their engagement are assessed. The grade is on a scale of 2-5.
The final grade for the laboratory exercises: the average of the averaged grades obtained during the classes and the grade from the final exam.
There is the possibility of a one-time retake of the exam, which follows the same rules as the original exam.

Bibliography

Obligatory references
Kartanas E., Adamski A. Podstawy informatyki dla studentów biologii i ochrony środowiska.Wyd. Nauk. UMK, Toruń 2000.,
Kamiński W., Kotowski R., Tronczyk P. Użytkowanie komputerów. Wydawnictwo PJWSTK, 2010.
Additional refferences
Sikorski;W. Podstawy technik informatycznych. Wydawnictwo Naukowe PWN, 2006.
Kopertowska M., Sikorski W. Arkusze kalkulacyjne. Poziom zaawansowany. Wydawnictwo Naukowe PWN, 2006.
Kopertowska M. Bazy danych, Wydawnictwo Mikom Multimedia, 2004.
Wojciechowski A. ECUK. Usługi w sieciach informatycznych. Wydawnictwo Naukowe PWN, 2006.
Wojtuszkiewicz K. Urządzenia techniki komputerowej cz. I i II. Wydawnictwo Naukowe PWN, 2007.

Additional information

Additional information (registration calendar, class conductors, localization and schedules of classes), might be available in the USOSweb system:

Description of 2600-TI-1-SJ in USOSweb