TIPS FOR PC OPERATION NC2 ASSESSMENT

PC Operation NC2 (PC Operation National Certification Level II) Assessment is composed of areas of competencies, namely (1) Operate a Word Processing Application, (2) Operate a Spreadsheet Application, (3) Operate a Presentation Package and (4) Operate Email and Search the Web Using Browser.  The assessment is composed of two parts, the first part is the demonstration which runs for 2 hours and the second part is the one-on-one interview with the assessor. 

The assessor may ask you to perform several skills or ask your underpinning knowledge.  Here are the things you should expect in PC Operation NCII assessment:

OPERATE A WORD Processing Application

Creating Documents

•      Creating a blank document
•    Opening an existing document
•      Saving a document in specified folder or directory

Formatting Documents

•   Apply specified formatting to character/paragraph such as changing of font, font size, color, appearance etc.
•   Learn to use the Styles and Formatting command which includes creating new styles and editing existing style.
•     Used of numbered and bulleted lists
•     Use of border, textboxes and shading
•     Can perform spelling and grammar check

Changing Page Appearance and Layout

•      Changing of margins, page size and orientation
•      Inserting of page numbers, section breaks and page breaks
•      Inserting of footnotes, cross-references and bookmarks.
•      Creating table of contents
•    Saving of documents in another file format. (e.g As Web Page, XML Document Rich Text File etc.)

Creating and Formatting Tables

•     Inserting table into document
•     Adding or deleting of rows and columns
  
•   Formatting table cells
•   Copying of table

Inserting Object

•  Inserting image (clipart/picture)
• Inserting Wordart and other objects
•  Resizing, positioning, and cropping of image

Customizing Basic Setting

• Activating and de-activating of toolbars

Basic Knowledge in Using Mail Merge

Previewing of document before printing

Print document according to specification (setting of pages to be printed and number of copies to be printed).

OPERATE A SPREADSHEET APPLICATION 

Creating Spreadsheet

• Creating a new worksheet
•  Entering data into worksheet
• Creating formula
•  Cells, columns and row formatting
• Saving of workbook in a specified folder or directory

Customize Basic Settings

• Adjusting page layout (margins, orientation, paper size)
• Activating and de-activating of toolbars

Format Worksheet

• Basic text/paragraph formatting (font style, size, color, appearance)
•  Application of borders, shading, and backgrounds.
•  Formatting of decimal places, comma and currency symbol

Inserting objects

• Creating chart according to the specified data.
• Use of different chart (bar, column, pie, line etc.)
• Formatting of chart based on the data in the worksheet
• Inserting of images (clipart/picture)

Familiarize commonly used formula other than arithmetic function (addition, subtraction, multiplication and division).

- suggested formula to familiarize: min, max, average, count, if

Print Worksheet

• Setting the print area
• Inserting of header and footer
• Printing of worksheet according to specification 

OPERATE A PRESENTATION PACKAGE

 Creating Presentation

• Inserting new slide according to specification
• Saving presentation in specified folder or directory
• Opening an existing presentation

Formatting a Presentation

• Apply specified formatting to the text which includes changing of font style, size, color, appearance etc.
• Use of bulleted and numbered list
• Use of slide layout
• Use of Design Template
• Rearranging of slides according to specification
• Deleting or copying of slides
• Use of Master Slide

Inserting Objects

• Inserting, resizing, positioning and cropping of images (clipart/picture)
• Inserting and editing of chart and graph
• Inserting and editing of tables
• Inserting and editing of organizational chart

Animating the Presentation

• Adding slide transition effects
• Creating custom animation for objects (Entrance, Emphasis, Exit, Motion Path)
• Use of on-screen navigation tools.

Print presentation according to specification.

 Operate Email and Search the Web Using Browser 

Access the Internet

• Launch an Internet Browser
• Setting the Home Page according to specification
• Modification of toolbars (activating/de-activating of toolbars)
• Accessing a particular website using the URL

Search the Internet

• Searching a particular topic on the internet using a search engine
• Creating a bookmark

Send and Organize Message

• Opening an e-mail account
• Composing of e-mail message
• Use of CC and BCC
• Attaching of files in an e-mail
• Sending e-mail
• Downloading and saving of attached files

Create an address book

• Adding a new address in the address book
• Creating of distribution list

 Source: TESDA Training Regulations (TR) for PC Operation NCII