Advanced Use of Excel (3cr)
Code: LT00DL18-3002
General information
- Enrollment
- 11.11.2024 - 15.12.2024
- Registration for the implementation has ended.
- Timing
- 07.01.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
- 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
- Mikko Kulmala
- Scheduling groups
- Avoin AMK (Ei koske tutkinto-opiskelijaa) (Size: 10 . Open UAS : 10.)
- Small groups
- Open UAS (Doesn't apply to degree student)
- Course
- LT00DL18
Evaluation scale
1-5
Objective
The student knows how to plan, implement and use Excel's PowerPivot functionality versatilely. The student knows how to import data into Excel from databases and a CSV file. The student knows how to build a PowerPivot data model and present results graphically and filter them. The student knows the basics of the DAX language and knows how to use it in building a data model and metrics.
Content
With the Excel spreadsheet program
- Data import from different data sources
- Building a PowerPivot data model
- Basics of the DAX language
- Preparing graphic and numerical reports
- Creating a dashboard
Materials
Material provided by lecturer and online materials
Teaching methods
Lectures in Teams, excel exercises
Completion alternatives
Kurssi on mahdollista suorittaa itsenäisesti tehtäviä suorittaen
Student workload
Lectures 12h, independent work 69h
Assessment criteria, satisfactory (1)
The student passes the requirements according to the performance rule. The student knows how to import information from different sources into Excel and create a PowerPivot data model at a basic level. He knows how to satisfactorily create metrics, reports and dashboards based on a data model. The student knows how to use the basics of the DAX language.
Assessment criteria, good (3)
The student passes the requirements according to the performance rule. The student knows how to import information from different sources into Excel better than at the basic level. The student knows how to create a PowerPivot data model. He knows how to create metrics, reports, and a dashboard based on a data model. The student knows how to use the basics of the DAX language.
Assessment criteria, excellent (5)
The student fulfills the requirements according to the performance rule. The student knows how to create a PowerPivot data model. He knows how to apply metrics, reports, and dashboards based on the data model. The student knows the DAX language and can apply it.
Qualifications
Information and communication technology, Spreadsheets