Key words
Spreadsheet Applications IWETO-code: P175
Objectives
Knowledge:
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 independently and accurately with spreadsheets in the professional practice of for instance an environment official, an environment co-ordinator, …They must be able to make for instance analyses, …
Students will need the skills acquired through this course in other courses later in the programme, such as integrated cases.
Skills:
The student has to handle the package in a professional and efficient way. He also has to learn to solve problems. This is why the student needs to practice the discussed subject matters (theory and exercises) independently, thoroughly and regularly. Like this, he will be able to perform a given number of assignments within the given limit of time.
Competencies:
The student has to have a thorough command of the most important possibilities of a spreadsheet programme. He must also be able to expand his knowledge through documentation of the programme.
Topics
Spreadsheet-programs
Knowledge:
Repetition of the basic techniques of a spreadsheet under Windows, like for instance- Using formulae
- Laying out worksheets
- Printing
- Band names
- Basic functions (for example sum, average, maximum, minimum, number)
Working with 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 graphs
Further in-depth exploration:- In-depth study of functions: date and time functions, logical functions, financial functions, search functions, conceiting of functions,
- Links
- Elementary macros and hyperlinks
Job-related 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 the end of the 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:
General:
Job-related (general):
Job-related (specific):- Knowledge of calculation sheets, word processing, e-mail, internet and the possibilities of programmes concerning the field of profession
- Knowledge of both data processing and adjusting of data
Skills
General:- Thinking and reasoning power
- Working independently
Job-related (general):- Handling numerical data
- Make efficient use of the knowledge (for instance ICT)
- Operating the PC efficiently, with an eye on output
- Ability to think in an analytical and problem-solving way
- Thinking logically
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:
Job-related (general):
Job-related (specific):- Eagerness to work with numerical data
Materials used
- 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.
Estimated number of pages: about 400
Study guidance
- Monitoring and coaching students during guided self-study.
- Guidance is possible through the electronic learning environment
- 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.
Teaching Methods
Method of question-and-answer and seminar.
Guided and individual exercises on the computer.- Through the question-and-answer method, guided and individual exercises with the computer, the student will gain insight into the software.
- The lecturer will coach you during your guided self-study (concerning various exercises and assignments you have first 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 only enrolled for taking the exams: - First exam session: 100 % exam with practical application on the computer. Within the given time being able to carry out the given assignments correctly.
- 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)
|
|
