Software Development Life Cycle

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.). 

 https://youtu.be/B8I9H5AHNCw 

 https://youtu.be/T7_rQ-dOxeM 

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

Alternate Instruction for Microsoft 365 Apps icon

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.

Alternate Instruction for Microsoft 365 Apps icon 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.

  1. 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.
  2. Create a pie chart object.
    1. Select the Revenue by Department sheet, select cells A4:F4, press Ctrl, and select cells A13:F13.
    2. Click the Recommended Charts button [Insert tab, Charts group].
    3. Choose Pie and click OK.
  3. Apply a chart style.
    1. Select the chart object.
    2. Click the More button [Chart Design tab, Chart Styles group].
      Alternate Instruction for Microsoft 365 Apps icon Click the More button [Chart Tools Design tab, Chart Styles group].
    3. Select Style 12.
  4. Size and position a chart object.
    1. Point to the chart object border to display the move pointer.
    2. Drag the chart object so its top-left corner is at cell A21.
    3. Point to the bottom right selection handle to display the resize arrow.
    4. Drag the pointer to cell G36.
  5. Change the chart type.
    1. Select the pie chart object and click the Change Chart Type button [Chart Design tab, Type group].
      Alternate Instruction for Microsoft 365 Apps icon Select the pie chart object and click the Change Chart Type button [Chart Tools Design tab, Type group].
    2. Select the All Charts tab and choose Pie in the left pane.
    3. Choose 3-D Pie and click OK.
  6. Format pie chart elements.
    1. Double-click the pie to open its Format Data Series task pane.
    2. 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. )
    3. Click the Series Options button in the Format Data Series task pane.
    4. Set the pie explosion percentage at 10%.
    5. Close the task pane.
    6. Click the chart object border to deselect the Atlanta slice.
  7. Add and format chart elements in a pie chart.
    1. Click the Chart Elements button in the top-right corner of the chart.
    2. Select the Data Labels box.
    3. Click the Data Labels arrow to open its submenu and choose More Options.
    4. If necessary, click the Label Options button In the Format Data Labels pane.
    5. If necessary, click Label Options to expand the group.
    6. Select the Percentage box.
    7. Deselect the Value box (Figure 3-66).Data labels are selected in the chartFigure 3-66 Format Data task pane for data labels
    8. Press Ctrl+B to apply bold.
    9. Change the font size to 12 pt [Home tab, Font group].
    10. Click the chart object border to select it.
    11. Click the Shape Outline button [Chart Format tab, Shape Styles group] and choose Purple, Accent 4, Darker 50% (eighth column).
      Alternate Instruction for Microsoft 365 Apps icon Click the Shape Outline button [Chart Tools Format tab, Shape Styles group] and choose Purple, Accent 4, Darker 50% (eighth column).
    12. Click the Shape Outline button and choose Weight and 1 pt.
    13. Click a worksheet cell.
  8. Create a line chart sheet.
    1. Select the Atlanta Revenue sheet tab.
    2. Select cells A4:E7.
    3. Click the Quick Analysis button and choose Charts.
    4. Select Line.
    5. Click the Move Chart button [Chart Design tab, Location group].
      Alternate Instruction for Microsoft 365 Apps icon Click the Move Chart button [Chart Tools Design tab, Location group].
    6. Click the New sheet button.
    7. Type Promo Depts and click OK.
  9. Apply a chart layout.
    1. Click the Quick Layout button [Chart Design tab, Chart Layouts group].
      Alternate Instruction for Microsoft 365 Apps icon Click the Quick Layout button [Chart Tools Design tab, Chart Layouts group].
    2. Select Layout 5 to add a data table to the chart sheet (Figure 3-67).Data table displays values from the chart.Figure 3-67 Data table added by Quick Layout
  10. Change the chart type.
    1. Click the Change Chart Type button [Chart Design tab, Type group].
      Alternate Instruction for Microsoft 365 Apps icon Click the Change Chart Type button [Chart Tools Design tab, Type group].
    2. Select the All Charts tab and choose Line with Markers in the Line category.
    3. Click OK.
  11. Edit chart elements in a line chart.
    1. Click the chart title placeholder.
    2. Type Special Promotion Departments in the Formula bar and press Enter.
    3. Click the vertical axis title placeholder.
    4. Type Dollar Sales in the Formula bar and press Enter.
    5. Click the Chart Elements drop-down arrow [Chart Format tab, Current Selection group].
      Alternate Instruction for Microsoft 365 Apps icon Click the Chart Elements drop-down arrow [Chart Tools Format tab, Current Selection group].
    6. Choose Series “Apparel” to select the line in the chart.
    7. Click the Format Selection button [Chart Format tab, Current Selection group].
      Alternate Instruction for Microsoft 365 Apps icon Click the Format Selection button [Chart Tools Format tab, Current Selection group].
    8. Click the Fill & Line button in the Format Data Series task pane.
    9. Click Marker and then click Marker Options to expand the group (Figure 3-68).The Apparel series is the blue lineFigure 3-68 Marker options for the data series
    10. Choose Built-in and set the Size to 10.
    11. Click the Series Options triangle at the top of the task pane and choose Series “Baseball” (Figure 3-69).The series names are at the bottom of the list.Figure 3-69 New data series selected
    12. Apply the same marker changes for the baseball series.
    13. Select the Basketball series and apply the same marker changes.
    14. Close the task pane and click outside the chart.
  12. Insert sparklines in the worksheet.
    1. Click the Atlanta Revenue tab.
    2. Right-click the column F heading and choose Insert.
    3. Select cells B5:E18 as the data range.
    4. Click the Line Sparkline button [Insert tab, Sparklines group].
    5. Select cells F5:F18 in the Location Range box.
    6. Click OK.
  13. Format sparklines in worksheet.
    1. Click the Format button [Home tab, Cells group] and change the Row Height to 24.
    2. Click the Format button [Home tab, Cells group] and set the Column Width to 35.
    3. Select the Markers box in the Show group in the Sparkline tab.
      Alternate Instruction for Microsoft 365 Apps icon Select the Markers box in the Show group on the Sparkline Tools Design tab.
    4. Click the Sparkline Color button [Sparkline tab, Style group].
      Alternate Instruction for Microsoft 365 Apps icon Click the Sparkline Color button [Sparkline Tools Design  tab, Style group].
    5. Choose Black, Text 1 (second column) for the line color.
    6. Click cell A1.
  14. Change the page orientation to landscape.
  15. Save and close the workbook (Figure 3-70).Excel 3-3 completed worksheet and chartsFigure 3-70 Excel 3-3 completed worksheet and charts
  16. Upload and save your project file.
  17. Submit project for grading.

Reset Progress Back to top

SUPPORT

FOLLOW MCGRAW HILL

SIMnet Blog
 

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.

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.