Muhammad Ali Jinnah University, Islamabad Campus
Computer Programming (CS1121)
Assignment 3
Instructor: Quratulain Siddiqui
Submission Date: 5th March 2012
Note: Use only one excel workbook and separate Work Sheet for each part of
assignment. Use built-in functions & formulas where required.
PART 1
Zubair is a 5th Grade student, and is studying in the leading school of his city. He is
usually considered an average student among his class fellows but has a strong will
that one day he’ll be in the outstanding student’s lists of his school and has been
working very hard to achieve it. This year his performance has been much better
then rest of his class fellows. But not sure of what grade he will get after his
Annual Examination Result. He is studying following courses.
You being class teacher have to maintain the class records of all the subjects your
class students are studying and assign them grades after calculating the overall sum
of marks obtained in all the subjects and percentage out of hundred. The Record is
maintained in Alphabetical order and marks are added row first order.
The format for grade sheet is as follows:
Sr. no. Reg.# Name English Mathematics Social
Studies Pakistan
Studies Urdu Islamic
Studies Computer
1 54 Zubair 92 90 89 87 85 87 89
Courses
English
Mathematics
Social Studies
Pakistan Studies
Urdu
Islamic Studies
Computer
docsity.com
