Study programmes / B-EMEN Economics and Management / Office Applications
Course code:KAPA
Course title in language of instruction:Office Applications
Course title in Czech:Kancelářské aplikace v AJ
Course title in English:Office Applications
Mode of completion and number of credits:Exam (5 credits)
(1 ECTS credit = 28 hours of workload)
Mode of delivery/Timetabled classes:full-time, 1/2
(full-time, hours of lectures per week / hours of seminars per week)
Language of instruction:English
Level of course:bachelor
Semester:SS 2016/2017 - FBE
Name of lecturer:Ing. Jan Přichystal, Ph.D. (supervisor)
Prerequisites:not Final Bachelor Exam
 
Aims of the course:Introduction to office text processor and spreadsheet application. Students get new experience in working with Microsoft Word when formatting documents and Microsoft Excel when processing and presenting the data.
Course contents:
1.Text processor -- basic terms, usage, text editing (allowance 8/14)
 
a.Text formating
b.Paragraph properties
c.Styles

2.Spreadsheet -- basic terms, usage (allowance 6/14)
 
a.Editing spreadsheet, cell formats
b.Functions, equations
c.Charts

Learning outcomes and competences:
Generic competences:
 
-ability to apply knowledge
-ability to solve problems
-ability to work independently
-designing and managing projects
-skilled at utilizing and processing information

Specific competences:
 
-Student is able to choose proer style of formating the document
-Student is able to list parts of document
-Student is able to process data into easy reading outputs
-Student is able to select proper font for document

Type of course unit:optional
Year of study:Not applicable - the subject could be chosen at anytime during the course of the programme.
Work placement:There is no compulsory work placement in the course unit.
Recommended study modules:none
Assessment methods:Student has to prepare text document and table calculations with chart according to predefined template on computer in two hours. Minimum is 50% of accomplished tasks.
 
Learning activities and study load (hours of study load)
Type of teaching methodDaily attendance
Direct teaching
     lecture14 h
     practice28 h
Self-study
     preparation for exam42 h
     elaboration of reports56 h
Total140 h

Basic reading list
  • COX, J. -- PREPPERNAU, J. Microsoft Office Word 2007 Step by Step. USA: Microsoft, 2007. 400 p. ISBN 0-7356-2302-3.
  • MICROSOFT, C. Word 2003 to Word 2007 command reference guides.  [online]. 2010. URL: http://office.microsoft.com/en-us/word-help/.
  • WALKENBACH, J. Excel 2007 Bible. USA: John Wiley, 2007. 300 p. ISBN 978-0-470-04403-2.
Recommended reading list
  • KNUTH, D E. Digital typography. Stanford: CSLI, 1998. 685 p. ISBN 1-57586-010-4.
  • FELICI, J. The complete manual of typography : a guide to setting perfect type. Berkeley, CA: Peachpit Press, 2003. 360 p. ISBN 0321127307.