Kisi-Kisi LKS Makasar 08 IT - SOFTWARE APPLICATION

1. TECHNICAL/COMPETITION DESCRIPTION (TD)

This competition is designed to test specialist users of software applications. The skill involves the ability to:
o Undertake document processing
o Prepare and use a personal relational database
o Create and use spreadsheets
o From a given design create and use spreadsheets
o Produce and amend graphics and drawings
o Create and edit application macros and make use of software customization facilities (the competitor should be able to choose the method of creation/editing - no question should be of the level that could only be resolved using programming tools e.g. Vba)
o Create slide show presentations
o Access, store and use files on a local area network
o Organizing location of files and maintaining links between them
o Access different printers on a network
o Understand and use basic processes in a business-commercial environment
o Manipulate, present and communicate information in a business/commercial environment
o Prepare electronic files for viewing on the internet
o Access and retrieve data from a restricted on site intranet
o Exporting of documents to other forms, such as, pdf, text, csv files, or html documents to be viewed in a browser.

Generally, those skills are divided into four major groups of skill test:

Group
Software
Database
Microsoft Access 2003
Spreadsheet
Microsoft Excel 2003
Document Processing
Microsoft Word 2003
Graphic and Electronic Presentation
Microsoft PowerPoint 2003, Corel Draw 12, Adobe Photoshop CS3









2. DETAIL COMPETITION MATERIAL

Detail material of each group will be explained in this section.

2.1 Database Case Materials

Database and Table
Creating and Editing Database
Creating and Editing Tables
Changing Table Design
Import Data from others type of file (txt, xls, html, etc.)
Lookup Data
Customizing Field Properties (Format , Input Mask , Validation, look up etc)
Query
Creating Query (from more than one tables, adding new field, formatting fields in query, aggregation) and naming
Creating insert, update, and delete query
Using operators
Using functions
Using formulas
Form
Creating Single Form and naming
Creating Sub Form, including displaying different data/view in different tabs.
Creating form to view, entry, and querying data
Formatting form
Using Control Tool Box(checkbox, combo box, list box, image, etc.)
Using submit button and its combination (next, previous, print, close, save, delete, close, print, etc.), modifying navigation setting,
Modifying existing form
Able to display data from combination of more than one field
Report
Creating Report from one or more table(s) resource and naming
Inserting pictures in report
Report’s formatting, header, footer, page break, and subtotal etc.
Able to perform reports in letter formats (mail merge)
Switchboard
Creating Switchboard manager and naming
Able to open form or reports
Switchboard’s formatting, Inserting picture into switchboard, etc.








2.2 Spreadsheet Case Material

Cell Manipulation
Font, Color, Border
Formula & function
Arithmetic
Lookup function (vlookup, hlookup, etc)
Mathematic function
General function (sum, max, min, etc)
Logical function (if )
Macro
Toolbar form and control tool box (button, label, group box, check box, list box, etc)
Macro application using Vba ( reset form, search and retrieve data, etc)
Appending data
Data validation
Search and filtering data
Solver
Linear problem solving using solver
Setting goal
Setting changing variable
Setting constraint
Graph manipulation
Various type of graphic
Color setting
Scaling


2.3 Graphic & Presentation

Graphic – Corel Draw
Designing Logo, including Geometric shape, cutting, shaping and reshaping object, convert to curve, combining object, etc
Picture manipulation including color and shape editing, etc

Presentation
Slide template design and manipulation
Hyperlink in presentation
Inserting few types of components
Custom animation
Slide transition
Slide effect







2.4 Document Processing

Document manipulation
Manipulation of document and manipulation
Type and size of font
Background and foreground manipulation
Special layout design
Bullet & Numbering
Table manipulation
Table creation
Table’s border
Drawing
Special drawing shape
Inserting and manipulation picture
Using text box
Using word art
Using clip art
Document Template
Document template creation
Menu creation using macro
Macro
Creating additional toolbar
Creating additional menu
Creating macro to manipulate document
Document link
Header and footer
Mail Merge
Retrieving data from several data source to create mass letter
Field positioning and formatting
Miscellaneous
Security


3. COMPETITION SCENARIO

3.1 Opening Day

¨ Welcome ceremony

¨ Technical Briefing
1. Explanation of Competition rules
2. Explanation of technical description
3. Marking Schema
4. Competitor working place’s arrangement





¨ Familiarization
1. Hardware PC Client & PC SERVER checking
2. Software checking
3. Competition working place checking

3.2 Competition Day 1

No
Schedule
Activity
1.
08:00 – 10.00
Database 1
2.
10:00 – 10:15
Break and Submission
3.
10:15 – 12:15
Database 2
4.
12:15 – 13:15
Break + Lunch
5.
13:15 – 15:15
Spreadsheet 1

3.3 Competition Day 2

No
Schedule
Activity
6.
08:00 – 10.00
Spreadsheet 2
7.
10:00 – 10:15
Break and Submission
8.
10:15 – 12:15
Graphic
9.
12:15 – 13:15
Break + Lunch
10.
13:15 – 15:15
Electronic Presentation

3.4 Competition Day 3

No
Schedule
Activity
11.
08:00 – 10.00
Document Processing 1
12.
10:00 – 10:15
Break and Submission
13.
10:15 – 12:15
Document Processing 2
14.
12:15 – 13:15
Break + Lunch


4. MARKING GUIDELINE

Marking will be done after each module finished
Competitor that is capable to finish current module before submission time is not permitted to start doing the next module.
Competitors are not allowed to revise the submitted module after the submission time.
Competitors are not allowed to bring any electronic and printed material to competition area.
All marking is designed into objective category.
Jury is checking based on given check list. One checklist may contain more than one marking components. Missing or incorrect result on one of those components will be assumed as wrong answer.




Marking Percentage :
Ø Database : 25%
Ø Spreadsheet : 25%
Ø Graphic & Presentation : 25%
Ø Document Processing : 25%


5. FACILITIES

3.1 Hardware

The following machines and equipment will be made available to each competitor:
Computer for each competitor :
Motherboard duo core / core 2 duo + Driver, 1.8 GHz
LAN Card, VGA Card min 256 MB
Network capabilities of 100MBPS
Keyboard, Mouse PS/2
Hard disk min 80 GB 7200 RPM
Memory minimal 1 GB
Speaker, Microphone
Monitor LCD minimal 17”
File Server
CD/DVD Writer
CD Blank
Printer A3 Laserjet, speed min 28ppm
UPS 10 KW
Document holder and stationary

3.2 Software

The software used by competitors will be representative of widely accepted International software and may represent several software producers. One important aspect will be the integration potential between the various types of software. This will require a careful check but software of the following kind will be required for each computer system:

Microsoft Windows 2003
Microsoft Office 2003
Adobe Photoshop CS3
Corel Draw 12