AB-2-069

Yrkesstudier

Engelska

Obligatorisk

Yrkeshögskoleexamen

3

5 sp

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.

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.

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.

Module 1 or equivalent

To be announced later

Närundervisning

Essä, rapporter, produktioner och portfolio

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: ...

Björk Kaj-Mikael

Björk Kaj-Mikael

https://arcada.itslearning.com/

Ingen begränsning

12 månader efter kursens slutdatum

Datum meddelas senare - Rapporter och produktioner