204 Data processing

The competition tasks of this skill category are based on the Vocational qualification in Information and Communications Technology, and on the Vocational Qualification in Business. 

Depending on the competence area, working place can be e.g. in the information and communications technology environment, or finance- and office work in different companies or in the public sector. 

#taitaja2021 #dataprocessing 

Semifinal

Semifinals are not organized to international competitors.

Final

The page will be launched in March 2021.

Results

The results of the final will be released May 20, 2021.

Description of the skill category

The competition consists of customer service- and specialist tasks. Therefore, competing the tasks requires good skills in problem solving and communication. 

Successful competitor knows how to train, assist and guide the customer in using the information technology as well as solves problems related to use of programs. 

Competition is individual. 

Skill requirements

Competence requirements are based on the requirements and criteria of ”Excellent” in the vocational qualification, including competence requirements of the task modules. 

  • Spreadsheet (Excel) 
    • Processing spreadsheet data (filtering, subtotals, protection, linking, importing data) 
    • Adding illustrations to a spreadsheet (images, objects, links, comments, editing charts) 
    • Calculations and functions, e.g. Sum, If, Sumif, Plookup, Vlookup, Count, Countif. In addition, Goal seek. 
    • Macro recording and producing a macro button 
  • Text formatting (Word) 
    • Styles and document templates 
    • Long documents (section breaks, footers and headers, table of contents, indexes, references and bibliographies) 
    • Columns (dividing a text into columns) 
    • Merge functions (address labels and newsletters, connecting to a data source) 
    • Forms (creating and editing tables and form fields) 
  • Presentation graphics (PowerPoint) 
    • Diverse use of images and drawing tools, animations 
    • Inserting and editing charts and objects, as well as RGB-color definitions 
    • Slide-specific effects, text effects, action buttons, hyperlinks 

The tasks may also be solved using Excel add-ons: PowerQuery and PowerPivot. 

To accomplish the tasks, a competitor must be familiar with the Office Object Linking and Embedding(OLE) – features.

The fulfilment of the competition task will be accepted as the completion of the Advanced license. 

Main event partners

  • Lapin koulutuskeskus Redun logo. Linkki Redun verkkosivuille.
  • Ammattiopisto Lappian logo. Linkki Lappian verkkosivuille.
  • Koulutuskeskus Jedun logo. Linkki Jedun verkkosivuille.
  • Oulun Palvelualan Opiston logo. Linkki OPAO:n verkkosivuille.
  • Ammattiopisto Luovin logo. Linkki Luovin verkkosivuille.
  • Suomen Diakoniaopiston logo. Linkki Suomen Diakoniaopiston verkkosivuille.
  • Skills Finlandin logo, linkki Skills Finlandin verkkosivuille.