Fundamentals of IT for business

obligatory courses

Classroom

The subject of the course includes teaching the basic principles of using a word processor (adapted to classes at WZ UW) and an Excel spreadsheet.

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

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

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).

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%)