Preview

Spreadsheet Modelling Assignment 2015

Good Essays
Open Document
Open Document
2830 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Spreadsheet Modelling Assignment 2015
Learner’s Comments ( What went well, What could you improve)

Assessor’s name:

Assessor’s signature:

Date:

Learner’s Declaration:
I declare that this assignment is my individual work. I have not worked collaboratively nor have I copied from any other student’s work or from any other source except where due acknowledgment is made explicitly in the text, nor has any part been written for me by another person.

Signed: ........................................................................................... Date: ................................

Learning Outcome Ref
Learning Outcome
Criteria reference
To achieve the criteria the evidence must show that the student is able to:
Met Yes or No
Student Evidence
(Page Nos)
Feedback (dated)

LO1

Understand how spreadsheets can be used to solve complex problems
P1
Explain how spreadsheets can be used to solve complex problems

D1
Discuss how organisations can use interpretation methods to analyse data

LO2
Be able to develop complex spreadsheet models
P2
Develop a complex spreadsheet model to meet particular needs [IE1]

P3
Use formulae, features and functions to process information

M1
Refine a complex spreadsheet model by changing rules and values

L03
Be able to automate and customise spreadsheet models
P4
Use appropriate tools to present data

P5
Customise the spreadsheet model to meet a given requirement

P6

Use automated features in the spreadsheet model to meet a given requirement

M2
Analyse and interpret data

M3
Compare different automation methods

Learning Outcome Ref
Learning Outcome
Criteria reference
To achieve the criteria the evidence must show that the student is able to:
Met Yes or No
Student Evidence
(Page Nos)
Feedback

LO4
Be able to test and document spreadsheet models.
P7
Test a spreadsheet model to ensure that it is fit for purpose

P8
Export the contents of the spreadsheet model to an

You May Also Find These Documents Helpful

  • Good Essays

    Btec Business Level 3 Unit 4

    • 4682 Words
    • 19 Pages

    I hereby confirm that this assignment is my own work. I have identified and acknowledged all sources used in this assignment and have referenced according to the Harvard referencing system. I have read and understood the Plagiarism and Collusion section provided with the assignment brief and understood the consequences of plagiarizing.…

    • 4682 Words
    • 19 Pages
    Good Essays
  • Satisfactory Essays

    The City of Highlands Ranch, Colorado, wishes to organize its campaign contributions records in a more strategic format. The city council is considering an executive information system that can show them overall views of the contribution information as well as give them the ability to access more detailed information. You have been hired to make recommendations about what reports should be available for the executive information system reporting.…

    • 381 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    excel assignment 3

    • 421 Words
    • 2 Pages

    2) What would be the time to maturity of a zero-coupon bond with face value $1000 that would also immunize your obligation (Bond3)? Let’s call this portfolio B (includes only zero-coupon bond).…

    • 421 Words
    • 2 Pages
    Satisfactory Essays
  • Better Essays

    Modeling is the process of creating a simplified representation of real life problems and representing them in an organized fashion in order to understand a particular problem. These models can take many forms such as mental, visual, mathematical or electronic spreadsheets to name a few. Their uses can be seen in almost every field of our daily lives such as businesses, governments, human resources, science and engineering, and medicine etc. Their primary function is to gain insight into a specific problem and after getting a clear understanding of the topic, one can easily approach it from different directions with possible solutions. This paper discusses this process in detail, starting with gaining insight into a specific problem by using a problem solving model, and then moves on to how it applies to spreadsheet modeling. It also discusses different aspects of electronic spreadsheet engineering, its uses and caveats, as well as its dependency in the business world these days.…

    • 2313 Words
    • 10 Pages
    Better Essays
  • Better Essays

    except where I have indicated, this assignment is my own work, based on my personal study and/or research.…

    • 1840 Words
    • 7 Pages
    Better Essays
  • Better Essays

    Fin204

    • 2195 Words
    • 9 Pages

    * No part of this assignment has been copied from any other person’s work except where due acknowledgement is made in the text, and…

    • 2195 Words
    • 9 Pages
    Better Essays
  • Good Essays

    Law, A. M. and W. D. Kelton, Simulation Modeling and Analysis, 3rd Edition, McGraw Hill, 2000.…

    • 1490 Words
    • 6 Pages
    Good Essays
  • Best Essays

    International Joint Ventures

    • 2571 Words
    • 11 Pages

    In submitting this assignment, I certify that all this material is my own work, except where I have indicated otherwise with appropriate references.…

    • 2571 Words
    • 11 Pages
    Best Essays
  • Satisfactory Essays

    Role Internet Marketing

    • 1165 Words
    • 7 Pages

    This assignment is my own work. If I have worked with someone else or have received help I have shown this clearly in my work. I have given references for all quotations and materials from the work of other people.…

    • 1165 Words
    • 7 Pages
    Satisfactory Essays
  • Powerful Essays

    I declare that this assignment is our own work. I further declare that where material has been used from other sources, whether by paraphrasing or by direct quotation, it has been fully acknowledged and referenced. I have retained a copy of this assignment for my records.…

    • 5443 Words
    • 22 Pages
    Powerful Essays
  • Powerful Essays

    chain in the United States. In its place, Forte Hotels will develop a new chain…

    • 2004 Words
    • 9 Pages
    Powerful Essays
  • Satisfactory Essays

    Excel Case Study

    • 416 Words
    • 4 Pages

    My Household Budget ITEM MONTHLY BUDGET JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Item Total Housing $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $12,000.00 Utilities $250.00 $136.00 $146.00 $150.00 $142.00 $155.00 $270.00 $290.00 $267.00 $260.00 $210.00 $200.00 $200.00 $2,426.00 Car Payment $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $3,600.00 Insurance $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00…

    • 416 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    BTEC L3 Unit 3 Assignment

    • 1831 Words
    • 11 Pages

    I declare that this assignment is all my own work and the sources of information and material I have used (including the internet) have been fully identified and properly acknowledged as required.…

    • 1831 Words
    • 11 Pages
    Satisfactory Essays
  • Powerful Essays

    I/We declare that this assignment is all my/our own work, that it has not been copied from elsewhere and that any extracts from books, papers or other sources have been properly acknowledged as references or quotations. In addition I/we agree that this assignment may be subject to electronic analysis for the detection of collusion, plagiarism and other forms of unfair advantage.…

    • 9450 Words
    • 31 Pages
    Powerful Essays
  • Best Essays

    I certify that this assignment is the result of my own work and does not exceed the word count noted. Number of words: 1500 (Excluding references, title page)…

    • 1836 Words
    • 6 Pages
    Best Essays