Unit 6 Assignment: Implementation Plan

Overview:

For this assignment, write a two-page paper covering a plan to implement the Sporting Goods project. For example, if you chose “a website for a sporting goods retail company,” then you can include the details of a marketing and advertising campaign.

Instructions:

Create an implementation plan that will meet the needs and requirements of the Sporting Goods project. This might include last-minute testing to eliminate any bugs, as well as to monitor user reactions to the new site. The ranking of the site on popular search engines should be checked and, if not satisfactory, steps should be taken to make changes and corrections. Newspaper and television ads might announce the new website, and celebrity sports figures might be hired to do videos for the site. After implementation, the website should be monitored for possible problems. Each of the tasks involved in implementation should have an estimated duration. Make sure to include the major tasks that are necessary to perform during an implementation. Information on this can be found in the Project Implementation article.

Requirements:

• The implementation plan paper should be 2 pages in length, with additional cover and reference pages.

• The summary should be double-spaced, written in 12-point Times New Roman font, and use a 1-inch margin.

• Use at least two (2) scholarly sources in the Sporting Goods assignment and include all references and citations properly formatted in APA.

• Use complete sentences and appropriate grammar and spelling.

Final Submission

This will be the complete submission of your project and implementation plan. You will need to defend and support your final work to the CEO and board.

Improve all previous project submissions based on graded feedback. Then assemble them into a final plan with a summary that advocates for your position. Think of this as making the final sale to a customer. Why should the CEO and board accept this as the best solution? What will the company gain by implementing this solution? How will we ensure that the solution is sustainable?

Along with your final deliverable, create a PowerPoint presentation containing 7-10 slides that you would use to present your findings at a board meeting.

It217 week 6 Assignment

 

1. Modify the conversion2loop.as program to allow the user to enter up to 10 grades for Assignment, up to 10 grades for Discussion, up to 10 grades for Attendance, and 2 grades for Tests. 

2. Calculate the average grade for each group in question 1. 

3. Calculate the total average grade for the course in letter grade and numerical grade assuming that Assignment is 30%, Discussion 30%, Attendance 15%, Tests 25%.

Submit the “.bas” program and the screenshots of the program and the outputs.

HERE IS THE CODE BELOW

‘Convert grades to letter

average = 0

count = 0

do

input “enter grade: “; grade

select case

case grade >= 90

result$ = “A”

case grade>=80

result$ = “B”

case grade >= 70

result$ = “C”

case grade >= 60

result$ = “D”

case grade <60

result$ = “F”

end select

print result$

 confirm “Again”; answer$

 if answer$ = “yes”  then

 count = count +1

 total = (total + grade)

 average = total/count

end if

 loop while answer$ = “yes”

count = count +1

  total = (total + grade)

 average = total/count

 print count; ” grades entered.”

 print “Average is: “;average

grade = average

select case

case grade >= 90

result$ = “A”

case grade>=80

result$ = “B”

case grade >= 70

result$ = “C”

case grade >= 60

result$ = “D”

case grade <60

result$ = “F”

end select

print result$

Speed Test

First, test your ISP- we are looking for a 10 up and 10 down, if you do not meet we can allow time for you to upgrade to meet:

You will need to go to www.speedtest.net and complete the speed test using your computer, in your office location, and on a hardwired link if possible. Once you have completed the test save the link in your results to give us.

Course_Related_Hybrid

 Correlate your job responsibilities with the course outcomes listed below. 300 Words. APA Format

Job Responsibilities

• As an Oracle ERP Test Lead was responsible for managing 6 resources who were part of the Oracle testing team

• Able to extract back-end data using SQL/Toad queries

• Tested sales cycles by implementing Oracle Configure Price Quote (CPQ) solutions effectively.

• Involved in Integration testing using various SFTP/SOA Middleware.

• Validated SOAP UI and Restfull API services

• Involved in developing Test Plans and Test cases for the entire functionality.

• Worked closely with Developers and Cross-Functional teams for different issues.

• Flow Testing for Oracle SCM Modules (AR, AP, OM, CM, INV, PO, GL) to make sure flow is working without any issues.

• Tested B2B, B2C and B2E order flow.

• Reviewed database test cases according to assigned Requirements to validate reports by retrieving data with complex SQL queries from oracle database.

• Written Standard test scripts for Oracle Order to Cash O2C Modules and Procure to Pay P2P Modules

• Tested EDI Batches from OTM to Oracle

• Tested database objects like tables, views, sequences using SQL/PLSQL.

• Done Field by Filed comparison of OTM and Oracle Data

• Responsible for Test Plan Preparation, Test Strategy Preparation, Team Meetings Facilitation, Defect Tracking Facilitation, Report bugs, etc.

• Analyze, design, prototype, configure, test, document, and implement new or modify existing software to support various business processes.

• Assist key users in testing new functionality, documenting and retaining ERP knowledge.

• Documented testing results and updated the same for verification to the management.

• Test a new enhancement for a Business Process.

• Involved End to end testing for business process using all application tiers.

Course Outcome

a) Database Systems – Students will study database architecture (physical, logical, modeling, and normalization). This will include the following learning area:1) Database fundamentals; 2) The Relational Model; 3) Structured Query Language; 4) Data Modeling and ER Diagrams; 5) Database Design; 6) Database Administration; 7) Database processing / applications; 8) Data Warehouses, Business Intelligence Systems, and Big Data

b) Object Oriented Programming (OOP) – Students will develop and test OOP using the Java platform.  This will include the following learning area: 1) An introduction to OOP (using Java); 2) How to start writing code; 3) How to use classes and methods; 4) How to code your own classes and methods; 5) How to work with primitive types and operators; 6) How to code control statements; 7) How to work with strings;8) How to work with arrays; 9) How to work with inheritance; 10) How to work with interfaces; 11) How to work with dates and times; 10) How to handle exceptions

c) Operating Systems – Students will study database architecture (physical, logical, design, and normalization). This will include the following learning area: 1) Chapter 1 – Components of a Modern Computer; 2) Processes and Threads; 3) Memory Management; 4) File Systems; 5) Input / Output Operations; 6) Deadlocks; 7) Virtualization and the Cloud; 8) Multiple Processor Systems.

d) Computer Networking – Students will study computer network architecture (physical, logical, and protocols). This will include the following learning area: 1) Core Network Concepts and Terminology; 2) Terminology and Network Standards; 3) Network Management; 4) Network Security; 5) Ethernet (802.3) Switched LANs; 6) Wireless LANs, 7) TCP/IP Internetworking I; 8) Wide Area Networks (WANs)

e) Software Engineering – Students will study building computer software systems (project management (waterfall, agile), requirements constructs, design, development, and testing). This will include the following learning area: 1) Software Engineering from 20,000 Feet; 2) Before the Beginning; 3) Project Management; 4) Requirement Gathering; 5) High-level Design; 6) – Low-level Design; 7) Development; 8)Testing 

The formula is =HLOOKUP(E5,H_Rates,2)

Homework Assignmet

 

Central Sierra Insurance (CSI) sets bonus percentages based on commissions earned by each agent and calculates totals by branch office. This workbook also tracks fundraising efforts of employees for a community event.

[Student Learning Outcomes 2.1, 2.2, 2.3, 2.5, 2.6, 2.7]

File Needed: CentralSierra-02.xlsx (Available from the Start File link.)

Completed Project File Name: [your name]-CentralSierra-02.xlsx

Skills Covered in This Project

  • Create, copy, and edit formulas.
  • Name cell ranges.
  • Set mathematical order of operations.
  • Set cell references to be absolute.
  • Use the NOW function.
  • Use HLOOKUP and VLOOKUP
  • Use the SUMIF function.
  • Build an IF function.
  1. Open the start file CentralSierra-02.xlsx workbook. 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. Select the Tables sheet, select cells A6:B10, and create range names using the Create from Selection button [Formulas tab, Defined Names group].
  3. Select cells B1:F2 and click the Name box. Name the selection H_Rates. Note that the first row is arranged in ascending order.
  4. Create an HLOOKUP function to display the bonus rate.
    1. Click the Commissions sheet tab and select cell F5.
    2. Start the HLOOKUP function and use cell E5 as the lookup_value.
    3. For the table_array argument, use the H_Rates range.
    4. Use the second row for the row_index_num argument (Figure 2-100).The formula is =HLOOKUP(E5,H_Rates,2)Figure 2-100 HLOOKUP function to display bonus
  5. Format the results as Percent Style with two decimal places.
  6. Copy the formula in cell F5 to cells F6:F14.
  7. Set order of operations to calculate total earnings.
    1. Select cell G5.
    2. Build a formula to add the commissions amount (E5) to the commissions amount times the rate (F5*E5).
    3. Copy the formula in cell G5 to cells G6:G14.
  8. Create and copy a SUMIF function to calculate total earnings by branch office.
    1. Select cell E18.
    2. Start the SUMIF function with cells $D$5:$D$14 as the Range argument.
    3. Set the Criteria argument as a relative reference to cell C18.
    4. Select cells G5:G14 for the Sum_range argument and make the references absolute.
    5. Copy the formula in cell E18 to cells E19:E20 without formatting to preserve borders.
    6. Format cells E18:E21 as Currency.
  9. Total the earnings in cell E21.
  10. Create and format the current date.
    1. Select cell G23 and insert the NOW function.
    2. Select cell G23 and click the Number group launcher [Home tab]. On the Number tab, select the Date category.
    3. Scroll the Type list to find the date that displays the month spelled out, the date, a comma, and a four-digit year (Figure 2-101).The Date category in the Format Cells dialog boxFigure 2-101 Date format selected
    4. Click OK. Press Ctrl+Home.
  11. Create and copy a VLOOKUP function to display goals for each funding source.
    1. Click the Family Day sheet tab and select cell F6.
    2. Start the VLOOKUP function and use cell E6 as the lookup_value.
    3. Click the Tables sheet tab for the table_array argument and use cells $A$6:$B$10. The data is sorted by the first column in ascending order.
    4. Use the second column as the col_index_num The range_lookup argument is empty.
    5. Copy the formula in cell F6 to cells F7:F20 without formatting to preserve the fill color.
    6. Format cells F6:F20 as Currency with no decimal places.
  12. Create and copy an IF function.
    1. Select cell H6 and start an IF
    2. Type a logical_argument to determine if cell G6 is greater than or equal to (>=) cell F6.
    3. Type Yes as the Value_if_true argument and No as the Value_if_false argument.
    4. Copy the formula in cell H6 to cells H7:H20 without formatting to maintain the fill color.
    5. Center align cells H6:H20.
    6. Press Ctrl+Home.
  13. Insert a new sheet at the end of the tab names and paste the range names starting in cell A1. AutoFit columns A:B and name the worksheet as Range Names.
  14. Save and close the workbook (Figure 2-102).Excel 2-4 completed

Deliverable 1

Problem: Transportation system in London has an issue of getting overloaded during some soccer games. Since this data was not available consistently due to soccer games not having a set pattern every season, the city of London needed to put together a data analysis strategy in order to predict the transportation usage during these games and administer transportation systems accordingly.  

Definition: Overloading of high volume stations with travelers on Weekend evenings which was design as a low load period. 

Scope: Data  governance strategy for acquiring data, specifying principles, quality, metadata, access and lifecycle