You are attending a meeting regarding project development using the SDLC. Your manager is giving a high-level overview of the SDLC process, but your colleagues look confused about some of the points. As a result, your manager asks you to schedule a meeting to present the four phases and the importance of each to your colleagues. In your own words, how would you explain each of the phases to your colleagues during the meeting? Provide specific examples that will help them understand each of the phases and their importance.
Two Factor Authentication
Need a research paper on two-factor authentication effectiveness. In the attached Guide Page 1 has the mind map and outline of the topics that need to be covered in the research paper also it has a guide on how to build the research report. It needs to be a minimum of 12 Pages excluding Table of contents, Introduction and references pages.
Assignment
After responding to the weekly discussion topic on FOOTPRINTING, you now have an idea as to how to conduct a digital investigative project. For this assignment, you are asked to develop your own crime scenario. Explain the incident that occurred, and then list the steps you would follow to solve this case (examples might include: a lost child, an unauthorized charge on your credit card, an unidentified charge made with your EZ PASS, etc.).
Computer User Support Help Desk and Support Specialist
ASSIGNMENT NAME: Assignment #6 (A)
PURPOSE(S):
To research tools that can help you resolve problems.
OBJECTIVE(S):
Discussing methods for evaluating and selecting technology products
GRADE PERCENTAGE: 2%
MATERIAL(S) NEEDED:
INSTRUCTIONS:
Read Chapter 8 and Complete “Check Your Understanding” at the end of the chapter
Assignment 6A: HANDS-ON: Do Activity 8-1 (at least 300 words). Cite all sources.
SUBMIT IN BLACKBOARD:
Locate the Assignment Link(s) by name and submit your work by the due date and time. Please submit Activity in the Assignment #6 link.
Assignment 6A: HANDS-ON: Activity 8-1 (at least 300 words)
GRADING RUBRIC:
Assignment 6A
Criteria content – 4pts
Additional criteria content – 4pts
Description of evaluation method used – 4pts
Objective or subject results – 4pts
Agree or disagree with results – why or why not? –
Textbook: Computer User Support Help Desk and Support Specialist – 6th edition, By: Fred Beisse
How to work on spreadsheet document using the information given
Guided Project 3-3
Windows Mac
Blue Lake Sports has locations in several major cities and tracks sales by department in each store. For this project, you create a pie chart that shows each store’s share of golf-related sales for the first quarter. You also create a line chart to illustrate week-to-week sales for specific departments in one of the stores and insert sparklines in the data.
[Student Learning Outcomes 3.1, 3.2, 3.3, 3.4, 3.6, 3.8]
File Needed: BlueLakeSports-03.xlsx (Available from the Start File link.)
Completed Project File Name: [your name]-BlueLakeSports-03.xlsx
Skills Covered in This Project
- Create, size, and position a pie chart object.
- Apply a chart style.
- Change the chart type.
- Add and format chart elements.
- Create a line chart sheet.
- Apply a chart layout.
- Insert and format sparklines in a worksheet.
This image appears when a project instruction has changed to accommodate an update to Microsoft 365 Apps. If the instruction does not match your version of Office, try using the alternate instruction instead.
- Open the BlueLakeSports-03 start file. If the workbook opens in Protected View, click the Enable Editing button so you can modify it. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.
- Create a pie chart object.
- Select the Revenue by Department sheet, select cells A4:F4, press Ctrl, and select cells A13:F13.
- Click the Recommended Charts button [Insert tab, Charts group].
- Choose Pie and click OK.
- Apply a chart style.
- Select the chart object.
- Click the More button [Chart Design tab, Chart Styles group].
Click the More button [Chart Tools Design tab, Chart Styles group].
- Select Style 12.
- Size and position a chart object.
- Point to the chart object border to display the move pointer.
- Drag the chart object so its top-left corner is at cell A21.
- Point to the bottom right selection handle to display the resize arrow.
- Drag the pointer to cell G36.
- Change the chart type.
- Select the pie chart object and click the Change Chart Type button [Chart Design tab, Type group].
Select the pie chart object and click the Change Chart Type button [Chart Tools Design tab, Type group].
- Select the All Charts tab and choose Pie in the left pane.
- Choose 3-D Pie and click OK.
- Select the pie chart object and click the Change Chart Type button [Chart Design tab, Type group].
- Format pie chart elements.
- Double-click the pie to open its Format Data Series task pane.
- Click the Atlanta slice to update the pane to the Format Data Point task pane. (Rest the pointer on a slice to see its identifying ScreenTip. )
- Click the Series Options button in the Format Data Series task pane.
- Set the pie explosion percentage at 10%.
- Close the task pane.
- Click the chart object border to deselect the Atlanta slice.
- Add and format chart elements in a pie chart.
- Click the Chart Elements button in the top-right corner of the chart.
- Select the Data Labels box.
- Click the Data Labels arrow to open its submenu and choose More Options.
- If necessary, click the Label Options button In the Format Data Labels pane.
- If necessary, click Label Options to expand the group.
- Select the Percentage box.
- Deselect the Value box (Figure 3-66).
Figure 3-66 Format Data task pane for data labels
- Press Ctrl+B to apply bold.
- Change the font size to 12 pt [Home tab, Font group].
- Click the chart object border to select it.
- Click the Shape Outline button [Chart Format tab, Shape Styles group] and choose Purple, Accent 4, Darker 50% (eighth column).
Click the Shape Outline button [Chart Tools Format tab, Shape Styles group] and choose Purple, Accent 4, Darker 50% (eighth column).
- Click the Shape Outline button and choose Weight and 1 pt.
- Click a worksheet cell.
- Create a line chart sheet.
- Select the Atlanta Revenue sheet tab.
- Select cells A4:E7.
- Click the Quick Analysis button and choose Charts.
- Select Line.
- Click the Move Chart button [Chart Design tab, Location group].
Click the Move Chart button [Chart Tools Design tab, Location group].
- Click the New sheet button.
- Type Promo Depts and click OK.
- Apply a chart layout.
- Click the Quick Layout button [Chart Design tab, Chart Layouts group].
Click the Quick Layout button [Chart Tools Design tab, Chart Layouts group].
- Select Layout 5 to add a data table to the chart sheet (Figure 3-67).
Figure 3-67 Data table added by Quick Layout
- Click the Quick Layout button [Chart Design tab, Chart Layouts group].
- Change the chart type.
- Click the Change Chart Type button [Chart Design tab, Type group].
Click the Change Chart Type button [Chart Tools Design tab, Type group].
- Select the All Charts tab and choose Line with Markers in the Line category.
- Click OK.
- Click the Change Chart Type button [Chart Design tab, Type group].
- Edit chart elements in a line chart.
- Click the chart title placeholder.
- Type Special Promotion Departments in the Formula bar and press Enter.
- Click the vertical axis title placeholder.
- Type Dollar Sales in the Formula bar and press Enter.
- Click the Chart Elements drop-down arrow [Chart Format tab, Current Selection group].
Click the Chart Elements drop-down arrow [Chart Tools Format tab, Current Selection group].
- Choose Series “Apparel” to select the line in the chart.
- Click the Format Selection button [Chart Format tab, Current Selection group].
Click the Format Selection button [Chart Tools Format tab, Current Selection group].
- Click the Fill & Line button in the Format Data Series task pane.
- Click Marker and then click Marker Options to expand the group (Figure 3-68).
Figure 3-68 Marker options for the data series
- Choose Built-in and set the Size to 10.
- Click the Series Options triangle at the top of the task pane and choose Series “Baseball” (Figure 3-69).
Figure 3-69 New data series selected
- Apply the same marker changes for the baseball series.
- Select the Basketball series and apply the same marker changes.
- Close the task pane and click outside the chart.
- Insert sparklines in the worksheet.
- Click the Atlanta Revenue tab.
- Right-click the column F heading and choose Insert.
- Select cells B5:E18 as the data range.
- Click the Line Sparkline button [Insert tab, Sparklines group].
- Select cells F5:F18 in the Location Range box.
- Click OK.
- Format sparklines in worksheet.
- Click the Format button [Home tab, Cells group] and change the Row Height to 24.
- Click the Format button [Home tab, Cells group] and set the Column Width to 35.
- Select the Markers box in the Show group in the Sparkline tab.
Select the Markers box in the Show group on the Sparkline Tools Design tab.
- Click the Sparkline Color button [Sparkline tab, Style group].
Click the Sparkline Color button [Sparkline Tools Design tab, Style group].
- Choose Black, Text 1 (second column) for the line color.
- Click cell A1.
- Change the page orientation to landscape.
- Save and close the workbook (Figure 3-70).
Figure 3-70 Excel 3-3 completed worksheet and charts
- Upload and save your project file.
- Submit project for grading.
Reset Progress Back to top
SUPPORT
FOLLOW MCGRAW HILL
eco231w homework2
Please make sure you submit two files: a) a .do file with your stata code that can be executed by the TAs, and b) a word document with your written answers to the questions including any figures and tables.
Write a method to print
1. Write a method to print a (singly) linked list of integers in reverse order using a stack. (Pseudocode, assuming that a stack class is already defined for you) .
2. Assume that a queue is implemented with a circular array. Write a method in Pseudocode to calculate the sum of all elements in the queue.
3. A palindrome is a string that reads the same forward and backward. For example, “Able was I ere I saw Elba “. Write a program to determine whether a string is palindrome.
4. Write a program to add two large integers with up to 300 digits. One approach is to treat each number as a list, each of whose elements is a block of digits of that number, then add two integers (lists), element by element, carrying from one element to the next when necessary.
follow the instruction in the attached file.
follow the instruction in the attached file.
Excel_Introductory_Capstone1_Year_End_Report
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.