204 IT / Software Applications

Finalists

  • Tobias Back, Vamia
  • Liina-Lotta Forsström, Helsinki Business College Oy
  • Joonas Hiltunen, Helsinki Business College Oy
  • Eevert Holma, Mercuria Kauppiaitten Kauppaoppilaitos
  • Saku Lehtola, Mercuria Kauppiaitten Kauppaoppilaitos
  • Timo Nurmivaara, Helsinki Business College Oy
  • Santeri Pallari, Jyväskylän koulutuskuntayhtymä Gradia
  • Mikael Sekkouri, Mercuria Kauppiaitten Kauppaoppilaitos

International competitor

  • Evgenii Gerasimov (Russia)

Competition task structure and central task module components

There is a theme to the tasks: Pohjois-Karjalan maakuntaliitto (Regional Council of North Carelia).

The competitor must have a good knowledge of English. The software is in English, and the files processed in the tasks are also in English.

The competitors do the tasks by using office tool software (Word, Excel and PowerPoint). In the final tasks, the competitor must also know how to seek and process external database information (the database is a local SQL Server Express database), which is done by PowerPivot and Word and/or Excel. The competitor must know how to read and interpret an ER model and database table definitions. Designing an ER model is not included in the competition task.

Module 1. Excel, 40 points

  • functions (financial, time, search, calculate, logical, text)
  • conditional formatting
  • models
  • pivot and solver
  • data validation
  • sorting, filtering and subtotal
  • protection
  • financial calculations
    form control widgets
  • import of data
  • macro recording

Module 2. Word, 25 points

  • document templates
  • text formatting
  • document template
  • long documents
  • chapters and bullets
  • newsletter and forms
  • automatic data source
  • tables
  • form functions
  • utilization of graphic instructions

Module 3. PowerPoint, 20 points

  • designing and performing the slide presentation
  • presentation styles
  • import of data
  • advanced animation
  • shapes, smart-art and chart
  • text effects
  • timing and interaction
  • action buttons
  • picture formatting
  • transition, effects and animations
  • usage of media
  • utilization of graphic instructions

Module 4. Utilizing external databases, 15 points

  • collaborative use of programs
  • utilizing external databases
  • sharing of data between programs
  • file storage formats

 

Express tasks

  • There will be at least three express tasks.
  • The express tasks have no impact on total points.
  • The competitors get separate awards for the express tasks.

 

Task duration and allotted time

The task duration is from 20 minutes to 1,5 hours. The total competition time is 14 hours.

 

Main assessment criteria

The competition tasks are based on the basic qualification in Business and in Information and Telecommunication technology. The required skill level is in line with the Excellent grade of the qualification.

 

Description of the assessment process

Objective assessment is used in all tasks. The competition task should observe the compulsory themes of the Taitaja competition: Entrepreneurship, Sustainable development, Wellbeing at work and Work safety.

 

Materials, equipment and work phases used and the competition area

Every competitor has a usual office work station. The competition organizer provides:

  • a usual office workstation with Windows 10 operating system (in English), Microsoft Office 2016 Professional tool software (in English), Internet Explorer, Mozilla Firefox and Google Chrome browsers, Adobe Acrobat Reader PDF reader program and other programs which needed.
  • USB flash drive
  • Internet access
  • HeadSet headphones with microphone

 

What the competitor brings to the competition venue

The competitor may bring along personal headphones if he or she wishes to listen to music during the work.

 

A sample task and assessment as a whole

There is a theme to the tasks: Pohjois-Karjalan maakuntaliitto (Regional Council of North Carelia).

The competitors perform the tasks:

  • Office tool programs (Word, Excel ja PowerPoint). Previous final tasks can be found at the Skills Finland website and www.taitaja.com.
  • In the final tasks, the competitor must also know how to seek and process external database information (the database is a local SQL Server Express database), which is done by PowerPivot and Word and/or Excel.
  • The competitor must know how to read and interpret an ER model and database table definitions. Designing an ER model is not included in the competition task.
  • The competitor must have a good knowledge of English. The software is in English, and the files processed in the tasks are also in English.

 

Judges

  • main judge Hannu Hokkanen, Business College Helsinki Oy
  • Harri Hautala, Business College Helsinki Oy
  • Risto Oksanen, Business College Helsinki Oy
  • Teemu Aho, Gradia
  • Minna Niskanen, Gradia
  • Juhani Kuivaniemi, Keski-Pohjanmaan ammattiopisto
  • Riitta Mahlamäki, Koulutuskeskus Sedu
  • Tomi Tirroniemi, Mercuria
  • Päivi Keskitalo, Tredu

Taitaja Competition enables the develompent of competence and competence demonstration for the competitors. The judges of the skill categories will give feedback to the competitors during the competition and they will also evaluate the competition tasks. The presentations and ideas created during the competition are in the public domain and can be used by an individual or an enterprise. The presentations and ideas can be used as they are or further developed. The Taitaja2019 event is mainly publicly funded from the semifinals to the finals. The materials produced during the event are openly availabe without any usage fees.