Monthly Archives: June 2023

Topic: 5G Vehicular Network Resource Management for Improving Radio Access Through Machine Learning

Instructions:  It should be of professional quality and be in the format of an IEEE transaction style. Figures must be clear and drawn by you.  Proper citation of references must be embedded in the term paper. All term report should be printed in 8.5x11in format, 10 size, time new roman font, two-column, about 8 pages, left, right, top, bottom margin 1 inch, and contain the following:

1. Title page.
2. Abstract (summary of the paper).
3. Introduction (problem motivation, background materials, related work, summary of objectives and methods).
4. (i) Description of existing algorithms/protocols for survey papers; (ii) system model, assumptions, and/or formal problem formulation for research-oriented papers.
5. (i) Comparison among existing algorithms/protocols and discussion on possible improvements/enhancements;      (ii) project results (derivation, proof, justification, or detailed design/simulation) in one or more numbered sections for research-oriented      papers.
6. Conclusions (evaluation of results, suggestions for improvements, or future work).
7. References must follow IEEE Transactions format (at least 10 references).Proper citation of references must be embedded in the term paper.
8. Appendices (if appropriate).
9. In particular, references used must be clearly cited in your written report at proper locations  

Sample document is attached….

 SC_EX365_2021_CS1-3b_FirstLastName_1

· Open the file SC_EX365_2021_CS1-3b_FirstLastName_1.xlsx, available for download.

· Save the file SC_EX365_2021_CS1-3b_FirstLastName_1.xlsx as SC_EX365_2021_CS1-3b_FirstLastName_2.xlsx 

o Edit the file name by changing “1” to “2”.

o If you do not see the .xlsx file extension, do not type it. The file extension will be added for you automatically.

· With the file SC_EX365_2021_CS1-3b_FirstLastName_2.xlsx open, ensure that your first and last name is displayed in cell B6 of the Documentation worksheet. 

o If cell B6 does not display your name, delete the file and download a new copy.

PROJECT STEPS

1. Liang Bandy is a senior project manager at Forward Construction, a firm that works on construction projects for business and commercial buildings. Liang has created a workbook summarizing the Office Plaza Construction project for the Meadowood Office Center. She asks for your help in completing the workbook.
Go to the Budget worksheet. Unfreeze the panes since Liang does not need to display those rows as she scrolls the worksheet.

2. In cell K2, enter a formula using the NOW function to display today’s date. Apply the Short Date number format to display only the date in the cell.

3. Format the worksheet title as follows to use a consistent design throughout the workbook:

a. Fill cell C2 with the Teal, Accent 6, Lighter 40% shading color.

b. Change the font color to White, Background 1.

c. Merge and center the contents of cell C2 across the range C2:I2.

d. Use AutoFit to resize row 2 to its best fit.

4. Format the hourly rate data as follows to suit the design of the worksheet and make the data easier to understand:

a. Italicize the contents of cell L2 to match the formatting in cell J2.

b. Apply the Currency number format to cell M2 to clarify that it contains a dollar amount. 

5. Format the data in cell B4 as follows to display all of the text:

a. Merge the cells in the range B4:B14.

b. Rotate the text up in the merged cell so that the text reads from bottom to top.

c. Middle-align and center the text.

d. Remove the border from the merged cell.

e. Resize column B to a width of 6.00.

6. Format the data in row 4 as follows to show that it contains column headings:

a. Change “Description” to use Code Description as the complete column heading.

b. Apply the Accent 6 cell style to the range C4:I4.

c. Use AutoFit to resize column E to its best fit.

7. In column F, Liang wants to include the actual dollar amount of the work completed. Enter this information as follows:

a. In cell F5, enter a formula without using a function that multiplies the completed hours (cell E5) by the hourly rate (cell M2) to determine the dollar amount charged for blueprint drafting. Include an absolute reference to cell M2 in the formula.

b. Use the Fill Handle to fill the range F6:F14 with the formula in cell F5 to include the charges for the other work.

c. Format the range F6:F14 using the Comma Style format and no decimal places to match the formatting in column G.

8. Liang needs to show how much of the estimate remains after the completed work. Provide this information as follows:

a. In cell H5, enter a formula without using a function that subtracts the completed amount billed (cell F5) from the estimated amount (cell G5) to determine the remaining amount of the estimate for blueprint drafting.

b. Use the Fill Handle to fill the range H6:H14 with the formula in cell H5 to include the remaining amount for the other work.

c. Format the range H6:H14 using the Comma Style format and no decimal places to match the formatting in column G.

9. Liang also wants to show the remaining amount as a percentage of the completed amount. Enter this information as follows:

a. In cell I5, enter a formula that divides the remaining dollar amount (cell H5) by the estimated dollar amount (cell G5).

b. Copy the formula in cell I5 to the range I6:I15, pasting only the formula and number formatting to display the remaining amount as a percentage of the actual amount for the other work and the total.

10. Calculate the totals as follows:

a. In cell E15, enter a formula using the SUM function to total the actual hours (range E5:E14).

b. Use the Fill Handle to fill the range F15:H15 with the formula in cell E15.

c. Apply the Accounting number format with no decimal places to the range F15:H15.

11. Liang also wants to identify the work for which Forward Construction has billed more than the full estimate amount.
In the range I5:I14, use conditional formatting Highlight Cells rules to format values less than 1% (0.01) in Light Red Fill with Dark Red Text. 

12. Liang imported data about the project team working on the Office Plaza Construction project and stored the data on a separate worksheet, but wants to include the data in the Budget worksheet. Copy and paste the data as follows:

a. Go to the Project Team worksheet and copy the data in the range B2:G13.

b. Return to the Budget worksheet. Paste the data in cell K3, keeping the source formatting when you paste it.

13. Liang needs to list the position for each team member. Those with five or more years of experience have a Senior position. Otherwise, they have Support position. List this information as follows:

a. In cell O5 on the Budget worksheet, enter a formula that uses the IF function to test whether the number of years of experience (cell N5) is greater than or equal to 5.

b. If the team member has five or more years of experience, display “Senior” in cell O5.

c. If the team member has less than five years of experience, display “Support” in cell O5.

d. Copy the formula in cell O5 to the range O6:O14, pasting the formula only.

e. Use AutoFit to resize column O to its best fit.

14. Liang wants to include summary statistics about the project and the team members. Include this information as follows:
In cell E17, enter a formula that uses the AVERAGE function to average the number of years of experience (range N5:N14).

15. Make the Line chart in the range C19:I33 easier to interpret as follows:

a. Change the chart type to a Clustered Column chart.

b. Enter Task Progress as the chart title.

c. Add a primary vertical axis title to the chart, entering Hours as the axis title text.

d. Add data labels to the Outside End of each column.

16. Delete row 35 since Liang has adjusted the chart.

17. Go to the Schedule worksheet. Rename the Schedule worksheet tab to Work Schedule to use a more descriptive name.

18. Each type of work starts on a different date because the types depend on each other. Enter the starting dates for the remaining work as follows:

a. In cell D6, enter a formula without using a function that adds 1 day to the value in cell C6.

b. In cell E6, enter a formula without using a function that adds 2 days from the value in cell C6.

c. In cell F6, enter a formula without using a function that adds 3 days to the value in cell C6.

d. In cell G6, enter a formula without using a function that adds 3 days to the value in cell C6.
[Mac Hint: The date will display in the format m/d/yy.]

19. Copy the formulas for inspections to the rest of the schedule as follows:

a. Copy the formula in cell D6 to the range D7:D8.

b. Copy the formula in cell E6 to the range E7:E8.

c. Copy the formula in cell F6 to the range F7:F8.

d. Copy the formula in cell G6 to the range G7:G8.

20. In cell C9, enter a formula that uses the MIN function to find the earliest date in the project schedule (range C6:G8).

21. In cell C10, enter a formula that uses the MAX function to find the latest date in the project schedule (range C6:G8).

Discussion 2.1

What is the Gramm-Leach-Bliley Act?  Can you find any cases that have dealt with this Act?  

Discussion 2.2

What are the Payment Card Industry Standards?  Provide an example of why these standards were developed.

Case Study 2.1

Case Study:Conduct research on the Internet or select 1 of the 2 examples in your text in Chapter 4, page 117 on a credit card breach. Write a 3 to 4 page paper (Not including title and reference page) in which describe the details of the event. Tell us what could done to prevent the event from happening, list the laws that were broken and if the event violated any of the acts or laws that you read about in chapters 3 & 4. You paper should be in APA format and contain 3 to 4 different sources. Make sure you cite all sources.Writing Requirements

• 3–4 pages in length  (excluding cover page, abstract, and reference list)
• At least 3-4 peer reviewed sources that are properly cited and referenced
• APA format, Use the APA template located in the Student Resource Center to complete the assignment.
• Please use the Case Study Guide as a reference point for writing your case study.

Search the peer-reviewed literature  for examples of this. You may select any topic relating to technology that illustrates the potential for really messing things up. Include, in your description, an analysis of what might have caused the problems and potential solutions to them. 

Be sure to provide supporting evidence, with citations from the literature 

Should be more than 350 words

For this portion of your project, you will perform a model development on your dataset, following these step:

1. Using your chosen dataset, reevaluate the heat map from the last module.
2. Consider ways to perform a visual check to see if there is a relationship between fields.
3. With this insight, develop a model using either linear regression or multiple linear regression.
4. Report the intercepts, slope, model accuracy, output to predicted comparison, and a scatterplot with line portraying the model.

Once you complete these steps, you will need to provide a Word document showing and explaining the results of your model development. This assignment is due by 11:59 PM CT on Sunday.

Imagine you run a small business that handles sensitive data for its clients. Such a company might handle payroll for other companies or some other task that requires a great deal of data security. Because you transmit important information (employee data, account numbers, invoices, and the like), you decide it is a good idea to use encryption, to digitally sign e-mail messages, and to have a digital certificate. Visit the websites of certificate authorities. In your web research, determine how much it will cost your company to acquire a digital certificate and the kinds of information you must provide to the certificate authority. 

  Exp19_PowerPoint_Ch02_ML1_Duarte

Bank Churners Project. Appreciate fast response. I will give the detailed requirement on this via PM. Thank you.  

Subject: Cloud computing

For this project, select an organization that has leveraged Cloud Computing technologies in an attempt to improve profitability or to give them a competitive advantage.  Research the organization to understand the challenges that they faced and how they intended to use Cloud Computing to overcome their challenges.  The paper should include the following sections each called out with a header.

• Company Overview:  The section should include the company name, the industry they are in and a general overview of the organization.
• Challenges: Discuss the challenges the organization had that limited their profitability and/or competitiveness and how they planned to leverage Cloud Computing to overcome their challenges.
• Solution:  Describe the organization’s Cloud Computing implementation and the benefits they realized from the implementation.  What was the result of implementing Cloud Computing?  Did they meet their objectives for fall short?
• Conclusion:  Summarize the most important ideas from the paper and also make recommendations or how they might have achieved even greater success.

Requirements:

The paper must adhere to APA guidelines including Title and Reference pages.  There should be at least three scholarly sources listed on the reference page.  Each source should be cited in the body of the paper to give credit where due.  Per APA, the paper should use a 12-point Time New Roman font, should be double spaced throughout, and the first sentence of each paragraph should be indented .5 inches.  The body of the paper should be 5 – 8 pages in length.  The Title and Reference pages do not count towards the page count requirements.