Kursens undervisningsperiod

1 (2022-08-01 till 2022-10-23)

Nivå/kategori

Yrkesstudier

Undervisningsspråk

Engelska

Kurstyp

Obligatorisk

Cykel/nivå

Yrkeshögskoleexamen

Rekommenderat studieår

3

Omfattning

5 sp

Kompetensmål

Competencies
Within this study unit we will focus on the
following competencies:
The aim of the course is that the student knows
how to handle data and use calculation programs
like MS Excel for both basic and more challenging
operations in order to gain to more digital
competencies.

SDGs in focus:
1 NO POVERTY
4 QUALITY EDUCATION
8 DECENT WORK AND ECONOMIC GROWTH
10 REDUCED INEQUALITIES
12 RESPONSIBLE CONSUMPTION & PRODUCTION

Läranderesultat

The student should be able import and
manipulate data in Excel, and use functions as
IF, nested IF, VLOOKUP and HLOOKUP functions in
Excel. He/She should also be able to use Advanced
Graphing and Charting and Filtering and basic data
base functions. The student should also understand
the structure of different kinds of data and how
to use statistical tools in Excel.

Innehåll

Introduction to several functions in Excel like
LOOKUP, IF-functions, as well as Data filtering
in Excel and knowhow in the construction of
Pivot Tables to organize data. Also using
advanced chart options will be gone through as
well as statistical
tools from Excel. A walk-
through of logical operators is done.

Förkunskaper

20 credits completed from the subject module.

Kursen ersätter följande kurser

No previous course

Mer information

to be announced later

Litteratur

To be announced later

Studieaktiviteter

  • Föreläsningar - 20 timmar
  • Praktiska övningar - 20 timmar
  • Projekt- och produktionsarbete/konstnärlig verksamhet - 95 timmar

Arbetsbelastning

  • Kursens totala antal arbetstimmar: 135 timmar
  • Varav självstyrda studieformer: 135 timmar
  • Varav schemalagda studier: 0 timmar

Undervisningsform

Närundervisning

Examinationsformer

Essä, rapporter, produktioner och portfolio

Examinationskrav

To pass the course the student must participate

and do the assignments given during the course.

There is no written exam in the course.

Minimum 50 points of 100 points is

required

Lärare

Björk Kaj-Mikael

Examinator

Björk Kaj-Mikael

Antal kursplatser

Ingen begränsning (40 studenter anmälda)

Delprestation i kraft till

12 månader efter kursens slutdatum

Kursanmälningstid

2022-08-10 till 2022-08-25

Examinationsformer

Datum meddelas senare - Rapporter och produktioner

Rumsbokningar
Datum Tid Rum Titel Beskrivning Organisatör
2022-08-30 08:15 - 12:15 E385 Business Data Modelling Björk Kaj-Mikael
2022-09-06 08:15 - 12:15 E385 Business Data Modelling Björk Kaj-Mikael
2022-09-13 08:15 - 12:15 E385 Business Data Modelling Björk Kaj-Mikael
2022-09-20 08:15 - 12:15 E385 Business Data Modelling Kaj-Mikael Björk is inviting you to a scheduled Zoom meeting. Join Zoom Meeting https://arcada.zoom.us/j/63741281546?from=addon Meeting ID: 637 4128 1546 Join by SIP 63741281546@109.105.112.236 63741281546@109.105.112.235 Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 637 4128 1546 Björk Kaj-Mikael
2022-09-27 08:15 - 12:15 E385 Business Data Modelling Björk Kaj-Mikael
2022-10-04 08:15 - 12:15 E385 Business Data Modelling Björk Kaj-Mikael
2022-10-11 08:15 - 12:15 E385 Business Data Modelling Björk Kaj-Mikael
2022-10-18 08:15 - 12:15 Business Data Modelling Kaj-Mikael Björk is inviting you to a scheduled Zoom meeting. Join Zoom Meeting https://arcada.zoom.us/j/63422566498?from=addon Meeting ID: 634 2256 6498 Join by SIP 63422566498@109.105.112.236 63422566498@109.105.112.235 Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 634 2256 6498 Björk Kaj-Mikael

Kurs och studieplanssökning