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
-
IB23BBachelor of Business Administration, International Business
-
IGWIB25SGateway to International Business
-
VVO
-
IB22B
-
IB23ABachelor 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
-
IGWIB24SGateway 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
-
IGWIB23SGateway 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
-
IGWIB22SGateway to International Business
-
IGWIB21FGateway 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