This assignment has two goals: 1) have students, via research, increase their understanding of impacts of information
technology on current world issues, and 2) learn to correctly use the tools and techniques within Word to format a research
paper, including use of available References and citation tools. These skills will be valuable throughout a student’s
academic career.
The paper will require a title page, NO abstract, three to five full pages of content with incorporation of a minimum of 3
external resources from credible sources and a Works Cited/References page. Wikipedia and similar general information
sites, blogs or discussion groups are not considered creditable sources for a research project. No more than 10% of the
paper may be in the form of a direct citation from an external source. Choose your topic from the list of topics that follow
these organization steps.
Paper organization
Open Word and save a blank document with the following name:
“Student’s LastNameFirstInitial Research Paper”
The paper should be organized in the following way:
1. Title page:
a. Center in the middle of the page (horizontally and vertically) the title (subject) of the paper and below that
your name
2. Body of the paper:
a. Use 12-point Arial font
b. Set the margins at 1”
c. Entire paper should be double-spaced
d. Length – 3-5 full pages, not counting the title page or the References page.
e. Include a minimum of 3 APA-formatted citations and related References page. Every reference must be cited
at least once, and every citation have an entry in the References list. If you are not familiar with APA format,
it is recommended that you use the References feature in Word for your citations and Reference List or refer
to the “Citing and Writing” option under the Resources/Library/Get Help area in the LEO classroom. It is
important to review the final format for APA-style correctness even if generated by Word.
f. Include at least two (2) informational footnotes. Footnotes are not used to list a reference! Footnotes contain
information about the topic to which the footnote has been attached.
g. Place the references on a separate page following the body of the paper. Note: Use a hard return (CTRL
Enter) after the end of your paper body and the start of the References page.
3. Organization of the content of the paper:
Include the following sections in the paper (include, in bold, the headings identified here):
a. Introduction – Identify the issue or idea. Explain why the topic was selected and what you are trying to
achieve (what is your end goal). The introduction should not be more than half a page; details will be
discussed in the follow-on areas.
b. Areas of interest, activity or issue – Define the issue or idea in greater detail. Define the specific problem
or problems or new idea. Identify other underlining or related issues as well as dependencies. Explain what
impacts will result if not addressed.
c. Research Findings – Summarize your research findings and what they contribute to the study of the issue
or idea. You must identify (cite) the sources of the research or class material related to your topic that you
include in the findings.
d. Proposed solution(s), idea(s), courses of action(s). List solutions, ideas or courses of action with an
analysis of its effectiveness (how will your suggestions affect or change the current situation). If more than
one idea is suggested, provide an analysis that covers all proposed suggestions.
e. Conclusion – Summarize the conclusions of your paper.
A list of topics from which students can choose is provided here:
Topics for Research Paper
The focus of the paper should be on one of the following:
1. How has information technology led to the struggle between online and brick-and-mortar stores? What do the
next 5-10 years look like?
2. How has information technology opened up the potential for 5G networks? Are there any downsides to
the implementation of this technology?
3. How has information technology impacted the use of robots in your local stores?
4. How has information technology supported the development of monopolies – Amazon, Microsoft, telecom
companies? Will these monopolies survive?
5. How has information technology supported the development of facial recognition software and the current issues
related to its use?
6. How has information technology led to the use of biometrics and the potential for rise of an International “Big
Brother”?
7. How has information technology led to the development of the Internet of Things and the concern about the
impact of privacy laws (or lack thereof) on the IOT?
8. How has information technology supported the development of Facebook and other social media sites? Should
social media sites be regulated?
9. Who/what is Huawei and what are the issues the U.S. and other countries are having with Huawei?
10. How has information technology changed the political process within the past 5 years?
Writing Quality for the Research Paper
• All Grammar, Verb Tenses, Pronouns, Spelling, Punctuation, and Writing Competency should be without error.
• Be particularly careful about mis-matching a noun and pronoun. For example, if you say “A person does this…” then do
not use “their” or “they” when referring to that person. “Person” is singular; “their” or “they” is plural.
• Remember: there is not their, your is not you’re, its is not it’s, too is not to or two, site is not cite, and who should be
used after an individual, not that. For example, “the person WHO made the speech” not “the person THAT made the
speech.”
• in the previous sentence. It is more business-like to say “In a professional paper one should not use contractions,”
rather than saying, “In a professional paper you don’t use contractions.”
• In a professional paper one does not use contractions (doesn’t, don’t, etc.) and one
does not use the personal I, you or your. Use the impersonal as in the previous
sentence. It is more business-like to say “In a professional paper one should not use
contractions,” rather than saying, “In a professional paper you don’t use contractions.”
• Remember: spell-check, then proofread. Better yet, have a friend or colleague read it before submitting it. Read it out
loud to yourself. Read it as if you are submitting it to your boss.
Grading Criteria
Paper Mechanics
Format- title pg,
font, margins, paper
length
0.5 Title page included: Arial 12-point font used; margins set at 1″;
body of the paper is 3-5 pages, double spaced. The title page
and References page are not counted as part of the 3-5 pages of
text.
APA work –
citations and
references
0.5 A minimum of 3 correctly formatted citations matched to
references; both citations and references in APA format.
Footnotes 0.5 A minimum of 2 footnotes that contain additional information
but are NOT references.
Mechanicsgrammar, spelling,
etc.
1.5 Grammar, spellings, and punctuation correct throughout the
paper.
Content
Introduction 2 This is a summary of the topic. Simply identify the issue
without going into great detail, explain why was the topic
selected and what the you are trying to achieve (what is your
end goal). The introduction should not be more than half a
page; details will be discussed in the follow-on areas.
Issue 2.0 Define the issue or idea. Define the specific problem or
problems or new idea. Identify other underlying or related
issues as well as dependencies. Explain what impacts will
result if not addressed.
Findings 2.0 Identify research or class material related to your topic.
Summarize your findings and what they contribute to the
study of the issue or idea. Sources must be identified in
citations and the related References list.
Solutions/actions 3.0 List solution, idea or courses of action with an analysis of its
effectiveness (how will your suggestions affect or change the
current situation). If more than one idea is suggested,
provide an analysis that covers all proposed suggestions.
Conclusion 2 Summarize the conclusions of your paper. In a paragraph
briefly identify the issue, the findings, your proposed
solution/actions. However, do not simply repeat the words in
the previous sections.
You can find instructions on how to use the References tool in Word on a PC or on a Mac in a file included in the
Assignment link.

#1. Think about the concept, What Makes a Strategy a Winner. What about this concept makes sense to you and what do you question? Consider a challenging strategic management situation in your workplace. Drawing on this concept, what new understanding do you have of this situation?
#2. Think about the concept, S.M.A.R.T. What about this concept makes sense to you and what do you question? Consider a challenging strategic management situation in your workplace. Drawing on this concept, what new understanding do you have of this situation?
#3. Think about the concept, Balanced Scorecard. What about this concept makes sense to you and what do you question? Consider a challenging strategic management situation in your workplace. Drawing on this concept, what new understanding do you have of this situation?
Required text:
Thompson, Arthur A.; Peteraf, Margaret A.; Gamble John E. & Strickland III, A.J. (2016). Crafting and Executing Strategy: The Quest for Competitive Advantage (20th ed.). New York: McGraw-Hill.
Available at: https://ufile.io/mlgv5uz9

The subject of this five to seven (5-7) page written assignment, which will determine ten percent (10%) of your cumulative grade, will evolve from a visit to the University of Miami’s Lowe Art Museum. Choose one piece of art in the Permanent Collection produced during the Gothic, Renaissance, or Mannerist period and compare/contrast its stylistic elements to works we have discussed in class. The visual analysis should be treated as any composition, so that it includes an introduction, body, and conclusion. Further, more explicit, instructions will be made available on Blackboard.

Shelly Cashman Excel 2019 | Module 1: SAM Project 1a

New Era Medical
Complete a Budget Summary Worksheet

 

      GETTING STARTED

• Open the file SC_EX19_1a_FirstLastNamexlsx, available for download from the SAM website.
• Save the file as SC_EX19_1a_FirstLastNamexlsx by changing the “1” to a “2”.
  • If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
• With the file SC_EX19_1a_FirstLastNamexlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet.
  • If cell B6 does not display your name, delete the file and download a new copy from the SAM website.
• PROJECT STEPS

1. Josh Bartel is the senior director of the Pennsylvania field office for New Era Medical, a global company that manufactures medical equipment. He has created a worksheet summarizing the revenue and expenses for the first three quarters of the year. He asks for your help in determining what the Pennsylvania office needs to do to meet its targeted profit goals in the fourth quarter.
   Go to the Budget Summary Cut the worksheet title from cell I1 and paste it in cell A1 to display the title in its expected location.
2. In cell E2, add the text Number of so that the complete text appears as “Number of salespeople:” and more clearly identifies the value in cell G2.
3. Enter Quarter 2 in cell C4 and Quarter 3 in cell D4.
4. In cell G5, enter a formula without a function that subtracts the target revenue (cell F5) from the year to date revenue (cell E5) to determine how much revenue the field office needs to earn in Quarter 4 to reach its target for the year.
5. Josh wants to calculate the gross margin for Quarters 1–3 and the year to date. Provide this information as follows:
   1. In cell B7, enter a formula without a function that divides the gross profit for Quarter 1 (cell B6) by the revenue in Quarter 1 (cell B5).
   2. Fill the range C7:E7 with the formula in cell B7 to find the gross margin for Quarters 2 and 3 and for the year to date.
6. Josh needs to sum the sales for each Pennsylvania region for the year to date. Provide this information as follows:
   1. In cell E10, enter a formula that uses the SUM function to total the regional sales data for the Northeast region (the range B10:D10) to calculate the year-to-date sales.
   2. Use the Fill Handle to fill the range E11:E13 with the formula in cell E10 to find the year-to-date sales for the other three regions.
7. In cell F10, enter the value 925000 to provide the targeted annual sales amount for the Northeast region.
8. Josh wants to determine how much revenue each region needs to generate in Quarter 4 to reach its target for the year. Enter this information as follows:
   1. In cell G10, enter a formula without a function that subtracts the target sales for the Northeast region (cell F10) from its year to date regional sales (cell E10) to find the amount of sales the Northeast region needs to generate to meet its target.
   2. Copy the formula in cell G10, and then paste it in the range G11:G14, pasting the formulas only, to find the variances for the other regions and for the total.
9. Josh is interested in how much revenue each of the 12 salespeople generates on average in each quarter and for the year to date. Find this information as follows:
   1. Edit cell B15 to include a formula without a function that divides the total regional sales in Quarter 1 (cell B14) by the number of salespeople (cell G2). Don’t change the reference to cell G2 that is already there.
   2. Fill the range C15:E15 with the formula in cell B15 to determine the average revenue per salesperson in Quarters 2 and 3 and for the year to date.
10. Josh also needs to calculate the operating margin, which is the ratio of operating profit or loss to revenue and indicates how much the office makes after paying for expenses. Calculate the operating margin as follows:
    1. In cell B20, enter a formula without a function that divides the operating profit or loss in Quarter 1 (cell B19) by the revenue from Quarter 1 (cell B5).
    2. Use the Fill Handle to fill the range C20:E20 with the formula in cell B20 to find the operating margin for Quarters 2 and 3 and for the year to date.
11. Josh wants to include a visualization of the total year to date sales separated by region. Insert a chart to provide this visualization as follows:
    13. Create a 2-D Pie Chart based on the nonadjacent ranges A9:A13 and E9:E13.
    14. Enter Total Year to Date Sales by Region as the chart title.
    15. Resize and reposition the chart so its upper-left corner is in cell I4 and its bottom-right corner is in cell L18.
    16. Apply Style 3 to the chart.
12. Hide the gridlines for the Budget Summary worksheet to make it easier to read.

Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project.
 
 
Final Figure 1: Budget Summary Worksheet