Scribd
Upload
53 views3 pages

Instructions:: Course: Quantitative Techniques & Analytics Course Code: 21VMB0C105 Assignment: 2 Subjective Section

The document provides instructions for a quantitative techniques assignment involving 4 questions. Question 1 involves calculating the critical path of a project network. Question 2 involves calculating project duration, critical path, and float from a network diagram. Question 3 involves merging tables and calculating highest marks using VLOOKUP and conditional formatting. Question 4 involves creating a pivot table to analyze sales data.

Uploaded by

khushi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
53 views3 pages

Instructions:: Course: Quantitative Techniques & Analytics Course Code: 21VMB0C105 Assignment: 2 Subjective Section

The document provides instructions for a quantitative techniques assignment involving 4 questions. Question 1 involves calculating the critical path of a project network. Question 2 involves calculating project duration, critical path, and float from a network diagram. Question 3 involves merging tables and calculating highest marks using VLOOKUP and conditional formatting. Question 4 involves creating a pivot table to analyze sales data.

Uploaded by

khushi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

Course: Quantitative Techniques & Analytics Course Code: 21VMB0C105

Assignment: 2

Subjective Section
Instructions:
● This section is of 20 marks
● Question is allotted based on the following units
1. Unit 6: Project Scheduling: PERT/CPM
2. Unit 7: Fundamentals of Information Systems
3. Unit 8: MS Excel
4. Unit 9: MS Word
5. Unit 10: MS PowerPoint

● Submission of the assignment


o Format: PDF with proper question numbers and subsections
o Use Excel Solver to solve the questions
o Add screenshot of the solution for each question in the PDF or Print
the Excel Worksheet (Make sure all the sheets are covered)
o Make sure that the quality of the screenshots is good. Do not stretch
or resize the images too much as it leads to the resolution being
compromised.
o Add written explanations wherever required in the document/Excel
o Handwritten solutions will not be accepted

Powered by Great Learning. Proprietary content. ©Great Learning. All Rights Reserved.
Unauthorized use or distribution prohibited.
All the questions are mandatory

Question 1
Following data refers to the activities of a project, where, node 1 refers to the start and node 5 refers to
the end of the project:

Activity Duration (days)


1-2 2
2-3 1
4-3 3
1-4 3
2-5 3
3-5 2
4-5 4

What is the critical path of the network? (5 marks)

Question 2
Based on the network diagram, answer the following questions (5 marks)

A B C D E F G H I J K L
20 18 18 11 19 15 17 15 21 19 10 10

2.1 What is the estimated duration of the project? – 1 mark


2.2 What is the critical path of the project? – 1 mark
2.3 What is the total float for activity F? – 1 mark
2.4 What is the total float for activity G? – 1 mark
2.5 What is the total float for activity E? – 1 mark

Powered by Great Learning. Proprietary content. ©Great Learning. All Rights Reserved.
Unauthorized use or distribution prohibited.
Question 3
There are two tables provided in the Excel workbook named “QTA-Assignment2-July” – worksheet
Question 3

3.1 Merge the data of Table 2 and Table 1 using the VLOOKUP formula by adding the additional columns
Gender and Work Experience. Hint: Student name is the common key. – 2 marks
3.2 Calculate the total marks awarded to each of the individuals. Which female student scored the
highest mark from the lot? – 1 mark
3.3 Using conditional formatting, highlight the students who scored less than 50% overall (calculated
from the total marks of individuals) – 2 marks

Hint: Percentage = Total mark of individual * 100 / Total marks. Total marks = 150 overall.

Question 4
There is a table provided in the Excel workbook named “QTA-Assignment2-July” – worksheet Question 4

Create a Pivot table report with the data and answer the following questions:
4.1 Which region made the maximum profits? – 2 marks
4.2 Which item was sold more frequently than the rest? – 2 marks
4.3 What is the maximum actual price of the item that was sold more frequently than the rest? – 1 mark

Powered by Great Learning. Proprietary content. ©Great Learning. All Rights Reserved.
Unauthorized use or distribution prohibited.

You might also like