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. They must be able to make debit notes and 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, budgeting, ...
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 (for instance data and marks series, legend, axis, text sections, …)
- Adjusting graphs (for instance adding or erasing data series, changing types of graphs, …)
Managing lists- Drawing up lists
- Validation
- Sorting
- Filtering lists (automatic filter, expanded filters)
- Database functions
- Subtotals
- Rotation graphsIn-depth study
- In-depth study of functions : date and time functions, logical functions, financial functions, search functions, conceiting of functions, …
- Links
- Elementary macros and hyperlinks
Group-oriented exercises and cases
Prerequisites
- Being able to make efficient use of the possibilities of the operating system most in demand and having basic keyboard skills (competencies at end of course Communication 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. The first weeks will be differentiated and possibly delay with certain students can be eliminated.
- 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 (see topics)
Skills:
General:- Thinking and reasoning power
- Working on one's own
Job-related (general):- Dealing with figures
- Operating the PC efficiently, with an eye on output
- 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 ones concerning the profession)
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
::Click here for additional information::
- Syllabus with practical exercises (available at the service for courses)
- Lessons available through the internal network may be copied onto CD-rom in class
- PC with Office-software; students may operate computers after the lessons.
Study costs
Syllabus: unit price determined under Hogeschool rules, around 300 pages.
Medium to store
Costs related to performing of assignments.
Study guidance
- A test at the beginning of the course will determine the level of the basic competencies concerning spreadsheets, so that it is possible to work differentiated in the first weeks
- Monitoring and coaching students during guided self-study.
- Lecturers are available for questions through their email address.
Teaching Methods
- Through question-and-answer method, guided and individual exercises with the computer you understand the software.
- The lecturer will coach you during your guided self-study (various exercises and assignments that you prepared independently)
Assessment
- First exam session: 80 % exam with practical application on the computer, being able to carry out the given assignments correctly within the given time and 20 % continuous assessment.
- Second exam session: 100 % exam with practical application on the computer. Within the given time being able to carry out the given assignments correctly.
- Students who only register to take examinations:
first and second exam session: 100 % exam with practical application on the computer. Within the given time being able to carry out the given assignments correctly.
Lecturer(s)
|
|
