Présentiel, premier quadrimestre, 39 heures de théorie.

Premier quadrimestre
le jeudi de 08:30 à 10:30
le lundi de 10:30 à 12:30

English

KULB1325A - Business information systems [1 Q. • 13 Th. • Pond. : 50] Claude Doom
KULB1325B - Data management [1 Q. • 26 Th. • Pond. : 50] Claude Doom

The courses within the domain of Business Science allow students to gain knowledge and develop competences in the following subjects: accounting, tax, finance and risk management, information management. Due to the importance of and the close link with knowledge of the legal system and the broader management perspective, these subjects are also integrated in the curriculum.
Business Information Management students build knowledge and skills in the following domains: ICT strategy, IT architecture and the design and use of ICT systems. Given the growth and importance of large business information systems that are able to register and process immense data sets, the use of ERP systems and Business Intelligence are also dealt with.
Students should have a basic theoretical and practical knowledge of information systems. They need to have the necessary knowledge about terminology and functionality, especially the use of IT in a business oriented context.Students are able to process business, scientific and administrative data by using office software, specifically with large amounts of data. They must be able to work with spreadsheets and database management systems.For spreadsheets there is a large integration of ICT applications in this and other courses. The student learns by practice to work in a problem -or application oriented context with the Office tools Excel (Spreadsheet) and Access (DBMS).For databases the students learns how to enquire and manipulate databases and, in simple cases, to design a new database. He is aware of the problems that may rise in doing so.
The competences to be attained are:
** The student is able to relate theory to practice
** The student contributes actively to a common result
** The student is able and willing to engage with others in a project that transcends self-interest
** The student is able to follow the discussion about developments within his/her own field of study and to assess social consequences
** The student reflects critically on the achievements and limitations of his/het own field of study
** The student has insight into the relations between various disciplines
** The student applies all principles of time-management
** The student is able to use information technology
** The student is able to solve business-related problems by means of adjusted IT tools
** The student has an insight into the working and the strategic importance of ICT management in an enterprise
** The student uses his/her knowledge of mathematics and statistics to asses gathered information in a critical way
The key objectives are:
** The student is able to explain the opportunities of IT application in typical business administration systems e.g. supply administration, human resource administration and order registration.
** The student is able to apply the principal user commands on a Personal Computer with a graphical user interface e.g. Windows, with regard to file management and multitasking.
** The student is able to look for information on the internet in a structured en efficient way. He understands the way in which information is put on the internet and how it is distributed.
** The student is able to solve problems of storage and retrieval of information at a user level with a database package. She/He must be able to construct tables, sort, make selective queries and design input forms and reports. She/He must master the principles of Query By Example and have an elementary knowledge of the SQL statement SELECT.

Pour le programme de Bachelier en ingénieur de gestion :

Pour le programme de Bachelier en sciences économiques et de gestion :

Aucun

Business information systems:
This part of the course consists of the following subjects:
** IT in a Business environment. We examine the relationship between the business and IT
** Operational systems. We discribe the different kinds of operational IT systems in a business environment.
** Management Information Systems. We discuss business intelligence and tactical systems supporting decision making.
** A framework for IT. We develop a framework to think about business information systems.
** The conception of IT systems. We discuss the first activities in the conception and design of information systems.
** IT architecture. We discuss frameworks and methodologies to develop an IT architecture.
** System development. We discuss methodologies and techniques to develop IT systems.
** Roll-out. What are the activities and issues when making a newly developed IT system operational.
** Operational management. We duscuss the activities to operationally support and maintain information systems.
** Decommissioning. When removing information systems there are specific issues that need to be handled.
** Information Management. We discuss frameworks and best practices in IT management.
** IT goverance. We discuss frameworks for IT governance, regulating the relationship between the business and IT.
 
Data management:
The data management part of this course trains the students in the following subjects:
** Relational Database Management Systems (RDBMS)
** Design and making use of tables
** Queries based on a single table
** Forms and reports based on one and on more related tables.
** The use of several tables
** Queries based on several tables
** Forms and reports based on several tables.
The students also learn to split tables in smaller parts in order to avoid data redundancy and data inconsistency. They learn to import data from other sources (spreadsheet, text file, internet), also in large amounts, and to process these data by means of a spreadsheet or a RDBMS. Doing so they learn to evaluate the pro's and con's, the strengths and weaknesses en de usability of software tools.

Business information systems:
Format: Lecture

Data management:
Format: Practical
There are two learning paths
1. Computer classes where the students are introduced tot the subjecs and can make exercises individually.
2. A group exercise where the students work in groups of five to eight students, solving more advanced exercises on database management.

Type : Exam during the examination period
Description of evaluation : Written
Type of questions : Open questions
Learning material : None
Explanation

The written exam consists of two kinds of questions:
1. Questions on the part "Business information systems" of this course. There are two questions requiring a brief answer (each on two points) and two questions requiring a more elaborate answer (each on three points). These questions are on a total of 10 points.
2. Questions on the part "Data management". These questions probe the knowledge and competences of the students on data management with databases. The questions will pertain to database tables (creation, modification, use), queries (creation, modification, correction), forms and reports (creation, modification, correction), using both single and several tables. These questions, for a total of 10 points, will be based on the database used in the group exercise and can refer to particular exercises contained in the group exercise. Good knowledge of the group exercise is essential to answer these questions successfully.
The evaluation methods during the first and second exam opportunities are identical.
Transfer of results to the next exam opportunity (but not to the next year) is possible. Students who obtain a 10/20 or more for the part "Business information systems" can transfer this result to the next exam opportunity (but not to the next year). Students who obtain a 10/20 or more for the part "Data management" can transfer this result to the next exam opportunity (but not to the next year).

http://public.hubrussel.be/Ancor/SSM/Pages/BekijkSSM.aspx?ACJ=2012&OID=2027

http://public.hubrussel.be/Ancor/SSM/Pages/BekijkSSM.aspx?ACJ=2012&OID=2028