• Effective Utilization of Spreadsheet Computation (HL00BD63-3005),
         29.08.2022 – 15.05.2023,  5 cr  (HTL21S1, ...) — Online learning +-
    Learning outcomes of the course
    The object of the course
    Once you have completed the course, you have the essential information on the possibilities and benefits of spreadsheet computation related to your field of studies.

    Course competencies
    Learning to learn
    Operating in a workplace
    Business competence

    The learning objectives of the course
    After this course, you will know the advanced features of the spreadsheet computation and you will be able to take advantage of them in studying and working life.
    You recognise the strengths and development areas of your competence and learning methods.
    Prerequisites and co-requisites
    Basics of Spreadheets computation: functions, charts, cell references.
    Course contents
    Spreadsheet computation: editing features, checking formulas, using printing range, references in tables and between them, functions facilitating calculation, sorting functions of large tables, macros, Pivot, Power Pivot.
    Assessment criteria
    Assessment criteria - grade 1 and 2
    Sufficient 1
    You recognize the principles of effective working with a spreadsheet program and you can use the tools with instruct.

    Satisfactory 2
    You understand the main principles of the advanced features of the spreadsheet, and you can use your skills in different kind of situations independently.
    Assessment criteria - grade 3 and 4
    Good 3
    You understand the possibilities of using the spreadsheet program as an effective tool. You can apply your skills in different kind of situations.

    Very good 4
    You master possibilities for using the spreadsheet program as an effective personal tool. You know how to apply your skills to different spreadsheet computing situations. You can justify your choices and decisions.
    Assessment criteria - grade 5
    Excellent 5
    You have the critical knowledge of the spreadsheet program, and you can apply your skills in developing new innovative applications in work. You justify your choices and decisions.
    Further information
    macin käyttäjille suositellaan joidenkin tehtävien tekemiseen etäyhteyttä: remote.jamk.fi (not translated)
    Language of instruction

    Finnish

    Planned learning activities, teaching methods and guidance

    Assignments and Learning tasks are in an online learning environment (Moodle). Feedback of the assignments is given as comments in the online learning environment. Studying requires the student to be self-directed.

    Learning materials and recommended literature

    General learning material can be found in Microsoft Office tutorials.

    Lecturer(s)

    Päivi Hänninen-Pihlajamäki

    Working life cooperation

    You can do the assignments in practical training or to your workplace.

    Campus

    Main Campus

    Exam dates and re-exam possibilities

    No exams. The course ends 15.5.2023.

    Timing

    29.08.2022 - 15.05.2023

    Learning assignments and student workload

    Online studies and tasks 135 h:

    Reading materials 30 h
    Learning tasks 55 h
    Assignments 50 h

    Enrollment

    01.08.2022 - 31.03.2023

    Content scheduling

    In the course, you should first complete the first tasks and then so-called final assignments. Tasks and assignments are done at your own pace.
    Nonstop, online 30.8.2022 - 15.5.2023.

    Groups
    • HTL21S1
    • ZJA23KH
    • ZJA22SH
    • HTL21SIY
    • HTLDIG
    Alternative learning methods

    Recognition of Prior Learning and Experience: Accreditation, Recognition of informal learning, Studification
    More information in the degree regulations and the study guide.

    Seats

    0 - 100

    Assessment methods

    Feedback of the assignments is given as comments in the online learning environment.

    Degree Programme

    Bachelor's Degree Programme in Business Management

    Mode of delivery

    Online learning

    Share of virtual studies

    5 cr

    Credits
    • 5 cr
    Unit

    School of Business