Local Award Courses

The Local Award Courses offered are:

Certificate in Web Development with Dreamweaver CS5

Certificate in Graphics Design with Adobe® Photoshop CS5

Certificate in Programming with Visual Basic 2010

Certificate in Fundamentals of Graphics Design

Certificate in Advanced Graphics Design

Certificate in Computerized Accounting - Accounts Implementation in MYOB

Certificate in Computerized Accounting- MYOB for End-Users

Certificate in Computerized Payroll

Certificate in Animation Design with Flash CS5

Certificate in Essentials of Office Computing

Certificate in Advanced Office Computing

Computers at Beginners Level

Computers at Intermediate Level

Computers at Advanced Level

Relational Database Design and Implementation

 



Certificate in Web Development with Dreamweaver CS5


Adobe® Dreamweaver CS5 introduces the candidate to the fundamentals of building effective web sites, as well as diverse Internet career opportunities. The participants will learn how to use Dreamweaver CS5 to create and modify Websites. You will also learn how to plan and define a Web site; create web pages, format text; define structural elements; create and apply CSS style, create rules; insert and modify tables, images, and links; test and manage Web site files; and publish a site.

Capabilities Addressed

- Website Overview – Internet basics, Dreamweaver CS5 workspace, basic editing and code tools
- Websites and Pages – creating a web sites, creating pages and using find and replace
- Structure and Style – structure and Style sheets
- Tables – creating tables, table structure and formatting, column width and cell properties
- Links – creating links, image maps and links style
- Image formats and Attributes – working with images and backgrounds
- CSS layouts – overview of style sheets and page layout
- Forms – building a form, tab order and validation input field
- Multimedia – adding multimedia content like flash movie
- Publishing – site checks, website publishing

Target Group
This course is designed for participants who are new to web design and development and want to develop skills to work with Dreamweaver CS5 to build intuitive, attractive and accessible websites.

Session

Suva

Duration Course Fee

Evening

8 – 26 Aug

60 Hours $650







Certificate in Graphics Design with Adobe® Photoshop CS5


Adobe® Photoshop CS5 software redefines digital imaging with powerful new photography tools and breakthrough capabilities for complex image selections, realistic painting, and intelligent retouching. The participants will learn to identify the components of the Photoshop environment; learn about the differences between raster and vector graphics. Students will explore various methods of selecting image areas and will learn how to modify and manipulate selections. In addition, students will also learn how to work with text, layers, and layer effects; how to adjust, retouch, and resize images; and how to prepare images for printing and the Web.

Capabilities Addressed
-
Introduction to Photoshop
- File types; The Photoshop environment; and Getting help- Working with Image Selections
- Selection techniques; and Modifying selections.- Working with layers
- Creating layers, Modifying layers, Using Type layers and using layer effects
- Adjusting Images – image mode, Hue/Saturation and Vibrant adjustment, and Levels adjustments
- Retouching images – Repairing image defects, Painting, Using the Background Eraser and using filters
- Resizing Images – Image resolution and image canvas size
- Fills and Overlay – Filling image areas, Gradients and pattern and layer overlays
- Masks -  Mask channels, Layer masks, Grayscale masks and clipping masks
- Vector Paths – Creating vector paths, Editing vector paths, Vector mask and paths for creative imagery
- Creative Image Effects – Painted effects, Wrapping, Efficient compositing, vanishing Point

Target Group
This course is intended for people who have an interest in graphic designing, or for students who wish to pursue a career in graphic designing. It is best suited for professional photographers, serious amateur photographers, graphic designers and web designers.

Session

Suva

Duration Course Fee

Evening

4 – 29 Jun

60 Hours $650







Certificate in Programming with Visual Basic 2010


Visual Basic is part of the Microsoft® Visual Studio 2010 suite; it is an integrated developer environment (IDE) compiler for visual basic programming language. In this course, the participants will learn the essentials of Visual Basic language and also learn to use the IDE to compile and run Visual Basic code. This course gives special attention to the design of the user interfaces &courses that flow logically& helps provide a consistent user experience in designing & creating forms and coding in visual basic using and applying appropriate syntax and course structure.

Capabilities Addressed
-
Introduction to Microsoft® Visual Studio 2010, Introduction to visual basic programming
- Design forms application and coding
- Visual Basic language essentials, syntax and structure
- Learning to use different data types, and data structures, e.g. Arrays
- Working with form controls and debugging an application
- Using object-oriented programming techniques, control structures
- Coding procedures, event handlers, using exception handling techniques
- Create and use classes
- Database programming using visual basic
- Working with data sources and data sets and bound controls
- Working with interfaces and parameterized queries, organize and document classes
- Learning to work with default properties, events and operators
- Applying inheritance techniques in coding structure
- Learning to enhance the user interface and deploying an application

Target Group
This course is for participants who have an interest in developing software’s and graduate programmers and IT personnel who would like to develop custom made software’s for their organization.   

Session

Suva

Duration Course Fee

Evening

5 – 30 Nov

50 Hours $750

 






Certificate in Fundamentals of Graphics Design


This course is designed to introduce participant to the fundamentals of Graphic Designing with the use of the new Adobe® CS5 Suite, which includes graphics courses like Photoshop, Illustrator and Fireworks. The participants will also learn to edit the color, size, shape and background of an image to customize the image to suite the client need, provide a distinctive artwork for any project, by craft vector assets for use in any design project, from logos and branding to graphics for advertising, packaging and environments.

Capabilities Addressed
-
Use the Workspace – locations all tools and panels, change the workspace area
- Work with Panels and Menus – functions and uses of different panels and menus, hide and show panels
- Understand the tools on the tool bar – functions of basic tools on the tool bar.
- Understand Image Size and Resolution – change image width, height and resolution
- Crop and Add Canvas Size – change canvas size
- Create Basic Selections – use basic selection tools from the tool bar to make selections
- Transform Objects – perform basic transformation such as scale, skew, distort, rotate
- Understand Layer Basics – importance on use of layers
- Manage Layers -  add and remove layers, change layer properties
- Work with Opacity and Blending Modes – change the opacity and blending modes of the images and layers
- Create Type – add text to the graphics
- Format Characters – change color, orientation, size of the characters
- Save Files - saving of files in different formats such as jpg, gif or the application formats.

Target Group
This is course is suitable for participants who would like to choose web designing as their career and also participants who are in the field and need to enhance skills. The back-end developers wishing to (or must) add more page design skills to their list of qualifications. These participants will gain formal training and qualifications in this course.

Session

Suva

Namaka

Lautoka

Rakiraki

Duration Course Fee

Evening

10 – 28 Sep

16 Apr – 18 May

10 – 27 Apr

10 – 27 Apr

45 Hours $550







Certificate in Advanced Graphics Design


Advance Graphics Design is a course that will enable participants to develop practical skills and knowledge required to produce and communicate creative graphic design images for reproduction in print and digital media. This course will also enable participants to create rich, interactive content for digital, web, and mobile platforms. Participants will learn to create rich media advertisements, instructional media, engaging presentations, games, and more.

Capabilities Addressed
-
Retouching and Repairing  - repairing torn and faded images, re-coloring, removing marks from the image and cloning
- Working with Selections – using tools to select bitmap and vector images
- Working with Vector Paths – selecting, adding, deleting and creating symbols using vector paths
- Working with Shape and Mask -  creating and modifying shapes, creating masking effect
- Creating special Effects – adding effects such as glow, shadow, bevel
- Transforming objects - perform basic transformation such as scale, skew, distort, rotate
- Applying Appearance Attribute and Graphic Styles – applying predefined styles on the image and symbols and text
- Advanced Layering – using multiple layers- Typographic design – using predefined text designs
- Preparing Files for Web – saving images and symbols for use on web

Target Group
This course is intended for participants who have an interest in web designing, or for participants who wish to pursue a career in web designing and IT professionals who wish to set up a website for their organization. This course is best suited for professional photographers, graphic designers and web designers.

Session

Suva

Lautoka

Duration Course Fee

Evening

5 – 23 Nov

23 Jul – 10 Aug

45 Hours $650

 





Certificate in Computerized Accounting
Accounts Implementation in MYOB


MYOB is one of the most widely used and popular accounting packages available in the market.  Knowledge of operating MYOB can be very advantageous and beneficial in the accounting field. MYOB is a unique accounting package when compared with any other accounting system. This course enables participants to setup a data file, preparing it for data entry.  This involves the General Ledger setup with debtor and creditor opening balances as well as Inventory setup.

Capabilities Addressed
-
Introducing and registering MYOB – different types of MYOB courses available, software registration
- Understand basic key features of MYO -Use of command centers, Menus at the bottom of command center, To Do List, Find Transaction, Reports Analysis, Calendar, Calculator, and Use of Menu Bar.
- Create company files - Requirements for company file setup
- Current financial year, Last month of Financial Year, Conversion Month, Number of accounting periods, File backup after each session
- Activating and setting up a data file – implications of file activation ,By Internet, Telephone
- Create a chart of accounts, Tax Code list, Accounts list and Linked Accounts
- Creation, Deletion, Edition of detail accounts.- Enter opening balances -Balance of each account as of the first day of conversion month
- Card File – Building Database, Listing details of Suppliers, Listing details of Customers
- Entering historical data- Information of   Customer  & Supplier  accounts still outstanding  months prior of conversion month, Customers opening Balances ,Suppliers opening balances ,Setting up terms, default layouts, Tax code & link accounts.
- Setting up Inventory– Items bought for the resell purpose
- Create Item List, Link items to respective account of income, Cost of Goods Sold, Asset, Tax code, set up base prices, Create a Journal to balance inventory with chart of accounts entry.
- Initial Bank Reconciliation – bring forward the un-reconciled entries from pre-conversion period and reconciling as at the conversion month.

Target Group

This course is for participants who are either currently practicing manual accounting and would prefer to computerize their accounting system.  This course is designed for participants who have proven accounting knowledge and for anyone who would like to implement MYOB.

Duration: 30 Hours

Course Fee: $450

Session

Suva

Namaka

Lautoka

Sigatoka

Rakiraki

Day

13 – 17 Feb

-

-

-

-

25 – 29 May

-

-

-

-

15 – 19 Oct

-

-

-

-

Evening

13 – 24 Feb

13 – 24 Feb

20 Feb – 9 Mar

13 – 24 Feb

20 Feb – 9 Mar

21 May – 1 Jun

18 – 29 Jun

4 – 14 Jun

-

4 – 14 Jun

1 – 12 Oct

-

-

-

-














Certificate in Computerized Accounting- MYOB for End-Users


This course is designed to enable participants to understand the data entry concepts of the MYOB accounting package. It provides a knowledge base for MYOB courses in terms of entering data into an existing data file and maintaining it at the same time. This course will prepare the participant to fully understand the techniques of using MYOB to enter transactions for a business using all the command centers.

Capabilities Addressed
-
Purchases – creating orders, bills, changing orders to bills, applying returns and supplier payments, handling discount, recording delivery of goods on backorder, Recording the return of items and Recording the receipt of a refund cheque
- Sales – creating orders, invoices, changing orders to invoices, applying returns and customer payments, Entering returns, Settling returns, Viewing ageing methods accounting for overpayments, Entering a refund cheque and Viewing ageing methods.
- Banking­ – Entering payments from cheque butts, Saving and using a recurring payment, Checking accuracy of data entered – using Bank Register, Reconciling your bank A/C, Entering account keeping fees, Entering interest received,
- General Journal entries – creating journal entries for capital expenditure, depreciation, loans, recording a dishonored cheque, Recording dishonored cheque fee and entering the purchase of an asset.
- Further Data Entry Techniques – creating and using recurring entries, applying bad debts, dishonored cheques, and backorders.
- Reports – generating financial reports, analysis reports, variance reports, various other summary and detail reports

Target Group
This course is intended for participants who have a career in accounting field or intend to have one, or anyone who wishes to learn the correct techniques of entering data in MYOB.  This course is for participants who have been using MYOB software or have completed the Certificate in Computerized Accounting – Accounts Implementation in MYOB.

Duration: 42 Hours
Course Fee: $600

Session

Suva

Namaka

Lautoka

Sigatoka

Rakiraki

Day

7 – 16 Mar

 

 

 

 

30 May – 8 Jun

 

 

 

 

22 – 31 Oct

 

 

 

 

Evening

 

7 – 23 Mar

5 – 23 Mar

19 Mar – 5 Apr

5 – 23 Mar

19 Mar – 5 Apr

4 – 22 Jun

9 – 27 Jul

2 – 20 Jul

2 – 20 Jul

15 Oct – 1 Nov














Certificate in Computerized Payroll


Payroll is one of the most essential functions of any accounting system.  It is critical for any organization/ business to perform this function accurately and timely. Constructing Payroll in MYOB enables to integrate the payroll transactions within the accounting process.  This eliminates the need for creating journal entries for wages & salaries. The organizations payroll can be processed within MYOB, with relevant postings done at the same time, along with wages and salaries calculation, other entitlements and deductions can also be setup to complete the payroll requirements.

Capabilities Addressed
- Set up payroll using MYOB – setup of conditions under which payments will be made, setting up superannuation funds, Entering Year-to-date payroll history, Entering business banking details, Editing/Adding wages categories, Modifying/Adding leave entitlements, Viewing/Editing deduction categories, setting up employment classifications, creating necessary wages A/c in the Accounts List.
- Employee Cards – creating, editing and deleting of employee cards, set clerical employees pay scale, set employee obligations- such as salary sacrifice, payroll tax, work cover and hours worked.
- Applying Payroll details – applying the payroll categories and other applicable details to employee cards
- Processing Payroll – applying timesheet details to payroll system for payroll process, processing payroll for wage and salary earners, applying leaves, entitlements and deductions, paying employees, printing pay slips and recording payroll transactions.
- Deduction Reconciliation – generating reports on expected and actual deductions of PAYE, FNPF and other deductions.
- Paying Payroll Liabilities – paying the FNPF, FIRCA and any other relevant authority the deductions made from the employees’ payroll and other employer expenses incurring on behalf of the employees

Target Group
This course is designed for participants who are already engaged in processing payroll like payroll clerks or have payroll related knowledge like accounts personnel. Participants should have brief knowledge of how PAYE, FNPF, leaves, entitlements and deductions work or anyone else interested.

 

Session

Suva

Namaka

Lautoka

Duration Course Fee

Evening

17 – 28 Sep

7 – 25 May

14 May – 25 May

36 Hours $550

10 – 28 Sep









Certificate in Animation Design with Flash CS5


This course delivers an advanced authoring environment for creating rich, interactive content for digital, web, and mobile platforms. Participants will learn to create interactive websites, rich media advertisements, instructional media, engaging presentations, games, and much more.

Capabilities Addressed
-
Flash CS5 environment – understand the timeline, use rulers, grids and property panel and change document properties
- Symbols – create, modify and use symbols, know how to change one symbol into another- Work with Graphics – make detail graphic selection, modify simple graphics( flipping, rotating, skewing and distorting)- Import images
- Understand Layers – create graphics on multiple layers, understand and organize layers, change layer properties
- Work with Frames – create basic frame by frame animations, know the difference between frames and key frames, create, add, remove frames or key frames
- Add Animation with Motion Tweens – be able to animate with motion tweening- Work with Text Tool – write with text tool, modify text and paragraph
- Create Interactive Navigation – create basic buttons, assign actions to buttons
- Work with Sound  - add sound to the animation
- Load and Control Flash Content – know what format you can import in flash

Target Group
This course is intended for participants who have an interest in web designing, or for participants who wish to pursue a career in web designing and IT professionals who wish to set up a website for their organization. This course is best suited for professional photographers, advert designers, graphic designers and web designers.

Session

Suva

Duration Course Fee

Evening

9 – 27 Jul

45 hours $550







Certificate in Essentials of Office Computing


This course introduces participants to the first level of Office Computing. The participant will begin with the basics of three common office applications specifically Microsoft word, excel and PowerPoint. The course acts as a building block for students to understand how personal computers operate and how to perform, standard tasks using office applications.

Capabilities Addressed

- Computer Fundamentals and Keyboarding Techniques

   a. Using the alphanumeric QWERTY arrangement keyboard
   b. Using Special Purpose keys (e.g. Spacebar, Backspace, Shift) and keypads (e.g. numeric, function, & navigation)
   c. Apply strategies for proof reading, Assess and improve typing speed and accuracy

- Microsoft® Windows7 Foundation
  
a. Files, Folders & disks – types of drive and drive letters, Windows explorer, and data storage devices
   b. Manipulating files – creating, renaming and deleting a file, recognizing common file types, sorting the file list within Windows explorer, restoring files and folders from the recycle bin
   c. Viruses, Spyware & Cookies – what is a computer virus, spyware and cookies, virus checking courses and scanning for viruses

- Microsoft® Office Word 2010 Foundation
   a. Spell Checking a Document, Adding & Removing words to the Dictionary
   b. Applying Line Spacing Formatting Options and using the Widow/ Orphan Control
   c. Editing pictures in the compatibility mode, Clipping screenshots, compressing and Modifying pictures

- Microsoft® Office Excel 2010 Foundation
   a. Using the Nested function and consolidating data using referenced functions
   b. Inserting Time & Date Functions such as day, month, year, date into worksheets
   c. Applying Special Mathematical Functions to rows and column data
   d. Use of Statistical Functions such as concatenate, rank, trim, etc., Logical Functions to a data set, Using Financial Functions,  VLookup & HLookup Functions

- Microsoft® Office PowerPoint 2010 Foundation
   a. Creating a Presentation, Inserting new slides and saving a presentation
   b. Applying themes to the PowerPoint presentations, creating a Table, Applying Styles to a Table, Applying borders to cells, Manipulating illustrations and graphics, Inserting Text into a Shape
   c. Creating a footer , automatic slide numbering and inserting dates into the footer
   d. Running a slide show, Transition & animation Effects, Applying spell-checking, Changing slide orientation

- Microsoft®  Internet Explorer 8.0
   a. Internet Explorer 8.0 terminology & concepts e.g. World Wide Web, URL, cookies, etc.
   b. Downloading files from a webpage
   c. Using search engines, searching using instant search
   d. Changing search engines & Customizing internet explorer homepage, setting multiple home pages

Target Group
This course is intended for participants who are working and would like to equip themselves with the necessary skill to process and manage computer related office work.

Session

Suva

Duration Course Fee

Day

12 – 22 Jun

45 Hours $475

 






Certificate in Advanced Office Computing


This course is based on a more detailed level of office computing. Most of the concepts covered in this course involve advance office applications such as word, excel. The course also integrates database development tools such as access and higher degree of options for presentation development within PowerPoint. The course provides more information on Windows 7 operating system and offers the participant a greater level of customisation options. Additionally the participant is trained on the features internet explorer 8.0.

Capabilities Addressed

- Microsoft® Windows 7 Intermediate
   a. Desktop Personalization, Taskbar Customization, locking, moving, hiding and displaying taskbar toolbars
   b. Displaying & Customizing Side bar and Adding & Removing Gadgets, Sharing and Accessing shared folders on your network and mapping a drive
   c. Opening the Windows photo gallery, adding and deleting tags, thumbnail views, grouping and sorting
   d. Creating Master Documents &Creating table of contents & indexes
   e. Tracking changes and accepting or rejecting changes within a document, Linking and embedding data into a document
   f. Creating forms with fields, checkboxes and drop-down menus g. Creating & Using Mail Merge &Adding and Removing password protection to a document

- Microsoft® Office Word 2010 Intermediate
a. Creating Master Documents &Creating table of contents & indexes
b. Tracking changes and accepting or rejecting changes within a document, Linking and embedding data into a document
c. Creating forms with fields, checkboxes and drop-down menus
d. Creating & Using Mail Merge &Adding and Removing password protection to a document

- Microsoft® Office Excel 2010 Intermediate
   a. Linking & Embedding within a Worksheet and between worksheets, Linking data between Workbooks and Applications (e.g. Excel and Word)
   b. Tracking and Reviewing, Validating Numbers, Lists, Data, Time, Validation Input message and Error Alert.
   c. Assigning and Deleting Macros, Using the Scenario Manager and Scenario Summary Reports
   d. Enabling Passwords Protection in an Excel Worksheet, hiding and un-hiding formulas

- Microsoft® Office PowerPoint 2010 Intermediate
   a. Creating, renaming, collapsing and expanding PowerPoint Sections
   b. Inserting, editing and customizing slide master & Applying and modifying themes
   c. Formatting and resetting pictures, manipulating illustrations and formatting auto shapes

- Microsoft® Office Access 2010 Foundation
   a. Database concepts – database, relational database, table, record, field and data types
   b. Define primary key, indexing, create and delete single-field and multiple field indexes
   c. Relationships – one-to-one, one-to-many and many-to-many relationships, create relationships between tables, referential integrity, cascade options, delete relationship
  d. Forms – create, modify, save and delete forms, form views, modify data within a form, add records using a form, filter form, inserting and modifying a form header and form footer

Target Group
This course is intended for participants who are working and would like to equip themselves with advanced techniques and methods to process and manage computer related office work.

 

Session

Suva

Duration Course Fee

Day

23 Jul – 10 Aug

75 Hours $750

 






Computers at Beginners Level


This course is designed for a novice user who has little or no knowledge of computing and provides an opportunity to learn new skills and enhance the knowledge of computers. It strives to deal with all aspects of keyboarding techniques and gives an understanding of how a computer works. Furthermore, this course provides an upgrade to a new learning experience with the use of the latest operating system such as Windows 7 and Microsoft Office Products 2010.Users will gain confidence in using the computer proficiently. This course is the ideal introductory course to prepare students for more advanced courses in the information technology/computing sector.

Capabilities Addressed

-
Computer Fundamentals and Keyboarding Techniques
   a. Using the alphanumeric QWERTY arrangement keyboard
   b. Using Special Purpose keys (e.g. Spacebar, Backspace, Shift) and keypads (e.g. numeric, function, & navigation)
   c. Practicing computer ergonomics relative to posture and keyboarding techniques
   d. Apply strategies for proof reading, Assess and improve typing speed and accuracy

- Microsoft® Windows 7 Foundation
   a. The Windows Desktop – desktop icons, moving a desktop icon, Windows taskbar, customizing your desktop and setting a screen saver
   b. Windows, installing & removing courses, creating and using a desktop shortcut
   c. Manipulating files – creating, renaming and deleting a file, recognizing common file types, sorting the file list within Windows explorer, restoring files and folders from the recycle bin
   d. Viruses, Spyware & Cookies – what is a computer virus, spyware and cookies, virus checking courses and scanning for viruses

- Microsoft® Office Word 2010 Foundation
   a. Starting to use Microsoft Word 2010 , Opening Word document, Saving Word documents and Closing Word documents
   b. Applying font types, Font Size, Case Changing, highlighting, removing formatting
   c. Page Formatting, changing page orientation, adding and removing Headers and Footers
   d. Inserting, Navigating, Modifying and Deleting  Tables, Using Graphics within Microsoft Word, inserting illustrations

- Microsoft® Office Excel 2010 Foundation
   a. Starting Excel 2010 course, learning to Open, Save & Close Workbook
   b. Inserting, Modifying or deleting worksheets, Selecting multiple range of cells, entire worksheet, rows and columns
   c. Switch between worksheets, renaming, copying and moving a worksheet
   d. Creating formulas, Using Operators, relative and Absolute cell referencinge. Using common functions, SUM, AVERAGE, MAX, MIN, COUNT, etc.

Target Group

This course is designed for participants who wish to gain computer knowledge or for anyone who has not used computers before.

 

Duration: 30 Hours

Course Fee: $250

Session

Suva

Namaka

Lautoka

Sigatoka

Rakiraki

Day

9 – 13 Jan

9 – 13 Jan

9 – 13 Jan

9 – 13 Jan

9 – 13 Jan

30 Apr – 4 May

30 Apr – 4 May

30 Apr – 4 May

 

30 Apr – 4 May

20 – 24 Aug

20 – 24 Aug

20 – 24 Aug

20 – 24 Aug

20 – 24 Aug

24 – 28 Sep

3 – 7 Dec

3 – 7 Dec

3 – 7 Dec

3 – 7 Dec

3 – 7 Dec

-

-

-

-

Evening

9 – 20 Jan

9 – 20 Jan

9 – 20 Jan

-

9 – 20 Jan

30 Apr – 11 May

30 Apr – 11 May

-

-

-

20 – 31 Aug

-

-

-

-

26 Nov – 7 Dec

3 – 14 Dec

3 – 14 Dec

-

3 – 14 Dec


















Computers at Intermediate Level


This course is for participants who have prior knowledge of computers and wants to upgrade to the use of web browsing applications, mail merging features, consolidating data and doing presentations. These provide a unique way of addressing work related issues and provides a user friendly environment for the user to adopt.

Capabilities Addressed

-
Microsoft Windows 7 – Intermediate
   a. Customizing the Windows 7 Desktop& using the Desktop Personalization feature
   b. Windows 7 Taskbar customization, hide and un-hide the task bar
   c. Adding & removing gadgets to the Windows sidebar, customizing the sidebar
   d. Sharing files and folders, accessing shared folders on the network


- Microsoft Office Word 2010- Intermediate
  a. Using the Proofing and Printing feature for Spell checking
  b. Formatting of Paragraphs, using line spacing, multi-level list formatting, etc.
  c. Editing and Resetting Pictures & Using the Autocorrect feature
  d. Applying Headers & footers, Styles and text wrapping, Adding, Removing and Modifying Watermarks
  e. Applying table styles, merging cells within a table, converting text to table and table to text

 

- Microsoft Office Excel 2010Intermediate
  a. Using the Nested function and consolidating data using referenced functions
  b. Inserting Time & Date Functions such as day, month, year, date into worksheets
  c. Applying Special Mathematical Functions to rows and column data, Applying Logical Functions to a data set
  d. Use of Statistical Functions such as concatenate, rank, trim, etc., Using Financial Functions, VLookup & HLookup Functions
  e. Using Database Functions to manipulate data sets in an excel worksheet


- Microsoft Office PowerPoint 2010 – Foundation
a. Using PowerPoint 2010 to create presentations
b. Manipulating Slides, Changing backgrounds and applying themes
c. Formatting of paragraphs, fonts and Character Spacing
d. Inserting and Manipulating Illustrations, Inserting charts, creating organization charts and slide masters
  
Target Group
This course is designed for participants who have basic computing knowledge and wish to further their knowledge and skills.

Duration: 30 Hours

Course Fee: $285

 

Session

Suva

Namaka

Lautoka

Sigatoka

Rakiraki

Day

16 – 20 Jan

16 – 20 Jan

16 – 20 Jan

16 – 20 Jan

16 – 20 Jan

7 – 11 May

7 – 11 May

7 – 11 May

27 – 31 Aug

7 – 11 May

1 – 5 Oct

27 – 31 Aug

27 – 31 Aug

10 – 14 Dec

27 – 31 Aug

10 – 14 Dec

10 – 14 Dec

10 – 14 Dec

-

10 – 14 Dec

Evening

23 Jan – 3 Feb

23 Jan – 3 Feb

23 Jan – 3 Feb

-

23 Jan – 3 Feb

14 – 25 May

14 – 25 May

18 – 29 Jun

-

18 – 29 Jun

3 – 14 Sep

-

-

-

-

10 – 21 Dec

-

-

-

-

















Computers at Advanced Level


This course not only provides you with advance techniques but also allows you to create database applications and prepare simple reports and queries. Furthermore, with functions of Microsoft Excel you would learn and diversify your knowledge of how monthly payments are calculated and in turn use pivot tables and input data tables. It also provides you with enhanced presentation skills.

Capabilities Addressed
- Microsoft Office Word 2010 -  Advanced
   a. Creating Master Documents &Creating table of contents & indexes
   b. Tracking changes and accepting or rejecting changes within a document
   c. Linking and embedding data into a document
   d. Creating forms with fields, checkboxes and drop-down menus
   e. Creating & Using Mail Merge &Adding and Removing password protection to a document

- Microsoft Office Excel 2010 -  Advanced
  a. Using Pivot Tables to sort, filter and group data
  b. Linking & Embedding within a Worksheet and between worksheets, Linking data between Workbooks and Applications (e.g. Excel and Word)
  c. Importing a delimited text files into Excel, Sorting and Filtering Data within a Worksheet
  d. Tracking and Reviewing Changes (Using the ‘Track Changes’ feature, Sharing, Comparing and Merging Worksheets)
  e. Assigning and Deleting Macros, Using the Scenario Manager and Scenario Summary Reports


- Microsoft Office PowerPoint 2010 – Intermediate
  a. Creating, renaming, collapsing and expanding PowerPoint Sections
  b. Inserting, editing and customizing slide master & Applying and modifying themes
  c. Formatting and resetting pictures, manipulating illustrations and formatting auto shapes
 
- Internet & Email   
  a. Internet Explorer 8.0 terminology & concepts e.g. world wide web, URL, cookies
  b. Downloading files from a webpage and utilizing different email platforms e.g. Yahoomail, Gmail
  c. Displaying Webpages within a new tab and new window
  d. Using search engines, searching using instant search
  e. Changing search engines & Customizing internet explorer homepage, setting multiple home pages
  f.  Subscribing to RSS feeds & Security issues and web based forms, protected sites, encryption and digital certificates
  
Target Group
This course is designed for participants who have intermediate level computing knowledge and wish to enhance their knowledge and to achieve efficiency and productivity.

 

Duration: 30 Hours

Course Fee: $350

Session

Suva

Namaka

Lautoka

Sigatoka

Rakiraki

Day

23 – 27 Jan

23 – 27 Jan

23 – 27 Jan

17 – 21 Dec

23 – 27 Jan

14 – 18 May

14 – 18 May

17 – 21 Dec

-

17 – 21 Dec

3 – 7 Sep

17 – 21 Dec

-

-

-

8 – 15 Oct

-

-

-

-

17 – 21 Dec

-

-

-

-

Evening

7 – 17 Feb

28 May – 8 Jun

7 – 17 Feb

-

7 – 17 Feb

28 May – 8 Jun

-

-

-

-

17 – 28 Sep

-

9 – 20 Jul

-

9 – 20 Jul

 
















Relational Database Design and Implementation

This course is designed for participants interested in database design and implementation using Microsoft® Office Access 2010. The participants in this course will learn to create databases, work with tables, fields, records and sort, filter data, integrate web development, database normalization, using structured query language, create charts, using pivot tables and pivot charts. Candidates will also be introduced to creating macros, importing & exporting data, create relationships, work with indexes and data types and linking of database objects.

Capabilities Addressed
-
Database Concepts, relational databases, tables, records, fields and data types
- Opening a Database from trusted locations
- Create Blank database, adding fields and setting the field type
- Table Navigation & Modification, Opening a table within a database
- Using Field Properties, input masks, validating numbers and dates
- Adding, editing, deleting, renaming Tables & Records
- Create and define Primary Keys and Creating single
- field index and multiple-field index
- Single and multiple text  filtering
- Sorting records, removing a sort and sorting multiple fields
- Searching through records
- Creating& Modifying Relationships between tables, Cascade update fields, and enforce referential integrity
- Creating, modifying and saving a Forms& Creating reports using wizards
-
Create, Update, append and delete Queries, adding a criteria to a query, refining and wildcards
-
Exporting tables as Excel file, text files, .csv file, .pdf file, .xml file
- Using Inner Joins, Outer Join, Subtract Join and Self Join
- Using Crosstab queries, grouping information in a query using functions
- Applying Forms Controls such as Text box, combo box, List box Arithmetic expressions, etc.
- Formatting Arithmetic Calculation controls, concatenating fields within a report
- Creating Macros, Assigning Macro to a Command button, Object, Control
- Linking Data from an Excel Workbook to a Database, linking external data
- Importing Data from an Excel file, CSV Text file, TXT file, XML file and Database file

Target Group
This course is designed for participants with prior knowledge in basic computing and those familiar with basic features of Access 2010 or anyone wishing to gain expertise in database design and implementation. It is for participants who want to be proficient with complex features and functions such as query design in SQL, using crosstab, creating & running macros and dealing with basic database security.

 

Session

Namaka

Sigatoka

Duration Course Fee

Day

2 – 6 Jul

-

36 Hours To be confirmed

Evening

16 – 27 Jul

16 – 27 Jul