Create a 5–10 minute video of yourself, as a presenter, in which you will propose an evidence-based plan to improve the outcomes for a patient and examine how remote collaboration provided benefits or challenges to designing and delivering the care.

/in /by

4/9/2020 Assessment 4 Instructions: Remote Collaboration and …
https://courserooma.capella.edu/webapps/blackboard/content/listContent.jsp?course_id=_232998_1&content_id=_8397727_1 1/3
Assessment 4 Instructions: Remote Collaboration and Evidence-
Based Care
Create a 5–10 minute video of yourself, as a presenter, in which you will propose an evidence-based plan to improve
the outcomes for a patient and examine how remote collaboration provided benefits or challenges to designing and
delivering the care.
As technologies and the health care industry continue to evolve, remote care, diagnosis, and collaboration are
becoming increasingly more regular methods by which nurses are expected to work. Learning the ways in which
evidence-based models and care can help remote work produce better outcomes will become critical for success.
Additionally, understanding how to leverage EBP principles in collaboration will be important in the success of
institutions delivering quality, safe, and cost-effective care. It could also lead to better job satisfaction for those
engaging in remote collaboration.
Demonstration of Proficiency
By successfully completing this assessment, you will demonstrate your proficiency in the course competencies
through the following assessment scoring guide criteria:
Competency 2: Analyze the relevance and potential effectiveness of evidence when making a decision.
Reflect on which evidence was most relevant and useful when making decisions regarding the care
plan.
Competency 3: Apply an evidence-based practice model to address a practice issue.
Explain the ways in which an EBP model was used to help develop the care plan.
Competency 4: Plan care based on the best available evidence.
Propose an evidence-based care plan to improve the safety and outcomes for a patient.
Competency 5: Apply professional, scholarly communication strategies to lead practice changes based on
evidence.
Identify benefits and strategies to mitigate the challenges of interdisciplinary collaboration to plan care
within the context of a remote team.
Communicate in a professional manner that is easily audible and uses proper grammar, including a
reference list formatted in current APA style.
Professional Context
Remote care and diagnosis is a continuing and increasingly important method for nurses to help deliver care to
patients to promote safety and enhance health outcomes. Understanding best EBPs and building competence in
delivering nursing care to remote patients is a key competency for all nurses. Additionally, in some scenarios, while
you may be delivering care in person you may be collaborating with a physician or other team members who are
remote. Understanding the benefits and challenges of interdisciplinary collaboration is vital to developing effective
communication strategies when coordinating care. So, being proficient at communicating and working with remote
health care team members is also critical to delivering quality, evidence-base care.
Scenario
Course Navigation 
Abigail Mitchell
FACULTY 31 NEW

Mark Whitley
COACH
Tutorials Support Log Out Charmi Shah 13
4/9/2020 Assessment 4 Instructions: Remote Collaboration and …
https://courserooma.capella.edu/webapps/blackboard/content/listContent.jsp?course_id=_232998_1&content_id=_8397727_1 2/3
The Vila Health: Remote Collaboration on Evidence-Based Care simulation provide the context for this assessment.
Instructions
Before beginning this assessment, make sure you have worked through the following media:
Vila Health: Remote Collaboration on Evidence-Based Care.
For this assessment, you are a presenter! You will create a 5–10-minute video using Kaltura or similar software. In the
video:
Propose an evidence-based care plan that you believe will improve the safety and outcomes of the patient in
the Vila Health Remote Collaboration on Evidence-Based Care media scenario.
Discuss the ways in which an EBP model and relevant evidence helped you to develop and make decision
about the plan you proposed
Wrap up your video by identifying the benefits of the remote collaboration in the scenario, as well as discuss
strategies you found in the literature or best practices that could help mitigate or overcome one or more of
the collaboration challenges you observed in the scenario.
Be sure you mention any articles, authors, and other relevant sources of evidence that helped inform your video.
Important: You are required to submit an APA-formatted reference list of the sources you cited specifically in your
video or used to inform your presentation.
The following media is an example learner submission in which the speaker successfully addresses all competencies
in the assessment.
Exemplar Kaltura Reflection.
Please note that the scenario that the speaker discusses in the exemplar is different from the Vila
Health scenario you should be addressing in your video. So, the type of communication expected is
being model, but the details related to the scenario in your submission will be different.
Make sure that your video addresses the following grading criteria:
Propose an evidence-based care plan to improve the safety and outcomes for a patient based on the Vila
Health Remote Collaboration on Evidence-Care media scenario.
Explain the ways in which an EBP model was used to help develop the care plan.
Reflect on which evidence was most relevant and useful when making decisions regarding the care plan.
Identify benefits and strategies to mitigate the challenges of interdisciplinary collaboration to plan care within
the context of a remote team.
Communicate in a professional manner that is easily audible and uses proper grammar, including a reference
list formatted in current APA style.
Refer to Using Kaltura [PDF] as needed to record and upload your video.
Note: If you require the use of assistive technology or alternative communication methods to participate in this
activity, please contact DisabilityServices@Capella.edu to request accommodations. If, for some reason, you are
unable to record a video, please contact your faculty member as soon as possible to explore options for completing
the assessment.
Additional Requirements
Your assessment should meet the following requirements:
4/9/2020 Assessment 4 Instructions: Remote Collaboration and …
https://courserooma.capella.edu/webapps/blackboard/content/listContent.jsp?course_id=_232998_1&content_id=_8397727_1 3/3
Length of video: 5–10 minutes.
References: Cite at least three professional or scholarly sources of evidence to support the assertions you
make in your video. Include additional properly cited references as necessary to support your statements.
APA reference page: Submit a correctly formatted APA reference page that shows all the sources you used to
create and deliver your video. Be sure to format the reference page according to current APA style.
Portfolio Prompt: Remember to save the final assessment to your ePortfolio so that you may refer to it as you
complete the final capstone course.
SCORING GUIDE
Use the scoring guide to understand how your assessment will be evaluated.
VIEW SCORING GUIDE 

Case studies discussion: Fight over Friday for the Future

/in /by

Read case 1: Fight over Friday for the Future (in additional material)
QUESTION: Should children be allowed to protest unsupervised during school hours.

Write three- five paragraphs evaluating the ethical issues of the case and arguing FOR or AGAINST a position from the question. Make sure to pick ONE position (for or against), identify the stakeholders, address various ethical issues (e.g., freedom of speech, responsibility of schools to ensure students’ safety, environmental ethics, autonomy, etc.), give at least 1 argument that supports your position, and explain and reply to a possible objection.

FORMAT:

Paragraph 1: Summarize the scenario briefly, focusing on the elements that you will address in your argument.

Paragraph 2: State your thesis (pick a position either FOR or AGAINST)

Paragraph 3: Give one argument that supports the thesis. Remember to explain your argument fully, using examples or scenarios.

Paragraph 4: Give another argument that supports the thesis.

Paragraph 5: Explain a possible objection to the thesis.

Paragraph 6: Reply to that objection.

Tips:

–Your goal is to give objective arguments to support a thesis.Use the theories that we have studied to support your arguments. One of your arguments must explicitly address one of the ethical theories we covered (Utilitarianism, Deontology, Cultural Relativism, Social contract theory, Egoism, Divine command theory). Think about what Mill or Kant would say.

–Make sure your arguments do not commit any obvious fallacy such as anecdotal evidence, emotional appeal, fallacy of assertion (stating beliefs or opinions), straw man, etc.

–Make sure you give REASONS for the position.

— Explain your arguments fully, using examples or scenarios. Pretend that your reader doesn’t know the case, and does not agree with you. Explain your argument fairly and sufficiently.

–Your last paragraph (or two) should explain a possible objection against your argument, and then explain your reply. Thus, if your thesis is FOR a position, explain an argument AGAINST the position, and reply to that argument.

Asset management firm

/in /by

The start of my career in an asset management firm

You have recently completed a Bachelor of Business degree through the College of Business, Law and Governance at James Cook University (JCU) and have been appointed as a junior member in an asset management firm in Singapore. This is your first full time position and you are on probation for three months. You feel a little anxious but you are keen to make a good impression in order to secure your position.

It is Monday morning of your second week in the position. On arrival your boss calls you into her office. Before she hands over some project to you, your boss wants to understand how familiar you are with statistical knowledge and skills. She gives you a dataset of stocks listed in the U.S. market. The data contain the firm information in Dec 2019.  You need to utilise your statistical knowledge to describe and summarise the data. More importantly, you need to identify the factors affecting stock returns and give your recommendations for investors in the U.S. stock market. Your boss asks you to complete the report within three days.

More specifically, she asks you to:

  1. Identify the variables and their types and scales of measurement.
  2. Provide a table in which you summarise the complete descriptive statistics on ‘stock return’ and ‘firm size’ (including but NOT limited to measures of central location, measures of variability, coefficient of variation (where applicable), etc.).
  3. Prepare two bar charts to graphically represent the frequency distribution of stock exchanges and of industries.
  4. Develop tables to provide joint information on:
    1. Stock exchanges and average stock return.
    2. Different industries and average stock return.
  5. Graphically demonstrate the output of Question 4.
  6. Provide a scatter plot and correlation analysis for
    1. Stock return and firm size
    2. Stock return and past return
    3. Stock return and past trading volume

What insights can be gained from these analyses?

  1. Are your results consistent with the research findings in the related literature? What are your recommendations to investors in the U.S. stock market?

 

Rights and Duties of Landlord

/in /by

Rights and Duties of Landlord

 

This week’s material discusses some of the rights and duties of landlords and tenants.

  • Do you think the law does enough to protect tenants from landlords?  What about protecting landlord from tenants?
  • What laws are there protecting tenants (or landlords) in your state?

 

This documentary is about a new geological era, called by scientists, ANTHROPOCENE. In your short paper please explain what kind of new era Anthropocene is. Also discuss how a) Industrial Revolution, fossil fuels and industrial technologies, b) Modern Military Technologies, c) European/American Exploitation of Poor Countries, and d) Consumerism and Consumption Culture have contributed to environmental devastation and exploitation of nature since the 19th century until present days.

/in /by

 

 

 

NOTE: Write your short paper addressing the following questions.

Type in 12-pt font, 1.5 spaced. You can write up to two (2) pages. Please Do NOT exceed the page limit.

 

Documentary is attached

 

 

Sources to use in your reflection paper: the documentary, Breakpoint.

 

Please sit down in a quiet corner, watch the documentary and take notes carefully.

 

Guiding questions to write your short reflection paper:

 

This documentary is about a new geological era, called by scientists, ANTHROPOCENE. In your short paper please explain what kind of new era Anthropocene is. Also discuss how a) Industrial Revolution, fossil fuels and industrial technologies, b) Modern Military Technologies, c) European/American Exploitation of Poor Countries, and d) Consumerism and Consumption Culture have contributed to environmental devastation and exploitation of nature since the 19th century until present days.

 

 

 

 

 

 

 

 

 

 

 

 

 

Business Exam

/in /by

Business Administration 243 Take Home Exam #2 (Open Book)
Question 1- If you are an attorney representing a mixed race candidate to be Chief Human Resource Manager for a Coffee Manufacturer, who was fully qualified for the position but has been turned down for it, and an apparently less qualified white male has been hired for the position, what elements would you have to prove for a case of Disparate Treatment under the Civil Rights Act of 1964, and what defenses should you anticipate from the Coffee Company?

What about if you are representing a woman Emergency Medical Transport candidate who has been turned down for that position because she could not lift the required 100 pounds to be eligible, could you support a Disparate Impact case on her behalf, what would you have to prove, and what reasonable accommodations would you argue for?
What is a BFOQ under the Civil Rights Act, give an example, and for what Protected Class does it not apply to? (25 Points)

Question 2- Your best friend has a small grocery store business with another friend where they formed a partnership when they opened last year. Your best friend has now asked you whether she and her partner (who now has a terminal disease) should form a Corporation or not. (Business is great and they may want to expand the size of their Store). What would you advise her in reference to the strengths and weaknesses of each form and whether they should form a Corporation? If you keep the Partnership, what specific items/elements should be stated in the Partnership Agreement? (25 Points)

Question 3- Define what negligence is, and what four elements does the plaintiff, who fell over a slippery banana peel, have to prove against the Defendant Grocery Store to succeed in a claim of negligence against that Defendant? Does it matter if the banana peel has only been on the floor for five minutes as opposed to four hours, and why? What are the defenses of assumption of the risk, comparative negligence, and contributory negligence, and give an example of each? (25 Points)

Question 4- What is strict liability and the public policy behind it? Who is in the Chain of Distribution here and how are they liable? Does the injured plaintiff have the burden of proof in Strict Liability Claims, and why or why not? What are abnormally dangerous activities, and what are the standards for proving liability for a business regarding such activities? (25 Points)

Final Group Project: Review and Comparison of Two Films

/in /by

Final Group Project: Review and Comparison of Two Films

In the following pages you are provided a number of options from which to choose for your final group project. Within each option the first film mentioned is the “required film” and then there are a number of options for the second “comparative film.”

Assignment: Your group will watch two films. You may choose any form of assigning tasks but perhaps the best strategy is for all group members to watch both films. Using materials gathered throughout the term, you should address the following issues:

  1. What is the general plot of each film? Where was it set? During what time period? What prehistoric, historic, or indigenous group (s) are depicted?
  2. How closely does the film follow historic, archaeological or modern knowledge of the group(s) depicted?

–using knowledge from reliable sources, is the group or time period represented fairly?

–for some films setting or context may be relevant. If so, is the setting or context depicted accurately.

  1. Are any stereotypes employed in the depiction of any of the groups?

– Are genders represented fairly? Are there any ethnic or racial stereotypes that are exhibited?

-This may include stereotypes of archeologists or archaeology if it is depicted in the film you watched.  It may include the use of actors of fluid ethnicity to depict certain roles.  The persons or their actions may be stereotypically represented.

  1. Describe the genre of the movie and any conventions or codes employed to support the overall message or any stereotypes.
  2. Were there ways in which the movie(s) promoted Othering? OR, were you made to feel a sense of shared humanity with the persons or groups depicted?
  3. Be sure to comment on whether the director, screenwriter, or actors were portrayed by indigenous persons and whether or not they had any relation to the group(s) depicted.

-Does the director or screen writer have any background that would provide them knowledge about the group being depicted?

-If there was a significant difference in indigenous versus non-indigenous persons involved in telling the story, please comment on this.

Please address these issues by completing an essay of no more than 10-15 pages, double spaced in at least 11 point font.

Your group should indicate in a separate document the roles that each member of your group undertook in preparing the final document.

 

 

Option 4: the US Indian Wars

Required: Dances With Wolves (1990)

The Revenant (2015)

 

1 WEEK # 2 – EXERCISES CHAPTER # 1

/in /by

1
WEEK # 2 – EXERCISES CHAPTER # 1
Exercise 1-1: Level 2- Job Analysis 1.
You work in the Human Resources Department of a computer-consulting firm. An employee is considering a transfer to one of the company’s other locations and is qualified for several different positions. Your task is to help the employee choose the most appropriate position based on a number of criteria. For example, you need to determine the value of each position in terms of the disposable income the employee can expect. The position with the highest salary is located in the company’s New York City office, but a studio apartment there costs about $2,650 per month. However, in the New York office, the employee would not need a car.
You have documented each position in an Excel worksheet. On this sheet, you have recorded the positions, the annual salary, the cost of living multiplier (which you obtained from a Web site) and estimates of a monthly car payment including insurance, assuming for some of these jobs the employee will need to purchase a car. You have also recorded information regarding starting bonuses (a one-time payment when hired) offered to the employee. Now, you need to finalize the worksheet.
Complete the following:
1. Open the workbook named Jobs-1.xlsx attached with the data of the assignment, and then save the file as 1-1-Job-Analysis1-Your-Name.xlsx.
2. In cells F2:F4, calculate the associated annual adjusted salary.
This adjusted salary is the annual salary divided by the cost of living multiplier minus the expected annual car payments.
(Note that car payments are given in dollars per month ($/month).
3. In cell F6, write a formula to calculate the average adjusted salary of the three positions.
4. In cell F7, write a formula to determine the value of the lowest adjusted salary.
This formula should automatically update if any of the data inputs are later changed.
5. In cell F8, write a formula to determine the value of the highest adjusted salary.
This formula should automatically update if any of the data inputs are later changed.
6. In cell G9, write a formula to determine the number of positions that include a bonus.
7. In cells H2:H4, calculate the value of the adjusted salary package for each position over a two-year period, including bonuses. The bonus does not need to be adjusted for location (multiplied by location factor) because the employee plans to use the bonus toward a vacation. Assume that the employee will receive a 5.5% raise after the first year of employment in the new position.
Adjusted Salary + (Adjusted Salary*5.5%) + Bonus
8. Display dollar values in columns E to H without cents, and include a dollar sign only in the first row of columns with dollars. Format the cost of living multipliers with two decimal places displayed, and align these values on the decimal point.
9. Another position for which the employee is qualified has just become available. This position, a senior consultant position, is located in Washington D.C., has an annual salary of $58,000, plus a $1,500 hiring bonus. Because the position is located in downtown Washington, assume that the employee will not be purchasing a car and that the cost of living multiplier is 2.4. Insert the data for this new position just below the New York position. Complete the calculations for the adjusted salary and the total two- year financial package.
2
WEEK # 2 – EXERCISES CHAPTER # 1
Verify that all of the other values you’ve calculated update correctly. Adjust the formatting of the new data, as needed, to match the formatting of the existing data.
10. Highlight in yellow the row of the position with the highest two-year financial package, and bold the text in this row.
11. Add your name at the end of the exercise and date in the cell A50.
12. Save and close the 1-1-Job-Analysis1-Your-Name.xlsx workbook.
3
WEEK # 2 – EXERCISES CHAPTER # 1
Exercise Ch1-2: Level 3- CKG Sales.
Level 3 – Analyzing Regional Sales Information for CKG Auto
As a regional sales manager for CKG Auto, you have just finished summarizing sales data for the first half of this year (January through June), aggregated by car model. You have started to enter data in an Excel worksheet, which lists by model the following information:
• Sales Volume, indicating the number of cars sold to dealers.
• Manufacturing (Mfg.) Cost per Vehicle.
• Total Cost of all vehicles sold for the model, which is based on the sales volume and the manufacturing costs per vehicle.
• Markup Percentage, which is the percentage charged above manufacturing cost to dealers.
• Total Sales to dealers, which is the Total Cost plus Markup. Markup equals the markup percentage times the manufacturer cost of the vehicle.
• % of Total Volume, which is based on the volume for the model compared to the volume of all models sold for the time period.
First, you need to complete the January through June computations based on the data contained in the worksheet and the information given.
Then, you have been asked to create a similar worksheet to estimate sales for July through December based on volume supplied by the marketing group.
These volumes are based on the historical values adjusted for seasonal demand of specific models and from market research on the popularity of models. After you have completed both the first half actual sales and the second half estimated sales, combine the data to determine expected yearly sales. Management is interested in not only the absolute value of those sales, but also each model’s contribution to the total yearly sales in each half of the year and in aggregate.
When completing the workbook, be sure that all data is correctly referenced so that your formulas will work as you copy them down the column or across the row, as necessary.
To complete the workbook, use the following steps:
1. Open the workbook named CKG-1.xlsx attached with the data of the assignment, and then save the file as 1-2-CKG-Sales2-Your-Name.xlsx. Rename the Sheet1 worksheet tab as 1-Half.
2. In the highlighted cells, enter formulas to perform the necessary calculations for January through June and to summarize. Be sure to write all formulas so that they can be copied as necessary. Note the following:
• Display all dollar values in whole numbers and include the dollar sign in the first row and total rows only.
• When calculating averages, your formula should automatically exclude models that had no sales. Display all average values (other than the percentage) with commas and no decimal places.
• When calculating summary data (total, average, etc.), keep in mind that additional car models (rows) may eventually be inserted at the bottom of the list.
• The formulas in column G need to determine the percent of total volume sales that the vehicle represents. (That is, if model A sold 100 cars and a total of 1000 cars were sold for all models, then model A would represent 10% of the total volume.)
4
WEEK # 2 – EXERCISES CHAPTER # 1
Format the cells in column G to display values to the nearest tenth of a percent. Be sure to calculate the number of models available for sale.
3. Your next task is to estimate the July through December sales based on the marketing data and the sales volume for the second half of the year.
The marketing group has provided a list of all car models in identical order to the original data you received with the expected sales volumes for each car model.
You can find this list in the Marketing-1.xlsx workbook, located in the Chapter 1 folder. The marketing group assumes that the manufacturing costs and markups will be the same for the second half of the year as they were for the first half.
With the data and assumptions in mind, insert a new worksheet named 2-Half in the 1-2-CKG-Sales2-Your-Name.xlsx workbook, identical to the 1-Half worksheet. Copy and paste the sales volumes from the Marketing-1.xlsx workbook into your new worksheet.
Verify that all the calculations in the new worksheet reflect the new data.
TROUBLESHOOTING: In order to complete this task successfully, copy the entire 1-Half worksheet to a new worksheet. Then, copy only the values for the sales volume, excluding the heading, from the Market workbook by highlighting the column Values and clicking the Copy button. Next, place the insertion point in the cell of the new worksheet corresponding to the first vehicle’s volume, and then paste the data. Check the calculated fields (Total Cost, Total Sales to Dealers, etc.) to make sure vehicles that were not sold during the first half of the year have values calculated and vehicles not sold during the second half do not have values.
4. Add another new worksheet named Sales Estimated, and include the column headings shown in Table 1.9 on this new worksheet.
a. Insert the model numbers in the identical format as shown on the 1-Half and 2-Half worksheets.
b. Insert the annual volume for each model—the combined totals of the January through June and the July through December volumes. Make sure that the values will automatically update if any of the input values are changed.
c. Insert the Jan–June sales to dealers, again ensuring that these values will automatically update if any of the input data changes.
d. Insert the July–Dec sales to dealers, again ensuring that these values will automatically update if any of the input data changes.
e. Create a combined total of sales to dealers for the entire year.
f. Calculate the total volumes and the total sales to dealers for each time period and annually in a row below the data.
g. Calculate the percentage of sales to dealers that each model represents, as a percentage of the total sales to dealers for all models, for January through June, July through December, and the year. Use only one formula for this calculation, and make sure that the formula can be copied down the column to calculate the percentages for the corresponding models and across the row to
5
WEEK # 2 – EXERCISES CHAPTER # 1
calculate the percentages for the corresponding time frames. Display the percentages with an appropriate format and number of decimal places.
5. Format all three worksheets so that they have a professional appearance.
6. Add your name at the end of the exercise and date
7. Save and close the 1-2-CKG-Sales2-Your-Name.xlsx workbook.

 

 

Week # 2 – Chapter # 1 Assignment
This week we cover the Level 2 and 3 of Chapter One of your textbook. Before you start on the Excel exercises be sure to read and make sure you understand the Chapter Introduction and VERY IMPORTANT, the Case Scenario on page 23. You have three ways to learn the material: • Use the book in the pages indicated for the chapter • Use the Lecture (Power Point) available in the week assignment. • Use the video tutorials guiding you through the Learning part of each level of each chapter or the link of youtube.com available in the week assignment. WATCH THE VIDEOS– WATCH THE VIDEOS — WATCH THE VIDEOS. Use the Chapter # 1 – Videos presentation to see the videos if you prefer. Let’s get started: ========================================================================================== If you have difficult with EXCEL or you have not practice with EXCEL, I recommend that you check the Level # 1 of Chapter # 1 before you continue.
Week # 2 – Chapter # 1 Assignment
Level 2: Objectives
• Work with multiple worksheets
• Calculate total, average, minimum, and maximum values with functions
• Understand how functions work: syntax, arguments, and algorithms
• Use the AutoSum feature to perform calculations quickly • Calculate the number of values using both COUNT and COUNTA Level Two: LEARNING Open CH01 Level 2 Figures.xlsx This file is the same as the figures in your textbook for Level 2 Starting on 43 of your textbook. You should read the learning material covered on pages 43-51 and the youtube.com video tutorial for this level. Use the attached presentation in Level 2 to see the video Level 2: Calculating and Comparing Data Using Simple Functions. or use the link: https://www.youtube.com/watch?v=7BgYlPeEeuo Level Two: APPLYING
Using the Week # 2 – Chapter 1 – Exercises.pdf
Make the Exercise Ch1-1: Level 2 – Job Analysis Post your completed file to Blackboard for review and grading. The file Name should be 1-1-Job-Analysis1-Your-Name.xlsx POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (40 POINTS) ==================================================================
Week # 2 – Chapter # 1 Assignment
Level 3: Objectives
• Organize a workbook
• Understand relative, absolute, and mixed cell referencing
• Write formulas with different types of cell references
• Copy formulas with different types of cell references • Name a cell or cell range Level Three: LEARNING Open CH01 Level 3 Figures.xlsx. This file is the same as the figures in your textbook for Level 3 Starting on 54 of your textbook. You should read the learning material covered on pages 54-68 of your text book and the youtube.com video tutorial for this level. Use the attached presentation in Level 3 to see the video Level 3: Analyzing Cell References When Writing and Copying Formulas. Or use the link: https://www.youtube.com/watch?v=s7ZgikkMxS0 Part Three: APPLYING
Using the Week # 2 – Chapter 1 – Exercises.pdf
Make the Exercise Ch1-2: Level 3 – CKG Sales Post your completed file to Blackboard for review and grading. The file Name should be 1-2-CKG-Sales1-Your-Name.xlsx POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (40 POINTS) ==================================================================
Week # 2 – Chapter # 1 Assignment
Let me know if there is anything you don’t understand — the earlier the better. ALWAYS attach a copy
of yours excel file clearly indicating where you have a problem.
The solution files that you need to attach are:
1-1-Job-Analysis1-Your-Name.xlsx (40 points)
1-2- CKG Sales1-Your-Name.xlsx (40 points)
After you understand the material and complete the exercises:
Answer the questions in the Practical Test – Chapter # 1 (20 POINTS)

The purpose of this discussion is to explore to what extent public health agencies provide guidance to consumers related to water source conservation and protection, waterborne illness prevention and reporting, and monitoring safety of drinking water (including those with private wells).

/in /by

Purpose

The purpose of this discussion is to explore to what extent public health agencies provide guidance to consumers related to water source conservation and protection, waterborne illness prevention and reporting, and monitoring safety of drinking water (including those with private wells).

Note: for the remainder of this semester, you will be placed in small groups for discussion.

This assignment aligns with one or more of the following learning outcomes:

  • identify actions taken by U.S.  public health officials to protect water sources and address waterborne illness

Tasks

  1. Upon reading and viewing this week’s module, consider important information that should be easily accessible to consumers. Create a list of at least seven criteriayou would hope to see on an agency’s website.
  2. Choose a local or state public health/environmental health agencysuch as Ramsey County or MN Department of Health to investigate. Using your criteria, grade the agency on how well it addresses each of the criteria provided. Briefly describe the strengths and weaknesses of the agency’s website based upon the criteria.
  3. Provide three recommendations for how the agency could improve their websitein regards to water quality and quantity issues presented this week.

Criteria for Success

Follow these guidelines to be successful:

Address the items in bold in your response.

You have posted your >250 word response to the above prompt by Thursday 11:59 p.m.

You have responded to at least two of your peers’ initial posts by Sunday 11:59 p.m.

You have engaged in discussion throughout the week, not just during one or two days.

 

Please see Module 0 for more information about the Discussion Assignment and the grading rubric.

 

Network Security Part One

/in /by

You have been hired as part of the network security team at UMGC. After completing orientation and training, your manager calls you into a meeting to discuss your first project.

The university has completed the implementation of the leased building in Adelphi, Maryland. The university realizes it needs to secure the faculty, students, and visitors network and data. With your background and skills, the university is looking to you for guidance. In addition to helping the university secure its network, you are required to obtain your CompTIA Security+ certification within 60-days of being hired.

As you will recall, the university leased building in Adelphi, Maryland was designed and implemented via the following layout:

You’ve been asked to perform network security analysis and planning, secure the boundary devices, hosts, and software; and secure the data at rest and in transit. Your deliverable should explain the requirement, propose a solution, and justify the solution. You should make use of the TestOut LabSim material to create the task, and study for CompTIA Security+ certification. You should also make use of other sources as required. It is important that your deliverable explain the technical issues in layman’s terms. Before you begin, make sure to review the Network Security Proposal (Parts 1-3).

In this learning demonstration, you will use TestOut Security Pro to help you understand how to identify and assess network infrastructure and pass the CompTIA Security+ certification. In order to identify your strengths and weaknesses, you will first complete the practice exam that will prepare you for the certification. The learning materials within TestOut LabSim will help you understand the types of vulnerabilities within a network and how to address them. As you step through each set of activities, you will submit a Vulnerability Assessment and Recommendation Document in three parts. Use the results of the certification practice exam you took at the beginning of the class to help guide you on which areas within LabSim you should pay closer attention. You must complete all online labs in TestOut LabSim; these are the activities with the computer mouse icon. Some of the other areas in TestOut LabSim are optional. You can complete any or all of those if you feel you need to learn more about the topics.

There are nine steps in this project that lead you through each deliverable. Begin with Step 1, obtaining access to TestOut Security Pro and enrolling in LabSim, and then continue with Step 2, taking the practice exam.
Here is the rubric:xcellent
Good
Acceptable (Minimally Proficient)
Needs Improvement
Needs Significant Improvement
Missing or Unacceptable
Assessed the appropriate vulnerability assessment tools to support the requirements of the organization
20 points
Provided an excellent description of the technical requirements, proposal, and justification for the vulnerability assessment.

16 points
Provided an outstanding description of the technical requirements, proposal, and justification for the vulnerability assessment.

14 points
Provided a description of the technical requirements, proposal, and justification for the vulnerability assessment.

12 points
Provided a description of the technical requirements and proposal for the vulnerability assessment, but lacked an appropriate justification.

10 points
Identified technical requirements for the vulnerability assessment, but the proposal and justification lacked detail and/or was not well supported.

0 points
The technical requirements, proposal, and justification for the vulnerability assessment of the paper were off topic or failed to provide required level of detail.

/ 20
Identified the appropriate security policy for the organization
15 points
Provided an excellent description of the technical requirements, proposal, and justification for the security policy.

12 points
Provided an outstanding description of the technical requirements, proposal, and justification for the security policy.

10.5 points
Provided a description of the technical requirements, proposal, and justification for the security policy.

9 points
Provided a description of the technical requirements and proposal for the security policy, but lacked an appropriate justification.

7.5 points
Identified a technical requirement for the security policy, but the proposal and justification lacked detail and/or was not well supported.

0 points
The technical requirements, proposal, and justification for the security policy of the paper were off topic or failed to provide required level of detail.

/ 15
Describe the proper risk management solution to reduce risk to an acceptable level
20 points
Provided an excellent description of the technical requirements, proposal, and justification for the proper risk management solution.

16 points
Provided an outstanding description of the technical requirements, proposal, and justification for the proper risk management solution.

14 points
Provided a description of the technical requirements, proposal, and justification for the proper risk management solution.

12 points
Provided a description of the technical requirements and proposal for the proper risk management solution, but lacked an appropriate justification.

10 points
Identified a technical requirement for the proper risk management solution, but the proposal and justification lacked detail and/or was not well supported.

0 points
The technical requirements, proposal, and justification for the proper risk management solution of the paper were off topic or failed to provide required level of detail.

/ 20
Assessed the appropriate business continuity plan to enable critical organizational functions to continue
15 points
Provided an excellent description of the technical requirements, proposal, and justification for the business continuity plan.

12 points
Provided an outstanding description of the technical requirements, proposal, and justification for the business continuity plan.

10.5 points
Provided a description of the technical requirements, proposal, and justification for the business continuity plan.

9 points
Provided a description of the technical requirements and proposal for the business continuity plan, but lacked an appropriate justification.

7.5 points
Identified a technical requirement, but the proposal and justification for the business continuity plan lacked detail and/or was not well supported.

0 points
The technical requirements, proposal, and justification for the business continuity plan of the paper were off topic or failed to provide required level of detail.

/ 15
Assessed the proper access control models for the organization
15 points
Provided an excellent description of the technical requirements, proposal, and justification for the access control model(s) selected.

12 points
Provided an outstanding description of the technical requirements, proposal, and justification for the access control model(s) selected.

10.5 points
Provided a description of the technical requirements, proposal, and justification for the access control model(s) selected.

9 points
Provided a description of the technical requirements and proposal for the access control model(s) selected, but lacked an appropriate justification.

7.5 points
Identified a technical requirement for the access control model(s) selected, but the proposal and justification lacked detail and/or was not well supported.

0 points
The technical requirements, proposal, and justification for the access control model(s) were off topic or failed to provide required level of detail.

/ 15
Use of Authoritative Sources / Resources
10 points
Work contains a reference list containing entries for all cited sources. Reference list entries and intext citations are correctly formatted using the appropriate IEEE style for each type of resource. The description appropriately used information from 3 or more authoritative sources, i.e. journal articles, industry or trade publications, news articles, industry or government white papers and authoritative Web sites.

8 points
Work contains a reference list containing entries for all cited sources. One or two minor errors in IEEE format for in-text citations and/or reference list entries. The description appropriately used information from 3 or more authoritative sources, i.e. journal articles, industry or trade publications, news articles, industry or government white papers and authoritative Web sites.

7 points
Work contains a reference list containing entries for all cited sources. No more than 5 minor errors in IEEE format for in-text citations and/or reference list entries. The description appropriately used information from 2 or more authoritative sources, i.e. journal articles, industry or trade

Work publications, news articles, industry or government white papers and authoritative Web sites.

6 points
Work contains a reference list containing entries for cited sources. Work contains no more than 5 minor errors in IEEE format for in-text citations and/or reference list entries. The description appropriately used information from 2 or more authoritative sources, i.e. journal articles, industry or trade publications, news articles, industry or government white papers and authoritative Web sites.

5 points
Work attempts to credit sources but demonstrates a fundamental failure to understand and apply the IEEE formatting standard.

The description appropriately used information from 1 or more authoritative sources, i.e. journal articles, industry or trade publications, news articles, industry or government white papers and authoritative Web sites.

0 points
Reference list is missing. Work demonstrates an overall failure to incorporate and/or credit authoritative sources for information used in the paper.

/ 10
Satisfy standards of writing style and grammatical correctness
5 points
No formatting, grammar, spelling, or punctuation errors.

4 points
Work contains minor errors in formatting, grammar, spelling or punctuation which do not significantly impact professional appearance.

3.5 points
Errors in formatting, spelling, grammar, or punctuation which detract from professional appearance of the submitted work.

3 points
Submitted work has numerous errors in formatting, spelling, grammar, or punctuation. Work is unprofessional in appearance.

1 point
Submitted work is difficult to read / understand and has significant errors in formatting, spelling, grammar, punctuation, or word usage.

0 points
No work submitted for this assignment.

/ 5