Excelin edistynyt käyttö tekniikan sovelluksissa (5 cr)
Code: TLXV1580-3007
General information
Enrollment
02.08.2021 - 05.09.2021
Timing
06.09.2021 - 31.12.2021
Number of ECTS credits allocated
5 op
Virtual portion
5 op
Mode of delivery
Online learning
Unit
Teknologiayksikkö
Campus
Pääkampus
Teaching languages
- English
Seats
0 - 20
Degree programmes
- Konetekniikka (AMK)
Teachers
- Anne Rantakaulio
Teacher in charge
Anne Rantakaulio
Groups
-
TKN21VKKonetekniikka (AMK), vaihto-opiskelu/Exchange studies
-
TKN19SMKonetekniikka
-
TLP21VSBachelor's Degree Programme in Purchasing and Logistics Engineering (AMK) vaihto-opiskelu/Exchange studies
-
TKN19SBKonetekniikka B
-
TKN20SMKonetekniikka
-
TKN19SAKonetekniikka A
-
TSA22VKDDSähkö- ja automaatiotekniikka (AMK), DD
-
TLE19S1Degree Programme in International Logistics
-
TLE18S1Degree Programme in International Logistics
-
TKN20S1Konetekniikka (AMK)
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
Oppimateriaali ja suositeltava kirjallisuus
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
Employer connections
The course excercises have been prepared based on working life.
Exam schedules
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 6.9.2021 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
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
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.
Qualifications
ICT Skills or corresponding studies at university