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)33820/4419/2021/1/87
Study guide

Spreadsheet Applications (English language)

33820/4419/2021/1/87
Academic year 2020-21
Is found in:
  • Bachelor of Business Management, programme stage 1
    Specialisation:
    • SME-Management and Entrepreneurial Studies
In other study programme:
  • Bachelor of Business Management as Spreadsheet Applications (Dutch language)
  • Bachelor of Business Management as Spreadsheet Applications (Dutch language)
  • Bachelor of Business Management as Spreadsheet Applications (Dutch language)
  • Bachelor of Business Management as Spreadsheet Applications (Dutch language)
  • Bachelor of Business Management as Spreadsheet Applications (Dutch language)
  • Bachelor of Business Management as Spreadsheet Applications (Dutch language)
  • Bachelor of Business Management as Spreadsheet Applications (Dutch language)
  • Bachelor of Business Management as Spreadsheet Applications (Dutch language)
  • Bachelor of Business Management as Spreadsheet Applications (Dutch language)
  • Bachelor of Business Management as Spreadsheet Applications (Dutch language)
  • Bachelor of Business Management as Spreadsheet Applications (Dutch language)
  • Bachelor of Business Management as Spreadsheet Applications (Dutch language)
This is a single course unit.
Study load: 3 credits
Weight: 3,00
Total study time: 75,00 hours
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
Languages: English
Scheduled for: Semester 1 or Semester 2

Final objectives

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

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

Organisation of education

Contactonderwijs24,00 hours

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
Inside Regular exam scheduleWritten examination100,00
Evaluation(s) for re-sit exam
MomentForm%Remark
Inside Regular exam scheduleWritten examination100,00
This course unit is marked out of 20 (rounded to an integer).
Re-sit exam: is possible.

Other study materials

Course material will be made available online (Chamilo)

Prerequisites

Final terms secondary school in Flanders
Possible deadlines for learning account: 01.12.2020 () or 15.03.2021 ()