Spreadsheet and Design Development Assignment, writing homework help

Anonymous
timer Asked: Oct 18th, 2016
account_balance_wallet $40

Question Description

Briefly respond to the following in 2-3 pages:

1.Microsoft (MS) Excel Development Functions. Review commonly used spreadsheet development functions within MS Excel (formulas, linking, pivot tables, etc.) by completing Atomic Learning tutorials. Complete the Excel 2016 - Frequently Used Formulas & Functions Training: B. Formulas (required) and C. Linking and Consolidating Worksheets (required) module tutorials. Also complete the Excel 2016 - Pivot Tables: A. Getting Started (required), B. Creating and Deleting (required), C. Custom Appearance and Layout (required), D. Printing Options and Copying a Pivot Table (required), E. Summarizing with Totals and Formulas (required), Refreshing Data (required), G. Pivot Charts (optional), and I. Sparklines and Slicers (optional) module tutorials. List the modules completed, provide a brief synopsis what you learned within each module (You do not have to provide a synopsis of each individual tutorial video), and comment on the usefulness of MS Excel development functions. Note: Atomic Learning modules are required.

2.Poor Spreadsheet Design/Development Practices.

  1. How do poor spreadsheet design/development practices contribute to spreadsheet integrity/reliability problems?
  2. Identify two poor spreadsheet design/development practices (see Ansari and Block 2008 and Harkins 2011 but also conduct your own research and draw your own conclusions). Explain the implications of each poor practice you identified. Hint: Search for “bad spreadsheet development practices” or “spreadsheet design errors.”
  3. Explain the potential business consequences of poor spreadsheet design/development practices. Hint: Search for “spreadsheet errors” or “spreadsheet horror stories.
  4. Explain why the majority of spreadsheets typically contain serious errors.

3.Good Spreadsheet Design/Development Practices.

  1. How do good spreadsheet design/development practices contribute to spreadsheet integrity/reliability?
  2. Identify two good spreadsheet design/development practices and list them in order of priority (see Ansari and Block 2008 and Bewig 2005 but also conduct your own research and draw your own conclusions). Explain the implications of each good practice you identified. Hint: Search for “good spreadsheet development practices” or “spreadsheet design best practices.”
  3. Review the systems development life cycle (SDLC) in the course notes/text. Explain how the SDLC may facilitate sound spreadsheet design/development.

4.Improving Spreadsheet Design/Development. Recommend two practical solutions to the spreadsheet design/development concerns you identified above. That is, how would you go about ensuring sound spreadsheet design/development within a real-world organization? Consider the practicability of your recommendations.

Tutor Answer

Kims
School: Cornell University

Atta...

flag Report DMCA
Review

Anonymous
Top quality work from this guy! I'll be back!

Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors