INDIVIDUAL ASSIGNMENT INDIVIDUAL ASSIGNMENT
AICT003-4-1-PITS AICT003-4-1-PITS PRACTICAL SKILLS
PRACTICAL SKILLS UCDF1505BIT ASSIGNMEUCDF1505BIT ASSIGNMENTNT
NAME:NUR SALSABILA BINTI LOKMAN NAME:NUR SALSABILA BINTI LOKMAN TP NUMBER
TP NUMBER:TP039211:TP039211
LECTURER NAME:ZETY MARLIA ZAINAL ABIDIN LECTURER NAME:ZETY MARLIA ZAINAL ABIDIN COMPANY:BELLY STATIONERY
COMPANY:BELLY STATIONERY
POSITION:CHIEF EXECUTIVE OFFICER POSITION:CHIEF EXECUTIVE OFFICER
ADDRESS:NO.311 TAMAN PINGGIRAN ATIRA KOK LANAS 1!"#0 KETEREH ADDRESS:NO.311 TAMAN PINGGIRAN ATIRA KOK LANAS 1!"#0 KETEREH KELANTAN
ACKNOWLEDGMENT
ACKNOWLEDGMENT
I am grateful
I am grateful and thankful to Gand thankful to God for giving od for giving the opportunity to the opportunity to complete this tascomplete this task on date thatk on date that given. Then, I want to thanks to my PITS lecturer Mrs Zetty Marlia inti Zainal !"idin for given. Then, I want to thanks to my PITS lecturer Mrs Zetty Marlia inti Zainal !"idin for guiding me how to complete the assignment.
guiding me how to complete the assignment. I also want
I also want to thanks "oth to thanks "oth of my parents of my parents for always for always giving me their giving me their support and words support and words ofof encouragementwen I felt depressed like wanna give up. #ast "ut not least, I want to thanks to my encouragementwen I felt depressed like wanna give up. #ast "ut not least, I want to thanks to my friends for their help in completing this task for me even
friends for their help in completing this task for me even they are also "usy do they are also "usy do their works.their works. $ithout them, the possi"ility cannot I set up this task perfect and well. Thanks to all those $ithout them, the possi"ility cannot I set up this task perfect and well. Thanks to all those involved directly or indirectly in helping me to
TABLE CONTENT
CONTENT PAGE !ST%!&T ' I(T%)*+&TI)( ' $!#T-%)+G- SP%/!*S-//T0 123 4+(&TI)(S !(* 4)%M+#!/ 56253 &)(*ITI)(!# 4)%M!TI(G 76 *!T! 8!#I*!TI)( 75 P!SS$)%* 79 M!I#M/%G/ 7'27: &)(&#+SI)( 7; %/4/%/(&/S 7<ABSTRACT
elly Stationery is a company that provides a wide range of stationery. $e provide the good services to our customers. y using /=cel, I can make an easy calculation for costs and "enefits of the company. I got a lot of helps from my lecturer, Mrs Zetty Marlia inti Zainal !"idin and my friends a"out how to use Microsoft /=cel.
INTRODUCTION
elly Stationery was esta"lished in >une 7651 "y the company?s chief e=ecutive officer. (ur Salsa"ila inti #okman. It is a small stationery company with the most @ualities and good services availa"le to our customers. The company offer three "rands of P ilot,4a"er &astell and Sta"ilo with each "rand is have than a"out five kinds of stationery.
Since our inception we have secured a fair siAed customers "ase supplying the stationeries. $e consider ourselves a Bonly oneC supplier satisfying customers demand.
WALKTHROUGH (SPREADSHEET)
5. M!I( P!G/
I choose a "ackground image of stars patterned. The main page consists hyperlink "utton of inventory, sale, salary,analysis as well as chart. -yperlink "utton are provided to easier for those to make open th certain sheet.
Inventory sheet show all the information of sales. This sheet consist product I*, product description, num"er "ought, initial cost per each, selling price per item, selling price, num"er sold, num"er on hand and total cost.
9. S!#/
This sheet shows a"out the sales of company in that month. This sheet contains the product I*, product description, initial cost per each, selling price per item, num"er sold, total selling price
". /MP#)D// S!#!%D T)*+ +)'', %-/, ''' '454%67' *6 B' S,%,*6'4. T)*+ +)'', 76,%*6 ,)' +,%8 ID -4%6+ +,%8 6%' +%%4 %7,/% +%' 7*++*6 54 '%7) ''' )*7) *+ 1#; 54 ) %7)*'<' ,)' ,%4&', +%' )*7) ,)' &4'%,'4 ,)%6 RM1#00. T)*+ +)'', %+ +) ,)' ,,% +%%4 /+ 7*++*6 5 '%7) -4%6. #. !(!#DSIS
!nalysis sheet shows the analysis of sales revenue, cost each "rands, commission earned for reach staff "y each "rand profit, chart of profits and data of analysis. This sheet also shows various types of chart like "ar chart. 4rom the charts, we can know the profits and the loss for our company.
MAIN PAGE >HOME?
70-DP/%#I(
50#)G) +TT)(
1?LOGO
i. &lick the insert "utton and then look for shapes "utton.
ii. !fter click the shapes "utton. There are many types and shapes to choices. Then choose as "elow shape and customiAe the colour.
iii. Then click right "utton to edit te=t. !fter that click te=t to choose the types of colour and font.
2?HYPERLINK BUTTON
i. To create a hyperlink "utton, follow the same way to produce a logo to find oval shapes, then after finish doing the shapes, press the right click "utton on the shapes and find hyperlink.
**. !fter click at BPlace in This *ocumentC, click where the "utton wants to Eump to a new document or a new section within the current document.
50 TIT#/
70 T!#/ 90-DP/%#I(
1)TITLE
-ighlighted the space needed for the title and go to B-omeC and click BMerge F &enterC.
!fter click BMerge F &enterC, fill in the title in the "lank "o=.
2)TABLE
4irstly, to create a ta"le click insert then choose ta"le
!fter done click ta"le this "o= appear then Eust click )
Then drag the column until the num"er of column is enoughto make suita"le ta"le and fill in data in ta"le.
a) Cost of Each Item
4or cost of each item, use formula Bnum"er soldHinitial costC.
b) Selling Price
4or selling price, use formula Binitial costH5.'C.
c) Total Cost
4or total cost, use formula Binitial costHnum"er soldC.
>ust follow the same way to make the hyperlink. This "utton, hyperlink, must Eump to main page-ome0.
%) #astly for this part, to add up all the data use the !utoSum formula.
SALES SHEET
i Total Selling Price
4irst, create the ta"le as in the inventory sheet. Then fill in the data ta"le as usual. In this section, Eust copy all the data from inventoryuse linking worksheet0 /&/PT total selling price.
I. T)T!# S/##I(G P%I&/
EMPLOYEES SALARY SHEET
1?COMMISSION 3?PERFORMANCE
2?TOTAL SALARY
4irst, create ta"le as in inventory. Then fill in the data in ta"le as usual.
1)CO&&ISSION
4or commission, if the target sales revenue is less than %M5166, the commission is 51J from the selling price of the item sold.
If target get sales revenue is e@ual to or greater than %M5166, the items sold after that will "e counted with a commission of 51J from the selling price.
2)TOTAL SALA#"
4or total salary, use formula BSalary added &ommissionC.
)STA''(S PE#'O#&ANCE
4or staffs? performance, if the target sales revenue is e@ual to or greater than %M5166, the performances is BG))*C.
If the target sales revenue is less than %M5166 "ut greater than %M5666, the performance is B!)+T !8/%!G/C.
4or the target sales revenue is less than %M5666 "ut greater than %M166, the performance is BS!TIS4!&T)%DC.
ANALYSIS AND CHART SHEET
4irstly, create a ta"le and fill in the data. In this analysis sheet must have ta"le for sales revenue for each "rand, total sales revenu, cost for each "rand, total sales revenue, cost for each "rand, total cost, salary plus commission for each employee, total salary and the profit and also chart for analysis2purpose.
i) *ata for sales revenue Eust copy from sales sheet. ii) *ata for cost Eust copy from inventory sheet.
BAC$G#O*N+ S!EET
/very single sheet must have "ackground photo.
4irst, search an image for the "ackground in internet, then save the photo in gallery. Then, find KP!G/ #!D)+T? and click the BackgroundC to insert the photo.
LIN$ING ,O#$S!EET
#inking worksheet is a formula that dynamically pulls in data from a cell to another cell in worksheet. /very time the cell value in the source worksheet changes, the cell containing the linking formula will update as well when we opened it ne=t time. In this spreadsheet, these are few linking word worksheet.
I' STATE&ENT
CON+ITION 'O#&ATING 50-ighlight the cells
70&lick the "utton conditional formatting at B-omeC ri""on. Then click the "utton B-IG-#IG-T &/##S %+#/SC then click B#/SS T-!(LC.
+ATA -ALI+ATION
5. Select one or more cells to validate.
7. Go to B*!T!C ri""on and then click the data validation.
9. 4ill in at setting, click "utton of imput message and fill the title and imput message. (e=t, click "utton of error and fill style, title and error message and click ).
i. n n
P#OTECT S!EET O' SALES S!EET a0 )n the review ta", click protect sheet.
"0 There will appear to protect your sheet "o=. Type your password and click ).
PASS,O#+ *SE#
I. 4irst, unprotect sheet and then highlight one or more cell. )n the review ta", click allow users to edit ranges then click new.
II. 4ill up and range password then click ).
&AIL &E#GE
ST/P D ST/P -)$ T) &%/!T/ M!I# M/%G/
5. &lick mailing and select mail merge. Select Bstep2"y2step Mail Merge $iAardC.
7. &lick letters.
9. Select use the current documents.
1. &lick ne=t and preview your letter.
CONCLUSION
In a conclusion, from this assignment I can learn many new things a"out Microsoft $ord, Microsoft /=cel, Microsoft !ccess and Microsoft Power Point. I get to know how to use and functions of all Microsoft. 4rom Microsoft word I learn a"out how to use mail merge and make a documentation. )ther than that, from Microsoft e=cel I got learn how to make a ta"le, shortcut calculation and how to insert the formula properly. (e=t, from Microsoft access I learn how to create @uery, form, report and so on. !nd the last is Microsoft power point, I learn how to complete and make a perfectly slide. This will help me in my "usiness on day.
REFERENCE
$e"space.apiit.edu.my, 76510.!I&T6692'252PITS. onlineN !vaila"le at
httpOOwe"space.apiit.edu.myOmodOfolderOview.phpidQ75';; !ccessed 53 !ug. 7651N.
