1. Homepage
  2. Homework
  3. EPPD1063: Computer Application LAB TEST 1: Excel
This question has been solved

EPPD1063: Computer Application LAB TEST 1: Excel

Engage in a Conversation
UKMEPPD1063Computer ApplicationExcelWord

CourseNana.COM

EPPD1063: Computer Application
CourseNana.COM

  CourseNana.COM

LAB TEST 1 CourseNana.COM

  CourseNana.COM

  CourseNana.COM

May 2024 CourseNana.COM

2 hours CourseNana.COM

  CourseNana.COM

  CourseNana.COM


CourseNana.COM

Instruction: Please save all answers (Excel and Words files) in a folder and named it with your Matric Number. Please submit both files via UKMFolio. No excuse is accepted if you forgot to submit any of the files. CourseNana.COM

  CourseNana.COM

Part 1: Microsoft Excel (50 marks) CourseNana.COM

1.     Please create a new Microsoft Excel file and save the file. In this file, please rename the sheet as Data. CourseNana.COM

2.     By using the data below, please proceed with the following instructions: CourseNana.COM

Item CourseNana.COM

 Matric Number CourseNana.COM

 Name CourseNana.COM

Q CourseNana.COM

A CourseNana.COM

M CourseNana.COM

F CourseNana.COM

 1 CourseNana.COM

Your Own Matric No CourseNana.COM

 Your Own Name CourseNana.COM

65 CourseNana.COM

71 CourseNana.COM

79 CourseNana.COM

84 CourseNana.COM

 2 CourseNana.COM

A191342 CourseNana.COM

 NG ZHI QIAO CourseNana.COM

73 CourseNana.COM

74 CourseNana.COM

53 CourseNana.COM

67 CourseNana.COM

 3 CourseNana.COM

A191455 CourseNana.COM

 NUR HALIZA BINTI HALIM CourseNana.COM

90 CourseNana.COM

90 CourseNana.COM

70 CourseNana.COM

80 CourseNana.COM

 4 CourseNana.COM

A191549 CourseNana.COM

 AIN BINTI HISHAM CourseNana.COM

97 CourseNana.COM

74 CourseNana.COM

60 CourseNana.COM

78 CourseNana.COM

 5 CourseNana.COM

A191637 CourseNana.COM

 NAZARUL BINTI HANIFFA CourseNana.COM

69 CourseNana.COM

63 CourseNana.COM

51 CourseNana.COM

61 CourseNana.COM

 6 CourseNana.COM

A191648 CourseNana.COM

 NUR IZZAH BINTI AZMI CourseNana.COM

80 CourseNana.COM

83 CourseNana.COM

53 CourseNana.COM

70 CourseNana.COM

 7 CourseNana.COM

A191721 CourseNana.COM

 RAMA A/L VIJAY CourseNana.COM

81 CourseNana.COM

67 CourseNana.COM

68 CourseNana.COM

83 CourseNana.COM

 8 CourseNana.COM

A191900 CourseNana.COM

 NABILAH BINTI MAJID CourseNana.COM

82 CourseNana.COM

83 CourseNana.COM

52 CourseNana.COM

55 CourseNana.COM

 9 CourseNana.COM

A191911 CourseNana.COM

 AMIRAH ISMAIL CourseNana.COM

67 CourseNana.COM

69 CourseNana.COM

60 CourseNana.COM

88 CourseNana.COM

 10 CourseNana.COM

A191957 CourseNana.COM

 SURAYA RAHMAN CourseNana.COM

78 CourseNana.COM

69 CourseNana.COM

61 CourseNana.COM

79 CourseNana.COM

 11 CourseNana.COM

A192029 CourseNana.COM

 KUMARI A/P SAMY CourseNana.COM

87 CourseNana.COM

69 CourseNana.COM

53 CourseNana.COM

76 CourseNana.COM

 12 CourseNana.COM

A192055 CourseNana.COM

 SHAMIL BIN GHAFAR CourseNana.COM

73 CourseNana.COM

74 CourseNana.COM

60 CourseNana.COM

59 CourseNana.COM

  CourseNana.COM

i)      The details for the columns are as below: CourseNana.COM

Q is for Quiz, A is for Assignments, M is for Midterm Examination and F is for Final Examination. The total marks for each student is 100%. CourseNana.COM

ii)    By using the formula available in Microsoft Excel, please find the largest and smallest marks for each of the Q, A, M and F columns. Please add new rows in the table with appropriate title for the answer. CourseNana.COM

iii)   For each of the Q, A, M and F columns please COUNT how many students with CourseNana.COM

a) 80 marks and above CourseNana.COM

b) 60 marks and below CourseNana.COM

Please add new rows in the table with appropriate title for the answer. CourseNana.COM

iv)   Calculate the following: CourseNana.COM

-       For Quiz = 20% CourseNana.COM

-       For Assignments = 30% CourseNana.COM

-       Midterm examination = 20% CourseNana.COM

-       Final examination = 30% CourseNana.COM

You should add new columns for Total Marks and Grade. Please calculate the Total Marks based on the percentages above. CourseNana.COM

v)     Please use the following table for Grades: CourseNana.COM

0-39 CourseNana.COM

E CourseNana.COM

40-43 CourseNana.COM

D CourseNana.COM

44-46 CourseNana.COM

D+ CourseNana.COM

47-49 CourseNana.COM

C- CourseNana.COM

50-54 CourseNana.COM

C CourseNana.COM

55-59 CourseNana.COM

C+ CourseNana.COM

60-64 CourseNana.COM

B- CourseNana.COM

65-69 CourseNana.COM

B CourseNana.COM

70-74 CourseNana.COM

B+ CourseNana.COM

75-79 CourseNana.COM

A- CourseNana.COM

80-100 CourseNana.COM

A CourseNana.COM

  CourseNana.COM

  CourseNana.COM

vi)   Please add new columns in the table for the status of the students. This status is based on the following grades: CourseNana.COM

Grade CourseNana.COM

Status CourseNana.COM

Status2 CourseNana.COM

D+ - E CourseNana.COM

Fail CourseNana.COM

improve CourseNana.COM

C+ - C- CourseNana.COM

Pass CourseNana.COM

improve CourseNana.COM

A- - B- CourseNana.COM

Good CourseNana.COM

improve CourseNana.COM

A CourseNana.COM

Excellent CourseNana.COM

maintain CourseNana.COM

  CourseNana.COM

  CourseNana.COM

vii)    Please create an appropriate chart or graph which shows the achievement of the students based on their grade (number of students by grade).
CourseNana.COM

viii)   The following table is a new Address table. The first row is your own details. Please fill up the Name2 column with the parent / guardian name. Please create any names for the parents/guardians: CourseNana.COM

Name2 CourseNana.COM

Address1 CourseNana.COM

Address2 CourseNana.COM

Postcode CourseNana.COM

City CourseNana.COM

State CourseNana.COM

  CourseNana.COM

  CourseNana.COM

  CourseNana.COM

  CourseNana.COM

  CourseNana.COM

  CourseNana.COM

  CourseNana.COM

No.3 CourseNana.COM

Seksyen 5 CourseNana.COM

43650 CourseNana.COM

Bangi CourseNana.COM

Selangor CourseNana.COM

  CourseNana.COM

100 CourseNana.COM

Jalan 3/2A CourseNana.COM

77000 CourseNana.COM

Jasin CourseNana.COM

Melaka CourseNana.COM

  CourseNana.COM

PL1/2 CourseNana.COM

Taman Mawar CourseNana.COM

80000 CourseNana.COM

Johor Bahru CourseNana.COM

Johor CourseNana.COM

  CourseNana.COM

Lot 1A CourseNana.COM

PengkalanHulu CourseNana.COM

26200 CourseNana.COM

Gong Badak CourseNana.COM

Terengganu CourseNana.COM

  CourseNana.COM

No.7 CourseNana.COM

JalanPelandok CourseNana.COM

86200 CourseNana.COM

SimpangRenggam CourseNana.COM

Johor CourseNana.COM

  CourseNana.COM

Lot 365 CourseNana.COM

JalanKuda CourseNana.COM

43000 CourseNana.COM

Kajang CourseNana.COM

Selangor CourseNana.COM

  CourseNana.COM

No.777 CourseNana.COM

JalanEmas CourseNana.COM

77451 CourseNana.COM

Ayer Keroh CourseNana.COM

Melaka CourseNana.COM

  CourseNana.COM

Lot 123 CourseNana.COM

JalanBahagia CourseNana.COM

32460 CourseNana.COM

Slim River CourseNana.COM

Perak CourseNana.COM

  CourseNana.COM

No.34 CourseNana.COM

Taman Permata CourseNana.COM

43600 CourseNana.COM

Bandar BaruBangi CourseNana.COM

Selangor CourseNana.COM

  CourseNana.COM

Lot 6295 CourseNana.COM

JalanPenjara CourseNana.COM

34000 CourseNana.COM

Taiping CourseNana.COM

Perak CourseNana.COM

  CourseNana.COM

No.362 CourseNana.COM

Taman Chen Siew CourseNana.COM

20000 CourseNana.COM

SeberangPerai CourseNana.COM

Pulau Pinang CourseNana.COM

  CourseNana.COM

  CourseNana.COM

  CourseNana.COM


CourseNana.COM

Part 2: Microsoft Word (50 marks) CourseNana.COM

1.     By using data from Microsoft Excel file that you created earlier, you need to create a formal letter. This letter is to inform about the performance of student to their parent / guardian. Please use the Mail Merge technique for this particular section. Please use the following template and add your own logo (you can Google the logo) with your creativity: CourseNana.COM

(LOGO) CourseNana.COM

<Name2> CourseNana.COM

<Address1> <Address2> CourseNana.COM

<Postcode> CourseNana.COM

<City><State> CourseNana.COM

  CourseNana.COM

Dear Sir/Madam, CourseNana.COM

Exam Result for Computer Applications CourseNana.COM

With reference to the above matter, this is the formal result for <Name>, <MatricNumber>. CourseNana.COM

The details are as below: CourseNana.COM

  CourseNana.COM

                        ID                    :           <MatricNumber> CourseNana.COM

                        Total Marks   :           <TotalMarks> CourseNana.COM

                        Grade             :           <Grade> CourseNana.COM

                        Status             :           <Status> CourseNana.COM

                        CourseNana.COM

We hope that <Name> could <Status2> his/her performance in the following semester. If you have any question regarding to this matter, please contact me, Dr Surya Binti Ahmad at this number, 03-32569841 or via email, surya@silk.edu.my. CourseNana.COM

Thank you for your attention. CourseNana.COM

  CourseNana.COM

Best regards, CourseNana.COM

………………. CourseNana.COM

Dr Surya Binti Ahmad CourseNana.COM

Faculty of Management CourseNana.COM

SILK University College CourseNana.COM

Get in Touch with Our Experts

WeChat (微信) WeChat (微信)
Whatsapp WhatsApp
UKM代写,EPPD1063代写,Computer Application代写,Excel代写,Word代写,UKM代编,EPPD1063代编,Computer Application代编,Excel代编,Word代编,UKM代考,EPPD1063代考,Computer Application代考,Excel代考,Word代考,UKMhelp,EPPD1063help,Computer Applicationhelp,Excelhelp,Wordhelp,UKM作业代写,EPPD1063作业代写,Computer Application作业代写,Excel作业代写,Word作业代写,UKM编程代写,EPPD1063编程代写,Computer Application编程代写,Excel编程代写,Word编程代写,UKMprogramming help,EPPD1063programming help,Computer Applicationprogramming help,Excelprogramming help,Wordprogramming help,UKMassignment help,EPPD1063assignment help,Computer Applicationassignment help,Excelassignment help,Wordassignment help,UKMsolution,EPPD1063solution,Computer Applicationsolution,Excelsolution,Wordsolution,