PRM 524 FINAL TERM – October 2017  –   100% correct

What do you expect when you
are submitting an invitation for bid to sellers?

Question 1 options:

Offers which are not primarily written to win
against competition.

Offers which
are similar enough to allow a selection based on price.

General information on a seller’s ability to
provide the goods or services.

Offers which will differ significantly in
solution approach and price.

___________ are usually not
a manifestation of unique organizational cultures and styles.
Question 2 options:

Views of authority relationships

Individual
traits and attitudes of co-workers

Shared visions, values, norms, beliefs, and
expectations

Policies, methods, and procedures

During project execution,
you found out that work is often not performed at the right time and in the
right order. Deliverables are made by one team member that cannot be processed
by another one. This already leads to timely rework and bad morale among team
members. Which project management tool is most appropriate to deal with
problems like this?
Question 3 options:

Communications management plan

Work
authorization system

RACI matrix

Organization chart

How should change management
be planned for?
Question 4 options:

Planning for change management should be done
while the various change control processes are being applied.

Change
management can be planned in a set of management plans or a specific change
management plan.

Changes are generally not predictable; therefore,
planning for change management cannot be reasonable.

Changes are a sign of bad planning. One should
avoid changes during a project, thus eliminating the need to manage them

Which statement best
describes the purpose of the communications management plan?
Question 5 options:

The communications management plan focuses on
the use of communications technologies by the project management team.

The project management plan is a subsidiary
document of the overall communications management plan.

The communications management plan describes
rules of behavior and respect for communications in cross-cultural teams.

The
communications management plan describes the information delivery needs
including format and level of detail

A project manager’s PDM
network schedule gets audited by a scheduling expert.
The expert tells the project manager to focus
more on nodes with “path
convergence,” also known as “sinks.” What is he
referring to?
Question 6 options:

Nodes in a WBS, where several branches are
brought back together.

Nodes in a
network logic diagram, which have multiple predecessors.

Nodes in a conditional network diagram, at which
it becomes deterministic.

Nodes in a decision tree, showing various
branches with the same chance

You are running a major
project with four sub-projects. Each of the sub-project managers has developed
a risk management plan, identified many risks, analyzed them, and planned for
risk response. It is now two months later. What should you not do?
Question 7 options:

Make sure that the sub-project managers monitor
trigger conditions for contingency plans.

Make sure that the sub-project managers monitor
their project work for new and changing risks.

Ensure that
they handle all risks to save you from project level risk control.

Make sure that the sub-project managers keep
track of the identified risks and those on the watch list.

What should managers
consider before conducting a performance-evaluation interview with a project
team member?
Question 8 options:

How can discussion of the manager’s leadership
style be avoided?

Has the
employee been provided with sufficient instructions and work tools?

How can disputes related to unsatisfactory
performance be avoided?

Which management fallacies can most easily be
delegated to the worker?

At the beginning of project
execution, you notice different opinions between team members relating to
project work and deliverables and to the level of overall complexity. What
should you do right now?
Question 9 options:

Give your team members some time to develop a
common understanding of the project scope and product scope. Upcoming interface
problems may be resolved later.

Use interviews in private with each individual
team member to inform them of your expectations and your requirements in an
atmosphere of confidence.

Organize
meetings to identify and resolve misunderstandings between team members in
order to avoid interface problems, disintegration, and costly rework early in
the project.

Use the risk management processes to identify
and assess risks caused by misunderstandings and develop a plan with measures
in order to respond to them.

In configuration management,
which of the following is necessary to maintain the integrity of baselines?
Question 10 options:

Analyzing variances by comparing baseline
information with actual project data.

Ensuring transparency across all project
management processes and activities.

Releasing
only approved changes for incorporation into products or services.

Ensuring that team members adhere to a code of
ethical conduct and behavior.

Which of the following is
generally not regarded as an element of active listening?
Question 11 options:

Paraphrasing

Making eye contact

Interrupting when appropriate

Interpreting
the information

Which statement
describes best handling of assumptions during the initiating processes?
Question 12 options:

Organizational, environmental,
and external assumptions should be addressed by the project charter.

Managing and organizing assumptions means avoiding risks right from the start
of the project.

It is the responsibility of the sales person in charge to identify all risks
related to a customer project.

Risks are a sign of uncertainty. Avoiding all uncertainties means that a
project should have no risks at all.

Which statement
describes best handling of assumptions during the initiating processes?

For a project, the following
earned value data have been assessed:

AC: $ 4,000,000
CV: $ -500,000
SPI: 1.12
BaC: $ 9,650,000

What is the earned value of the project?

Question 13 options:

$3,000,000

$5,650,000

$4,480,000

$3,500,000

During the execution of a
project to build a complex defense system, your team has run into a deep
crisis. The project’s goal and objectives have been challenging right from the
start, but now you have discovered that your team members have become
increasingly unaware of them. Being busy solving detail problems, they often
fail to understand the overall requirements. Then they develop solutions that
resolve issues in their area of limited responsibility while causing new
problems at the interfaces with other system components. Meanwhile, the team
members show signs of growing frustration, and time is running away. How can
you help your team in this situation?
Question 14 options:

Ignore the low-level issues and focus on
achieving the overall requirements. Details can be sorted out during test and
handover.

If everybody simply does their jobs, then there
should be no problem. Make sure that team members are fully aware of their
accountability.

Problems of this dimension have their origin in
fundamental personal incompatibilities between team members. You should replace
them all.

Accompany
your team members along a sequence of maturity levels from dependence through
independence to interdependence.

Which of the following are
not common barriers to project team building?
Question 15 options:

Unclear project objectives/outcomes

Role conflicts

Excessive
team member commitment

Differing outlooks, priorities, and interests

What is not a reason for
companies to organize lessons learned?
Question 16 options:

Lessons learned databases are an essential
element of the organizational process assets.

Lessons
learned should focus on identifying those accountable for errors and failures.

Phase-end lessons learned sessions provide a
good team building exercise for project staff members.

Lessons learned sessions should bring about
recommendations to improve future performance on projects.

What is important for
quality auditors?
Question 17 options:

They must be mandated by the auditee.

They must be
properly trained.

They must be in-house personnel.

They must be third-party staff.

The communications
management plan is a document that includes descriptions of:
Question 18 options:

stakeholder
communication requirements.

activity level status reports.

project level performance reports.

responsibility assignments.

A customer is requiring a
minor scope change and expects you to do this without delays and additional
costs. You believe that you have adequate authorization to make the decision by
yourself, but you are not quite sure. What should be your next steps?
Question 19 options:

A requested change is always an opportunity to
get more money paid by the customer and to secretly solve schedule and quality
problems. You should make some reasonable estimates on time, costs, risks, etc.
and then add a nice margin on top of that to calculate the new price.

Customer satisfaction is your top priority. The
customer gives you an opportunity to increase their satisfaction, which you
should use to the maximum benefit. Most project managers have contingencies to
cover risks; these can be used to pay the additional costs.

Handle the
request according to the integrated change control processes described in your
management plans. Then make a decision together with the appropriate change
control body, whether the increased customer satisfaction will be worth the
extra costs, work, risks, etc.

Before making a decision, you should have a look
at the customer’s parking lot. If you find there to be many expensive, new
automobiles, it is likely that you can use the requested change to increase the
profit from the contract. Otherwise, you should reject the request.

The cost baseline is
developed during which process?
Question 20 options:

Estimate costs

Develop schedule

Determine
budget

Perform integrated change control

During a meeting, a
discussion came up: To which degree does your project have to be compliant to
the processes enumerated in the PMBOK Guide? What should be the guiding
principle to answer this question?
Question 21 options:

The more processes the project team follows, the
better the project’s performance will be.

The processes are meant as rough guidelines to
which a team should only adhere if there is enough consensus.

The project
team must select appropriate processes required to meet the project
requirements.

Without alterations, the project manager must
follow all 42 processes for project management

What is typical for critical
chain project management?
Question 22 options:

Management of leads and lags

Management of resource over-allocations

Management of total floats and free floats

Management
of buffers

The members of your project
team have been assigned to your project with general availability levels of
50%. Yesterday, they reported to you that significant variances occurred during
project execution. You have noted that the team members have been spending less
than 50% of their time working on your project. Your project schedule is about
to become heavily delayed, and deadlines are in jeopardy. What should you do?
Question 23 options:

Ignore the difficulties, adjust your schedule,
and negotiate new deadlines according to the slower progress.

Talk with
functional managers. Negotiate clear and written assignments with reliable
scheduling priorities.

Focus on internal charges. Make sure that your
project is not getting charged for more than the actual work.

Talk to your sponsor and try to get more
resources assigned on similar conditions as the existing ones.

The concept of (the) __________
states that changes related to one requirement—scope, time, or cost—will at
least influence one other element.
Question 24 options:

three wise men

three-point estimation

triple
constraint

three needs theory

During code inspection in a
major software development project, a project management team identified
frequent occurrences of critical programming errors. These errors are scattered
across the code and occur without a discernible pattern. Which tool is most
likely to help the team identify areas of error concentration in order to
develop a prioritized response strategy?
Question 25 options:

Check sheet

Decision tree

Influence diagram

Process decision program chart

NR361 RN Information Systems in Healthcare

Week 1 Discussion

AACN Essentials Self-Assessment

CO2 Analyze data from all relevant sources, including technology, to inform the delivery of care. (PO 2)

Download and open the AACN Essentials Self-Assessment (Links to an external site.)Links to an external site.. Complete the self-assessment of your current comfort levels and total your score. If you are willing, please share your results with your classmates in your discussion post. (Remember, this is the starting point for our course and the start of the knowledge we will learn over 8 weeks).

As you reflect on your score, identify areas where your knowledge could use improvement. Whether you are a new graduate or a seasoned nurse, it is important to keep in mind that all professional nurses are knowledge workers. What questions do you have as they relate to nursing informatics and the AACN essentials?

NR361 RN Information Systems in Healthcare

Week 2 Discussion

Experiences With Healthcare Information Systems

This week’s graded discussion topic relates to the following Course Outcome (CO).

CO1 Describe patient-care technologies as appropriate to address the needs of a diverse patient population. (PO 1)

Share your experiences with healthcare information systems, past or present. Has it been an easy transition or difficult? Why do you believe your experience has been positive or negative? If you are currently not working, how has the medical record exposure in nursing school impacted your current knowledge?

NR361 RN Information Systems in Healthcare

Week 3 Discussion

Standardized Terminology and Language in Informatics

CO3 Define standardized terminology that reflects nursing’s unique contribution to patient outcomes. (PO 3)

CO8 Discuss the value of best evidence as a driving force to institute change in delivery of nursing care. (PO 8)

What is the impact of Centers for Medicare and Medicaid Services (CMS) payment denial on the healthcare system?

What are the implications for our nursing practice related to use of standardized terminology for documentation?

How do evidence-based practice guidelines impact patient outcomes and necessitate improved practice care?

NR361 RN Information Systems in Healthcare

Week 4 Discussion

Your Patient Has a Personal Health Record . . . Now What?

CO4 Investigate safeguards and decision-making support tools embedded in patient care technologies and information systems to support a safe practice environment for both patients and healthcare workers. (PO 4)

CO5 Identify patient care technologies, information systems, and communication devices that support safe nursing practice. (PO 5)

Case Study: A 65-year-old woman was just been diagnosed with Stage 3 non-Hodgkin’s lymphoma. She was informed of this diagnosis in her primary care physician’s office. She leaves her physician’s office and goes home to review all of her tests and lab results with her family. She goes home and logs into her PHR. She is only able to pull up a portion of her test results. She calls her physician’s office with concern. The office staff discussed that she had gone to receive part of her lab work at a lab not connected to the organization, part was completed at the emergency room, and part was completed in the lab that is part of the doctor’s office organization.

The above scenario might be a scenario that you have commonly worked with in clinical practice. For many reasons, patients often receive healthcare from multiple organizations that might have different systems.

As you review this scenario, reflect and answer these questions for this discussion.

What are the pros and cons of the situation in the case study?

What safeguards are included in patient portals and PHRs to help patients and healthcare professionals ensure safety?

Do you agree or disagree with this process?

What are challenges for patients that do not have access to all of the EHRs? Remember, only portions of the EHRs are typically included in the PHRs.

NR361 RN Information Systems in Healthcare

Week 5 Discussion

Trends in Informatics

CO6 Discuss the principles of data integrity, professional ethics, and legal requirements related to data security, regulatory requirements, confidentiality, and client’s right to privacy. (PO 6)

CO7 Examine the use of information systems to document interventions related to achieving nurse sensitive outcomes. (PO 7)

Select one of the following trends and discuss your understanding of this trend in healthcare and its potential impact on your practice as a nurse. What are the legal, privacy, and ethical considerations of this trend?

Nanotechnology

Consumer health informatics (CHI)

Telehealth (or telenursing)/virtual healthcare

Social media healthcare applications

Health-focused wearable technology

eHealth

NR361 RN Information Systems in Healthcare

Week 6 Discussion

Distractors in Our Environments

CO6 Discuss the principles of data integrity, professional ethics, and legal requirements related to data security, regulatory requirements, confidentiality, and client’s right to privacy. (PO 6)

Distractions are everywhere. They may include cellphones, multiple alarms sounding, overhead paging, monitors beeping, and various interruptions that disrupt your train of thought.

Give an example of an ethical or legal issue that may arise if a patient has a poor outcome or sentinel event because of a distraction such as alarm fatigue. What does evidence reveal about alarm fatigue and distractions in healthcare when it comes to patient safety?

NR361 RN Information Systems in Healthcare

Week 7 Discussion

Use of Personal Communication Devices in Patient Care Settings

CO6 Discuss the principles of data integrity, professional ethics, and legal requirements related to data security, regulatory requirements, confidentiality, and client’s right to privacy. (PO 6)

This week, we will discuss personal communication devices and their use in healthcare. As we focus on this topic, please address the questions below in the discussion.

How can the use of the nurse’s personal communication device(s) impact patient care positively and/or negatively?

What are the ethical and legal implications?

What does the professional literature say about how communication devices can support safe nursing practice?

NR361 RN Information Systems in Healthcare

Week 8 Discussion

Reflective and Projected Practice

CO8 Discuss the value of best evidence as a driving force to institute change in delivery of nursing care. (PO 8)

Prior to posting, complete the Week 8 AACN Essentials Self-Assessment (Links to an external site.)Links to an external site.. Compare your scores from Week 1 to Week 8. How far have you come? How will you apply this information to continue to improve your informatics knowledge in nursing practice?

NR361 RN Information Systems in Healthcare

Week 2 Patient Education Technology Guide to a Mobile Health Application PowerPoint

Purpose

The purpose of this assignment is to demonstrate the skills of the professional nurse as an educator. You are to prepare a guide that will serve as a handout to assist a specific patient that you identify. Your guide or handout should help this patient find and evaluate a reliable mobile health, or mHealth application (app) that is already developed. This may be related to the patient’s disease process or diagnosis, or may be an app that can help a patient maintain or improve good health, and prevent illness.

You will develop the guide using Microsoft PowerPoint. PowerPoint is a versatile application that lets you design slideshows and handouts. For this assignment, you will be using PowerPoint to create a guide or handout that you may print and give to patients and families. You will be submitting this PowerPoint file for grading.

Course Outcomes

This assignment enables the student to meet the following Course Outcomes.

CO1: Describe patient-care technologies as appropriate to address the needs of a diverse patient population. (PO1)

CO5: Identify patient care technologies, information systems, and communication devices that support safe nursing practice. (PO5)

Points

This assignment is worth a total of 175 points.

Due Date

The Patient Education Technology Guide to a Mobile Health Application PowerPoint assignment is due in Week 2. Submit your completed assignment. You may consult the Policies section in the Introduction & Resources module for details regarding late assignments. Late assignments will result in loss of points. Post questions about this assignment in the Course Q & A Forum.

Directions

You are required to complete this assignment using the productivity tools required by Chamberlain University, which is Microsoft Office 2013 (or later version), or Windows and Office 2011 (or later version) for MAC. You must save the file in the “.pptx” format. A later version of the productivity tool includes Office 365, which is available to Chamberlain students for FREE by downloading from the student portal at http://my.chamberlain.edu (Links to an external site.)Links to an external site.. Click on the envelope at the top of the page.

You are required to cite your source(s) as it relates to your application slide. Other citations are permitted, but this is not a requirement for the assignment.

Title slide (first slide): Include a title slide with your name and the title of the presentation.

Scenario Slide (one slide): This slide should include a brief scenario, then identify a patient who is experiencing a specific disease process or diagnosis who would benefit from an already developed and reliable mHealth app. Or it could identify a person who is currently healthy and would like to maintain or improve health and prevent illness. Be sure to include the nurse’s assessment of the patient’s learning needs and readiness to learn. Be specific.

Example:

Scenario for Ms. Ellis

Jane Doe (your name here)

Jennifer Ellis, a 62-year-old African American woman, has been recently diagnosed with chronic kidney disease (CKD). She has been prescribed several medications she must take every day.

The nephrologist has stressed the importance of leading a healthy lifestyle to slow or stop the progression of CKD.

She is interested in ways in which she can better track her health and make healthier choices.

She is a high school graduate and iPhone user, mostly to send text messages to family and friends.

She is eager to learn how to use an app that can help her manage her CKD.

Prepare the following slides as if you are presenting them to the patient.

mHealth application slide (one to three slides): Identify a developed and reliable mHealth app that could benefit the patient. Describe the app, including the following.

Name

Purpose

Intended audience

Mobile device(s) upon which it will operate

Where to download or obtain it (include a working link if it is to be downloaded from a website)

Any other information you believe would be pertinent to this situation

Be sure to cite all sources you use.

Teaching slides (one to three slides): Prepare slides that contain important points about the app that you want to teach to the patient, such as how to use the app safely and effectively (including how to interpret and act on the information that is provided).

Evaluation slide (one to three slides): Describe how you would determine the success of the patient’s use of this app. For example, include ways to evaluate the effectiveness of the teaching plan that are a good fit for the type of app or focus on specific ways that this app benefits the patient’s health and wellness.

References (last slide): List any references for sources that were used or cited in the presentation.

Writing and design: There should be no spelling or grammatical errors. Writing is concise and clear. Avoid words that the patient may not understand. Slides are visually appealing, incorporating graphics, photographs, colors, and themes.

Review the section on Academic Integrity Policy found in the RNBSN Policies. All work must be original (in your own words) unless properly cited.

Best Practices in Preparing PowerPoint Slideshows

Be creative but realistic.

Incorporate graphics, color, themes, or photographs to increase interest.

Make it easy to read with short bullet points and large font.

Review directions thoroughly.

Cite all sources within the slides with (author, year), as well as on the reference slide.

Proofread prior to final submission.

Check for spelling and grammar errors prior to final submission.

Abide by the Chamberlain academic integrity policy.

Tutorial: For those not familiar with the development of a PowerPoint slideshow, the following link to the Microsoft website may be helpful. http://office.microsoft.com/en-us/support/training-FX101782702.aspx (Links to an external site.)Links to an external site. The Chamberlain Student Success Strategies (CCSSS) offers a module on Computer Literacy that contains a section on PowerPoint. The link to SSPRNBSN may be found in your student portal.

NR361 RN Information Systems in Healthcare

Week 4 Information Systems Paper

Purpose

The purpose of this assignment is explore the assigned topic related to information systems in healthcare, research and analyze the topic, and describe how you will apply your new found knowledge to your nursing practice.

Course Outcomes

This assignment enables the student to meet one or more of the following Course Outcomes depending on the topic selected.

CO1: Describe patient-care technologies as appropriate to address the needs of a diverse patient population. (PO1)

CO2: Analyze data from all relevant sources, including technology, to inform the delivery of care. (PO2)

CO3: Define standardized terminology that reflects nursing’s unique contribution to patient outcomes. (PO3)

CO4: Investigate safeguards and decision-making support tools embedded in patient care technologies and information systems to support a safe practice environment for both patients and healthcare workers. (PO4)

CO5: Identify patient care technologies, information systems, and communication devices that support safe nursing practice. (PO5)

CO 6: Discuss the principles of data integrity, professional ethics, and legal requirements related to data security, regulatory requirements, confidentiality, and client’s right to privacy. (PO6)

CO7: Examine the use of information systems to document interventions related to achieving nurse sensitive outcomes. (PO7)

CO8: Discuss the value of best evidence as a driving force to institute change in delivery of nursing care. (PO8)

Points

This assignment is worth a total of 200 points.

Due Date

Your completed paper is due by 11:59 p.m. MT Sunday by the end of Week 4.

Be sure to submit your assignment. Post your questions to the Q & A Forum. Contact your instructor if you need additional assistance. See the Course Policies regarding late assignments and academic integrity. Failure to submit your paper on time will result in a deduction of points.

Topic

Topic for the focus of your paper.

Robotics in Healthcare (CO5, CO8)

Directions

You are required to complete the form using the productivity tools required by Chamberlain University, which is Microsoft Office 2013 (or later version), or Windows and Office 2011 (or later version) for MAC. You must save the file in the “.docx” format. Do NOT save as Word Pad. A later version of the productivity tool includes Office 365, which is available to Chamberlain students for FREE by downloading from the student portal at http://my.chamberlain.edu (Links to an external site.)Links to an external site.. Click on the envelope at the top of the page.

You are to research, analyze, and write an APA-formatted scholarly paper on Robotics in Healthcare.

Click on the APA template (Links to an external site.)Links to an external site. to complete this assignment.

Write an introduction that defines and describes the topic. Address what purpose the topic serves and how it impacts the delivery of healthcare in general and nursing care in particular.

Search for scholarly sources and relevant websites. Include a minimum of two scholarly sources. The course textbook does not qualify as a scholarly source. Cite all sources in the body of the paper and include them in the References list following proper APA formatting.

Provide one example of this topic. Describe the main features or aspects of the example with support from your sources. If you haven’t used this before, think of how this could benefit clinical practice.

Describe an experience where the topic impacted you personally, either when you were receiving healthcare or when you were providing nursing care. Relate one positive aspect or one negative aspect of this experience and how it could have been improved. If you haven’t used this before, think of how this could benefit clinical practice.

Write a conclusion that summarizes the topic, the purpose, and how your newfound insight will influence your nursing care.

Use the APA template above to develop your paper. Use APA formatting. Refer to the Publication manual of the APA, sixth edition. Review the various APA documents included in this course and the SSPRNBSN Student Success course that can help you with your writing. Take advantage of the tutoring services that are available to Chamberlain students for free.

The length of the paper should be a maximum of 4-5 pages, excluding the title page and the reference page. There should only be one small quote maximum in the paper. Citations should primarily include summary and restatement.

NR361 RN Information Systems in Healthcare

Week 6 Interview With a Nurse Information Expert

Purpose

The purpose of this assignment is to

communicate your understanding of the importance of quality information in everyday nursing practice;

discuss the roles and responsibilities of a nursing information expert; and

articulate how the professional nurse uses information and data in everyday practice to improve outcomes.

Course Outcomes

This assignment enables the student to meet the following Course Outcomes.

CO1: Describe patient-care technologies as appropriate to address the needs of a diverse patient population. (PO1)

CO4: Investigate safeguards and decision-making support tools embedded in patient care technologies and information systems to support a safe practice environment for both patients and healthcare workers.

CO8: Discuss the value of best evidence as a driving force to institute change in delivery of nursing care. (PO8)

Points

This assignment is worth a total of 225 points.

Due Date

This assignment, Interview With a Nursing Information Expert, is due in Week 6. Post questions to the Q & A Forum. Contact your instructor if you need additional assistance. See the Policies regarding late assignments. Failure to submit your paper on time will result in a deduction of points. Be sure to submit your assignment.

Directions

Download the required NR361 Interview Form (Links to an external site.)Links to an external site., which will be used to complete this assignment.

You are required to complete the form using the productivity tools required by Chamberlain University, which is Microsoft Office 2013 (or later version), or Windows and Office 2011 (or later version) for MAC. You must save the file in the “.docx” format. Do NOT save as Word Pad. A later version of the productivity tool includes Office 365, which is available to Chamberlain students for FREE by downloading from the student portal at http://my.chamberlain.edu (Links to an external site.)Links to an external site.. Click on the envelope at the top of the page.

Select your interviewee and schedule an interview. This individual must be a Registered Nurse. Job titles of RNs who may be considered include, but are not limited to, nursing clinical information manager, super user, director/manager clinical education, chief information officer, quality assurance or performance improvement nurse, nurse informaticist, telenursing specialist, nurse abstractor, case manager, or compliance nurse. If you have any concerns about whether the RN is suitable for this assignment, contact your instructor before you schedule the interview.

Review all questions (areas of inquiry) on the Interview Form prior to conducting the interview. You may print the form and take it with you to the interview.

Note that there are five required questions to ask the RN.

Note that there are four optional questions. You need to select only one of these to ask the RN.

Note that there are two follow-up questions you must answer.

Prior to conducting your interview, review two scholarly resources. These resources should guide your understanding of the RN’s role and responsibilities or make you more knowledgeable about GIGO, interprofessional communication, or other key concepts in the questions that you may not fully understand. For example, if your interviewee is a telenurse, you would want to review information on this specialty. If you do not know what GIGO means, look it up.

Conduct your interview. The length of your interview will vary but should not exceed 1 hour.

Submit the completed interview form prior to the deadline outlined above.

BUS 308 Week 2 Assignment

The ongoing question that the weekly assignments will focus on is: Are males and females paid the same for equal work (under the Equal Pay Act)?
Note: to simplfy the analysis, we will assume that jobs within each grade comprise equal work.

The column labels in the table mean:
ID – Employee sample number Sal – Salary in thousands
Age – Age in years
EES – Appraisal rating (Employee evaluation score)
SER – Years of service
G – Gender (0 = male, 1 = female)
Mid – salary grade midpoint Raise – percent of last raise
Grade – job/pay grade
Deg (0= BSBA 1 = MS)
Gen1 (Male or Female)
Compa – salary divided by midpoint, a measure of salary that removes the impact of grade
This data should be treated as a sample of employees taken from a company that has about 1,000
employees using a random sampling approach.
Mac Users: The homework in this course assumes students have Windows Excel, and
can load the Analysis ToolPak into their version of Excel.
The analysis tool pak has been removed from Excel for Windows, but a free third-party
tool that can be used (found on an answers Microsoft site) is:
http://www.analystsoft.com/en/products/statplusmacle
Like the Microsoft site, I make cannot guarantee the program, but do know that
Statplus is a respected statistical package. You may use other approaches or tools
as desired to complete the assignments.

Week 1. Describing the data.

1 Using the Excel Analysis ToolPak function descriptive statistics, generate and show the descriptive statistics for each appropriate variable in the sample data set.
a. For which variables in the data set does this function not work correctly for? Why?
2

Sort the data by Gen or Gen 1 (into males and females) and find the mean and standard deviation for each gender for the following variables:
sal, compa, age, sr and raise. Use either the descriptive stats function or the Fx functions (average and stdev).

3

What is the probability for a:
a.
Randomly selected person being a male in grade E?
b. Randomly selected male being in grade E?
c. Why are the results different?

4

5

Find:
a. The z score for each male salary, based on only the male salaries.
b. The z score for each female salary, based on only the female salaries.
c. The z score for each female compa, based on only the female compa values.
d. The z score for each male compa, based on only the male compa values.
e. What do the distributions and spread suggest about male and female salaries?
Why might we want to use compa to measure salaries between males and females?
Based on this sample, what conclusions can you make about the issue of male and female pay equality?
Are all of the results consistent with your conclusion? If not, why not?

W eek 2
Testing means with the t-test

For questions 2 and 3 below, be sure to list the null and alternate hypothesis statements. Use .05 for your significance level in making your decisions.
For full credit, you need to also show the statistical outcomes – either the Excel test result or the calculations you performed.
1

Below are 2 one-sample t-tests comparing male and female average salaries to the overall sample mean.
Based on our sample, how do you interpret the results and what do these results suggest about the population means for male and female salaries?
Males
Females
Ho: Mean salary = 45
Ho: Mean salary = 45
Ha: Mean salary =/= 45
Ha: Mean salary =/= 45
Note when performing a one sample test with ANOVA, the second variable (Ho) is listed as the same value for every corresponding value in the data set.
t-Test: Two-Sample Assuming Unequal Variances
t-Test: Two-Sample Assuming Unequal Variances
Since the Ho variable has Var = 0, variances are unequal; this test defaults to 1 sample t in this situation
Male
Ho
Female
Ho
Mean
52
45
Mean
38
45
Variance
316
0
Variance
334.6667
0
Observations
25
25
Observations
25
25
Hypothesized Mean Difference 0
Hypothesized Mean Difference
0
df
24
df
24
t Stat
1.968903827
t Stat
-1.91321
P(T<=t) one-tail
0.03030785
P(T<=t) one-tail
0.033862
t Critical one-tail
1.71088208
t Critical one-tail 1.710882
P(T<=t) two-tail
0.060615701
P(T<=t) two-tail
0.067724
t Critical two-tail
2.063898562
t Critical two-tail 2.063899
Conclusion: Do not
Conclusion: Do not
reject Ho; mean
reject Ho; mean
equals 45
equals 45
Males
The way that I interpret the results are that since the p-value =.061 is greater than the alpha = .05 it tells me that there is insufficient evidence to make the claim that the average salary of males is significantly different than the average for all employees.
Females
The way that I interpret the results are that since the p-value =.068 is greater than the alpha = .05 it tells me that there is insufficient evidence to make the claim that the average salary of males is significantly different than the average for all employees.

2

Based on our sample results, perform a 2-sample t-test to see if the population male and female salaries could be equal to each other.
t-Test : Two-sample Assuming equal variances
Male-salay

Female-salary
mean
52
38
Variance
316 334.6667
Observations
25
25
Pooled Variance
325.3333
Hypothesized mean Difference 0
degree of freedom
48
t-Stat
2.744219
0.004253
P(T ? t) one-tail
t Critical one-tail
1.677224
P(T ? t) Two-tail
0.008506
t Critical two-tail

t-Test : Two-sample Assuming Unequal variances
Male-salay emale-salary
F
mean
52
38
Variance
316 334.6667
Observations
25
25
Hypothesized mean Difference
0
degree of freedom
48
t-stat
2.744219
P(T ? t) one-tail
0.004253
t Critical one-tail
1.67724
P(T ? t) Two-tail
0.008506
t Critical two-tail
2.010635

2.010635

Based on the results of the 2-sample t-test the p-value =.008 and being less than alpha which is .05 that tells me that there is sufficient evidence that indicates the average salaries of males and females significantly different.
3

Based on our sample results, can the male and female compas in the population be equal to each other? (Another 2-sample t-test.)
t-Test: Two-Sample Assuming Equal Variances

t-Test: Two-Sample Assuming UnEqual Variances

Male-compa Female-compa
Mean
1.05624
1.06872
Variance
0.007021
0.004948
Observations
25
25
Pooled Variance
0.005984
Hypothesized mean Difference
0
degree of freedom
48
t-Stat
-0.57037
P(T ? t) one-tail
0.285544
t Critical one-tail
1.677224
P(T ? t) Two-tail
0.571088
t Critical two-tail
2.010635

Male-compaemale-compa
F
Mean
1.05624 1.06872
Variance 0.007021 0.004948
Observations
25
25
Hypothesized mean 0
Difference
degree of freedom 48
t-Stat
-0.57037
P(T ? t) one-tail
0.285572
t Critical one-tail
1.677927
P(T ? t) Two-tail
0.571144
t Critical two-tail
2.011741

Based on the sample results the p-value =.571 is greater than the alpha = .05 tells me that there is insufficient
evidence to indicate the average compa’s of males and females are significantly different, which also tells me
that the male and female compass are equal.
4

What other information would you like to know to answer the question about salary equity between the genders? Why?
The other information that would be needed to answer the question is about salary equity between the
genders are, years of service, degree, performance rating, and experience. All of these attributes are important
w hen salaries are negotiated and agreed upon

5

If the salary and compa mean tests in questions 3 and 4 provide different results about male and female salary equality,
w hich would be more appropriate to use in answering the question about salary equity? Why?
What are your conclusions about equal pay at this point?
The mean test in questions 3 & 4 do give different conclusions.
The reason why, is that by using the compa it removes the impact of grade.
In my conclusions the better of the two t-test is the one which compares the comp’s.

Week 3
Testing multiple means with ANOVA

For questions 3 and 4 below, be sure to list the null and alternate hypothesis statements. Use .05 for your significance level in making your decisions.
For full credit, you need to also show the statistical outcomes – either the Excel test result or the calculations you performed.
1.

Based on the sample data, can the average(mean) salary in the population be the same for each of the grade levels? (Assume equal variance, and use the analysis toolpak function ANOVA.)
Set up the input table/range to use as follows: Put all of the salary values for each grade under the appropriate grade label.
Be sure to incllude the null and alternate hypothesis along with the statistical test and result.
Note: Assume equal variances for all grades.
A
B
C
D
E
F

2.

The table and analysis below demonstrate a 2-way ANOVA with replication. Please interpret the results.
Grade
Gender
A
B
C
D
E
F
The salary values were randomly picked for each cell.
M
24
27
40
47
56
76
25
28
47
49
66
77
F
22
34
41
50
65
75
24
36
42
57
69
77
Ho: Average salaries are equal for all grades
Ha: Average salaries are not equal for all grades
Ho: Average salaries by gender are equal
Ha: Average salaries by gender are not equal
Ho: Interaction is not significant
Ha: Interaction is significant
Perform analysis:
Anova: Two-Factor With Replication
SUMMARY
A
M
Count
Sum
Average
Variance

B

C

D

E

F

Total

2
49
24.5
0.5

2
55
27.5
0.5

2
87
43.5
24.5

2
96
48
2

2
122
61
50

2
12
153
562
76.5 46.83333
0.5 364.5152

2
46
23
2

2
70
35
2

2
83
41.5
0.5

2
107
53.5
24.5

2
134
67
8

2
12
152
592
76 49.33333
2 367.3333

F
Count
Sum
Average
Variance

Total
Count
4
4
4
4
4
4
Sum
95
125
170
203
256
305
Average
23.75
31.25
42.5
50.75
64
76.25
Variance
1.58333 19.5833 9.66667 18.9167 31.3333 0.916667
ANOVA
Source of VariationSS
Sample
37.5
Columns
7841.83
Interaction
91.5
Within
117
Total

8087.83

df

MS
F
P-value F crit
1
37.5 3.84615 0.07348 4.747225
5 1568.37 160.858 1E-010 3.105875
5
18.3 1.87692 0.17231 3.105875
12
9.75

Note: a number with an E after it (E9 or E-6, for example)
means we move the decimal point that number of places.
For example, 1.2E4 becomes 12000; while 4.56E-5 becomes 0.0000456

23

Do we reject or not reject each of the null hypotheses? What do your conclusions mean about the population values being tested?
Interpretation:

3.

Using our sample results, can we say that the compa values in the population are equal by grade and/or gender, and are independent of each factor?
Be sure to include the null and alternate hypothesis along with the statistical test and result.
Grade

Gender
A
B
C
D
E
F
for the intersection of M and A might be 1.043.>
M

salary values used in question 2 for a more direct comparison of the two
F
outcomes.>
Conduct and show the results of a 2-way ANOVA with replication using the completed table above. The results should look something like those in question 2.
Interpret the results. Are the average compas for each gender (listed as sample) equal? For each grade? Do grade and gender interaction impact compa values?

4.

Pick any other variable you are interested in and do a simple 2-way ANOVA without replication. Why did you pick this variable and what do the results show?
Variable name:
Be sure to include the null and alternate hypothesis along with the statistical test and result.
Gender
A
B
C
D
E
F
Hint: use mean values in the boxes.
M
F

5.

Using the results for this week, What are your conclusions about gender equal pay for equal work at this point?

Week 4
Confidence Intervals and Chi Square (Chs 11 – 12)Let’s look at some other factors that might influence pay.
For question 3 below, be sure to list the null and alternate hypothesis statements. Use .05 for your significance level in making your decisions.
For full credit, you need to also show the statistical outcomes – either the Excel test result or the calculations you performed.
One question we might have is if the distribution of graduate and undergraduate degrees independent of the grade the employee?
(Note: this is the same as asking if the degrees are distributed the same way.)
Based on the analysis of our sample data (shown below), what is your answer?
Ho: The populaton correlation between grade and degree is 0.
Ha: The population correlation between grade and degree is > 0
Perform analysis:
A
B
C
D
E
F
Total
OBSERVED
7
5
3
2
5
3
25
COUNT – M or 0
8
2
2
3
7
3
25
COUNT – F or 1
15
7
5
5
12
6
50
total
EXPECTED
7.5
3.5
2.5
2.5
6
3
25

7.5
3.5
2.5
2.5
6
3
25
is found: row total times column total divided by
15
7
5
5
12
6
50
grand total.>
1

By using either the Excel Chi Square functions or calculating the results directly as the text shows, do we
reject or not reject the null hypothesis? What does your conclusion mean?
Interpretation:
Using our sample data, we can construct a 95% confidence interval for the population’s mean salary for each gender.
Interpret the results. How do they compare with the findings in the week 2 one sample t-test outcomes (Question 1)?
Males
Mean St error
Low
to
High
52
3.65878
44.4483
59.5517
Results are mean +/-2.064*standard error
Females
38
3.62275
30.5226
45.4774
2.064 is t value for 95% interval

2

Interpretation:
3

Based on our sample data, can we conclude that males and females are distributed across grades in a similar pattern within the population?

4

Using our sample data, construct a 95% confidence interval for the population’s mean service difference for each gender.
Do they intersect or overlap? How do these results compare to the findings in week 2, question 2?

5

How do you interpret these results in light of our question about equal pay for equal work?

Week 5 Correlation and Regression
For each question involving a statistical test below, list the null and alternate hypothesis statements. Use .05 for your significance level in making your decisions.
For full credit, you need to also show the statistical outcomes – either the Excel test result or the calculations you performed.
1

Create a correlation table for the variables in our data set. (Use analysis ToolPak function Correlation.)
a. Interpret the results. What variables seem to be important in seeing if we pay males and females equally for equal work?

2

Below is a regression analysis for salary being predicted/explained by the other variables in our sample (Mid,
age, ees, sr, raise, and deg variables.) (Note: since salary and compa are different ways of
expressing an employee’s salary, we do not want to have both used in the same regression.)
Ho: The regression equation is not significant.
Ha: The regression equation is significant.
Ho: The regression coefficient for each variable is not significant
Ha: The regression coefficient for each variable is significant
Sal
SUMMARY OUTPUT

The analysis used Sal as the y (dependent variable) and
mid, age, ees, sr, g, raise, and deg as the dependent
variables (entered as a range).

Regression Statistics
Multiple R 0.992154976
R Square 0.984371497
Adjusted R Square 0.981766746
Standard Error 2.592776307
Observations
50
ANOVA
df
Regression
Residual
Total

SS
MS
F
Significance F
7 17783.66 2540.522 377.9139 8.440427E-036
42 282.3445 6.722489
49
18066

Coefficients
Intercept
-4.009
Mid
1.220
Age
0.029
EES
-0.096
SR
-0.074
G
2.552
Raise
0.834
Deg
1.002

Standard
Error
3.775
0.030
0.067
0.047
0.084
0.847
0.643
0.744

t Stat
-1.062
40.674
0.439
-2.020
-0.876
3.012
1.299
1.347

P-value
0.294
0.000
0.663
0.050
0.386
0.004
0.201
0.185

Lower 95%
-11.627
1.159
-0.105
-0.191
-0.244
0.842
-0.462
-0.500

Upper 95% Lower 95.0% Upper 95.0%
3.609
-11.627
3.609
1.280
1.159
1.280
0.164
-0.105
0.164
0.000
-0.191
0.000
0.096
-0.244
0.096
4.261
0.842
4.261
2.131
-0.462
2.131
2.504
-0.500
2.504

Interpretation: Do you reject or not reject the regression null hypothesis?
Do you reject or not reject the null hypothesis for each variable?
What is the regression equation, using only significant variables if any exist?
What does result tell us about equal pay for equal work for males and females?
3

Perform a regression analysis using compa as the dependent variable and the same independent
variables as used in question 2. Show the result, and interpret your findings by answering the same questions.
Note: be sure to include the appropriate hypothesis statements.

4

Based on all of your results to date, is gender a factor in the pay practices of this company? Why or why not?
Which is the best variable to use in analyzing pay practices – salary or compa? Why?

5

Why did the single factor tests and analysis (such as t and single factor ANOVA tests on salary equality) not provide a complete answer to our salary equality question?
What outcomes in your life or work might benefit from a multiple regression examination rather than a simpler one variable test?

week 1

Data are placed onto the media by encoding them. Discuss some of the methods commonly used for encoding data onto wired and wireless media.

Which type of medium is best for a data network? Explain why.

week 2

What are the categories of UTP cabling commonly seen in networks?

What are the various types of connectors used on UTP and fiber-optic cable? How are they the same and how are they different?

week 3

What are some of the main structured cabling standards? Why are these guidelines so important to follow when installing media and equipment inside of a building?

What are some of the tests used to ensure that UTP cable has been properly terminated and installed? What is the main test for fiber-optic cable?

week 4

What types of media are appropriate for use in the outside plant? What would you use, and where?

What outside plant installation methods are commonly used?

week 5

What is a protocol analyzer? What are the common models of this tool?

What frames are commonly used in LANs? What frames are commonly used in WANs?

week 6

What is flow control? Where should flow control be done?

How is error detection accomplished at the data link layer?

week 7

In what ways can a protocol analyzer assist in troubleshooting a network problem?

What tools other than a protocol analyzer are available to assist in troubleshooting a network problem?

iLab 1: Examine the Physical Layer (70 points)

Note!

Submit your assignment to the Dropbox, located at the top of this page.

(See the Syllabus section “Due Dates for Assignments & Exams” for due dates.)

iLAB OVERVIEW

Scenario/Summary

In this first week of the course, we are discussing the signals seen at Layer 1, the physical layer, of the OSI model. For wired media, such as a UTP cable used in a local area network or a fiber-optic cable used to interconnect local area networks inside of a building, the signal is not easily viewed with the tools a network manager would have access to, nor would such viewing aid him or her in diagnosing and correcting problems on the network. However, for the wireless signals that we are seeing used more and more, these are easily viewed by using a low-cost spectrum analyzer. In this iLab, we will look at the different types of spectrum analyzers, look at typical signals seen on them, and then use one of them to examine wireless signals.

This iLab is in two parts. In Part 1, you will learn how to use the tool required to conduct analysis such as this in the real world. In Part 2, you will watch a video that shows common wireless signals. The grade for Part 1 is based on your successful completion of a set of questions demonstrating that you understand what a spectrum analyzer is and what type of information it displays to the network manager. The grade for Part 2 is based on your ability to use what you learned in Part 1 to identify and classify common waveforms seen in typical wireless local area networks.

Deliverables

You are required to submit a lab report to the Week 1 Dropbox.

Required Software

None

iLAB STEPS

STEP 1: Learn What a Spectrum Analyzer

Back to Top

Part 1—What a Spectrum Analyzer Is and How to Use It

Watch each of these videos in order to learn about spectrum analysis.

Types of Spectrum AnalyzersPlay00:00MuteFullscreen

Transcript

Recognizing the Noise FloorPlay00:00MuteFullscreen

Transcript

Recognizing Unlicensed Bands SignalsPlay00:00MuteFullscreen

Transcript

Recognizing Co-Channel InterferencePlay00:00MuteFullscreen

Transcript

Recognizing Adjacent Channel InterferencePlay00:00MuteFullscreen

Transcript

Recognizing All Channel InterferencePlay00:00MuteFullscreen

Transcript

Part 2—Identify and Classify Common Waveforms

Watch this video and then answer the question on the lab report template based on what you see.

Identify and Classify Common WaveformsPlay00:00MuteFullscreen

NETW 310 Week 1 Lab Report

Answer each of the question listed below on page 2.

Create your report using the template starting on page 2 and submit it to the Week 1 Dropbox by the due date.

In order to be eligible to receive full credit, you must write in complete sentences and use the lab report template. Answers that are NOT written in complete sentences will receive point deductions.

Use a red-coloredfont for you answers.

REMOVE THIS PAGE BEFORE YOU TURN IN YOUR DELIVERABLE AS IT IS INSTRUCTIONS ONLY.
Your Name:

NETW 310, Professor’s Name

DATE

Lab #1, Examine the Physical Layer

Lab Report

This assignment has 17 questions that are equally weighted. Each answer is worth 4 points. Using the template and completing the header are worth 2 points on your grade for this assignment.

Use a red-coloredfont for you answers. Answers that are NOT written in complete sentences will receive point deductions.

In order to be eligible to receive full credit, you must write in complete sentences and use the lab report template.

Place your answers in the template below the questions.

1. What is a spectrum analyzier used for in terms of wireless and wired networking?
2. An oscilloscope has a screen that has a horizontal and vertical axis that shows ampliture (in volts) and time ( in seconds) respectively. It operates in what is called the TIME DOMAIN.

A spectrum analyzer (example shown above) has a screen whose horizontal and vertical axis show what two things? What are the units of these two? What domain is a spectrum analyzer.

Spectrum Analyzer horizontal axis: ______________________

Spectrum Analyzer vertical axis: ______________________

Spectrum Analyzer units for horizontal axis: ______________________

Spectrum Analyzer units for vertical axis: ______________________

Spectrum Analyzer shows the ______________________ domain

3. Match the screen of the spectrum analyzer and the oscilloscope with which view of a sine wave shows up for each one. Which one would show a? Which one would show b?

Oscilloscope: ______________________

Spectrum Analyzer: ______________________

4. What is the difference between BANDWIDTH that shows up on the screen of a spectrum analyzer and CHANNELS that show up on the screen of a spectrum analyzer?
5. What does dB stand for? How do you calculate dB?

HINT: What is the formula for dB?

6. Is dB a linear scale or a logarithmic scale? What does this mean?Are there any advantages to using this?

HINT: What does it mean to have a linear scale? What does it mean to have a logarithmic scale? What are the advantages or disadvantages of these?

7. What is GAIN and LOSS in terms of dB?

HINT: What does this mean in terms of dB? Think of how dB is used for an audio system for example. What does this mean in terms of negative or positive dB?

8. This question refers to the video tutorial. There are three patterns outlined on the screen which one of these is identifying the noise floor? NOTE: You are to give the PATTERN number ( 1 – 4), not state which panel/range/view it is shown in.

HINT: Look at Video: Recognizing the Noise Floor Video

9. This question refers to the video tutorial. What is the approximate signal level of the noise floor? HINT: You are looking for the amplitude in (negative) dB.

HINT: Look at Video: Recognizing the Noise Floor Video

10. This question refers to the video tutorial. Of the 11 channels being displayed which ones have the lowest noise floor?

HINT: Look at Video: Recognizing the Noise Floor Video
HINT: The tapering area on the far right edge is due to the fact that 2.4 GHz signal ends at channel 11. So look at what is under channel 11.

11. This question refers to the video tutorial. Inside the circle marked as Pattern 2 is this a signal from one of the three unlicensed fequency ranges? What channels are shown?

HINT: Look at Video: Recognizing Unlicensed Bands Signals Video

12. This question refers to the video tutorial and question 11 above. If it is, what type of signal is this, 900 MHz, 2.4GHz, or 5 GHz?

HINT: Look at Video: Recognizing Unlicensed Bands Signals Video and what channels are shown in Pattern 2.

13. This question refers to the video tutorial. Inside the circle marked as Pattern 3 is this a signal from one of the three unlicensed signal ranges? HINT: What range is shown here for Pattern 3?

HINT: Look at Video: Recognizing Unlicensed Bands Signals Video and what channels are shown in Pattern 3.

14. This question refers to the video tutorial and question 13 above. If it is, what type of signal is this, 900 MHz, 2.4GHz, or 5 GHz?

HINT: Look at Video: Recognizing Unlicensed Bands Signals Video and what channels are shown in Pattern 3.

15. This question refers to the video tutorial. In the area marked as Pattern 4 some interference has appeared. What type of interference is this, such as all-channel, co-channel, adjacent-channel?

HINT: See Videos: Recognizing Adjacent Channel Interference Video (and Recognizing Co-Channel Interference Video, and Recognizing All Channel Interference Video)

16. This question refers to the video tutorial. On what channel has this interference appeared on?

HINT: See Videos: Recognizing Adjacent Channel Interference Video (and Recognizing Co-Channel Interference Video, and Recognizing All Channel Interference Video)

17. This question refers to the video tutorial and questions 15 and 16 above.. Is this interference weaker than, the same, or stronger than the signal that was there before it appeared?

HINT: See Videos: Recognizing Adjacent Channel Interference Video (and Recognizing Co-Channel Interference Video, and Recognizing All Channel Interference Video). Loook at the signal strength.

iLab 2: Terminating Category 5e and 6 UTP Cable (70 points)

Note!

Submit your assignment to the Dropbox, located at the top of this page.

(See the Syllabus section “Due Dates for Assignments & Exams” for due dates.)

iLAB OVERVIEW

Scenario/Summary

For this week’s iLab, you will watch two videos on terminating Category 5e and 6 UTP cable. To start watching the videos, go to the Tutorial Box and click on the Terminating Category 5e UTP Cable blue link. After you have watched it, then click on the Terminating Category 6 UTP Cable blue link. Click on START in the lower right-hand corner when the page displays.

Deliverables

You are required to submit a lab report to the Week 2 Dropbox.

Required Software

None

iLAB STEPS

STEP 1

Back to Top

Watch the tutorials on terminating Category 5e and Category 6 UTP Cable.

Terminating Category 5e CablePlay00:00MuteFullscreen

Terminating Category 6 UTP CablePlay00:00MuteFullscreen

STEP 2

Back to Top

Download this week’s lab report template.

STEP 3

Back to Top

Answer the questions on terminating UTP cabling.

STEP 4

Back to Top

Submit your completed report to the Dropbox.

Submit your lab to the Dropbox, located at the top of this page. For instructions on how to use the Dropbox, read these step-by-step instructionsor watch this TutorialDropbox Tutorial.

See the Syllabus section “Due Dates for Assignments & Exams” for due date information.

<pclass=”msonormal” style=”box-sizing: border-box; overflow-wrap: break-word;”>NETW 310 Week 2 Lab Report</pclass=”msonormal”>

To complete your Week 2 Lab Report, answer the ten questions concerning the procedure involved and the advantage of wiring standards.

Create your report using the template starting on page 2 and submit it to the Week 2 Dropbox by the due date.
Your Name

NETW 310, Professor’s Name

Current Date

Lab #2, Terminating Category 5e and Category 6 UTP Cable

Lab Report

Each answer is worth seven points.

Use a red colored font for you answers.

Place the answers below the questions.

1. In the videos you just watched where is the color code to use for the jack shown?
2. For the wires how many possible termination color code methods are there?
3. How many wires are there in a UTP cable?
4. What colors are used on these wires?
5. The punch down tool used to insert the wires into a jack such as this does what two things to each wire?
6. What is the most critical part of the termination procedure to ensure low crosstalk on the connection?
7. How is the outer insulation covering each wire cut through during the termination procedure?
8. Which termination color code method is used in this example?
9. In which video is the wire separation tower shown?
10. Where are the pin numbers shown on the jack with the wire separation towers?

<pclass=”msonormal” style=”box-sizing: border-box; overflow-wrap: break-word;”></pclass=”msonormal”>

iLab 3: Installing Structure Cabling (70 points)

Note!

Submit your assignment to the Dropbox, located at the top of this page.

(See the Syllabus section “Due Dates for Assignments & Exams” for due dates.)

iLAB OVERVIEW

Scenario/Summary

For this week’s iLab, you will watch a video on Installing Structured Cabling. To start watching the video, go to the Tutorial Box and click on the Installing Structured Cabling blue link. Click on START in the lower right-hand corner when the page displays.

Deliverables

You are required to submit a lab report to the Week 3 Dropbox.

Required Software

None

iLAB STEPS

STEP 1: Watch the Video

Back to Top

Watch the video on installing structured cabling below.

Installing Structured Cabling

This video provides you with examples of the correct and incorrect ways to install the various aspects of a structured cabling system in a typical office building.
Click here, or on the image to the right, to begin.

STEP 2: Download the Lab Report Template

Back to Top

Download this week’s lab report template.

STEP 3: Answer the Questions

Back to Top

Answer the questions concerning what is shown.

STEP 4: Submit Your Work

Back to Top

Submit your completed report to the Week 3 Dropbox.

Submit your lab to the Dropbox, located at the top of this page. For instructions on how to use the Dropbox, read these step-by-step instructionsor watch this TutorialDropbox Tutorial.

See the Syllabus section “Due Dates for Assignments & Exams” for due date information.

<pclass=”msonormal” style=”box-sizing: border-box; overflow-wrap: break-word;”>NETW 310 Week 3 Lab Report

To complete your Week 3 lab report, discuss the questions below concerning the installation of structured cabling.

Create your report using the template starting on page 2 and submit it to the Week 3 Dropbox by the due date.
Your Name

NETW 310, Professor’s Name

Current Date

Lab #3, Installation of Structured Cabling

Lab Report

Each answer is worth 2.8 points.

Use a red colored font for you answers.

Place the answers below the questions

1. How often are network standards reviewed?
2. What category of UTP cabling is the minimum for a telephone cable?
3. What category of cabling should be installed as a best practice for a telephone cable?
4. What is the problem with leaving abandoned cable in place in a building?
5. Why must the twisting in the individual wires be maintained in a UTP cable?
6. How many wires does a gigabit cable use?
7. Is the labeling standard commonly used or not used?
8. Grounding should be attached to what in the building?
9. Horizontal cabling connects what areas to each other?
10. What is a plenum rated cable?
11. What is a riser tube used for?
12. What is the code for plenum rated horizontal cable?
13. How many wires in a UTP cable does Fast Ethernet use?
14. How many inches should separate UTP cable from 120 volt electrical cable?
15. What is the reason for grounding jumpers on each connection in ladder rack?
16. Why should overfilling of a riser tube be avoided?
17. Is the grounding of equipment a safety or a performance concern?
18. What are the current recognized horizontal cabling categories?
19. May an existing Category 5 cable be used to make network connections?
20. In the example used here what does the firestop material consist of?
21. In what circumstances will poorly installed cabling still function?
22. Why should the outer cover on a UTP cable be maintained in place?
23. Does cable labeling impact network performance?
24. May CM cable be used in the plenum space?
25. Why should a plastic riser tube not be used?

iLab 4: Outside Plant Installation (70 points)

Note!

Submit your assignment to the Dropbox, located at the top of this page.

(See the Syllabus section “Due Dates for Assignments & Exams” for due dates.)

iLAB OVERVIEW

Scenario/Summary

For this week’s lab, you be looking at “Right of Way” issues that deal with outside plant installations in a “real” scenario.

You will be using the Right of Way manual developed by the city of Burleson, Texas to determine what requirements the local jurisdiction has in the case of a new installation of media and what rules you will need to follow to complete the installation project. In this example, a city street must be crossed to interconnect two buildings to each other. Therefore, the local jurisdiction does cover Right of Way issues.

Here is the scenario.

You are the network manager for the local school district. Due to growth in the city, one of the elementary schools has run out of classroom space. Across a city street from this elementary school, there is a church that is for sale. The school district is considering purchasing this church as a low-cost way to expand the space in the elementary school. The local-area networks in the two buildings will have to be connected to each other. Due to the school district’s data-security policy, the connection must be made using wired media. To install this media, the city street between the two buildings must be crossed. This crossing will be underground. Here is the relationship of the two buildings.

etwork manager, you will have done a feasibility study and are now at the point of looking at vendors, timelines, and project specifics. You will first issue a request for proposal (RFP) to hire a firm to perform this work for the school district. To create this RFP, you must determine what the city’s requirements are for this type of work. After reading the Right of Way Manual also found in Doc Sharing and the background information from the iLab content item this week, answer the questions in the lab report on the iLab page.

Vendors will respond to the RFP and you will rank their answers based on a criteria you decide is best for the project.

Deliverables

You are required to submit a lab report to the Week 4 Dropbox.

Required Software

None

iLAB STEPS

STEP 1: Download the Lab Report Template

Back to Top

Download this week’s Lab Report Template form Doc Sharing.

STEP 2: Answer the Questions

Back to Top

Answer the questions concerning installation in the outside plant installation.

STEP 3: Submit the Work

Back to Top

Submit your completed report to the Week 4 Dropbox.

Submit your lab to the Dropbox, located at the top of this page. For instructions on how to use the Dropbox, read these step-by-step instructions or watch this TutorialDropbox Tutorial.

See the Syllabus section “Due Dates for Assignments & Exams” for due date information.

<pclass=”msonormal” style=”box-sizing: border-box; overflow-wrap: break-word;”>NETW 310 Week 4 Lab Report

To complete your Week 4 lab report, answer the questions below concerning the installation of the outside plant equipment.

Create your report using the template starting on page 2 and submit it to the Week 4 Dropbox by the due date.

Create your report using the template starting on page 2 and submit it to the Week 4 Dropbox by the due date. Use the reference documents and websites as required to complete the iLab questions.

In order to be eligible to receive full credit, you must write in complete sentences and use the lab report template. Answers that are NOT written in complete sentences will receive point deductions.

Use a red-coloredfont for you answers.

Using the template and completing the header are worth 2 points on your grade for this assignment.

REMOVE THIS PAGE BEFORE YOU TURN IN YOUR DELIVERABLE AS IT IS INSTRUCTIONS ONLY.
Your Name

NETW 310, Professor’s Name

Current Date

Lab #4, Installation in the Outside Plant

Lab Report

This assignment has 19 questions that are weighted as marked on the iLab sheet. Each answer is worth 2, 3, 4 or 5 points. Using the template and completing the header are worth 2 points on your grade for this assignment.

Use a red-coloredfont for you answers. Answers that are NOT written in complete sentences will receive point deductions. You are to add in any references you do use. Please Support all of your decisions.

In order to be eligible to receive full credit, you must write in complete sentences and use the lab report template. You are to take off the cover of the template since this is a page of instructions, but include your header.

Place your answers in the template below the questions.

Section I: Use a reference such as the IRWA (www.irwaonline.org) to answer the question below. Cite your reference. (citation is worth 2 points)

1. What is a right-of-way? (4 points)

Section II: Using the RIGHT OF WAY Manual for the city of Burleson,Texas available in doc sharing and from the Week 4 iLab page, answer the questions below. (Each question is worth 3 points, section of the manual is worth 2 points)

1. May we dig a trench across the city street shown in this lab? (3 points) What section/sections in the ROW manual for the city of Burleson, Texas are relevant for this question? (2 points)
2. Who issues the permit for this work? Is this a local or state agency? (3 points) What section/sections in the ROW manual for the city of Burleson, Texas are relevant for this question? (2 points)
3. Must we submit construction plans to the city? If so, how many and to what entity are they submitted? (3 points) What section/sections in the ROW manual for the city of Burleson, Texas are relevant for this question? (2 points)
4. Once the permit is issued, how long must we wait before commencing work? How long do you have MAXIMUM to start work? (3 points)

What section/sections in the ROW manual for the city of Burleson, Texas are relevant for this question? (2 points)

5. How deep must any cables be buried? (3 points)

What section/sections in the ROW manual for the city of Burleson, Texas are relevant for this question? (2 points)

6. What are the exact detailed compaction requirements as listed in the manual provided by the city for restoration of any surface that is trenched? When do compaction of trenches have to occur? What are the backfill to be made of? (3 points)

What section/sections in the ROW manual for the city of Burleson, Texas are relevant for this question? (2 points)

7. Is the company we hire to do the work required to be registered in any way? If so, what registrations or certifications are accepted? (3 points)

What section/sections in the ROW manual for the city of Burleson, Texas are relevant for this question? (2 points)

8. When is interference with traffic flow allowed? (3 points)

What section/sections in the ROW manual for the city of Burleson, Texas are relevant for this question? (2 points)

9. During what hours may work not be done? (3 points)

What section/sections in the ROW manual for the city of Burleson, Texas are relevant for this question? (2 points)

Section III: Look at the “Best Practices for Preparing a RFP” document available in doc sharing or from the Week 4 ilab page and answer the questions below. (This document was created by Faulkner Information Services and downloaded from the library database.)

1. This document is a tutorial prepared to help IT professionals work on RFPs if they have not worked with them in the past. Write a paragraph of at least 10 sentences that outline what you learned when reading this document that you did not know and you will need to consider when writing your RFP? (5 points)
2. What in your mind are some of the reasons RFPs are successful and some reasons they fail? (2 points)
3. Would you consider using online or automated RFP development tools from an outside vendor? Why or why not? (2 points)
4. How will you work to set up the hardware and software requirement portions of an RFP? (2 points)
5. When considering Business needs and project domain, were there surprises in this document that you were not aware had to be addressed in a successful RFP? (2 points)
6. How will you work to determine a short list of suppliers for your RFP? (2 points)

Section IV: Using the RFI template available in doc sharing and from the Week 4 iLab page, answer the questions below.

1. Look at the template provided as an example by Sourcing for OEM

www.sourcing4oem.com that is available in doc sharing. How would using a template as a start to creating an RFP or RFI help you with this job? (2 points)

2. Can you create a complete RFP or RFI without investigating the business or technical requirements for the project? How will you use the vendors expertise to help you create a complete and on-time and on-budget project installation? (2 points)
3. What do you think about vendors helping create the RFP and RFI especially if you are working with a company that has a small IT staff or does not have anyone with the expertise to work on a new technology? (2 points)
4. Is this process more complicated that you thought it would be? (2 points)

</pclass=”msonormal”></pclass=”msonormal”><pclass=”msonormal” style=”box-sizing: border-box; overflow-wrap: break-word;”></pclass=”msonormal”><pclass=”msonormal” style=”box-sizing: border-box; overflow-wrap: break-word;”></pclass=”msonormal”><pclass=”msonormal” style=”box-sizing: border-box; overflow-wrap: break-word;”>NETW 310 Week 5 Lab Report

To complete your Week 5 lab report, answer the questions below concerning the Wireshark protocol analyzer software.

Create your report using the template starting on page 2 and submit it to the Week 4 Dropbox by the due date. Use the reference documents and websites as required to complete the iLab questions.

In order to be eligible to receive full credit, you must write in complete sentences and use the lab report template. Answers that are NOT written in complete sentences will receive point deductions.

Use a red-coloredfont for you answers. Answers that are NOT written in complete sentences will receive point deductions. You are to add in any references you do use. Please Support all of your decisions.

In order to be eligible to receive full credit, you must write in complete sentences and use the lab report template. You are to take off the cover of the template since this is a page of instructions, but include your header.

Place your answers in the template below the questions. Remove any graphics or explanations so that your deliverable has questions and your answers only.

Using the template and completing the header are worth 2 points on your grade for this assignment.

This assignment has 12 questions that are weighted as marked on the iLab sheet. Each answer is worth 2, 5, or 8 points. Remember, Using the template and completing the header are worth 2 points on your grade for this assignment.

REMOVE THIS PAGE BEFORE YOU TURN IN YOUR DELIVERABLE AS IT IS INSTRUCTIONS ONLY.

Your Name

NETW 310, Professor’s Name

Current Date

Lab #5, Wireshark Introduction Lab

Lab Report

Section I: Watch the video on the iLab page about Wireshark and answer the questions below.

1. Is Wireshark open-source or proprietary? What does it mean to be open-source vs proprietary in the first place? Give an example of something that is open source vs something that is proprietary in the field of networking and telecommunications. (5 points)
2. What is seen in each of the three panes that display the packets seen on a local area network? HINT: For full credit you must talk about what is DISPLAYED in each pane in addition to the NAME of each pane. ( 5 points)
3. What does a display filter do? Where do you add in a display filter? ( 5 points)
4. What does the protocol column show? How can this be helpful to you when troubleshooting? ( 5 points)
5. How do you expand the details in a layer of the packet in the middle frame? What is shown when you expand the details of a packet? ( 5 points)
6. Wireshark capture files have what file name extension? ( 5 points)
7. The time column shows what? The time is displayed in what part of a second ( sec, msec, usec, etc) ( 5 points)
8. When you right click on something in one of the panes what happens? ( 5 points)
9. How is a display filter removed? ( 5 points)
10. When a filter is correct what color is the background of the filter window?

Section II :Go towww.wireshark.org and look at the documents pagehttp://www.wireshark.org/docs/. Select one of the network mysteries “CASES”videos to watch and comment on.

1. Write a paragraph of at least 7 sentences about the case you choose and what you learned about wireshark and network troubleshooting from that case. (10 points)

www.wireshark.org

http://www.wireshark.org/docs/

Some of the network mystery cases highlighted on the wireshark documentation page:

Section III : Download Wireshark and some supporting documents. (You will need this for the Week 7 iLab).

1. Download the 100 Wireshark Tips from laura Chappell so you have it as a reference for your Week 7 iLab. This is available in doc sharing and from the Week 5 iLab page.
2. Download wireshark from www.wireshark.org You will need this to complete the Week 7. Please show a screen shot of the program on your computer and list what VERSION you were able to download. You will see something like this:

3.Download the appropriate user guide for your downloaded version of wireshark. Which version did you download?

4. What version of wireshark did you download? Show a screen shot of the version that you downloaded (as inj the graphic above). ( 8 points) You are now ready to work on the next Wireshark iLab in Week 7.

iLab 6 of 7: Introduction to Visio (70 points)

Note!

Submit your assignment to the Dropbox, located at the top of this page.

(See the Syllabus section “Due Dates for Assignments & Exams” for due dates.)

iLAB OVERVIEW

Scenario/Summary

In this iLab, you will be introduced to the Visio software package to create network diagrams.

Deliverables

You are required to submit both your Lab Report and your Visio file to the Dropbox.

Required Software

Visio

Access to the software is available at https://lab.devry.edu.

iLAB STEPS

STEP 1

Back to Top

Decide how you will access the Visio software package. You have several options.

1. You might have Visio already installed on your computer.
2. You can get it from the Student Software Store to install on your computer. To support you in achieving your educational goals, special educational offerings of applications used in a number of your courses are made available to DeVry’s students at no cost from Microsoft Dreamspark. The Visio Software package is one of these offerings. The Student Software Store is available under the Course Home section in your course shell.
3. Visio is also available to all students in the Citrix environment from the lab link above; to run without installing on their computer. Instructions and tutorials for accessing Citrix, uploading or saving files to Citrix, and contacting the Help Desk are available from your Course Home iLab page. You can get to Citrix by clicking the “Connect to the iLab here” link in the top right-hand corner of each week’s iLab page. Once logged into Citrix, Visio is available from the Microsoft Office folder.

STEP 2

Back to Top

Download this week’s lab report template. You will use this to create your lab report.

STEP 3

Back to Top

Download and perform all procedures in this week’s lab instructions.

STEP 4

Back to Top

Your iLab is now complete. When you are satisfied with your documentation, submit both your lab report and your Visio file to the Dropbox located on the silver tab at the top of this page.

Submit your lab to the Dropbox, located at the top of this page. For instructions on how to use the Dropbox, read these step-by-step instructionsor watch this TutorialDropbox Tutorial.

<pclass=”msonormal” style=”box-sizing: border-box; overflow-wrap: break-word;”>NETW 310 Week 6 Lab Report</pclass=”msonormal”>

Answer each of the question listed below on page 2.

Create your report using the template starting on page 2 and submit it to the Week 6 Dropbox by the due date.
Your Name

NETW 310, Professor’s Name

Current Date

Lab #6, Introduction to Visio

Lab Report

Use a red colored font for you answers.

Place the answers below the questions.

1 (3 points) What is your experience with the Visio software? Have you used it before or is it your first experience with Visio?

2. (3 points) How did you access Visio? How do you feel about the different access methods?
3. (3 points) What version of Visio did you use for this lab?
4. (3 points) What file extension does your version of Visio use? Does Visio support other extensions?
5. (6 points: 3 points for each screenshot and comment) Use this website (http://www.ratemynetworkdiagram.com/index.php?z=1) to find a diagram that you think has good points. Paste a screen shot of the diagram in your lab report and explain why you think it is good. (3 points) You must include a detailed explanation to get credit for this portion of the question.

Find another diagram from this site, or any other site, that you feel can be improved. Paste a screen shot in your lab report and explain what you think can be improved about the diagram. (3 points) You must include a detailed explanation to get credit for this portion of the question.

6. (6 points)What websites did you use to find Visio icons for networking. Which sites were most useful to you? Which ones did you like best in terms of icons available? Did you find others?
7. (6 points) What is the difference between a logical network diagram and a physical network diagram? (1 point) When would you use each type? (1 point)

Use the Internet to find an example of a logical network diagram and paste a screenshot below, along with proper citation. (logical diagram and URL: 2 points)

Use the Internet to find an example of a physical network diagram and paste a screenshot below, along with proper citation. (physical diagram and URL: 2 points)

8. (20 points) Place a screen shot here of your first Visio diagram showing a building LAN below.

<pclass=”msonormal” style=”box-sizing: border-box; overflow-wrap: break-word;”></pclass=”msonormal”>

</pclass=”msonormal”>

9. (20 points) Place a screen shot here of your second Visio diagram showing a relay rack below.

iLab 7: Troubleshooting Network Problems (70 Points)

Note!

Submit your assignment to the Dropbox, located at the top of this page.

(See the Syllabus section “Due Dates for Assignments & Exams” for due dates.)

iLAB OVERVIEW

Scenario/Summary

In this iLab, you will learn to recognize, diagnose, and suggest corrective actions for problems commonly seen in networks.

Deliverables

You are required to submit your lab report after completing the iLab assignments

Required Software

Wireshark

Access the software at www.wireshark.org.
Steps: all

iLAB STEPS

STEP 1: Step Title

Back to Top

Download this week’s Lab Report Template.

STEP 2: Step Title

Back to Top

Download and perform all procedures in this week’s lab instructions.

STEP 3: Step Title

Back to Top

Your iLab is now complete! When you are satisfied with your documentation, submit your assignment to the Dropbox.

Submit your lab to the Dropbox, located at the top of this page. For instructions on how to use the Dropbox, read these step-by-step instructionsor watch this TutorialDropbox Tutorial.

See the Syllabus section “Due Dates for Assignments & Exams” for due date information.

<pclass=”msonormal” style=”box-sizing: border-box; overflow-wrap: break-word;”>NETW 310 Week 7 Lab: Troubleshooting Network Problems</pclass=”msonormal”>

To complete your Week 7 lab report, answer the questions below concerning the Wireshark protocol analyzer software.

Create your report using the template starting on page 2 and submit it to the Week 7 Dropbox by the due date. Use the reference documents and websites as required to complete the iLab questions.

In order to be eligible to receive full credit, you must write in complete sentences and use the lab report template. Answers that are NOT written in complete sentences will receive point deductions.

Use a red-colored font for you answers. Answers that are NOT written in complete sentences will receive point deductions. You are to add in any references you do use. Please Support all of your decisions.

In order to be eligible to receive full credit, you must write in complete sentences and use the lab report template. You are to take off the cover of the template since this is a page of instructions, but include your header.

Place your answers in the template below the questions. Remove any graphics or explanations so that your deliverable has questions and your answers only.

Using the template and completing the header are worth 2 points on your grade for this assignment.

This assignment has 15 questions that are weighted as marked on the iLab sheet. Each answer is worth 2, 5, or 8 points. Remember, using the template and completing the header are worth 2 points on your grade for this assignment.

REMOVE THE COVER PAGE BEFORE YOU TURN IN YOUR DELIVERABLE AS IT IS INSTRUCTIONS ONLY.

Your Name
NETW 310, Professor’s Name
Current Date
Lab #7, Wireshark Introduction Lab
Lab Report

SECTION I: Using Wireshark, answer the questions below.

1. Show a screen shot of the frame where the SYN-ACK for TCP stream 0 appears. What frame is this in? ( 4 points)

Add in your screen shot here.

2. How long from the time the client issued the initial SYN for stream 0 did it take the server to answer with the SYN-ACK? (4 points)

Which method did you use? What was your calculation?

3. Notice that the client had to issue two initial SYNs as the first one did not elicit a response. In what frame is the first SYN that was issued? (4 points)
4. How long did it take the client to issue the ACK to the SYN-ACK for TCP stream 0? (4 points)
5. How long did it take the client to issue the first GET for stream 0 after the TCP 3-way handshake was completed? Add in a screen shot of this with the HTTP expanded so you can see information about the GET. (4 points)
6. Is this fast or slow? NOTE:What is fast or slow is not specifically discussed in the material for the week. Is a response in some ten-thousandths of a second is seen as fast “enough” according to DeVry? What do you think? Justify your answer. (2 points)
7. What is the window size sent by the client to the server in the first GET frame? Not the calculated window size using the window scaling factor, the window size value. Show a screen shot of where you found this answer.(4 points)
8. As the client receives data does the window size get smaller, stay the same, or get bigger?(4 points)
9. What do you conclude from this? Is the client being overloaded? Is it the source of any delays in the response seen by the user? ( 2 points)
10. Examine the stream of frames now displayed. Does either end show a smaller and smaller window size as the frames go back and forth? ( 2 points)
11. Examine the stream of frames are there any significant differences in the times during the back and forth between the client and the server? ( 2 points)
12. How many duplicate ACKs are there for stream index 0? What filter did you use to search for the dup acks? Show a screen shot of your filter and results for full credit.(4 points)
13. How many of these are between the client and the server? (4 points)
14. Does this indicate a problem in the network? Yes or no? How do you justify your answer? (4 points)

SECTION II: ( 10 points) Using the 100 Tips for Wireshark document from Laura Chappell, outline your favorite 5 tips and outline when and how you would use them to troubleshoot a network problem. Write at least 3 sentences on each tip you select to profile. Each outline is worth 2 points each.

SECTION III: Looking at security with wireshark. (10 points)

Write a short paragraph about what you see in this example. What does this tell you about password security in general? How does this profile what an unauthorized person using wireshark could capture?