Hogeschool Gent
Geraard de Duivelstraat 5 - 9000 Gent
Tel: 09 243 33 33 - E-mail: info@hogent.be
Website: www.hogent.be
Spreadsheet Applications (English language)34176/4114/1819/1/84
Study guide

Spreadsheet Applications (English language)

34176/4114/1819/1/84
Academic year 2018-19
Is found in:
  • International Curriculum, programme stage 1
This is a single course unit.
Study load: 3 credits
Weight: 3,00
Total study time: 75,00 hours
Possible deadlines for learning account: 01.12.2018 () or 15.03.2019 ()

Organisation of education

Teaching Activities, Learning Activities, Assessment Activities
Lecture
Self-study51,00 hours
Seminar24,00 hours
Supervised independent work
This course unit is marked out of 20 (rounded to an integer).
Re-sit exam: is possible.
Special admission is required to enrol in this course unit under
  • credit contract.
  • exam contract (to obtain a credit).
  • exam contract (to obtain a degree).
Co-ordinator: Mestdagh Barbara
Other teaching staff: De Man Harry, Mostien Cliff
Language course: No
Languages: Dutch
Scheduled for: Semester 1 or Semester 2

Objectives

Can apply basic Microsoft Excel techniques.
Can work with graphs in Microsoft Excel
Can work with data lists in Microsoft Excel
Can work with advanced functions and hyperlinks in Microsoft Excel
Can process, edit, analyze, present and interpret data in an Excel program

Contents

Working with tables: sorting, filteringWorking with data, formulas, functions, and range names
Format cells and worksheets
Printing
Working with tables: sorting, filtering
Charts
Pivot tables
Data Validation
Advanced features: date and time functions, logical functions, search functions, text functions, nesting functions

Order of enrolment

There are no prerequisites for this course.

Prerequisites

Final terms secondary school in Flanders

Final objectives

can work in a project-based manner and devise and carry out research step by step and in a professional manner

Teaching methods

  • Learning dialogue
  • Practice session

Study guidance

Individual learning problems can always be reported to the lecturer.

Evaluation

Evaluation(s) for first exam chance
MomentForm%Remark
PeriodicWritten examination100,00
Evaluation(s) for re-sit exam
MomentForm%Remark
PeriodicWritten examination100,00

Other study materials

Course material will be made available online (Chamilo)