How to Make Pie Charts

How to Make Pie Charts (Using MsExcel)

The Pie chart is one of my favorite graphical presentations. I consider it the best graph to differentiate gender, age brackets, and division/departments. I'm an expert in making this type of chart.

Check out my pdf presentation in scribd below.

How to Make Pie Charts

^{A pie chart (or a circle graph) is a circular chart divided into sectors, illustrating proportion. In a pie chart, the arc length of each sector (and consequently its central angle and area), is proportional to the quantity it represents. When angles are measured with 1 turn as unit then a number of percent is identified with the same number of centiturns. Together, the sectors create a full disk. It is named for its resemblance to a pie which has been sliced. The earliest known pie chart is generally credited to William Playfair's Statistical Breviary of 1801.} 

^{The pie chart is perhaps the most ubiquitous statistical chart in the business world and the mass media. Pie charts can be an effective way of displaying information in some cases, in particular if the intent is to compare the size of a slice with the whole pie, rather than comparing the slices among them. Pie charts work particularly well when the slices represent 25 to 50% of the data, but in general, other plots such as the bar chart or the dot plot, or non-graphical methods such as tables, may be more adapted for representing certain information.It also shows the frequency within certain groups of information.}

^{(source: wikipedia)}

Read more »

Work of a Job Analyst

Job Analyst

I've been handling Job Analyst position for 8 years. The scope of this job covers all divisions and category level managers and down in the company.

Job analysts work in the human resource (HR) department conducting in-depth research about occupations and job descriptions. 

They focus on worker classification systems while studying the effects of industry and occupational trends upon worker relationships. 

They also provide management with descriptions of what each employee in the company does, so that human resources recruiters will know what to look for when hiring employees as well as understand the components of each job. 

The job analyst's role has become increasingly significant as companies and organizations realize the importance of hiring the most qualified employees according to their job descriptions thereby contributing to the profitability and success of any business. 

Job analysts often serve as the technical liaison between the firm and industry, government, and labour unions. 

They usually work for larger companies and organizations, as their skill is very specialized in the HR department. Job analysts gather information about jobs through interviewing employees, observing performance of certain tasks, asking employees to fill out questionnaires and worksheets, and collecting information about a job from secondary sources. 

They know what questions to ask specific individuals and even what questions not to ask, such as personal religion or marital status questions. 

The job analysts will then write-up their findings from the analysis and review them with management. 

The documentation is then presented to the senior manager supervisor for review. 

The supervisor may then act as an editor to add, delete or modify duties, knowledge, skills, abilities, and other characteristics. 

A signed and dated job description is then prepared and the job description becomes the official company record for a particular job. 

The employment analyst field comprises two differing roles -- job analysts and occupational analysts. 

The main difference between the two is that a job analyst looks directly at the worker whereas an occupational analyst studies how a particular worker fits into their career.

Read more »

Industrial Engineer

What is Industrial Engineering?

Industrial engineering is concerned with the design, improvement, and installation of integrated systems of people, materials, and technology. Industrial engineers combine knowledge of mathematics, physical sciences, and social sciences with the principles and methods of engineering analysis and design. At one time, industrial engineers were employed mainly in manufacturing, however, today they are employed by both manufacturing and service industries, which has increased the demand for industrial engineers.

Industrial engineers:
         I. Improve productivity
         II. Improve quality by determining the most effective methods of using the basic factors of production:
                 a) Machines
                 b) Materials
                 c) Personnel

Specialize in:

1. Methods planning         
2. Facilities planning and layout
3. Product design
4. The selection and design of machines and equipment to be used in manufacturing
5. The supervision of the installation of industrial equipment
6. Other areas of specialization include:

            ♦ Development of work measurement systems

            ♦ Production methods and standards
            ♦ Cost control systems
            ♦ Materials handling
            ♦ Total quality management
            ♦ Safety engineering
            ♦ Systems engineering
            ♦ Operations research

Industrial engineering provides an excellent background to management positions because its practitioners are educated in both engineering and management.

Read more »

Curriculum Vitae | MitchieC

MitchieC, IE, MBA
Masters in Business Management, Xavier University
BS Industrial Engineering, University of San Carlos – Technological Center
BrainBench.Com transcript ID: 9436751 mitchiec@gmail.com | skype: mitchloe | +63.917.706.2865

SUMMARY

I am open for a part-time virtual assistant job.

Your company can leverage on my Human Resource and Administrative experience, on-line & off-line sales and marketing skills, and passion for winning. I always go the extra mile to find the most efficient and effective way of doing things to keep ahead of competition. I am a born ‘organizer’, taking pleasure in systematically arranging  my documents and files, as I like things to be in order around my work area. Planning events and activities, benchmarking the practices of other companies, and making research and HR studies are all exciting exercises which stimulate my mind, providing an array of challenging situations.

SHORT EMPLOYMENT HISTORY

Supervisor, Job Info, Organization & HRIS, Corp. Compensation & Benefits and HRIS, DMPI
Job Analyst, Corp. Compensation & Benefits and HRIS, Del Monte Philippines, Inc.
HR Project Employee, Cannery HR Management, Del Monte Philippines, Inc.
On-The-Job-Trainee, Cebu Crafters, Inc., Cebu City
Computer Assistant & Cashier, Cybase Internet Café


EMPLOYMENT HISTORY

Supervisor, Job Info, Organization & HRIS
Corp. Compensation & Benefits and HRIS, Del Monte Philippines, Inc., Cagayan de Oro City
September 2008 to present
Reporting to: Senior Manager, Corp. Compensation and Benefits, & HRIS

Conducts job analysis & job evaluation for corporate-wide positions; provides supervision in planning, executing and assisting manpower statistics reports and ensures that the different position questionnaires of the various jobs in the Cannery are promptly and regularly updated for unconstrained analysis and evaluation; provides research data and recommendations to the Human Resource Management team as a tool for decision making; updates corporate-wide organizational charts, consolidates corporate-wide manpower plan & manpower statistics reports.

Major Duties & Responsibilities:
·          Oversees HRIS system implementation, updates, and maintenance
·          Updates Corporate-wide Organizational Charts, company policies, and information
·          Consolidates the Corporate-wide Manpower Plan
·          Reviews the Corporate-wide Monthly Headcount Report
·          Conducts HR Research and studies
·          Assists in preparing Departmental Budget
·          Conducts Job Analysis and Job Evaluation; Job Matching
·          Performs Headcount Monitoring
·          Generates and consolidates Corporate-wide Manpower Statistics reports
·          Generates Headcount reports - comparison, historical, monitoring, absenteeism, labor turn-over and the like
·          Accomplishes surveys from government agencies, individuals, private, & other companies
·          Maintains and updates data & stats (basic commodities prices, fuel rates, & others indicators)
·          Reviews corporate-wide Personnel Movements – change rate, transfers, change levels
·          Gathers personnel-related data & stats for my superiors
·          Oversees the HR Research filing system
·          Others: prepares presentation materials for top management

Job Analyst
Corp. Compensation & Benefits and HRIS, Del Monte Philippines, Inc., Cagayan de Oro City
May 2001 to October 2008
Reporting to: Senior Manager, Corp. Compensation and Benefits, & HRIS

Performs job analysis & job evaluation for corporate-wide positions; gathers data for Research/Studies to include documentation and administrative needs of the department; updates corporate-wide organizational charts, consolidates corporate-wide manpower plan & manpower statistics reports.

Major Duties & Responsibilities:  
·          Updates Corporate-wide Organizational Charts, company policies, and information
·          Consolidates the Corporate-wide Manpower Plan
·          Consolidates the Corporate-wide Monthly Headcount Report
·          Conducts HR Research and studies
·          Assists in preparing Departmental Budget
·          Conducts Job Analysis and Job Evaluation
·          Conducts Job Matching
·          Performs Headcount Monitoring
·          Generates and consolidates Corporate-wide Manpower Statistics Report
·          Generate Headcount reports - comparison, historical, monitoring, absenteeism, labor turn-over and the like
·          Accomplishes surveys from government agencies, individuals, private, & other companies
·          Maintains and updates data & stats (basic commodities prices, fuel rates, & others indicators)
·          Reviews corporate-wide Personnel Movements – change rate, transfers, change levels
·          Gathers personnel-related data & stats for my superiors
·          Oversees the HR Research filing system
·          Others: prepares presentation materials for top management

HR Project Employee
Cannery HR Management, Del Monte Philippines, Inc., Cagayan de Oro City
October 2000 – May 2001
Reporting to: Manager, Corporate Compensation and Benefits

Major Duties & Responsibilities:
·          Conducts Job Analysis and Job evaluation
·          Conducts HR Research and studies 
·          Assists in hiring skilled and unskilled pool
On-The-Job-Trainee
Industrial Engineering Department, Cebu Crafters, Inc., Cebu City
November 1999 to March 2000
Reporting to: Industrial Engineering Department Head

Major Duties & Responsibilities:        
·          Performs Time study
·          Performs crewing study

Computer Assistant/ Cashier
Cybase Internet Café, Talamban, Cebu City
June – September 1998
Reporting to: Proprietor

Duties:  
·          Assists the customers
·          Troubleshoots minor computer problems
·          Tends the cash box


NON-WORK BACKGROUND

Franchise Distributor – Northern Mindanao,  Aromacology Sensi  - Bath & Body Products
December 2006 to Present
Runs own Franchise Outlet as a Franchise Distributor.

Stock Investor and Trader, Philippine Stock Exchange (PSE)
Year 2008 to Present
Earned approximately 24% since July 2010 to present (gained approximately 37% growth).

Dealer, Human ♥ Nature
December 2009 to Present
Distributes bath & beauty products.

Webmaster assistant and internet marketer, Snap in a Box Photobooth (www.snapinabox.com)
October 2009 to Present
Maintains and updates website; promotes business online.

Proprietor,  Pili Pinoy Online Store (FaceBook: Pili Pinoy; www.pilipinoyonlinestore.blogspot.com)
August 2010 to Present
Sells products and services online.


EDUCATION

Graduated - Master in Business Administration (MBA)
Xavier University, Ateneo de Cagayan, Cagayan de Oro City     

Earned Units - Master of Arts in Human Resources Development (MA-HRD)                     
Lourdes College, Cagayan de Oro City

Graduated - Bachelor of Science in Industrial Engineering     
University of San Carlos-Technological Center, Cebu City                              



WORKSHOPS, SEMINARS, SHORT COURSES ATTENDED/ RECEIVED

Effective Presentation Skills Workshop (Del Monte Philippines, Inc.)
September 23-24, 2010.  Del Monte Bungalow, Camp Phillips, Bukidnon

Put it in Writing Course (Del Monte Philippines, Inc.)
September 7-8, 2010.  Del Monte Bungalow, Camp Phillips, Bukidnon

LeAD 2: Systems Thinking and Strategic Planning (Del Monte Philippines, Inc.)
August 25-26, 2010.  Del Monte Bungalow, Camp Phillips, Bukidnon

Internet Marketing Workshop (by Jomar Hilario)
August 14-15, 2010.  Cebu City

Virtual Assistant Seminar (by Jomar Hilario)
August 13, 2010.  Cebu City

2008 ASPBI and 2008 SICT Data Dissemination and Launching of the 2009 ASPBI, 2009 SICT and 2009 STEP (National Statistics Office-Region 10)
July 29, 2010. Grand Caprice, Cagayan de Oro City

LeAD 1: Building the Leadership Difference (Del Monte Philippines, Inc.)
July 14-16, 2010.  Del Monte Bungalow, Camp Phillips, Bukidnon

2006 ASPBI Regional Data Dissemination (National Statistics Office-Region 10)
March 27, 2009. Mallbery Suites, Cagayan de Oro City

FOCUS: Achieving Your Highest Priorities (Franklin Covey)
September 19, 2008. Marco Hotel, Alwana, Cagayan de Oro City

Applying EQ at Work (PMAP-CdO)
September 5, 2008. Pearlmont Inn, Cagayan de Oro City

Advanced MsWord, Advanced MsExcel, MsPowerPoint Course (Informatics Computer Institute, Philippines)
October 27-November 4, 2006. LFL CYD, Camp Phillips, Bukidnon

Advanced MsExcel Course (Del Monte Philippines, Inc.)
October 21, 2006. LFL CYD, Camp Phillips, Bukidnon

DACUM Facilitation Workshop (Del Monte Philippines, Inc.)
April 10-12, 2006. Bungalow, Camp Phillips, Bukidnon

Understanding The ISO0 9001:2000 Standard and Its Documentation Requirements
January 11-13, 2006. Del Monte Phils., Inc. – Conference Room

Cleaner Production Workshop
April 5, 2003. Country Village Hotel, Cagayan de Oro City

Fire School (Del Monte Plant Safety and Training Department)
May 1, 2001. Bugo, Cagayan de Oro City

Logistics Seminar on Forwarding
March 11, 1999. University of San Carlos-Technological Center, Room 245

Seminar on Pneumatics. FESTO
February 10, 1999. FESTO, Mandaue City

Leadership Training Seminar
August 16-18, 1996. Talisay, Cebu City

Time Management Seminar
August 9, 1997. University of San Carlos-Technological Center, Cebu City


SKILLS AND HOBBIES
Ø  Computer Literate

    * Microsoft Windows 95/ 98/ 2000/2007
    * Microsoft Office Programs (Ms Word, Ms Excel, Ms PowerPoint, Ms Visio, Ms Outlook, Visio)
    * Internet research and browsing
    * Photoshop Adobe CS
    * Blogging
    * Internet Marketing

Ø  Inter-company Benchmarking
Ø  Online Stock investing and trading
Ø  Driving, Licensed Non-Professional Driver
Ø  Events Organizer/ Coordinator and planner (birthdays, parties, send-offs, etc.)
Ø  Stock Investing and Trading
Ø  Business scheduling
Ø  Making personal appointments
Ø  Hiring various services
Ø  Buying personal and corporate gifts
Ø  Hotel reservations
Ø  Travel arrangements for clients (arranges trip and itineraries for family & friends)
Ø  Paying personal bills
Ø  Handling household activities
Ø  Dancing, Acting, Traveling
Ø  Sports: badminton, golf, bowling, run/walk, rappelling, spelunking, mountain climbing
Ø  Language - English, Filipino, Cebuana/ Bisaya


PERSONAL BACKGROUND:
Birth date: May 18
Nationality: Filipino  
Civil Status: Married      

Read more »