Information technology tools 2 (5 cr)

Objective

You know how to use the more advanced functions of Excel and effectively share data between various pieces of software and applications.
You know how to use Excel in the calculations necessary in your field of study.
You can produce and process simple digital content and you understand the importance of user's rights and licenses.
You can choose the appropriate tool to solve a problem and solve simple problems related to the use of personal technology, and determine what skills you need to improve further.

Content

How is an embedded or linked table added to a Word document or Power Point presentation from a spreadsheet program?
How are forms created in Word?
How to insert comments in a Power Point presentation?
How to use the special functions of Excel, such as financial, logical, date and time functions? How to utilize the sorting and filtering features, and calculate subtotals in larger tables?
How to use and utilize the Pivot tables when reporting and analyzing data?
How to use Pivot table summary functions and utilize automatic calculation?
How to make and edit graphical presentations such as trend curves, combination charts and Pivot charts?
How to use the aim search and solver?
How do you calculate the clock times? How to protect your tables and sections of tables?

Course material

Ornanet-materiaalit, opettajan materiaali

Timing of exams and assignments

LOKT20SM1: Uusintatenttipäivät: ma 20.9.2021 klo 16.30 – 18.00, ma 29.11.2021 klo 16.30 - 18.00 ja ma 28.3.2022 klo 16.30 - 18.00. Ilmoittautuminen vähintään 10 vuorokautta ennen tenttiä sähköpostitse Virpille (virpi.aalto@xamk.fi). Tentti suoritetaan Learnissa etänä. MUUTOKSET MAHDOLLISIA!

Further information

Avaimen Moodleen saa lähiopetustunnilla.

Evaluation scale

1-5

Qualifications

Information technology tools 1 or equivalent knowledge.