Information Systems I: Introduction and Modelling [ECGEB110]
Learning outcomes
Thanks to this course, students will be able to:
- understand and manipulate the basic mechanisms of information systems
- model computational problems
- implement computational problems in a spreadsheet program such as Excel
- create and critique graphical illustrations
Objectives
The course is divided into four parts:
Part I - Information systems: components and typology
Main objective: to have a basic computer culture
Part II - Calculation models: Analysis, modelling and implementation
Main aim: to be able to model and use spreadsheets to solve calculation problems
Part III - Creating graphical illustrations with a spreadsheet program
Main aim: to be able to create and critique graphical illustrations
Part IV - Some important and/or topical themes in computer science
Main aim: to open up your curiosity about current words and themes.
Content
The first part of the course is designed to introduce students to the different functions and components of an information system, emphasising the notion of a system and the central role that information plays in organisations. The second part is dedicated to information processing, through the learning of rigorous methods of analysis, modelling and implementation of computational problems. The third part is devoted to the study of graphical illustrations of quantitative data, while the fourth part deals with various current themes linked to information and communication technologies.
Teaching methods
The course includes theoretical courses in the auditorium and procatical exercises in computers rooms.
The theoretical part of the course is given in the form of lectures with the possibility for students to ask questions during the inter-course or after the course. These lectures are illustrated by exercises and examples.
The part relating to the use of the Excel spreadsheet is given in small groups in the computer pools. The students know in advance the exercises that will be used as a basis for the sessions. They are therefore invited to think in advance about how to solve the problems posed. The sessions will alternate between two main types of activity:
Analysis of computational problems and development of a model for their solution; the assistants work with the students to answer their questions and help them to understand the problem and work towards the solution.
Implementation of the solution (model of a problem) using the Excel spreadsheet. The principles of implementing the models seen in the theory lessons are applied and the solution is built on the PC with the help of the assistants.
One session will also be devoted to developing and critiquing graphical illustrations.
Evaluations
Written exam (theory + modelling) and on computer (Excel).
Recommended readings
Jean-Luc HAINAUT, Bases de données et modèles de calcul (4e édition), Collection Sciences Sup, Dunod, Paris, Edition 4, 2005
The main reference is: Jean-Luc HAINAUT, Bases de données et modèles de calcul (4e édition), Collection Sciences Sup, Dunod, Paris, Edition 4, 2005. Other references are provided in the syllabus.
Other references are provided in the course material.
Language of instruction
French / FrançaisLocation for course
NAMUROrganizer
Faculté des sciences économiques, sociales et de gestionRue de Bruxelles, 61
5000 NAMUR
