follow the instruction in the attached file.

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.

Describe in 500 words the shared security responsibility model that a dba must be aware of  when moving to the cloud.

Use at least three sources. Use the Research Databases available from the Danforth Library not Google. Include at least 3 quotes from your sources enclosed in quotation marks and cited in-line by reference to your reference list.  Example: “words you copied” (citation) These quotes should be one full sentence not altered or paraphrased. Cite your sources using APA format. Use the quotes in your paragaphs.  Stand alone quotes will not count toward the 3 required quotes.

need help with a question

Discussion 3.1

What is Python?  What are some of the attributes of Python?  Why is Python preferred over some other languages? 

Discussion 3.2 

You can use python for many reasons, what are some of the uses of Python outside of academia?  

Discussion 3.3

What did you learn during this week in regards to Python?  

Case Study 3.1

Using google scholar to find an article about Python3 and tell the class about what the article says, giving your personal views on the article and what it has to say about Python3. Remember to deploy your personal views into the case study not just what the article has to say. Remember, the below instructions about peer-reviewed material.Writing Requirements

• 3–4 pages in length  (excluding cover page, abstract, and reference list)
• Include at least 2-3 peer-reviewed sources that are properly cited
• 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.

describe how federated identity management will impact the processes behind identifying end users. APA format 300 words You must use at least two scholarly resource.must be properly APA formatted.

Do some basic searching  on security certifications.

See https://www.giac.org/.

Write  a text of certifications that are open. 

Consider if any of the certifications would be valuable for your career.

Investigate and describe on options.

 Dynamic Array of Strings  
One problem with dynamic arrays is that once the array is created using the new operator the size cannot be changed. For example, you might want to add or delete entries from the array similar to the behavior of a vector. This project asks you to create a class called DynamicStringArray that includes member functions that allow it to emulate the behavior of a vector of strings.
The class should have:
A private member variable called dynamicArray that references a dynamic array of type string.
A private member variable called size that holds the number of entries in the array.
A default constructor that sets the dynamic array to NULL and sets size to 0.
A function that returns size.
A function named addEntry that takes a string as input. The function should create a new dynamic array one element larger than dynamicArray, copy all elements from dynamicArray into the new array, add the new string onto the end of the new array, increment size, delete the old dynamicArray, and then set dynamicArray to the new array.
A function named deleteEntry that takes a string as input. The function should search dynamicArray for the string. If not found, return false. If found, create a new dynamic array one element smaller than dynamicArray. Copy all elements except the input string into the new array, delete dynamicArray, decrement size, and return true.
A function named getEntry that takes an integer as input and returns the string at that index in dynamicArray. Return “” string if the index is out of dynamicArray’s bounds.
Overload the operator[] so that you can get and change an element by an index integer. If the index is out-of-bounds, return a “” string.
A copy constructor that makes a copy of the input object’s dynamic array.
Overload the assignment operator so that the dynamic array is properly copied to the target object.
A destructor that frees up the memory allocated to the dynamic array.
Create a suitable test program to test your class.
You should name the project ASG10. When you zip up the project folder, ASG10, include all the files (.sln, .cpp, etc) and subdirectories (Debug, etc.).
 

Exp19_Excel_Ch09_CapAssessment_Tips

Project Description:

Let me know for reasonable price

Your friend Kimo is a server at a restaurant. He downloaded data for his customers’ food and beverage purchases for the week. You will complete the workbook by applying consistent formatting across the worksheets and finalizing the weekly summary. The restaurant requires tip sharing, so you will calculate how much he will share with the beverage worker and the assistant.     

Start   Excel. Download and open the file named Exp19_Excel_Ch09_Cap_Assessment_Tips.xlsx.   Grader has automatically added your last name to the beginning of the   filename.
 

  The Excel workbook contains circular references. When you open the file, an   error message displays. This error will be resolved as part of the project

The   Tip Left column in the Friday worksheet contains a fill color and number   formatting. You want to fill these formats to the other daily worksheets.
 

  Group the Friday through Monday worksheets, staring with the Friday   worksheet. Fill the format only for the range E5:E24.

Now   you want to insert column totals for the five worksheets simultaneously.
 

  With the worksheets still grouped, insert SUM functions in the range B25:E25   and apply the Totals cell style. Ungroup the worksheets.

The   Week worksheet is designed to be a summary sheet. You want to insert a   hyperlink to the Total heading in the Monday worksheet.
 

  On the Week worksheet, in cell A5, insert a hyperlink to cell A25 in the   Monday worksheet with the ScreenTip text Monday’s Totals. Test the hyperlink to   ensure it works correctly.

In   cell A6 on the Week worksheet, insert a hyperlink to cell A25 in the Tuesday   worksheet with the ScreenTip text Tuesday’s Totals. Test the hyperlink to   ensure it works correctly.

In   cell A7, insert a hyperlink to cell A25 in the Wednesday worksheet with the   ScreenTip text Wednesday’s Totals. Test the hyperlink to ensure it works   correctly.

In   cell A8, insert a hyperlink to cell A25 in the Thursday worksheet with the   ScreenTip text Thursday’s Totals. Test the hyperlink to ensure it works   correctly.

In   cell A9, insert a hyperlink to cell A25 in the Friday worksheet with the   ScreenTip text Friday’s Totals. Test the hyperlink to ensure it works   correctly.

Now,   you are ready to insert references to cells in the individual worksheets.   First, you will insert a reference to Monday’s Food Total.
 

  In cell B5 on the Week worksheet, insert a formula with a 3-D reference to   cell B25 in the Monday worksheet. Copy the formula to the range C5:E5.

The   next formula will display the totals for Tuesday.
 

  In cell B6, insert a formula with a 3-D reference to cell B25 in the Tuesday   worksheet. Copy the formula to the range C6:E6.

In   cell B7, insert a formula with a 3-D reference to cell B25 in the Wednesday   worksheet. Copy the formula to the range C7:E7.

In   cell B8, insert a formula with a 3-D reference to cell B25 in the Thursday   worksheet. Copy the formula to the range C8:E8.

In   cell B9, insert a formula with a 3-D reference to cell B25 in the Friday   worksheet. Copy the formula to the range C9:E9.

Now   you want to use a function with a 3-D reference to calculate the totals.
 

  In cell B10 on the Week worksheet, insert the SUM function with a 3-D   reference to calculate the total Food purchases (cell B25) for the five days.   Copy the function to the range C10:E10.

The   servers are required to share a portion of their tips with the Beverage   Worker and Assistants. The rates are stored in another file.
 

  Open the Exp_Excel_Ch09_Cap_Assessment_Rates.xlsx   workbook. Go back to the Exp_Excel_Ch09_Cap_Assessment_Tips.xlsx   workbook. In cell F5 of the Week worksheet, insert a link to the Beverage   Worker Tip Rate (cell C4 in the Rates workbook) and multiply the rate by the   Monday Drinks (cell C5). Copy the formula to the range F6:F9.

Next,   you will calculate the tips for the assistant.
 

  In cell G5 in the Tips workbook, insert a link to the Assistant Tip Rate   (cell C5 in the Rates workbook) and multiply the rate by the Monday Subtotal   (cell D5). Copy the formula to the range G6:G9. Close the Rates workbook.
 

  Note: The tip is a monetary value in the Week worksheet. It should be   formatted for Accounting Number Format.

You   noticed a circular error when you first opened the Tips workbook. Now you   will find and correct it.
 

  On the Week worksheet, check for errors and correct the formula with the   circular reference. 

You   want to create a validation rule to prevent the user from accidentally   entering a negative value. For now, you will create a validation in the   Friday worksheet.
 

  Select the range E5:E24 in the Friday worksheet, create a validation rule to   allow a decimal value greater than or equal to zero. Enter the input message   title Tip and   the input message Enter the amount of tip. (including the   period). Use the Stop alert with the error alert title Invalid Number and the error   alert message   The tip must be zero or more. (including the period). Test the   data validation by attempting to enter -20 in cell E5 and then cancel the change.

Now   you will copy the validation settings to the other daily worksheets.
 

  Copy the range E5:E24 in the Friday worksheet. Group the Monday through   Thursday worksheets, select the range E5:E24, and use Paste Special   Validation to copy the validation settings.

You   want to unlock data-entry cells so that the user can change the tips in the   daily worksheets.
 

  Group the Monday through Friday worksheets. Select the ranges E5:E24 and   unlock these cells.

Create   footer with your name on the left side, the sheet name code in the center,   and the file name code on the right side of all worksheets.

Now   that you unlocked data-entry cells, you are ready to protect the worksheets   to prevent users from changing data in other cells. Individually, protect   each sheet using the default allowances without a password.

Mark   the workbook as final.
 

  Note: Mark as Final is not available in Excel for Mac. Instead, use Always   Open Read-Only on the Review tab.

Save   and close Exp19_Excel_Ch09_Cap_Assessment_Tips.xlsx.   Exit Excel. Submit the file as directed.

Subject: Business Network Systems Management – 03478 – Sp22

Task: 

— Write small summary 10-15 lines of each classmate research paper. No reference or other details.

— There are total 12 classmate research paper.

— it is due by tomorrow 05/06/2022.