Pages

Subscribe:

Tuesday, December 20, 2011

Visual Basic for Applications (VBA) – MS Excel

This course is intended for advanced users of Microsoft Excel. Knowledge of this course will allow individuals to create commands that are specific to the user’s tasks. VBA is helpful in generating commands that are repetitive.

Visual Basic for Applications (VBA) is an implementation of Microsoft’s Visual Basic which is built into most Microsoft Office applications. As its name suggests, VBA is closely related to Visual Basic, but one can normally run this code within a host application rather than as a standalone application.

Pre-requisite: Advanced MS Excel and Program Logic Formulation

Target Audience:

This course is specifically designed to those who would want to customize the Microsoft Excel application into performing tasks and commands that are not part of the standard MS Excel menu. This course will particularly appeal to those who are in the following areas:

Management
Academe

They work as:

Supervisors
Managers
Administrators

General Outline:

Introduction to Visual Basic for Applications (VBA)
VBA Programming Fundamentals
Event-Driven Programming
Working with Objects
Manipulating Excel with VBA
Working with Microsoft Forms
Creating Custom Menus and Toolbars
Working with Excel Database

No. of Hours: 30 Hours

Programming Languages using Microsoft Visual C++

This course is designed to enable programmers to create their own computer applications with the graphical user interfaces with Visual C++.

Pre-requisite: Program Logic Formulation

Target Audience:

This course is designed to teach programmers how to develop object-oriented applications using Microsoft Visual C++.

They work as:

Programmers

In:

IT Consulting Companies
Software Development Houses
The IT Department of a company
The Academe

General Outline:

Introduction to Visual C++
Timers and Dialog Box
Menus
Font infrastructure and Graphics
Using Controls and integrating mouse and keyboard interaction
ActiveX controls
Single Document Interface

No. of Hours: 30 Hours

Active Server Pages.NET (ASP.Net)

This comprehensive course provides practical code examples and in-depth case studies one needs to master ASP.NET and build dynamic, successful and enterprising Web applications.

Especially designed for experienced ASP developers, this course is also for those who are currently developing with ASP 2.0 or 3.0 and those considering the implications of the .NET Framework.

Experience in VB or C-based syntax (C++, Java, C#) would be beneficial for this course.

Pre-requisite: ASP Programmer

Target Audience:

This course is targeted at people who have interest in learning how to develop server-side scripting for dynamic web pages using ASP.NET.

They work as:

Programmers
Web Developers

In:

IT Consulting Companies
Software Development Houses
The IT Department of a company
The Academe

General Outline:

A Fast-Track Guide to ASP.NET
Understanding the .NET Framework
The .NET Languages
Writing ASP.NET Pages
Server Controls and Validation
ASP.NET Web Form Controls
List Controls and Data Binding
Introducing .NET Data Management
Working with Relational Data
Updating Relational Data Sources
XML Data Management in .NET
Web Applications and Global.asax
Configuration
Securing ASP.NET Applications
Working with Collections and Lists
Working with Other Base Classes
.NET Components
Building ASP.NET Server Controls
Exposing Web Services
Using Web Services
Mobile Controls
Debugging, Tracing, and Error Handling
Migration and Interoperability

No. of Hours: 33 Hours

Download the Informatics Active Server Pages.NET (ASP.Net) in PDF format »

Graphic Courses Using Photoshop

This course aims to teach users how to edit pictures interactively on the computer screen. This allows users to modify digital images by manipulating color, texture, contrast, and other elements.

Pre-requisite: Knowledge in Windows

Target Audience:

Adobe Photoshop addresses the needs of people who create and/or work with high-end images. Photoshop will particularly appeal to customers in the following three areas:

Photography
Graphic design
Web design

They work as:

Professional photographers
Graphic and Web design professionals
Educators
Technical image editors (for example: architecture firms, medical organizations, law enforcement agencies)

In:

Web and graphic design departments and studios
Prepress service bureaus and commercial printers
Ad agencies
Magazines and newspapers (photo journalism)
Video production departments and studios
Commercial and portrait photo studios
The Academe

General Outline:

Scanning a Photograph
The Work Area
Importing Images
Color Techniques
Manipulating Text
Understanding Layers
Painting Tools
Layer Techniques
Creating Special Effects

No. of Hours: 15 Hours

Graphics Courses using CorelDRAW

This course combines lecture and practical hands-on exercises to teach students the basic of graphics and desktop publishing software. CorelDraw combines graphics power and advanced publishing capabilities within an integrated user interface from short design intensive documents to long text-heavy publications.

Pre-requisite: Knowledge in Windows

Target Audience:

This course is designed to teach graphic professionals who need an essential understanding of vector illustrations. Experienced users will also benefit from the many tips and tricks and special exercises.

They work as:

Professional photographers
Graphic and Web design professionals
Educators
Technical image editors (for example: architecture firms, medical organizations, law enforcement agencies)

In:

Web and graphic design departments and studios
Prepress service bureaus and commercial printers
Ad agencies
Magazines and newspapers (photo journalism)
Video production departments and studios
Commercial and portrait photo studios
The Academe

General Outline:

Introduction to CorelDRAW
Getting Started With CorelDRAW
Drawing Objects
Manipulating Objects
Modifying Object Files and Outlines
Scaling, Rotating And Distorting Objects
Adding Text To A Drawing
Introduction to the Effects Using Lens Effect
Advance Line & Curve Techniques

No. of Hours: 21 Hours

Introduction to Animation using Flash

The course aims to introduce animation and interactivity to web pages through the use of the most widely used Adobe Flash software. Flash applications are widely used in web pages to create animated links, integrate videos, and even provide gaming activities.

Pre-requisite: Knowledge in Windows

Target Audience:

This course is designed to teach a wide spectrum of software professionals how to design and deliver cross-platform, low-bandwidth animations, presentations, and Web applications using Flash.

They work as:

Professional photographers
Graphic and Web design professionals
Educators
Technical image editors (for example: architecture firms, medical organizations, law enforcement agencies)

In:

Web and graphic design departments and studios
Prepress service bureaus and commercial printers
Ad agencies
Magazines and newspapers (photo journalism)
Video production departments and studios
Commercial and portrait photo studios
The Academe

General Outline:

Creating and Modifying Simple Objects
Complex Objects on a Single Layer
Objects on Multiple Layers
Using Non-Flash Graphics
Frame-by-Frame Animations
Animations with Motion and Shape Tweening
More Complex Animation Tasks
Interactivity with Frame Actions and Buttons
Adding Sound to Your Movies
Introducing Complex Interactivity
Delivering Movies to Your Audience

No. of Hours: 15 Hours

Fun Animation Using Flash

Course Description:
Fun animation with Flash introduces the world of Flash MX animation to building animators and web
artists. The instructor led, project oriented workshop leads the participants into creating media rich Flash
objects that incorporate animation, video and sound components.
Course Objectives:
Upon completion of this course, the student will be able to:
• To introduce participants to the world of Flash MX animation
• To create short animated projects
Course Outline:
I. Introduction and Flash Basics
II. Creating Graphics
III. Working with Text
IV. Creating Animation
V. Adding Sound and Creating a Flash Movie
No. of Hours: 12 Hours

Creating Visual Presentations

This course is a comprehensive training course on the needed skills in using electronic presentation software. The course covers topics like working with slides, embedding graphic objects and other special effects to enhance a presentation.

Pre-requisite: Knowledge in Windows

Target Audience:

Creating Visual Presentations is intended to address the needs of people who do lecturers and presentations to a group of people. This course will particularly appeal to those who are in the following areas:

Management
Academe

They work as:

Supervisors
Managers
Administrators
Teachers
Students who are in the process of developing their Thesis projects

Software Used:

Microsoft PowerPoint or
OpenOffice.org Impress (Freeware)

General Outline:

Electronic Presentation Views
Working with Slides and Text
Inserting Objects
Manipulating the background and layout
Printing the Presentation and producing handouts
Tips in Making an Effective Presentation

No. of Hours: 12 Hours
Download the Informatics Creating Visual Presentations in PDF format »

Certified Computerized Bookkeeping Course using MYOB

The course is a comprehensive range of fully integrated bookkeeping and accounting systems with MYOB application.

Pre-requisite: Knowledge in Windows

Target Audience:

This course is targeted at people who have interest in automating their accounting processes using MYOB.

They work as:

Bookkeepers
Accountants

In:

Accounting Firms
The Accounting Department of a company

General Outline:

Introduction to Accounting
Business Organizations
Business Transactions
The Accounting Equation
The Double-Entry Accounting System
The Accounting Cycle
Journalizing
Posting to the General Ledger
Preparing the Trial Balance
MYOB Background
Installing and Activating the Program
The Navigation Tools
Creating New Company File
Setting-up Own Company File
Setting-up Additional Preferences for Accounting Purposes
Per Module Features
Setting-up Preferences
Customization of Various Forms

No. of Hours:

For Accountants – 21 Hours

For Non-Accountants – 33 Hours
Download the Informatics Certified Computerized Bookkeeping Course using MYOB in PDF format »

Seeing Possibilities: Informatics Student Represents Philippines in International IT Training for Visually Impaired

Until recently, career options for the visually impaired were extremely limited. Without the musical talent of Johann Sebastian Bach or the performing genius of Stevie Wonder, a visually impaired youth would find little avenue for fulfillment and success.

Modern technology has opened many doors for the blind and the visually impaired, allowing them to read and write efficiently, and even to surf the Internet or use GPS devices. Now, even the visually impaired can become IT experts, with advances in programming tools and applications tailor-fit for their special needs.

Japanese philanthropist Teruko Ikeda takes this one level higher by funding annual IT training specifically for the visually impaired in the Asia Pacific region. The training is conducted by the Japan Braille Library at St. Nicholas Home in Penang, Malaysia. The 2011 training was held from August 1 to 20, conducted by David Hathaway, an IT expert who is visually impaired himself.
Informatics BS Computer Science student Rhea Guntalilib.

Informatics BS Computer Science student Rhea Guntalilib.

The Philippines was represented by Informatics’ own Rhea Guntalilib, a third year student taking up BS Computer Science at the Diliman campus. Rhea, who hails from Nueva Vizcaya, suffered from retinal disease at age 18. She was to pursue a career in nursing, but her failing vision forced her to look for a different field where she could excel. She chose to take up IT at Informatics, and has not regretted her choice. Her IT education and experience at the Teruko Ikeda training has provided new opportunities for her future – as an IT professional, a leader, and an inspiration to other visually impaired youth. She shares her experience in an essay below:

—–

I am Rhea Althea T. Guntalilib, a visually impaired student of Informatics International College, Diliman campus. I am currently in my third year taking up Bachelor of Science in Computer Science and an Advanced Diploma in Computing Science major in Programming.

Losing a good pair of eyes has seemingly been my life’s toughest battle. My eyesight was robbed away from me when I had a retinal disease last 2006. Those were the times where I felt like I’ve reached the end of the road. But then, life proved me wrong, as one door closed, several windows opened. Little by little, I managed to get back on my feet. Countless opportunities came my way. An opportunity for a college education was granted to me, and together with it are endless chances of proving myself and proving to the world that I can still bring out what’s best in me despite of my disability.

Last August 1 to August 20, 2011, I was sent to Malaysia to attend an intensive training that will deepen and enhance my programming skills. I joined the Teruko Ikeda ICT Advanced course on Python programming. This said training was organized and conducted by the Japan Braille Library. We were trained by Mr. David Hathaway, a visually impaired professional programmer. The basic programming constructs were taught, as well as database related matters. The best part of it was that we were introduced to Common Gateway Interface (CGI). We developed our own websites using template engines which we designed ourselves, and techniques on how to maintain the visual appeal of our websites were also fed to us.

The most important thing I learned in this course was on how to run my program in spite of the unavoidable circumstances of applications that are currently not yet blind-friendly. In this training, E-marketing or internet marketing was also introduced. This is something crucial for persons who are physically impaired like me. Job opportunities for blind persons are very rare, and online employment is the most suited. For this reason, a group of advocates called the PECC generously offered their time and resources to help us put up our own income generating tools in the cyber world. As soon as I finish the most hectic moments of my schooling, I will grab this opportunity and try my best to learn E-marketing. Internet publishing is what I intend to do. Given my additional skills in putting up a website plus my passion for writing, will surely help me find a precious slot in this venture. In the event that I succeed, the first thing that I would do is to echo this to my fellow visually impaired persons here in the Philippines, for in reality, aside from the chance to attain education, employment opportunity is what we truly seek.

This whole thing became a great learning experience for me. It helped me not just on the technical aspect of ICT, but it helped me grow as a mature independent person. I was fortunate enough that my God-given skills in the complexity of programming gave me the opportunity to be of help to my fellow trainees. In the end of every session, before we go to bed, I was the one tasked to help my fellow trainees cope up with the lessons. After the evening remedial and everyone catches up, we then begin to brainstorm and all-together develop and accomplish the assigned tasks. Those experiences taught me the real essence of teamwork, and my patience was greatly stretched.

At present, I am now back in the Philippines to continue my studies and to continue my life with the goal of making a difference. I will try my best to share every single fruitful thing that I learned with my fellow blind persons; to continue helping them realize that life has lots to offer and most of all, to alter the perception of all persons with sight. I greatly thirst for their attention, not in the sense of gaining glory for myself, but I yearn to be a living proof in my own little ways – that persons with impairment like me are not actually disabled. We still have our abilities, they were never lost nor have been disabled, and people have just to realize that we have our own special ways in making the best out of our skills and capabilities.

—–

Sources:

http://thestar.com.my ; http://terukoikeda.wordpress.com; http://www.informaticsdiliman.com

Informatics Lecturers Bag Gold in TESDA IT Skills Competition

We are Number One:

Informatics Lecturers Bag Gold in TESDA IT Skills Competition



Informatics is the Philippines’ Number One IT School. The country’s governing and regulating body on technical skills, the Technical Education and Skills Development Authority (TESDA) confirmed that last year when their Job Absorption Rate Review attested that Informatics IT training graduates have the highest employability among all computer school students.



This year, TESDA has confirmed this locally with their District Skills Competition. In the Pasay-Makati District (PasMak), two Informatics lecturers bagged the Gold medals in the IT skills competitions: Marichu Zafe for Software Applications and Ernesto “Jun” Resullar Jr. for PC Networking. Both hail from the Informatics Makati campus. In a showdown of various computer schools present in the PasMak district, Informatics proved its mettle.



For Software Applications, competitors would be given various tasks to accomplish using Microsoft Word, Excel, PowerPoint, and Access. PC Networking competitors would need to disassemble and assemble a computer, and set up a computer network. All tasks must be accomplished within the time limit. Marichu Zafe, the Software competition winner, shares: “The competition felt different from a classroom setting – there’s so much pressure so I really needed a lot of focus. Sinamahan ko na lang ng prayers. I tried to do everything as fast as possible.” Despite the pressure, Informatics proved to be the best computer school in PasMak.



Several lecturers from Informatics Makati were also called in to serve as subject matter Experts for the IT events: Vanessa Jose and Maynard Flaminiano for PC Networking and Joey Villota for Software Applications. The skills Experts would help to adjudicate the various events and evaluate each competitor. Experts will evaluate scores of all competitors, except for their own schools – so not only TESDA but experts from other computer schools can attest to the superior IT skills of Informatics!



The winners and experts were recognized at the awarding ceremonies which TESDA held at the SM Mall of Asia on September 23, 2011. Marichu and Jun will be competing at the regional level (NCR) in November. “I’m super excited for the NCR event,” Marichu enthuses. “This is our chance to be known as the best IT school.”



If you want to learn Basic and Advanced Office Applications, and Computer Troubleshooting and Networking, please contact your nearest Informatics – you’re sure to get the best skills in the field!