My Blog

Tag: Criminal

  • [Solved] Presentation on Theory

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    – IMG_9164.jpeg – IMG_9162.jpeg – IMG_9163.jpeg – IMG_9165.jpeg – Samplepresentation.pptx **IMG_9164.jpeg** This file is too large to display. [View in new window](https://www.sweetstudy.com/files/img-9164-jpeg) **IMG_9162.jpeg** This file is too large to display. [View in new window](https://…

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    – IMG_9164.jpeg
    – IMG_9162.jpeg
    – IMG_9163.jpeg
    – IMG_9165.jpeg
    – Samplepresentation.pptx

    **IMG_9164.jpeg**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/img-9164-jpeg)

    **IMG_9162.jpeg**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/img-9162-jpeg)

    **IMG_9163.jpeg**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/img-9163-jpeg)

    **IMG_9165.jpeg**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/img-9165-jpeg)

    **Samplepresentation.pptx**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/samplepresentation-pptx-10399979)

    **Samplepresentation.pptx**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/samplepresentation-pptx-10399979)

    **IMG_9164.jpeg**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/img-9164-jpeg)

    **IMG_9162.jpeg**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/img-9162-jpeg)

    **IMG_9163.jpeg**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/img-9163-jpeg)

    **IMG_9165.jpeg**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/img-9165-jpeg)

    **Samplepresentation.pptx**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/samplepresentation-pptx-10399979)

    **IMG_9164.jpeg**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/img-9164-jpeg)

    **IMG_9162.jpeg**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/img-9162-jpeg)

    **IMG_9163.jpeg**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/img-9163-jpeg)

    **IMG_9165.jpeg**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/img-9165-jpeg)

    **Samplepresentation.pptx**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/samplepresentation-pptx-10399979)

    – 1
    – 2
    – 3
    – 4
    – 5

  • [Solved] crj 331 i need help wk1

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    – ## cf_CRJ331_Week1_Activity1.docx **## cf_CRJ331_Week1_Activity1.docx** ![](https://www.sweetstudy.com/questions/crj-331-i-need-help-wk1)CRJ331: Common Disorders in the Criminal Justice System Overview: The goal of this activity is to reinforce the facts around some of the more common disord…

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    – ## cf_CRJ331_Week1_Activity1.docx

    **## cf_CRJ331_Week1_Activity1.docx**

    ![](https://www.sweetstudy.com/questions/crj-331-i-need-help-wk1)CRJ331: Common Disorders in the Criminal Justice System

    Overview:

    The goal of this activity is to reinforce the facts around some of the more common disorders seen in the criminal justice system by forensic psychologists. Each disorder has a flashcard with a brief definition from the American Psychiatric Association and a link to a fact sheet and diagnostic criteria from the
    [American Psychiatric Association's Diagnostic and Statistical Manual of Mental Disorders (DSM-5)](https://www.psychiatry.org/psychiatrists/practice/dsm/educational-resources). Understanding these disorders will help you better understand the role of the forensic psychologist when they encounter an individual with one of these disorders.

    **Submission:** Save this document as “lastname_firstname_CRJ331_WK1_Activity” and submit it via the link in the course to earn the points assigned in your course guide.

    Assignment:

    1. Based on your readings this week, how would you differentiate between a clinical psychologist and a forensic psychologist?
    _Your answer should be one paragraph._

    **Write your response below:**

    2. Using the information in your readings this week and in this activity, choose one of the six disorders and describe the role a forensic psychologist might play when a suspect has the chosen disorder.
    _Your answer should be one paragraph_

    **Write your response below:**

    This course requires the use of Strayer Writing Standards (SWS). The library is your home for SWS assistance, including citations and formatting. Please refer to the
    Library site for all support. Check with your professor for any additional instructions.

    ## image1.png

    **## cf_CRJ331_Week1_Activity1.docx**

    ![](https://www.sweetstudy.com/questions/crj-331-i-need-help-wk1)CRJ331: Common Disorders in the Criminal Justice System

    Overview:

    The goal of this activity is to reinforce the facts around some of the more common disorders seen in the criminal justice system by forensic psychologists. Each disorder has a flashcard with a brief definition from the American Psychiatric Association and a link to a fact sheet and diagnostic criteria from the
    [American Psychiatric Association's Diagnostic and Statistical Manual of Mental Disorders (DSM-5)](https://www.psychiatry.org/psychiatrists/practice/dsm/educational-resources). Understanding these disorders will help you better understand the role of the forensic psychologist when they encounter an individual with one of these disorders.

    **Submission:** Save this document as “lastname_firstname_CRJ331_WK1_Activity” and submit it via the link in the course to earn the points assigned in your course guide.

    Assignment:

    1. Based on your readings this week, how would you differentiate between a clinical psychologist and a forensic psychologist?
    _Your answer should be one paragraph._

    **Write your response below:**

    2. Using the information in your readings this week and in this activity, choose one of the six disorders and describe the role a forensic psychologist might play when a suspect has the chosen disorder.
    _Your answer should be one paragraph_

    **Write your response below:**

    This course requires the use of Strayer Writing Standards (SWS). The library is your home for SWS assistance, including citations and formatting. Please refer to the
    Library site for all support. Check with your professor for any additional instructions.

    ## image1.png

  • [Solved] crj 435 wk8 i need help

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    – ## Week8Activity-LocalandGlobalGangsWorksheet.docx **## Week8Activity-LocalandGlobalGangsWorksheet.docx** | | | | — | — | | ![Strayer University](https://www.sweetstudy.com/questions/crj-435-wk8-i-need-help) | **CRJ435 – Drugs, Gangs, and Organized Crime**<br>Week 8 Activity – Local and Global…

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    – ## Week8Activity-LocalandGlobalGangsWorksheet.docx

    **## Week8Activity-LocalandGlobalGangsWorksheet.docx**

    | | |
    | — | — |
    | ![Strayer University](https://www.sweetstudy.com/questions/crj-435-wk8-i-need-help) | **CRJ435 – Drugs, Gangs, and Organized Crime**<br>Week 8 Activity – Local and Global Gangs Worksheet |

    **Local and Global Gangs**

    1.
    Describe a gang operating in your area, including its name, location, and 3 facts about the gang.

    **_Note_**: These facts could relate to the gang’s:

    · History

    · Activities

    · Reputation

    · Affiliations

    · Some other interesting characteristics of the group.

    **Local Gang Name**: [Type your answer here]

    **Gang Location**: [Type your answer here]

    **Facts about the Local Gang**:

    1. [Type your answer here]

    2. [Type your answer here]

    3. [Type your answer here]

    2. Compare the gang operating in your area to one of the gangs you explored on the world map, highlighting at least 3 points of comparison.

    **_Note_**: Some ideas for comparisons you could make are:

    ·
    **Organizational Structure:** Compare how each gang is organized, such as hierarchy, leadership roles, and divisions of labor.

    ·
    **Criminal Activities:** Compare the types of illegal activities each gang engages in, such as drug trafficking, extortion, or violence.

    ·
    **Recruitment Methods:** Compare how each gang recruits new members, including tactics used and target demographics.

    ·
    **Geographic Reach:** Compare the geographic scope of each gang's operations, including where they operate and their level of influence.

    ·
    **Impact on Community:** Compare the impact each gang has on the community, including social, economic, and security implications.

    ·
    **Notable Events or Incidents:** Compare any significant events or incidents associated with each gang, such as high-profile crimes or conflicts with law enforcement.

    ·
    **Affiliations:** Compare any alliances or affiliations each gang may have with other criminal organizations or groups.

    ·
    **Response from Authorities:** Compare how local authorities or law enforcement agencies have responded to each gang, including enforcement efforts and strategies for combating gang activity.

    **International Gang Name**: [Type your answer here]

    **Gang Location**: [Type your answer here]

    **Comparisons between the International Gang and the Local Gang**:

    1. [Type your answer here]

    2. [Type your answer here]

    3. [Type your answer here]

    © 2022 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written permission of Strayer University.

    1 of 4

    **image1.png**

    **## Week8Activity-LocalandGlobalGangsWorksheet.docx**

    | | |
    | — | — |
    | ![Strayer University](https://www.sweetstudy.com/questions/crj-435-wk8-i-need-help) | **CRJ435 – Drugs, Gangs, and Organized Crime**<br>Week 8 Activity – Local and Global Gangs Worksheet |

    **Local and Global Gangs**

    1.
    Describe a gang operating in your area, including its name, location, and 3 facts about the gang.

    **_Note_**: These facts could relate to the gang’s:

    · History

    · Activities

    · Reputation

    · Affiliations

    · Some other interesting characteristics of the group.

    **Local Gang Name**: [Type your answer here]

    **Gang Location**: [Type your answer here]

    **Facts about the Local Gang**:

    1. [Type your answer here]

    2. [Type your answer here]

    3. [Type your answer here]

    2. Compare the gang operating in your area to one of the gangs you explored on the world map, highlighting at least 3 points of comparison.

    **_Note_**: Some ideas for comparisons you could make are:

    ·
    **Organizational Structure:** Compare how each gang is organized, such as hierarchy, leadership roles, and divisions of labor.

    ·
    **Criminal Activities:** Compare the types of illegal activities each gang engages in, such as drug trafficking, extortion, or violence.

    ·
    **Recruitment Methods:** Compare how each gang recruits new members, including tactics used and target demographics.

    ·
    **Geographic Reach:** Compare the geographic scope of each gang's operations, including where they operate and their level of influence.

    ·
    **Impact on Community:** Compare the impact each gang has on the community, including social, economic, and security implications.

    ·
    **Notable Events or Incidents:** Compare any significant events or incidents associated with each gang, such as high-profile crimes or conflicts with law enforcement.

    ·
    **Affiliations:** Compare any alliances or affiliations each gang may have with other criminal organizations or groups.

    ·
    **Response from Authorities:** Compare how local authorities or law enforcement agencies have responded to each gang, including enforcement efforts and strategies for combating gang activity.

    **International Gang Name**: [Type your answer here]

    **Gang Location**: [Type your answer here]

    **Comparisons between the International Gang and the Local Gang**:

    1. [Type your answer here]

    2. [Type your answer here]

    3. [Type your answer here]

    © 2022 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written permission of Strayer University.

    1 of 4

    **image1.png**

  • [Solved] crj 331 i need help wk 9

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    In this assignment you will examine the multiple ways forensic psychologists work with the police. In movies or television, we usually see the forensic psychologist working as a profiler to catch a killer, but in reality, they play a much bigger role. Some of those roles are examined here including …

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    In this assignment you will examine the multiple ways forensic psychologists work with the police. In movies or television, we usually see the forensic psychologist working as a profiler to catch a killer, but in reality, they play a much bigger role. Some of those roles are examined here including assessment for hiring, evaluation for stress, burnout, and fitness for duty. Sometimes officers are on the other side of the law and the forensic psychologist could be tasked with performing psychosocial evaluations of officers accused of crimes and serving as consultants or expert witnesses in the trial and sentencing. You will leverage the knowledge you've gained from the readings and discussions over the past three weeks to complete this assignment.
    ## **Instructions**
    Complete the assignment using the [CRJ331 Week 9 Assignment Template](https://canvas.strayer.edu/courses/22264/files/14372204?wrap=1 "cf_CRJ331_Week_9_Assignment_Template.docx") [Download CRJ331 Week 9 Assignment Template](https://canvas.strayer.edu/courses/22264/files/14372204/download?download_frd=1)[DOCX]. Use the information from your textbook and other resources from the course as well as those listed here. Review the assignment rubric before you start the assignment.
    **The categories listed here will be the focus of the assignment. Specific scenarios, questions, prompts, and resources for each category will be provided on the assignment template (linked above).**
    1. Assessment for hiring.
    2. Evaluation after a crime.
    3. Jury selection.
    4. Stress and Burnout.
    5. Sentencing Decisions.
    6. Produce writing that is clear and well organized and applies appropriate [Strayer Writing Standards](https://library.strayer.edu/sws/paper) (SWS) style. Writing contains accurate grammar, mechanics, and spelling.
    7. Use at least two quality sources, including the course textbook, to support your writing. Choose sources that are credible, relevant, and appropriate. Cite each source listed on your source page at least one time within your assignment. For help with research, writing, and citation, access the [library](https://library.strayer.edu/) or review the [B.S. in Criminal Justice Library Guide.](https://library.strayer.edu/bscj)
    This course requires the use of Strayer Writing Standards (SWS). The library is your home for SWS assistance, including citations and formatting. Please refer to the [Library site](https://library.strayer.edu/sws) for all support. Check with your professor for any additional instructions.
    ## **Resources**
    – Course textbook and resources from the Learn section in the course.
    – [Stress, Burnout, and Health.Links to an external site.](https://www.ojp.gov/pdffiles1/nij/grants/242957.pdf)
    – [Documenting the Traumas of First Responders.Links to an external site.](https://nami.org/Blogs/NAMI-Frontline-Wellness/2021/Documenting-the-Traumas-of-First-Responders)
    – [Policing through the Pain: How Trauma Impacts Police Officers.Links to an external site.](https://www.joinipsa.org/resources/Publications/Policing%20through%20the%20Pain%20-%20How%20Trauma%20Impacts%20Police%20Officers%20-%20International%20Public%20Safety%20Association%20-%20October%202019.pdf)
    – [M.I.N.I International Neuropsychiatric Interview](https://canvas.strayer.edu/courses/22264/files/14372140?wrap=1 "cf_CRJ331_MINI.pdf") [Download M.I.N.I International Neuropsychiatric Interview](https://canvas.strayer.edu/courses/22264/files/14372140/download?download_frd=1)[PDF].
    The course learning outcomes aligned to this assignment are:
    – Demonstrate an understanding of how a forensic psychologist works with police and other law enforcement personnel.
    – Analyze the key components of translating psychological information into a legal framework.
    \
    cf_CRJ331_Week_9_Assignment_Template.docx](https://www.sweetstudy.com/files/cf-crj331-week-9-assignment-template-docx "cf_CRJ331_Week_9_Assignment_Template.docx")

  • [Solved] crj 435 wk7 i need help

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    People involved in gang activity are just that—people. Like all of us, they have families, hopes, dreams, motivations, disappointments, and sorrows. They have rights, just like other U.S. citizens, that need to be protected. They are likely to have had logical, rational reasons for becoming involved…

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    People involved in gang activity are just that—people. Like all of us, they have families, hopes, dreams, motivations, disappointments, and sorrows. They have rights, just like other U.S. citizens, that need to be protected. They are likely to have had logical, rational reasons for becoming involved in a gang. They are more than the crime, or crimes, they have committed. They are not animals as some people have described them, but people.
    To be able to prevent, intervene in, and suppress gang activity in our communities, we need to learn people's stories. What trauma did these individuals encounter in their lives? What protective factors were present to help them resist gang involvement? Protective factors, for example, include the existence of role models outside gang life, parents who were not gang members themselves, and family and community support. In other words, we need to learn their story.
    This assignment will help you to see the personal side of gang life by taking an in-depth look at the story of someone who has been involved in it.
    ## **Preparation**
    Begin by downloading the [Week 7 Assignment – Gang Life and Its Societal Impacts Worksheet](https://canvas.strayer.edu/courses/22280/files/14373180?wrap=1 "Week 7 Assignment – Gang Life and Its Societal Impacts Worksheet.docx") [Download Week 7 Assignment – Gang Life and Its Societal Impacts Worksheet](https://canvas.strayer.edu/courses/22280/files/14373180/download?download_frd=1).
    Then, research and analyze the story of an individual who was involved in gang life and later got out. You may analyze the life story of someone you know, a character from a movie or book, or someone who has spoken out about their experiences leaving a gang.
    Examples of individuals you could research are, but aren't limited to:
    – Pearl Arredondo's story, My Story, From Gangland Daughter to Star Teacher
    – Gerardo Lopez's story, I Was an MS-13 Gang Member. Here's How I Got Out
    – John Jackson's story, How I Got Out of a Prison Gang
    ## **Instructions**
    Please fill in the boxes in the provided worksheet with the following:
    1. Describe the background and risk factors that led to the gang involvement of your chosen individual.
    2. Describe the reasons behind your chosen individual's delinquent behavior, considering how community and societal problems shaped their actions.
    3. Discuss protective factors and community support systems that were present in your chosen individual's life before they got involved with a gang.
    4. Discuss the personal strengths that enabled your chosen individual to overcome the influence of the gang and leave the group.
    5. Create a simple timeline that details the key events in your chosen individual's progression into and then out of gang involvement.
    6. Describe how your chosen individual left the gang and reintegrated into society, considering community support and rehabilitation.
    7. Reflect on potential actions and supports that could have prevented your chosen individual from joining a gang.
    8. Support your writing with at least three credible sources, cited in a Source List in SWS style.
    This course requires the use of Strayer Writing Standards (SWS). The library is your home for SWS assistance, including citations and formatting. Please refer to the [Library](https://library.strayer.edu/sws) site for all support. Check with your professor for any additional instructions.
    The specific course learning outcome associated with this assignment is:
    – Research the societal impacts of gangs and organized crime.
    \
    Week7Assignment-GangLifeandItsSocietalImpactsWorksheet.docx](https://www.sweetstudy.com/files/week7assignment-ganglifeanditssocietalimpactsworksheet-docx "Week7Assignment-GangLifeandItsSocietalImpactsWorksheet.docx")

  • [Solved] Discussion 3

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    \ IMG_9204.jpeg](https://www.sweetstudy.com/files/img-9204-jpeg "IMG_9204.jpeg")

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    \
    IMG_9204.jpeg](https://www.sweetstudy.com/files/img-9204-jpeg "IMG_9204.jpeg")

  • [Solved] DB

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    See attached. – ## WK6.docx – ## DiscussionAssignmentInstructionsCJUS350.docx **## WK6.docx** **Discussion Thread: Lead by Example** Please post your answers to the following questions: · Rookie officers often emulate the actions of their field training officer. Therefore, why is it important to ens…

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    See attached.

    – ## WK6.docx

    – ## DiscussionAssignmentInstructionsCJUS350.docx

    **## WK6.docx**

    **Discussion Thread: Lead by Example**

    Please post your answers to the following questions:

    · Rookie officers often emulate the actions of their field training officer. Therefore, why is it important to ensure we select the best field training officers in the organization?

    · Please consider the scenario,
    _Moral Weakness/Moral Courage_, found in the Lecture Notes for this Module: Week. How would you have handled this situation?

    · Please read I Timothy 4:8 and explain how this is relevant to strong, effective leadership in the criminal justice system.

    **## DiscussionAssignmentInstructionsCJUS350.docx**

    CJUS 350

    **Discussion Assignment Instructions**

    The student will complete 8 Discussions in this course. The student will post one thread of at least 400 words by 11:59 p.m. (ET) on Thursday of the assigned Module: Week. The student must then post at least 2 replies of at least 200 words by 11:59 p.m. (ET) on Monday of the assigned Module: Week. For each thread, students must support their assertions with at least 2 scholarly citations in APA format. Each reply must incorporate at least 2 scholarly citation(s) in APA format. Any sources cited must have been published within the last five years. Acceptable sources include the textbook, the Bible, journal articles and professional experiences.

    **## DiscussionAssignmentInstructionsCJUS350.docx**

    CJUS 350

    **Discussion Assignment Instructions**

    The student will complete 8 Discussions in this course. The student will post one thread of at least 400 words by 11:59 p.m. (ET) on Thursday of the assigned Module: Week. The student must then post at least 2 replies of at least 200 words by 11:59 p.m. (ET) on Monday of the assigned Module: Week. For each thread, students must support their assertions with at least 2 scholarly citations in APA format. Each reply must incorporate at least 2 scholarly citation(s) in APA format. Any sources cited must have been published within the last five years. Acceptable sources include the textbook, the Bible, journal articles and professional experiences.

    **## WK6.docx**

    **Discussion Thread: Lead by Example**

    Please post your answers to the following questions:

    · Rookie officers often emulate the actions of their field training officer. Therefore, why is it important to ensure we select the best field training officers in the organization?

    · Please consider the scenario,
    _Moral Weakness/Moral Courage_, found in the Lecture Notes for this Module: Week. How would you have handled this situation?

    · Please read I Timothy 4:8 and explain how this is relevant to strong, effective leadership in the criminal justice system.

    **## DiscussionAssignmentInstructionsCJUS350.docx**

    CJUS 350

    **Discussion Assignment Instructions**

    The student will complete 8 Discussions in this course. The student will post one thread of at least 400 words by 11:59 p.m. (ET) on Thursday of the assigned Module: Week. The student must then post at least 2 replies of at least 200 words by 11:59 p.m. (ET) on Monday of the assigned Module: Week. For each thread, students must support their assertions with at least 2 scholarly citations in APA format. Each reply must incorporate at least 2 scholarly citation(s) in APA format. Any sources cited must have been published within the last five years. Acceptable sources include the textbook, the Bible, journal articles and professional experiences.

    **## WK6.docx**

    **Discussion Thread: Lead by Example**

    Please post your answers to the following questions:

    · Rookie officers often emulate the actions of their field training officer. Therefore, why is it important to ensure we select the best field training officers in the organization?

    · Please consider the scenario,
    _Moral Weakness/Moral Courage_, found in the Lecture Notes for this Module: Week. How would you have handled this situation?

    · Please read I Timothy 4:8 and explain how this is relevant to strong, effective leadership in the criminal justice system.

    **## DiscussionAssignmentInstructionsCJUS350.docx**

    CJUS 350

    **Discussion Assignment Instructions**

    The student will complete 8 Discussions in this course. The student will post one thread of at least 400 words by 11:59 p.m. (ET) on Thursday of the assigned Module: Week. The student must then post at least 2 replies of at least 200 words by 11:59 p.m. (ET) on Monday of the assigned Module: Week. For each thread, students must support their assertions with at least 2 scholarly citations in APA format. Each reply must incorporate at least 2 scholarly citation(s) in APA format. Any sources cited must have been published within the last five years. Acceptable sources include the textbook, the Bible, journal articles and professional experiences.

    – 1
    – 2

  • [Solved] DB Response

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    See attached. – ## DiscussionAssignmentInstructionsCJUS350.docx – ## JoyAlstonWK5.docx – ## DylanLudwickWK5.docx **## DiscussionAssignmentInstructionsCJUS350.docx** CJUS 350 **Discussion Assignment Instructions** The student will complete 8 Discussions in this course. The student will post one threa…

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    See attached.

    – ## DiscussionAssignmentInstructionsCJUS350.docx

    – ## JoyAlstonWK5.docx

    – ## DylanLudwickWK5.docx

    **## DiscussionAssignmentInstructionsCJUS350.docx**

    CJUS 350

    **Discussion Assignment Instructions**

    The student will complete 8 Discussions in this course. The student will post one thread of at least 400 words by 11:59 p.m. (ET) on Thursday of the assigned Module: Week. The student must then post at least 2 replies of at least 200 words by 11:59 p.m. (ET) on Monday of the assigned Module: Week. For each thread, students must support their assertions with at least 2 scholarly citations in APA format. Each reply must incorporate at least 2 scholarly citation(s) in APA format. Any sources cited must have been published within the last five years. Acceptable sources include the textbook, the Bible, journal articles and professional experiences.

    **## JoyAlstonWK5.docx**

    Joy Alston

    Frank Serpico’s courageous decision to expose corruption within the New York City Police Department in the 1970s remains a powerful symbol of ethical resistance in law enforcement. His experience: being shot in the face under suspicious circumstances and allegedly abandoned by fellow officers, raises critical questions about the strength of police subculture and the consequences of breaking the “blue wall of silence.”

    The “blue wall of silence” refers to an unwritten code among police officers that discourages reporting misconduct by peers. This phenomenon is not merely anecdotal; it has been substantiated by recent research. Liu (2020) describes the blue wall as a “degradation of accountability,” where officers fear retaliation, ostracization, and loss of career prospects if they report wrongdoing. This culture fosters loyalty to colleagues over duty to the public, often resulting in whistleblowers being denied backup or support in dangerous situations. Such retaliation is not rare. Bastian (2022) documents numerous cases where whistleblowers faced severe consequences, including threats, harassment, and professional sabotage.

    **Subculture Vs. Officers Individual Values**

    These accounts reinforce the idea that the subculture within policing can be so strong that it overrides individual ethics and values. Even officers with high moral standards may hesitate to report misconduct due to fear of isolation or harm. This tension between personal integrity and institutional loyalty is deeply problematic. It suggests that the subculture can indeed constrain an officer’s individual values, creating a moral conflict that few are willing to confront.

    **Effective Leadership**

    The Bible, in Hebrews 13:17, calls for obedience to leaders who “keep watch over your souls,” emphasizing the importance of leadership that inspires trust and joy—not fear or resentment. Effective leaders must therefore cultivate transparency, protect whistleblowers, and dismantle toxic norms that prioritize silence over justice. Faithful followership arises when officers believe their leaders uphold ethical standards and protect those who act with integrity. Leaders must model accountability, enforce ethical policies, and create safe channels for reporting misconduct. Without these measures, the blue wall of silence will continue to erode public trust and compromise the safety of both officers and citizens.

    **## DylanLudwickWK5.docx**

    Dylan Ludwick

    The dangers of police subculture were made clear by Frank Serpico's choice to reveal corruption in the New York City Police Department in the 1970s. Serpico was shot in the face after denouncing misconduct to the Knapp Commission, and he feels that his fellow cops abandoned him in a potentially fatal scenario. The phrase "blue wall of silence" was later created by Congressman Charles Rangel and Mayor Rudolph Giuliani to characterize this unwritten pact of allegiance among officers who choose not to disclose their peers' immoral behavior. This phenomena is a reflection of a long-standing subculture that values social cohesiveness over moral and legal responsibility. The blue wall of silence still exists as a real obstacle to fairness and openness in law enforcement.

    Anyone who is called a "rat" or "snitch" will be shunned by the strong subculture of silence, endangering both personal safety and the integrity of the organization. When coworkers decline to provide support during crucial situations, officers who confront unethical behavior run the risk of social exile, career stagnation, and even physical harm (Punch, 2009). Systemically prioritizing loyalty over the law deters whistleblowers and encourages wrongdoing, fostering an atmosphere where corruption flourishes unnoticed. Numerous internal investigations and testimony attest to the fact that the blue wall of silence endures throughout departments and eras, proving it is more than just a notion. In order to remove the protective obstacles that keep misbehavior from being held accountable, effective reform must recognize this reality.

    In the face of subcultural pressures, even officers with strong morals, ethics, and values may be reluctant to report malfeasance. A person's moral compass may be overridden by their fear of isolation, loss of camaraderie, and professional reprisal, which can result in them doing nothing when injustice occurs. Soldiers of integrity may come to the conclusion that silence is necessary for their own survival when institutional reporting systems are unreliable or intimidating. This restriction of personal beliefs damages public confidence in policing and erodes trust in leadership. Organizations must enable officers to act on their ethical convictions without fear of retaliation in order to offset this trend.

    "Obey your leaders and submit to them, for they are keeping watch over your souls, as people who will have to give an account," according to Hebrews 13:17. Allow them to accomplish this joyfully rather than moaningly, as it would not benefit you in any way (New International Version). This paragraph highlights the reciprocal accountability of leaders and followers: followers flourish under fair and caring leadership, and leaders are held to higher standards. Officers are more inclined to voice concerns and adhere to moral principles when leaders govern with honesty, openness, and respect. Confidence in leaders' dedication to justice, rather than fear, is the source of joyful obedience.

    To cultivate devoted followership, effective law enforcement officials must set an example of moral conduct, establish safe reporting channels, and embrace transparency. Posner and Kouzes (2017). Leaders establish credibility by acting and speaking consistently, which empowers officers to speak up without fear of retaliation. The creation of peer-led ethics committees, anonymous hotlines, and recurring integrity audits send a message that corruption will not be accepted and that whistleblowers are respected. These values are further ingrained in day-to-day operations through training programs that emphasize moral bravery and servant leadership. By doing this, organizations can dismantle the "blue wall of silence" and foster a culture in which honesty prevails over allegiance to misconduct.

    **## DylanLudwickWK5.docx**

    Dylan Ludwick

    The dangers of police subculture were made clear by Frank Serpico's choice to reveal corruption in the New York City Police Department in the 1970s. Serpico was shot in the face after denouncing misconduct to the Knapp Commission, and he feels that his fellow cops abandoned him in a potentially fatal scenario. The phrase "blue wall of silence" was later created by Congressman Charles Rangel and Mayor Rudolph Giuliani to characterize this unwritten pact of allegiance among officers who choose not to disclose their peers' immoral behavior. This phenomena is a reflection of a long-standing subculture that values social cohesiveness over moral and legal responsibility. The blue wall of silence still exists as a real obstacle to fairness and openness in law enforcement.

    Anyone who is called a "rat" or "snitch" will be shunned by the strong subculture of silence, endangering both personal safety and the integrity of the organization. When coworkers decline to provide support during crucial situations, officers who confront unethical behavior run the risk of social exile, career stagnation, and even physical harm (Punch, 2009). Systemically prioritizing loyalty over the law deters whistleblowers and encourages wrongdoing, fostering an atmosphere where corruption flourishes unnoticed. Numerous internal investigations and testimony attest to the fact that the blue wall of silence endures throughout departments and eras, proving it is more than just a notion. In order to remove the protective obstacles that keep misbehavior from being held accountable, effective reform must recognize this reality.

    In the face of subcultural pressures, even officers with strong morals, ethics, and values may be reluctant to report malfeasance. A person's moral compass may be overridden by their fear of isolation, loss of camaraderie, and professional reprisal, which can result in them doing nothing when injustice occurs. Soldiers of integrity may come to the conclusion that silence is necessary for their own survival when institutional reporting systems are unreliable or intimidating. This restriction of personal beliefs damages public confidence in policing and erodes trust in leadership. Organizations must enable officers to act on their ethical convictions without fear of retaliation in order to offset this trend.

    "Obey your leaders and submit to them, for they are keeping watch over your souls, as people who will have to give an account," according to Hebrews 13:17. Allow them to accomplish this joyfully rather than moaningly, as it would not benefit you in any way (New International Version). This paragraph highlights the reciprocal accountability of leaders and followers: followers flourish under fair and caring leadership, and leaders are held to higher standards. Officers are more inclined to voice concerns and adhere to moral principles when leaders govern with honesty, openness, and respect. Confidence in leaders' dedication to justice, rather than fear, is the source of joyful obedience.

    To cultivate devoted followership, effective law enforcement officials must set an example of moral conduct, establish safe reporting channels, and embrace transparency. Posner and Kouzes (2017). Leaders establish credibility by acting and speaking consistently, which empowers officers to speak up without fear of retaliation. The creation of peer-led ethics committees, anonymous hotlines, and recurring integrity audits send a message that corruption will not be accepted and that whistleblowers are respected. These values are further ingrained in day-to-day operations through training programs that emphasize moral bravery and servant leadership. By doing this, organizations can dismantle the "blue wall of silence" and foster a culture in which honesty prevails over allegiance to misconduct.

    **## DiscussionAssignmentInstructionsCJUS350.docx**

    CJUS 350

    **Discussion Assignment Instructions**

    The student will complete 8 Discussions in this course. The student will post one thread of at least 400 words by 11:59 p.m. (ET) on Thursday of the assigned Module: Week. The student must then post at least 2 replies of at least 200 words by 11:59 p.m. (ET) on Monday of the assigned Module: Week. For each thread, students must support their assertions with at least 2 scholarly citations in APA format. Each reply must incorporate at least 2 scholarly citation(s) in APA format. Any sources cited must have been published within the last five years. Acceptable sources include the textbook, the Bible, journal articles and professional experiences.

    **## JoyAlstonWK5.docx**

    Joy Alston

    Frank Serpico’s courageous decision to expose corruption within the New York City Police Department in the 1970s remains a powerful symbol of ethical resistance in law enforcement. His experience: being shot in the face under suspicious circumstances and allegedly abandoned by fellow officers, raises critical questions about the strength of police subculture and the consequences of breaking the “blue wall of silence.”

    The “blue wall of silence” refers to an unwritten code among police officers that discourages reporting misconduct by peers. This phenomenon is not merely anecdotal; it has been substantiated by recent research. Liu (2020) describes the blue wall as a “degradation of accountability,” where officers fear retaliation, ostracization, and loss of career prospects if they report wrongdoing. This culture fosters loyalty to colleagues over duty to the public, often resulting in whistleblowers being denied backup or support in dangerous situations. Such retaliation is not rare. Bastian (2022) documents numerous cases where whistleblowers faced severe consequences, including threats, harassment, and professional sabotage.

    **Subculture Vs. Officers Individual Values**

    These accounts reinforce the idea that the subculture within policing can be so strong that it overrides individual ethics and values. Even officers with high moral standards may hesitate to report misconduct due to fear of isolation or harm. This tension between personal integrity and institutional loyalty is deeply problematic. It suggests that the subculture can indeed constrain an officer’s individual values, creating a moral conflict that few are willing to confront.

    **Effective Leadership**

    The Bible, in Hebrews 13:17, calls for obedience to leaders who “keep watch over your souls,” emphasizing the importance of leadership that inspires trust and joy—not fear or resentment. Effective leaders must therefore cultivate transparency, protect whistleblowers, and dismantle toxic norms that prioritize silence over justice. Faithful followership arises when officers believe their leaders uphold ethical standards and protect those who act with integrity. Leaders must model accountability, enforce ethical policies, and create safe channels for reporting misconduct. Without these measures, the blue wall of silence will continue to erode public trust and compromise the safety of both officers and citizens.

    **## DylanLudwickWK5.docx**

    Dylan Ludwick

    The dangers of police subculture were made clear by Frank Serpico's choice to reveal corruption in the New York City Police Department in the 1970s. Serpico was shot in the face after denouncing misconduct to the Knapp Commission, and he feels that his fellow cops abandoned him in a potentially fatal scenario. The phrase "blue wall of silence" was later created by Congressman Charles Rangel and Mayor Rudolph Giuliani to characterize this unwritten pact of allegiance among officers who choose not to disclose their peers' immoral behavior. This phenomena is a reflection of a long-standing subculture that values social cohesiveness over moral and legal responsibility. The blue wall of silence still exists as a real obstacle to fairness and openness in law enforcement.

    Anyone who is called a "rat" or "snitch" will be shunned by the strong subculture of silence, endangering both personal safety and the integrity of the organization. When coworkers decline to provide support during crucial situations, officers who confront unethical behavior run the risk of social exile, career stagnation, and even physical harm (Punch, 2009). Systemically prioritizing loyalty over the law deters whistleblowers and encourages wrongdoing, fostering an atmosphere where corruption flourishes unnoticed. Numerous internal investigations and testimony attest to the fact that the blue wall of silence endures throughout departments and eras, proving it is more than just a notion. In order to remove the protective obstacles that keep misbehavior from being held accountable, effective reform must recognize this reality.

    In the face of subcultural pressures, even officers with strong morals, ethics, and values may be reluctant to report malfeasance. A person's moral compass may be overridden by their fear of isolation, loss of camaraderie, and professional reprisal, which can result in them doing nothing when injustice occurs. Soldiers of integrity may come to the conclusion that silence is necessary for their own survival when institutional reporting systems are unreliable or intimidating. This restriction of personal beliefs damages public confidence in policing and erodes trust in leadership. Organizations must enable officers to act on their ethical convictions without fear of retaliation in order to offset this trend.

    "Obey your leaders and submit to them, for they are keeping watch over your souls, as people who will have to give an account," according to Hebrews 13:17. Allow them to accomplish this joyfully rather than moaningly, as it would not benefit you in any way (New International Version). This paragraph highlights the reciprocal accountability of leaders and followers: followers flourish under fair and caring leadership, and leaders are held to higher standards. Officers are more inclined to voice concerns and adhere to moral principles when leaders govern with honesty, openness, and respect. Confidence in leaders' dedication to justice, rather than fear, is the source of joyful obedience.

    To cultivate devoted followership, effective law enforcement officials must set an example of moral conduct, establish safe reporting channels, and embrace transparency. Posner and Kouzes (2017). Leaders establish credibility by acting and speaking consistently, which empowers officers to speak up without fear of retaliation. The creation of peer-led ethics committees, anonymous hotlines, and recurring integrity audits send a message that corruption will not be accepted and that whistleblowers are respected. These values are further ingrained in day-to-day operations through training programs that emphasize moral bravery and servant leadership. By doing this, organizations can dismantle the "blue wall of silence" and foster a culture in which honesty prevails over allegiance to misconduct.

    **## DiscussionAssignmentInstructionsCJUS350.docx**

    CJUS 350

    **Discussion Assignment Instructions**

    The student will complete 8 Discussions in this course. The student will post one thread of at least 400 words by 11:59 p.m. (ET) on Thursday of the assigned Module: Week. The student must then post at least 2 replies of at least 200 words by 11:59 p.m. (ET) on Monday of the assigned Module: Week. For each thread, students must support their assertions with at least 2 scholarly citations in APA format. Each reply must incorporate at least 2 scholarly citation(s) in APA format. Any sources cited must have been published within the last five years. Acceptable sources include the textbook, the Bible, journal articles and professional experiences.

    **## JoyAlstonWK5.docx**

    Joy Alston

    Frank Serpico’s courageous decision to expose corruption within the New York City Police Department in the 1970s remains a powerful symbol of ethical resistance in law enforcement. His experience: being shot in the face under suspicious circumstances and allegedly abandoned by fellow officers, raises critical questions about the strength of police subculture and the consequences of breaking the “blue wall of silence.”

    The “blue wall of silence” refers to an unwritten code among police officers that discourages reporting misconduct by peers. This phenomenon is not merely anecdotal; it has been substantiated by recent research. Liu (2020) describes the blue wall as a “degradation of accountability,” where officers fear retaliation, ostracization, and loss of career prospects if they report wrongdoing. This culture fosters loyalty to colleagues over duty to the public, often resulting in whistleblowers being denied backup or support in dangerous situations. Such retaliation is not rare. Bastian (2022) documents numerous cases where whistleblowers faced severe consequences, including threats, harassment, and professional sabotage.

    **Subculture Vs. Officers Individual Values**

    These accounts reinforce the idea that the subculture within policing can be so strong that it overrides individual ethics and values. Even officers with high moral standards may hesitate to report misconduct due to fear of isolation or harm. This tension between personal integrity and institutional loyalty is deeply problematic. It suggests that the subculture can indeed constrain an officer’s individual values, creating a moral conflict that few are willing to confront.

    **Effective Leadership**

    The Bible, in Hebrews 13:17, calls for obedience to leaders who “keep watch over your souls,” emphasizing the importance of leadership that inspires trust and joy—not fear or resentment. Effective leaders must therefore cultivate transparency, protect whistleblowers, and dismantle toxic norms that prioritize silence over justice. Faithful followership arises when officers believe their leaders uphold ethical standards and protect those who act with integrity. Leaders must model accountability, enforce ethical policies, and create safe channels for reporting misconduct. Without these measures, the blue wall of silence will continue to erode public trust and compromise the safety of both officers and citizens.

    **## DylanLudwickWK5.docx**

    Dylan Ludwick

    The dangers of police subculture were made clear by Frank Serpico's choice to reveal corruption in the New York City Police Department in the 1970s. Serpico was shot in the face after denouncing misconduct to the Knapp Commission, and he feels that his fellow cops abandoned him in a potentially fatal scenario. The phrase "blue wall of silence" was later created by Congressman Charles Rangel and Mayor Rudolph Giuliani to characterize this unwritten pact of allegiance among officers who choose not to disclose their peers' immoral behavior. This phenomena is a reflection of a long-standing subculture that values social cohesiveness over moral and legal responsibility. The blue wall of silence still exists as a real obstacle to fairness and openness in law enforcement.

    Anyone who is called a "rat" or "snitch" will be shunned by the strong subculture of silence, endangering both personal safety and the integrity of the organization. When coworkers decline to provide support during crucial situations, officers who confront unethical behavior run the risk of social exile, career stagnation, and even physical harm (Punch, 2009). Systemically prioritizing loyalty over the law deters whistleblowers and encourages wrongdoing, fostering an atmosphere where corruption flourishes unnoticed. Numerous internal investigations and testimony attest to the fact that the blue wall of silence endures throughout departments and eras, proving it is more than just a notion. In order to remove the protective obstacles that keep misbehavior from being held accountable, effective reform must recognize this reality.

    In the face of subcultural pressures, even officers with strong morals, ethics, and values may be reluctant to report malfeasance. A person's moral compass may be overridden by their fear of isolation, loss of camaraderie, and professional reprisal, which can result in them doing nothing when injustice occurs. Soldiers of integrity may come to the conclusion that silence is necessary for their own survival when institutional reporting systems are unreliable or intimidating. This restriction of personal beliefs damages public confidence in policing and erodes trust in leadership. Organizations must enable officers to act on their ethical convictions without fear of retaliation in order to offset this trend.

    "Obey your leaders and submit to them, for they are keeping watch over your souls, as people who will have to give an account," according to Hebrews 13:17. Allow them to accomplish this joyfully rather than moaningly, as it would not benefit you in any way (New International Version). This paragraph highlights the reciprocal accountability of leaders and followers: followers flourish under fair and caring leadership, and leaders are held to higher standards. Officers are more inclined to voice concerns and adhere to moral principles when leaders govern with honesty, openness, and respect. Confidence in leaders' dedication to justice, rather than fear, is the source of joyful obedience.

    To cultivate devoted followership, effective law enforcement officials must set an example of moral conduct, establish safe reporting channels, and embrace transparency. Posner and Kouzes (2017). Leaders establish credibility by acting and speaking consistently, which empowers officers to speak up without fear of retaliation. The creation of peer-led ethics committees, anonymous hotlines, and recurring integrity audits send a message that corruption will not be accepted and that whistleblowers are respected. These values are further ingrained in day-to-day operations through training programs that emphasize moral bravery and servant leadership. By doing this, organizations can dismantle the "blue wall of silence" and foster a culture in which honesty prevails over allegiance to misconduct.

    – 1
    – 2
    – 3

  • [Solved] Excel2G

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    – ## Excel_2G_Inventory_Instructions.docx – Slice.thmx – 2G_Inventory_final_result.jpg – clayton_Excel_2G_Inventory.xlsx **## Excel_2G_Inventory_Instructions.docx** Grader – Instructions Excel 2021 Project ## **Excel_2G_Inventory** ### **Project Description:** In the following project,…

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    – ## Excel_2G_Inventory_Instructions.docx

    – Slice.thmx
    – 2G_Inventory_final_result.jpg
    – clayton_Excel_2G_Inventory.xlsx

    **## Excel_2G_Inventory_Instructions.docx**

    Grader – Instructions Excel 2021 Project

    ## **Excel_2G_Inventory**

    ### **Project Description:**

    In the following project, you will edit a worksheet that summarizes the inventory of bulbs and trees at the Pasadena facility.

    ### **Steps to Perform:**

    | | | |
    | — | — | — |
    | **Step** | **Instructions** | **Points Possible** |
    | 1 | Open the Excel workbook <br>_Student_Excel_2G_Inventory.xlsx_ downloaded with this project. | 0 |
    | 2 | Change the Theme to Slice. Rename Sheet1 as <br>**Bulbs** and Sheet2 as <br>**Trees**, and then make the Bulbs sheet the active sheet.<br>If the theme is not available, click Browse for Themes, navigate to your downloaded files, and select <br>_Slice.thmx_. | 3 |
    | 3 | To the right of column B, insert two new columns to create new blank columns C and D. By using Flash Fill in the two new columns, split the data in column B into a column for Item # in column C and Category in column D. | 5 |
    | 4 | Type <br>**Item #** as the column title in column C and <br>**Category** as the column title in column D. Delete column B. By using the Cut and Paste commands, cut column C—Category—and paste it to column G, and then delete the empty column C. Apply AutoFit to columns A:F. | 1 |
    | 5 | Display the Trees worksheet, and then repeat Steps 3 and 4 on this worksheet. | 6 |
    | 6 | Make the following calculations in each of the two worksheets without grouping the sheets:<br>•In cell B4, enter a function to sum the Quantity in Stock data, and then apply Comma Style with zero decimal places to the result.<br>•In cells B5:B8, enter formulas to calculate the Average, Median, Lowest, and Highest retail prices, and then apply the Accounting Number Format. | 14 |
    | 7 | In each of the two worksheets, make the following calculation without grouping the sheets:<br>In cell B10, enter a COUNTIF function to determine how many different types of <br>**Tulips** are in stock on the Bulbs sheet and how many different types of <br>**Evergreens** are in stock on the Trees worksheet. | 6 |
    | 8 | Without grouping the worksheets, complete the following in each worksheet:<br>• In cell G14, type <br>**Stock Level**<br>• In cell G15, construct an IF function to determine the items that must be ordered. If the Quantity in Stock is less than <br>**75** the Value_if_true is <br>**Order.** Otherwise the Value_if_false is <br>**OK.** Fill the formula down through all the rows. | 8 |
    | 9 | Without grouping the worksheets, apply conditional formatting as follows to both worksheets:<br>•Apply Conditional Formatting to the range of cells containing the Stock Level so that cells that contain the text <br>_Order_ are formatted with Bold Italic, font color set to Automatic, and Fill color set to No Color.<br>•Apply Gradient Fill Blue Data Bars to the range of cells containing the Quantity in Stock. | 4 |
    | 10 | In the Bulbs sheet, format the range A14:G42 as a table with headers and apply Light Orange, Table Style Light 20. If the style isn’t available, choose another style. Insert a Total Row, filter by Category for Tulips, and then Sum the Quantity in Stock column. Record the result in cell B11. | 3 |
    | 11 | Select the table, clear the filter, Sort the table on the Item # column from Smallest to Largest (Ascending) and then remove the Total Row. On the Page Layout tab, set Print Titles so that row 14 repeats at the top of each page. | 3 |
    | 12 | In the Trees sheet, format the range A14:G42 as a table with headers and apply Light Green, Table Style Light 19. If the style isn’t available, choose another style. Insert a Total Row, filter by Category for Evergreens, and then Sum the Quantity in Stock column. Record the result in cell B11. | 3 |
    | 13 | Select the table, clear the filter, Sort the table on the Item # column from Smallest to Largest (Ascending), and then remove the Total Row. On the Page Layout tab, set Print Titles so that row 14 repeats at the top of each page, and then Save your workbook. | 3 |
    | 14 | Group the two worksheets. Merge & Center the title in cell A1 across the range A1:G1 and apply the Title cell style. Merge & Center the subtitle in cell A2 across the range A2:G2 and apply the Heading 1 cell style. AutoFit columns A:G. | 5 |
    | 15 | With the worksheets still grouped, center the worksheets Horizontally, change the Orientation to Landscape, and insert a footer in the left section with the file name. Display the Print Preview, and then change the Settings to Fit All Columns on One Page. <br>(Mac users, on the Page Layout tab, change the Width to 1 page.) | 5 |
    | 16 | Save your workbook and then ungroup the sheets. View both worksheets and apply AutoFit to any column in which the data does not fully display. Make the Trees sheet the active sheet, and then insert a new worksheet. Change the new sheet name to <br>**Summary** and then move the Summary sheet so that it is the first sheet in the workbook. Widen columns A:D to <br>**20**. | 2 |
    | 17 | In cell A1, type <br>**Pasadena Inventory Summary**. Merge & Center the title across the range A1:D1, and then apply the Title cell style. In cell A2, type <br>**As of December 31** and then Merge & Center the text across the range A2:D2. Apply the Heading 1 cell style. | 4 |
    | 18 | On the Bulbs sheet, Copy the range A4:A8. Display the Summary sheet and Paste the selection to cell A5. Apply the Heading 4 cell style to the selection. | 2 |
    | 19 | In the Summary sheet, in cell B4, type <br>**Bulbs**. In cell C4 type <br>**Trees**. In cell D4 type <br>**Bulbs/Trees**. Center the column titles, and then apply the Heading 3 cell style. | 3 |
    | 20 | In cell B5, enter a formula that references cell B4 in the Bulbs sheet so that the Bulbs Total Items in Stock displays in B5. Create similar formulas to enter the Average Price, Median Price, Lowest Price, and Highest Price from the Bulbs sheet into the Summary sheet in the range B6:B9. | 5 |
    | 21 | Enter formulas in the range C5:C9 that reference the Total Items in stock and the Average Price, Median Price, Lowest Price, and Highest Price cells in the Trees worksheet. | 5 |
    | 22 | In cells D5, D6, D7, D8, and D9, insert Column sparklines using the values in the Bulbs and Trees columns. Format each sparkline using the first five Sparkline styles in the first row. | 5 |
    | 23 | To the range B5:C5, apply Comma Style with zero decimal places, and to the range B6:C9, apply Accounting Number Format. Center the Summary worksheet Horizontally and change the Orientation to Landscape. Insert a footer in the left section with the File Name. | 5 |
    | 24 | Save and close the file, and then submit for grading. | 0 |

    | | |
    | — | — |
    | **Total Points** | **100** |

    Created On: 11/06/2023 1 GO22_XL_CH02_GRADER_2G_HW – Inventory 1.3

    **Slice.thmx**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/slice-thmx)

    **2G_Inventory_final_result.jpg**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/2g-inventory-final-result-jpg)

    **clayton_Excel_2G_Inventory.xlsx**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/clayton-excel-2g-inventory-xlsx)

    **clayton_Excel_2G_Inventory.xlsx**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/clayton-excel-2g-inventory-xlsx)

    **## Excel_2G_Inventory_Instructions.docx**

    Grader – Instructions Excel 2021 Project

    ## **Excel_2G_Inventory**

    ### **Project Description:**

    In the following project, you will edit a worksheet that summarizes the inventory of bulbs and trees at the Pasadena facility.

    ### **Steps to Perform:**

    | | | |
    | — | — | — |
    | **Step** | **Instructions** | **Points Possible** |
    | 1 | Open the Excel workbook <br>_Student_Excel_2G_Inventory.xlsx_ downloaded with this project. | 0 |
    | 2 | Change the Theme to Slice. Rename Sheet1 as <br>**Bulbs** and Sheet2 as <br>**Trees**, and then make the Bulbs sheet the active sheet.<br>If the theme is not available, click Browse for Themes, navigate to your downloaded files, and select <br>_Slice.thmx_. | 3 |
    | 3 | To the right of column B, insert two new columns to create new blank columns C and D. By using Flash Fill in the two new columns, split the data in column B into a column for Item # in column C and Category in column D. | 5 |
    | 4 | Type <br>**Item #** as the column title in column C and <br>**Category** as the column title in column D. Delete column B. By using the Cut and Paste commands, cut column C—Category—and paste it to column G, and then delete the empty column C. Apply AutoFit to columns A:F. | 1 |
    | 5 | Display the Trees worksheet, and then repeat Steps 3 and 4 on this worksheet. | 6 |
    | 6 | Make the following calculations in each of the two worksheets without grouping the sheets:<br>•In cell B4, enter a function to sum the Quantity in Stock data, and then apply Comma Style with zero decimal places to the result.<br>•In cells B5:B8, enter formulas to calculate the Average, Median, Lowest, and Highest retail prices, and then apply the Accounting Number Format. | 14 |
    | 7 | In each of the two worksheets, make the following calculation without grouping the sheets:<br>In cell B10, enter a COUNTIF function to determine how many different types of <br>**Tulips** are in stock on the Bulbs sheet and how many different types of <br>**Evergreens** are in stock on the Trees worksheet. | 6 |
    | 8 | Without grouping the worksheets, complete the following in each worksheet:<br>• In cell G14, type <br>**Stock Level**<br>• In cell G15, construct an IF function to determine the items that must be ordered. If the Quantity in Stock is less than <br>**75** the Value_if_true is <br>**Order.** Otherwise the Value_if_false is <br>**OK.** Fill the formula down through all the rows. | 8 |
    | 9 | Without grouping the worksheets, apply conditional formatting as follows to both worksheets:<br>•Apply Conditional Formatting to the range of cells containing the Stock Level so that cells that contain the text <br>_Order_ are formatted with Bold Italic, font color set to Automatic, and Fill color set to No Color.<br>•Apply Gradient Fill Blue Data Bars to the range of cells containing the Quantity in Stock. | 4 |
    | 10 | In the Bulbs sheet, format the range A14:G42 as a table with headers and apply Light Orange, Table Style Light 20. If the style isn’t available, choose another style. Insert a Total Row, filter by Category for Tulips, and then Sum the Quantity in Stock column. Record the result in cell B11. | 3 |
    | 11 | Select the table, clear the filter, Sort the table on the Item # column from Smallest to Largest (Ascending) and then remove the Total Row. On the Page Layout tab, set Print Titles so that row 14 repeats at the top of each page. | 3 |
    | 12 | In the Trees sheet, format the range A14:G42 as a table with headers and apply Light Green, Table Style Light 19. If the style isn’t available, choose another style. Insert a Total Row, filter by Category for Evergreens, and then Sum the Quantity in Stock column. Record the result in cell B11. | 3 |
    | 13 | Select the table, clear the filter, Sort the table on the Item # column from Smallest to Largest (Ascending), and then remove the Total Row. On the Page Layout tab, set Print Titles so that row 14 repeats at the top of each page, and then Save your workbook. | 3 |
    | 14 | Group the two worksheets. Merge & Center the title in cell A1 across the range A1:G1 and apply the Title cell style. Merge & Center the subtitle in cell A2 across the range A2:G2 and apply the Heading 1 cell style. AutoFit columns A:G. | 5 |
    | 15 | With the worksheets still grouped, center the worksheets Horizontally, change the Orientation to Landscape, and insert a footer in the left section with the file name. Display the Print Preview, and then change the Settings to Fit All Columns on One Page. <br>(Mac users, on the Page Layout tab, change the Width to 1 page.) | 5 |
    | 16 | Save your workbook and then ungroup the sheets. View both worksheets and apply AutoFit to any column in which the data does not fully display. Make the Trees sheet the active sheet, and then insert a new worksheet. Change the new sheet name to <br>**Summary** and then move the Summary sheet so that it is the first sheet in the workbook. Widen columns A:D to <br>**20**. | 2 |
    | 17 | In cell A1, type <br>**Pasadena Inventory Summary**. Merge & Center the title across the range A1:D1, and then apply the Title cell style. In cell A2, type <br>**As of December 31** and then Merge & Center the text across the range A2:D2. Apply the Heading 1 cell style. | 4 |
    | 18 | On the Bulbs sheet, Copy the range A4:A8. Display the Summary sheet and Paste the selection to cell A5. Apply the Heading 4 cell style to the selection. | 2 |
    | 19 | In the Summary sheet, in cell B4, type <br>**Bulbs**. In cell C4 type <br>**Trees**. In cell D4 type <br>**Bulbs/Trees**. Center the column titles, and then apply the Heading 3 cell style. | 3 |
    | 20 | In cell B5, enter a formula that references cell B4 in the Bulbs sheet so that the Bulbs Total Items in Stock displays in B5. Create similar formulas to enter the Average Price, Median Price, Lowest Price, and Highest Price from the Bulbs sheet into the Summary sheet in the range B6:B9. | 5 |
    | 21 | Enter formulas in the range C5:C9 that reference the Total Items in stock and the Average Price, Median Price, Lowest Price, and Highest Price cells in the Trees worksheet. | 5 |
    | 22 | In cells D5, D6, D7, D8, and D9, insert Column sparklines using the values in the Bulbs and Trees columns. Format each sparkline using the first five Sparkline styles in the first row. | 5 |
    | 23 | To the range B5:C5, apply Comma Style with zero decimal places, and to the range B6:C9, apply Accounting Number Format. Center the Summary worksheet Horizontally and change the Orientation to Landscape. Insert a footer in the left section with the File Name. | 5 |
    | 24 | Save and close the file, and then submit for grading. | 0 |

    | | |
    | — | — |
    | **Total Points** | **100** |

    Created On: 11/06/2023 1 GO22_XL_CH02_GRADER_2G_HW – Inventory 1.3

    **Slice.thmx**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/slice-thmx)

    **2G_Inventory_final_result.jpg**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/2g-inventory-final-result-jpg)

    **clayton_Excel_2G_Inventory.xlsx**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/clayton-excel-2g-inventory-xlsx)

    **## Excel_2G_Inventory_Instructions.docx**

    Grader – Instructions Excel 2021 Project

    ## **Excel_2G_Inventory**

    ### **Project Description:**

    In the following project, you will edit a worksheet that summarizes the inventory of bulbs and trees at the Pasadena facility.

    ### **Steps to Perform:**

    | | | |
    | — | — | — |
    | **Step** | **Instructions** | **Points Possible** |
    | 1 | Open the Excel workbook <br>_Student_Excel_2G_Inventory.xlsx_ downloaded with this project. | 0 |
    | 2 | Change the Theme to Slice. Rename Sheet1 as <br>**Bulbs** and Sheet2 as <br>**Trees**, and then make the Bulbs sheet the active sheet.<br>If the theme is not available, click Browse for Themes, navigate to your downloaded files, and select <br>_Slice.thmx_. | 3 |
    | 3 | To the right of column B, insert two new columns to create new blank columns C and D. By using Flash Fill in the two new columns, split the data in column B into a column for Item # in column C and Category in column D. | 5 |
    | 4 | Type <br>**Item #** as the column title in column C and <br>**Category** as the column title in column D. Delete column B. By using the Cut and Paste commands, cut column C—Category—and paste it to column G, and then delete the empty column C. Apply AutoFit to columns A:F. | 1 |
    | 5 | Display the Trees worksheet, and then repeat Steps 3 and 4 on this worksheet. | 6 |
    | 6 | Make the following calculations in each of the two worksheets without grouping the sheets:<br>•In cell B4, enter a function to sum the Quantity in Stock data, and then apply Comma Style with zero decimal places to the result.<br>•In cells B5:B8, enter formulas to calculate the Average, Median, Lowest, and Highest retail prices, and then apply the Accounting Number Format. | 14 |
    | 7 | In each of the two worksheets, make the following calculation without grouping the sheets:<br>In cell B10, enter a COUNTIF function to determine how many different types of <br>**Tulips** are in stock on the Bulbs sheet and how many different types of <br>**Evergreens** are in stock on the Trees worksheet. | 6 |
    | 8 | Without grouping the worksheets, complete the following in each worksheet:<br>• In cell G14, type <br>**Stock Level**<br>• In cell G15, construct an IF function to determine the items that must be ordered. If the Quantity in Stock is less than <br>**75** the Value_if_true is <br>**Order.** Otherwise the Value_if_false is <br>**OK.** Fill the formula down through all the rows. | 8 |
    | 9 | Without grouping the worksheets, apply conditional formatting as follows to both worksheets:<br>•Apply Conditional Formatting to the range of cells containing the Stock Level so that cells that contain the text <br>_Order_ are formatted with Bold Italic, font color set to Automatic, and Fill color set to No Color.<br>•Apply Gradient Fill Blue Data Bars to the range of cells containing the Quantity in Stock. | 4 |
    | 10 | In the Bulbs sheet, format the range A14:G42 as a table with headers and apply Light Orange, Table Style Light 20. If the style isn’t available, choose another style. Insert a Total Row, filter by Category for Tulips, and then Sum the Quantity in Stock column. Record the result in cell B11. | 3 |
    | 11 | Select the table, clear the filter, Sort the table on the Item # column from Smallest to Largest (Ascending) and then remove the Total Row. On the Page Layout tab, set Print Titles so that row 14 repeats at the top of each page. | 3 |
    | 12 | In the Trees sheet, format the range A14:G42 as a table with headers and apply Light Green, Table Style Light 19. If the style isn’t available, choose another style. Insert a Total Row, filter by Category for Evergreens, and then Sum the Quantity in Stock column. Record the result in cell B11. | 3 |
    | 13 | Select the table, clear the filter, Sort the table on the Item # column from Smallest to Largest (Ascending), and then remove the Total Row. On the Page Layout tab, set Print Titles so that row 14 repeats at the top of each page, and then Save your workbook. | 3 |
    | 14 | Group the two worksheets. Merge & Center the title in cell A1 across the range A1:G1 and apply the Title cell style. Merge & Center the subtitle in cell A2 across the range A2:G2 and apply the Heading 1 cell style. AutoFit columns A:G. | 5 |
    | 15 | With the worksheets still grouped, center the worksheets Horizontally, change the Orientation to Landscape, and insert a footer in the left section with the file name. Display the Print Preview, and then change the Settings to Fit All Columns on One Page. <br>(Mac users, on the Page Layout tab, change the Width to 1 page.) | 5 |
    | 16 | Save your workbook and then ungroup the sheets. View both worksheets and apply AutoFit to any column in which the data does not fully display. Make the Trees sheet the active sheet, and then insert a new worksheet. Change the new sheet name to <br>**Summary** and then move the Summary sheet so that it is the first sheet in the workbook. Widen columns A:D to <br>**20**. | 2 |
    | 17 | In cell A1, type <br>**Pasadena Inventory Summary**. Merge & Center the title across the range A1:D1, and then apply the Title cell style. In cell A2, type <br>**As of December 31** and then Merge & Center the text across the range A2:D2. Apply the Heading 1 cell style. | 4 |
    | 18 | On the Bulbs sheet, Copy the range A4:A8. Display the Summary sheet and Paste the selection to cell A5. Apply the Heading 4 cell style to the selection. | 2 |
    | 19 | In the Summary sheet, in cell B4, type <br>**Bulbs**. In cell C4 type <br>**Trees**. In cell D4 type <br>**Bulbs/Trees**. Center the column titles, and then apply the Heading 3 cell style. | 3 |
    | 20 | In cell B5, enter a formula that references cell B4 in the Bulbs sheet so that the Bulbs Total Items in Stock displays in B5. Create similar formulas to enter the Average Price, Median Price, Lowest Price, and Highest Price from the Bulbs sheet into the Summary sheet in the range B6:B9. | 5 |
    | 21 | Enter formulas in the range C5:C9 that reference the Total Items in stock and the Average Price, Median Price, Lowest Price, and Highest Price cells in the Trees worksheet. | 5 |
    | 22 | In cells D5, D6, D7, D8, and D9, insert Column sparklines using the values in the Bulbs and Trees columns. Format each sparkline using the first five Sparkline styles in the first row. | 5 |
    | 23 | To the range B5:C5, apply Comma Style with zero decimal places, and to the range B6:C9, apply Accounting Number Format. Center the Summary worksheet Horizontally and change the Orientation to Landscape. Insert a footer in the left section with the File Name. | 5 |
    | 24 | Save and close the file, and then submit for grading. | 0 |

    | | |
    | — | — |
    | **Total Points** | **100** |

    Created On: 11/06/2023 1 GO22_XL_CH02_GRADER_2G_HW – Inventory 1.3

    **Slice.thmx**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/slice-thmx)

    **2G_Inventory_final_result.jpg**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/2g-inventory-final-result-jpg)

    **clayton_Excel_2G_Inventory.xlsx**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/clayton-excel-2g-inventory-xlsx)

    – 1
    – 2
    – 3
    – 4

  • [Solved] excel3g

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    – ## clayton_Excel_3G_Expenses.xlsx – ## Excel_3G_Expenses_Instructions.docx – 3G_Expenses_final_result.JPG **## clayton_Excel_3G_Expenses.xlsx** ## Expenses | | | | | | | | | — | — | — | — | — | — | — | | City of Springbury | | Recreation Department Summary of Annual Expen…

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    – ## clayton_Excel_3G_Expenses.xlsx

    – ## Excel_3G_Expenses_Instructions.docx

    – 3G_Expenses_final_result.JPG

    **## clayton_Excel_3G_Expenses.xlsx**

    ## Expenses

    | | | | | | | |
    | — | — | — | — | — | — | — |
    | City of Springbury |
    | Recreation Department Summary of Annual Expenses |

    | | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Annual Total | Percent of Total |
    | Salaries and Benefits | $ 821,215 | $ 812,457 | $ 796,650 | $ 882,655 |
    | Facility Rental | 125,730 | 189,425 | 124,630 | 216,356 |
    | Materials and Equipment | 325,680 | 368,942 | 339,874 | 315,500 |
    | Contract Services | 465,278 | 378,210 | 529,743 | 442,105 |
    | Administrative Costs | 286,550 | 301,226 | 297,412 | 325,687 |
    | Totals by Quarter |

    | Expenses 5-Year Forecast |
    | Forecasted Increase | 3.5% |
    | Year | 2024 | 2025 | 2026 | 2027 | 2028 |
    | Projected Expenses |

    ## Enrollment

    | | |
    | — | — |
    | Recreation Department |
    | Workshop Annual Enrollment Analysis |

    | Enrolled Residents | 2,265 |
    | Submitted Payment | 1,895 |
    | Attended | 1,698 |

    ## County Partnership

    | | | |
    | — | — | — |
    | Recreation Department |
    | City/County Partnership Analysis |
    | County | State | Number of<br>Partnered Cities |
    | Bergen | New Jersey | 12 |
    | Camden | New Jersey | 5 |
    | Mercer | New Jersey | 8 |
    | Passaic | New Jersey | 15 |
    | Somerset | New Jersey | 10 |
    | Union | New Jersey | 20 |

    **## Excel_3G_Expenses_Instructions.docx**

    Grader – Instructions Excel 2022 Project

    ## **Excel_3G_Expenses**

    ### **Project Description:**

    In the following project, you will edit a worksheet that will be used to summarize the operations costs for the Public Works Department.

    ### **Steps to Perform:**

    | | | |
    | — | — | — |
    | **Step** | **Instructions** | **Points Possible** |
    | 1 | Open the Excel workbook <br>_Student_Excel_3G_Expenses.xlsx_ downloaded with this project. | 0 |
    | 2 | In the Expenses worksheet, calculate row totals for each Expense item in the range F5:F9. Calculate column totals for each quarter and for the Annual Total in the range B10:F10. Be sure that F6:F9 are formatted with Comma Style and zero decimal places. | 5 |
    | 3 | In cell G5, construct a formula to calculate the Percent of Total by dividing the Annual Total for Salaries and Benefits by the Annual Total for all quarters. Use absolute cell references as necessary, format the result in Percent Style, and then Center. Fill the formula down through cell G9. | 9 |
    | 4 | Use a 3-D Pie chart to chart the Annual Total for each item. Move the chart to a new sheet and then name the sheet <br>**Annual Expenses Chart** | 7 |
    | 5 | As the text for the Chart Title element, type<br>**Summary of Annual Expenses** and then change the Font Size to 28. | 4 |
    | 6 | Remove the Legend from the chart and then add Data Labels formatted so that only the Category Name and Percentage display positioned in the Center. Format the data labels by applying a Font style of Bold and Italic and a Font Size of 12. Change the Font Color—in the first column, click the first color. | 9 |
    | 7 | Format the Data Series using a 3-D Format effect. Change the Top bevel and Bottom bevel–under Bevel, in the first row, apply the first bevel effect. Set the Top and Bottom bevel Width and Height to <br>**100 pt** | 2 |
    | 8 | Display the Series Options, and then set the Angle of first slice to <br>**125** so that the Salaries and Benefits slice is in the front of the pie. Select the Salaries and Benefits slice, and then explode the slice <br>**10%**. | 4 |
    | 9 | Format the Chart Area by applying a Gradient fill using the Preset gradients—in the second column, apply the first gradient. Format the Border of the Chart Area by adding a Solid line border—in the last column, apply the first color. Change the Width to <br>**3 pt** | 6 |
    | 10 | Display the Page Setup dialog box, and then for this chart sheet, insert a custom footer in the left section with the file name. | 4 |
    | 11 | Display the Expenses worksheet, and then by using the Quarter names and the Totals by Quarter, insert a Line with Markers chart in the worksheet. Do <br>_not_ include the Annual Total. Move the chart so that its upper left corner is positioned slightly inside the upper left corner of cell A12. Change the Width of the chart to <br>**7.5** and then as the Chart Title, type <br>**Recreation Department Expense Summary** | 8 |
    | 12 | Format the Bounds of the Vertical (Value) Axis so that the Minimum is <br>**2000000** Apply Bold to the values on the Vertical (Value) Axis and to the labels on the Horizontal (Category) Axis. | 10 |
    | 13 | Display the Format Chart Area pane. Click Fill & Line, and then expand the Border section. Select the Solid line option, display the Color gallery, and then in the last column, click the first color. Change the Width to <br>**2 pt** and then Close the Format Chart Area pane. Click cell A1 to deselect the chart, and then Save your workbook. | 1 |
    | 14 | Copy the Annual Total in cell F10 and then use Paste Special to paste Values & Number Formatting in cell B35. In cell C35, construct a formula to calculate the Projected Expenses after the forecasted increase of 3.5% in cell B31 is applied. Fill the formula through cell F35, and then use Format Painter to copy the formatting from cell B35 to the range C35:F35. | 10 |
    | 15 | In the Page Setup dialog box, center this worksheet Horizontally, and insert a Custom Footer in the left section with the file name. Save your workbook. | 6 |
    | 16 | Display the Enrollment worksheet. Insert a Funnel chart that shows resident workshop participation for the year using the range A4:B6. Change the Height of the chart to <br>**2.5** and the Width to<br>**3.5** and then drag the chart so that the upper left corner aligns with the upper left corner of A9. Change the chart title to <br>**Enrollment Analysis** and then click cell A1. Center the worksheet Horizontally and insert a Custom Footer in the left section with the file name. | 6 |
    | 17 | Display the County Partnership worksheet. The City of Springbury is partnering with the County to offer workshops to residents. The Recreation Department staff will visit several cities with similar partnership agreements. Using the range A3:C9, insert a Filled Map chart. Change the chart title to <br>**Partnership Analysis** and then drag the chart so that the upper left corner aligns with the upper left corner of A11. Change the chart Width to <br>**4.5** and then click cell A1. | 3 |
    | 18 | Center this worksheet Horizontally and insert a Custom Footer in the left section with the file name. Display the workbook Properties. As the Tags, type <br>**recreation** and as the Subject, type your course name and section number. Be sure your name displays as the Author. | 6 |
    | 19 | Save and close the file, and then submit for grading. | 0 |

    | | |
    | — | — |
    | **Total Points** | **100** |

    Created On: 08/04/2022 1 GO22_XL_CH03_GRADER_3G_HW – Expenses 1.0

    **3G_Expenses_final_result.JPG**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/3g-expenses-final-result-jpg-10405509)

    **3G_Expenses_final_result.JPG**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/3g-expenses-final-result-jpg-10405509)

    **## clayton_Excel_3G_Expenses.xlsx**

    ## Expenses

    | | | | | | | |
    | — | — | — | — | — | — | — |
    | City of Springbury |
    | Recreation Department Summary of Annual Expenses |

    | | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Annual Total | Percent of Total |
    | Salaries and Benefits | $ 821,215 | $ 812,457 | $ 796,650 | $ 882,655 |
    | Facility Rental | 125,730 | 189,425 | 124,630 | 216,356 |
    | Materials and Equipment | 325,680 | 368,942 | 339,874 | 315,500 |
    | Contract Services | 465,278 | 378,210 | 529,743 | 442,105 |
    | Administrative Costs | 286,550 | 301,226 | 297,412 | 325,687 |
    | Totals by Quarter |

    | Expenses 5-Year Forecast |
    | Forecasted Increase | 3.5% |
    | Year | 2024 | 2025 | 2026 | 2027 | 2028 |
    | Projected Expenses |

    ## Enrollment

    | | |
    | — | — |
    | Recreation Department |
    | Workshop Annual Enrollment Analysis |

    | Enrolled Residents | 2,265 |
    | Submitted Payment | 1,895 |
    | Attended | 1,698 |

    ## County Partnership

    | | | |
    | — | — | — |
    | Recreation Department |
    | City/County Partnership Analysis |
    | County | State | Number of<br>Partnered Cities |
    | Bergen | New Jersey | 12 |
    | Camden | New Jersey | 5 |
    | Mercer | New Jersey | 8 |
    | Passaic | New Jersey | 15 |
    | Somerset | New Jersey | 10 |
    | Union | New Jersey | 20 |

    **## Excel_3G_Expenses_Instructions.docx**

    Grader – Instructions Excel 2022 Project

    ## **Excel_3G_Expenses**

    ### **Project Description:**

    In the following project, you will edit a worksheet that will be used to summarize the operations costs for the Public Works Department.

    ### **Steps to Perform:**

    | | | |
    | — | — | — |
    | **Step** | **Instructions** | **Points Possible** |
    | 1 | Open the Excel workbook <br>_Student_Excel_3G_Expenses.xlsx_ downloaded with this project. | 0 |
    | 2 | In the Expenses worksheet, calculate row totals for each Expense item in the range F5:F9. Calculate column totals for each quarter and for the Annual Total in the range B10:F10. Be sure that F6:F9 are formatted with Comma Style and zero decimal places. | 5 |
    | 3 | In cell G5, construct a formula to calculate the Percent of Total by dividing the Annual Total for Salaries and Benefits by the Annual Total for all quarters. Use absolute cell references as necessary, format the result in Percent Style, and then Center. Fill the formula down through cell G9. | 9 |
    | 4 | Use a 3-D Pie chart to chart the Annual Total for each item. Move the chart to a new sheet and then name the sheet <br>**Annual Expenses Chart** | 7 |
    | 5 | As the text for the Chart Title element, type<br>**Summary of Annual Expenses** and then change the Font Size to 28. | 4 |
    | 6 | Remove the Legend from the chart and then add Data Labels formatted so that only the Category Name and Percentage display positioned in the Center. Format the data labels by applying a Font style of Bold and Italic and a Font Size of 12. Change the Font Color—in the first column, click the first color. | 9 |
    | 7 | Format the Data Series using a 3-D Format effect. Change the Top bevel and Bottom bevel–under Bevel, in the first row, apply the first bevel effect. Set the Top and Bottom bevel Width and Height to <br>**100 pt** | 2 |
    | 8 | Display the Series Options, and then set the Angle of first slice to <br>**125** so that the Salaries and Benefits slice is in the front of the pie. Select the Salaries and Benefits slice, and then explode the slice <br>**10%**. | 4 |
    | 9 | Format the Chart Area by applying a Gradient fill using the Preset gradients—in the second column, apply the first gradient. Format the Border of the Chart Area by adding a Solid line border—in the last column, apply the first color. Change the Width to <br>**3 pt** | 6 |
    | 10 | Display the Page Setup dialog box, and then for this chart sheet, insert a custom footer in the left section with the file name. | 4 |
    | 11 | Display the Expenses worksheet, and then by using the Quarter names and the Totals by Quarter, insert a Line with Markers chart in the worksheet. Do <br>_not_ include the Annual Total. Move the chart so that its upper left corner is positioned slightly inside the upper left corner of cell A12. Change the Width of the chart to <br>**7.5** and then as the Chart Title, type <br>**Recreation Department Expense Summary** | 8 |
    | 12 | Format the Bounds of the Vertical (Value) Axis so that the Minimum is <br>**2000000** Apply Bold to the values on the Vertical (Value) Axis and to the labels on the Horizontal (Category) Axis. | 10 |
    | 13 | Display the Format Chart Area pane. Click Fill & Line, and then expand the Border section. Select the Solid line option, display the Color gallery, and then in the last column, click the first color. Change the Width to <br>**2 pt** and then Close the Format Chart Area pane. Click cell A1 to deselect the chart, and then Save your workbook. | 1 |
    | 14 | Copy the Annual Total in cell F10 and then use Paste Special to paste Values & Number Formatting in cell B35. In cell C35, construct a formula to calculate the Projected Expenses after the forecasted increase of 3.5% in cell B31 is applied. Fill the formula through cell F35, and then use Format Painter to copy the formatting from cell B35 to the range C35:F35. | 10 |
    | 15 | In the Page Setup dialog box, center this worksheet Horizontally, and insert a Custom Footer in the left section with the file name. Save your workbook. | 6 |
    | 16 | Display the Enrollment worksheet. Insert a Funnel chart that shows resident workshop participation for the year using the range A4:B6. Change the Height of the chart to <br>**2.5** and the Width to<br>**3.5** and then drag the chart so that the upper left corner aligns with the upper left corner of A9. Change the chart title to <br>**Enrollment Analysis** and then click cell A1. Center the worksheet Horizontally and insert a Custom Footer in the left section with the file name. | 6 |
    | 17 | Display the County Partnership worksheet. The City of Springbury is partnering with the County to offer workshops to residents. The Recreation Department staff will visit several cities with similar partnership agreements. Using the range A3:C9, insert a Filled Map chart. Change the chart title to <br>**Partnership Analysis** and then drag the chart so that the upper left corner aligns with the upper left corner of A11. Change the chart Width to <br>**4.5** and then click cell A1. | 3 |
    | 18 | Center this worksheet Horizontally and insert a Custom Footer in the left section with the file name. Display the workbook Properties. As the Tags, type <br>**recreation** and as the Subject, type your course name and section number. Be sure your name displays as the Author. | 6 |
    | 19 | Save and close the file, and then submit for grading. | 0 |

    | | |
    | — | — |
    | **Total Points** | **100** |

    Created On: 08/04/2022 1 GO22_XL_CH03_GRADER_3G_HW – Expenses 1.0

    **3G_Expenses_final_result.JPG**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/3g-expenses-final-result-jpg-10405509)

    **## clayton_Excel_3G_Expenses.xlsx**

    ## Expenses

    | | | | | | | |
    | — | — | — | — | — | — | — |
    | City of Springbury |
    | Recreation Department Summary of Annual Expenses |

    | | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Annual Total | Percent of Total |
    | Salaries and Benefits | $ 821,215 | $ 812,457 | $ 796,650 | $ 882,655 |
    | Facility Rental | 125,730 | 189,425 | 124,630 | 216,356 |
    | Materials and Equipment | 325,680 | 368,942 | 339,874 | 315,500 |
    | Contract Services | 465,278 | 378,210 | 529,743 | 442,105 |
    | Administrative Costs | 286,550 | 301,226 | 297,412 | 325,687 |
    | Totals by Quarter |

    | Expenses 5-Year Forecast |
    | Forecasted Increase | 3.5% |
    | Year | 2024 | 2025 | 2026 | 2027 | 2028 |
    | Projected Expenses |

    ## Enrollment

    | | |
    | — | — |
    | Recreation Department |
    | Workshop Annual Enrollment Analysis |

    | Enrolled Residents | 2,265 |
    | Submitted Payment | 1,895 |
    | Attended | 1,698 |

    ## County Partnership

    | | | |
    | — | — | — |
    | Recreation Department |
    | City/County Partnership Analysis |
    | County | State | Number of<br>Partnered Cities |
    | Bergen | New Jersey | 12 |
    | Camden | New Jersey | 5 |
    | Mercer | New Jersey | 8 |
    | Passaic | New Jersey | 15 |
    | Somerset | New Jersey | 10 |
    | Union | New Jersey | 20 |

    **## Excel_3G_Expenses_Instructions.docx**

    Grader – Instructions Excel 2022 Project

    ## **Excel_3G_Expenses**

    ### **Project Description:**

    In the following project, you will edit a worksheet that will be used to summarize the operations costs for the Public Works Department.

    ### **Steps to Perform:**

    | | | |
    | — | — | — |
    | **Step** | **Instructions** | **Points Possible** |
    | 1 | Open the Excel workbook <br>_Student_Excel_3G_Expenses.xlsx_ downloaded with this project. | 0 |
    | 2 | In the Expenses worksheet, calculate row totals for each Expense item in the range F5:F9. Calculate column totals for each quarter and for the Annual Total in the range B10:F10. Be sure that F6:F9 are formatted with Comma Style and zero decimal places. | 5 |
    | 3 | In cell G5, construct a formula to calculate the Percent of Total by dividing the Annual Total for Salaries and Benefits by the Annual Total for all quarters. Use absolute cell references as necessary, format the result in Percent Style, and then Center. Fill the formula down through cell G9. | 9 |
    | 4 | Use a 3-D Pie chart to chart the Annual Total for each item. Move the chart to a new sheet and then name the sheet <br>**Annual Expenses Chart** | 7 |
    | 5 | As the text for the Chart Title element, type<br>**Summary of Annual Expenses** and then change the Font Size to 28. | 4 |
    | 6 | Remove the Legend from the chart and then add Data Labels formatted so that only the Category Name and Percentage display positioned in the Center. Format the data labels by applying a Font style of Bold and Italic and a Font Size of 12. Change the Font Color—in the first column, click the first color. | 9 |
    | 7 | Format the Data Series using a 3-D Format effect. Change the Top bevel and Bottom bevel–under Bevel, in the first row, apply the first bevel effect. Set the Top and Bottom bevel Width and Height to <br>**100 pt** | 2 |
    | 8 | Display the Series Options, and then set the Angle of first slice to <br>**125** so that the Salaries and Benefits slice is in the front of the pie. Select the Salaries and Benefits slice, and then explode the slice <br>**10%**. | 4 |
    | 9 | Format the Chart Area by applying a Gradient fill using the Preset gradients—in the second column, apply the first gradient. Format the Border of the Chart Area by adding a Solid line border—in the last column, apply the first color. Change the Width to <br>**3 pt** | 6 |
    | 10 | Display the Page Setup dialog box, and then for this chart sheet, insert a custom footer in the left section with the file name. | 4 |
    | 11 | Display the Expenses worksheet, and then by using the Quarter names and the Totals by Quarter, insert a Line with Markers chart in the worksheet. Do <br>_not_ include the Annual Total. Move the chart so that its upper left corner is positioned slightly inside the upper left corner of cell A12. Change the Width of the chart to <br>**7.5** and then as the Chart Title, type <br>**Recreation Department Expense Summary** | 8 |
    | 12 | Format the Bounds of the Vertical (Value) Axis so that the Minimum is <br>**2000000** Apply Bold to the values on the Vertical (Value) Axis and to the labels on the Horizontal (Category) Axis. | 10 |
    | 13 | Display the Format Chart Area pane. Click Fill & Line, and then expand the Border section. Select the Solid line option, display the Color gallery, and then in the last column, click the first color. Change the Width to <br>**2 pt** and then Close the Format Chart Area pane. Click cell A1 to deselect the chart, and then Save your workbook. | 1 |
    | 14 | Copy the Annual Total in cell F10 and then use Paste Special to paste Values & Number Formatting in cell B35. In cell C35, construct a formula to calculate the Projected Expenses after the forecasted increase of 3.5% in cell B31 is applied. Fill the formula through cell F35, and then use Format Painter to copy the formatting from cell B35 to the range C35:F35. | 10 |
    | 15 | In the Page Setup dialog box, center this worksheet Horizontally, and insert a Custom Footer in the left section with the file name. Save your workbook. | 6 |
    | 16 | Display the Enrollment worksheet. Insert a Funnel chart that shows resident workshop participation for the year using the range A4:B6. Change the Height of the chart to <br>**2.5** and the Width to<br>**3.5** and then drag the chart so that the upper left corner aligns with the upper left corner of A9. Change the chart title to <br>**Enrollment Analysis** and then click cell A1. Center the worksheet Horizontally and insert a Custom Footer in the left section with the file name. | 6 |
    | 17 | Display the County Partnership worksheet. The City of Springbury is partnering with the County to offer workshops to residents. The Recreation Department staff will visit several cities with similar partnership agreements. Using the range A3:C9, insert a Filled Map chart. Change the chart title to <br>**Partnership Analysis** and then drag the chart so that the upper left corner aligns with the upper left corner of A11. Change the chart Width to <br>**4.5** and then click cell A1. | 3 |
    | 18 | Center this worksheet Horizontally and insert a Custom Footer in the left section with the file name. Display the workbook Properties. As the Tags, type <br>**recreation** and as the Subject, type your course name and section number. Be sure your name displays as the Author. | 6 |
    | 19 | Save and close the file, and then submit for grading. | 0 |

    | | |
    | — | — |
    | **Total Points** | **100** |

    Created On: 08/04/2022 1 GO22_XL_CH03_GRADER_3G_HW – Expenses 1.0

    **3G_Expenses_final_result.JPG**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/3g-expenses-final-result-jpg-10405509)

    – 1
    – 2
    – 3