Skip to main content

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

16.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
  • TKN22SA
    Konetekniikka (AMK)
  • TKN24VSDD
    Konetekniikka (AMK), DD
  • TKN22SB
    Konetekniikka (AMK)
  • TKN24VS
    Konetekniikka (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 16.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
  • ZJK24KT
    Korkeakoulujen välinen yhteistyö, TEKN
  • ZJA24KT
    Avoin 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
  • ZJA23KTHAV
    Avoin AMK, tekniikka, Hankintaosaaja
  • TKN21SA
    Konetekniikka (AMK)
  • TKN21SB
    Konetekniikka (AMK)
  • TKN23VS
    Konetekniikka (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
  • ZJA23KTHAV
    Avoin AMK, tekniikka, Hankintaosaaja
  • ZJA23KT
    Avoin 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
  • ZJK22ST
    Korkeakoulujen välinen yhteistyö, TEKN
  • ZJA22STHAH
    Avoin amk, Hankintaosaaja 1, Helsinki, Monimuoto
  • ZJA22ST
    Avoin AMK, tekniikka
  • ZJA22STHAV
    Avoin 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
  • TKN20S1
    Konetekniikka (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
  • TLS20S1
    Bachelor's Degree Programme in Logistics
  • TLS19S1
    Bachelor's Degree Programme in Logistics
  • ZJK22KT
    Korkeakoulujen välinen yhteistyö, TEKN
  • ZJA21STPPLO
    Avoin amk, tekniikka, Logistiikka päivä
  • TLS21S1
    Logistiikan tutkinto-ohjelma (AMK)
  • ZJA22KTHAH
    Avoin AMK, tekniikka, Hankintaosaaja 1, Helsinki
  • ZJA22KT
    Avoin AMK, tekniikka
  • TLS18S1
    Bachelor'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