Advanced Use of Excel in Technical ApplicationsLaajuus (5 cr)
Code: TLXV1580
Credits
5 op
Teaching language
- Finnish
- English
Responsible person
- Juha Kuula
- Anne Rantakaulio
Objective
You know how to use spreadsheets in depth and you can apply your skills both in your studies and in working life in the field of technology and transport.
Engineering practice:
You have ability to identify, formulate and solve complex engineering problems, by being able to select and having the practical skills to apply relevant established analytical, computational and experimental techniques and methods
Content
Advanced us of Excel and mixed use of spreadsheets and word processing.
- using strings
- using large information material
- using logical, set and search functions
- creating forms and macros
- using analytical tools in engineering
- basic use of pivot tables and charts
Qualifications
ICT Skills or corresponding studies at university
Assessment criteria, approved/failed
To achieve approved performance, you must demonstrate that you have mastered the advanced use of spreadsheets. Competence is demonstrated by approved weekly assignments in the areas described in the course content.
Enrollment
18.11.2024 - 09.01.2025
Timing
23.01.2025 - 23.04.2025
Number of ECTS credits allocated
5 op
Virtual portion
5 op
Mode of delivery
Online learning
Unit
School of Technology
Campus
Main Campus
Teaching languages
- Finnish
Seats
20 - 70
Teachers
- Juha Kuula
- Anne Rantakaulio
Objectives
You know how to use spreadsheets in depth and you can apply your skills both in your studies and in working life in the field of technology and transport.
Engineering practice:
You have ability to identify, formulate and solve complex engineering problems, by being able to select and having the practical skills to apply relevant established analytical, computational and experimental techniques and methods
Content
Advanced us of Excel and mixed use of spreadsheets and word processing.
- using strings
- using large information material
- using logical, set and search functions
- creating forms and macros
- using analytical tools in engineering
- basic use of pivot tables and charts
Learning materials and recommended literature
The public Study Material consists of the Microsoft Office Software Help website. (https://support.office.com/fi-fi)
Teaching methods
Exercises and learning tasks are in an online learning environment.
Course consists of
- online videos
- reading material in a learning environment
- web discussion
Practical training and working life connections
The course excercises have been prepared based on working life.
Exam dates and retake possibilities
The total performance of the course is made on the basis of the returned assignments in three stages, which correspond to the exam and re-exams. The assignment return schedule is announced at the beginning of the course. If the completion of the course is in progress at the time of the first or second assessment phase, you have the opportunity to complete your performance up to the third assessment phase.
The Course will be introduced online. The address will be sent by e-mail to those who have registered.
Student workload
The scope of the course is 5 cr x 27 h / cr 135 h
- Guide videos 10 h
- Independent study 40 h
- Completion of excecises 85 h
Further information for students
Feedback is given as comments to the e-learning environment during the course. Assessment is based on competence objectives, qualitative, criteria-based.
Students:
Open University of Applied Sciences
CampusOnline
Evaluation scale
Pass/Fail
Evaluation criteria, pass/failed
To achieve approved performance, you must demonstrate that you have mastered the advanced use of spreadsheets. Competence is demonstrated by approved weekly assignments in the areas described in the course content.
Prerequisites
ICT Skills or corresponding studies at university
Enrollment
01.08.2024 - 22.08.2024
Timing
16.09.2024 - 18.12.2024
Number of ECTS credits allocated
5 op
Virtual portion
5 op
Mode of delivery
Online learning
Unit
School of Technology
Campus
Main Campus
Teaching languages
- Finnish
Seats
20 - 70
Teachers
- Juha Kuula
- Anne Rantakaulio
Objectives
You know how to use spreadsheets in depth and you can apply your skills both in your studies and in working life in the field of technology and transport.
Engineering practice:
You have ability to identify, formulate and solve complex engineering problems, by being able to select and having the practical skills to apply relevant established analytical, computational and experimental techniques and methods
Content
Advanced us of Excel and mixed use of spreadsheets and word processing.
- using strings
- using large information material
- using logical, set and search functions
- creating forms and macros
- using analytical tools in engineering
- basic use of pivot tables and charts
Learning materials and recommended literature
The public Study Material consists of the Microsoft Office Software Help website. (https://support.office.com/fi-fi)
Teaching methods
Exercises and learning tasks are in an online learning environment.
Course consists of
- online videos
- reading material in a learning environment
- web discussion
Practical training and working life connections
The course excercises have been prepared based on working life.
Exam dates and retake possibilities
The total performance of the course is made on the basis of the returned assignments in three stages, which correspond to the exam and re-exams. The assignment return schedule is announced at the beginning of the course. If the completion of the course is in progress at the time of the first or second assessment phase, you have the opportunity to complete your performance up to the third assessment phase.
The Course will be introduced on online. The address will be sent by e-mail to those who have registered.
Student workload
The scope of the course is 5 cr x 27 h / cr 135 h
- Guide videos 10 h
- Independent study 40 h
- Completion of excecises 85 h
Further information for students
Feedback is given as comments to the e-learning environment during the course. Assessment is based on competence objectives, qualitative, criteria-based.
Students:
Open University of Applied Sciences 50
CampusOnline 20
Evaluation scale
Pass/Fail
Evaluation criteria, pass/failed
To achieve approved performance, you must demonstrate that you have mastered the advanced use of spreadsheets. Competence is demonstrated by approved weekly assignments in the areas described in the course content.
Prerequisites
ICT Skills or corresponding studies at university
Enrollment
01.08.2024 - 22.08.2024
Timing
02.09.2024 - 09.12.2024
Number of ECTS credits allocated
5 op
Virtual portion
5 op
Mode of delivery
Online learning
Unit
School of Technology
Campus
Main Campus
Teaching languages
- English
Seats
20 - 70
Teachers
- Anne Rantakaulio
Groups
-
TKN22SAKonetekniikka (AMK)
-
TKN24VSDDKonetekniikka (AMK), DD
-
TKN22SBKonetekniikka (AMK)
-
TKN24VSKonetekniikka (AMK), vaihto-opiskelu/Exchange studies
Objectives
You know how to use spreadsheets in depth and you can apply your skills both in your studies and in working life in the field of technology and transport.
Engineering practice:
You have ability to identify, formulate and solve complex engineering problems, by being able to select and having the practical skills to apply relevant established analytical, computational and experimental techniques and methods
Content
Advanced us of Excel and mixed use of spreadsheets and word processing.
- using strings
- using large information material
- using logical, set and search functions
- creating forms and macros
- using analytical tools in engineering
- basic use of pivot tables and charts
Learning materials and recommended literature
The public Study Material consists of the Microsoft Office Software Help website. (https://support.office.com/fi-fi)
Teaching methods
Exercises and learning tasks are in an online learning environment.
Course consists of:
- online videos
- reading material in a learning environment
- web discussion
- guidance in web if needed
Practical training and working life connections
The course excercises have been prepared based on working life.
Exam dates and retake possibilities
The total performance of the course is made on the basis of the returned assignments in three stages, which correspond to the exam and re-exams. The assignment return schedule is announced at the beginning of the course. If the completion of the course is in progress at the time of the first or second assessment phase, you have the opportunity to complete your performance up to the third assessment phase.
1. assessment phase: 25.11.2024
2. assessment phase: 02.12.2024
3. assessment phase: 09.12.2024
The Course will be introduced on 2.9.2024 at 17:00 online. The address will be sent by e-mail to those who have registered.
Student workload
The scope of the course is 5 cr x 27 h / cr 135 h
- Guide videos 10 h
- Independent study 40 h
- Completion of exercises 85 h
Further information for students
Feedback is given as comments to the e-learning environment during the course. Assessment is based on competence objectives, qualitative, criteria-based.
Evaluation scale
Pass/Fail
Evaluation criteria, pass/failed
To achieve approved performance, you must demonstrate that you have mastered the advanced use of spreadsheets. Competence is demonstrated by approved weekly assignments in the areas described in the course content.
Prerequisites
ICT Skills or corresponding studies at university
Enrollment
20.11.2023 - 04.01.2024
Timing
17.01.2024 - 01.05.2024
Number of ECTS credits allocated
5 op
Virtual portion
5 op
Mode of delivery
Online learning
Unit
School of Technology
Campus
Main Campus
Teaching languages
- Finnish
Seats
0 - 100
Teachers
- Juha Kuula
- Anne Rantakaulio
Groups
-
ZJK24KTKorkeakoulujen välinen yhteistyö, TEKN
-
ZJA24KTAvoin AMK, tekniikka
Objectives
You know how to use spreadsheets in depth and you can apply your skills both in your studies and in working life in the field of technology and transport.
Engineering practice:
You have ability to identify, formulate and solve complex engineering problems, by being able to select and having the practical skills to apply relevant established analytical, computational and experimental techniques and methods
Content
Advanced us of Excel and mixed use of spreadsheets and word processing.
- using strings
- using large information material
- using logical, set and search functions
- creating forms and macros
- using analytical tools in engineering
- basic use of pivot tables and charts
Learning materials and recommended literature
The public Study Material consists of the Microsoft Office Software Help website. (https://support.office.com/fi-fi)
Teaching methods
Exercises and learning tasks are in an online learning environment.
Course consists of
- online videos
- reading material in a learning environment
- web discussion
Practical training and working life connections
The course excercises have been prepared based on working life.
Exam dates and retake possibilities
The total performance of the course is made on the basis of the returned assignments in three stages, which correspond to the exam and re-exams. The assignment return schedule is announced at the beginning of the course. If the completion of the course is in progress at the time of the first or second assessment phase, you have the opportunity to complete your performance up to the third assessment phase.
The Course will be introduced online. The address will be sent by e-mail to those who have registered.
Student workload
The scope of the course is 5 cr x 27 h / cr 135 h
- Guide videos 10 h
- Independent study 40 h
- Completion of excecises 85 h
Further information for students
Feedback is given as comments to the e-learning environment during the course. Assessment is based on competence objectives, qualitative, criteria-based.
Students:
Open UAS: 15
CampusOnline: 15
Evaluation scale
Pass/Fail
Evaluation criteria, pass/failed
To achieve approved performance, you must demonstrate that you have mastered the advanced use of spreadsheets. Competence is demonstrated by approved weekly assignments in the areas described in the course content.
Prerequisites
ICT Skills or corresponding studies at university
Enrollment
01.08.2023 - 24.08.2023
Timing
04.09.2023 - 08.12.2023
Number of ECTS credits allocated
5 op
Virtual portion
5 op
Mode of delivery
Online learning
Unit
School of Technology
Campus
Main Campus
Teaching languages
- English
Seats
0 - 40
Degree programmes
- Bachelor's Degree Programme in Mechanical Engineering
Teachers
- Anne Rantakaulio
Groups
-
ZJA23KTHAVAvoin AMK, tekniikka, Hankintaosaaja
-
TKN21SAKonetekniikka (AMK)
-
TKN21SBKonetekniikka (AMK)
-
TKN23VSKonetekniikka (AMK), vaihto-opiskelu/Exchange studies
Objectives
You know how to use spreadsheets in depth and you can apply your skills both in your studies and in working life in the field of technology and transport.
Engineering practice:
You have ability to identify, formulate and solve complex engineering problems, by being able to select and having the practical skills to apply relevant established analytical, computational and experimental techniques and methods
Content
Advanced us of Excel and mixed use of spreadsheets and word processing.
- using strings
- using large information material
- using logical, set and search functions
- creating forms and macros
- using analytical tools in engineering
- basic use of pivot tables and charts
Learning materials and recommended literature
The public Study Material consists of the Microsoft Office Software Help website. (https://support.office.com/fi-fi)
Teaching methods
Exercises and learning tasks are in an online learning environment.
Course consists of:
- online videos
- reading material in a learning environment
- web discussion
- guidance in web if needed
Practical training and working life connections
The course excercises have been prepared based on working life.
Exam dates and retake possibilities
The total performance of the course is made on the basis of the returned assignments in three stages, which correspond to the exam and re-exams. The assignment return schedule is announced at the beginning of the course. If the completion of the course is in progress at the time of the first or second assessment phase, you have the opportunity to complete your performance up to the third assessment phase.
1. assessment phase: 24.11.2023
2. assessment phase: 01.12.2023
3. assessment phase: 08.12.2023
The Course will be introduced on 4.9.2022 at 17:00 online. The address will be sent by e-mail to those who have registered.
Student workload
The scope of the course is 5 cr x 27 h / cr 135 h
- Guide videos 10 h
- Independent study 40 h
- Completion of exercises 85 h
Further information for students
Feedback is given as comments to the e-learning environment during the course. Assessment is based on competence objectives, qualitative, criteria-based.
Evaluation scale
Pass/Fail
Evaluation criteria, pass/failed
To achieve approved performance, you must demonstrate that you have mastered the advanced use of spreadsheets. Competence is demonstrated by approved weekly assignments in the areas described in the course content.
Prerequisites
ICT Skills or corresponding studies at university
Enrollment
01.11.2022 - 05.01.2023
Timing
16.01.2023 - 19.04.2023
Number of ECTS credits allocated
5 op
Virtual portion
5 op
Mode of delivery
Online learning
Unit
School of Technology
Campus
Main Campus
Teaching languages
- Finnish
Seats
0 - 20
Teachers
- Juha Kuula
- Anne Rantakaulio
Teacher in charge
Juha Kuula
Groups
-
ZJA23KTHAVAvoin AMK, tekniikka, Hankintaosaaja
-
ZJA23KTAvoin AMK, tekniikka
Objectives
You know how to use spreadsheets in depth and you can apply your skills both in your studies and in working life in the field of technology and transport.
Engineering practice:
You have ability to identify, formulate and solve complex engineering problems, by being able to select and having the practical skills to apply relevant established analytical, computational and experimental techniques and methods
Content
Advanced us of Excel and mixed use of spreadsheets and word processing.
- using strings
- using large information material
- using logical, set and search functions
- creating forms and macros
- using analytical tools in engineering
- basic use of pivot tables and charts
Learning materials and recommended literature
The public Study Material consists of the Microsoft Office Software Help website. (https://support.office.com/fi-fi)
Teaching methods
Exercises and learning tasks are in an online learning environment.
Course consists of
- online videos
- reading material in a learning environment
- web discussion
Practical training and working life connections
The course excercises have been prepared based on working life.
Exam dates and retake possibilities
The total performance of the course is made on the basis of the returned assignments in three stages, which correspond to the exam and re-exams. The assignment return schedule is announced at the beginning of the course. If the completion of the course is in progress at the time of the first or second assessment phase, you have the opportunity to complete your performance up to the third assessment phase.
The Course will be introduced on xx.xx.xxxx at 17:00 online. The address will be sent by e-mail to those who have registered.
Student workload
The scope of the course is 5 cr x 27 h / cr 135 h
- Guide videos 10 h
- Independent study 40 h
- Completion of excecises 85 h
Further information for students
Feedback is given as comments to the e-learning environment during the course. Assessment is based on competence objectives, qualitative, criteria-based.
Students:
Open UAS: 15
CampusOnline: 15
Evaluation scale
Pass/Fail
Evaluation criteria, pass/failed
To achieve approved performance, you must demonstrate that you have mastered the advanced use of spreadsheets. Competence is demonstrated by approved weekly assignments in the areas described in the course content.
Prerequisites
ICT Skills or corresponding studies at university
Enrollment
01.08.2022 - 25.08.2022
Timing
29.08.2022 - 21.12.2022
Number of ECTS credits allocated
5 op
Virtual portion
5 op
Mode of delivery
Online learning
Unit
School of Technology
Campus
Main Campus
Teaching languages
- Finnish
Seats
0 - 20
Teachers
- Juha Kuula
- Anne Rantakaulio
Teacher in charge
Juha Kuula
Groups
-
ZJK22STKorkeakoulujen välinen yhteistyö, TEKN
-
ZJA22STHAHAvoin amk, Hankintaosaaja 1, Helsinki, Monimuoto
-
ZJA22STAvoin AMK, tekniikka
-
ZJA22STHAVAvoin amk, Hankintaosaaja 1, Verkko
Objectives
You know how to use spreadsheets in depth and you can apply your skills both in your studies and in working life in the field of technology and transport.
Engineering practice:
You have ability to identify, formulate and solve complex engineering problems, by being able to select and having the practical skills to apply relevant established analytical, computational and experimental techniques and methods
Content
Advanced us of Excel and mixed use of spreadsheets and word processing.
- using strings
- using large information material
- using logical, set and search functions
- creating forms and macros
- using analytical tools in engineering
- basic use of pivot tables and charts
Learning materials and recommended literature
The public Study Material consists of the Microsoft Office Software Help website. (https://support.office.com/fi-fi)
Teaching methods
Exercises and learning tasks are in an online learning environment.
Course consists of
- online videos
- reading material in a learning environment
Practical training and working life connections
The course excercises have been prepared based on working life.
Exam dates and retake possibilities
The total performance of the course is made on the basis of the returned assignments in three stages, which correspond to the exam and re-exams. The assignment return schedule is announced at the beginning of the course. If the completion of the course is in progress at the time of the first or second assessment phase, you have the opportunity to complete your performance up to the third assessment phase.
The Course will be introduced on xx.xx.xxxx at 17:00 online. The address will be sent by e-mail to those who have registered.
Student workload
The scope of the course is 5 cr x 27 h / cr 135 h
- Guide videos 10 h
- Independent study 40 h
- Completion of excecises 85 h
Further information for students
Feedback is given as comments to the e-learning environment during the course. Assessment is based on competence objectives, qualitative, criteria-based.
Students:
Open University of Applied Sciences 50
CampusOnline 20
Evaluation scale
Pass/Fail
Evaluation criteria, pass/failed
To achieve approved performance, you must demonstrate that you have mastered the advanced use of spreadsheets. Competence is demonstrated by approved weekly assignments in the areas described in the course content.
Prerequisites
ICT Skills or corresponding studies at university
Enrollment
01.08.2022 - 25.08.2022
Timing
29.08.2022 - 21.12.2022
Number of ECTS credits allocated
5 op
Virtual portion
5 op
Mode of delivery
Online learning
Unit
School of Technology
Campus
Main Campus
Teaching languages
- English
Seats
0 - 40
Degree programmes
- Bachelor's Degree Programme in Mechanical Engineering
Teachers
- Anne Rantakaulio
Teacher in charge
Juha Kuula
Groups
-
TKN20S1Konetekniikka (AMK)
Objectives
You know how to use spreadsheets in depth and you can apply your skills both in your studies and in working life in the field of technology and transport.
Engineering practice:
You have ability to identify, formulate and solve complex engineering problems, by being able to select and having the practical skills to apply relevant established analytical, computational and experimental techniques and methods
Content
Advanced us of Excel and mixed use of spreadsheets and word processing.
- using strings
- using large information material
- using logical, set and search functions
- creating forms and macros
- using analytical tools in engineering
- basic use of pivot tables and charts
Learning materials and recommended literature
The public Study Material consists of the Microsoft Office Software Help website. (https://support.office.com/fi-fi)
Teaching methods
Exercises and learning tasks are in an online learning environment.
Course consists of:
- online videos
- reading material in a learning environment
- web discussion
- guidance in web if needed
Practical training and working life connections
The course excercises have been prepared based on working life.
Exam dates and retake possibilities
The total performance of the course is made on the basis of the returned assignments in three stages, which correspond to the exam and re-exams. The assignment return schedule is announced at the beginning of the course. If the completion of the course is in progress at the time of the first or second assessment phase, you have the opportunity to complete your performance up to the third assessment phase.
1. assessment phase: 25.11.2022
2. assessment phase: 02.12.2022
3. assessment phase: 09.12.2022
The Course will be introduced on 5.9.2022 at 17:00 online. The address will be sent by e-mail to those who have registered.
Student workload
The scope of the course is 5 cr x 27 h / cr 135 h
- Guide videos 10 h
- Independent study 40 h
- Completion of exercises 85 h
Further information for students
Feedback is given as comments to the e-learning environment during the course. Assessment is based on competence objectives, qualitative, criteria-based.
Evaluation scale
Pass/Fail
Evaluation criteria, pass/failed
To achieve approved performance, you must demonstrate that you have mastered the advanced use of spreadsheets. Competence is demonstrated by approved weekly assignments in the areas described in the course content.
Prerequisites
ICT Skills or corresponding studies at university
Enrollment
01.11.2021 - 09.01.2022
Timing
19.01.2022 - 27.04.2022
Number of ECTS credits allocated
5 op
Virtual portion
5 op
Mode of delivery
Online learning
Unit
School of Technology
Campus
Main Campus
Teaching languages
- Finnish
Seats
0 - 50
Teachers
- Juha Kuula
- Anne Rantakaulio
Teacher in charge
Juha Kuula
Groups
-
TLS20S1Bachelor's Degree Programme in Logistics
-
TLS19S1Bachelor's Degree Programme in Logistics
-
ZJK22KTKorkeakoulujen välinen yhteistyö, TEKN
-
ZJA21STPPLOAvoin amk, tekniikka, Logistiikka päivä
-
TLS21S1Logistiikan tutkinto-ohjelma (AMK)
-
ZJA22KTHAHAvoin AMK, tekniikka, Hankintaosaaja 1, Helsinki
-
ZJA22KTAvoin AMK, tekniikka
-
TLS18S1Bachelor's Degree Programme in Logistics
Objectives
You know how to use spreadsheets in depth and you can apply your skills both in your studies and in working life in the field of technology and transport.
Engineering practice:
You have ability to identify, formulate and solve complex engineering problems, by being able to select and having the practical skills to apply relevant established analytical, computational and experimental techniques and methods
Content
Advanced us of Excel and mixed use of spreadsheets and word processing.
- using strings
- using large information material
- using logical, set and search functions
- creating forms and macros
- using analytical tools in engineering
- basic use of pivot tables and charts
Learning materials and recommended literature
Videos are shared in e-learning environment. (https://moodle.jamk.fi)
The public Study Material consists of the Microsoft Office Software Help website. (https://support.office.com/fi-fi)
Teaching methods
Exercises and learning tasks are in an online learning environment.
Course consists of
- online videos
- reading material in a learning environment
- web discussion
Practical training and working life connections
The course excercises have been prepared based on working life.
Exam dates and retake possibilities
The total performance of the course is made on the basis of the returned assignments in three stages, which correspond to the exam and re-exams. The assignment return schedule is announced at the beginning of the course. If the completion of the course is in progress at the time of the first or second assessment phase, you have the opportunity to complete your performance up to the third assessment phase.
This course implementation is only in Finnish. The Course will be introduced on xx.xx. at xx:xx online. The address will be sent by e-mail to those who have registered.
Student workload
The scope of the course is 5 cr x 27 h / cr 135 h
- Guide videos 10 h
- Independent study 40 h
- Completion of excecises 85 h
Further information for students
This course implementation is in finnish.
Feedback is given as comments to the e-learning environment during the course. Assessment is based on competence objectives, qualitative, criteria-based.
Students:
Procurement specialist 8
Open University of Applied Sciences 50
CampusOnline 20
Evaluation scale
Pass/Fail
Evaluation criteria, pass/failed
To achieve approved performance, you must demonstrate that you have mastered the advanced use of spreadsheets. Competence is demonstrated by approved weekly assignments in the areas described in the course content.
Prerequisites
ICT Skills or corresponding studies at university