Public Program: IT

 

Advanced Microsoft Access-ICT900

OBJECTIVE

• To enable the participants to use and manipulate tables, create queries, forms, report, graphs, mailing labels and macros.

COURSE CONTENT
Day 1
Unit 1 Designing Applications
• Identify the components of an application
• Plan an application

Unit 2 Automating Forms
• Automate the application interface by using dialog boxes
• Automate dialog boxes by creating macro groups
• Use code elements in Visual Basic for Applications and automate navigation across forms by using command buttons

Unit 3 Working with Switchboard and Splash Screen
• Create, test, and modify Switchboard forms by using the Switchboard Manager
• Create Splash Screen forms by modifying from properties
• Automate Splash Screen forms

Unit 4 Creating Custom Toolbars and Menu Bars
• Create macro groups to show and hide toolbars, and create custom toolbars
• Create custom menu bars, create shortcut menus, and set the startup properties for toolbars and menu

Day 2
Unit 5 Working with VBA Code
• Use the Different Visual Basic programming elements, such as data types, variables, and constants to write VBA code
• Work with modules by identifying their components and by examining sample VBA code in the Code window
• Create Sub and Function procedures in modules, and create procedures to call other procedures.

Unit 6 Advance VBA Programming
• Use control and loop structures in VBA code
• Handle events by automating combo boxes and text boxes, coordinate event across forms, and unload forms.
• Trap and resolve errors by adding error-handling code and then execute the code for error trapping.
• Add a web browser control to a form to display a Web site.

Unit 7 Managing Databases
• Work with database utilities to optimize resources
• Use database utilities to secure data
• Encrypt and decrypt databases

WHO SHOULD ATTEND

• Executive, clerical and other administrative staff.

Duration : 2 Days
Time : 9.00 am – 5.00 pm
Venue : JOHOR SKILLS
Methodology : Lecture, hands-on, open discussions, practical demonstration


 

Open Source Application Web Development-ICT1900

OBJEKTIF
Peserta dapat mempelajari :-
• Web Server Apache, PHP dan MySQL. Memahami pembangunan Laman Web. Pengelolaan Database Kerjasama diantara PHP dengan MySQL

ISI KANDUNGAN
Day 1
Topic 1 : Introduction to Apache, PHP and MySQL
• Introduction to Web Server
• Introduction to PHP
• Introduction to MySQL
• Introduction to Wamp / Xampp
• Installation Apache, PHP and MySQL using Wamp / Xampp
Topic 2 : Basic PHP
• Overview PHP
• Variable
• Types of data
• Constant
• Operator
• Selection, Looping, Array, Function
Day 2
Topic 3 : Basic MySQL
• Introduction PHPMyAdmin
• Create Database
• Create Table
• Insert Record
• Edit Record
• Delete Record
• Delete Table
Topic 4 : Introduction to SQL
• What is SQL?
• Select, Insert, Update, Delete, Aggregation, Where and Order by Statement
Day 3
Topic 5 : Working with PHP and MySQL
• connection from PHP to MySQL
• Query using SQL statement
• View query

WHO SHOULD ATTEND
• Open (17 years old and above)

Duration : 3 days
Time : 9.00 am – 5.00 pm
Venue : JOHOR SKILLS
Methodology : Lecture, hands-on, open discussions, practical demonstration


 

Microsoft Project Level I-ICT1800

OBJEKTIF
Di akhir kursus peserta boleh :-
Memahami perancangan dan penjadualan proses dengan menggunakan kaedah CPM. Membina dan mengurus penjadualan project dengan menggunakan Microsoft Project. Mengemaskini dan memantau perjalanan projek. Memplotkan masa berdasarkan s-curve

ISI KANDUNGAN
Day 1
Topic 1 PLANNING & SCHEDULING PROCESS
• Identify Project Activities
• Estimate Activity duration
• Develop Project Plan
• Schedule Project Activities
• Review & Analyze the schedule
• Developed bar chart
• Progress Curve
Topic 2 INTRODUCTION TO MS PROJECT
• Starting MS Project.
• Understanding the Project Screen
• Using Common Views.
• Creating a New Project.
• Setting the Project Calendar.
• Using the Project Guide.
Day 2
Topic 3 DEVELOPING A NEW PROJECT SCHEDULE
• Adding Task
• Linking Task
• Editing Task
• Using Task Information Dialog Box & Notes
• Moving, Copying, Inserting & Deleting Tasks
Topic 4 WORKING WITH TASKS
• Overlapping & Delaying Tasks
• Setting Constraints
• Understand Task Type
Topic 5 PROJECT PROGRESS
• Updating Process
• Viewing Project Statistics
• Plotting S-Curve

Sasaran Peserta
• Dibuka kepada semua yang pengguna yang berkecimpung dalam perancangan dan penjadualan projek

Duration : 2 days
Time : 9.00 am – 5.00 pm
Venue : JOHOR SKILLS
Methodology : Lecture, hands-on, open discussions, practical demonstration


 

Microsoft Application-ICT1700

OBJECTIVE
• On completion, participants will be able to execute the windows commands pertaining to file organization, software installation, Hardware Installation, System Maintenance, Changing System Setting, Optimization and Updating files on two Computer
• On completion, participants will be able to type text documents produce table, spreadsheets, mail merge, outline and graphics
• To enable the participant to produce worksheets, charts and enhanced worksheet files
• On completion, participants will e able to create, graphic presentations in the form of a slide show
• To enable participants to use internet in various aspects such as search engines, telnet, newgroup, transferring files, electronic mail, modem and services providers.

COURSE CONTENT
Window XP
• File Organization
• Software Installations
• Hardware Installations
• Changing System Settings
• System Maintenance
• Optimizations
• Updating files on two Computers
• Using other programs
• Troubleshooting
Microsoft Word
• Typing and editing
• Proofing and reviewing
• Formatting text
• Formatting paragraph
• Automatic formatting and styles
• Working with tables
Microsoft Excel
• Creating Toolbars
• Creating a Toolbars
• Positing and Displaying a Toolbar
• Deleting
• Analyzing Worksheets
• Finding Specific Types of Cells
• Auditing a Worksheet
• Using the Goal Seek Feature
• Using the Scenario Manager
• Using the Report Manager
• Exploring Functions
• Using Functions Working with Date and Time functions
• Working with Numeric functions
• Working with the logical IF Functions
Creating HLOOKUP and VLOOKUP
• Working with Financial Functions
• Using Advanced File techniques
• Using the Paste Special Command
• Linking Files
• Protection Information
• Managing a Database List
• Exploring Excel Data List Structures
• Sorting Data
• Using Data Forms
Filtering Data
• Presenting Database Information
• Creating Subtotals and Grand Total
• Running a Macro
• Recording a Macro
• Viewing and Editing Visual Basic Application Code
Microsoft Power Point
• Overview of power Point
• Getting Started
• Power Point Primer
• Exploring Power Point
• Entering typing and Editing
• Editing Text and Working with lines
• Formatting and Enchaining Graphs
• Drawing and Working with Art Objects
• Coloring Presentation
• Printing Slide and handout
• Displaying a Slide show
Internet
• Configuration of modem, Network and dial-up networking
• Internet Service Providers ñ ISP
• Starting Internet
• Using the Search Engines
• Telnet, Newsgroup and the Internet Relay Chat (IRC)
• Transferring files ñ Electronic mail
• Downloading files ñ text, audio, video and graphics into the hard disk
• Multimedia in the Web

WHO SHOULD ATTEND
• SME’s. Executives, clerical and other administrative staff.

Duration : 4 days
Time : 9.00 am – 5.00 pm
Venue : JOHOR SKILLS
Methodology : Lecture, hands-on, open discussions, practical demonstration


 

Graphic Design Using Photoshop Level II-ICT1601

OBJECTIVE
Adobe PageMaker 7.0 software is the ideal page layout program for business education, and small-and home-office professionals who want to create high-quality publications such as brochures and newsletters. Get started quickly with templates, graphics, and intuitive design tools; work productively across Adobe applications and easily leverage exiting content to create customized communications.

COURSE CONTENT
Lesson 1 : navigation the Workspace
• The Menu Bar
• The Status Bar
• The Toolbox
• The palettes
• Review
Lesson 2 : Working With Documents
• Navigator Palette & Hand Tool
• New View & Duplicate
• Image Size & Resolution
• Image Size Dialog Box
• Resizing Practice
• Canvas Size
• Crop Tool
• History Palette Basics
• Saving Images
Lesson 3 : Image Modes & Color Selection
• Color Primer
• The Color Picker
• Color & Swatch Palettes
• Custom Swatch Exercise
• Eyedropper & info Palette
• Review & Assignment
Lesson 4 : Selection and Masks
• Exercise
• Marquee Selection Tools
• Lasso & Wand Selection Tools
• Selection Tool Practice
• Select Menu Commands
• Transforming Selection
• Alpha Channels & Channel Palette
• Mask / Selection Practice
Lesson 5 : Layer and Blend Modes
• Intro to Layers
• The Layer Palette
• Important Layer Information
• Move , Copy & Transform Layers
• Advanced Layer Features
Lesson 6 : Adding and Working With Type
• Working With Type Introduction
• The Type Tool
• Type Palettes and Text Warping
Lesson 7 : Painting Tools
• Intro , Paint Bucket and Fill Command
• Gradient , Pattern and Line Tools
• Brushes and Fade Command
• Pencil , Paintbrush and Air brush Tools
• Eraser Tools
Lesson 8 : Retouching Tools
• Retouching Tools Intro & Tips
• Blur , Sharpen , Smudge
• Dodge , Burn , sponge
• Clone Stamp , History Brush , Art History Brush

WHO SHOULD ATTEND
• Practically anybody who is interested

Duration : 2 Days
Time : 9.00 am – 5.00 pm
Venue : JOHOR SKILLS
Methodology : Lecture, Hands – on, open discussions, practical demonstration


 

Graphic Design Using Photoshop Level I-ICT1600

OBJECTIVE
Adobe PageMaker 7.0 software is the ideal page layout program for business education, and small-and home-office professionals who want to create high-quality publications such as brochures and newsletters. Get started quickly with templates, graphics, and intuitive design tools; work productively across Adobe applications and easily leverage exiting content to create customized communications.

COURSE CONTENT
Lesson 1 : navigation the Workspace
• The Menu Bar
• The Status Bar
• The Toolbox
• The palettes
• Review
Lesson 2 : Working With Documents
• Navigator Palette & Hand Tool
• New View & Duplicate
• Image Size & Resolution
• Image Size Dialog Box
• Resizing Practice
• Canvas Size
• Crop Tool
• History Palette Basics
• Saving Images
Lesson 3 : Image Modes & Color Selection
• Color Primer
• The Color Picker
• Color & Swatch Palettes
• Custom Swatch Exercise
• Eyedropper & info Palette
• Review & Assignment
Lesson 4 : Selection and Masks
• Exercise
• Marquee Selection Tools
• Lasso & Wand Selection Tools
• Selection Tool Practice
• Select Menu Commands
• Transforming Selection
• Alpha Channels & Channel Palette
• Mask / Selection Practice
Lesson 5 : Layer and Blend Modes
• Intro to Layers
• The Layer Palette
• Important Layer Information
• Move , Copy & Transform Layers
• Advanced Layer Features
Lesson 6 : Adding and Working With Type
• Working With Type Introduction
• The Type Tool
• Type Palettes and Text Warping
Lesson 7 : Painting Tools
• Intro , Paint Bucket and Fill Command
• Gradient , Pattern and Line Tools
• Brushes and Fade Command
• Pencil , Paintbrush and Air brush Tools
• Eraser Tools
Lesson 8 : Retouching Tools
• Retouching Tools Intro & Tips
• Blur , Sharpen , Smudge
• Dodge , Burn , sponge
• Clone Stamp , History Brush , Art History Brush

Duration : 2 days
Time : 9.00 am – 5.00 pm
Venue : JOHOR SKILLS
Methodology : Lecture, hands-on, open discussions, practical demonstration


 

Networking and Maintenance-ICT1500

OBJECTIVE
• On completion of the course, participants world be able to administer basic networking system.

COURSE CONTENT
• Networking Structures
• Microsoft Windows NT Server
• Network Protocol
• Network Security
• Network Installation
• Standard operation procedures

WHO SHOULD ATTEND
• Practically anybody who is interested in network administration.

Duration : 5 Days
Time : 9.00 am – 5.00 pm
Venue : JOHOR SKILLS
Methodology : Lecture, Hands – on, open discussions, practical demonstration


 

PC Maintenance-ICT1400

OBJECTIVE
• On completion, participants will be able to identify the various system parts of a PC Multimedia Internet Ready as well as be able to assemble and do minor PC Multimedia and troubleshooting.

COURSE CONTENT
• Different parts that make up a PC
• Steps in Assembling a PC
• Configuring the Motherboard
• Installing Floppy Disk Drive
• Configuration the Hard Disk
• Installing Windows Operating System
• Optimizing Memory Usage
• Installing CD – Rom Drive
• Installing VGA driver
• Installing Sound card Driver
• Installing Modem and Configuring for the Internet Connection
• Basic Troubleshooting procedures

WHO SHOULD ATTEND
• Execute, Technicians, those involved with PC maintenance and the genaral public.

Duration : 3 Days
Time : 9.00 am – 5.00 pm
Venue : JOHOR SKILLS
Methodology : Lecture, hands – on, open discussions and practical demonstration


 

Adobe Premiere-ICT1300

OBJECTIVE
• To enable participants to digitize audio – visual materials and output materials for multimedia.

COURSE CONTENT
• Preparing short movies
• Editing digital videos
• Using cuts and transitions
• Using effects and filters
• Using audio

WHO SHOULD ATTEND
• Practically anybody who is interested in Audio – Video editing

Duration : 2 Days
Time : 9.00 am – 5.00 pm
Venue : JOHOR SKILLS
Methodology : Lecture, hands – on, open discussions and practical demonstration


 

Macromedia Director-ICT1200

OBJECTIVE
• To provide an opportunity for participants to explore the features and capabilities of one of the most powerful multimedia authoring packages – Macromedia Director.

COURSE CONTENT
• Creative Basic Director Movies
• Build Animation Sequences
• Create, Edit and Format Text
• Design Navigation Control
• Utilise Sound Effects
• Import Video Files
• Create Execution Director Files
• Prototype for a CD – Rom Production
• Use Lingo Scripting to Enhance Director Functionality
• Manage Multimedia Assets
• Design for Cross – platform Working
• Use Appropriate File Naming Convention
• Test Products Across Platform
• Write Master CD- ROM

WHO SHOULD ATTEND
• Design and creative professionals who are new to Macromedia Director, and all those involved in multimedia applications development.This course is also suitable for managers and technical staff who need hands – on experience of multimedia.

PRE-REQUISITE : Adobe Photoshop Level 1
Duration : 4 days
Time : 9.00 am – 5.00 pm
Venue : JOHOR SKILLS
Methodology : Lecture, hands-on, open discussions, practical demonstration


 

Web Design-ICT1100

OBJECTIVE
• To enable participants to design a professional looking website suitable for corporate image using MS FrontPage.

COURSE CONTENT
• Overview of Approaching a Website Project
• View HTML with the Browser
• Create HTML Documents with a Text Editor
• Use FrontPage and HTML Shortcuts
• Create Hypertext Links to other Pages and Site
• Process Images for the WWW
• Utilise Good Design Techniques
• Publish Your Web Pages on the Internet
• Plan and manage a Website Project
• Make an Image into a Navigational Tolls
• Create Frames
• Put Forms on Your Websites
• Use Style Sheets
• Use layers to Create Animations
• Put Forms on Your Websites
• Add Sound
• Create Templates

WHO SHOULD ATTEND
• Small and medium scale entrepreneurs, business owners and key decision makers.

Duration : 4 days
Time : 9.00 am – 5.00 pm
Venue : JOHOR SKILLS
Methodology : Lecture, hands-on, open discussions, practical demonstration


 

Internet Application-ICT1000

OBJECTIVE
• To enable participants to use internet in various aspects such as search engines, telnet,newsgroup, transfering files, electronic mail, modem and service providers.

COURSE CONTENT
• Configuration of modem, network and dial- up networking
• Internet Service Providers -ISP
• Starting Internet
• Using the Search Engines
• Telnet, Newsgroup and the Internet Relay Chat(IRC)
• Transferring files – Electronic mail
• Downloading files – text, audio, video and graphics into the hard disk
• Multimedia in the Web

WHO SHOULD ATTEND
• Practically anybody who is interested in the Internet Fundamentals.

Duration : 2 days
Time : 9.00 am – 5.00 pm
Venue : JOHOR SKILLS
Methodology : Lecture, hands-on, open discussions, practical demonstration


 

Advanced Microsoft Power Point 2000-ICT800

OBJECTIVE
• On completion, participants will be able to create, graphic presentations in the form of a slide show.

COURSE CONTENT
Advance Text Formatting
• Change text attribute
• Split text with new slide
• Word art
• Insert word table
• Export to another application
Advanced Charting
• Datasheet and Graph Components
• Editing and Formatting Charts
• Enhancing Chart
• Importing Data From another Application
Working with template
• Background
• Colour
• Design
• Presentation template
• Working with colour scheme
• Customizing Templates
• Movie and round effect animation
• Transition, slide show create/ print handout
Working with Organization Carts and Tables
• Creating, Formatting and Editing Organization Charts
• Creating, Formatting and editing Tables
• Insert Excel Spreadsheet
• Insert word table/ spreadsheet

WHO SHOULD ATTEND
• Executives, clerical and other administrative staff.

Duration : 2 days
Time : 9.00 am – 5.00 pm (weekdays)
Venue : JOHOR SKILLS
Methodology : Lecture, hands-on, open discussions, practical demonstration


 

Advanced Microsoft Excel 2000-ICT700

OBJECTIVE
• To enable the participants to produce worksheets, charts and enhanced worksheet files.

COURSE CONTENT
Creating Toolbars
• Creating a Toolbar
• Positioning and Displaying a Toolbar
• Deleting Custom Toolbar
Analyzing Worksheets
• Finding Specific Types of cells
• Auditing a Worksheet
• Using the Goal Seek Feature
• Using the Scenario Manager
• Using the Report Manager
Exploring Functions
• Using Functions
• Working with Date and Time Functions
• Working with Numeric Functions
• Creating HLOOKUP and VLOOKUP
• Working with Financial Functions
using Advanced File techniques
• Using the Paste Special Command
• Linking File
• Protection Information
Managing a Database List
• Exploring Excel data List Structures
• Sorting Data
• Using Data validation
• Filtering Data
Presenting Database Information
• Creating Subtotals and Grand Total
• Running a Macro
• Viewing and Editing Visual Basic Application Code

WHO SHOULD ATTEND
• Executives, clerical and other administrative staff.

Duration : 2 days
Time : 9.00 am – 5.00 pm (weekdays)
Venue : JOHOR SKILLS
Methodology : Lecture, hands-on, open discussions, practical demonstration


 

Microsoft Access-ICT500

OBJECTIVE
• To enable particioants to use and manipulate tables, create queries, forms, reports, graphs, mailing labels and macros.

COURSE CONTENT
• Creating Tables
• Changing Tables Contents and Table Design
• Changing Relationships between tables
• Creating Queries
• Using Criteria and saving Queries
• Changing a Query and Totaling
• Getting Started with Forms
• Using the Form Wizards
• From Design without From Wizards
• Working with Sub forms
• Putting a list Box on Your Form
• Selecting and Resizing labels and Data
• Moving Labels and Data
• Adding and Editing Labels
• Using data Validation
• Default Values
• Using the Rectangle and line Tools
• Finding Information in a Database
• Finding Values
• Saving a Frequently Used Filter for Future Use
• Creating Reports
• Creating a Single Column Report
• Creating a Grouped data Report
• Working with Microsoft Graphs
• Putting a Graph on a Form
• Creating Mailing Label

WHO SHOULD ATTEND
• Executive, clerical and other administrative staff.

Duration : 2 days
Time : 9.00 am – 5.00 pm
Venue : JOHOR SKILLS
Methodology : Lecture, hands-on, open discussions, practical demonstration

Members Of FMSDC

Server Clock

Traffic Stats

Pages

Pages|Hits |Unique

  • Last 24 hours: 946
  • Last 7 days: 6,889
  • Last 30 days: 27,351
  • Online now: 6