Excel Spreadsheet Calculation in BusinessLaajuus (2 op)
Tunnus: KD19CNTT012
Osaamistavoitteet
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
Esitietovaatimukset
Basics of mathematics and ICT skills
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.
Oppimateriaalit
- material provided by the teacher
- Internet material
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
-
IB23BBachelor of Business Administration, International Business
-
IGWIB25SGateway to International Business
-
VVOVVO-ryhmä Peppiä varten
-
IB22BTradenomi (AMK), International Business
-
IB23ABachelor of Business Administration, International Business
-
IB22ATradenomi (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
Ilmoittautumisaika
24.08.2023 - 17.01.2024
Ajoitus
22.01.2024 - 16.02.2024
Laajuus
2 op
Yksikkö
SeAMK International Business
Toimipiste
SeAMK Seinäjoki, Frami
Opetuskielet
- Englanti
Tutkinto-ohjelma
- Bachelor of Business Administration, International Business
Opettaja
- Nicolas Martinez
Opiskelijaryhmät
-
IGWIB24SGateway to International Business
-
IB21Tradenomi (AMK), International Business
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, videos and workshop
Opiskelijan ajankäyttö ja kuormitus
Lectures 16 hours and self-study or independent work 38 hours
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
Lecture work and assignments
Esitietovaatimukset
Basics of mathematics and ICT skills
Ilmoittautumisaika
14.11.2022 - 26.02.2023
Ajoitus
09.01.2023 - 17.02.2023
Laajuus
2 op
Toimipiste
SeAMK Seinäjoki, Frami
Opetuskielet
- Englanti
Opettaja
- Nicolas Martinez
Opiskelijaryhmät
-
IB20Tradenomi (AMK), International Business
-
IBDDSIB:n saapuneet DD-opiskelijat
-
IB21Tradenomi (AMK), International Business
-
VVOVVO-ryhmä Peppiä varten
-
IGWIB23SGateway to International Business
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
Teacher's material in Moodle
Opetusmenetelmät
Lectures and independent assignment
Opiskelijan ajankäyttö ja kuormitus
54 h work for student
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
Independent assignments and exam
Esitietovaatimukset
Basics of mathematics and ICT skills
Ilmoittautumisaika
15.10.2021 - 31.01.2022
Ajoitus
10.01.2022 - 20.02.2022
Laajuus
2 op
Yksikkö
SeAMK International Business
Toimipiste
SeAMK Seinäjoki, Frami
Opetuskielet
- Englanti
Tutkinto-ohjelma
- Bachelor of Business Administration, International Business
Opettaja
- Raija Kangassalo
Opiskelijaryhmät
-
IB20Tradenomi (AMK), International Business
-
IBDDSIB:n saapuneet DD-opiskelijat
-
IGWIB22SGateway to International Business
-
IGWIB21FGateway to International Business
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
Teacher's material in Moodle
Opetusmenetelmät
Lectures and independent assignment
Opiskelijan ajankäyttö ja kuormitus
54 h work for student
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
Independent assignments and exam
Esitietovaatimukset
Basics of mathematics and ICT skills