3.8+Spreadsheets+modelling+and+simulations

=3.8 Spreadsheets, modelling and simulations=

• 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 • 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)
 * //Theoretical and practical concepts for spreadsheets //**

• Model • Simulation • Types of simulations and models • Virtual reality, augmented reality, gaming: for example, MMORPG (massively multiplayer online roleplaying game) • Graphics and animations (2D, 3D) <span style="font-family: 'Arial','sans-serif'; font-size: 13px;">• Visualization of data <span style="font-family: 'Arial','sans-serif'; font-size: 13px;">• Feedback loop
 * //<span style="font-family: 'MyriadPro-BoldIt','sans-serif'; font-size: 13px;">Modelling and simulation technologies and considerations //**

<span style="font-family: 'Arial','sans-serif'; font-size: 13px;">• The validity of the model and verification of the results of a simulation, reproducibility of results <span style="font-family: 'Arial','sans-serif'; font-size: 13px;">• Relationship of model to reality <span style="font-family: 'Arial','sans-serif'; font-size: 13px;">• Relationship between a model and a simulation
 * //<span style="font-family: 'MyriadPro-BoldIt','sans-serif'; font-size: 13px;">Developing and using models and simulations //**