3.8 Spreadsheets, modelling and simulations - page 35
Introduction
The increasing capabilities of computers have allowed individuals and organizations to develop software
that can be used to test “what-if” scenarios and create simulations and models of real-world events.
Spreadsheets, through the use of worksheets and graphs, can be used to manage, predict using a series of “what-if” scenarios, and display financial details of businesses.
IT concepts to address in this topic
Theoretical and practical concepts for spreadsheets
• Cell types: for example, text, number, date, currency, hyperlinks
• Formulas: relative and absolute cell references
• Sorting, filtering and replicating data
• Types of charts
• Formatting and presentation: for example, text (fonts), background, paragraphs, pages
Syllabus content
36 Information technology in a global society guide
• Data validation, verification and testing
• Functions: maths, text, logic, date
• Protection for sheets and workbooks, cell locking
• Advanced functions: for example, lookup, pivot tables, macros
• Worksheet modelling: “what-if” analysis (scenarios, goal seek tool)