Academic year
2017-18
Is found in:
- International Curriculum, programme stage 1
In other study programme:
-
Bachelor of Business Management as ICT I (English taught): (Partial module) Spreadsheet applications
-
Bachelor of Business Management as ICT I (English taught): (Partial module) Spreadsheet applications
-
Bachelor of Business Management as ICT I (English taught): (Partial module) Spreadsheet applications
This is a part of the course unit ICT.
Study load:
3 credits
Weight:
3,00
Total study time: 75,00 hours
Possible deadlines for learning account: 01.12.2017 () or 15.03.2018 ()
Organisation of education
This part of the course unit 'ICT' is marked out of 20 (rounded to an integer).
Re-sit exam:
- is possible.
- in the event of a fail mark for the composite course 'ICT', only the failed part(s) need(s) to be retaken.
Co-ordinator: Mestdagh Barbara
Other teaching staff: De Man Harry, Van Boven Geert
Language course: No
Languages: English
Scheduled for: Semester 1 or Semester 2
Objectives
The main aim is to enable students to use spreadsheet applications efficiently in professional surroundings. Students have to be able to work independently and accurately with spreadsheets.
Contents
1. Revision of basic techniques of a spreadsheet, i.e.:
- using formulas; basic functions and defined names
- layout of cells and worksheets
- printing
2. Charts
- making graphs
- laying out graphs
- formatting graphs
3. Tables
- making tables
- validation
- sorting
- filtering
- database functions
- pivot tables
4. Advanced functions
- in-depth study of functions: date and time, logic functions, search and text functions, nesting functions
- securing sheets and folders
- linking
- basic macros and hyperlinks
Prerequisites
Being able to use the basic possibilities of excel.
If students do not have any elementary knowledge of the basics of a spreadsheet, they will be recommended to enroll in the introduction to excel course.
Final objectives
1. Can work efficiently with the advanced functions of Microsoft Excel.
Indicators:
- can work efficiently with files, worksheets, cells, cell format (e.g. complex number formatting, alignment, conditional formatting); can secure files and sheets; use linked sheets and files;
- can work efficiently with data, formulas, functions and ranges;
- can make up and print large Excel files;
- knows how to efficiently use the help function;
- can present numerical information, statistics, graphs and figures (including choosing the most suitable presentation form or graph form; legends, axes);
- is able to analyze numerical information, statistics, graphs and figures;
- can work efficiently with large sets of data, using tables, validation, sorting, filters (auto filtering and advanced filtering), database functions, subtotals and pivot tables; formula with nested if and vertical lookup functions;
- can use time and date functions; logical functions; nested functions;
- knows houw to efficiently process information, and convert data between word processing, spreadsheet, database and html programs and formats;
- has a basic knowledge of macros, is able to use macros (i.e. record and run a macro). Is able toe make elementary changes to the VBA of a self-made macro;
- is able to carry out a number of exercises in Excel within a given deadline.
2. Is able to professionally use Excel to analyse and interpret data, to solve complex business problmes and report on them.
Indicators:
- use the possibilities of Excel when composing large spreadsheets;
- can analyze, process and interpret numerical information, statistics, graphs and figures;
- is able to work analytically and with an eye for problem-solving.
| Evaluation
- First exam opportunity:
- non-period bound evaluation: 20%
- period bound evaluation: 80% exam on computer, withe assignments to be finished within given deadline
- Second exam session:
- 100% exam on computer, with assignments to be finished within given deadline