Kursens undervisningsperiod

1 (2020-08-01 till 2020-10-25)

Nivå/kategori

Yrkesstudier

Undervisningsspråk

Engelska

Kurstyp

Obligatorisk

Cykel/nivå

Yrkeshögskoleexamen

Rekommenderat studieår

3

Omfattning

5 sp

Kompetensmål

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.

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

Module 1 or equivalent

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.
(examinationer = tentamina, demonstrationer och
presentationer, rapporter och produktioner,
uppsatser, samt närvaro vid angivna tillfällen)

Examinationerna väger sinsemellan på följande
sätt: ...

Lärare

Björk Kaj-Mikael

Examinator

Björk Kaj-Mikael

Antal kursplatser

Ingen begränsning (41 studenter anmälda)

Delprestation i kraft till

12 månader efter kursens slutdatum

Kursanmälningstid

2020-05-18 till 2020-09-01

Examinationsformer

Datum meddelas senare - Rapporter och produktioner

Rumsbokningar
Datum Tid Rum Titel Beskrivning Organisatör
2020-09-03 09:45 - 13:45 Business Data Modelling bjorkpau@arcada.fi is inviting you to a scheduled Zoom meeting. Join Zoom Meeting https://arcada.zoom.us/j/63537045921?pwd=YS9sazlWN3l3cTBMR2c5bU5GUTFGQT09 Meeting ID: 635 3704 5921 Passcode: BM Join by SIP 63537045921@109.105.112.236 63537045921@109.105.112.235 Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 635 3704 5921 Passcode: 401614 Björk Kaj-Mikael
2020-09-10 08:30 - 12:00 Business Data Modelling bjorkpau@arcada.fi is inviting you to a scheduled Zoom meeting.   Join Zoom Meeting https://arcada.zoom.us/j/64156750280?pwd=RDVZdnc3eG84bnBHZEY5THpxdm9UUT09   Meeting ID: 641 5675 0280 Passcode: BM   Join by SIP 64156750280@109.105.112.236 64156750280@109.105.112.235   Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 641 5675 0280 Passcode: 950744   Björk Kaj-Mikael
2020-09-17 08:30 - 12:30 Business Data Modelling bjorkpau@arcada.fi is inviting you to a scheduled Zoom meeting.   Join Zoom Meeting https://arcada.zoom.us/j/66497385056?pwd=K240SVBUbHduVjdWbkQvYlJrT2RYdz09   Meeting ID: 664 9738 5056 Passcode: BM   Join by SIP 66497385056@109.105.112.236 66497385056@109.105.112.235   Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 664 9738 5056 Passcode: 054992   Björk Kaj-Mikael
2020-09-24 12:00 - 16:00 Business Data Modelling bjorkpau@arcada.fi is inviting you to a scheduled Zoom meeting.   Join Zoom Meeting https://arcada.zoom.us/j/61993851603?pwd=ZmJlZmd2SXZWUHJGckpRMVZEZ3UwUT09   Meeting ID: 619 9385 1603 Passcode: BM   Join by SIP 61993851603@109.105.112.236 61993851603@109.105.112.235   Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 619 9385 1603 Passcode: 702563   Björk Kaj-Mikael
2020-10-01 12:00 - 16:00 Business Data Modelling bjorkpau@arcada.fi is inviting you to a scheduled Zoom meeting.   Join Zoom Meeting https://arcada.zoom.us/j/68659014196?pwd=aWVMenpjTWNmSUV5Znk5ZlNOam9odz09   Meeting ID: 686 5901 4196 Passcode: BM   Join by SIP 68659014196@109.105.112.236 68659014196@109.105.112.235   Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 686 5901 4196 Passcode: 860654   Björk Kaj-Mikael
2020-10-08 12:00 - 16:00 Business Data Modelling bjorkpau@arcada.fi is inviting you to a scheduled Zoom meeting.   Join Zoom Meeting https://arcada.zoom.us/j/67306605657?pwd=RHFUS1EzUFZRSks1OUwzR2FTR1ZRUT09   Meeting ID: 673 0660 5657 Passcode: BM   Join by SIP 67306605657@109.105.112.236 67306605657@109.105.112.235   Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 673 0660 5657 Passcode: 976291   Björk Kaj-Mikael
2020-10-13 08:30 - 12:30 Business Data Modelling bjorkpau@arcada.fi is inviting you to a scheduled Zoom meeting.   Join Zoom Meeting https://arcada.zoom.us/j/61531246025?pwd=SlZtSHNsODNWNkkyMUhXTWRzOHQyQT09   Meeting ID: 615 3124 6025 Passcode: BM   Join by SIP 61531246025@109.105.112.236 61531246025@109.105.112.235   Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 615 3124 6025 Passcode: 816190   Björk Kaj-Mikael
2020-10-21 12:00 - 16:00 Business Data Modelling bjorkpau@arcada.fi is inviting you to a scheduled Zoom meeting.   Join Zoom Meeting https://arcada.zoom.us/j/65334409431?pwd=c0FiWFFIYWRZdFRRVkZEbmw5YnNNZz09   Meeting ID: 653 3440 9431 Passcode: BM   Join by SIP 65334409431@109.105.112.236 65334409431@109.105.112.235   Join by H.323 109.105.112.236 109.105.112.235 Meeting ID: 653 3440 9431 Passcode: 076838   Björk Kaj-Mikael

Kurs och studieplanssökning