Siirry suoraan sisältöön

Excel Spreadsheet Calculation in Business (2 op)

Toteutuksen tunnus: KD19CNTT012-3009

Toteutuksen perustiedot


Ilmoittautumisaika

11.11.2024 - 15.01.2025

Ajoitus

07.01.2025 - 16.02.2025

Laajuus

2 op

Yksikkö

SeAMK International Business

Toimipiste

SeAMK Seinäjoki, Frami

Opetuskielet

  • Englanti

Tutkinto-ohjelma

  • Bachelor of Business Administration, International Business

Opettaja

  • Maja Krljic

Ajoitusryhmät

  • Avoin AMK (Ei koske tutkinto-opiskelijaa) (Koko: 10. Avoin AMK: 10.)

Opiskelijaryhmät

  • IB23B
    Bachelor of Business Administration, International Business
  • IGWIB25S
    Gateway to International Business
  • VVO
    VVO-ryhmä Peppiä varten
  • IB22B
    Tradenomi (AMK), International Business
  • IB23A
    Bachelor of Business Administration, International Business
  • IB22A
    Tradenomi (AMK), International Business

Koulutusryhmat

  • Avoin AMK (Ei koske tutkinto-opiskelijaa)

Tavoitteet

Students are able to plan, implement and utilise various calculation models. They are able to present the results graphically. Students are also able to make summaries of the information in tables and utilise other special features in the Excel software.

Sisältö

- Creating and editing spreadheets with Excel
- Writing formulas and using functions
- Processing/sorting information in a spreadsheet
- Using Pivot tables
- Creating and editing graphs and charts
- Goal Seek
- Basic macros
- Special features in the Excel

Oppimateriaalit

- material provided by the teacher
- Internet material

Opetusmenetelmät

Lectures, individual work

Opiskelijan ajankäyttö ja kuormitus

All together 54 h ( 2 ECTS):
- 16h for contact lessons and assignements
- 38h for self-study

Arviointiasteikko

1-5

Arviointikriteerit, tyydyttävä (1)

The student is able to plan, implement and utilise calculation models with some help. The student is able to present the results using basic charts and is also able to make summaries of the information in tables and utilise some other essential features in the Excel software. In this work the student needs some help.

Arviointikriteerit, hyvä (3)

The student is able to plan, implement and utilise a variety of Excel tasks. The student is able to present the results using charts and is also able to make summaries of the information in tables and utilise other special features in the Excel software.

Arviointikriteerit, kiitettävä (5)

The student is able to plan independently, implement and utilise a variety of various calculation models. The student is able to present the results using excellent charts and is also able to make summaries of the information in tables, filter information and utilise very well other special features in the Excel software.

Arviointimenetelmät ja arvioinnin perusteet

8 assignments- each worth 12,5 %

Esitietovaatimukset

Basics of mathematics and ICT skills