Virtual University of Pakistan commemorated 9th convocation for its students from Sindh at Regent Plaza Hotel, Main Shahra-e-Faisal Karachi on February 28, 2018.
As many as 437 students were conferred degrees for the successful completion of various degree programs. Furthermore, 8 Gold Medals and 15 Merit Certificates were also awarded to outstanding graduates. An audience included proud parents, members of faculty, eminent personalities from academia, corporate and public sector attended the event.
In his welcome address, Dr. Naveed A. Malik, Rector Virtual University of Pakistan, congratulated students, their parents, and wished them a prosperous future. He admired the students honored with gold medals and merit certificates for their dedication and outstanding achievements in their academic career.
Dr. Naveed A. Malik highlighted the achievements of Virtual University, its leading role in delivering information and communication technology based education and contribution in the provision of quality education even to the remotest areas of the country.
Former Chairman of the Higher Education Commission (HEC) Prof. Dr. Atta-ur-Rehman, was the Chief Guest at the Convocation. The chief guest emphasized the importance of higher education and the significance of research and development for the progress of the country. He said that Virtual University has a distinctly reputed place in the list of top national universities. He advised the students to contribute towards scientific and technological development of the country through their ability, dignity, determination and commitment.
Prof. Dr. Atta-ur-Rehman, along with Dr. Naveed A. Malik distributed awards to the high achievers to celebrate dedication in their respective disciplines.
CS507 - Information Systems Assignment No. 2 Solution and Discussion Spring 2017 Due Date: May 27, 2017
Semester Spring 2017
Total Marks: 20
Please read the following instructions carefully before solving & submitting assignment:
For any query about the assignment, contact only at CS507@vu.edu.pk
Do not post queries related to assignment on MDB.
By using What-If Analysis tool in Excel, you can use several different sets of values in
one or more formulas to explore all the various results. What-If Analysis allows you to try out different values (scenarios) for formulas.
A Scenario is a set of values that Excel saves and can substitute automatically on your worksheet. You can create and save different groups of values as scenarios and then switch between these scenarios to view different results.
Scenarios are managed with the Scenario Manager wizard from the What-If Analysis group on the Data tab.
Suppose you own a Computer store and have 200 computers in storage. You sell a certain % for the highest price of 1000Rs and a certain % for the lower price of 500Rs. If you sell 60% for the highest price, cell E11 calculates a total profit of 60 * 1000 + 40 * 500 = 160000.
What if you sell 70% for the highest price? And what if you sell 80% for the highest price? Or even 90%? Each different percentage is a different scenario.
Q No 1:
You are required to add 4 scenarios 60%, 70%, 80% and 90% by using Scenario Manager. After adding scenarios, take screenshot of the scenario manager and paste it here. (Marks = 10)
Q No 2:
Take screenshot of scenario summary showing all the scenarios that you have added to the scenario manager and paste it here. (Marks = 10)