Premium Writing

Source Required for last question Chapters 4, 13 from:
Business Leadership, 2e, Joan Gallos (Editor), ISBN: 9780787988197.
Reflection #2
What makes organizations so complex?
What are frames and the process of re-framing? How is this relevant to leadership?
How do leaders acquire their personal frame preferences? How have you acquired yours?
Give a concrete example (personal if possible) that shows the importance of re-framing to good leadership.
A provocative discussion-generating question related to the readings?

In this project, you will correct function mistakes and other formula errors in a workbook designed for planning a large party or event. Be sure to save your work often!
Skills needed to complete this project:
Checking Formulas for Errors (Skill 3.18)
Finding Errors Using Trace Precedents and Trace Dependents (Skill 3.19)
Displaying and Printing Formulas (Skill 3.20)
Creating Formulas Using Counting Functions (Skill 3.6)
Finding Minimum and Maximum Values (Skill 3.4)
Formatting Text Using Functions (Skill 3.7)
Using CONCAT to Combine Text (Skill 3.8)
Finding Data Using the VLOOKUP Function (Skill 3.17)
Using the Function Arguments Dialog to Enter Functions (Skill 3.1)
Using Formula AutoComplete to Enter Functions (Skill 3.2)
Calculating Averages (Skill 3.3)
Naming Ranges of Cells (Skill 3.11)
Working with Named Ranges (Skill 3.12)
Updating Named Ranges with the Name Manager (Skill 3.13)
Editing and Deleting Names with the Name Manager (Skill 3.14)
Using Date and Time Functions (Skill 3.5)
Using the Logical Function IF (Skill 3.15)
Creating Formulas Referencing Data from Other Worksheets (Skill 3.10)
Calculating Loan Payments Using the PMT Function (Skill 3.16)
Open the start file EX2019-FixIt-3-6. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.
If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the workbook so you can modify the workbook.
On the GuestList sheet, check all the formulas. Cells to check are filled with the light purple color. Most of them need to be corrected. Use error checking as needed and/or display the formulas on-screen for easy viewing.
In the Name Tag column, modify the formula to display the guest name in this format: BILL SMITH Hint: There are multiple errors in this formula. Fix the formula in cell D10 and then copy it to the other cells in the column.
Correct the function used in cell A3 to calculate the sum of the values in the NumAttending column.
Correct the function used in cell A4 to count the number of values in the Street column.
Correct the function used in cell A5 to count the number of blank cells in the NumAttending column.
Correct the function used in cell A6 to display the largest value in the NumAttending column.
Correct the function used in cell A7 to display the average value in the NumAttending column.
On the Shopping List sheet, check all the formulas. Cells to check are filled with the light purple color. Most of them need to be corrected. Many of the problems on this worksheet can be solved by creating named ranges or using a name that already exists.
The formula in cell B2 uses the wrong function.
The formulas in cells A9:A23 reference a named range that doesnt exist. There is more than one correct way to fix this problem using the cell range A5:H18 on the Places to Shop worksheet. You can create the named range referenced in the formulas, or you can change the function arguments to reference the cell range instead.
The formula in cell H9 results in the correct value. However, the workbook author copied this formula to the remaining cells in the column and those values are definitely not correct! Fix the formula in cell H9 and copy it to cells H10:H23. Hint: Notice that cell H8 is named Tax.
If youve fixed the formulas in cells H9:H23 correctly, the formulas in cells I9:I23 and G5 should calculate properly now. However, the formulas in cells G2:G4 still have errors that need to be fixed. Hint: Use error checking as needed and/or display the formulas on-screen for easy viewing.
Correct the function used in cell G2 to average value of the Cost column.
Correct the function used in cell G3 to display the largest value in the Cost column.
Correct the function used in cell G4 to display the smallest value in the Cost column.
On the Summary sheet, you will be entering all the formulas. Cells to complete are filled with the light purple color. Hint: Use error checking as needed and/or display the formulas on-screen for easy viewing.
Cell B2 should use a function that will update the date to the current date every time the workbook is opened.
Cell B4 references a named range that doesnt exist. It should reference cell A4 on the Guest List sheet. You can create the named range or edit the formula to reference the cell instead.
Cell B5 references a named range that doesnt exist. It should reference cell A3 on the Guest List sheet. You can create the named range or edit the formula to reference the cell instead.
Cell B8 is missing the formula to calculate whether or not the total Cost with tax on the Shopping List sheet + the total Cost for purchasing and mailing invitations on the Guest List sheet is greater than the available cash. The cell should display yes or no.
Add a formula to cell B9 to calculate the amount to borrow (total Cost with tax on the Shopping List sheet + the total Cost for purchasing and mailing invitations on the Guest List sheet the cash available) if the value in cell B8 is yes. If the value in cell B8 is not yes, the cell should display 0.
Add a formula to cell B12 to calculate the monthly loan payment based on the information in cells B9:B11. Use a negative number for the Pv argument.
Save and close the workbook.
Upload and save your project file.
Submit project for grading.

The primary means of advertising a film is by creating a movie trailer. The movie trailer is a short look at various scenes of a film with other enticing features such as editing, voice-overs, text, and name-dropping.
Complete the following for this assignment:
Review a movie trailer of your choosing, and discuss how the production company sells the film.
Highlight how psychological principles are used to entice the audience.
Discuss at least 3 of the following concepts in your paper:
Color
Gender
Class
Action
Star power or name-dropping
Titles and text
Discuss how any editing techniques that are used such as quick cuts, jump cuts, and music add to the psychological strategies of selling the film.
In the process of analyzing the movie trailer, identify who the target audience is, and discuss how psychological tactics are linked with the target audience.
Use at least 3 outside resources to support your discussion in addition to citing the movie trailer.

select a country about which to write an essay regarding a current human rights issue in the country. The question will revolve around the multi-spatial nature of human rights and advocacy in/directed toward that country. Outside reading academic, policy-related, and advocacy material will be necessary.
Human rights violations stem from structural issues, which are multi-spatial in their nature. After offering a brief descriptive account of the nature of the violations you have chosen to examine, identify the primary structural factors that contribute to the sustenance of those violations, including economic, political, cultural, and social. Discuss how these factors are linked between international, regional, national, and local realms. Select at least one organisation or advocacy campaign that has worked to rectify or address these violations and analyse the NGO/advocacy response: Has it been effective? Has it operated on multispatial levels? Has the advocacy emerged from within the country or from external bases? What lessons might you draw from your analysis?

Advising you to choose a specific sub topic (labour rights, childrens rights, migrants rights etc.) within the country.

Order maintenance policing is considered one of the key drivers of racialized mass incarceration. What is order maintenance policing, why did it arise in US cities when it did, and what has been its impact on policing and incarceration in US cities? What are the historical precedents for order maintenance policing? How has order maintenance policing exacerbated long-standing tensions between police and communities of color?

The Fourth Amendment sets limitations to stop and frisk and arrests. It also affords individuals to be protected against unreasonable searches and seizures.
This discussion asks you to examine probable cause and illegal searches and seizures.
Please thoroughly discuss each of the following:
A police officer must have probable cause to arrest an individual. What is probable cause? How much probable cause is needed to secure an arrest or search warrant?
What is the exclusionary rule? Discuss the exceptions to the exclusionary rule.
Discuss the difference in a stop and frisk and an arrest. What are the requirements for an officer to conduct a stop and frisk?

http://link.galegroup.com.libraryresources.columbiasouthern.edu/apps/doc/A14584556/AONE?u=oran95108&sid=AONE&xid=cdac492b>

After reading the article, write a review of the articles main ideas, and share marketing strategies from the article that you might utilize to tap into the spectator and participant market in an effort to increase your own marketing techniques and profit margin.
Also, include the items below in your review.
Explain an instance where consumers may be both participants and spectators.
Explain consumer needs that impact the marketing process.

Do you dream? Do you remember your dreams? Do you have special abilities in your dreams

Jacob is a licensed addiction professional and a Caucasian homosexual male. He has strong ties to his Jewish heritage. He is self-aware and does not feel that he holds any personal biases that would keep him from being effective in therapy with his new client, Gabriella.
Watch Gabriellas Case Study
Using the above case scenario, answer the following questions:
What ethical dilemmas are presented in the case scenario?
Describe the cultural, gender, and spiritual considerations in the case scenario.
Although Jacob feels that he holds no personal biases, should he reflect on his own biases and values before beginning treatment with Gabriella? If so, discuss one way that he could carry out this reflection.

The personal application assignment is based on Kolbs model
(1971) of experiential learning. The use of this model can help solve the
problem of performance assessment. The model argues that learning occurs
through a process which might begin with a concrete experience, which leads to
reflective observation about the experience. Abstract conceptualization follows
in which models, paradigms, strategies, and metaphors are applied to the results
of the experience. Active experimentation concludes the cycle as the concepts
are then put into practice, thus generating new concrete experience.
Choosing a good topic is essential. Select an experience
that relates to the assigned course topics. It should be an experience that you
would like to understand better, (e.g. there was something about it that you do
not totally understand, that intrigues you, that made you realize that you
lacked certain managerial skills, or that was problematical or significant for
you.) The topic must be meaty enough to take it through the entire learning
cycle. I recommend identifying your plot and then outlining the paper across
all four elements to see if this topic will work. The incident does not have to
be work related; an incident in any setting (sport teams, school, family, club,
church, etc.) that relates to the course topics is acceptable.