MINGGU 5 - 18 OKTOBER 2012 (MICROSOFT POWER POINT)

1- Pengenalan Kepada Microsoft Power Point

2- Pembahagian Kumpulan Untuk presentation next week.

3- Assigment Power Point :

ASSIGNMENT 3: MICROSOFT POWERPOINT

You are required to create a presentation using Microsoft PowerPoint in a way you may find it attractive and unique. Convey your information simply and precisely. There are three guidelines for creating effective presentation as follows:

·         Grab viewer’s attention

·         Clearly communicate your information

·         Stay in control of your presentation

Suggested topics for presentation:

You can choose any interesting topics or world most popular issues in year 2012 such as in the area of computer, business, science, health, geography, society, welfare, astronomy, education, history, crime, sport, industrial revolution and politics.

About the assignment:

1. Your presentation slides must consist of at least 10 slides and must NOT exceed than 15 slides.
2. Your presentation must have all of these elements:

No	Elements
1	Title
2	Text
3	Slides Number
4	Background
5	Bulleted Lists
6	Charts/Graphics/Pictures
7	Tables
8	Slide Transitions
9	Sound/Music
10	Short movies/videos*
11	Animation
12	Header and Footer
13	Link or Hyperlink
14	Word Art
15	Consistent Color Theme

*As for video, you are required to create your own video. For example, you can insert an introduction video about your group and presentation topic. The video duration should be less than 5 minutes.

EVALUATION:

Marks will be given according to:

·         The contents (eg. informative)

·         The creative layout and style of the presentation

·         The elements in Microsoft PowerPoint

SUBMISSION:

You will need to present your PowerPoint presentation during the lab session. You will be given only 5-10 minutes to present your slides.

BLOG: In your own blog, please upload your video (1 file) and PowerPoint presentation (1 file) in two separate blog entries.

EMAIL: Please don't forget to email a copy of your assignment to your lecturer

MINGGU 5 - 11 OKTOBER 2012 (MICROSOFT EXCEL)

Assignment Excel :

Assignment 2: Microsoft Excel

This is an individual assignment. You are new Human Resource Executive in ABC Enterprise. You will need to use these tables as reference to develop new table by following below instructions.

Table 1 Employee information

Employee ID	Full Name	I/C No	Age	Contact No	Job ID	KPI
ABC1001	Mohd Shahrul Nizam	790323-02-6037	33	012-3456789	70	4
ABC1002	Muhammad Irham Shafy	870915-10-1243	25	019-4567890	501	3
ABC1003	Nur Fathaen Arynee	851023-10-7890	27	013-5678901	509	4
ABC1004	Akmal Razi	881120-05-5287	24	010-9876543	1002	5
ABC1005	Fauziah Ahmad	880428-04-9876	24	013-2345678	1007	1
ABC1006	Zulkifli Zaini	900712-10-6543	22	011-8970324	1009	2
ABC1007	Saiful Nizam	900227-05-7643	22	010-7549239	1012	0
ABC1008	Ahmad Dani	900514-07-8761	22	011-7357401	1013	0

Table 3 Job description

Job ID	Job Description	Job Level	Leave  (day)	Basic Wage (RM)
70	Managing Director	Executive	20	4000
501	Technical Manager	Executive	15	3000
509	Account Manager	Executive	11	2600
1002	Technical Assistant Manager	Non-executive	7	1600
1007	Technician	Non-executive	12	1380
1009	Technician	Non-executive	8	1360
1012	Technician	Non-executive	10	1240
1013	Technician	Non-executive	1	1250

1.       Create a individual payroll calculator table from data in table 1 and 2. Name this table 3 as Payroll Calculator. You need to calculate payroll for this month of September 2012.

a.       Add Employee ID, Employer EPF (12%), Employee EPF (9%), Employer Socso (1.5%), Employee Socso (1.2%) and Tax (10%) fields. Tax field only applicable for employee with salary more than RM2500. Calculate the percentage base on Basic Wage and fill up each of the fields.

b.      Add Net Wage field and fill up in each row. Net wage must deduct from Employee Socso, Employee EPF and Tax contribution.

c.       Create new table 4 as Payroll. You need to add field such Date, Total Amount, Average, Minimum and Maximum Amount. The date will be last date of each month. Calculate previous month of August, current month and expected of next month salary expenses. For your additional information, Saiful Nizam and Ahmad Dani just joined the company early this month and Nur Fathaen Arynee will leave this company end of this month.

d.      Use LOOKUP function to determine the performance base on the KPI. The performance can assign as below :

        0-Not Evaluate, 1-Poor, 2-Medium, 3-Good, 4-Excellent

2.       Sort of each table by following

a.       In ascending sequence by name

b.      By net wage (ascending)

3.       Use the COUNTIF function to calculate the number of employee base on their KPI. Create pie chart for the result above.

Assignment must be posted in your own blog using Google documents.