Principles of information science 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 the formatting of editorial graphics
4.additional document processing functions (section, header, footer, even and odd pages)
5.Objects in the text editor, for example, 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 document's table of contents, entry index, etc.
Examples of spreadsheet applications in an organization:
1. Addressing convention in a spreadsheet - relative, absolute and mixed references
2. cell formatting and fonts, and use of the formula bar
3. creating financial simulations
4. the use of built-in functions and function nesting
5. work with data from multiple spreadsheets
6. creating charts with one and many data series
7. introduction to the use of financial functions in the worksheet
8.base functions in a spreadsheet - simple and multi-level data sorting, data filtering using an autofilter and advanced filtering
Examples of accounting, efficiency and cost accounting are illustrations to the theoretical solutions
Type of course
After the didactic cycle, learning outcomes are as follows:
Knowledge: the student has knowledge of the basic concepts of economic computer science, and tools to support office work
Skills: the student is able to independently analyze the data in a spreadsheet, is able to prepare legible and methodologically correct charts, operate Microsoft Office in terms of Word and Excel
Social competences: the student is able to correctly use in practice the knowledge of conducted classes for communication in the organization.
The final form of passing the exam consists of two practical tests consisting in completing a set of tasks using the Microsoft Word text editor and a Microsoft Excel spreadsheet.
The final grade is composed of: 30% of the word processor pass, 70% of the spreadsheet grade. The credit will be done remotely on the e-Science platform. The assessment covers the completion of forms and sending the file by eNauka, an active student account is required in the IT infrastructure of the Faculty of Management at the University of Warsaw.
To pass the course, you must obtain at least 51% of each of the partial tests.
Rating scale: DST (51% -60%), DST Plus (61% -70%), DB (71% -80%), DB Plus (81% -90%), BDB (91% -100%)
Kowalczyk G., Word 2010 PL. Kurs (ebook), Helion, Gliwice, 2013
Masłowski K., Excel 2010 PL. Ćwiczenia praktyczne (ebook), Helion, Gliwice, 2011
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
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: