•   Advanced Use of Excel ANA002AS2AE-3004 20.05.2024-30.08.2024  5   (EVENING, ...) +-
    Osaamistavoitteet
    - recognize the possibilities of spreadsheet calculation
    - identify the possibilities of using the Excel program in working life
    - knows how to use the Excel program versatilely and effectively
    - knows how to choose appropriate ways from the functions offered by the Excel program
    Lähtötaso ja sidonnaisuudet muihin opintojaksoihin
    Before completing this course, the student must know the basics of Excel.
    Sisältö
    Functions and calculations versatilely; rounding, search, lookup, time.
    Pivots and utilization of it.
    Forms and templates
    Basics of using macros and Visual Basic.
    Data refining - data to support decision-making.
    Arviointikriteerit
    Arviointikriteeri - arvosana 1
    - knows the basic use of the program and copes with the assigned tasks helpfully
    - can apply the features of the program independently to a small extent
    Arviointikriteeri - arvosana 3
    - can apply a spreadsheet program appropriately
    - is able to find new solutions using Excel's functions in a versatile way
    Arviointikriteeri - arvosana 5
    - can apply the program versatilely to practical situations
    - have strong skills and reliable competence
    - is able to independently find new and effective solutions and use the versatile possibilities of Excel
    Lisätiedot
    The course materials do not fully support Mac users. Mac users may work through vdi.
    Note! The software must be installed on the machine, OnlineExcel is not enough.

    When the implementation type of the course is contact, online or blended it is required that the student is present during those teaching hours that are marked in the study schedule. If you are absent more than 25 %, your grade will be lowered by one. If you are absent more than 50 %, the course is failed.
    Opetusmenetelmät ja ohjaus

    Study at your own pace based on the videos in the course.
    Voluntary EVENING ONLINE lessons: twice in May and once in August.
    Online lessons:
    - Monday 20.5.2024 17-20
    - Monday 27.5.2024 17-20
    - Monday 12.8.2024 17-20

    Oppimateriaali ja suositeltava kirjallisuus

    Material and links to be shared in Moodle.

    Työelämäyhteydet

    practical usage of Excel in working life.

    Toimipiste

    Pasila Campus

    Tenttien ajankohdat ja uusintamahdollisuudet

    no exams.

    Opetuskieli

    Englanti

    Kansainvälisyys

    in English with English version of Excel.

    Ajoitus

    20.05.2024 - 30.08.2024

    Oppimistehtävät

    The assignments are practical and useful, skills taught are important to manage in work-life.

    Ilmoittautumisaika

    23.01.2024 - 17.05.2024

    Aikataulu

    starting 20.05.2024 and ending 31.08.2024.

    Ryhmä
    • EVENING
    • BLENDED
    • SUMMER
    • ONLINE
    Toteutuksen valinnaiset oppimistavat

    - at your own pace based on the videos and guidance in the course
    - remotely online
    - RPL.

    Opettaja

    Lauri Tapola

    Paikkoja

    15 - 60

    Arviointitavat

    Some of the assignments are graded. Grade is based on the quality of the assignments.

    Koulutus

    ITBBA Business Information Technology, INTBBA International Business

    T&K-osuus

    0.00 op

    Virtuaaliosuus

    3.00 op

    Arviointiasteikko

    H-5