Academic year
2016-17
Is found in:
- International Curriculum, programme stage 1
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.2016 () or 15.03.2017 ()
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: Vermeulen Steven
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
Revision of basic techniques of a spreadsheet under windows, i.e.:
- Using formulas
- Layout of worksheets
- Printing
- Defined names
- Basic functions (sum, average, maximum, minimum, total)
- Charts:
- Making graphs
- Laying out graphs
- Formatting graphs
- Tables:
- Making tables
- Validating
- Sorting
- Filtering (automatic and advanced)
- Database functions
- Subtotals
- Pivot tables
- Advanced functions:
- In-depth study of functions: date and time, logic, search, nesting functions
- Securing sheets and folders
- Linking
- Basic macros and hyperlinks
Prerequisites
Having an elementary knowledge of the basics of a spreadsheet is recommended If students do not have any elementary knowledge of the basics of a spreadsheet, they will be recommended to enrol in the Introduction to Excel course.
Final objectives
1 Using Microsoft Excel efficiently.
Indicators:
- Knowing the basic terminology of spreadsheets: files, worksheets, cells, functions
- Using the help function Inputting and copying of data and formulae
- Making and copying worksheets
- Making series, working with range names, etc.
- Knowing several ways to put in worksheet functions and knowing the names of widely used worksheet functions.
- Formatting cells (e.g. complex number formatting, alignment, conditional formatting).
- Knowing the possibilities of Microsoft Excel concerning printing and being able to use them to print out large worksheets in a neatly arranged way (e.g. fit, print titles).
- Analysing figures using graphs:
- Drawing up charts (series of data and items, legend, axes)
- Adapting charts (adding series of data and items, changing type of graph)
- Being able to work with tables in Excel: making tables, validation, sorting, filtering (auto filtering and advanced filtering), database functions, subtotals and pivot tables.
- Securing and sheets and files.
- Using linked sheets and files.
- Making calculations with dates and times.
- Making hyperlinks and turning sheets into HTML.
- Using date and time functions, logic functions, search functions when solving administrative problems.
- Drawing up complex formulae, e.g. a formula with nested if and vertical lookup functions.
- Having a basic knowledge of macros.
- Being able to use macros (i.e. record a macro and running a macro).
- Making elementary changes to the VBA code of a self-made macro.
- Being able to do an amount of exercises in Excel within a given deadline.
2 Using Excel to analyse and interpret data, to solve complex business problems and reporting on them.
Indicators:
- Using the possibilities of Excel when composing large spreadsheets.
- Analysing, processing and interpreting figures.
- Being able to work analytically and with an eye for problem-solving.
Organisation of education
Lectures (question-and-answer method), guided and individual exercises.
The lecturer will coach you during your guided self-study (various exercises and assignments to be prepared individually).
Study guidance
Coaching students (guided self-study).
Lecturers can be reached by e-mail.
Evaluation
- First exam oppertunity:
- non-period bound evaluation: /
- period bound evaluation: 20% continuous assessment, 80% exam using the computer to be finished within given deadline
- Second exam oppertunity:
- 100% exam using the computer, assignments to be finished within given deadline