WorksheetsU9 Modelling 9.1.5 Uses of computer models
Total questions: 41
Worksheet time: 35mins
What is one factor that affects the effectiveness of a spreadsheet model?
Human errors introduced by users
The color of the spreadsheet
The brand of the computer
The time of day it is used
What mistake was made at the 2012 Olympics regarding spreadsheet data entry?
Typing '2' instead of '1' and entering '20000' instead of '10000'
Using the wrong spreadsheet software
Forgetting to save the spreadsheet
Entering data in the wrong column
What is one key phase of producing a model?
Testing it to ensure it does what is intended
Printing it for review
Sharing it on social media
Deleting unnecessary data
What is important for companies to be able to do according to the text?
Make a profit
Hire more employees
Expand globally
Reduce working hours
What does the model in Morag's company help predict?
Profit
Weather
Employee satisfaction
Market trends
What feature of spreadsheets allows you to change variables easily?
What-if analysis
Color coding
Password protection
Data encryption
What does conditional formatting in spreadsheets help with?
Highlighting particular values
Changing the font style
Adding images
Creating charts
What is a benefit of using conditional formatting?
Seeing immediately which items are making a profit
Changing the background color
Increasing the font size
Adding more data
What is a potential outcome if a company produces too much of a product that doesn't sell?
Making a loss
Gaining more customers
Increasing market share
Improving brand image
What is one of the main uses of complex models in financial organizations?
To predict weather patterns
To illustrate historical events
To predict the number of products sold over time
To create art designs
What is the purpose of the Goal Seek facility in spreadsheets?
To design marketing strategies
To produce results showing the number of products to be sold for a specific profit
To create artistic graphs
To manage employee schedules
Spreadsheet software is often used to create (a) models. The
characteristics of spreadsheets which make them so suitable for this purpose
include the ability to (b) formulae throughout a model but also influence
this replication through the use of (c) and relative cell referencing. This
makes sure you only increment the parts of a formula you need to by using
relative cell (d) . The use of absolute cell referencing ensures that those
parts of the formula you wish to remain (e) do so.
Why might inexperienced employees use cell protection in spreadsheets?
To prevent unauthorized access
To avoid accidental changes to formulas or data
To enhance spreadsheet aesthetics
To increase processing speed
What is one way governments can use computer models?
To design new fashion trends
To see how much extra money would be raised by increasing taxes
To create music playlists
To manage social media accounts
What role do computer models play in environmental conservation?
They have no role
They help calculate maximum harvests
They increase resource consumption
They predict weather only
What is the main focus of a population-growth computer model?
Predicting weather
Predicting population changes
Predicting earthquakes
Predicting ocean currents
What is the impact of exponential growth on densely populated areas?
It has no impact
It makes them more densely populated
It reduces population density
It stabilizes population density
What is the main challenge in using computer models for weather forecasting?
Lack of data
Uncertainty of predictions
Too much data
Predicting earthquakes
What is the main focus of numerical weather prediction?
Predicting earthquakes
Predicting weather
Predicting ocean currents
Predicting wildlife patterns
What is the purpose of using computer models in weather forecasting?
To perform manual calculations
To predict weather conditions
To replace meteorologists
To eliminate the need for data collection
Why are some people skeptical about computer models in climatology?
They believe models are too accurate
They think models are too approximate
They think models are too expensive
They believe models are too simple
What does the Figure illustrate?
The relationship between service capacity and queuing cost
The effect of greenhouse gas emissions on climate
The accuracy of computer models in climatology
The number of variables in climate models
Queue management, sometimes referred to as ‘waiting line management’, is crucial
to many aspects of the service industry. The aim is to reduce the time customers
wait to be served and therefore improve the quality of the service provided. Queue
management deals with cases where customer arrival
is unpredictable and varies a great deal for different
times of the day.
What happens to the cost of waiting in line as service capacity increases?
It increases
It decreases
It remains the same
It fluctuates randomly
What mathematical technique is used to cover all possible eventualities in queue management?
Algebra
Differential equations
Geometry
Trigonometry
Queue management
Put these in order
Queue management theory also has to take into account the type of queue set-up in particular
situations. Some set-ups involve just one queue and one outcome, such as queuing at a drive-through
car wash. You have to wait for the car in front of you to be washed before you can drive your car
through. Some have one queue but several outcomes, such as at a fast-food drive-through where there
may be one queue of cars but you could be required to first place your order at one window then drive on
What factors affect the movement of traffic?
Weather conditions
Number of vehicles, lanes, and intersections
Road surface material
Type of fuel used by vehicles
What has been difficult to produce despite sophisticated computing power?
A general theory of traffic flow
A new type of vehicle
A faster road construction method
A universal road sign system
What is a disadvantage of using CAD software?
It is free to use.
It is always accurate.
It is expensive to update regularly.
It requires no training.
What is a key aspect of BIM according to the US National BIM Standard Project Committee?
Building information modelling
It is only for physical aspects.
It is a digital representation of physical and functional characteristics.
It is only for electrical aspects.
It is a manual drawing method.
Construction
Models are frequently used in the construction industry. The most common
type of software used is computer-aided design (CAD). It is used by architects
and engineers to create precise drawings or technical illustrations. CAD
software can be used to create two-dimensional (2-D) drawings or 3-D models.
CAD software is used to design structures such as bridges and buildings, and
can also be used to generate animations and other presentational material.
The software often allows for the inclusion of additional information, such as
dimensions and descriptions of components.
What does CAD stand for?
Why do we use simulations?
To create virtual reality games.
So people can learn something.
To test an idea in a controlled environment.
All of the above.
a representation of a real-world system, behavior, or event that uses a computer to simulate and study it
Conceptual Model
Math Equation Model
Graph Model
Computer Model
Are models perfect representations of every detail?
Yes
No
Do models prove things beyond a doubt?
Yes
No
Do models have limitations?
Yes
No
What are the benefits of CAD/CAM systems?
Increased speed and accuracy of production
Reduction in the cost of prototypes and molds
Increased design quality and flexibility
Reduced labor costs
What are the limitations of CAD/CAM?
High cost of software and hardware
Lack of flexibility in design
Difficulty in reversing designs
Lengthy process of programming CNC machines
What is the difference between CAD and CAM?
CAD is used to design components while CAM is used to machine them
CAD is used to program CNC machines while CAM is used to design components
CAD is used to produce drawings while CAM is used to create prototypes
CAD is used to analyze designs while CAM is used to control machines
