Skip to main content

Spreadsheet (3 cr)

Code: LT00CK95-3018

General information


Enrollment
11.11.2024 - 15.01.2025
Registration for the implementation has ended.
Timing
07.01.2025 - 13.04.2025
Implementation has ended.
Number of ECTS credits allocated
3 cr
Local portion
3 cr
Mode of delivery
Contact learning
Unit
SeAMK Business Management and SME Business Management
Campus
SeAMK Seinäjoki, Frami
Teaching languages
Finnish
Degree programmes
Bachelor of Business Administration, Business Management
Teachers
Marja Erkkilä
Groups
LITA24B
Bachelor of Business Administration, Business Management
Course
LT00CK95

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, filter information and utilise other special features in the Excel software. Students can carry out internet poll and use the results in spreadsheet

Content

Creating and editing spreadheets with Excel
- Writing formulae and using functions
- Processing/sorting information in a spreadsheet
- Filtering, summarising, linking
- Using Pivot tables
- Creating and editing graphs and charts
- Printing
- Goal Seek
- Creating an internet questionaire
- Special features in the Excel

Materials

Will be announced at the beginning of the cource

Teaching methods

Kontaktiopetus ja itsenäiset harjoitukset.

Exam schedules

Pakolliset harjoitukset

Completion alternatives

OT.testi

Student workload

Yhteensä 82 h: lähiopetusta 30 h ja itsenäistä opiskelua 52 h

Assessment criteria, satisfactory (1)

The student will do the job of the course requirements successfully. The student is able to plan, implement and utilise calculation models satisfactrorily. The student is able to present the results using charts and is also able to make summaries of the information in tables, filter information and utilise some other special features in the Excel software. Student can carry out internet poll and bring the results to spreadsheet.

Assessment criteria, good (3)

The student will do the job of the course requirements well. The student is able to plan, implement and utilise well a variety of various calculation models. The student is able to present the results using good charts and is also able to make summaries of the information in tables, filter information and utilise other special features in the Excel software. Student can carry out internet poll and use the results in spreadsheet.

Assessment criteria, excellent (5)

The student will do the job of the course requirements perfectly. 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. Student can independently carry out internet poll and use the results in spreadsheet.

Qualifications

Information and Communication Technology

Further information

Toteutuksella käytössä Moodle

Go back to top of page