| Local Award Courses |
|
The Local Award Courses offered are:
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.
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.
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.
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.
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.
Course Fee: $450
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
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.
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.
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.
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.
Duration: 30 Hours Course Fee: $250
- 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 2010 - Intermediate
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
Course Fee: $285
- Microsoft Office Excel 2010 - Advanced - 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
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.
|