(in Polish) IT in Management 1155-12-M12-ITMan

1. Applications of a spreadsheet in management - W1, U1, K1
a. Visualization of business data (selection of the appropriate method of presentation according to the data type, use of conditional formatting, creating an information dashboard)
b. Simulation analysis and optimisation tools
c. Data filtering
d. Formants controlling the sheet
e. Pivot tables, analysis of data from external sources
f. Elements of creating macro commands (VBA)

2. Applications of relational databases in management - W1, U2, K1
a. Tables, relations between them
b. Select queries, functional queries
c. Forms, reports
d. Controlling the database application

Total student workload

1. Hours realised with the teacher's participation - 30 hours of exercises, 5 hours of office hours, 2. Time devoted to individual student work - 15 hours of preparation for colloquium and solving given problems

Learning outcomes - knowledge

W1: The student knows the IT tools that allow him to obtain data and transform it into information needed for decision-making purposes K_W08

Learning outcomes - skills

U1: The student is able to use a spreadsheet at work - K_U05 , K_U10 U2: The student is able to use the database at work - K_U05 , K_U10

Learning outcomes - social competencies

K1: Student analyzes and improves acquired knowledge and skills - K_K01 K2: Student is able to transform raw data into information supporting decision making - K_K02

Teaching methods

laboratory

Expository teaching methods

- description
- problem-based lecture

Exploratory teaching methods

- laboratory
- classic problem-solving

Online teaching methods

- methods referring to authentic or fictitious situations

Type of course

compulsory course

Assessment criteria

W1, U1, U2, K1, K2 Colloquia in the computer laboratory consisting in solving problems in the field of spreadsheets and databases - +++, Activity in the classroom +

Bibliography

1. Wayne Winston, Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition. Microsoft Press
2. Alan Beaulieu, Learning SQL: Generate, Manipulate, and Retrieve Data, O'Reilly Media
3. Michael Alexander, Jared Decker, Bernard Wehbe, Microsoft Business Intelligence Tools for Excel Analysts, Wiley

Additional information

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

Description of 1155-12-M12-ITMan in USOSweb