To prepare for this assignment, review Figures 3.1, 3.2, 3.3, 3.5, and 3.6 from your textbook. Select a Saudi Arabian company, identify the industry in which it competes, and identify its three main competitors. Complete an Industry Analysis by answering the following questions.

1. Analyze      and predict industry profitability:
   1. Apply       a detailed Porter’s Five Forces framework with a graphic representation       (Figure 3.3) and written explanation for your selected company in       relation to the Five Forces.
   2. Given       the Five Forces analysis outcomes, predict the level of industry       profitability expressed as high, intermediate, or low.
2. Implications      for strategy:
   1. What       strategies can the rival companies adopt to reduce competitive pressure       and improve industry profitability?
   2. Which       strategies do you recommend for your company to improve its       competitiveness, position, and earnings?
3. Identifying      Key Success Factors (KSFs)—What are the KSFs of your company?
   1. See       Figure 3.6. Who are the customers and what do they want?
   2. See       Figure 3.6. How does the company survive competition?
   3. Has       your company’s KSFs changed over time?

Your well-written paper should meet the following requirements:

• Be  7 pages in length, which does not include      the required title and reference pages..
• APA      style guidelines.
• Support      your submission with course material concepts, principles, and theories from      the textbook and at least two scholarly, peer-reviewed journal      articles unless the assignment calls for more.
• Turnitin      Originality Check.

  

Exp19_Access_Ch02_Capstone – International Foodies 1.0

Project Description:

International Foodies is an importer of exotic foods from all over the world. You landed a summer internship with the company and discovered that their product lists and the suppliers they buy from are stored in Excel workbooks. You offer to help by using your newly gained knowledge of Access to create a relational database for them. You will begin by importing the workbooks from Excel into a new Access database. Your manager mentions that she would also like a table that specifies food categories so that you can relate the products you sell to specific categories in the database. You will create a table from scratch to track categories, create relationships between the tables, and create some baseline queries.

Steps to Perform:

   

Step

Instructions

Points    Possible

 

1

Start   Access. Open the downloaded Access file named Exp19_Access_Ch2_Cap_Foodies. Grader has automatically added your   last name to the beginning of the filename. Save the file to the location   where you are storing your files.

0

 

2

You will examine the data in the   downloaded Excel worksheets to determine which fields will become the primary   keys in each table and which fields will become the foreign keys so that you   can join them in the database.
 

  Open the Suppliers.xlsx Excel   workbook, examine the data, and close the workbook. Open the Products.xlsx Excel workbook, examine   the data, and close the workbook.
 

  You will import two Excel workbooks that contain supplier and product   information into the database.
 

  Click the External Data tab, click   New Data Source, point to From File in the Import & Link   group, and then select Excel.   Navigate to and select the Suppliers.xlsx   workbook to be imported as a new table in the current database. Select First Row Contains Column Headings.   Set the SupplierID field Indexed option to Yes (No Duplicates). Select SupplierID   as the primary key when prompted and accept the table name Suppliers. Do not save the import   steps.

10

 

3

Import   the Products.xlsx workbook, set the   ProductID Indexed option to Yes (No   Duplicates), and select ProductID   as the primary key. Accept the table name Products.

10

 

4

Change the Field Size of the   QuantityPerUnit field to 25   in Design view of the Products table. Set the Field Size of ProductID and   CategoryID to Long Integer. Save   the changes and open the table in Datasheet view. Open the Suppliers table in   Datasheet view to examine the data. Close the tables.

4

 

5

You   will create a new table that will enable International Foodies to associate   each product with a food category in the database.
 

  Create a new table in Design view. Add the following fields in Design view   and set the properties as specified:
 

  Add the primary key field as CategoryID   with the Number Data Type and Number assigned to a new category.   (type the period) as the Description. Set the Caption property to Category ID.
 

  Save the table as Categories.

 

6

 

6

   Add CategoryName with the Short Text Data Type and Name of food   category.   (type the period) as the Description. Change the field size to 15. Set the Caption property to Category Name and the Required property to Yes.

6

 

7

Add   CategoryDescription with the Long Text Data Type. Set the Caption property to Category Description. Switch to Datasheet view and save the   table when prompted. You will enter Category data into the table in the next step.

4

 

8

   You will add 8 records to the Categories table so that you have some sample   data to test in the database.
 

  Add the following records to the Categories table:

Category ID Category Name   Category Description 

1 BEVERAGES  SOFT DRINKS, COFFEES, TEAS 

2 CONDIMENTS  SAUCES, RELISHES, SEASONINGS

3 CONFECTIONS  DESSERTS, CANDIES, SWEET BREADS

4 DAIRY PRODUCTS  CHEESES

5 GRAINS/CEREALS  BREADS,   PASTA, CEREAL

6  MEAT/POULTRY  PREPARED   MEATS

7 PRODUCE  DRIED FRUIT, BEAN CURD

8 SEAFOOD  SEAWEED AND FISH

  Close the table.

 

6

 

9

You   will create the relationships between the tables using the Relationships   window.
 

  Add all three tables to the Relationships window. Identify the primary key   fields in the Categories table and the Suppliers table and join them with   their foreign key counterparts in the related Products table. Select the Enforce Referential Integrity and Cascade Update Related Fields check boxes.   Save and close the Relationships window.

12

 

10

You will use the Simple Query Wizard to   create a query of all products that you import in the seafood category.
 

  Add the ProductName, SupplierID, and CategoryID fields from Products (in that order). Save the query   as Seafood Products.

10

 

11

Add   a criterion in Design view, to include only products with 8 as the CategoryID.

2

 

12

Sort the query results in ascending   order by ProductName. Run, save, and close the query.

2

 

13

You   want to create a query that displays actual category names rather than the   CategoryIDs. You are interested to know which meat and poultry products are   imported. You will copy the Seafood Products query and modify it to delete a   field, then add an additional table and field.
 

  Copy the Seafood Products query   and paste it using Seafood Or Meat/Poultry   as the query name.

2

 

14

Open the Seafood Or Meat/Poultry query in Design view and delete the CategoryID column.

2

 

15

Add   the Categories table to the top   pane of the query design window. Add the CategoryName   field to the last column of the design grid and set the criterion as “Seafood” Or “Meat/Poultry”.   Run, save, and close the query.

4

 

16

You will create a query that identifies   suppliers and their associated products. Because there is a relationship   between the two tables, you can now pull data from each of them together as   usable information.
 

  Create a query in Design view that includes the Suppliers and Products   tables. The query should list the company name, contact name, phone (in that   order), then the product name and the product cost (in that order).

6

 

17

Sort   the query by company name in ascending order, then by product cost in   descending order. Run, close, and save the query as Company by Product List.

4

 

18

You determine that the data in the   Company by Product List query could be summarized with a Total row. You will   group the records by company name, and then count the number of products you   buy from each of them.
 

  Copy the Company by Product List query   and paste it using Summary of Company by   Product   as the query name.

2

 

19

Open   the Summary of Company by Product   query in Design view and delete the ContactName, Phone, and ProductCost columns.

3

 

20

Click Totals in the Show/Hide group on the Query Tools Design tab.   Click in the Total row of the   ProductName field, click the arrow,   and then select Count. The records   will be grouped by the company’s name and the products for each   company will be summarized.

3

 

21

Modify   the field name of the ProductName column as Product Count:   ProductName to make the field name more   identifiable. Click Run in the   Results group (20 records display in the Datasheet). The results display the   product count for each company that supplies your organization. Save and   close the query.

2

 

22

Close all database objects. Close the   database and then exit Access. Submit the database as directed.

0

  

Total   Points

100

Week 4: Experiences and Challenges

Answer at least two questions:

• Now that you have come to the final week of the module, and if you had to write you paper all over, what would you change? Would you change your focus or thesis? If so, why?
• From your experience so far in the Criminal Justice Capstone class, are there other areas of your studies that would work well within your existing topic?
• Comment on the challenge(s) you had writing this research paper. How was your experience in this class?

Respond to at least two of your peers’ posts.

Please share your comments and respond to other students in the class.  Your posts should be thoughtful and contain constructive criticism and support. This is a chance to share your experiences over the past years as you pursued your BA degree.  What were some of the challenges you faced?  How did you maintain your focus? 

Be careful with your spelling and grammar but enjoy these last chats as a part of your overall University experience. The week closes on Sunday at 11:59 PM and you will no longer have access to the discussion.

The initial post must be a minimum of 250 words and remember, quality counts.  When responding to another post, please ensure your comments are substantive in nature and offer useful feedback and support.  Each response post must be a minimum of 50 words.

Please click on the above title, “Week 4 CJ Chat: Experiences and Challenges” to enter and post to the “Week 4 CJ Chat: Experiences and Challenges” forum.

https://www.youtube.com/watch?v=lAjsnVh3erg&t=1s

 The Final DAP Summary is an in-depth, comprehensive essay summary that covers:

• ALL the content from your Dietary Analysis Project reports
• Your textbook course content
• Information you obtained over the semester from analyzing your food intake and exercise habits

Essay process:

1. Review the core competencies skills this essay assesses 
2. Review detailed directions and rubric
3. Write a  750- 1200 word essay in a (.docx) document ahead of time, using correct grammar and spelling. 

Core Intellectual Competency

This essay is a comprehensive evaluation showing you mastered the course learning objectives and possess the core intellectual competency (listed below) as it relates to your nutrition. Specific references to your individual report values must be addressed. The essay assesses:

• Critical Thinking Skills – to include creative thinking, innovation, inquiry, and analysis, evaluation and synthesis of information 
• Communication Skills – to include effective development, interpretation and expression of ideas through written, oral and visual communication 
• Empirical and Quantitative Skills – to include the manipulation and analysis of numerical data or observable facts resulting in informed conclusions 
• Social Responsibility – to include inter cultural competence, knowledge of civic responsibility, and the ability to engage effectively in regional, national, and global communities.

Answer the questions below as well as include all the elements  of the Core Competency Skills. 

1. What specific modifications or changes could you make to improve your current eating habits, exercise habits, and current lifestyle choices?
2. How does your nutrition & fitness plan impact your personal, economic health as well impact your social/society responsibility as a whole?
3. Please be specific about what foods, nutrients and changes in behaviors you will do, making sure to address all the nutrients that were out of the recommendations.

*Make sure you use all components from your DAP project reports in your project summary. This is detailed analysis and not just a generalized assessment. See grading rubric for how points will be awarded. 

I have attached the DAP Report use that report to do this essay as well as look up through the rubric.

 

Introduction

Creating a culture of workplace safety and legal compliance is a very real task for the human resource professional. Each type of work setting has some overarching safety standards. Compliance with the Occupational Safety and Health Administration (OSHA) is part of everyday record keeping and expenses within a business.

You will have the opportunity to learn more about OSHA and how its work impacts modern organizations. By creating a memorandum for your leadership team, you will get practical experience communicating the legal issues, expenses, and benefits of compliance with OSHA regulations.

Scenario

Your organization is reviewing their OSHA practices and expenses to determine if they are currently effective or if they need to be revisited. Your executive memorandum will serve as background information for the ongoing discussions between organizational leadership and the human resource department.

Your Challenge

You are a human resources specialist with experience in establishing OSHA protocols and the related costs. You will write the memo of explanation to the organizational leadership team so that they can have an informed discussion about practices in your organization.

Instructions

1. Write a 2–3-page executive memorandum to organizational leadership regarding the Occupational Safety and Health Administration (OSHA) and its effectiveness in the workplace. Include the following:
   • Describe the mission and function of OSHA.
     • What is OSHA intended to do? Is it working?
   • List some of the compliance objectives, or the overarching safety standards.
   • Analyze the impact of OSHA in modern organizations.
     • What does the HRM professional need to know about OSHA?
   • Analyze the cost of regulations and enforcement versus the benefit in reduced worker injury. Is the cost of regulations and enforcement worth the results?
   • Develop health- and safety-related best practices for human resources and organizational leadership.
     • Are there different perspectives toward interpretation, monitoring, and compliance with OSHA, and do the differing perspectives enhance or hinder workplace safety?
   • Evaluate the ways in which a company can mitigate risk.
2. Your executive memorandum is to be written coherently to support a central idea with correct grammar, usage, and mechanics as expected of a business professional.
3. Support your assignment with citations from relevant readings, and use real-world organization examples to demonstrate the importance of the concepts and analysis you have provided.

Submission Requirements

The deliverable for this assignment applies professional skills in Human Resources Management (HRM) to workplace situations which you will likely encounter in your day-to-day work in HRM. As part of your learning, we focus on the development of effective professional communication skills for the workplace.

• Length of paper: Your paper should be 2–3 double-spaced pages, 11 point font, Times New Roman.
• Organization: Make sure that your assignment writing is well-organized, using headings and subheadings to organize content for the reader.
• Resources: It is suggested that you use just the resources provided for this assignment and used in this course, no outside research should be necessary.
• Evidence: Support your assertions with data and/or in-text citations. Use current APA format for in-text citations and create a reference list at the end of your documents.
• APA formatting: Resources and in-text citations are formatted according to current APA style and formatting.
• Written communication:
  • Convey purpose, in an appropriate tone and style, incorporating supporting evidence and adhering to organizational, professional, and scholarly writing standards.
  • Write for a specific audience, using the vernacular of the profession.
  • Use spell-check and  other tools to ensure correct spelling and grammar.
• Recommended Headings for the Memorandum:
  • OSHA Description.
  • Compliance Objectives.
  • Risk/Opportunity (costs and benefits).
  • Specific Steps (approach).

Resources 

• Health and Safety
  These articles will help you to determine what to include in your executive summary, due this week.
  • 10 things you wish: Everyone understood about safety. (2019). Professional Safety, 64(11), 22–23.
    • This article outlines the benefits of a culture of safety.
  • Just had a reportable injury? Prepare for a visit from OSHA. (2017, July 10). OSHA Compliance News, 6(4).
    • An article about preparing for an OSHA visit to the workplace.
  • Minnick, W. D., Helmrich-Rhodes, L., Mulroy, J., & McKnight, D. (2019). OSHA consultation. Professional Safety, 64(6), 46–50.
    • The authors outline an approach to creating a culture of safety and performance.
  • OSHA rule will help protect sensitive employee information. (2019). Briefings on Hospital Safety, 27(6), 6–7.
    • This article is about protecting the privacy of employee information.
  • The mock OSHA inspection: Practice makes perfect. (2014). Medical Environment Update, 24(5), 1–3.
    • Outlines an approach to practicing for an OSHA inspection.