Powerpoint Presentation

For this Assignment, you are to generate a 5 to 8 PowerPoint slide presentation that addresses the following topics:

  1. Address at least one common ethical obligation or issue facing psychologists in each of the following areas.
    • Law enforcement
    • Corrections
    • Courts System
    • Academia
  2. Explain how each ethical obligation is overcome and/or mitigated by psychologists by providing specific examples of policies, programs, laws, or regulations that are in place in each area of focus.

IT Audit (Conducting A Technology Audit Of Your Organization )

The CEO of your organization has asked to you to conduct a technology audit to help him understand and manage his information technology tools and processes as a strategic business resource.

“Our existing IT systems have not always met expectations,” he explains. “Unfortunately, some of these suboptimal systems could still be in use because we haven’t fully explored suitable alternatives.”

“Our technology team and tech company vendors have briefed me on several new technologies and their capabilities, but I’m worried they don’t fit into an overall strategy for our organization. If we invest in these technologies and don’t recoup the costs, it could be a disaster.”

“I want you to become familiar with the current mission, objectives, and operations of the organization. Then I want you to perform an inventory of the current IT infrastructure, development, user-support, and system security, and assess how much they support the business strategy. Finally, research some of the latest technologies and how we could potentially use them.”

“I’d like you to a prepare and give me three things: a summary of our organization’s business objectives and our effectiveness in meeting them, an assessment of our existing technology, and a technology audit with your specific recommendations for changes to our organization’s technology infrastructure. You’ll have three weeks to complete this task. I’ll e-mail you some additional information later today.”

You return to your office and begin research into your organization’s mission and objectives. A few hours later you receive an e-mail from the CEO.

“I went to a conference last month,” the CEO has written, “and heard about some interesting ways to analyze large amounts of data.”

“Apparently, big data analytics,” he continues,”“is one of the fastest growing emerging technologies for business, and it has applications in finance, human resources, supply chain management, and engineering. Maybe we should be thinking about this? Or maybe there is other new tech we should learn more about? I’ll leave it to you to pursue what you think would work for us.” As you read his e-mail, you wonder what other emerging technologies you will learn about after a little more research.

You also begin to ponder the word audit: it implies a complete and careful examination. For this technology audit, you know you’ll need to examine all of the important factors that impact your organization’s current legacy systems and future technical capabilities, including hardware, software, networks, databases, security and people. You have a lot of work to do in the next three weeks!

 

This project will use templates in Microsoft Excel to walk you through steps to evaluate your information systems strategy, to assess gaps in your current system implementation and security, and to recommend emerging technologies to assist your organization in its business objectives. The file Templates_for_Project2_with_Instructions.xlsx contains the required templates and instructions in Appendices A1, A2, B, C, D, E, F, G ,H, I:

· Appendices A1, A2: Business Objectives (to be used with Step 1)

· Appendix B: Organizational Effectiveness (to be used with Step 1)

· Appendix C: Department Effectiveness (to be used with Step 1)

· Appendix D: Technology Inventory (to be used with Step 2)

· Appendix E: Information Technology Assessment (to be used with Step 2)

· Appendix F: Risk Assessment (to be used with Step 3)

· Appendix G: Risk Matrix (to be used with Step 3) (for information only)

· Appendix H: Emerging Technology Assessment (to be used with Step 4)

· Appendix I: Implementation Plan for Emerging Technology (to be used with Step 6)

Each appendix is in a different tab. A link to the Templates_for_Project2_with_Instructions.xlsx file is found in Step 1: “Understand the Business.”

When you submit your project, your work will be evaluated using the competencies listed below. You can use the list below to self-check your work before submission.

· 1.1: Organize document or presentation clearly in a manner that promotes understanding and meets the requirements of the assignment.

· 2.1: Identify and clearly explain the issue, question, or problem under critical consideration.

· 2.5: Develop well-reasoned ideas, conclusions or decisions, checking them against relevant criteria and benchmarks.

· 8.1: Evaluate major business/organizational systems and processes and make recommendations for improvement.

· 8.2: Analyze an organization’s current technology capabilities and needs, identifying specific strengths and areas of weakness.

· 11.1: Recommend strategic plan for the use of technology to meet the strategic goals of organization.

· 13.1: Identify and analyze new opportunities.

Cost Behavior Analysis – POWER POINT

Scenario: Shelley Jones has just been elected as president of the Circular Club of Auburn, Kansas, and she has been asked to suggest a new fundraising activity for the club. After a considerable amount of research, Shelley proposed the Circular Club sponsor a professional rodeo. In her presentation to the club, Shelley recommends the fundraiser become an annual activity with the following goals:

  • Continue to grow each year
  • Give back to the community
  • Provide the club a presence in the community

Shelley’s goal in the first year is to have an activity that would become an “annual community event” and would break even the first year and raise $5,000 the following year. In addition, based on the experience of other communities, Shelley believed a rodeo could grow in popularity so the club would eventually earn an average of $20,000 annually.

A rodeo committee was formed. Shelley contacted the world’s oldest and largest rodeo-sanctioning agency to apply to sponsor a professional rodeo. The sanctioning agency requires a rodeo to consist of the following five events: Bareback Riding, Bronco Riding, Steer Wrestling, Bull Riding, and Calf Roping, Team Roping and Women’s Barrels. Prize money in the amount of $3,000 would be paid to winners in each of the seven events. Members of the rodeo committee contracted with RJ Cattle Company, a livestock contractor on the rodeo circuit, to provide bucking stock, fencing, and chutes. Realizing costs associated with the rodeo were tremendous and ticket sales would probably not be sufficient to cover the costs, the rodeo committee sent letters to local businesses soliciting contributions in exchange for various sponsorships. Exhibiting Sponsorships are $1,000 to exhibit products or services, while Major Sponsorships are $600, and Chute Sponsorships are $500 to have the name of the sponsor’s business on one of the six bucking chutes. For a contribution of $100, individual sponsors will be included in a Friends of Rodeo list found in the rodeo programs.

A local youth group will be contacted to provide concessions to the public and divide the profits with the Circular Club. The Auburn Circular Club Pro Rodeo Roundup will be held on June 1, 2, and 3. The cost of an adult ticket is set at $8 in advance or $10 at the gate; the cost of a ticket for a child 12 or younger is set at $6 in advance or $8 at the gate. Tickets are not date-specific. Rather, one ticket will admit an individual to one performance of his or her choice– Friday, Saturday, or Sunday. The rodeo committee is able to secure a location through the county supervisors’ board at a nominal cost to the Circular Club. The arrangement allows for the use of the county fair grounds and arena for a one-week period. Several months prior to the rodeo, members of the rodeo committee were notified the bleachers at the arena would hold 2,500 patrons. On Saturday night, paid attendance was 1,663, but all seats were filled due to poor gate controls.  Attendance was 898 Friday and 769 on Sunday.

The following revenue and expense figures relate to the first year of the rodeo.

Receipts

Contributions from sponsors      $22,000

Receipts from ticket sales         $28,971

Share of concession profits         $1,513

Sale of programs                           $600

Total receipts                            $53,084

Expenses

Livestock contractor                  $26,000

Prize money                              $21,000

Contestant hospitality                  $3,341*

Sponsor signs for arena               $1,900

Insurance                                    $1,800

Ticket printing                              $1,050

Sanctioning fees                             $925

Entertainment                                 $859

Judging fees                                   $750

Port-a-potties                                  $716

Rent                                               $600

Hay for horses                                 $538

Programs                                         $500

Western hats to first 500 children       $450

Hotel rooms for stock contractor        $325

Utilities                                            $300

Sand for arena                                  $251

Miscellaneous fixed costs                  $105

Total expenses                                            $61,410

Net loss                                                      $ (8,326)

*The club contracted with a local caterer to provide a tent and food for the contestants. The cost of the food was contingent on the number of contestants each evening. Information concerning the number of contestants and the costs incurred are as follows:

Contestants  Total Cost

Friday                                  68                            $998

Saturday                              96                          $1,243

Sunday                                83                          $1,100

$3,341

On Wednesday after the rodeo, members of the rodeo committee met to discuss and critique the rodeo. Jonathan Edmunds, CPA and President of the Circular Club, commented that the club did not lose money. Rather, Jonathan said, “The club made an investment in the rodeo.”  The rodeo committee has requested an analysis of the rodeos performance and evaluation of the CPA’s review.

Create a minimum 2-slide presentation, including detailed speaker notes, as the committee’s consultation team and respond to the following:

  • Rather than hire the local catering company to cater the Contestant Hospitality Tent, members of the Circular Club are considering asking Shady’s Bar-B-Q to cater the event in exchange for a $600 Major Sponsor spot. In addition, The Fun Shop, a local party supply business, will be asked to donate a tent to use for the event. The Fun Shop will also be given a $600 Major Sponsor spot. Several members of the Club are opposed to this consideration, arguing that the two Major Sponsor spots will take away from the money to be earned through other sponsors. Adrian Stein has explained to the members the Major Sponsor signs for the arena cost only $48 each. In addition, there is more than enough room to display two additional sponsor signs. What would you encourage the Club to do concerning the Contestant Hospitality Tent? Would your answer be different if the arena were limited in the number of additional signs that could be displayed? What kind of cost would you consider in this situation that would not be found on a financial statement?
  • Assume you are elected chair of the rodeo committee for next year. What steps would you suggest the committee take to make the rodeo profitable?

Show your work in Microsoft® Word or Excel®.

Complete calculations/computations using Microsoft® Word or Excel®.

Format the assignment consistent with APA guidelines.

Data, Information, And Knowledge Assignment

now that you know the definitions of data, information and knowledge, compare and contrast all three terms using the following scenario:

Big Bank runs a free daycare service for all of its employees. The company wants to easily identify employees who use the service and where it is best for parents to pick up their kids based on the multiple locations. The bank locations are all in the city of Chicago. Each location has at least 75 employees. The bank consistently is ranked within the top 100 places to work. Each location offers at least one restaurant on site. Food trucks are brought in once a month for variety.Each employee can have multiple children enrolled in the daycare center.Employees can be described by their employee ID number, first name, last name, phone number, and work location.Children can be described by their first name, last name, gender, and date of birth.Because children are provided with lunch and snacks, it is important to track dietary restrictions (e.g., gluten-free, vegetarian, vegan, food allergies, etc.).Each child is assigned to one of three rooms based on age, maturity, and parents work location.

Develop a 1-page document to compare and contrast the terms data, information, and knowledge. Alternatively, create an infographic using an infographic maker such as Piktochart, Venngage, or Canva.

Include the answers to the following questions in your document or infographic:Why does it matter if an information system developer mixes up the terms data, information, and knowledge?What consequences might result in designing an information system if the terms were interpreted improperly?

Information System Overview Assignment

We interact with information systems every day. For example, libraries have systems that enable you to search for, reserve, and check out books; utilities maintain systems that enable customer service representatives to answer questions about your bill; and your grocery store checkout station is connected to multiple systems that enable the store executives to determine staffing levels, inventory levels, advertising, and promotion efforts.

Select an information system you use on a regular basis.

Create an overview that explains the following:The type of the information systemThe evolution of the selected type of information system. (e.g. the evolution of student financial aid systems in general)How the information system affected jobs and careers. (e.g. before financial aid systems were developed and which jobs supported the function of financial aid that do not exist today due to technology)The names of the components used and a description of the purpose or role of each. (Hint: Use information system components you learned so far.)The benefits this system evolution has brought to you, the organization implementing the change, and other people or organizations within the community

Present your recommendation in one of the following ways:

A 2-page Microsoft® Word document or

A 12 slide Microsoft® PowerPoint® presentation with detailed speaker notes and appropriate animations

Note: You can include diagrams developed with Microsoft® Visio®, Microsoft® PowerPoint®, or another software application approved by your Instructor if you feel it will enhance your recommendation.

Case Study 2: Data Breaches and Regulatory Requirements

Due Week 6 and worth 100 points
The National Institute of Standards and Technology (NIST) provides an extensive amount of information, resources, and guidance on IT and information security topics. The Federal Information Security Management Act (FISMA) provides standards and guidelines for establishing information security within federal systems. However, there have been, and continues to be, numerous security incidents including data breaches within federal systems. Review the information about FISMA at the NIST Website, located at http://csrc.nist.gov/groups/SMA/fisma/index.html. Additionally, review the information, located at http://www.govtech.com/blogs/lohrmann-on-cybersecurity/Dark-Clouds-Over-Technology-042212.html, about the data breaches within government systems. Select one (1) of the data breaches mentioned to conduct a case analysis, or select another based on your research, and research more details about that incident to complete the following assignment requirements. Write a three to five (3-5) page paper on your selected case in which you:

  1. Describe the data breach incident and the primary causes of the data breach.
  2. Analyze how the data breach could have been prevented with better adherence to and compliance with regulatory requirements and guidelines, including management controls; include an explanation of the regulatory requirement (such as from FISMA, HIPAA, or others).
  3. Assess if there are deficiencies in the regulatory requirements and whether they need to be changed, and how they need to be changed, to mitigate further data breach incidents.
  4. Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.

Assignment 5: Tour Operator Agency Database 

Due Week 6 and worth 90 points

The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maintained Oracle server.

A multinational tour operator agency has gained new business growth in the North American market through the use of social media. Its operation has expanded by 50% within six months and the agency requires an enhanced data management strategy to sustain their business operations. Their existing data repository for its reservation processing system is limited in business intelligence and reporting functionalities. The tour operator seeks a database management specialist to assist them in leveraging their data sources to enable them to forecast and project tour sales appropriately.

Imagine that you have been hired to fulfill their need of enhancing the data repository for their current reservation processing system. Upon reviewing the system, you find that the data structure holds redundant data and that this structure lacks normalization. The database has the following characteristics:

  • A table that stores all the salespersons. The table holds their employee id, first name, last name and “Tours sold” field. The “Tours sold” field is updated manually.
  • A table that stores tour customer data and tours sold. The table holds customer name, address, city, state, zip code, tour(s) selected, number of persons in tour, and total amount paid. The current structure will show the customer more than once, if the customer books multiple tours.
  • A tour table that is used as a tour rate sheet which holds the tours offered and the cost per person. Tour rates vary every three (3) months depending on the tourist season.

Write a three to four (3-4) page paper in which you propose an enhanced database management strategy. Your proposal should include the following:

  1. Design a data model that will conform to the following criteria:
    1. Propose an efficient data structure that may hold the tour operator’s data using a normalization process. Describe each step of the process that will enable you to have a 2nd Normal Form data structure.
    2. Create naming conventions for each entity and attributes.
    3. Conclude your data model design with an Entity Relationship Model (ERM) that will visually represent the relationships between the tables. You may make use of graphical tools with which you are familiar. Note: The graphically depicted solution is not included in the required page length.
  2. Construct a query that can be used on a report for determining how many days the customer’s invoice will require payment if total amount due is within 45 days. Provide a copy of your working code as part of the paper.
  3. Using the salesperson table described in the summary above, complete the following:
    1. Construct a trigger that will increase the field that holds the total number of tours sold per salesperson by an increment of one (1).
    2. Create a query that can produce results that show the quantity of customers each salesperson has sold tours to.
  4. Support the reasoning behind using stored procedures within the database as an optimization process for the database transactions.

Your assignment must follow these formatting requirements:

  • Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
  • Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
  • Include charts or diagrams created in any chart or drawing tool with which you are familiar. The completed diagrams / charts must be imported into the Word document before the paper is submitted.

The specific course learning outcomes associated with this assignment are:

  • Explain the fundamentals of how data is physically stored and accessed.
  • Compose conceptual data modeling techniques that capture information requirements.
  • Design a relational database so that it is at least in 3NF.
  • Prepare database design documents using the data definition, data manipulation, and data control language components of the SQL language.
  • Use technology and information resources to research issues in the strategic implications and management of database systems.
  • Write clearly and concisely about topics related to the strategic planning for database systems using proper writing mechanics and technical style conventions.