Effective Utilization of Spreadsheet ComputationLaajuus (5 cr)
Code: HL00BD63
Credits
5 op
Teaching language
- Finnish
Responsible person
- Päivi Hänninen-Pihlajamäki
Objective
The object of the course
Once you have completed the course, you have the essential information on the possibilities and benefits of spreadsheet computation related to your field of studies.
Course competencies
Learning to learn
Operating in a workplace
Business competence
The learning objectives of the course
After this course, you will know the advanced features of the spreadsheet computation and you will be able to take advantage of them in studying and working life.
You recognise the strengths and development areas of your competence and learning methods.
Content
Spreadsheet computation: editing features, checking formulas, using printing range, references in tables and between them, functions facilitating calculation, sorting functions of large tables, macros, Pivot, Power Pivot.
Qualifications
Basics of Spreadheets computation: functions, charts, cell references.
Assessment criteria, satisfactory (1)
Sufficient 1
You recognize the principles of effective working with a spreadsheet program and you can use the tools with instruct.
Satisfactory 2
You understand the main principles of the advanced features of the spreadsheet, and you can use your skills in different kind of situations independently.
Assessment criteria, good (3)
Good 3
You understand the possibilities of using the spreadsheet program as an effective tool. You can apply your skills in different kind of situations.
Very good 4
You master possibilities for using the spreadsheet program as an effective personal tool. You know how to apply your skills to different spreadsheet computing situations. You can justify your choices and decisions.
Assessment criteria, excellent (5)
Excellent 5
You have the critical knowledge of the spreadsheet program, and you can apply your skills in developing new innovative applications in work. You justify your choices and decisions.
Further information
macin käyttäjille suositellaan joidenkin tehtävien tekemiseen etäyhteyttä: remote.jamk.fi
Enrollment
01.08.2024 - 31.03.2025
Timing
26.08.2024 - 19.05.2025
Number of ECTS credits allocated
5 op
Virtual portion
5 op
Mode of delivery
Online learning
Unit
School of Business
Teaching languages
- Finnish
Seats
20 - 100
Degree programmes
- Bachelor's Degree Programme in Business Management
Teachers
- Päivi Hänninen-Pihlajamäki
Groups
-
HTL24KIYTradenomi (AMK), liiketalous, monimuotototeutus
-
HTLDIGDigital Business, Business Administration
-
HTL23KIYTradenomi (AMK), liiketalous, monimuotototeutus
-
HTL23S1Liiketalouden tutkinto-ohjelma (AMK)
-
ZJA24SHNO1Avoin amk, lita, nonstop 1, verkko
Objectives
The object of the course
Once you have completed the course, you have the essential information on the possibilities and benefits of spreadsheet computation related to your field of studies.
Course competencies
Learning to learn
Operating in a workplace
Business competence
The learning objectives of the course
After this course, you will know the advanced features of the spreadsheet computation and you will be able to take advantage of them in studying and working life.
You recognise the strengths and development areas of your competence and learning methods.
Content
Spreadsheet computation: editing features, checking formulas, using printing range, references in tables and between them, functions facilitating calculation, sorting functions of large tables, macros, Pivot, Power Pivot.
Learning materials and recommended literature
General learning material can be found in Microsoft Office tutorials.
Teaching methods
Assignments and Learning tasks are in an online learning environment (Moodle). Feedback of the assignments is given as comments in the online learning environment.
Guidance will be available:
1. Introduction webinar/video
2. Evaluation of the learning tasks with the scale Failed/Passed. Feedback if you need to re-submit tasks.
3. Workshops in Zoom
4. Evaluation of the final assignments with a scale. Artificial intelligence can be used in the final assignments. Its use must be mentioned when returning.
Practical training and working life connections
You can do the assignments in practical training or to your workplace.
Exam dates and retake possibilities
No exams. The course ends 15.5.2025.
Alternative completion methods
Recognition of Prior Learning and Experience: Accreditation, Recognition of informal learning, Studification
More information in the degree regulations and the study guide.
Student workload
Online studies and tasks 135 h:
Reading materials 30 h
Learning tasks 55 h
Assignments 50 h Artificial intelligence can be used in the final assignments. Its use must be mentioned when returning.
Content scheduling
In the course, you should first complete the first tasks and then so-called final assignments. Tasks and assignments are done at your own pace.
Nonstop, online 30.8.2023 - 15.5.2024.
Further information for students
Feedback of the assignments is given as comments in the online learning environment.
The first assignment of the course must be submitted no later than three weeks after registering for the course or starting from the start date of the course.
Evaluation scale
0-5
Evaluation criteria, satisfactory (1-2)
Sufficient 1
You recognize the principles of effective working with a spreadsheet program and you can use the tools with instruct.
Satisfactory 2
You understand the main principles of the advanced features of the spreadsheet, and you can use your skills in different kind of situations independently.
Evaluation criteria, good (3-4)
Good 3
You understand the possibilities of using the spreadsheet program as an effective tool. You can apply your skills in different kind of situations.
Very good 4
You master possibilities for using the spreadsheet program as an effective personal tool. You know how to apply your skills to different spreadsheet computing situations. You can justify your choices and decisions.
Evaluation criteria, excellent (5)
Excellent 5
You have the critical knowledge of the spreadsheet program, and you can apply your skills in developing new innovative applications in work. You justify your choices and decisions.
Prerequisites
Basics of Spreadheets computation: functions, charts, cell references.
Further information
macin käyttäjille suositellaan joidenkin tehtävien tekemiseen etäyhteyttä: remote.jamk.fi
Enrollment
01.08.2024 - 22.08.2024
Timing
26.08.2024 - 18.12.2024
Number of ECTS credits allocated
5 op
Virtual portion
5 op
Mode of delivery
Online learning
Unit
School of Business
Teaching languages
- Finnish
Seats
20 - 40
Degree programmes
- Bachelor's Degree Programme in Business Management
Teachers
- Päivi Hänninen-Pihlajamäki
Groups
-
HTL24KIYTradenomi (AMK), liiketalous, monimuotototeutus
-
HTLDIGDigital Business, Business Administration
-
HTL23KIYTradenomi (AMK), liiketalous, monimuotototeutus
-
HTL23S1Liiketalouden tutkinto-ohjelma (AMK)
Objectives
The object of the course
Once you have completed the course, you have the essential information on the possibilities and benefits of spreadsheet computation related to your field of studies.
Course competencies
Learning to learn
Operating in a workplace
Business competence
The learning objectives of the course
After this course, you will know the advanced features of the spreadsheet computation and you will be able to take advantage of them in studying and working life.
You recognise the strengths and development areas of your competence and learning methods.
Content
Spreadsheet computation: editing features, checking formulas, using printing range, references in tables and between them, functions facilitating calculation, sorting functions of large tables, macros, Pivot, Power Pivot.
Learning materials and recommended literature
General learning material can be found in Microsoft Office tutorials.
Teaching methods
Assignments and Learning tasks are in an online learning environment (Moodle). Feedback of the assignments is given as comments in the online learning environment.
Guidance will be available:
1. Introduction webinar/video
2. Evaluation of the learning tasks with the scale Failed/Passed. Feedback if you need to re-submit tasks.
3. Workshops in Zoom
4. Evaluation of the final assignments with a scale 0 - 5. Artificial intelligence can be used in the final assignments. Its use must be mentioned when returning.
Practical training and working life connections
You can do the assignments in practical training or to your workplace.
Exam dates and retake possibilities
No exams. Course ends 13.12.2024.
Alternative completion methods
Recognition of Prior Learning and Experience: Accreditation, Recognition of informal learning, Studification
More information in the degree regulations and the study guide.
Student workload
Online studies and tasks 135 h:
Reading materials 30 h
Learning tasks 55 h
Assignments 50 h
Content scheduling
In the course, you should first complete the first tasks and then so-called final assignments.
Online course.
Further information for students
Feedback of the assignments is given as comments in the online learning environment.
Evaluation scale
0-5
Evaluation criteria, satisfactory (1-2)
Sufficient 1
You recognize the principles of effective working with a spreadsheet program and you can use the tools with instruct.
Satisfactory 2
You understand the main principles of the advanced features of the spreadsheet, and you can use your skills in different kind of situations independently.
Evaluation criteria, good (3-4)
Good 3
You understand the possibilities of using the spreadsheet program as an effective tool. You can apply your skills in different kind of situations.
Very good 4
You master possibilities for using the spreadsheet program as an effective personal tool. You know how to apply your skills to different spreadsheet computing situations. You can justify your choices and decisions.
Evaluation criteria, excellent (5)
Excellent 5
You have the critical knowledge of the spreadsheet program, and you can apply your skills in developing new innovative applications in work. You justify your choices and decisions.
Prerequisites
Basics of Spreadheets computation: functions, charts, cell references.
Further information
macin käyttäjille suositellaan joidenkin tehtävien tekemiseen etäyhteyttä: remote.jamk.fi
Enrollment
01.08.2023 - 31.03.2024
Timing
29.08.2023 - 15.05.2024
Number of ECTS credits allocated
5 op
Virtual portion
5 op
Mode of delivery
Online learning
Unit
School of Business
Campus
Main Campus
Teaching languages
- Finnish
Seats
20 - 100
Degree programmes
- Bachelor's Degree Programme in Business Management
Teachers
- Päivi Hänninen-Pihlajamäki
Groups
-
HTL22S1Liiketalouden tutkinto-ohjelma (AMK)
-
HTLDIGDigital Business, Business Administration
-
ZJA23SHNO1Avoin amk, lita, nonstop 1, verkko
-
HTL22SIYLiiketalouden tutkinto-ohjelma (AMK)
Objectives
The object of the course
Once you have completed the course, you have the essential information on the possibilities and benefits of spreadsheet computation related to your field of studies.
Course competencies
Learning to learn
Operating in a workplace
Business competence
The learning objectives of the course
After this course, you will know the advanced features of the spreadsheet computation and you will be able to take advantage of them in studying and working life.
You recognise the strengths and development areas of your competence and learning methods.
Content
Spreadsheet computation: editing features, checking formulas, using printing range, references in tables and between them, functions facilitating calculation, sorting functions of large tables, macros, Pivot, Power Pivot.
Learning materials and recommended literature
General learning material can be found in Microsoft Office tutorials.
Teaching methods
Assignments and Learning tasks are in an online learning environment (Moodle). Feedback of the assignments is given as comments in the online learning environment.
Guidance will be available:
1. Introduction webinar/video
2. Evaluation of the learning tasks with the scale Failed/Passed. Feedback if you need to re-submit tasks.
3. Workshops in Zoom
4. Evaluation of the final assignments with a scale 0 - 5.
Practical training and working life connections
You can do the assignments in practical training or to your workplace.
Exam dates and retake possibilities
No exams. The course ends 15.5.2024.
Alternative completion methods
Recognition of Prior Learning and Experience: Accreditation, Recognition of informal learning, Studification
More information in the degree regulations and the study guide.
Student workload
Online studies and tasks 135 h:
Reading materials 30 h
Learning tasks 55 h
Assignments 50 h
Content scheduling
In the course, you should first complete the first tasks and then so-called final assignments. Tasks and assignments are done at your own pace.
Nonstop, online 30.8.2023 - 15.5.2024.
Further information for students
Feedback of the assignments is given as comments in the online learning environment.
Evaluation scale
0-5
Evaluation criteria, satisfactory (1-2)
Sufficient 1
You recognize the principles of effective working with a spreadsheet program and you can use the tools with instruct.
Satisfactory 2
You understand the main principles of the advanced features of the spreadsheet, and you can use your skills in different kind of situations independently.
Evaluation criteria, good (3-4)
Good 3
You understand the possibilities of using the spreadsheet program as an effective tool. You can apply your skills in different kind of situations.
Very good 4
You master possibilities for using the spreadsheet program as an effective personal tool. You know how to apply your skills to different spreadsheet computing situations. You can justify your choices and decisions.
Evaluation criteria, excellent (5)
Excellent 5
You have the critical knowledge of the spreadsheet program, and you can apply your skills in developing new innovative applications in work. You justify your choices and decisions.
Prerequisites
Basics of Spreadheets computation: functions, charts, cell references.
Further information
macin käyttäjille suositellaan joidenkin tehtävien tekemiseen etäyhteyttä: remote.jamk.fi
Enrollment
01.08.2023 - 24.08.2023
Timing
28.08.2023 - 19.12.2023
Number of ECTS credits allocated
5 op
Virtual portion
5 op
Mode of delivery
Online learning
Unit
School of Business
Campus
Main Campus
Teaching languages
- Finnish
Seats
20 - 45
Degree programmes
- Bachelor's Degree Programme in Business Management
Teachers
- Päivi Hänninen-Pihlajamäki
Groups
-
HTL22S1Liiketalouden tutkinto-ohjelma (AMK)
-
HTLDIGDigital Business, Business Administration
-
HTL22SIYLiiketalouden tutkinto-ohjelma (AMK)
Objectives
The object of the course
Once you have completed the course, you have the essential information on the possibilities and benefits of spreadsheet computation related to your field of studies.
Course competencies
Learning to learn
Operating in a workplace
Business competence
The learning objectives of the course
After this course, you will know the advanced features of the spreadsheet computation and you will be able to take advantage of them in studying and working life.
You recognise the strengths and development areas of your competence and learning methods.
Content
Spreadsheet computation: editing features, checking formulas, using printing range, references in tables and between them, functions facilitating calculation, sorting functions of large tables, macros, Pivot, Power Pivot.
Learning materials and recommended literature
General learning material can be found in Microsoft Office tutorials.
Teaching methods
Assignments and Learning tasks are in an online learning environment (Moodle). Feedback of the assignments is given as comments in the online learning environment.
Guidance will be available:
1. Introduction webinar/video
2. Evaluation of the learning tasks with the scale Failed/Passed. Feedback if you need to re-submit tasks.
3. Workshops in Zoom
4. Evaluation of the final assignments with a scale 0 - 5.
Practical training and working life connections
You can do the assignments in practical training or to your workplace.
Exam dates and retake possibilities
No exams. Course ends 13.12.2023.
Alternative completion methods
Recognition of Prior Learning and Experience: Accreditation, Recognition of informal learning, Studification
More information in the degree regulations and the study guide.
Student workload
Online studies and tasks 135 h:
Reading materials 30 h
Learning tasks 55 h
Assignments 50 h
Content scheduling
In the course, you should first complete the first tasks and then so-called final assignments.
Online 29.8.2023 - 13.12.2023.
Further information for students
Feedback of the assignments is given as comments in the online learning environment.
Evaluation scale
0-5
Evaluation criteria, satisfactory (1-2)
Sufficient 1
You recognize the principles of effective working with a spreadsheet program and you can use the tools with instruct.
Satisfactory 2
You understand the main principles of the advanced features of the spreadsheet, and you can use your skills in different kind of situations independently.
Evaluation criteria, good (3-4)
Good 3
You understand the possibilities of using the spreadsheet program as an effective tool. You can apply your skills in different kind of situations.
Very good 4
You master possibilities for using the spreadsheet program as an effective personal tool. You know how to apply your skills to different spreadsheet computing situations. You can justify your choices and decisions.
Evaluation criteria, excellent (5)
Excellent 5
You have the critical knowledge of the spreadsheet program, and you can apply your skills in developing new innovative applications in work. You justify your choices and decisions.
Prerequisites
Basics of Spreadheets computation: functions, charts, cell references.
Further information
macin käyttäjille suositellaan joidenkin tehtävien tekemiseen etäyhteyttä: remote.jamk.fi
Enrollment
01.08.2022 - 25.08.2022
Timing
29.08.2022 - 06.01.2023
Number of ECTS credits allocated
5 op
Virtual portion
5 op
Mode of delivery
Online learning
Unit
School of Business
Campus
Main Campus
Teaching languages
- Finnish
Seats
0 - 40
Degree programmes
- Bachelor's Degree Programme in Business Management
Teachers
- Päivi Hänninen-Pihlajamäki
Groups
-
HTL21S1Liiketalouden tutkinto-ohjelma (AMK)
-
HTL21SIYLiiketalouden tutkinto-ohjelma (AMK)
-
HTLDIGDigital Business, Business Administration
Objectives
The object of the course
Once you have completed the course, you have the essential information on the possibilities and benefits of spreadsheet computation related to your field of studies.
Course competencies
Learning to learn
Operating in a workplace
Business competence
The learning objectives of the course
After this course, you will know the advanced features of the spreadsheet computation and you will be able to take advantage of them in studying and working life.
You recognise the strengths and development areas of your competence and learning methods.
Content
Spreadsheet computation: editing features, checking formulas, using printing range, references in tables and between them, functions facilitating calculation, sorting functions of large tables, macros, Pivot, Power Pivot.
Learning materials and recommended literature
General learning material can be found in Microsoft Office tutorials.
Teaching methods
Assignments and Learning tasks are in an online learning environment (Moodle). Feedback of the assignments is given as comments in the online learning environment.
Practical training and working life connections
You can do the assignments in practical training or to your workplace.
Exam dates and retake possibilities
No exams. Course ends 15.12.2022.
Alternative completion methods
Recognition of Prior Learning and Experience: Accreditation, Recognition of informal learning, Studification
More information in the degree regulations and the study guide.
Student workload
Online studies and tasks 135 h:
Reading materials 30 h
Learning tasks 55 h
Assignments 50 h
Content scheduling
In the course, you should first complete the first tasks and then so-called final assignments.
Online 29.8.2022 - 15.12.2022
Further information for students
Feedback of the assignments is given as comments in the online learning environment.
Evaluation scale
0-5
Evaluation criteria, satisfactory (1-2)
Sufficient 1
You recognize the principles of effective working with a spreadsheet program and you can use the tools with instruct.
Satisfactory 2
You understand the main principles of the advanced features of the spreadsheet, and you can use your skills in different kind of situations independently.
Evaluation criteria, good (3-4)
Good 3
You understand the possibilities of using the spreadsheet program as an effective tool. You can apply your skills in different kind of situations.
Very good 4
You master possibilities for using the spreadsheet program as an effective personal tool. You know how to apply your skills to different spreadsheet computing situations. You can justify your choices and decisions.
Evaluation criteria, excellent (5)
Excellent 5
You have the critical knowledge of the spreadsheet program, and you can apply your skills in developing new innovative applications in work. You justify your choices and decisions.
Prerequisites
Basics of Spreadheets computation: functions, charts, cell references.
Further information
macin käyttäjille suositellaan joidenkin tehtävien tekemiseen etäyhteyttä: remote.jamk.fi
Enrollment
01.08.2022 - 31.03.2023
Timing
29.08.2022 - 15.05.2023
Number of ECTS credits allocated
5 op
Virtual portion
5 op
Mode of delivery
Online learning
Unit
School of Business
Campus
Main Campus
Teaching languages
- Finnish
Seats
0 - 100
Degree programmes
- Bachelor's Degree Programme in Business Management
Teachers
- Päivi Hänninen-Pihlajamäki
Groups
-
HTL21S1Liiketalouden tutkinto-ohjelma (AMK)
-
ZJA23KHAvoin AMK, lita
-
ZJA22SHAvoin AMK, lita
-
HTL21SIYLiiketalouden tutkinto-ohjelma (AMK)
-
HTLDIGDigital Business, Business Administration
Objectives
The object of the course
Once you have completed the course, you have the essential information on the possibilities and benefits of spreadsheet computation related to your field of studies.
Course competencies
Learning to learn
Operating in a workplace
Business competence
The learning objectives of the course
After this course, you will know the advanced features of the spreadsheet computation and you will be able to take advantage of them in studying and working life.
You recognise the strengths and development areas of your competence and learning methods.
Content
Spreadsheet computation: editing features, checking formulas, using printing range, references in tables and between them, functions facilitating calculation, sorting functions of large tables, macros, Pivot, Power Pivot.
Learning materials and recommended literature
General learning material can be found in Microsoft Office tutorials.
Teaching methods
Assignments and Learning tasks are in an online learning environment (Moodle). Feedback of the assignments is given as comments in the online learning environment. Studying requires the student to be self-directed.
Practical training and working life connections
You can do the assignments in practical training or to your workplace.
Exam dates and retake possibilities
No exams. The course ends 15.5.2023.
Alternative completion methods
Recognition of Prior Learning and Experience: Accreditation, Recognition of informal learning, Studification
More information in the degree regulations and the study guide.
Student workload
Online studies and tasks 135 h:
Reading materials 30 h
Learning tasks 55 h
Assignments 50 h
Content scheduling
In the course, you should first complete the first tasks and then so-called final assignments. Tasks and assignments are done at your own pace.
Nonstop, online 30.8.2022 - 15.5.2023.
Further information for students
Feedback of the assignments is given as comments in the online learning environment.
Evaluation scale
0-5
Evaluation criteria, satisfactory (1-2)
Sufficient 1
You recognize the principles of effective working with a spreadsheet program and you can use the tools with instruct.
Satisfactory 2
You understand the main principles of the advanced features of the spreadsheet, and you can use your skills in different kind of situations independently.
Evaluation criteria, good (3-4)
Good 3
You understand the possibilities of using the spreadsheet program as an effective tool. You can apply your skills in different kind of situations.
Very good 4
You master possibilities for using the spreadsheet program as an effective personal tool. You know how to apply your skills to different spreadsheet computing situations. You can justify your choices and decisions.
Evaluation criteria, excellent (5)
Excellent 5
You have the critical knowledge of the spreadsheet program, and you can apply your skills in developing new innovative applications in work. You justify your choices and decisions.
Prerequisites
Basics of Spreadheets computation: functions, charts, cell references.
Further information
macin käyttäjille suositellaan joidenkin tehtävien tekemiseen etäyhteyttä: remote.jamk.fi
Enrollment
02.08.2021 - 31.03.2022
Timing
30.08.2021 - 20.05.2022
Number of ECTS credits allocated
5 op
Virtual portion
5 op
Mode of delivery
Online learning
Unit
School of Business
Campus
Main Campus
Teaching languages
- Finnish
Seats
0 - 40
Degree programmes
- Bachelor's Degree Programme in Business Management
Teachers
- Päivi Hänninen-Pihlajamäki
Groups
-
ZJA21SHAvoin AMK, lita
-
HTL20IYBachelor's Degree Programme in Business Management
-
HTLDIGDigital Business, Business Administration
-
ZJA22KHAvoin AMK, lita
Objectives
The object of the course
Once you have completed the course, you have the essential information on the possibilities and benefits of spreadsheet computation related to your field of studies.
Course competencies
Learning to learn
Operating in a workplace
Business competence
The learning objectives of the course
After this course, you will know the advanced features of the spreadsheet computation and you will be able to take advantage of them in studying and working life.
You recognise the strengths and development areas of your competence and learning methods.
Content
Spreadsheet computation: editing features, checking formulas, using printing range, references in tables and between them, functions facilitating calculation, sorting functions of large tables, macros, Pivot, Power Pivot.
Time and location
Nonstop, online 30.8.2021 - 20.5.2022
Learning materials and recommended literature
General learning material can be found in Microsoft Office tutorials.
Teaching methods
Assignments and Learning tasks are in an online learning environment (Moodle). Feedback of the assignments is given as comments in the online learning environment. Studying requires the student to be self-directed.
Practical training and working life connections
You can do the assignments in practical training or to your workplace.
Exam dates and retake possibilities
The course ends 20.5.2022.
Alternative completion methods
Recognition of Prior Learning and Experience: Accreditation, Recognition of informal learning, Studification
More information in the degree regulations and the study guide.
Student workload
Online studies and tasks 135 h:
Reading materials 30 h
Learning tasks 55 h
Assignments 50 h
Content scheduling
In the course, you should first complete the first tasks and then so-called final assignments. Tasks and assignments are done at your own pace.
Evaluation scale
0-5
Evaluation criteria, satisfactory (1-2)
Sufficient 1
You recognize the principles of effective working with a spreadsheet program and you can use the tools with instruct.
Satisfactory 2
You understand the main principles of the advanced features of the spreadsheet, and you can use your skills in different kind of situations independently.
Evaluation criteria, good (3-4)
Good 3
You understand the possibilities of using the spreadsheet program as an effective tool. You can apply your skills in different kind of situations.
Very good 4
You master possibilities for using the spreadsheet program as an effective personal tool. You know how to apply your skills to different spreadsheet computing situations. You can justify your choices and decisions.
Evaluation criteria, excellent (5)
Excellent 5
You have the critical knowledge of the spreadsheet program, and you can apply your skills in developing new innovative applications in work. You justify your choices and decisions.
Prerequisites
Basics of Spreadheets computation: functions, charts, cell references.
Further information
macin käyttäjille suositellaan joidenkin tehtävien tekemiseen etäyhteyttä: remote.jamk.fi