CS001 Computer Proficiency Assignment 4 Solution Fall 2013

Suppose you are working as an internee in examination department of Virtual University of Pakistan. Your supervisor gives you graded papers of five subjects of a class and asks you to compile this data and prepare result for the class using MS Excel.  You are required to

  • Arrange data in spreadsheet in rows and columns showing student name and each subject’s marks.
  • Calculate Sum of each student marks using Sum formula (Do not use AutoSum ∑).
  • Calculate Average of each student marks using Average formula.
  • Develop a bar chart showing total marks and average of each student.

Your compiled and prepared Result should look like the following image.

Solution: Download Complete Solution Here