i;

The goal of this project is to demonstrate your ability to use common applications to communicate and store information. You will use your IoT design and plan for this assignment. Now that you have learned how to use email, web browsers, and productivity software, you can start to apply those skills.

1. First, you will use Microsoft Word to create a professional proposal document that is intended for some potential investors of your idea. It will need to be a comprehensive report using various formatting and styles. It should have clearly defined sections, images, and supporting tables and charts with data (fictional but realistic) regarding cost and other considerations. Apply as many of the concepts you learned in the tutorials as are reasonable to make this proposal look and feel professional.
2. Next, you will use Microsoft Excel to continue the proposal by created spreadsheets with formulas and formatting to enhance the proposal. Whatever data you wish to invent and provide, there must be actual formulas used to calculate in the spreadsheet. You must also have both absolute and relative cell references, and at least one function. You will need to be sure to reference the spreadsheet in your proposal as an attachment or appendix. Remember this is part of a professional package that is intended for your investors! Make it look polished!
3. Then, you will create a Microsoft PowerPoint presentation that gives a solid overview of your proposal and spreadsheets. There should be charts and tables derived from your Excel spreadsheet data, as well as information and images relating to your Word document inserted into the presentation. You must also apply themes, animations, and transitions to your work.
4. Once your three artifacts are complete, reviewed, and polished, you will create a single folder in your OneDrive titled Module 3 Artifacts to store these items and upload them there.
   1. Create a shared link to this folder.  Your link MUST be accessible.  The permissions must be set to “anyone with a link can view.”  This is one-third of your score for this assignment.
   2. Draft an “email to your investors” (me). In a professional, business-like tone, you will ask them to review your documents via the link consider your proposal in so many words. DO NOT COPY the previous sentence and assume that is enough for the body of the email.  Your email must contain the link to your files!
   3. Attach a copy of your three artifacts and the email in the project submission link above.

Excel_Introductory_Capstone1_Year_End_Report

In this project, you will work with multiple worksheets and enter formulas and functions to calculate totals, averages, maximum values, and minimum values. Additionally, you will create a summary sheet, format cells, insert charts, insert sparklines, and create a table in a workbook.

1

Open the Excel file Student_Excel_Intro_Cap1_Year_End_Report.xlsx   downloaded with this project.

2

On the Net Sales worksheet,   calculate totals in the ranges F4:F8 and B9:F9. Apply the Total cell style to   the range B9:F9.

3

Using absolute cell references   as necessary, in cell G4, construct a formula to calculate the percent that   the Colorado Total is of Total Sales, and then apply Percent Style with zero   decimals. Fill the formula down through the range G5:G8.

4

In the range H4:H8, insert Line   sparklines to represent the trend of each state across the four quarters. Do   not include the totals. Display Markers.

5

Select the range A3:E8, and then   use the Recommended Charts command to suggest an appropriate chart. Click the   first Clustered Column chart that uses the state names as the category axis.   Align the upper left corner of the chart inside the upper left corner of cell   A11, and then size the chart so that its lower right corner is slightly   inside cell H24. Apply chart Style 7. As the chart title, type Quarterly Net   Sales by State.

6

To show the percent that each   state contributes to the total sales, select the nonadjacent ranges that   represent the state names and state totals. Insert a 3-D Pie chart, and then   move the chart to a New sheet. Name the sheet Net Sales by State.

7

Change the Chart Title to   and then   change the chart title Font Size to 36. Remove the Legend from the chart, and   then add Data Labels that display only the Category Name and Percentage   positioned in the Center. Change the data labels Font Size to 14 and apply   Bold and Italic. Change the Font color to White, Background 1.

8

Select the entire pie and   display the Format Data Series pane. From the 3-D Format gallery, modify the   3-D options by changing the Top bevel and Bottom bevel to first bevel in the   first row. Set all of the Width and Height boxes to 512 and then change the   Material to the third Standard type—Plastic.

9

Insert a Custom Footer with the   File name in the left section and then save your workbook.

10

On the Seattle Inventory   worksheet, in cell B5, enter a function that will display the average retail   price. In cell B6, enter a function that will display the median retail   price. In cell B7, enter a function that will calculate the lowest retail   price. In cell B8, enter a function that will calculate the highest retail   price. Format the range B5:B8 with Accounting Number Format.

11

In cell B10, insert a COUNTIF   function that counts the number of Skiing items in the Sport column.

12

On the Seattle Inventory   worksheet, in cell G14, enter an IF function to determine the items to be   ordered. If the Quantity in Stock is less than 50, then the cell should display Order. If not, then the cell should   display OK.   Copy the function down through cell G19.

13

Format the range A13:G19 as a   table with headers. Filter the table on the Sport column to display only the   Skiing types. Display a Total Row in the table, and then sum the Quantity in   Stock for Skiing items. Type the result in cell B11. Remove the total row   from the table and then clear the Sport filter.

14

Add Gradient Fill Blue Data Bars   to the range A14:A19. Add conditional formatting to the range G14:G19 so that   the cells with text that contain the word Order are formatted with Bold and Italic. Sort the table   by Item # from Smallest to Largest.

15

Display the Inventory Summary   sheet. In cell B4, enter a formula that references cell B4 in the Seattle   Inventory sheet so that the Seattle Total Items in Stock displays in cell B4.   In cell B5, enter a formula that references cell B5 in the Seattle Inventory   sheet so that the Seattle Average Price displays in cell B5. In cells B6, B7,   and B8, enter similar formulas to reference the Median Price, Lowest Price,   and Highest price in the Seattle Inventory sheet.

16

In cell C4, enter a formula that   references cell B4 in the Denver Inventory sheet so that the Denver Total   Items in Stock displays in cell C4. In cells C5, C6, C7, and C8, enter   similar formulas to reference the Average Price, Median Price, Lowest Price,   and Highest price in the Denver Inventory sheet. Apply Accounting Number   format to the range B5:C8.
 

17

On the Annual Expenses sheet,   construct formulas to calculate Totals by Quarter in the range B10:E10 and   the Annual Totals in the range F5:F10. Apply the Total cell style to the   Totals by Quarter (B10:F10), and then center the column headings (B4:G4) and   apply the Heading 4 cell style.

18

Using absolute cell references   as necessary, in cell G5, construct a formula to calculate the % of Total by   dividing the Sales Expense Annual Total by the Annual Totals by Quarter. Fill   the formula down through the range G6:G9.

19

Using the data in the   nonadjacent ranges B4:E4 and B10:E10, insert a Line with Markers chart.   Position the upper left corner of the chart slightly inside the upper left   corner of cell A12. Change the height of the chart to 1.75 inches and the width of the   chart to 8   inches.
 

  Note, Mac users, change the height of the chart to 1.5 inches.

20

Apply chart Style 7. Change the   chart title to Direct Expenses. Edit the Vertical (Value) Axis so that the   Minimum is 8000000 and the Major unit is 1000000.

21

Use Format Painter to copy the   formatting from cell A2 to A20. In cell B23, enter a formula that references   the value in cell F10.

22

Using absolute cell references   as necessary, in cell C23, construct a formula to calculate the projected   expenses for 2020 after the Forecasted increase in cell B21 is applied. Fill   the formula through cell F23.

23

Display the Sales Reps sheet. By   using Flash Fill and deleting columns as necessary, place the last names in   column A and the first names in column B. Widen both columns to 100 pixels,   and then merge and center the title Sales Reps across the two columns. Apply   the Heading 1 cell style to the title.
 

24

With any sheet except the chart   sheet active, group the worksheets. Change the Orientation to Landscape,   center the worksheets Horizontally, and insert a footer in the left section   with the file name. (Mac users, click the Net Sales sheet, hold down SHIFT,   and then click the Sales Reps sheet. Then apply the Page Layout options.)

25

Save and close the file and   submit for grading.

It is important to have the client’s meet the contractors. The chatroom is a good inclusion to the website because it will facilitate interaction and place users in a virtual marketplace that simulates the experience in a real life market with bids and offers. I used to like this site when the buyer could meet the seller without the mediator. I hope you can recreate that in the project I sent last time by adding to the list everyone at all the universities I have uploaded in the website database. But that is only after you have reviewed the list of students on the Capella University student list, My UALR student list, and APUS student list. I will later add Columbia College and Central Texas College student list later after you have reviewed the project attached. See previous question.

One more thing. This is for anyone that has sent a bid, and cannot get through to me. Let me know if you can “hangout” with google. I have sent a message to any applicant and bidder. Check your messages. 

This is from Dr. Michelle_KM, so anyone can use it if they want.

Project 3: Support Queue Case Study Instructions For this project, you will apply the CompTIA 6-Step Troubleshooting Process to explain how you would tackle Hudson Fisher Associates Help Desk Tickets. There are three groups of tickets, Level 1, Level 2, and Level 3. You will pick two tickets from each group. As you prepare to analyze and hopefully

Project 3: Support Queue Case Study
Instructions
For this project, you will apply the CompTIA 6-Step Troubleshooting Process to explain how you would tackle Hudson Fisher Associates Help Desk Tickets. There are three groups of tickets, Level 1, Level 2, and Level 3. You will pick two tickets from each group.
As you prepare to analyze and hopefully solve these typical IT help desk tickets, keep in mind that for this course, it is more about the process and less about finding the “correct” answer. You may not always find an exact answer from the information given. The problems are structured to approximate what you will find in the workplace. Use a logical and repeatable process (e.g., the CompTIA 6-Step Troubleshooting Process) and eliminate the improbable as you work your way through each scenario.
CompTIA 6-Step Troubleshooting Process:
1. Identify the problem.
2. Establish a theory of probable cause.
3. Evaluate the theory to determine the actual cause.
4. Establish a plan of action to resolve the problem and implement the solution.
5. Verify full system functionality and if applicable implement preventative measures.
6. Document findings, actions, and outcomes.
How Will My Work Be Evaluated?
As you progress in your information technology and cybersecurity career, you may find yourself making presentations to customers, client audiences, and management. For this assignment, you should articulate your findings from the six support cases.
But the challenge you face is in expressing a technical solution to a nontechnical audience. Avoid jargon and acronyms. Find a way to relay your solution (and challenges) in language that your audience will find easily relatable.
Communicating in this manner will not always be easy. You may struggle to find the right analogy or metaphor. But if you can master the skill of summarizing your results and recommendations to management in an effective presentation, you will demonstrate how you use your technical knowledge to convey your ideas to others in a professional setting. You will also earn the respect and trust of your peers, your supervisor, and upper management as an effective communicator. You will be viewed as an employee ready for advancement.
The following evaluation criteria aligned to the competencies will be used to grade your assignment:
• 1.1.1: Articulate the main idea and purpose of a communication.
• 1.1.3: Present ideas in a clear, logical order appropriate to the task.
• 1.3.3: Integrate appropriate credible sources to illustrate and validate ideas.
• 2.1.1: Identify the issue or problem under consideration.
• 2.3.1: State conclusions or solutions clearly and precisely.
• 12.7.2: Explain the process of analyzing IT incidents.
• 13.1.1: Create documentation appropriate to the stakeholder.
Your deliverable for the project is an annotated PowerPoint Presentation covering the following:
• List of the six tickets you selected (two each from Level 1, Level 2, and Level 3)
• One to two slides for each ticket, in which you:
o State the problem.
o Describe the steps taken to troubleshoot/analyze the problem.
o Propose a brief resolution.
• One summary slide: What did you find challenging or interesting about one or two of the support cases (opinion-based)?
• One reference slide (two to six IEEE references). Include references for materials you consulted in TestOut or on the internet.
If you haven’t already done it last week, download the Support Queue Case Study Presentation Template to get started.
Delete the instructional text from the template before you submit.
When you are finished, click “add a file” to upload your work, then click the Submit button

 Provide at least three (3) best practices when creating methods in C# and explain why they are “best”. 

300 words

Must be done using Java. Output must be the same as output in the assignment.

 Discuss the potential biases that may exist in different public health datasets. Feel free to focus on specific datasets or types of data that you are familiar with, but you can also consider the following types of data:

• Infectious disease data from public schools
• Fall data from nursing homes
• Opioid overdose data from first responder reports
• Genetic risk profiles from rural regions in developing countries

Instructions:

1. Your discussion should include the types of explicit and implicit biases that may be in the data, as well as how both sampling and reporting biases may play a role in the data creation process
2. Finally, describe the ideal process for creating the data (as unrealistic and infeasible as it may well be), and
3. Identify steps to creating a feasible dataset on the topic that either reduces biases as much as possible or at least would allow public health experts to better understand the limitations of the data

Include references

 Respond to the discussion about algorithms and their roles below using 150 words or more. 

At  the most basic level, an algorithm is simply a set of step-by-step  instructions that we utilize to accomplish a specific task. We use  algorithms every single day in our day-to-day activities: Brushing our  teeth, getting dressed, driving to work, making dinner. These daily  tasks which we complete are all composed of a set of instructions that  starts with a certain action and ends with a certain action.

In  the realm of computer programming, algorithms are utilized to enhance  the efficiency, effectiveness, and functionality of the programs we  create. Two such types of algorithms are searching algorithms and  sorting algorithms.

Sorting  algorithms are designed to sort an array of objects into a specific  order. Searching algorithms are designed to compare the elements of an  array to find a particular value within an array of objects. Just a few  examples are search engines, the sorting of a business’ online item  inventory, and sorting/searching a database of students who attend a  university.

There  are multiple approaches which people have taken to solve the issue of  sorting and searching an array of items. Two frequently used searching  algorithms are linear search and binary search. Three frequently used  sorting algorithms are insertion sort, selection sort, and bubble sort.

Each  of these types of algorithms have both pros and cons associated with  them. The main properties that we want to keep an eye on when choosing  an algorithm are memory usage, maintainability, and time complexity. It  is always best to assess the situation and to use discretion when  choosing which algorithm that we want to implement into our program.