Excel Spreadsheet Calculation in Business (2cr)

Code: KD19CNTT012-3009

General information

Enrollment: 11.11.2024 - 15.01.2025; Registration for the implementation has ended.

Timing: 07.01.2025 - 16.02.2025; Implementation has ended.

Number of ECTS credits allocated: 2 cr

Local portion: 2 cr

Mode of delivery: Contact learning

Unit: SeAMK International Business

Campus: SeAMK Seinäjoki, Frami

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.)

Groups: IB23A
Bachelor of Business Administration, International Business; IB23B
Bachelor of Business Administration, International Business

Small groups: Open UAS (Doesn't apply to degree student)

Course: KD19CNTT012

Evaluation scale

1-5

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

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.

Qualifications

Basics of mathematics and ICT skills