US93997 – LP8 – Problem Solving (N3,Cr11,M8)

Current Status

Not Enrolled

Price

Closed

Get Started

This course is currently closed

Course Content

Expand All

US9012 Investigate life and work related problems using data and probabilities

Module 1: Investigate life and work related problems using data and probabilities 19 Lessons

Expand

Module Content

0% Complete 0/19 Steps

1.1. Investigate life and work related problems using data and probabilities

1.2. Problem Solving

1.3. Pose questions, collect and organise data

1.4. Identify variables contributing to a problem situation

1.5. Methods to collect, record and organise data

1.6. Types of questionnaires

1.7. Methods for calculating statistics

1.8. Adequate and representative data samples

1.9. Represent, analyse and interpret data to investigate real-life and work problems

1.10. Scatter diagram

1.11. Pie charts and frequency diagrams

1.12. Frequency polygons

1.13. Frequency and Frequency Tables

1.14. Compare different representations to take a position on the issue

1.15. Use random events to explore and apply probability concepts in simple life

1.16. Determine probabilities correctly

1.17. Use tree diagrams to represent and work with events

1.18. Theoretical vs. experimental probabilities

1.19. Communicate the outcomes of experiments and simulations

US116940 Use a Graphical User Interface (GUI)-based spreadsheet application to solve a given problem

Module 1: Use a Graphical User Interface (GUI)-based spreadsheet application to solve a given problem 22 Lessons

Expand

Module Content

0% Complete 0/22 Steps

1.1. Use a Graphical User Interface (GUI)-based spreadsheet application to solve a given problem

1.2. Work with MS Excel

1.3. Perform all elements within the laws of the country

1.4. Health and safety

1.5. Ethical codes of relevant professional bodies

1.6. Use MS Excel to adjust settings to customise the view and preferences to suit the solution created for the given problem

1.7. Enlarge and make the view of the spreadsheet smaller

1.8. Freeze cells to prevent scrolling

1.9. Change the default file location

1.10. Use MS Excel to work with multiple worksheets to suit the solution to the given problem

1.11. Rename worksheets in terms of their purpose within the solution to the given problem

1.12. Use MS Excel to apply formulae to provide alternative solutions to the given problem

1.13. Demonstrate the difference between relative and absolute cell addressing by using it in a formula

1.14. Create scenarios that demonstrate different possible outcomes

1.15. Use MS Excel to apply simple built-in functions to the given problem

1.16. Explain functions in terms of their purpose, use and construct

1.17. Apply simple mathematical functions to the given problem

1.18. Use MS Excel to apply formatting and special effects applicable to the given problem

1.19. Explain methods of automatically formatting a spreadsheet

1.20. Create a spreadsheet using a template

1 of 2