Oferta własna uczelni: Technologie informacyjne 1855-F1-T-SJ

1. During the course, the student get the following skills:
Using Literature Databases, Performing basic mathematical calculations, solving content-based tasks, reading and understanding the messages of computer programs.
2. Knowledge of Microsoft Office and OpenOffice.
3. Using MS Word as a text editor: basic and advanced text editing techniques: font editing, paragraphs, styles, page layout, text sorting, inserting bullets, header, footer, macros, line spacing, references - table of contents, footnotes, inserting tables and their formatting - edges, content alignment, etc., text direction, text alignment, page break, inserting a page number, writing symbols and mathematical equations, inserting graphic elements, cooperation with other MS Office programs.
4. Basic calculations in MS Excel program - creating databases, charts, pivot tables, creating equations. Data entry, charting, chart types, chart editing, basic functions - i.e. sum, average, minimum, maximum etc., sorting data, editing data in cells, saving data, formatting cells, splitting and locking windows, conditional formatting, list developed, data consolidation.
5. Basic calculations in MS Excel - creating databases, charts, pivot tables, creating equations. Entering data, creating graphs of various types, editing graphs, basic mathematical functions - ie. Sum, average, minimum, maximum, etc., sorting data, editing data in cells, saving data, formatting cells, dividing and locking windows, conditional formatting, list developed, data consolidation.
6. Database searches

Całkowity nakład pracy studenta

1. The workload related to classes requiring the direct participation of academic teachers is: - participation in exercises: 15h - consultations: 10h The workload related to classes requiring the direct participation of academic teachers is 25 hours, which corresponds to 1 ECTS point 2. Time devoted to individual student work needed to successfully complete the course: - reading the indicated scientific literature: 10h The workload related to the time devoted to individual student work is 10 hours, which corresponds to 0.4 ECTS points 3. Time required to prepare for participation in the assessment process: - preparation and completion of the test: 10h+5h=15h The total student workload related to preparing for participation in the assessment process is 15 hours, which corresponds to 0.6 ECTS points 4. Time required for compulsory practice(s). - not applicable- not applicable

Efekty uczenia się - wiedza

K1: information technologies and statistical tools used to analyze and present data and to solve problems. (B.W21) the student is able to: • use basic calculation programs for data analysis • present the results in a descriptive and graphic manner • create a database to sort and select information contained therein

Efekty uczenia się - umiejętności

S1: interpret a research study and analyze it in relation to the current state of knowledge (E.U2) S2: make use of national and international specialist scientific literature (E.U3) The student is able to: • use basic computer utilities • read with understanding the messages of computer programs • use the programs for data collection and analysis • edit text in MS Word • create multimedia presentations in Power Point • browse and analyze literature databases

Efekty uczenia się - kompetencje społeczne

SC1: identify and acknowledge own limitations, and perform a self-assessment of deficits and educational (K5) SC2: make use of objective sources of information (K6) The student is able to: • successfully use Internet resources and services • verify the collected information in terms of its reliability

Metody dydaktyczne

- individual work on the computer - work on the project

Metody dydaktyczne eksponujące

- pokaz

Metody dydaktyczne poszukujące

- ćwiczeniowa

Wymagania wstępne

A student starting education in the course of Information Technologies should have basic general knowledge in the field of mathematics and computer science (level of secondary school)

Koordynatorzy przedmiotu

Jacek Budzyński

Kryteria oceniania

Verification of the learning outcomes achieved by the student will take place through crediting:
• active participation and preparation for classes,
• mastering the material realized during lectures and exercises.
• preparation of evaluation work

Checking skills and social competences will take place by careful observation of the student's activities while performing practical tasks.
To pass the course, it is necessary to attend lectures and classes. The student must independently perform the practical tasks provided for the classes in accordance with the instructor's instructions, pass a practical test or prepare a evaluation work.
In the case of practical tasks, grades are ranked according to the following scale:

Percentage of completing the exercise correctly degree
92-100% very good
84-91% good plus
76-83% good
68-75% sufficient plus
60-67% sufficient
0-59% insufficient

Ways to verify knowledge B.W21
Active participation in exercises +
Preparation of evaluation work +

Ways to verify skills E.U2 E.U3
Active participation in exercises + +
Preparation of evaluation work + +

Ways to verify competences K5 K6
Active participation in exercises + +
Preparation of evaluation work + +

The following descriptive criteria will be used to pass the grade:

Very good: the student has mastered the knowledge of the entire material, presents it in a logical and systematic manner, knows practical applications.
Good plus: the student has mastered the knowledge of the entire material, presents it in a consistent and logical manner
Good: the student has mastered the knowledge of most of the material, presents it in a logical way, guided by the academic teacher, can formulate accurate conclusions.
Sufficient plus: the student has mastered the minimum curriculum, knows the basic issues and understands the questions asked, presents knowledge in a logical way.
Sufficient: the student has mastered the minimum curriculum, knows the basic issues and understands the questions asked, presents knowledge inconsistently, is unable to apply it in practice.
Insufficient: the student has not mastered the minimum curriculum, does not know the basic issues and does not understand the questions asked.

Ways to verify knowledge B.W21
Active participation in exercises +
preparation of evaluation work +

Ways to verify skills E.U2 E.U3
Active participation in exercises + +
preparation of evaluation work + +

Ways to verify competences K5 K6
Active participation in exercises + +
preparation of evaluation work + +

Praktyki zawodowe

not applicable

Literatura

1. Mary Anne Poatsy, Keith Mulbery, Cynthia Krebs, Lynn Hogan, Eric Cameron, Jason Davidson and all: Exploring Microsoft Office 2016. Exploring for Office 2016 Series
2. Charles Hargis Davis: Introduction to Information Science and Technology. ASIS&T Monograph (2011).
3. Prof James Steinberg: Open Office Basic: An Introduction. CreateSpace Independent Publishing Platform (December 15, 2012)

Więcej informacji

Dodatkowe informacje (np. o kalendarzu rejestracji, prowadzących zajęcia, lokalizacji i terminach zajęć) mogą być dostępne w serwisie USOSweb:

Strona przedmiotu 1855-F1-T-SJ w USOSweb