(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
Learning outcomes - knowledge
Learning outcomes - skills
Learning outcomes - social competencies
Teaching methods
Expository teaching methods
- problem-based lecture
Exploratory teaching methods
- classic problem-solving
Online teaching methods
Type of course
Course coordinators
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: