Excelin tehokäyttö (3 cr)
Code: LX00BE84-3011
General information
Enrollment
15.03.2021 - 09.05.2021
Timing
17.05.2021 - 13.06.2021
Number of ECTS credits allocated
3 op
Mode of delivery
Contact teaching
Unit
Liiketalous
Campus
Leiritie 1
Teaching languages
- Finnish
Seats
0 - 30
Degree programmes
- Degree Programme in International Business and Logistics
- Liiketalouden tutkinto-ohjelma
- Degree Programme in European Business Administration
Teachers
- Marko Kosonen
Teacher in charge
Anne Perkiö
Groups
-
LITO_VVVapaastivalittavat, 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
Etäluennot:
Ma 24.5.2021 17.00 - 20.45
Ke 26.5.2021 17.00 - 20.45
Pe 28.5.2021 17.00 - 20.45
Ma 31.5.2021 17.00 - 20.45
Ke 2.6.2021 17.00 - 20.45
Pe 4.6.2021 17.00 - 20.45
Materials
Tarvittava materiaali jaetaan kurssilla.
Teaching methods
Etäluennot (ZOOM) ja harjoitukset.
Exam schedules
Kurssi suoritetaan palautettavilla 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 palautettavilla harjoituksilla. Kurssi arvostellaan asteikolla 0 - 5.
Qualifications
Basics of IT