Looking for a Tutor Near You?

Post Learning Requirement ยป
x

Choose Country Code

x

Direction

x

Ask a Question

x

Hire a Tutor
Dubai

IB ITGS

Loading...

Published in: Software Testing
1,180 Views

This is an introduction to 3.8 Spreadsheet topic in strand 3 when studying IB ITGS. Also, a typical assignment leading the student through the main knowledge and understanding for the student to respond to.

Adam M / Dubai

12 years of teaching experience

Qualification: M.Sc in E-Commerce, Educational Leadership and Management, B.Sc in IT.

Teaches: Basic Computer, Coding & Programming, Robotics, ICT Training, MS Office, Computer Basics, Python, Computer Science

Contact this Tutor
  1. Lesson l: Introduction to topic Unit 3.8: Spread sheets, modelling & simulations Mr Masters
  2. 3.8 Intro to Topic Learning Objectives o Describe the basic functions and applications of spreadsheets and other types of statistical simulation programs. o Explain how computers can be used to answer what-if questions o Explain how computers are used as tools for simulating mechanical, biological and social systems.
  3. 3.8 Intro to Topic Introduction o Spreadsheet enables the Us er to take control of numbers, manipulating them in ways that WOUId be difficult or impossible otherwise. o A spreadsheet can make short work of tasks that involve repetitive calculations: budgeting, investment management, business projections, grade books, scientific simulations, check books and so on. o A spreadsheet can also reveal hidden relationship between numbers, taking much of the guesswork out of financial planning and speculation.
  4. 3.8 Intro to Topic Spreadsheet features o Lists o Replication o Formulas o Functions Macros O o Formatting o Validation o Linking o Database capabilities o Predefined functions o Automatic recalculation o Templates and wizards
  5. 3.8 Intro to Topic "What If?" Questions o Spreadsheet is especially for answering "what if?" questions. o It enables you to change numbers and instantly see the effect Of those changes. o Spreadsheet strearnlines the process of searching for answers to these questions. o Some programs include equation solvers that turn "what if?" questions around. E.g. an investor might use an equation solver to answer the question is the best mix Of these three stocks for minimising risk while producing a six percent return on my investment?
  6. 3.8 Intro to Topic Suitable chart types o Pie charts show the relative proportions of the parts to a whole. o Line charts are most often used to show trends or relationships over time or to show relative distribution of one variable through another. o Bar charts are similar to line charts, but they are more appropriate when data falls into a few categories. o Scatter charts are used to discover rather than display a relationship between two variables. A well-designed chart can convey a wealth of information just as poorly designed chart can confuse or mislead.
  7. 3.8 Intro to Topic Modeling & Simulations
  8. 3.8 Intro to Topic Modelling & Simulation o Computer modelling is the use of computers to create abstract models of objects, organisation, organisms and processes can be done with spreadsheets, mathematical applications or standard programming. o Examples include: o Business executive on profit and loss o An engineer testing bridge stress o A statistician examining data collected o A test pilot using it to test how a new plane will respond to human commands.
  9. 3.8 Intro to Topic Computer simulations (+) o Safety: Pilots safely learn to fly a plane and practise dangerous scenarios. Scientists COUId study the effects of a nuclear breakdown and its impact on the environment. o Ecomomy: Cheaper to produce a digital prototype of a car than build it from steel. o Projection: Biologists can quickly seek the population impacts of bacteria which WOUId take decades to realise.
  10. 3.8 Intro to Topic Computer simulations (+) o Visualisation: Computers make is possible to see relationships that might go unnoticed by researchers when looking at small particles. o Replication: An engineer can fine tune dimensions and angles to achieve peak Of medicine. An entrepreneur can test several business outcomes to make a hypotheses of what WOUId be the worst and best case scenario.
  11. 3.8 Intro to Topic 'Simulation isn't reality' Computer simulations GIGO: Garbage in, garbage out. When the O accuracy of a simulation depends on how closely mathematical model corresponds to the system simulated. o These models are built on assumptions, many of which are difficult or impossible to verify. o Some models suffer from faulty assumptions; others contain hidden assumptions that may not even be obvious to their creators; still other go astray simply because of clerical or human errors.
  12. 3.8 Intro to Topic 'Simulation isn't reality' Computer simulations Making reality fit the machine: simulations are O computation intensive. Some simulations are so complex that researchers need to simplify models and streamline calculations to get them to run on the best hardware available. o Information can be lost when the system is simplified and it is this simplification of reality is deliberate, the loss may compromise the integrity of the simulation and call the results in question.
  13. 3.8 Intro to Topic 'Simulation isn't reality' Computer simulations o Illusion of infallibility: risks can be magnified when people take computers too seriously. If you take generated reports over other sources of knowledge can lead to fatal errors that WOUId result in decision on thousands of jobs being costly. o Doctors use computer models to make life and death decisions involving new drugs and treatments. However, a supercomputer can generate and churn out to be an invaluable decision making-aid. The risk is that people who make decisions will rely too much on computers to make the decision.
  14. Using variables o All programs/Duck Game o Find out how to make the duck fly 3.8 Intro to Topic Duck Game VI .2 @ 2002 CGP (with so... File Help Front Leg Back Leg Back Wing Front Wing Body Bill Flap Speed Fly Exit
  15. 3.8 Intro to Topic Air pollution simulator o Using an interactive air pollution simulator to control the air quality in Smog City 2, you can see how individual choices, environmental factors, and different types of land use affect air pollution. o In Smog City 2 you are in charge - so whether your visit is a healthy or unhealthy experience depends on the decisions that you make. http://www.smogcity2.org

Need a Tutor or Coaching Class?

Post an enquiry and get instant responses from qualified and experienced tutors.

Post Requirement

Related PPTs

Upload PPTs

If you have your own PowerPoint Presentations which you think can benefit others, please upload on MyPrivateTutor. For each approved PPT you will get 100 Credit Points and 100 Activity Score which will increase your profile visibility.

Upload Now
Home > PowerPoint Slides > IB ITGS