Spreadsheet Calculation 2 (3cr)
Code: LT00DL21-3002
General information
- Enrollment
- 11.11.2024 - 07.01.2025
- Registration for the implementation has ended.
- Timing
- 03.02.2025 - 25.05.2025
- Implementation has ended.
- Number of ECTS credits allocated
- 3 cr
- Local portion
- 0 cr
- Virtual portion
- 3 cr
- Mode of delivery
- Distance learning
- Campus
- SeAMK Seinäjoki, Frami
- Teaching languages
- Finnish
- Seats
- 0 - 100
- Degree programmes
- Bachelor of Business Administration, Business Management
- Teachers
- Marja Erkkilä
- Course
- LT00DL21
Evaluation scale
1-5
Objective
The student deepens her/his Excel skills so that she/he knows how to plan, implement and use Excel spreadsheets in a versatile way.
Content
With Excel spreadsheet program
- Deepening the preparation of calculation formulas
- Deepening the preparation of diagrams
- Deepening the use of functions
- Three-dimensional calculation
- Alternative situations
- Search for a solution
- Pivot Tables
- Excel special functions
Materials
Moodlen materiaali
Teaching methods
Verkkototeutus. Tehtävät ja itsenäiset harjoitukset.
Exam schedules
Oppimistehtävä, joka vastaa tenttiä
Completion alternatives
OT-testi
Student workload
Itsenäistä opiskelua 82 h
Assessment criteria, satisfactory (1)
The student can prepare calculation formulas and diagrams based on the instructions and use the assigned function.
Assessment criteria, good (3)
The student knows how to prepare calculation formulas and diagrams and knows how to choose functions suitable for the calculation task. The student knows Excel's automation methods for creating spreadsheets.
Assessment criteria, excellent (5)
The student knows how to prepare and develop spreadsheets and charts and knows how to choose the functions suitable for the calculation task. The student makes versatile use of Excel's automation in preparing spreadsheets.
Qualifications
Information and communication technology, Spreadsheet