Assignment 3: Microsoft PowerPoint

Assalamualaikum wr wb n Salam Sejahtera

Below are the groups name and the title for the presentation for next week:

KUMPULAN	TAJUK
KUMPULAN 1 & 2	UKM TANPA SEMPADAN
KUMPULAN 3 & 4	MAKANAN
KUMPULAN 5 & 6	CINTA
KUMPULAN 7 & 8	ISLAND TO VISIT IN MALAYSIA
KUMPULAN 9 &10	HAIWAN PELIHARAAN
KUMPULAN 11 & 12	PERBEZAAN PERKAHWINAN DULU DAN SEKARANG
KUMPULAN 13 & 14	KEPUPUSAN HIDUPAN LIAR
KUMPULAN 15 & 16	WANITA GEMOK SELEPAS KAHWIN
KUMPULAN 17 & 18	KAWAN PELANCUNGAN DI MALAYSIA
KUMPULAN 19 & 20	KEK
KUMPULAN 21 & 22	ANIMATION MOVIE

Good Luck!

NAH

Tugasan Excel

Dear all

Below is your Excel assignment:

You are asked by your father to organize the inventory data of his sundry shop. Use these tables and follow the instructions.

Table 1  Items on Hand

Item Number	Description	Inventory	Price(RM)
B60338	Nescafe 3-in-1	619	14.25
M44910	Milo 500g	873	9.50
C71610	Dumex 500g	579	17.60
S80787	Beras cap ketupat 10kg	537	22.50
T36275	Planta 1kg	764	12.45
T74695	Kinder Bueno 3x43g	208	8.30
W59366	Quaker Oat cookies 280g	268	7.95
C248890	Nutella 375g	385	13.80
C87343	Mineral water 1.5l x 15	387	14.05
W15840	CintanMeeGorengPedas 2packs	699	6.85
C49955	Marigold 100% Fruit Juice	237	18.25

           

Table 2  Priority Codes

Inventory	Priority
0	1
250	2
400	3
600	4
800	5

1.      Create an inventory table from the data in Table 1.  Name this table as Table 3

a.       Add an Amount field and a Priority field. Both are calculated columns. Inventory Amount equals Inventory times Price.

b.      Find the Total Amount, Average, Minimum and Maximum Amount, each in separate rows below Table 3

c.       Calculate the percentage of Inventory Amount of each item in a new table (Table 4)

d.      Create a Priority Code table in the range U1:J6 using the data shown in Table 2.

e.       Use the VLOOKUP function to determine the priority to assign each record.

2.      Copy the table into 3 and sort each table by the following

a.        in ascending sequence by inventory

b.      by amount (ascending) within priority code (descending)

c.       in descending sequence by priority code

3.      Execute the following queries

a.       Number of items with Priority code equals to 2

b.      Inventory  greater than 250 and less than 600

c.       Sum of Inventory Amount greater than RM2000

4.      Create a suitable chart that shows the item description against the Inventory Amount.

The due date for this assignment is March 29, 2012.  Upload your assignment on your blog. Late submissions will not be entertained.

words for mail merge

Noor AzuanHashim
Lecturer
Management Department
Economic and Management Faculty, 
UniversitiKebangsaan Malaysia, 
Bandar BaruBangi

Selangor, Malaysia
(603) 8921-5751

Re:       Temporary Appointment        

You can work here for a little while in a temporary position Engineer at Ipoh.

I am pleased to advise you can start. Your appointment will be established as, at the salary of  bi-weekly and you will work for the first two months, and transfer to for another three months.  Your probation period is six months.  If you are capable in handling things according, we will offer a full time job yang your grade and salary will be revised.

Congratulations on your appointment. We hope to work well with you.

Yours truly,

Your Word Assignments

Salam and salam sejahtera...

Please read the following announce carefully, and make sure you use the time given in the class to finish up your assignments:

MICROSOFT WORD ASSIGNMENT 1

Attention: This is a group assignment. You are allowed to this assignment with just another student. This means that your friend and you will be responsible for this assignment.

You need to create two documents using MS Words 2007, installed in the computer lab. You may write in English or in Malay.

First document: One page of Newsletter from one of the topics listed at the end of this announcement. This document should include the following formatted elements:

·    Text	·    Text box	·  Suitable text formatting for font type, size, color
·    Pictures /Graphics/ Photos	·    Background color or image
·    Header & footer	·    Tables or chart or smart art
·    Clip Art	·    Drop Cap	·  Must have creative and suitable layout
·    Word Art	·    Columns

Second document: This document should contain at least 6 formatted pages or up to the maximum of 12 pages. If you have more than that, you will be penalized. This document should looks like an article that you read from any journals. The main features that you need to include in this document include:

·    Text	·   Text box	·  Paragraph and margin
·    Pictures /Graphics	·   Table of Content	·  Suitable text formatting for font type, size, color
·    Header & footer	·   Tables or chart
	·   Columns	·  Must have creative and suitable layout

Due date for this assignment is on 12 March 2012. You must email your both assignments to your instructor. Please embed your newsletter in your own blog using Google documents, or convert it to pdf file and post it to your blog.

The list below shows the students name and their topics for the assignment. Please make sure that you work with a friend who get the same topic with you.

Matriks No	Name	Topic
A135615	ZULHANIZAM BIN SULAIMAN	1
A135887	NUR AMALINA BINTI MISLAN	2
A135889	MAISARAH BINTI FUAD	3
A135998	ZURLIYANA IZZATI BINTI MOHD AZMI	4
A135999	NUR SYAHIRAH IZZATI BINTI MOHD SHARIF	5
A136180	NORHUDA SYAZANA BINTI ZAINAL	6
A136223	MUHAMMAD SYAFIQ BIN ABDUL GANI	7
A136243	AISYAH AMIRA BINTI FAUZI	8
A136268	SIE CHOO KEONG	9
A136324	SITI NOR SAIYIDAH BINTI KASSIM	10
A136353	SYAFINAZ BINTI ZOLKIFLI	11
A136371	SAJIDA BINTI AZALKIFLI	12
A136379	MUHAMMAD ALIFF FARHAN BIN KAMAL	13
A136382	MOHD SHAHRIL BIN MOHD SHUKRI	14
A136418	KRISHNAVANI A/P RAJASORIAN	15
A136453	ALMIZAR BIN AMIL HAMZAH	16
A136462	NURHANIS SYAZWANI BINTI OTHMAN	17
A136478	SUVARNA A/P BUN LOM	18
A136491	JAMILAH BINTI ISMAIL	19
A136498	NUR MADIHAH BINTI ROZAK	20
A136532	NOR AIDA BINTI BASRI	21
A136566	NUR AMIRA BINTI SAIDIN	22
A136656	HERMA HAZLINA BINTI A HANIM	1
A136686	MUHAMAD AFIF BIN MOHAMAD	2
A136687	MOHAMAD AZRI BIN AZHAR	3
A136689	SHARLILY SHAHIRA BINTI MAT NASIR	4
A136702	FARAH WAHIDAH BINTI JAMIL	5
A136715	NURUL ANIYAH BINTI SALIHIN	6
A136756	SYAHIRA BINTI MALEK	7
A136772	ATIKAH BINTI MOHD. NOR MAZLAN	8
A136777	AINAA NAJWA BINTI MOHD SUFI	9
A136786	WASEEM NURFAR`AIN BINTI ISHAK	10
A136800	SITI NOORHAIRUNNISHA BINTI MOHD ZULKAFLY	11
A136809	SALINA BINTI SARJI	12
A136823	ABDUL MUNEIM BIN HASSAN	13
A136908	NURUL IZZATI BINTI JUWANI	14
A137018	SYAZWANI BINTI MOHD ROSLAN	15
A137065	NORAFIDAH BINTI ROSLI	16
A137076	AHMAD SAIFULHISHAM BIN JAMAL	17
A137161	NAZMI AZIZI BIN MASSUAN	18
A137478	MUHAMMAD AZLAN BIN MOHAMED SHERAFATH ALI	19
A138722	NAJUMUNISHA ABDUL JABBAR	20
A138745	M. ASWIN HENDRAYADI	21
A138759	NURDIANA BINTI OTHMAN	22

Topics

1.      Impact Of E-Learning To Students

2.      Advantages And Disadvantages Of Social Networking

3.      Computer – The Effect To Human Life

4.      E-commerce – Do you think people should use them?

5.      Facebooking – Do We Need It?

6.      Why Do We Need To Learn Computers?

7.      Internet Addicted 

8.      The Good And Bad Having Everything Online

9.      Impact Of The Internet To Everyday Life

10.  Green Technology – Why We Should Aware With This Phenomenon?

11.  History of Computer

12.  Youtube

13.  Internet Linguistic Culture

14.  New IC Technologies in the Fields of Commerce and Tourism

15.  New Services in Financial Institutions

16.  People and E-Government

17.  Next Generation Networks

18.  Security and Trust in a Mobile World

19.  Analysis of a Hardware Systems

20.  Analysis of a Software Systems

21.  Online Banking in Malaysia

22.  Hotel and the Internet

23.  Online Booking Systems in Airlines Industry

24.  Mobile Phones in Their Generations

25.  Antivirus Software

Good lucks guys!!!


NAH