Study Guide

Objectives (course unit)

During the course the students extent their know-how of the digital skills needed in the working life.

Course Learning Outcomes:
After completing the course the students
- are able design a spreadsheet from the written description using more advanced functions.
- are able to save a workbook as a template
- are able to use the reporting tool
- know the benefits and opportunities of erp-system
- are able to perform purchase and sales processes in erp-system
- know how processes integrate to financial administration
- are able to understand the basic of coding from business administration point of view
- are able to use artificial intelligence opportunities in the modern business processes.

Content (course unit)

SPREADSHEET
How to create formulas in Excel using the functions in diverse ways?
How to visualize and process the information in the Excel table?
How to protect an Excel spreadsheet?
How to create, edit, and process a Pivot table?
How to design an Excel spreadsheet from a written description?
How to import and export data between Excel and other applications?
What is Power BI and how to utilize it?

ERP-SYSTEMS
What are basic the functions and features of SAP HANA?
How to perform purchase and sales processes in erp-system and how do they integrate to financial administration?

MODERN BUSINESS DIGITAL TOOLS
What are the basic principles of coding and which software languages are used in modern business environment?
How can robotics to be used in modern business?
What opportunities does artificial intelligence bring to the modern business environment?

Assessment criteria, pass/fail (course unit)

Passed:
The studen has completed Power BI exercise. They can identify and follow important procedures of spreadsheets.
The student is able to perform purchase and sale processes in the system and use the basic functions of the software independently.
The student can explain the basics of coding and knows the most used software language. They know the different solutions of robotics and artificial intelligence.
Failed:
The student has not been able to submit assignments approved.

Assessment methods and criteria

Assignments and potential exam passed.

Assessment scale

Pass/Fail

Assessment criteria - pass/fail (Not in use, Look at the Assessment criteria above)

Passed:
The student can identify and follow important procedures of spreadsheets. The student is able to perform purchase and sale processes in the system and use the basic functions of the software independently.
The student knows the basics of coding. They know the different solutions of robotics and artificial intelligence.

Failed:
The student has not been able to pass mandatory assignments.