Course syllabus 6MI102 - Informatics 2 (FMJH - WS 2009/2010)

Czech     English     

Course code:6MI102
Course title in language of instruction:Informatika 2
Course title in Czech:Informatika 2
Course title in English:Informatics 2
Mode of completion and number of credits:Exam ECTS (5 credits)
(One ECTS credit corresponds to 26 hours of workload for an average student.)
Type of course:
Language of instruction:Czech
Level of course and year of study:bachelor: 1
Semester:WS 2009/2010 - FMJH
Name of lecturer:Ing. Vladimír Přibyl (examiner, instructor, lecturer, supervisor)
Prerequisites:none
 
Aims of the course:This course is the second part of the basic course of informatics for bachelor students. The theoretical part of this course is focused on application of IS/ICT in enterprise management. It also describes the basic terms of information technology. The practical part is focused on effective working with spredsheet processor (MS Excel) preparing backgrounds for presentations.
Learning outcomes and competences:Upon successful completion of this course, students will be able to:

- effectively work with the data in spreadsheet processor (MS Excel)
- prepare graphical and text backgrounds for presentations
- prepare slidewshows in MS Powerpoint
- understand the terms of application of IS/ICT in enterprises
- understand the problems and methods of IS/ICT systems development and maintainance
Course contents:Theoretical part:

Data, information and knowledge
Data representation, coding
Structured versus Unstructured data
Information and communication technology
Hardware and software (software,communication systems principles,computer networks,computer networks services,security of information systems)

Enterpise informatics - content and resources
Types of information systems (ERP,CRM,SCM,ECM ...)
E-commerce
Enterprise IS/ICT management
Buseness intelligence (basic principles, application of BI)
Algorithm development (basic concepts, variables and their functions)

Practical part:

MS Excel:
The topics defined by the 4th module of the ECDL. It means:
modifying the application environment, making changes in workbooks and sheets, data inserting and editing, cells selecting, finding and replacing, data sorting,formulas, relative and absolute adressing, functions, formating cells (number/ date-time formats,content, alignment, borders), headers and footers, worksheet layout, working with sheets, diagrams and graphs, print layout
In addition these advance topics:
data processing (ranges, external data sources and importing, filtering, pivot tables)

Computer graphics, MS Powerpoint and presentations:
Bitmaps, vector graphics, MS Powerpoint (The topics defined by the 6th module of the ECDL), using audio and video files in presentations, publishing MS Office documents to WWW



Teaching methods and workload (hours of workload):

Type of teaching methodDaily attendanceCombined form
Participation in lectures26 h0 h
Attendance at seminars/workshops/tutorials26 h8 h
Preparation for seminars/workshops/tutorials0 h44 h
Preparation of term paper13 h13 h
Preparation for final test65 h65 h
Total130 h130 h


Assessment methods(weighing):
Requirement typeDaily attendanceCombined form
Final test100 %100 %
Total100 %100 %


Special requirements and details:

The final test consists of practical part (weight 50% and minimum is 70%) and theoretical part ( written test, weight 50% and minimum is 30%)


Recommended reading:
TypeAuthorTitlePublished inPublisherYearISBN
RGÁLA, L. -- TOMAN, P. -- POUR, J.Podniková informatikaPrahaGrada200680-247-1278-4
RKUNSTOVÁ, R.Informatika pro ekonomyPrahaVysoká škola ekonomická200280-245-0271-2
AKUNSTOVÁ, R.Užití kancelářských aplikacíPrahaOeconomica200480-245-0733-1
ANAVRÁTIL, P.Microsoft PowerPoint 2003 pro školy20058086686345
AKUBÁLEK, T. -- KUBÁLKOVÁ, M.MS Office XP - manažerská informatika. Prezentační program Microsoft Powerpoint, verze 2002 CZPrahaOeconomica200680-245-1017-0
APECINOVSKÝ, J.PowerPoint 2007PrahaGrada2007978-80-247-1960-3
ABŘÍZA, V.PowerPoint 2007 : podrobný průvodcePrahaGrada2007978-80-247-2178-1

Rrequired
Aadditional


Subject 6MI102 – Informatics 2 is to be found in the following study plans and groups:

FacultyProgramme, Field of study, SpecializationForm of studyTyp ss.GroupStudy period
FMJHB-EM-Mcomb.EoPWS 2005/2006
WS 2006/2007
WS 2007/2008
WS 2008/2009
WS 2009/2010
WS 2010/2011
pres.EoPWS 2005/2006
WS 2006/2007
WS 2007/2008
WS 2008/2009
WS 2009/2010
WS 2010/2011

Shown syllabus can be printed out by pressing the button mentioned below.

Last modification made by Ing. František Michl on 20. 5. 2009.


RSS exporty