Business Informatics

Exam number: 1211

Semester: from 1st semester (Grundlagenausbildung)

Duration of the module: One semester

Form of the module (i.e. obligatory, elective etc.): Obligatory

Frequency of module offer: Each winter semester

Prerequisites: IBA-Bachelor-Students and Foreign Exchange Students ONLY!

Applicability of module for other study programmes:
Obligatory or elective in other study programmes. For further information check regulations of the study programme.

Person responsible for module: Prof. Dr. Achim Koberstein (until winter semester 2013/14: Prof. Dr. Karl Kurbel)

Name of the professor: Prof. Dr. Achim Koberstein (until winter semester 2013/14: Prof. Dr. Karl Kurbel)

Language of teaching: English

ECTS-Credits (based on the workload): 6

Workload and its composition (self-study, contact time):
Contact time (lecture, tutorials etc.) 45 h; self-study: 135 h

Contact hours (per week in semester): 4

Methods and duration of examination:
Successful written exam (120 min)

Emphasis of the grade for the final grade: Please check regulations of the study programme

Aim of the module (expected learning outcomes and competencies to be acquired):
Students learn to use up-to-date tools and methods for business information processing in the Internet age.

Contents of the module:
Major topics include end-user tools such as spreadsheets (MS Excel) and database management systems (MS Access) as well as basic methods for problem-solving with these tools. Business information systems (e.g. Enterprise Resource Planning), the Internet and the World Wide Web (WWW) and creating websites are also explained. Some programming fundamentals needed for these purposes are discussed. The major languages extending the above end-user tools are VBA (Visual Basic for Applications) and SQL (Structured Query Language).
Outline:
1 Introduction to Business Informatics
1.1 Business information and communications systems
1.2 Electronic Commerce
2 Working with spreadsheets
2.1 Fundamental concepts
2.2 Microsoft Excel
3 Databases
3.1 Data modeling
3.2 Database management systems (DBMS)
3.3 SQL (Structured Query Language)
4 Internet, web servers and clients

Teaching and learning methods:
Lectures are accompanied by tutorials and homework assignment. As a student you are expected to solve the exercises given as assignment by yourself, usually by computer. PC pools are available in the seminar building August-Bebel-Strasse 12. You may also use your own PC if you have one.

Literature (compulsory reading, recommended literature):
t.b.a. in the lecture

Further information:
Registration in Moodle Viadrina required.