Key words
Spreadsheet applications, P 175 Informatics
Objectives
This course aims at making students familiar with spreadsheets. Emphasis is put on an efficient use of the software in economic applications. Students have to work with spreadsheets independently and accurately in the professional practice of for example the insurance agent, the bank clerk, … .
They must be able to make instalment tables, to manage lists, to construct formulae in order to calculate financial ratios, ….
Students will need the skills acquired through this course in other courses later in the programme, such as financial analysis, etc.
Topics
Revision of basic techniques of a spreadsheet under Windows, such as- Using formulae
- Laying out worksheets
- Printing
- Band names
- Basic functions ( for example sum, average, max, min, number)
Handling graphs- Making graphs
- Making up graphs
Managing lists- Drawing up lists
- Sorting
- Filtering lists
- Database functions
- Subtotals
- Rotation graphs
In-depth study- In-depth study of functions : date and time functions, logical functions, financial functions, search functions …
- Links
- Elementary macros and hyperlinks
Prerequisites
Being able to make efficient use of the possibilities of the operating system most in demand and having basic keyboard skills.
Elementary knowledge of the basic techniques of a spreadsheet is recommended. There will be a test to detect the level of the basic competencies and in the first weeks there will be individual tuiton.
If a student does not have elementary knowledge of the basic techniques of a spreadsheet he is recommended to take a bridging course 'Introduction to Excel'.
Final Objectives
Knowledge:
Job-related (general)- Calculation sheets
- Basic knowledge of statistics and graphs
Job-related (specific)- Knowledge of calculation sheets and the possibilities of spreadsheets relating to certain professions
Skills
General:- Thinking and reasoning power
- Working on one's own
·Job-related (general)- Dealing with figures
- Operating the PC efficiently
- Thinking analytically and with a view to solving problems
- Thinking logically
- Having insight in complex situations
- Being creative
- Being able to handle software packages (the most recent )
Job-related (specific)- Drawing up calculation sheets knowing the calculations
- Being able to deal with figures financially
- Being able to compute the financial consequences of different methods
Attitudes
General- Being precise and accurate
Job-related (general)
Materials used
- Syllabus with practical exercises.
- Lessons available through the internal network may copied onto CD-rom.
- PC with Office-software; students may operate computers after the lessons.
Study costs
Syllabus : unit price determined under hogeschool rules ( around 300 pages).
Study guidance
At the beginning of the course there will be a test to detect the level of the basic competencies and in the first weeks there will be individual tuiton.
Monitoring and coaching students during guided self-study.
Lecturers are available for questions through their email address.
Teaching Methods
Question-and-answer method, guided and individual exercises with the computer.
The lecturer will coach you during guided self-study.
Assessment
- First exam session: 80 % exam with practical application on the computer - 20 % continuous assessment.
- Second exam session: 100 % exam with practical application on the computer.
-
Examination Board Flemish Community: first and second exam session: 100 % exam with practical application on the computer
Lecturer(s)
|
|
