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
Type of course
Mode
Course coordinators
Learning outcomes
After completing the course, the student:
• identifies the needs of enterprises requiring IT system support and ways to use the MS Office package in business practice (K_W02),
• uses MS Excel and MS Word to solve basic ongoing business problems (K_U01),
• creates economic simulations based on provided data (K_U03),
• prepares analyses, diagnoses, and reports on the functioning of organizations using IT and communication tools (K_U05),
• independently develops topics not covered in class (K_U08),
• compares different solutions to business problems in the context of their application to process analysis in an organization (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:
Additional information (registration calendar, class conductors, localization and schedules of classes), might be available in the USOSweb system: