•   Advanced Use of Excel ANA002AS2AE-3002 19.08.2024-11.10.2024  5   (IBE5PASCM, ...) +-
    Learning objectives
    - 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
    Starting level and linkage with other courses
    Before completing this course, the student must know the basics of Excel.
    Contents
    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.
    Assessment criteria
    Assessment criteria - grade 1
    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.

    - 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
    Assessment criteria - grade 3
    - can apply a spreadsheet program appropriately
    - is able to find new solutions using Excel's functions in a versatile way
    Assessment criteria - grade 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
    Further information
    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.
    Teaching methods and instruction

    Study like you want, at your own pace based on the videos in the course, on-site in class or remotely online.

    Learning material and recommended literature

    All the material or the links to those are in Moodle.

    Working life connections

    The course is based on assignments that are based on teachers' over 20 years of work-life experience.

    Campus

    Pasila Campus

    Exam dates and re-exam possibilities

    No exams, some assignments are graded, and grading is based on those assignments.

    Teaching language

    English

    Internationality

    We are using English as the course language and the English version of Excel.

    Timing

    19.08.2024 - 11.10.2024

    Learning assignments

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

    Enrollment

    03.06.2024 - 16.08.2024

    Content scheduling

    8 weeks, assignments and lessons for every week.

    Groups
    • IBE5PASCM
    • IBE5PAMAR
    • IBE4PAACC
    • ITE2PAICB1
    • CONTACT
    • IBE4PASCM
    • BLENDED
    • IBE4PAMAR
    • IBE5PACOM
    • IBE5PAACC
    • EXCH
    Alternative learning methods

    - at your own pace based on the videos and guidance in the course,
    - on-site in class or
    - remotely online.

    Teachers

    Lauri Tapola, Ville Pennanen

    Seats

    15 - 45

    Further information

    Some of the assignments are graded.

    Degree Programme

    ITBBA Business Information Technology, INTBBA International Business

    R&D proportion

    0.00 cr

    Virtual proportion

    3.00 cr

    Evaluation scale

    H-5