IBDP Computer Science: Modelling and Simulation

What is a computer model?

• A realistic 3D representation of objects
• A program developed to mimic the way a system works in real life
• A digital image
• A physical model used for educational purposes

Which of the following is NOT an advantage of computer modeling?

• To get to be able to play with Spreadsheets

• Creates physical systems for real

• To tdo what-if analysis

• To predict future system behavior

Which is if right Spreadsheet if formula?

• =if(A3>66 then "Good" else "Poor")

• =if(A3>66,"Good","Poor")

• IF A3>66 THEN

  "Good"

  ELSE

  "Poor"

  ENDIF

• if A3>66,"Good","Poor"

Why might a computer model produce inaccurate results?

• It always re-creates real-life situations perfectly
• It depends on the quality of the model and data used to create it
• Models do not use mathematical formulas
• They are less expensive than real-life experiments

What are variables in a spreadsheet model?

• Fixed values that never change
• Text descriptions of operations
• Identifiers associated with particular cells holding values
• Only formulas and functions

Which of the following is a limitation of spreadsheet modeling?

• They cannot use graphs and charts for outputs
• They can accurately predict all future events
• Some models might not include all possible variables, like air resistance
• They do not allow for what-if analysis

The formula "=A7*B4" in a spreadsheet model indicates what operation?

• Addition
• Division
• Multiplication
• Subtraction

Which of the following is NOT a feature of spreadsheet models?

• They can only process text data
• Use of formulas to describe rules
• Capability for what-if analysis
• Output can include graphs and charts

In a spreadsheet, what does a $ in a cell reference indicate?

• The cell contains a dollar value
• The cell will be copied without altering its reference
• It marks the cell for deletion
• It indicates a formula error

What is a key difference between models and simulations?

• Models use computer graphics, while simulations are mathematical
• Models represent behavior at a snapshot in time, while simulations run over a time period
• Simulations are used exclusively for educational purposes
• Only models can use random numbers