Fundamentals of IT for business 2600-DSMdz1PIDB
Applications of the editor in the organization:
1. text formatting (font, paragraph, bulleted, numbered list),
2. full support for formatted tables (loading graphics, calculations, charts)
3. the role of the text field in formatting editorial graphics
4. additional document processing functions (section, header, footer, even and odd pages)
5. objects in a text editor on the example of decorative graphics, creating an organizational chart and mathematical and statistical formulas, etc.
6. creating data sources and using them in mail merge
7. creating a table of contents of the document, an index of entries, etc.
Examples of spreadsheet applications in the organization:
1. addressing convention in a spreadsheet - relative, absolute and mixed references
2. formatting cells and fonts and using the formula bar
3. creating financial simulations
4. using built-in functions and nesting functions
5. working with data from multiple spreadsheets
6. creating charts with one and many data series
7. introduction to the use of financial functions in the spreadsheet
8. database functions in a spreadsheet - simple and multi-level data sorting, data filtering using autofilter and advanced filtering.
Theoretical solutions are illustrated by examples relating to accounting, efficiency and cost accounting
|
Term 2025Z:
Applications of the editor in the organization: Examples of spreadsheet applications in an organization: |
Term 2026Z:
Applications of the editor in the organization: Examples of spreadsheet applications in an organization: |
Type of course
Mode
Learning outcomes
Student after completing the course:
1. Knows and understands in-depth the principles, procedures and practices regarding the use of the basic MS Word and Excel packages (K_W02),
2. Is able to use the practice of using MS Office to solve current economic problems (K_U01)
3. Is able to independently and collectively prepare analyses, diagnoses and reports on financial management in organizations, accounting, management of financial institutions and strategies of financial institutions and present them communicatively, also in English - using IT and communication tools (K_U03)
4. Is prepared to independently and collaboratively develop analyses, diagnoses, and reports on the functioning of organizations using MS Word and MS Excel tools, and to present them in a clear and communicative manner, also in English. (K_U05)
5. Has the ability to self-educate and improve acquired qualifications (K_U06)
6. Is prepared to improve their qualifications and independently develop skills in the use of IT tools for data analysis and processing. (K_U08)
7. Is ready to assess and critically approach situations and phenomena related to financial management in organizations, accounting, management of financial institutions and strategists of financial institutions (K_K01)
Assessment criteria
Methods: Exercises, examples from practice, interactive explanation of key concepts. The basic assessment criterion is the use of computer hardware and software (MS Office) to solve tasks.
The final form of assessment are two practical tests consisting in performing a set of tasks using the Microsoft Word text editor and a Microsoft Excel spreadsheet.
The final grade consists of: 30% grade for word processing, 70% grade for spreadsheet. The assessment will traditionally take place in the WZ UW laboratories
To pass the course, you must obtain at least 51% in each of the partial tests.
Rating scale: DST (51%-60%), DST Plus (61%-70%), DB (71%-80%), DB Plus (81%-90%), BDB (91%-100%)
Bibliography
Main:
Kowalczyk G., Word 2010 PL. Kurs (ebook), Helion, Gliwice, 2013
Masłowski K., Excel 2010 PL. Ćwiczenia praktyczne (ebook), Helion, Gliwice, 2011
Additional:
Węglarz W., Żarowska-Mazur A., Excel 2010. Praktyczny kurs (ebook), Warszawa, 2012, Wydawnictwo Naukowe PWN
Cox J., Lambert J., Microsoft Word 2010 Step by Step 1st Edition, Kindle Edition (ebook), 2010
Additional information
Information on level of this course, year of study and semester when the course unit is delivered, types and amount of class hours - can be found in course structure diagrams of apropriate study programmes. This course is related to the following study programmes: