Khairy Writer: new vitae for today.....:)

You're Welcome

Followers

19 July, 2011

new vitae for today.....:)

Lab 3 – Microsoft Excel
1. Download the excel file from Morpheus titled “RawData.xlsx”. By using macro tool in the developer ribbon, transform the table in to the format as shown below.
No
Name
Matrix No
Favourite Color
Favourite Food
English Mark
English Grade
1
Ahmad
A000001
Black
Nasi Lemak
79
?
2. By using the SORT function, sort the list according to the increment in Matrix No.
3. Following the Pra-University grading system, fill in the English Grade column with the correct grade using the VLOOKUP function.
4. Count how many students acquire each grade using the COUNTIF function.
5. Plot a column graph for number of students versus grade.
6. What is the difference between raw data and useful information? Relate this with what you just did in your lab session. Make a conclusion for the assessment system of the English subject based on the useful information that you have made.
Answers should be compiled in a report and to be delivered at the beginning of your next lecture class. Report is expected to be 2 pages long, font: Times New Roman, size: 12, 1 or 2 spacing.

No comments:

Post a Comment

Leave your comment :)

Blogger Widgets