Overview:

For this assignment, write a two-page systems design paper on Sporting Goods. For example, if you chose “a cybersecurity system for a small company that has neglected computer security issues,” then discuss the details of a system that will meet the company’s security needs and requirements.

Instructions:

Design a system that will meet the needs and requirements of the Sporting Goods project. This must include recommendations on new hardware, new software, interfaces, data, new/revised procedures, and new/revised policies. Make sure to include the major tasks that are necessary to perform during a systems design process. A list of these tasks can be found in the System Design in Software Development (<

Requirements:

• Your systems design 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 your assignment and include all references and citations properly formatted in APA.

• Use complete sentences and appropriate grammar and spelling.

Required Practical Connection Assignment

Provide a reflection of at least 500 words (or 2 pages double spaced) of how the knowledge, skills, or theories of this course have been applied, or could be applied, in a practical manner to your current work environment. If you are not currently working, share times when you have or could observe these theories and knowledge could be applied to an employment opportunity in your field of study.

NOTE:  Do not submit a paper you wrote for another class.  This paper must be written specifically for this class.

NOTE:  Do not include a job description from your current or previous job.  This paper must be written to describe how this course would apply to your job.  

250 words +

Data pipeline has been integrated to data warehouse processing. As you already study data management for a whole term, please have some imagination/future image/thoughts for potential technology to improve the process and application of database system

 write your complete draft of your discussion section:

• Activity: Discussion, Para. 1
• Activity: Discussion, Para. 2
• Activity: Discussion, Para. 3

references 

Zhang, Y., Yu, W., Li, Z., Raza, S., & Cao, H. (2021). Detecting Ethereum Ponzi schemes based on improved LightGBM algorithm. IEEE Transactions on Computational Social Systems, 9(2), 624–637. https://doi.org/10.1109/tcss.2021.3088145

Al-Nsour, E., Weshah, S., & Dahiyat, A. (2021). Cloud accounting information systems: Threats and advantages. Accounting, 7(4), 875-882. https://doi.org/10.5267/j.ac.2021.1.021

Boylan, D. H., & Hull, J. E. (2022). Have Accounting Information Systems significantly helped in detecting fraudulent activities in accounting? The Journal of Applied Business and Economics, 24(3), 45-56. https://doi.org/10.33423/jabe.v24i3.5191

GO19_AC_CH03_GRADER_3G_AS – Workshop Rooms 1.0

In this project, you will use a database to track workshops and the rooms where the workshops are held at a college. You will create forms, add and delete records by using a form, filter records, and modify a form in Layout view and Design view. You will create reports, modify a report in Layout view and Design view, group data in a report, and keep grouped data together for a printed report.

Start Access. Open the file Student_Access_3G_Workshop_Rooms.accdb downloaded with this project.
 

  View the relationship between the Rooms table and the Workshops table. One   room can be used for many workshops. Close the Relationships window.

Use   the Form tool to create a form based on the Workshops table. Save the form as   Workshop Form and then display the form in Form   view. Using the Workshop Form, add the following new record to the underlying   Workshops table:

Field

Data

Workshop ID

W-5034

Workshop Name

Job Portfolio

Room ID

RM-208

# Registrations

23

Workshop Category

Guide to Finding a     Job

Overview

In order to successfully manage risk,  one must understand risk itself and the assets at risk. The way one goes  about managing risk will depend on what needs to be protected, and from  what to protect it. 

Instructions

Write a 3–4 page paper in which you: 

1. Discuss at least three rationales for performing an information systems security risk assessment.
2. Explain the differences in quantitative, qualitative, and hybrid  information systems risk assessment and illustrate the conditions under  which each type is most applicable.
3. Describe the type of information that is collected to perform an  effective information systems security risk assessment. Include at least  three different types. Fully describe each and justify why you made  your selections.
4. Describe at least five common tasks that should be performed in an information systems security risk assessment.
5. Use at least two quality resources in this assignment. Note:  Wikipedia and similar websites do not qualify as quality resources. The  Strayer University Library is a good source for resources.

The specific course learning outcome associated with this assignment is: 

• Evaluate risk analysis methodologies to determine the optimal methodology based on needs, advantages, and disadvantages.

You are going to enhance the prior assignment by doing the following

1) Add menu items to write to a file and to read from a file

2) create a class wrfile() with two methods to write the results to a file, and to read the results from a file.

Sample output

Use the same output from last assignment

Midterm 

13. Define the IT organizational structure and how the IT organizational structure impacts culture and change management practices.  Additionally, how does the organizational structure impact competitive advantage?

14. How do you define operational excellence?  What factors are involved in achieving operational excellence?  Who (within an organization) is responsible for operational excellence and why is this important?

—————————————————————

1.  What is the productivity paradox?

2.  Summarize Carr’s argument in “Does IT Matter.”

3.  How is the 2008 study by Brynjolfsson and McAfee different from previous studies? How is it the same?

4.  What does it mean for a business to have a competitive advantage?

5.  What are the primary activities and support activities of the value chain?

6.  What has been the overall impact of the Internet on industry profitability? Who has been the true winner?

7.  How does EDI work?

8.  Give an example of a semi-structured decision and explain what inputs would be necessary to provide assistance in making the decision.

9.  What does a collaborative information system do?

10. How can IT play a role in competitive advantage, according to the 2008 article by Brynjolfsson and McAfee?

11. Do some independent research on Nicholas Carr (the author of “IT Doesn’t Matter”) and explain his current position on the ability of IT to provide competitive advantage.

1.  What does the term business process mean?

2.  What are three examples of business process from a job you have had or an organization you have observed?

3.  What is the value in documenting a business process?

4.  What is an ERP system? How does an ERP system enforce best practices for an organization?

5.  What is one of the criticisms of ERP systems?

6.  What is business process re-engineering? How is it different from incrementally improving a process?

7.  Why did BPR get a bad name?

8.  List the guidelines for redesigning a business process.

9.  What is business process management? What role does it play in allowing a company to differentiate itself?

10. What does ISO certification signify?

11. Review the return policies at your favorite retailer, then answer this question. What information systems do you think would need to be in place to support their return policy?

12. Review the section on knowledge creation, culture, and strategy.  Explain how balance scorecards impact knowledge creation, culture, and strategy.  Why are these important concepts to understand within an organization?

1 page

————————————————————————–

Question is uploaded to files

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

2  Use IF functions to calculate the regular pay and overtime pay based on a regular 40-hour workweek in cells E5 and F5. Pay overtime only for overtime hours. In cell G5, calculate the gross pay based on the regular and overtime pay. Abram’s regular pay is $398. With 8 overtime hours, Abram’s overtime pay is $119.40. 

3.  Create a formula in cell H5 to calculate the taxable pay. Multiply the number of dependents (column B) by the deduction per dependent (B24) and subtract that from the gross pay. With two dependents, Abram’s taxable pay is $417.40. 

4. Use a VLOOKUP function in cell I5 to identify and calculate the federal withholding tax. Use the tax rates from the range D21:E25. The VLOOKUP function returns the applicable tax rate, which you must then multiply by the taxable pay. 

5. Calculate FICA in cell J5 based on gross pay and the FICA rate (cell B23), and calculate the net pay in cell K5. Copy all formulas down their respective columns to row 16. 

6. With the range E5:K16 selected, use Quick Analysis tools to calculate the total regular pay, overtime pay, gross pay, taxable pay, withholding tax, FICA, and net pay on row 17.

Note, Mac users, with the range selected, on the Home tab, in the Editing group, click AutoSum. 

7. Apply Accounting Number Format to the range C5:C16. Apply Accounting Number Format to the first row of monetary data and to the total row. Apply the Comma style to the monetary values for the other employees. Apply the Total cell styles format to the range E17:K17. 

8. Insert appropriate functions to calculate the average, highest, and lowest values in the Summary Statistics area (the range I21:K23) of the worksheet. Format the # of hours calculations as Number format with one decimal and the remaining calculations with Accounting number format. 

9. Insert a 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 the worksheet. 

10. Save and close the workbook. Submit the file as directed.