Skip to main content

Excel Spreadsheet Calculation in BusinessLaajuus (2 cr)

Code: KD19CNTT012

Objective

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.

Content

- 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

Qualifications

Basics of mathematics and ICT skills

Assessment criteria, satisfactory (1)

The student is able to 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.

Assessment criteria, good (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.

Assessment criteria, excellent (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.

Materials

- material provided by the teacher
- Internet material

Enrollment

11.11.2024 - 15.01.2025

Timing

07.01.2025 - 16.02.2025

Credits

2 op

Teaching languages
  • English
Degree programmes
  • Bachelor of Business Administration, International Business
Teachers
  • Maja Krljic
Scheduling groups
  • Avoin AMK (Ei koske tutkinto-opiskelijaa) (Size: 10. Open UAS: 10.)
Student groups
  • IB23B
    Bachelor of Business Administration, International Business
  • IGWIB25S
    Gateway to International Business
  • VVO
  • IB22B
  • IB23A
    Bachelor of Business Administration, International Business
  • IB22A
Education groups
  • Open UAS (Doesn't apply to degree student)

Objective

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.

Content

- 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

Materials

- material provided by the teacher
- Internet material

Teaching methods

Lectures, individual work

Student workload

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

Evaluation scale

1-5

Assessment criteria, satisfactory (1)

The student is able to 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.

Assessment criteria, good (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.

Assessment criteria, excellent (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.

Assessment methods and criteria

8 assignments- each worth 12,5 %

Qualifications

Basics of mathematics and ICT skills

Enrollment

24.08.2023 - 17.01.2024

Timing

22.01.2024 - 16.02.2024

Credits

2 op

Teaching languages
  • English
Degree programmes
  • Bachelor of Business Administration, International Business
Teachers
  • Nicolas Martinez
Student groups
  • IGWIB24S
    Gateway to International Business
  • IB21

Objective

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.

Content

- 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

Materials

- material provided by the teacher
- Internet material

Teaching methods

Lectures, videos and workshop

Student workload

Lectures 16 hours and self-study or independent work 38 hours

Evaluation scale

1-5

Assessment criteria, satisfactory (1)

The student is able to 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.

Assessment criteria, good (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.

Assessment criteria, excellent (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.

Assessment methods and criteria

Lecture work and assignments

Qualifications

Basics of mathematics and ICT skills

Enrollment

14.11.2022 - 26.02.2023

Timing

09.01.2023 - 17.02.2023

Credits

2 op

Teaching languages
  • English
Teachers
  • Nicolas Martinez
Student groups
  • IB20
  • IBDDS
  • IB21
  • VVO
  • IGWIB23S
    Gateway to International Business

Objective

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.

Content

- 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

Materials

Teacher's material in Moodle

Teaching methods

Lectures and independent assignment

Student workload

54 h work for student

Evaluation scale

1-5

Assessment criteria, satisfactory (1)

The student is able to 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.

Assessment criteria, good (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.

Assessment criteria, excellent (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.

Assessment methods and criteria

Independent assignments and exam

Qualifications

Basics of mathematics and ICT skills

Enrollment

15.10.2021 - 31.01.2022

Timing

10.01.2022 - 20.02.2022

Credits

2 op

Teaching languages
  • English
Degree programmes
  • Bachelor of Business Administration, International Business
Teachers
  • Raija Kangassalo
Student groups
  • IB20
  • IBDDS
  • IGWIB22S
    Gateway to International Business
  • IGWIB21F
    Gateway to International Business

Objective

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.

Content

- 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

Materials

Teacher's material in Moodle

Teaching methods

Lectures and independent assignment

Student workload

54 h work for student

Evaluation scale

1-5

Assessment criteria, satisfactory (1)

The student is able to 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.

Assessment criteria, good (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.

Assessment criteria, excellent (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.

Assessment methods and criteria

Independent assignments and exam

Qualifications

Basics of mathematics and ICT skills