Spreadsheets

Spreadsheets

1. graphs in a spreadsheet

   • Ask yourself what do you want to find out from the Graph
     • Will determine which graph you should use
   • Only use necessary data
   • All graphs should include:
     • Title
     • Legend
     • Series
     • Y axis label
     • X axis label
   • When collecting data highlight the data needed
     • The name that you want the section to be called
     • The data going into the individual section
   • You can format the graph in different ways
     • You can choose a colour for the background
     • You can use pictures
     • You can alter the thickness of the gridlines
     • The font and sizes of the axis' label has changed

2. Hypothesis

   • A possible For something
     • Or a prediction Of what might happen in a given situation
   • It needs to be tested
     • It can be tested using a model
   • Uses of models
     • They are set up to simulate real-life situations
     • You can ask "what if" questions
     • Can be used to find out results of possible changes
     • Provide rough estimate of the results, instead of an accurate Prediction
     • Advantages of models
       • Often cheaper to simulate Instead of enacting it
       • Can be safer
       • It is quicker
     • Disadvantages of models
       • The results are not accurate, not approximate
       • It is very easy to make mistakes
       • They have to be tested ore than once to be sue of results
       • You have too make assumptions about the rules
     • can be used
       • By car manufacturers
       • In the financial Area of a company
       • By pilots