Siirry suoraan sisältöön

Excelin tehokäyttö (3 cr)

Code: LX00BE84-3010

General information


Enrollment

15.04.2020 - 10.05.2020

Timing

11.05.2020 - 12.06.2020

Number of ECTS credits allocated

3 op

Mode of delivery

Contact teaching

Unit

Liiketalous

Campus

Leiritie 1

Teaching languages

  • Finnish

Seats

20 - 35

Degree programmes

  • Liiketalouden tutkinto-ohjelma
  • Degree Programme in European Business Administration
  • Degree Programme in International Business and Logistics

Teachers

  • Marko Kosonen

Teacher in charge

Anne Perkiö

Groups

  • LITO_VV
    Vapaastivalittavat, liiketalous

Objective

On completion of the course the student will be able to apply advanced spreadsheet in reporting and business information analysis.

Content

- Decision support and spreadsheets
- Database and analysis operations
- Data source connections
- Powerpivot
- Solving optimization problems
- Advanced charting
- Functions and macros

Location and time

Luennot (Zoom) ja harjoitukset.

Luennot:

Ma 18.5.2020 17.00 - 20.45
Ke 20.5.2020 17.00 - 20.45
Ma 25.5.2020 17.00 - 20.45
Ke 27.5.2020 17.00 - 20.45
Ma 1.6.2020 17.00 - 20.45
Ke 3.6.2020 17.00 - 20.45
Ma 8.6.2020 17.00 - 20.45

Materials

Materiaali jaetaan kurssilla.

Teaching methods

Luennot (Zoom) ja harjoitukset.

Exam schedules

Kurssi suoritetaan harjoituksilla.

Evaluation scale

0-5

Assessment criteria, satisfactory (1)

Students have achieved the course objectives fairly. Students will be able to identify, define and use the course subject area’s concepts and models. The student understands the criteria and principles of the expertise development.

Assessment criteria, good (3)

Students have achieved the course objectives well, even though the knowledge and skills need improvement on some areas. Students are able to define the course concepts and models and are able to justify the analysis. The student is able to apply their knowledge in leisure, study and work situations. The student understands the importance of expertise in the field of business and is able to analyze his/her own expertise.

Assessment criteria, excellent (5)

Opiskelija on saavuttanut opintojakson tavoitteet kiitettävästi. Opiskelija hallitsee kiitettävästi opintojakson aihepiirin käsitteet ja mallit. Opiskelija osaa analysoida sujuvasti ja perustellusti sekä esittää käytännön kehittämistoimenpiteitä. Opiskelijalla on hyvät valmiudet soveltaa oppimaansa vapaa-ajan, opiskelun ja työelämän tilanteissa. Opiskelija osaa analysoida liiketalouden alan asiantuntijuutta ja omaa
asiantuntijaksi kehittymistään.

Assessment criteria, approved/failed

Students have achieved the objectives of the course with excellent marks. Students master commendably the course subject area’s concepts and models. Students are able to make justified and fluent analysis and to present concrete development measures. The students are well prepared to apply their knowledge in leisure, study and work situations. Students are able to analyze the business sector expertise and the evolvement of their own expertise.

Assessment methods and criteria

Kurssi suoritetaan harjoituksilla.

Qualifications

Basics of IT