Use Case for ERD

  

The goal of the project is to implement a “prototype” database system application / ERD diagram for an eCommerce social-network system called UCOnline where users can explore information about books/music/software, rate your purchase, identify purchase price and see ratings of their friends.

The project will require you to complete the assignment individually. Below you will find the ERD deliverable requirements. There are two parts to the assignment. You must create a diagram using a diagramming tool AND provide a written text-based document explaining your relationship mapping (systems analysis use case document). 

BUSINESS REQUIREMENTS ACROSS ALL ASSIGNMENTS

You will work with book/music/media information, user information, ratings of books, and users’ social network

  • Each book has an id, title, publication date, publisher,      ISBN, functional category, page count, price (publisher), and product      description
  • There are 3 categories of book: fiction, non-fiction, and      specialty
  • There are 2 categories of music: digital and media-based
  • An author can write one or more books.
  • A musician can be a solo artist, part of a group, or both
  • An author can also be associated with one or more publishers.
  • A musician/group/act can be associated with one or more music      houses
  • An author’s book can have one or more editions.
  • A song and or album can have more than one version/edition      (i.e. EP, LP, CD, DVD etc)
  • A publisher can have many authors and many books.
  • A record company can have many artists associated and many      albums associated with it. 
  • A record company can also be the publishing company (i.e.      self-publishing)
  • Many ISBNs can also be associated with a given publisher but      only one ISBN per form of medium (ie the ISBN is the PK no matter      what).
  • An author can write many books.
  • An artist can write many songs, albums etc.

UCOnline needs to keep track of user ratings for each item sold in the online store (e.g., 1-5 and 1 for ‘Dislike’, to 5, for ‘Awesome!’).

A particular user rates a particular item at a given time.

A user CANNOT rate the same multiple times unless there are multiple editions of the item. Each edition can be rated separately.

Each user who submits a rating will be identified by a unique id and has a name, gender, age, and location. Nothing is anonymous.

There is also a social network between users. Users can send communication requests (i.e. instant messages/emails) to other users. Such requests can be accepted or ignored. Once accepted, the two users are considered ‘book buddies.’ If ignored, the user can send the request again. We want to add a store when the requests were sent (timestamp), the result of the requests and when the request was answered (timestamp).

Module 05: Discussion Forum ECOM-500: Business and IT

 

Consider your organization or another organization that has been affected by a cyber-attack. Feel free to research current events on this topic if you do not have personal experience with an organization who has been affected by a cyber-attack. Once you have selected an organization, answer the following questions:

  • Provide a brief summary of the organization you have selected.
  • What type of cyber-attack occurred?
  • How did the organization respond to the attack?
  • What were the impacts (or potential impacts) to the business?
  • What were the costs associated with the attack? If you do not have actual numbers, what types of costs were likely involved?
  • What did the organization do to mitigate the risk of future attacks? Did the organization change its processes or procedures?
  • As a business manager, what are some additional recommendations you would make to the organization, from a business perspective, to better defend itself in the future? What steps can the business take to better support the IT (information technology) department’s security efforts? Explain.
  • Embed course material concepts, principles, and theories, which require supporting citations along with at least two scholarly peer reviewed references supporting your answer. Keep in mind that these scholarly references can be found in the Saudi Digital Library by conducting an advanced search specific to scholarly references.
  • Reply to at least two of your peers’ initial posts. These replies need to be substantial and constructive in nature. They should add to the content of the post and evaluate/analyze that post’s answers. Normal course dialogue doesn’t fulfill these two peer replies but is expected throughout the course. Keep in mind that within your initial post, answering all course questions is required.
  • Use  academic writing standards and APA style guidelines.

Be sure to support your statements with logic and argument, citing all sources referenced. Post your initial response early, and check back often to continue the discussion. Be sure to respond to your peers’ posts as well.

Focused Current Event Article Discussion 1: Culturalism vs Structuralism Evaluations of U.S. Political System

 

Instructions: This is a 2 part focused writing assignment. I will provide the context, necessary information, background, as well as links and resources, needed to comply with the minimum requirements necessary to participate and complete this assignment. If you are aiming for an A or B on this assignment, I do expect that you will include additional resources and research links. These do not have to be a laundry list.  More is not better. Direct and to the point is key.  I expect additional resources be properly cited, at the end of your part 1 critical analyses.   

Part 1: Choose a Prompt and Post Reply

Minimum length of analysis is 1 page double spaced, or half page single spaced. Type it first in a word document for reference. Then, copy and paste. Formatting standards: 12 point font, times new roman, double spaced ( if 1 full page in word) otherwise single spaced (equivalent to half page in word). Must include properly formatted citations for any and all resources, links and information publications, used in your research, as well as incorporated as supporting evidence, for your critique and analysis.

I expect you to incorporate information, offering supporting evidence specifically from at least one or more of independently researched resources and links, to be discussed, mentioned and cited within either your part 1 or part 2 post, if not both.  You can just note the source when citing parenthetically, within your analyses, as long as you provide a full title, and link to the information source, listed at the end of your reply. This is what will earn you a A or B grade.

Part 2:  Critique and Rebuttal

You will not be able to review posts submitted by your peers, until you yourself have submitted your critical analysis, for Part 1.

Review your classmates posts. Select one to offer a rebuttal or critique.

Selection Criteria and Post Formatting Requirements

Cannot choose to reply to post of someone who shares your same prompt or your same position and analyses. You only have to do this once, but I encourage you all to reply and post to as many classmates posts to enhance discussion to make the course more engaging.

Minimum length of analysis is 1 page double spaced, or half page single spaced. Type it first in a word document for reference. Then, copy and paste. Formatting standards: 12 point font, times new roman, double spaced ( if 1 full page in word) otherwise single spaced (equivalent to half page in word).

Introduction and Background on Discussion Topic and Prompts

Modern political scientist debates begin with matters of what research methods are to be accepted as the best approach. Structuralists believe research, methods and analysis should focus on objective factors. Understanding political context of one’s environment can only be objectively achieved, if focus is on factors pertaining to the way in which the world is organized. Structure and organization determine politics. Therefore, the proper objects to study are power, interests, and institutions.

Culturalists prioritize subjectivity. Exploring research of objects relative to perception is the best practices methodological approach to evaluating and understanding politics. Values, opinions and psychology are argued to be more important than objective and tangible reality.

Structuralists and culturalists agree on the issue and topic of debate. For example, both groups would acknowledge and validate there is considerable emerging inertia within the United States political systems, as it pertains specifically to presidential (s)election. The methods required to achieve an explanation is the source of opposing divergence.  

Take the presidential selection issue. Structuralists research and methods would rely on explanations of factors, such as electoral laws and processes.  It would be necessary to build a research method that evaluates variation or uniformity, with a state by state comparison of laws, rules, processes, and methods that govern how the state’s electoral college is selected, organized, structured, empowered, and ultimately the rules and processes that govern how presidential votes will be cast, tabulated and awarded.

A culturalist would require a research method that focuses on factors, such as public opinion. They would assume that the recent and increasing inertia behind electoral college concerns in deciding the country’s President, is most accurately and informatively explained as variable(s) dependent of people’s attitude in apathy towards voting system, all together. Or perhaps, evaluating the value in objects, like people’s obedience and acceptance of a 250 plus year old institution, that was created before modern United States’ geography. For culturalists, the root of the problem is not the governing laws and processes that structure the existence and behavior of the institution: electoral college.  The explanation requires evaluation of the governed.  Namely their values in acceptance and tolerance toward the current system. Their research and methods would be driven by a question focused more towards psychology. For example, despite a lack in federal law—outside of the constitutional creation of the electoral college institution—to uniformly mandate each state’s electoral college selection and voting processes be the same, and with the exception of 3-4 of the 50 total states, somehow the states ended up adopting the same selection and procedural system, by which their independent electoral college and its voters operate. Thus, the higher priority being placed on values of acceptance amongst the public, instead of the institutions (lack of uniformly mandated) procedural rules, guidelines and laws.   

PROMPT

Decide and discuss whether you consider yourself as one of the following….either

 1.) exclusively one or the other: structuralist or culturalist,

2.)  Neither, providing and discussing ideas about what you think a better approach and method to explaining current political system environments, include reasoning, examples and hypotheticals

3.) A combination, provided discussion must include identification of specific aspects from each approach that you would rely on, to achieve a balanced reasoning and rationalization to discuss and explain a more individualized approach, which you would defend as the best approach to finding the most accurate method to understanding political systems. Include any examples, along with hypothetical comparisons, explanations, or scenarios to fully explain your position.

Remember, there is no right or wrong answer. You can base your response on the presidential selection and electoral college example I outlined, while introducing the prompt and topic for this current event discussion.  Your response does not require you to focus your analysis and response on the particular example I illustrated.  You can find your own. Be thorough. Be direct. Be reflective. Be thoughtful. Be a political scientist!!

CJ 2400 MOD 5 question

 

Chapter 12-13 Problem

Directions: Please respond fully to the Procedural Problem based on the following paragraph(s). For specific assignment requirements see Course Syllabus/Grading Criteria/Assignments.During Dave’s final year at the university, he worked in the Internet technology section of the school’s communication center.  During this time he became familiar with the security protocols used by the university.  With his business degree at knowledge, he set up a small corporation that sold widgets.  Using his understanding of the university’s information technology security system to bypass the university’s security protocols, he managed to have the university pay the bill for the information technology that his company used by stealing computer resources.Other students who remained at the university discovered Dave’s scheme and notified the police.  Dave’s widget business was not doing well so Dave had to file bankruptcy at about the same time that the state filed an information charging him with felony theft of services.   An attorney was appointed to represent Dave at the preliminary hearing and the same attorney handled the felony trial at which Dave was convicted as charged.  His attorney requested a jury trial during which a total of six jurors were seated to form the jury. They heard most of the case, but near the end of the trial, one of the jurors had to have emergency surgery and was excused by the judge.  Since no alternate jurors were available at this point, the judge decided to allow the remaining five jurors to decide the case. As the judge noted, “Non-unanimous jury verdicts have been approved, so we will just have to go with five jurors.  It will be almost like a non-unanimous jury verdict and it’ll be all right.”  As it turned out, Five jurors eventually voted to convict Dave of the charged offense.Earlier, during the jury selection process, the prosecutor kept using peremptory challenges that had the effect of removing most members of Dave’s race from the jury.  Dave’s attorney objected to the use of race as a standard for eliminating jurors, but the judge overruled Dave’s attorney.  Dave’s attorney began eliminating members of the prospective jury based on a gender standard because he wanted more “geeky” types to hear the case.  He was eliminating prospective jurors based on gender in a similar way from what the prosecutor had been doing with race.  When the prosecutor objected to what Dave’s attorney was doing with respect to removing jurors based on gender, the judge said, “Well, that should even things out.”At the conclusion of jury selection, Dave’s attorney was not happy with the panel that had been selected, so after consulting with Dave, he requested that the judge hear the case without a jury. The judge refused because he noted that the prosecution had the right to a jury trial based on the guarantees under the federal constitution.The judge ordered that the case proceed and the result was that the jury convicted Dave.  The judge sentenced him to a year and a day in the state prison but did not order a fine or restitution.The Procedural QuestionFollowing the conclusion of the bankruptcy proceedings, Dave did manage to scrape some money together and hired an appellate attorney to see what opportunities for legal relief might exist in the Court of Appeals. Dave explained as much of what happened as he could remember, and the appellate attorney read the trial transcript. What legal issues should is appellate attorney identify? How should those issues be resolved? Why should the legal issues, in this case, be resolved the manner that you have suggested?  

ERM Wk5 – S

 Q1.  275 words

 The readings this week discusses broad context of risk and investigative forensics. Part of risk management is to understand when things go wrong, we need to be able to investigate and report our findings to management. Using this research, or other research you have uncovered discuss in detail how risk and investigate techniques could work to help the organization. ERM helps to protect an organization before an attack, where as forensics investigate technique will help us after an attack – so lets discus both this week. 

Resources:

Hou, J., Li, Y., Yu, J. & Shi, W. (2020). A Survey on Digital Forensics in Internet of Things IEEE Internet of Things Journal, I(1),1-15,.

Chen, J. & Zhu, Q. (2019). Interdependent Strategic Security Risk Management With Bounded Rationality in the Internet of Things. IEEE Transactions on Information Forensics and Security, 14(11), 2958-2971.

Borek, A. (2014). Total Information Risk Management: Maximizing the Value of Data and Information Assets (Vol. First edition). Amsterdam: Morgan Kaufmann

Q2. Research paper —  SEPARATE Document —- 5 full pages 

Write a research paper discussing the concept of risk modeling. Please also evaluate the importance of risk models. Lastly, construct an approach to modeling various risks and evaluate how an organization may make decisions about techniques to model, measure, and aggregate risks.  

Your paper should meet the following requirements:

  • Be approximately four to six pages in length, not including the required cover page and reference page.
  • Follow APA7 guidelines. Your paper should include an introduction, a body with fully developed content, and a conclusion.
  • Support your answers with the readings from the course and at least two scholarly journal articles to support your positions, claims, and observations, in addition to your textbook.
  • Be clearly and well-written, concise, and logical, using excellent grammar and style techniques. You are being graded in part on the quality of your writing.

 

Three discussion posts

  

All three sections are difference assignments can be done in sinle word document

Section I 

400 to 600 words with two APA reference

Create a post discussing standards and procedures. Discuss the following:

  • Which standards may apply to your      project company?
    • Explain why these standards are       relevant to your company.
  • How are standards different from      procedures?
  • How are standards and procedures      important to the organization?
  • How are standards and procedures      eventually incorporated into policies?

Note that standards can be internal and external.

Section 2 

400 to 600 words with two APA Reference

You just became the lead security person at a small company. Assume normal setup, e-mail, company Web site, internal servers, and so forth. Although your title is not chief security officer (CSO), you report directly to the chief information officer (CIO). The person who was previously in your position moved out of state and does not respond to calls or e-mails. The CIO tells you, “You have 90 days to get that area together! I want to see your high-level approach by Monday morning.” You have three inexperienced but energetic people on your team, and it is Friday afternoon.

Discuss the following:

  • What are the 4 key actions you need      to take within the first 90 days (or sooner)?
  • Who will be involved?
  • Include an explanation of the      benefits of these actions  

Remember, this is high level, so write two or three paragraphs with the 4 action items highlighted. The majority (90%) of your report will outline what has to be done, and the remainder (10%) should include how this will be done.

Section 3

400 to 600 words with two APA Reference

Create a policy for borrowing a car. What are some of the rules you would give someone if they were to borrow your car? (If you do not have a car, for the sake of this assignment, imagine that you do.) For inspiration, think of some of the rules that apply when renting a car, and consider the following:

  • Would the borrower be responsible      for any parking tickets incurred?
  • How many miles can they use on your      car?
  • Is food allowed in the car?
  • What specifically would you expect      when they return the car?

homework paper

I need  a Final  Project for nurse 508 Minimum of 4 pages in APA stile and minimum of 4 references , plus a power point presentation  no more of 12 slides. Please follow the instruction bellow very carefully. The professor is very demanding. 

Differential Diagnosis Case Studies Presentation.  Final Project

General Instructions

1. This is your Nurse 508 Final Project. Minimum of 4 pages in APA stile and minimum of 4 references 

Title – Scabies

Specific Instructions

You are the group of Nurse Practitioners working at the clinic. Each Team will develop the presentation of the Case Study as follows:

1. Discussion of assigned medical condition:

a) Description

1) Pathophysiology

2) Etiology

b) Clinical Manifestations

1) Red Flags

2. Case Study

a) Create a hypothetical case of a patient who comes to your consultation and   whose final diagnosis is assigned.

b) History Data and Physical Examination

3. Case analysis – Diagnostic Framework

a) Apply the VINDICATE mnemonic as applicable. Explain what the relationship   of the conditions is selected in the mnemonic with the diagnosis of the case.

4. Analysis of the case – Differential Diagnoses

a) Make the list of 5 differential diagnoses

1) In order of priority

2) Include in the list the diagnosis of the case (previously assigned)

5. Case analysis – Diagnostic Tests

a) Create a table, following the example described below, with the diagnostic   test(s) that you would order to your patient in order to make the “Rule Out” of  the differential diagnoses.

b) Include diagnostic tests in blood, and imaging studies, as applicable.

c) Explain what findings you are looking for with each test.

d) Describe the results obtained by your patient (hypothetical)

e) Be prepared to discuss the importance or relevance of the diagnostic tests you   ordered.

Differential   Diagnosis (Prioritize)

Diagnostic Tests (ordered)

Findings   expected with the diagnostic test

Patient results (hypothetical)

Analysis or Conclusion

 1. Assigned Diagnosis

6-. Prepare the case study in a Power Point presentation.  No more than 12 slide. Pay attention to the amount of information on the slides (do not overload them). Pay attention to the size of the font. APA Stile is needed even for the references.

7. Close your presentation with a conclusion or final analysis and the references used.

Leadership models and theories

 

Leadership models and theories help define approaches for creating effective behaviors within specific situations or environments. Examine contemporary leadership models and theories and in a 1,000-1,250-word paper, explain why these models or theories are effective tools for leaders who serve in health care organizations. Include the following:

  1. Discuss the correlation between effective leadership and organizational performance in health care.
  2. Discuss why it is important for regulatory professionals to practice good leadership. Outline effective strategies for regulatory leadership and explain why these are essential in health care.
  3. Describe how the concept of stewardship from servant leadership relates to a Christian worldview. Explain how stewardship relates to professional responsibility, how it can be applied in a health care setting that serves diverse populations, and the potential benefits for stakeholders and the organization overall.
  4. Distinguish between informal and formal leadership. Explain how informal leaders influence others and how this impacts a health care organization.
  5. Select one additional theory or model that you think would be effective for a health care leader to employ. Provide an overview of the model or theory and explain what aspects would be effective and why.

A minimum of three academic references from credible sources are required for this assignment.

Prepare this assignment according to the guidelines found in the APA Style Guide, located in the Student Success Center. An abstract is not required. 

Benchmark Assignment: Multi-Generational Workforce

 

Imagine that you manage a department in a specific health care service, facility, or other health sector-related occupation of your choice. In this scenario, the age of the employees in your department spans four generations and conflict is brewing between them. It is affecting performance, shift scheduling, and cooperation with other departments.   

Identify leadership and operational strategies that can be leveraged to overcome these conflicts and improve performance. 

Write a 3- to 4-page proposal about how you plan to resolve these conflicts. 

Include the following: 

  • Explain the situation that you and your department are facing. 
  • Propose key strategies that you believe will resolve the conflict. 
  • Provide and evaluation of your own leadership style and determine what changes need to be made to be a more effective leader. 

Create a 10-minute, 5- to 9-slide voice-over presentation using either Microsoft® PowerPoint® or websites such as Google Slides™, Adobe® Slate, or Prezi that presents your proposal to the human resources manager and chief operating manager. 

Cite at least 3 reputable references to support your assignment (e.g., trade or industry publications, government or agency websites, scholarly works, or other sources of similar quality). 

Format your assignment according to APA guidelines. 

Click the Assignment Files tab to submit your assignment.

Clarification to this assignment;

This assignment requires 2 parts: a word document and a powerpoint presentation.  

There are 8 parts that will be graded:

Assignment completeness.

Situational Assessment

Clear and Reasonable expectations (**HINT – use SMART goals)

Strategies to overcome conflicts

Measuring Success (*HINT – be clear, concise and quantifiable)

Leadership Style Evaluation (*HINT – Self Reflection, incorporate creativity)

Written Communication

Information Utilization (*HINT – 3 or more CREDITABLE references, citations throughout)

For the Powerpoint – I expect something that you would submit to your boss. Complete, final, and aesthetic. Choose a background. Slides should have bullets, and should have voice-over or detailed notes. Include citations and reference lists.

BPC110 homework Lesson 14

Part 1 – Microsoft Access 2019

Use Access to create a database to store and retrieve Manufacturer Contact and Inventory information for Rio Salado Boat and Marine dealership.

  1. Create a new blank Access database.
  2. Save the file as BoatDatabase_MEID.accdb. Be sure to replace “MEID” in the filename with your actual MEID.

Structure of the Database 

Read the requirements for the database below and understand how the database should work before you create the design. Remember to follow the best practices presented in TestOut and the online lesson content for creating professional Access databases.

Create the Tables 

You will create new tables that contain information about the Rio Salado Boat and Marine Dealership’s manufacturers and inventory. When creating fields for your tables, it is important to break down your data into the smallest chunks you can (fine data granularity) to make it easier to extract data from the database later. You will also need to join the tables on common fields later in the project. For this project, assume a manufacturer can supply the boat dealership with multiple types of boats for the dealership’s inventory.

NOTE: Remember to assign the most appropriate data type to each of the fields and that one of the fields in each of your tables must be set as the Primary Key. You do not need to enter data records into your tables at this time; you will create a form later in this project for data entry.

Manufacturer Contact Table

Create a new table named Manufacturer Contact Table. At a minimum, your table should include the following fields:

  • Manufacturer ID
  • Manufacturer (e.g., Bayliner)
  • Manufacturer Address
  • Sales Representative Name
  • Phone Number
  • Email Address

Inventory Table

Create a new table named Inventory Table. At a minimum, your table should include the following fields:

  • Inventory ID
  • Manufacturer ID
  • Boat Type (e.g., Sailboat)
  • Model Number
  • Dealer Cost
  • MSRP (i.e., Manufacturer Suggested Retail Price)
  • Quantity in Inventory

Establish Table Relationships

Once the design of the tables has been completed, the next step is to establish relationships between the tables:

  1. Join the Manufacturer Contact Table with the Inventory Table on common fields.
  2. Enforce referential integrity.

Create a Form

Once the tables have been designed and the relationships have been established, it is time to enter data. Remember that each field of each record will need to include data. You will use one form to enter and edit data in the two tables.

  1. Create one form named Manufacturer Form that can be used to enter data into both tables.
  2. Use the form to enter a minimum of four manufacturers. Include your name in one of the records as a Sales Representative for one of the manufacturers.
  3. Use the form to enter at least two different boat types for each manufacturer.

Create the Queries

The ability to extract data from one or more tables is one of the most important functions provided by a database. You will now design, save, and run queries to retrieve specific information from the two tables.

Inventory Query

  1. Create a query named Inventory Query that will SUM the Quantity in Inventory by each Manufacturer.
  2. Save and run the query.

Sales Rep Query

  • Create a query named Sales Rep Query that will show the Manufacturers and Sales Representatives from the Manufacturer Contact Table and all the fields from the Inventory Table.
  • The query must also sort ascending the data by Sales Representative Last Name.
  • Save and run the query.

Create a Report

Reports are used to generate printouts from the tables or queries in a database.

  1. Create a report named Inventory Report that lists the items in inventory.
  2. Include the following fields in the report:
    1. Manufacturer
    2. Boat Type
    3. Model Number
    4. MSRP
    5. Quantity in Inventory
  3. Group the report by Manufacturer.
  4. Format the report in Landscape Orientation so that it fits on one page and all of the fields are fully legible.
  5. After finishing the Report Wizard, remove the Alternate Row Color from the report.
  6. Add a Shape Fill color of your choice, other than the Office Default, to the Manufacturer rows.

Required Objects

After creating your database, the BoatDatabase_MEID.accdb file should contain the following required objects:

  • Tables
    • Inventory Table
    • Manufacturer Contact Table
  • Relationship
    • One-To-Many Relationship Type
  • Form
    • Manufacturer Form
  • Queries
    • Inventory Query
    • Sales Rep Query
  • Report
    • Inventory Report

Save and close your BoatDatabase_MEID.accdb file.

——————————————————————————————————————————————-

Part 2 – Microsoft Excel 2019

Use Excel to create a workbook containing three worksheets. The Excel workbook will include Rio Salado Boat and Marine contact information, manufacturer and inventory information, and financing information which will also be visually depicted in a chart.

TIP: When working in Excel, remember to use FontAlignment, and Number Formatting features.

  1. Create a new blank Excel workbook.
  2. Save the file as BoatWorkbook_MEID.xlsx. Be sure to replace “MEID” in the filename with your actual MEID.

Structure of the Workbook 

Your workbook must contain three worksheets:

  • Information – This worksheet will contain the boat dealership contact information and available inventory.
  • Financing – This worksheet will show monthly payments for boats financed.
  • MSRP Chart – This worksheet will provide a visual depiction of the MSRP’s for each model of boat available.

Information Worksheet

Rio Salado Boat and Marine Dealership wants you to create a new worksheet that will contain the boat dealership’s contact information and the available inventory for the upcoming sales promotion.

  1. Rename the first worksheet as Information.
  2. Assign the worksheet tab a color of your choice other than the default.
  3. In the first row, insert the title Rio Salado Boat and Marine Information.
  4. Beginning in the third row, create Row Labels for the following:
    1. Dealership Name:
    2. Dealership Address:
    3. Dealership Phone:
    4. Sales Promotion Title:
  5. Format the Row Labels and cells so they appear like the image below. The image depicts a range of cells that contains four rows and two columns. The entire range has an Outside Border. The first column contains the Row Labels from Step 4 and is right-aligned. The second column contains a Bottom Border for each cell of the column.

Table  Description automatically generated with medium confidence

  1. Fill in the information for the Dealership Name (e.g., Rio Salado Boat and Marine), the Dealership Address, Dealership Phone, and Sales Promotion Title (you supply this information). You will use this information for the Word and PowerPoint parts of the final project as well.
  2. Below the Row Labels, Import the Sales Rep Query from the BoatDatabase_MEID.accdb file that you created in Part 1.
  3. Apply a Table Style of your choice, other than the default, to the imported table.
  4. Add a Total Row to the table to SUM the Dealer CostMSRP, and Quantity in Inventory columns.
  5. Apply Conditional Formatting to highlight the top two MSRPs using a unique cell shading and font color.
  6. Merge and Center the title in Row 1 across all columns containing data.
  7. Apply the Heading 1 cell style to the title.
  8. Add your name, your MEID, and your course and section number in the Footer.
  9. Set the Page Orientation to Landscape.
  10. Scale the worksheet to print on a single page.

Financing Worksheet

Rio Salado Boat and Marine Dealership will be providing financing to its customers during the upcoming sales promotion.

  1. Add a new blank worksheet to the workbook.
  2. Rename the worksheet as Financing.
  3. Assign the worksheet tab a color of your choice other than the default.
  4. In the first row, insert the title Rio Salado Boat and Marine Financing Information.
  5. In the second row, create a new table with the following column headers to calculate the monthly payments for the available inventory (Hint: Use all boats from the Information worksheet as data):
    1. Inventory ID
    2. Manufacturer
    3. Boat Type
    4. Model Number
    5. MSRP
    6. Down Payment (Use a formula to calculate a cash down payment of 10% of the MSRP.)
    7. Loan Amount (Use a formula to calculate the remaining amount to be financed.)
    8. Annual Interest Rate (Use the value of 4.5% for all rows.)
    9. Term in Years (Use the value of 10 for all rows.)
    10. Monthly Payment – Use the proper financial function to calculate the monthly payment.
  6. Apply a Table Style of your choice other than the default.
  7. Sort the table by descending MSRP.
  8. Merge and center the title in the first row over the table columns in the second row.
  9. Change the Font Size of the title to 24 pt.
  10. Apply a Fill Color of your choice, other than the default, to the title cell.
  11. Two rows below the table, enter the following Row Labels in Column A and perform the calculations using functions in corresponding cells of Column B:
    1. Minimum MSRP
    2. Maximum MSRP
    3. Average MSRP
  12. Add your name, your MEID, and your course and section number in the Footer.
  13. Set the Page Orientation to Landscape.
  14. Scale the worksheet to print on a single page.
  15. Insert a Clustered Column Chart that includes the Model Number and the MSRP of each boat.
  16. Move the chart to a new sheet named MSRP Chart.

MSRP Chart

The Rio Salado Boat and Marine Dealership wants a visual depiction of the range of MSRPs for its inventory of boats.

  1. With the MSRP Chart worksheet active, assign the worksheet tab a color of your choice other than the default.
  2. Select a Chart Style of your choice other than the default.
  3. Insert a descriptive Chart Title.
  4. Add horizontal and vertical Axis Titles with descriptive text.
  5. Add Data Labels.
  6. Add your name, your MEID, and your course and section number in the Footer.

Required Worksheets

Arrange the worksheets in the following order:

  1. Information
  2. Financing
  3. MSRP Chart

Save and close your BoatWorkbook_MEID.xlsx file.

———————————————————————————————————————————————-

Part 3 – Microsoft Word 2019

Use Word to create a professional-looking flyer to alert customers about the upcoming sales promotion for the Rio Salado Boat and Marine Dealership.

  1. Create a new blank Word document. Do not use a template.
  2. Save the file as BoatDocument_MEID.docx. Be sure to replace “MEID” in the filename with your actual MEID.

Document Editing 

  1. Design a flyer from scratch. The flyer will contain information about the sale of available inventory:
    1. Choose a Theme other than the Office default.
    2. Include a Page Border.
  2. Use the dealership information from the Information worksheet of the BoatWorkbook_MEID.xlsx file that you created in Part 2, to design a letterhead:
    1. First line: Dealership Name
    2. Second line: Street Address
    3. Third line: City, State and Zip Code
    4. Fourth line: Phone Number
  3. Apply the following formatting to highlight the letterhead:
    1. Heading style
    2. Center alignment
    3. Paragraph border
    4. Paragraph shading of your choice other than the default
  4. Insert a minimum of 50 words of text announcing the sale of available inventory:
    1. Use your Course End Date as the date of the sale.
    2. Use your name as the contact person.
  5. Use each of the following features to make your flyer eye-catching by applying formatting to the text:
    1. At least one instance of a change of Font Size and Font Color.
    2. Insert at least one instance of WordArt text.
  6. Insert at least one Shape with a Fill Color of your choice, other than the default, and use the Sales Promotion Title from the Information worksheet of the BoatWorkbook_MEID.xlsx file that you created in Part 2 as the text.
  7. From the Financing worksheet of the BoatWorkbook_MEID.xlsx file that you created in Part 2, Copy as Picture the title and table and paste the picture into your flyer:
    1. Apply Text Wrapping for visual appeal.
    2. Apply a Picture Style of your choice other than the default.
  8. Reposition or resize flyer elements so that the entire flyer fits on one page.
  9. Insert a Watermark indicating that your design is a Sample.
  10. Check Spelling & Grammar.
  11. Create a Footer with your name, your MEID, and your course and section numbers.

Save and close your BoatDocument_MEID.docx file.

———————————————————————————————————————————————-

Part 4 – Microsoft PowerPoint 2019

Use PowerPoint to create a presentation that will run continuously on the boat dealership kiosk to announce the upcoming sales promotion.

  1. Create a new blank PowerPoint presentation.
  2. Save the file as BoatPresentation_MEID.pptx. Be sure to replace “MEID” in the filename with your actual MEID.

Presentation Editing 

  1. Apply a theme to the presentation other than the Office default.
  2. On the Title Slide enter the name of the boat dealership (Rio Salado Boat and Marine) as the title and the Sales Promotion Title from the Information worksheet of the BoatWorkbook_MEID.xlsx file that you created in Part 2 as the subtitle.
  3. Create three additional slides with appropriate slide layouts to showcase the available inventory:
    1. Select one of the boats from the Financing worksheet of the BoatWorkbook_MEID.xlsx file that you created in Part 2 and insert an image of the boat onto the slide.
    2. Use the Manufacturer and Model Number of the boat as the slide title.
    3. Use the Boat Type and MSRP of the boat as a caption.
    4. Repeat Steps a. through c. for the two other showcase slides.
  4. Insert a new slide with an appropriate slide layout for testimonials from three customers who have purchased boats from the boat dealership:
    1. Use “Testimonials from Previous Customers” as the slide title.
    2. Make up a quote for each of the three customers concerning their experiences with their purchases.
    3. Make up the customers’ names and list the name below each quote; however, use your nameas one of the customers.
  5. Insert a new slide with an appropriate slide layout with a title of “Rio Salado Boat and Marine Family of Employees” and insert an image of the boat dealership employees.
  6. Insert a new slide with an appropriate slide layout and add the list of References used for research during the creation of all content in the Final Project. You are required to use APA style formatting for any website or other source from which you retrieved images or data. At a minimum, you must include individual references for the four images used in your PowerPoint presentation.
  7. Apply a transition between all slides.
  8. Apply an animation to the images on each slide so they enter when the slides change.
  9. In the Notes pane of each slide:
    1. Identify the Slide Layout.
    2. Explain why you felt the slide layout was appropriate for the slide content.
  10. In the Notes Master View:
    1. Add your name and MEID to the header of the presentation.
    2. Add your Course and Section Numbers to the footer of the presentation.
  11. Make sure that you Set Up the slide show to run continuously on the boat dealership kiosk.
  12. You should have a total of seven slides.

Save and close your BoatPresentation_MEID.pptx file.