Tips on how to pass PC OPERATION NC-II
September 29, 2009Tips on how to pass PC Operation NC-II (PC Operation National Certification Level-II). The PC Operation NC-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 Demonstration (2 hours) and the one-on-one interview with the assessor.
Here are tips on how to pass PC Operation NCII assessment:
MS 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
- Perform spelling and grammar check
Changing Page Appearance and Layout
- Margins, page size and orientation
- Inserting page numbers, section breaks and page breaks
- Inserting footnotes, cross-references and bookmarks.
- Create a table of content.
- 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
Inserting Object
- Inserting image (clipart/picture)
- Inserting Word art and other objects
- Resizing, positioning, and cropping of image
OPERATE A SPREADSHEET APPLICATION
Creating Spreadsheet
- Creating a new worksheet
- Entering data
- Creating formula
- Cells, columns and row formatting
- Saving of workbook in a specified folder or directory
Format Worksheet
- Basic text/paragraph formatting (font style, size, color, appearance)
- Apply borders, shading, and backgrounds.
- Using of decimal places, comma and currency symbol
Inserting objects
- Creating chart according to the specified data.
- Formatting of chart based on the data in the worksheet
- Inserting of images (clipart/picture)
Familiarize commonly used formula
- 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
- 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
- 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.
OPERATE EMAIL AND SEARCH THE WEB USING BROWSER
Access the Internet
- Launch Internet Browser
- Setting the Home Page according to specification
- Modification of toolbars
- Access 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
- Attaching of files in an e-mail
- Sending e-mail
- Use of CC and BCC
- Downloading and saving of attached files
Create an address book
- Adding a new address in the address book
- Creating of distribution list


