Sample Quality Management Plan

This reference documents project-specific quality assurance and quality control procedures appropriate to the size, complexity, and nature of the project. Quality improvements are also documented and may be included as an integral part of the Project Management Plan (PMP). Plans are developed concurrently in the iterative Program/Project Planning Phase.
In addition to quality management objectives developed as part of PMPs for projects, the system for Quality Management is defined in an organizational level Quality Management Plan (QMP). Project-specific Quality Management objectives accompanying each PMP shall be consistent with the organization QMP unless documented.
Quality is planned for and managed through the “Plan-Do-Check-Act” cycle for project execution, program management, and business processes.
The Project Manager (PM) is responsible for Documenting customer expectations and consensus quality management objectives at a project-level that supports the implementation of the PMP. Utilizing the expertise of their project delivery teams to determine the procedures necessary (such as independent technical review) to achieve the target level of quality. Ensuring the customer endorses all quality objectives included in the Quality Management Plan. Understanding the customer’s role in project success; the PM’s relationship with the customer is pivotal to providing quality service Working with the customer early in the Project Scope and Customer Requirements Definition Process to determine customer needs, and refining those requirements in light of safety, fiscal, schedule, and other constraints; considers the cost/benefit of all quality improvements.
The Project Delivery Team (PDT) is responsible for Delivering a quality project Performing an active role to ensure the customer’s quality objectives are clearly articulated and that the customer understands the essential
Sample Quality Management Plan
professional standards, laws, and codes which must be incorporated
into the project
Monitoring the quality of their own work
Keeping the commitments for completion of their portion of the
project, as documented in the Quality Management Plan
The Resource Provider(s) is responsible for
Monitoring the quality of the products and services produced by their
team members serving on PDTs or the contractors they use to
supplement their in-house capability
Teaching, coaching, mentoring and training staff so that they have
technically competent staff to assign to PDT’s
Participating in selection of outside consultants and service/goods
providers to ensure they are qualified to perform assigned work
Assigning team members to project teams commensurate with their
ability and experience
Consulting with PDT members on a periodic basis to get feedback and
make adjustments as necessary
Ensuring that there are processes in place and qualified staff or
contractors are available to guarantee that an independent technical
review is conducted
Serving on an independent technical review team, when appropriate.
Distribution of Information and Data – Communications to all project
Stakeholders
Project Delivery Team (PDT)
Project Manager (PM)
Resource Provider(s)
Ownership
Sample Quality Management Plan
Quality Management Relationships
Quality Planning Quality Control
(QC)
Quality
Assurance (QA)
Quality
Improvement
Plan Do Check Act
What Is
Done
Determine what will be
quality on the project
and how quality will be
measured
Monitor specific
project
products to
determine if
they meet
performance
measurement
thresholds
defined in the
quality
management
plan
Determine if
measurement of
quality is
appropriate by
evaluating
overall
performance on
a regular basis to
insure the
project will
satisfy customer
quality
expectations
Increase the
effectiveness and
efficiency of the
project when
corrective actions
such as Change
Requests are
identified.
Changes to the
Quality
Management Plan
and the PMP may
be required.
When It Is
Done
Project Planning Phase
Processes
PMP
Development
Project Scope &
Customer
Requirements
Definition
Team
Establishment
Activity/Schedule
Development
Resource
Estimate
Development
Project Delivery
Acquisition
Strategy
Project
Execution, &
Control Phase
Processes
Project
Execution &
Control
Lessons
Learned
Project
Execution, &
Control Phase
Processes
Project
Execution &
Control
Project Execution,
& Control Phase
and Project
Planning Phase
Processes
Change
Management
PMP
Development
Sample Quality Management Plan
Quality Management Plan Content
Overview of Quality Management Plan
Purpose
Overview of Plan, Do, Check, Act
Customer Quality Objectives
Identify Customer Quality Objectives
Identify Quality Threshold for each Quality Objective
Quality Control Plans
Address each major deliverable
Identify Independent Technical Review Team(s)
Quality Assurance
Organizational Quality System Requirements (Organizational Quality
Management Plan)
Project-specific requirements
Other Project Specific Information as required
Quality Management Plan Methodology
Plan
Identify the customers Quality Objectives. Help customers express
quality expectations in objective, quantitative terms.
Identify professional standards including legal, environmental,
economic, code, life safety and health.
Balance needs and expectations of customers and stakeholders with
cost, schedule, and professional standards. Evaluate the costs and
Sample Quality Management Plan
benefits of selected quality objectives and the processes to be used to
achieve objectives.
Develop an effective plan and processes, including quality assurance
and quality control procedures, to achieve objectives. Consider
risk/hazard factors and complexity of the project and adapt processes
to provide the requisite level of quality. Document in the risk
management plan any project variations from the local QMP
requirements.
Develop performance measure thresholds to ensure agreement on the
definition of success relative to Quality Objectives.
Ensure customer endorsement of all quality objectives included in the
Quality Management Plan.
Do
Do the work according to the approved PMP and standard operating
procedures.
Project execution is a dynamic process. The PDT must communicate,
meet on a regular basis, and adapt to changing conditions. The
Quality Management Plan and PMP may require modification to ensure
that project objectives are met.
Document in Lessons Learned – PROC3020, as required.
Check
Perform independent technical review, management oversight, and
verification to ensure that quality objectives are met consistent with
District Quality Management Plans.
Check performance against the PMP and Customer Quality Objectives
performance measures thresholds to verify that performance will
accomplish Quality Objectives and to verify sufficiency of the plan.
Share findings with all project stakeholders to facilitate continuous
improvement.
Sample Quality Management Plan
Act
If performance measures thresholds are exceeded, take specific
corrective actions to fix the systemic cause of any non-conformance,
deficiency, or other unwanted effect.
Document quality improvements that could include appropriate
revisions to the quality management plan, alteration of quality
assurance and control procedures, and adjustments to resource
allocations.

BUMKT5902 Marketing Management

Assessment Criteria Sheets
BUMKT5902 Marketing Management
Assessment 2 – Marketing Strategy
Part A Report and Part B Presentation
This document contains the details for Assessment 2 for BUMKT5902 Marketing Management. Included are
aspects such as:



The assignment overview and report structure;
How the assessment is to be formatted; and
How it will be assessed by using an Assessment Criteria Sheet.

You should read this in conjunction with the Course Description, which contains other pertinent information
on submission, etc. It is your responsibility to fully acquaint yourself with these requirements. If you are not
clear on any aspect, please speak with your lecturer who will be happy to clarify any questions.
Overview of the Assignment
You are required to demonstrate your understanding of marketing theory as it relates to a real world setting.
For assessment 2, Part A and B, you are required to prepare a marketing strategy for a business you are
familiar with, or a business you work for, or an entrepreneurial ‘side hustle’ you might have started.
 Part A – Report
To complete Part A – you need to carry out background research, compile a situational analysis and use
this information to help you identify a new product line that the company will launch. The new product
should be aligned with the company image and existing offerings. The remainder of the assignment is
designed to explain how the new product is going to be sold.
Using marketing theory, academic research and industry research among others, you will identify how the
market will be segmented, and how the product will be both targeted and positioned to the target market.
Following this, the product will be explained in the context of the 4 Ps (product, price place, and promotion)
also using marketing theory and research to justify the suggestions being made.
Report length:
If you decide to complete this assessment individually, your word count is 1200 words maximum. For an
assessment of this length, we would expect to see a minimum of 8 academic references used.
If you decided to complete this assessment in a group of 2-3 people, your word count is 3,000 words
maximum. For an assignment of this size, we would expect to see a minimum of 20 academic references
used.
It is important to remember that this assessment requires you to demonstrate your understanding of
marketing theory as it relates to a real world setting. This means you will perform better in the assignment if
you are able to integrate marketing theory into your anlaysis and use academic theory to justify your
proposals, strategies and recommendations.
Deleted: Group
Deleted: In your group, y
Deleted: r group is
Deleted: one of
Deleted: one of
Deleted: as a group,
Deleted: the students
Deleted: Your group report will be
Report Structure
Use the following structure to organise your report:
Title page
Executive Summary
Table of Contents
1.0 Introduction
2.0 Company Introduction and Brief Industry Overview
3.0 Environmental marketing analysis
4.0 SWOT Summary
5.0 Overview of proposed product
6.0 Segmentation, Targeting & Positioning
6.1 Segmentation
6.2 Targeting
6.3 Positioning
7.0 Recommended Marketing Mix
7.1 Product
7.2 Price
7.3 Place
7.4 Promotion
8.0 Conclusion
References
Appendices (if applicable)
General Formatting Requirements for the Report
For those students who are unfamiliar or do not feel confident with academic writing, there are many sources
on the Federation University and Library websites. The formatting of assignments should adhere to the
following requirements:

Report format
Follow the headings outlined under the Assignment Instructions section
Use a report Title page containing all of the relevant information
The Executive Summary is placed before the Table of Contents and does not contribute to the word
count
Correct page numbering (e.g., the Cover Page is not numbered, the number format for the Executive
Summary and the Table of Contents is i, ii, etc. The body of the report starting with the Introduction is
numbered 1, 2, 3, etc.)
Do not write in the first or second person (I, we, our)—write in the third person only
Proof-read before submission for spelling, grammatical and logic errors
Fonts should be plain and easy to read (e.g., Tahoma, Arial, Times New Roman)
Font size is typically between 10 and 12 for the body of the assignment
Paragraphs are to be fully justified

BSB61015 – Advanced Diploma of Leadership and Management

Student Name and ID: Mauricio Sepulveda – AIBL180419
Course Code and title: BSB61015 – Advanced Diploma of Leadership and Management
Unit Code and title: BSBINN60 – Lead and Manage Organisational Change
Trainer and assessor name: Erdem Celik
Page numbers: (to be inserted at the bottom of each page – Microsoft Word can generate
this automatically, you just need to select “Insert” then “Page Number” from the ribbon at
the top).
________________________________________________________________________________
Question 1: Copy and Paste the question here
Write your answer here
– Do the same for all the other questions

Project Management (COMP 1009)

Project Management (COMP 1009)-SPRING-2020-CW1(Assignment1)-All-QP
MEC_AMO_TEM_034_01 Page 1 of 9
Instructions to Student



Answer all questions.
Deadline of submission: 10/06/2020 23:59
The marks received on the assignment will be scaled down to the actual weightage
of the assignment which is 50 marks
Formative feedback on the complete assignment draft will be provided if the draft is
submitted at least 10 days before the final submission date.
Feedback after final evaluation will be provided by 24/06/2020

Module Learning Outcomes
The following LOs are achieved once you complete this assignment
1) Adapt to a developing business environment and be able to manage and implement change towards
strategic objectives while critically evaluating the quality of their contribution
2) Assess key aspects of a given computer-related project within the scope of the indicative content
Assignment Objective
You are encouraged to see the role of a project manager within the broader perspective of
strategic business management, understanding where projects come from and why they are
selected.
Assignment Task
Read the following tasks, understand and present your response in a document not more than
12 to 14 pages.
Assume that you are a project manager in Muscat Information Systems LLC which is located in
KOM. Muscat Information Systems LLC undertakes projects based on specific client
requirements. These projects typically include development of:
 Transaction Processing Systems
 Business Intelligence Systems
 Management information Systems
 HR Systems
 Hospital Management Systems
 Banking Information Systems

Inventory Management Systems
Payroll Systems
CRM Systems
Knowledge Management Systems
Logistic Management software

`
IN SEMESTER INDIVIDUAL ASSIGNMENT
Module Code: COMP 1009 Module Name: Project Management
Level: 6 Max. Marks: 100
Project Management (COMP 1009)-SPRING-2020-CW1(Assignment1)-All-QP
MEC_AMO_TEM_034_01 Page 2 of 9
Choose any one of the above or any other systems development project or a research based
project of your liking (if you are choosing any other system/project, prior approval from your
faculty need to be taken) which you would like to head and complete the tasks given:

Task 1 (10 marks)
Submit a work proposal for this assignment or before 06/05/2020, 23:59 which must include:


Understanding of deliverables – a detail description of deliverables.
General overview of proposed plan – initial understanding of solution to task2.
Timeline for completion of the given tasks.

The work proposal must be submitted in a word file through the link available in Moodle.

Task 2. :
Write the scope statement for the selected project.
(50 marks)

You can read a research paper “Significance of Scope in Project Success” by Muhammad Nabeel
Mirza, available at https://www.sciencedirect.com/science/article/pii/S221201731300234X, and
an article “Improve Project Success with Better Scope Management” by Avneet Mathur,
available at https://www.projectsmart.co.uk/pdf/improve-project-success-with-better-scopemanagement.pdf, which highlights the key aspects needed to consider while capturing the scope
of the project.
Note: It is very important that you consider and completely mention the factors needed to write
scope statement. The above links can help you to identify the factors needed to write the scope
statement. Marks will be awarded for writing in detail factors needed for writing the scope
statement, minimum four factors expected [10 x 4 = 40marks]. Scope statement by itself have 10
marks.
Task 3: (40 marks)
For the project selected in task 2 conduct a feasibility study – Technical, Operational and
Economical feasibility studies, to access whether this project can be taken up or not.
Project Management (COMP 1009)-SPRING-2020-CW1(Assignment1)-All-QP
MEC_AMO_TEM_034_01 Page 3 of 9
Rules & Regulations:


All resources should be cited using CU Harvard style.
The final assignment must have a Title page, Table of Contents, References/ bibliography using
CU Harvard Style and page numbers.
Title Page must have Assignment Name, Module name, Session, your name, ID, and the name of
the faculty.
Softcopy in word format is to be submitted through Turnitin link on Moodle.
Viva will be conducted after the assignment submission as per the dates informed earlier. If
needed VIVA will be conducted using MS TEAMS

Guidelines:

Assignment must be computer typed.




Font – Times New Roman
Font – Style – Regular
Font – Size – 12
Heading should be with Font Size 14, Bold, Capital and Underline.
Avoid Wikis’ as references.
Explain with suitable diagrams wherever required. Diagrams must be drawn using suitable
software or by pencil.
Each student has to do the assignment individually
You can refer books in eLibrary or use internet resource. But you should not cut and paste material
from internet nor provide photocopied material from books. The assignment answers should be
in your own words after understanding the matter from the above resources.

Important Policies to be followed
1. Student Academic Integrity Policy*:
MEC upholds the spirit of academic integrity in all forms of academic work and any form of violation
of academic integrity shall invite severe penalty. Any benefit obtained by indulging in the act of
violation of academic integrity shall be cancelled.
All cases of violation of academic integrity on the part of the student shall fall under any of the below
mentioned categories:
1. Plagiarism
2. Malpractice
3. Ghost Writing
4. Collusion
5. Other cases
Project Management (COMP 1009)-SPRING-2020-CW1(Assignment1)-All-QP
MEC_AMO_TEM_034_01 Page 4 of 9
If the student fails a module and has a proven case of academic integrity violation in this module, the
student is required to re-register the module. This is applicable to first and second offenders of
plagiarism.
1. Plagiarism
A. First offence of plagiarism
I. If a student is caught first time in an act of plagiarism during his/her course of study in
any assignment other than project work, the student will be allowed to re-submit the
assignment once, within a maximum period of one week. However, a penalty of
deduction of 25% of the marks obtained for the resubmitted work will be imposed.

Researchers in Construction Management

Lowe, J G (2010) Edinburgh trams: a case study of a complex project. In: Egbu, C. (Ed) Procs 26th
Annual ARCOM Conference, 6-8 September 2010, Leeds, UK, Association of Researchers in
Construction Management, 1289-1298.
EDINBURGH TRAMS: A CASE STUDY OF A COMPLEX
PROJECT
John G Lowe1
Department of Construction Management and Economics, Glasgow Caledonian University,
Cowcaddens Road, Glasgow, G3 6BU, UK
The Edinburgh Tram project has proved to be politically contentious, complex, and
problematical since preparatory work on services diversion commenced in 2007. The
proposed network has been reduced to a single 18.5 km line linking Newhaven to
Edinburgh Airport via Leith, Princes Street, Haymarket, Edinburgh Park and the
Gyle. The main contract was let on a fixed price design and build basis to a
consortium of Bilfinger Berger (civil engineering) works, Siemens (electrical) and
CAF (tramcars). Work commenced in summer 2008. An earlier contract for the
preparatory works and services diversions was carried out by Carillion. It appears
likely that the project will not be completed before 2012 rather than the original target
of 2011 and the budget cost of £545 million as included in the final business case
appears likely to be exceeded. The early stages of the project’s life have been blighted
by political disputes between the Scottish National Party on one side, who have
opposed the project and the other political parties including Labour, Liberal
Democrats, Conservatives and Green Party on the other who have generally backed
the scheme. The SNP currently form a minority administration in the Scottish
Government at Holyrood and are part of the ruling coalition with the Liberal
Democrats on City of Edinburgh Council who are the sponsors of the project. Since
the opposition parties at Holyrood forced the finance for the project through there
have been a number of high profile contractual disputes between the arms’ length
project company, Transport Initiatives Edinburgh and Bilfinger Berger. The
resolution of these disputes has caused several delays to key operations for the
project. This paper will analyse implications of the political disputes and way that the
project was let on the progress and cost of the project.
Keywords: project management, political issues, dispute resolution, game theory.
INTRODUCTION
This paper is intended to illustrate the difficulties involved in project management on
a highly politicised project. The network can be broken down into two distinct stages.
The first is a largely on-road line starting at Newhaven in the north of the City and
continuing via Ocean Terminal, Constitution Street and Leith Walk to St Andrews
Square. It then proceeds along Princes Street and Shandwick Place to Haymarket. The
second section is largely off-road and commences at Haymarket following the main
line alignment to Edinburgh Park before going through to the Gyle Shopping Centre,
under the A8 and across country to the airport.
The two sections present very different challenges. The on-road sector poses no real
technical problems apart from the need to divert services from directly under the tram
1 j.lowe@gcal.ac.uk
Lowe
1290
line or to provide side access manholes for services which cannot be diverted. The real
issue is that of traffic management during the works and the disruption to local
residents and businesses. In the case of the off-road section of the works the disruption
faced is less of a problem. The challenge here is the construction of retaining walls,
bridges, viaducts and a tunnel often with poor ground conditions. Working alongside
a main line and constructing two bridges over the main Glasgow-Edinburgh main line
involves dealing with Network Rail. They can impose restrictions on the hours
worked. Some work may only be carried out overnight at weekends. It is fair to say
that the on-road section faces logistical and political issues while the off-road section
will have to deal with technical problems. The project has been bedevilled by
contractual disputes between the Project Manager (TIE) and the main infrastructure
contractor (BBS). This has led to the most of the working on the on-road sections
being suspended because of the refusal of BBS to start work until unspecified issues
were resolved. This led to the Client considering whether to remove the BBS from the
project.
THE PROJECT
Background
Trams have been considered as the solution to Edinburgh’s traffic problems since the
1980s. Edinburgh lost virtually all its suburban rail system in the 1960s. Only the line
to North Berwick and the reinstated service to Bathgate remain. Edinburgh overcame
this as car ownership was amongst the lowest in the UK and bus usage was very high.
However over the last twenty years, car ownership has steadily increased towards the
national average leading to increased traffic congestion. In a number of roads, such as
Princes Street and also Leith Walk much of the congestion is created by large volume
of well patronized bus traffic. The only substantial area of land available for housing
to meet demands from the rapidly expanding City population was on the Leith
waterfront. Building on the scale expected would put great strains on the bus service
and increase the congestion along Leith Walk and Princes Street. Obviously things
would be much worse if the newcomers opted for car travel. A full metro system was
always going to be ruled out on the grounds of cost so trams emerged as the only
viable solution. A consensus emerged on the City of Edinburgh Council (CEC) in
favour of a tram network supported by all the parties represented. Labour were the
majority party but the scheme was also supported by the Conservatives and Liberal
Democrats. The CEC allocated the management of the project to their ‘arms-length’
company Transport Initiatives Edinburgh (TIE).
The parliamentary bill
In order to progress the proposed tramway a Parliamentary Bill was required. This
gained the approval of the ruling Labour and Liberal Democrat coalition as well as the
opposition parties. Contrary to the popular misconception the project was initially
backed by the Scottish National Party (SNP) with their then Transport spokesman
Kenny MacAskill being particularly vociferous in support between 2000 and 2002.
The Scottish Executive announced the approval of funding in 2002. The project had
the support of all parties on CEC and most of the Scottish Parliament plus also the
local Chamber of Commerce and the business sector. This consensus was broken by
the SNP. According to the respected SNP member of the Scottish Parliament,
Christopher Harvie, this about-turn was engineered by Kenny MacAskill who was
standing for election in for Edinburgh East constituency in the upcoming 2007
election. Edinburgh East was the only seat not included in the proposed tram network.
The SNP were not a force on CEC until 2005 when a Labour councillor and Deputy
Edinburgh trams
1291
Provost Steve Cardownie defected to the SNP forming initially a group of one. The
Parliamentary approval was two lines. One was a loop linking the City Centre and the
Leith waterfront while the second linked this to the airport with a branch to the
Newbridge industrial estate. The first phase (1A) was prioritized. This involved a line
from Newhaven to the airport. The remainder of the loop was labelled Phase 1B and
Phase 2 while the Newbridge branch was to become Phase 3.
The network funded
The Final Business Case was under preparation while the Scottish Executive voted
funds to commence design of the network plus preparatory and investigative works.
Before the final approval could be given the 2007 Scottish Parliamentary elections
took place. This gave the SNP a one seat advantage over Labour although well short
of an overall majority. The SNP signed a concordat with the two Green Party MSPs.
This effectively precluded any coalition not involving the SNP other than the
implausible Labour-Liberal Democrat-Conservative grand coalition. The outcome
was a minority SNP administration with critical support from the Greens. Meanwhile
a new Council was elected in Edinburgh. The new proportional representation system
dramatically reduced the Labour representation and contributed to a big increase in
SNP numbers. The Liberal Democrats became the largest party and the Greens gained
representation. A Liberal Democrat-SNP coalition took control. The start of the
project was delayed with some service diversion work put on hold by the incoming
minority SNP Administration at Holyrood while they commissioned a report by Audit
Scotland (2007). This gave the project a clean bill of health. The new First Minister
Alex Salmond wanted to scrap the project. However a resolution backing the project
was passed with the support of all opposition parties including the Greens and the
former SNP Edinburgh Independent Margo MacDonald. After some delay, the SNP
leadership agreed to give £500 million funding to the project, possibly with the threat
of a motion of no confidence if the will of Parliament was frustrated. It was also
necessary for the SNP to keep their Green allies on side. CEC pledged to contribute
£45 million to the project. This was intended to be raised in part by charging for
planning applications on or near to the proposed tramline.
Political issues

Stakeholder Management Process

Stakeholder management is a renewed area of focus for project managers; yet, many project teams fall short in this critical area.
This paper will focus on how to set and manage expectations (SAME) of the stakeholders through a structured step-by-step
approach. You will be presented with tools and techniques designed to walk you through the processes of stakeholder identification,
stakeholder classification, and stakeholder management strategy development. The output of these processes will lead directly to
the development of an effective communication management plan, our plan to keep project stakeholders informed regarding project
status, progress, and forecasts.
Introduction
Successful projects depend upon a variety of people, and it is the wise project manager who actively determines who they are and
what areas of the project they influence. A forgotten stakeholder often rears his or her head at the most inopportune time, wreaking
all sorts of havoc in the project. But many project teams do a poor job of identifying project stakeholders and gaining their
commitment to the project objectives. In a survey conducted by Moorhouse Consulting (2012), it was determined that “Half (50%) of
respondents are leading business critical projects and yet only a third (36%) feel that they have got stakeholders and key staff
‘bought in’ very well to the projects aims and benefits of the change; this is despite the fact that ‘lack of ownership’ from stakeholders
is seen as the most important threat to a successful outcome” (p. 1). It is critical then, that the project team does a good job of
stakeholder analysis, so they can create the stakeholder management strategy, which in turn, forms the foundation for the project’s
communication management plan.
A Guide to the Project Management Body of Knowledge (PMBOK Guide) outlines the “what’s” and “why’s” of project management,
and even does a good job listing some effective tools and techniques for performing some project tasks. But it leaves the “soft skill”
parts to the individual project manager and team. How do they do this demanding job? This paper will introduce some thoughts on
the topic of stakeholder management and provide process flow and tools for doing a stakeholder analysis and creating the strategy
to manage the expectations of the stakeholders.
People – Process – Technology Balance
It has always been my contention that things work when there is a balance between an organization’s processes, the technology it
uses to support these processes, and the people who execute the processes. Where there are welldefined processes in place, tools
and technology that support these processes, and people who have been trained in the process and the technology, things seem to
work. Many organizations have experienced some improvements in project results simply by establishing standard processes and
tool usage. But the people side is often the most overlooked one, and of course, stakeholders are people (Exhibit 1).
Exhibit 1: People-Process-Technology Balance.
Problems can occur when we don’t take care of the people side. Problems often happen when one or more of the sides are out of
balance. For example, we may have poorly defined processes, processes that produce errors, or undesirable outcomes. Rather than
fix the broken process, we often invest in a new technology or toolset, one that ends up producing the errors faster! Another
illustration of this concept would be when we have established processes, but the tool doesn’t support the process, so the people
become the glue between the technology and the process. And, finally, improved processes and technology will not fix people
problems! People problems require people solutions and that leads directly to stakeholder management.
Definitions of Stakeholder
There are various definitions for a stakeholder:
®
Register Log In  
One that has a stake in an enterprise.
One who is involved in or affected by a course of action.
Merriam-Webster Online Dictionary (Stakeholder, n.d.)
Someone with an interest in the outcome of a project, either because they have funded it, will use it, or will be affected by it.
The Scrum Primer (Deemer, Benefield, Larman, & Vodde, 2010)
A group or person who has interests that may be affected by an initiative or have influence over it.
A Guide to the Business Analysis Body of Knowledge (BABOK Guide) (International Institute of Business Analysis, 2009, p. 232)
These definitions are drawn from the general business environment and generally refer to what most people agree upon—a
stakeholder is an individual or entity that can affect, or is affected by some outcome. What about the project management
community? Here are a few from this group:
Project Stakeholders
Any individual, group or organization that can affect, be affected by, or perceive itself to be affected by, an initiative (programme,
project, activity, risk)
PRINCE2 2009 Glossary of Terms (Office of Government Commerce, 2009, p.313)
The interesting perspective added here is that if someone or group believes themselves to be a stakeholder, then they are, in fact, a
stakeholder! The PMBOK Guide seems to agree:
Stakeholders are persons or organizations (e.g., customers, sponsors, the performing organization, or the public) who are actively
involved in the project or whose interests may be positively or negatively affected by the performance or completion of the project.
Stakeholders may also exert influence over the project, its deliverables, and the project team members.
PMBOK Guide—Fourth Edition (Project Management Institute, 2008, p. 23)
Without a doubt, the most detailed definition belongs to the PMBOK Guide, but the message is clear—stakeholders hold a lot of
influence within a project and managing their expectations is a very important job.
Definitions of Expectation
Given these ways of looking at stakeholders, what would best describe an expectation?
the act or state of expecting : anticipation
something expected
the state of being expected
Merriam-Webster Online Dictionary (Expectation, n.d.)
Definitions for expect complete this discussion:
Definition of Expect
to consider probable or certain
to consider reasonable, due, or necessary
to consider bound in duty or obligated
Merriam-Webster Online Dictionary (Expect, n.d.)
The last one listed looks more intense than the others, but it gives insight into a very important idea about one’s expectations for
anything.
Expectations ARE Requirements!
When looking at how to set and manage stakeholder expectations, we have to realize that from the perspective of the stakeholder
involved, what they are expecting as a project outcome, they consider a project requirement. Even the PMBOK Guide suggests this
idea:
Requirements include the quantified and documented needs and expectations of the sponsor customer and other stakeholders.
Collecting requirements is defining and managing customer expectations.
PMBOK Guide—Fourth Edition (Project Management Institute, 2008a, p. 105)
The thing to remember about requirements is that any project contains two types of requirements: product requirements (things that
define the features and function of the project’s end product) and process requirements (how we’ll keep stakeholders informed about
project progress, any problems, or constraints, etc.). And although the project may have succeeded on the product side, (that is, it
delivered what was promised), many fail on the process side by not keeping stakeholders informed about what was going on within

Implementing the Performance Management System

To be successful in providing feedback, particular skills and knowledge are required. So is competency at exercising those skills! Good feedback is both enlightening and satisfying to the giver and recipient. It is not criticism, it is open discussion about behaviour.
Providing constructive feedback is challenging – often because of the anticipated or real reception of the recipient. It becomes even more difficult when the behaviour in question was illegal or very sub-standard work. It is at these times that it is crucial to remain:
Business College at International House
RTO Code: 91109 CRICOS 02623G
Level 1, 203 Clarence St, Sydney NSW 2000 | Floor 1, 237 Oxford St, Bondi Junction NSW 2022
3 Searcy St, Darwin NT 0800 | Level 6, 601 Bourke St, Melbourne VIC 3000
info@ihBC.edu.au| www.ihBC.edu.au
• Empathetic and understanding their point of view even if you are angry
• Considerate even though you must reprimand
• Positive about the potential and development of the recipient.
All team leaders and managers who are going to be giving and receiving performance feedback need to be competent for the task. If they are not yet competent, then they need training. There are many different means of training individuals to the required standard:
• Interactive training incorporating workshops and groups
• Use of CD-ROM training programs
• Supervised coaching and mentoring
• Role playing
• Face-to-face training.
Role plays, workshops, and work groups all provide opportunities for individuals to train and interact in simulated feedback situations. The training can also be a combined training program with the assistance of workplace trainers and assessors.
The training should include specific training around addressing performance gaps. Performance gaps are situations where outcomes are less than those stated in the strategic objectives, such as:
• Costs above budget
• Disruptive conflict
• External interference
• Failure to meet strategic and/or operational objectives
• Lost time disputes
• Low / high turnover of labour
• Productivity below budget
• Quality / workplace health and safety / environmental failure
• Work bans / go slow.
Business College at International House
RTO Code: 91109 CRICOS 02623G
Level 1, 203 Clarence St, Sydney NSW 2000 | Floor 1, 237 Oxford St, Bondi Junction NSW 2022
3 Searcy St, Darwin NT 0800 | Level 6, 601 Bourke St, Melbourne VIC 3000
info@ihBC.edu.au| www.ihBC.edu.au
Team leaders and managers will need training in:
• How to distinguish among the various levels of performers
• How to communicate about performance
• How to make pay decisions.
The training must involve teaching team leaders and managers to differentiate between satisfactory performance, excellent performance, and sub-standard performance. Team leaders and managers must understand that if they are going to tie pay to performance, they have to be accurate and honest in their performance evaluations. This is often achieved by asking them whether they feel it makes sense for someone who excels on the job to make more than someone who does not.
Team leaders and managers need to be able to gain the support of their subordinates to receive on-going feedback on their performance so they would know exactly where they needed to improve and there would be no surprises at the appraisal. They also need to know the process step-by-step to be able to implement and support their subordinates to comply and support.
In summary, consider these tips for success:
• Give team leaders and managers the tools they need to have tough conversations with employees
• Talk early and talk often
• Make clear to team members what they will be measured on
• Discuss how your pay plan will improve the organisation’s success.
Team leaders and managers will also require training in identifying performance gaps. A performance ‘gap’ is the difference between what is happening and what could / should be happening. This sort of training is essential to assist them in remaining objective during the interview and also ensure that ‘root causes’ are identified rather than convenient but irrelevant issues.
Identification training will usually involve teaching team leaders and managers to ask various questions, such as:
• Is the issue having a negative impact on the organisation?
• How do I know it’s an ‘issue’?
Business College at International House
RTO Code: 91109 CRICOS 02623G
Level 1, 203 Clarence St, Sydney NSW 2000 | Floor 1, 237 Oxford St, Bondi Junction NSW 2022
3 Searcy St, Darwin NT 0800 | Level 6, 601 Bourke St, Melbourne VIC 3000
info@ihBC.edu.au| www.ihBC.edu.au
• Who else sees this issue as a problem?
• How are business metrics impacted by this issue?
• What would happen if nothing was done about this issue?
• What will be the benefits to the company and/or the business unit if the issue is successfully addressed?
• Is the problem ‘leverage-able’ (can a significant improvement be made with minimum effort?)
• Describe what the situation should / could be if the issue were resolved to everyone’s satisfaction.
The answers will provide further information and encourage greater accuracy in diagnosing ‘gaps’. Other training could be developed around:

  1. The appropriate atmosphere to create at the interview
  2. Selecting the performance criteria to use
  3. What information is on hand or is needed to be collected before the discussion
  4. Steps to be followed when conducting the discussion
  5. Managing disagreements
  6. Evaluating the interviewer’s performance
    Monitoring Performance
    Monitoring is the systematic and continual process of collecting and analysing of information about a piece of work. There are several types of monitoring and it is done at different time intervals, such as, monthly, bimonthly, quarterly, or annually, to assess the progress, production, numbers, and quality. It also provides inputs or feedback where necessary.
    KPIs must be measured in the units or terms into which the targets were broken down at the planning stage. Measurement of actual performance means knowing what has happened and predicting what is likely to happen. This means that deviations, shortfalls, overruns, etc, are forecast well in advance, so that corrective actions are initiated to forestall adverse circumstances. In other words, measurement of performance should include the process.
    To effectively monitor, you will need to know:
    • What are the specific KPIs related to the activities to be monitored?
    Business College at International House
    RTO Code: 91109 CRICOS 02623G
    Level 1, 203 Clarence St, Sydney NSW 2000 | Floor 1, 237 Oxford St, Bondi Junction NSW 2022
    3 Searcy St, Darwin NT 0800 | Level 6, 601 Bourke St, Melbourne VIC 3000
    info@ihBC.edu.au| www.ihBC.edu.au
    • Which individuals and teams will be responsible in undertaking these activities?
    • When are these activities undertaken?
    • What problems may arise in connection with the activities?
    • What measures may be adopted to evaluate the KPIs?
    • How is the data stored, recorded, and retrieved?
    • What logistics should be kept in mind?
    • What resources will be required?
    • Who will provide these resources?
    • What mechanism would you require for networking with other organisations?
    • What targets and objectives will be achieved?
    • What kind of supervision and monitoring will be undertaken?
    When significant deviations are noticed from the KPIs, corrective actions need to be initiated. This is called an intervention. Intervention activities could include any of: coaching, counselling, discipline, giving praise, or recognition of good performance. These could also include training, more frequent supervision, increasing number of observations, and motivating participants, undertaking exercises, improving the quality of learning material, etc.
    Everyone involved in a process has a responsibility to participate in the monitoring. All should be encouraged to keep their eyes and ears open to detect examples of exceeding the expectations and where there may be problems. Therefore, everyone needs to clearly understand the monitoring of KPIs.
    The first need is the development of the tools for data collection. These tools will vary from situation to situation. Reviewing data collected for quality, production requirements, or other reasons may all be valuable in terms of individual performances.
    In the case of a team leader or manager monitoring their staff, the process of observation is important. There is a management style referred to as ‘management- by-walking-around’ which is exactly as it is described. Getting out from behind the desk and taking the time to walk and talk is an excellent way of gathering information. This can allow you to seize the moment when individuals are most receptive to growing their skill or skills that are lacking and limiting their performance.
    Checklists to establish activities and their timeframes, casual discussions with
    Business College at International House
    RTO Code: 91109 CRICOS 02623G
    Level 1, 203 Clarence St, Sydney NSW 2000 | Floor 1, 237 Oxford St, Bondi Junction NSW 2022
    3 Searcy St, Darwin NT 0800 | Level 6, 601 Bourke St, Melbourne VIC 3000
    info@ihBC.edu.au| www.ihBC.edu.au
    groups and individuals may all be helpful. Remember that information received from others may be biased so investigate further before acting on unsubstantiated input.
    Whatever method is selected for the monitoring, it must be regularly and consistently applied. This is essential to provide a baseline for performance, productivity, and quality.
    Managing ‘Gaps’
    Once the evaluation on the performance has been conducted, you will know whether the individual performing the task has exceeded, met, or is below the standard as detailed by the KPI. Regardless of the outcome, feedback must be given. It is important to stay focused and be regular when monitoring.
    Team leaders or managers must respond quickly and decisively with an intervention as soon as they become aware of a ‘gap’, whether over or under-achieving. If they want to see the behaviour repeated, they will reward the behaviour in some appropriate way. If they want to see the behaviour changed, then they will provide constructive feedback
    – information on which the individual involved can build a more solid performance.
    They must respond quickly because the longer they wait, in the case of a positive behaviour, the impact is lost. In the case of a negative behaviour, it will be harder to change the behaviour, and in some cases, the potential consequences could be very bad.
    Many organisations will have policies and procedures to cover situations of non- performance or excellence. Team leaders and managers must make themselves aware of such policies and procedures, and perform as instructed by them.
    However, if there are no such policies in place, intervention will still be necessary. The immediate superior of team leaders and managers may be called upon to support and work with their subordinates to ensure compliance.

Performance Management (PM) Process Design

Performance management is the vehicle for translating organisational goals into team and individual deliverables, and sits at the heart of many other HR activities, including performance-related reward. It works in different ways for different organisations. They must develop the right performance approach that fits with their unique organisational culture and business needs to develop solutions that work for them. These approaches can range from rethinking current performance management strategy or simply enhancing the existing approach by making small innovative changes right through to working to become a learning organisation.
There are five main approaches:

  1. Total Performance Management
    This probably represents the most structured approach – comprising all the elements usually associated with PM: role profiles (role purpose accountabilities, success measures, competencies etc.); individual objectives or targets (usually written in SMART terms); personal development plans (covering specific development needs and activities as
    2.1 Train relevant groups and individuals to monitor performance, identify performance gaps, provide feedback and manage talent
    2.2 Work with line managers to ensure that performance is monitored regularly and that intervention occurs as required and in line with organisational
    policies and legal requirements
    2.3 Support line managers to counsel and discipline employees who continue to perform below standard
    2.4 Articulate dispute-resolution processes where necessary, mediating between line managers and employees
    2.5 Provide support to terminate employees who fail to respond to
    interventions, according to organisational protocols and legislative requirements
    2.6 Ensure recorded outcomes of performance-management sessions are accessible and stored securely according to organisational policy
    2.7 Regularly evaluate and improve all aspects of the performance-
    management processes, in keeping with organisational objectives and policies
    Business College at International House
    RTO Code: 91109 CRICOS 02623G
    Level 1, 203 Clarence St, Sydney NSW 2000 | Floor 1, 237 Oxford St, Bondi Junction NSW 2022
    3 Searcy St, Darwin NT 0800 | Level 6, 601 Bourke St, Melbourne VIC 3000
    info@ihBC.edu.au| www.ihBC.edu.au
    well as longer term career aspirations); and appraisals, with varying degrees of self-assessment and/or feedback from the manager and others.
    The emphasis here is on balancing the ‘what’s’ and the ‘how’s’ of performance
    – focussing the individual both on the business result required and the preferred way to achieve that result. Another aspect of the structure is a strong alignment with higher level business objectives that emerge from the business plan: all part of the cascade approach to achieving the organisation’s goals.
    Competencies in this model are seen as offering a standard framework with which to assess the strengths and weaknesses of the whole workforce and to plan individual and workforce-wide development programmes – often carrying a strong sense of ‘stock take’ and ‘gap analysis’. In doing so, it assumes that competency assessment is being carried out accurately and consistently by the many managers and individuals involved.
    When carried out well it is the type of approach that supports ‘total quality’ initiatives, including the Business Excellence model as well as providing evidence of the links between business plans, individual appraisals and personal development that underpins the Investors in People framework. It is also demanding and can appear complex, especially when combined with ‘balanced scorecard’ approaches and a myriad of performance measures. As such, it can run the risk of ‘losing the plot’ in terms of motivating individuals and improving relations and effectiveness within teams.
  2. Skills or Competency-Based
    The second approach can be viewed as a cut down version of the first, with more emphasis on competencies as a structuring and measurement framework often with strong links to pay progression. It may start from the view that the traditional management-by-objectives is not appropriate for the staff in question and that the key to successful performance is the demonstration of existing skills and the acquisition of new skills.
    This may be especially suitable for certain professional and technical groups for whom it is important to plot an individual’s career (possibly in parallel with the career ladders for similar groups outside the organisation). For such groups, also sometimes called ‘knowledge workers’, the performance that counts, and which offers competitive differentiation is often best thought of in terms of competencies and behaviours, rather than targets and outputs. It could be helpful where the organisation is aware of a skills deficit or is facing recruitment and retention difficulties in
    Business College at International House
    RTO Code: 91109 CRICOS 02623G
    Level 1, 203 Clarence St, Sydney NSW 2000 | Floor 1, 237 Oxford St, Bondi Junction NSW 2022
    3 Searcy St, Darwin NT 0800 | Level 6, 601 Bourke St, Melbourne VIC 3000
    info@ihBC.edu.au| www.ihBC.edu.au
    key areas and wishes to highlight that its collective skills are fundamental to its success.
    The obvious risk is that too much attention may be paid to inputs and behaviours and too little to business results, with for example pay systems being increasingly supply-driven as staff climb competency ladders in much the same way as they progressed up traditional incremental pay grades. The clear connection between competency assessment and reward can strain the integrity of the assessment and may jeopardise the developmental purpose of the manager and the individual reviewing and discussing competency openly and honestly.
  3. Team-Driven
    The third approach is based on a team process of thinking through a business plan or set of goals and addressing questions like “What does that plan imply for us? What can we commit to achieving? What will make the big difference to the team achieving the plan or making a real breakthrough in performance?” From there the process becomes more individually focussed: “What does all this imply for me? What will I need to bring to the party for us to succeed? What new skills do I need to acquire? How do I need to change in order to deliver my part?”
    As an approach it can be very useful when establishing a new section or business unit with specific goals to be achieved, or when significant change is anticipated or required and a different PM approach would signal and reinforce the ‘change’.
    It really only works when there are genuine team goals that need to be shared and jointly ‘owned’. As such, it can help a new management team to form and articulate their plan. Potentially it can provide both the framework for PM and the basis of raising team effectiveness in one process.
  4. Continuous Learning and Coaching
    The fourth approach is the most individually-based. It emphasises that improving performance comes from learning and that individuals learn best from experience. Here the process begins with looking back and discussing with a manager or coach what went well and not so well and coming to conclusions about the individual’s strengths and development needs.
    Business College at International House
    RTO Code: 91109 CRICOS 02623G
    Level 1, 203 Clarence St, Sydney NSW 2000 | Floor 1, 237 Oxford St, Bondi Junction NSW 2022
    3 Searcy St, Darwin NT 0800 | Level 6, 601 Bourke St, Melbourne VIC 3000
    info@ihBC.edu.au| www.ihBC.edu.au
    Looking forward, the individual commits to working on two or three key areas (which can include greater use of strengths as well as addressing weaknesses). While this conversation might use competencies as an aid, the focus is on taking the individual forward from where they are, not on purporting to compare them with others or produce a ‘stock take’.
    So it may be a helpful approach in dealing with individual cases where particular improvements are required. It helps the individual gain confidence by focussing on one or two particular skill areas which will produce quick wins. It may also be useful during or just after particular episodes that exposed development needs, or at the start of a new assignment when making a conscious effort to learn from the past.
    It lends itself to being used regularly (not just annually) especially when an individual is new to a role or where the circumstances are changing rapidly. This coaching style of PM brings substantial benefits when used by skilled, sympathetic coaches.
  5. Project-Based
    A common difficulty with PM is that it is based on the formal roles and reporting lines of the organisation chart rather than the way work is actually done. In extreme cases this can mean that the main contribution an individual makes (via projects) seems to cut across what they are formally there to do. As a result, many organisations are trying to re-focus their PM processes around project working. One result of this is renewed emphasis on the skills and attributes that an individual brings along with their progress and success depending on how well those talents are known in the organisation and how well they are deployed. The key here is proven and validated skills, with project managers being assured that what they buy is what they get.
    For the individual, the key aspects are understanding what skills and attributes they bring and will need to deploy; how these will fit the team’s needs and how the project will help in developing new skills and building personal value. For the project manager it is important to integrate the performance of the individual in the team, to take time to give regular and constructive feedback and at the end of the individual’s assignment to offer an overall assessment. There is often an additional role here: the ‘resource manager’, whose job is to match people to projects in a way that develops the individual, builds the organisation’s capability and deploys resources to best effect. The ‘resource manager’ will play a key role in the longer term development and progression of the individual.
    Business College at International House
    RTO Code: 91109 CRICOS 02623G
    Level 1, 203 Clarence St, Sydney NSW 2000 | Floor 1, 237 Oxford St, Bondi Junction NSW 2022
    3 Searcy St, Darwin NT 0800 | Level 6, 601 Bourke St, Melbourne VIC 3000
    info@ihBC.edu.au| www.ihBC.edu.au
    Client-driven professional service, civil engineering or consulting firms are the natural home for this approach. For them, and organisations like them, the approach is useful in signalling the significance of projects and ensuring that project work is given the right priority (not tacked on to ‘business as usual’ activities). It is also helpful when there would otherwise be a risk that individuals’ achievements and development needs would be lost or unrecognised as a result of managers concentrating purely on individual project goals – helping to balance up the ‘people’ aspect alongside the ‘task’). Similarly it helps in ensuring that the organisation focusses on building long term capability and productive capacity (skills base) rather than solely delivering project goals.
    For project managers a conscious PM process helps to ensure that the people and team aspects of projects are not ignored. Where performance related pay applies, the approach offers a mechanism for justifying individual pay decisions, especially where the individual’s contributions to a series of business outcomes needs to be understood by more than their immediate or current project manager.
    Looking across the five approaches there are clearly large areas of overlap, so electing for one does not mean ignoring all aspects of the others. For example, a good manager may fill the role of coach in almost any PM approach. It is nonetheless useful in designing the right PM approach to consider all the options in the context of the circumstances of the enterprise, especially the skills of managers involved. There are real choices to be made in finding the right PM approach. There can be a risk that organisations can sometimes ‘end up with’ a style that reflects the personal preferences or previous experiences of one or two individuals or, worse(!), be driven by a consultant’s pet style or the latest fad.

Operations Management & Supply Chain

Bahria University Islamabad
MS SCM
Academic Year: Spring 2020 Semester: 2
Module Title: Operations Management & Supply Chain
Module Number: SCM 706
Total Marks 20
Weighting: 20%
Submission Deadline:
Date and Time
29th of May, 2020 at 2345 Hrs PST.
Late submissions Assignments received after the specified date and time will
be regarded as late. Late submissions will not normally be
marked.
Module Learning Outcomes
Assessed:
CLO – 1 Develop appropriate operations and supply chain
strategies as well as objective priorities for diverse product
and customer/market characteristics.
CLO – 2 Identify and apply appropriate operations
management techniques in several decision categories and
analyse the outcome from both theoretical and practical
views.
CLO – 3 Determine how operations and supply chain issues
can be identified and resolved through the analysis of
primary information and implementation of theories and
frameworks.
Coursework Title: Case Study; ATS Synthetic & Plastics.
Brief
Please review the case study and attempt the following. All points must be addressed.
• Present a detailed account of the transformation process for the Concept range of
products and define the main process types as evidenced in the case.
• Identify and critically evaluate the strengths and weaknesses that exist in the
relationships between the three core functions.
• How do you recommend the weaknesses identified, be improved?
• Critically evaluate the opportunities and threats that exist in wider operating
environment.
• How can the threats identified, be reduced or eradicated?
Coursework Aim:
Students should demonstrate knowledge and understanding of operations management, with
specific focus on the relationships that exist between the core functions of an organisation.
Students should demonstrate clear understanding of the need for process improvement in an
operations contents.
Coursework Learning Outcomes:
Through further study and reflection, students are to demonstrate and expand their
knowledge of operations management.
Format/Instructions: (word count/report/essay/etc)
You are required to produce no more than 4,500 Words in response to the assignment brief.
You should present your answer against each question listed first.
Not including the content of the Front Page, Table of Contents, & References the word count
for the written component is 4,500 words (+/-10%)
You should approach the task as you would if asked to present findings and improvement
plans to management.
As an academic work, appropriate sources should be used to support your arguments.
Harvard referencing conventions apply.
The completed work should be uploaded to the designated drop box by the due date.
Harvard referencing should be used throughout.
Criteria for Assessment: Please also see attached grading grid
Please pay attention to the mark distribution on the grading grid. This will assist you in the
planning stage of your work.
Also be aware that in an MS level coursework you are expected to demonstrate critical
consideration of content.
Only use credible academic sources, including peer reviewed journals, text books, trade body
reports and organisational reports, but exclude blogs, wiki’s and other non-verified material.
Instructions for submission:
Please submit one electronic copy of your completed work.
All work should be submitted via Turnitin (Coordinate with Ms. Qurat ul Ain), no hard copies
will be graded. You can submit your work to Turnitin 02 times until the due date, but please
expect a 24 hour delay after first attempt.
Please ensure all work is submitted before the deadline, otherwise submissions will be
recorded as “late.”
If you have problems uploading your coursework please contact the I.T. Helpdesk in the first
instance and notify course coordinator of any technical issues Do NOT email your submission.
All submissions must go through Turnitin.
Academic Honesty:
It is your responsibility to ensure that your work conforms to the requirements for academic
honesty. The details below are a brief reminder of what constitutes academic
dishonesty/cheating.

Plagiarism
You may lose marks if you do not cite sources accurately. If you fail to reference sources
properly, the effect is to misrepresent the amount of work done. Passing someone else’s work
off as your own is plagiarism.
Plagiarism (i.e. presenting the thoughts or writings of others as your original work, without
properly identifying and referencing the source), is unacceptable behaviour and will be
regarded as a serious breach of Regulations by the University. This includes copying part or all
of a dissertation, copying from another student’s work, or the un-attributed quotation of even
a single sentence written by another author.
Collusion
If two or more students work together, to produce the same piece of work, and then attempt
to present this as entirely their own work, or if one student permits another to copy his/her
work, it will be considered that an offence has been committed by all concerned.
Note
A cover page is required with the word count displayed. 10% over or under this limit is
acceptable. Failure to keep within 10% of the designated word count will result in a penalty of
a reduction of one grade. Any appendices you may attach are not included in the word count.
You must include a statement on the front cover of your work that gives the word count. You
must comply with staff requests to submit to Turnitin and provide a receipt where asked to
do so.

CSCI312 Big Data Management

School of Computing & Information Technology Session: 2, April 2019
University of Wollongong Lecturer: Janusz R. Getta
CSCI312 Big Data Management
Singapore 2020-2
Assignment 2
Published on 27 April 2020
Scope
The objectives of Assignment 2 include conceptual modelling of a data warehouse,
logical design of a data warehouse and implementation of a data warehouse as a
collection of internal tables and external tables in Hive, querying a data cube,
implementation of HBase table and querying and manipulating data in HBase table,
This assignment is due on Saturday, 16 May 2019, 7:00pm (sharp) Singaporean Time
(ST).
This assignment is worth 30% of the total evaluation in the subject.
Only electronic submission through Moodle at:
https://moodle.uowplatform.edu.au/login/index.php
will be accepted. All email submissions will be deleted and mark 0 (“zero”) will be
immediately granted for Assignment 2. A submission procedure is explained at the end of
Assignment 2 specification.
A policy regarding late submissions is included in the subject outline.
Only one submission of Assignment 2 is allowed and only one submission per student is
accepted.
A submission marked by Moodle as “late” is always treated as a late submission no
matter how many seconds it is late.
A submission that contains an incorrect file attached is treated as a correct submission
with all consequences coming from the evaluation of the file attached.
All files left on Moodle in a state “Draft(not submitted)” will not be evaluated.
A submission of compressed files (zipped, gzipped, rared, tared, 7-zipped, lhzed, … etc)
is not allowed. The compressed files will not be evaluated.
The second assignment is an individual assignment and it is expected that all its tasks
will be solved individually without any cooperation with the other students. However,
it is allowed to declare in the submission comments that a particular component or task of
this assignment has been implemented in cooperation with another student. In such a case
evaluation of a task or component may be shared with another student. In all other cases
plagiarism will result in a FAIL grade being recorded for entire assignment. If you have
any doubts, questions, etc. please consult your lecturer or tutor during laboratory/tutorial
classes or over e-mail.
Task 1 (8 marks)
Conceptual modelling of a data warehouse
An objective of this task is to create a conceptual schema of a sample data warehouse
domain described below. Read and analyse the following specification of a data
warehouse domain.
A group of hospitals would like to create a data warehouse to store information about
the medical examinations performed on the patients and later on to analyse the
contents of a data warehouse. It is expected that the planned data warehouse will
contain historical information collected over a long period of time.
A data warehouse supposed to contain information about the medical examinations,
patients, medical staff conducting medical examinations and including nurses and
doctors, hospitals, cities and countries the patients come from and hospitals are located
at, and locations of medical examinations.
The patients are described by a medical insurance number, first name, last name, data of
birth and address. A medical insurance number identifies each patient. An address
consists of building number, street name, city, and country.
The medical examinations are performed in the hospitals. A hospital is identified by its
unique name, and described by city and country it is located at. A medical examination is
performed in a medical examination room. A room number, building level, and building
number describe a medical examination room.
A medical staff member is described be an employee number, first name, last name, and
data of birth. A medical staff member belongs to one of the hospitals. A medical staff
member is either a nurse or a doctor. Nurses are additionally described by qualifications
and doctors are described by a specialization.
A medical examination may involve an external medical expert whose role is to provide
an independent opinion. An external medical expert is described by a title, first name, las
name and a name of organization he/she belongs to.
A medical examination is described by date and time when performed and the
measurement of the parameters like weight, blood pressure, cholesterol levels, and the
others (please insert at least two other measurements of your choice).
A data warehouse must be designed such it would be possible to easily implement the
following classes of applications.
(1) Find the total number of medical examinations performed per year, per month and
per day, per patient, per nurse, per doctor, per external expert who participated in
the examinations, per hospital, per city, per country, etc. For example, it should be
to find the total number of medical examinations performed in each month of 2017
in each hospital.
(2) Find the aggregations of the measures obtained from the medical examinations per
year, per month and per day, per patient, per nurse, per doctor, per external expert
who participated in the examinations, per hospital, per city, per country, etc. For
example, it should be possible to find an average blood pressure of all patients older
than 70 per last 12 months.
To create a conceptual schema of a sample data warehouse domain follow the steps listed
below.
Step 1 Find a fact entity, find the measures describing a fact entity.
Step 2 Find the dimensions.
Step 3 Find the hierarchies over the dimensions.
Step 4 Find the descriptions (attributes) of all entity types.
Step 5 Draw a conceptual schema.
To draw a conceptual schema, use a graphical notation explained to you in a presentation
11 Conceptual Data Warehouse Design. To draw your diagram, you must use UMLet
diagram drawing tool and apply a “Conceptual modelling” notation, Selection of a
drawing notation is available in the right upper corner of the main menu of UMLet
diagram drawing tool.
Deliverables
A file solution1.pdf with a drawing of a conceptual schema.
Task 2 (4 marks)
Logical modelling of a data warehouse
Consider the following conceptual schema of a data warehouse.
Perform a step of logical design to transform a conceptual schema given above into a
logical schema (star schema). Use UMLet diagram drawing tool and apply a “Logical
modelling” notation to draw a logical schema. Selection of a drawing notation is
available in the right upper corner of the main menu of UMLet. Save a diagram of logical
schema in a file solution2.uxf and export it to a file solution2.pdf.
Deliverables
A file solution2.pdf with a drawing of a logical schema.
Task 3 (6 marks)
Implementation of a data warehouse as a collection of external tables in Hive
Consider the following two-dimensional data cube.
The data cube contains information about that parts that can be shipped by the suppliers.
Download and unzip a file task3.zip. You should obtain a folder task3 with the
following files: part.tbl, supplier.tbl, partsupp.tbl.
Use an editor to examine the contents of *.tbl files. Note, that the contents of the files
can be loaded into the relational tables obtained from the transformation of the twodimensional data cube given above into the relational table PART, SUPPLIER, and
PARTSUPP.
Transfer the files into HDFS.
Implement HQL script solution3.hql that creates the external tables obtained from
a step of logical design performed earlier. The external tables must overlap on the files
transferred to HDFS in the previous step. Note, that a header in each *.tbl file must be
removed before creating the external tables.
Include into solution3.hql script SELECT statements that any 5 rows from each
one of the external tables implemented in the previous step and the total number of rows
included in each table.
When ready, use a command line interface beeline to process a script
solution3.hql and to save a report from processing in a file solution3.rpt.
Deliverables
A file solution3.rpt with a report from processing of HQL script
solution3.hql.
Task 4 (4 marks)
Querying data cube
Download and unzip a file task4.zip. You should obtain a folder task4 with the
following files: dbcreate.hql, dbdrop.hql, partsupp.tbl, lineitem.tbl,
and orders.tbl.
A file orders.tbl contains information about the orders submitted by the customers.
A file lineitem.tbl contains information about the items included in the orders. A
file partsupp.tbl contains information about the items and suppliers of items
included in the orders.
Open Terminal window and use cd command to navigate to a folder with the just
unzipped files. Start Hive Server 2 in the terminal window (remember to start Hadoop
first). When ready process a script file dbcreate.hql to create the internal relational
tables and to load data into the tables. You can use either beeline or SQL Developer.
A script dbdrop.hql can be used to drop the tables.
The relational tables PARTSUPP, LINEITEM, ORDERS implement a simple twodimensional data cube. The relational tables PARTSUPP and ORDERS implement the
dimensions of parts supplied by suppliers and orders. A relational table LINEITEM
implements a fact entity of a data cube.
Implement the following queries. In each case, try to find the most efficient
implementation.
(1) For the order clerks (O_CLERK) Clerk#000000522, Clerk#000000154, find
the total number of ordered parts per order date (O_ORDERDATE), per supplier
(L_SUPPKEY), per order date and supplier (O_ORDEDATE, L_SUPPKEY), and the
total number of ordered parts.
(2) For the parts with the keys (L_PARTKEY) 7, 8,9 find the largest discount applied
(L_DISCOUNT) per part key (L_PARTKEY) and per part key and supplier key
(L_PARTKEY, L_SUPPKEY) and the largest discount applied at all.
(3) Find the smallest quantity (L_QUANTITY) per order year (O_ORDERDATE), and
order clerk (O_CLERK).
(4) Find the smallest tax (L_TAX) applied per supplier key (L_SUPPKEY).
(5) Find an average quantity (L_QUANTITY) and the largest quantity (L_QUANTITY)
per part key (L_PARTKEY), and per part key, and order year (L_PARTKEY,
O_ORDERDATE). Consider only parts with the keys 5, 6, 7, 8, and 9.
When ready, save your SELECT statements in a file solution4.hql. Then, process a
script file solution4.hql and save the results in a report solution4.rpt.
Deliverables
A file solution4.rpt that contains a report from processing of SELECT statements.
Task 5 (4 marks)
Implementation of HBase table
Implement as a single HBase table a database that contains information described by the
following conceptual schema.
(1) Create HBase script solution5.hb with HBase shell commands that create
HBase table and load sample data into the table. Load into the table information
about at least two parts and two suppliers and such that one supplier supplies one
part and the other supplier supplies 2 parts.
When ready use HBase shell to process a script file solution5.hb and to save a
report from processing in a file solution5.rpt.
Deliverables
A file solution5.rpt that contains a report from processing of solution5.hb
script with the statements that create HBase table and load sample data.
Task 6 (4 marks)
Querying and manipulating data in HBase table
Consider a conceptual schema given below. The schema represents a simple database
domain where students submit assignments and each submission consists of several files
and it is related to one subject.
Download a file task6.hb with HBase shell commands and use HBase shell to process
it. Processing of task6.hb creates HBase table task6 and loads some data into it.
Use HBase shell to implement the following queries and data manipulations on the
HBase table created in the previous step. Save the queries and data manipulations in a file
solution6.hb.
(1) Find all information about a student number 007, list one version per cell.
(2) Find all information about a submission of assignment 1 performed by a student 007
in a subject 312, list one version per cell.
(3) Find the first and the last names of all students, list one version per cell.
(4) Find all information about a student whose last name is Bond, list two versions per
cell.
(5) Delete a column family FILES.
(6) List information about all submissions performed by the students.
(7) Increase the total number of versions in each cell of a column family SUBJECT.
(8) Delete HBase table task6.
When ready, start HBase shell and process a script file solution6.hb with Hbase
command shell. When processing is completed copy the contents of Command window
with a listing from processing of the script and paste the results into a file
solution6.rpt. Save the file. When ready submit a file solution6.rpt.
Deliverables
A file solution6.rpt with a listing from processing of a script file
solution6.hb.
Submission of Assignment 2
Note, that you have only one submission. So, make it absolutely sure that you submit
the correct files with the correct contents. No other submission is possible !
Submit the files solution1.pdf, solution2.pdf, solution3.rpt,
solution4.rpt, solution5.rpt, and solution6.rpt through Moodle in
the following way:
(1) Access Moodle at http://moodle.uowplatform.edu.au/
(2) To login use a Login link located in the right upper corner the Web page or in
the middle of the bottom of the Web page
(3) When logged select a site ISIT312 (SP220) Big Data Management
(4) Scroll down to a section SUBMISSIONS
(5) Click at In this place you can submit the outcomes of your
work on the tasks included in Assignment 2 link.
(6) Click at a button Add Submission
(7) Move a file solution1.pdf into an area You can drag and drop
files here to add them. You can also use a link Add…
(8) Repeat step (7) for the remaining files solution2.pdf, solution3.rpt,
solution4.rpt, solution5.rpt, and solution6.rpt
(9) Click at a button Save changes
(10)Click at a button Submit assignment
(11)Click at the checkbox with a text attached: By checking this box, I
confirm that this submission is my own work, … in order to
confirm authorship of your submission.
(12)Click at a button Continue
End of specification