SPREADSHEET APPLICATIONS
 
Lectured in 1st year Bachelor in business studies - Main Subject: Legal Practise
Theory [A] 0.0
Exercises [B] 25.0
Training and projects [C] 12.5
Studytime [D] 100
Studypoints [E] 4
Level in-depth
Language of instruction Dutch
Lecturer Petra FERYN
Reference RCBMGR01A00012
 
Key words
Spreadsheet applications, P175 applied informatics - Excel

Objectives
This course should make students familiar with spreadsheets.
Special emphasis is on the most efficient use of this software in business economics.
Students need to be able to work independently and accurately with spreadsheets in a lawyer's context, a notary's, a bailiff's, for the registry or the judicial police …
They should be able to manage lists, using formulae to calculate wages and expenses claims.

Topics
Reviewing the basic technique for a spreadsheet under Windows, i.al.
  • Using formulae
  • Laying out worksheets
  • Printing
  • Range names
  • Elementary functions (e.g. sum, average, max, min, number, number arg)
Working with graphs
  • Making graphs
  • Laying out graphs (data series and -points, titles, legend, axes, text fields …)
  • Adapting graphs (adding and removing data series, changing type of graph, …)
Managing lists
  • Making lists
  • Validation
  • Sorting
  • Filtering lists (automatic filters, extended filters)
  • Database functions
  • Subtotals
  • Pivot tables
In-depth study
  • In-depth study of functions: date and time functions, logical functions, search functions, nesting functions
  • Links
  • Elementary macros and hyperlinks


Prerequisites
  • Being able to make efficient use of standard capabilities of the operating system and having basic keyboard skills (acquired at the and of the Communication Skills course).
  • Elementary knowledge of the basic techniques of a spreadsheet is recommended. There will be a test to detect the level of basic skills so differentiation will be possible in the first few weeks and arrears can be mended.
  • If a student does not have elementary knowledge of basic spreadsheet techniques, it is strongly advised to take the bridging course 'Introduction to Excel'.


Final Objectives
Knowledge:
General and job-related:
  • Spreadsheets
  • Basic knowledge of statistics and graphs
Job-related:
  • Knowledge of calculation sheets and the possibilities of spreadsheets relating to the professional field
Skills:
General and job-related:
  • Spreadsheets
  • Basic knowledge of statistics and graphs
Job-related:
  • Knowledge of calculation sheets and the possibilities of spreadsheets relating to the professional field
Skills:
General and job-related:
  • Thinking and reasoning power
  • Working on one's own
General and job-related:
  • 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 in the professional field).
Job-related:
  • Drawing up calculation sheets knowing the calculations
  • Being able to deal with numerical information from the judicial field
  • being able to compute the financial consequences of different approaches
Attitudes:
General:
  • Meticulousness
General and job-related
  • Critical attitude


Materials used
  • Syllabus with practical exercises available through the school's course service
  • Lessons available on the internal network, Dokeos platform
  • PC with Office-software; outside classes, students may train on computers in the students' computer room


Study costs
Course book at market price (approx. 300 p.)

Study guidance
  • At the beginning of the course there will be a test to detect the level of basic spreadsheet skills and in the first weeks there will be a differentiated approach.
  • Monitoring and coaching students during guided self-study.
  • Coaching by means of the electronic learning environment.


Teaching Methods
  • Question-and-answer method, guided and individual exercises on the computer.
  • The lecturer will coach you during guided self-study.


Assessment
  • First exam session: 20 % continuous assessment, 80 % exam with practical execution on the computer, executing the tasks correctly within the time frame.
  • Second exam session: 100 % exam with practical execution on the computer, executing the tasks correctly within the time frame.
Students registered for the examinations only:
  • First exam session: 100 % exam with practical execution on the computer, executing the tasks correctly within the time frame.
  • Second exam session: 100 % exam with practical execution on the computer, executing the tasks correctly within the time frame.


Lecturer(s)