Computer-Based Mathematics using Excel

COMPUTER-BASED MATHEMATICS USING EXCEL

Employers around the globe are demanding digital skills especially excel spreadsheet skills in the employment process. These changing requirements of the job market have seen the emergence of a gap between the knowledge generated by the traditional learning management system (LMS) and the skills required by employers worldwide.

The need for graduates from high school, college and university to start jobs with demand driven digital skills is therefore becoming more of a prerequisite for employment all over the world.

This “Computer - Based Mathematics using Excel” is a demand - driven skill course that shows how to translate mathematical formulas into computer language to solve complex digital problems across the globe. Therefore, the central focus is how to learn mathematics through computer. The objective of this course is to equip every educator and student in every school with digital skills and prepare them for employment by showing them how to learn mathematics through computer.

This Skill – Based Course across oceans fosters students’ employability and promotes internationalization by removing obstacles to mobility of labor. The course also strengthens professional development of educators and enable them create blended learning environment.

The course comprises 10 chapters. Chapter 1 provides the Excel Basics that covers Goal Seek, Data Table, Scenario Manager and Data Validation Tools, IF and V-Lookup Functions most frequently used in corporate world. Chapter 2 is step by step computer-based approach to solving Statistics problems. It covers basic Statistics, Binomial Distribution, Poison Distribution, Normal Distribution, T-test, Chi-test, Regression, and Multiple Regression analysis. Chapter 3 deals with Probability Distribution and chapter 4 covers Plane Geometry. Chapter 5 outlines how to use computer to solve Bearings and Vectors problems. Chapter 6 deals with how to use computer language to solve Simultaneous Linear equation with Matrix Operations. Chapter 7 deals with how to use computer language to solve Quadratic Equation problems. Chapter 8 covers Trigonometry. Chapter 9 deals with Logical Reasoning. Chapter 10 deals with Linear Programming using Solver.

This Course includes:

• 7 hours 33 minutes of 77 video tutorial clips (5 – 6 minutes each)

• 80 Spreadsheets on how to learn Mathematics through computer

• Certificate of Completion

  
  

What you'll learn

• Learn Excel Basics Skills required by Employers Worldwide

• Learn how to use computer to solve Statistics problems in classroom and workplace.

• Learn how to use computer to solve Probability Distribution problems in classroom and workplace.

• Learn how to use computer to solve Plane Geometry problems in classroom and workplace.

• Learn how to use computer to solve Bearings and Vectors problems in classroom and workplace.

• Learn how to use computer to solve Simultaneous Linear Equation problems in classroom and workplace.

• Learn how to use computer to solve Quadratic Equation problems in classroom and workplace.

• Learn how to use computer to solve Trigonometry problems in in classroom and workplace.

• Learn how to use computer to solve Logical Reasoning problems in classroom and workplace.

• Learn how to use computer to solve linear programming problems in classroom and workplace

Requirements

• Requires laptop or desktop with Microsoft Window 2007, 2010, 2013 and above.

Course Content / Title

Chapter 1 – Introduction Excel basics

Lesson 1: How to use keyboard

Lesson 2: How to use computer to convert unit of measurement

Lesson 3: How to use computer to mark and grade class test, homework and examination

Chapter 2 – Statistics

Lesson 1: How to use computer to determine arithmetic, geometric, harmonic mean.

Lesson 2: How to use computer to determine median, mode, standard deviation, upper & lower quartile, and percentiles.

Lesson 3: How to use computer to solve frequency problems

Lesson 4: How to use computer to solve binomial and poison distribution problems

Lesson 5: How to use computer to solve normal distribution problems

Lesson 6: how to use computer to solve Regression problems

Lesson 7: How to use computer to solve student t-test distribution problems

Lesson 8: How to use computer to solve Chi-test distribution problems

Course 3 - Probability distribution

Lesson 1: How to use computer to solve uncertainty problems

lesson 2: How to use computer to solve resource allocation problems

Chapter 4 - Plane Geometry

Lesson 1: how to use computer to solve Circle problems

lesson 2: how to use computer to solve Cylinder problems

Lesson 3: How to use computer to solve Pyramid and other Plane Geometry problems

Chapter 5 - Bearings and Vectors

Lesson 1: How to computer to convert radians (number) to degrees and vice versa

Lesson 2: how to use computer to determine the component form of velocity

Lesson 3: How to use computer to determine bearings of a plane

Course 6 - Simultaneous Equation

Lesson 1: How to use computer under matrix operations for simultaneous equations

Lesson 2: How to use computer to solve resource allocation problems

Chapter 7 - Quadratic Equation

Lesson 1: How to use computer to solve Quadratic Equation problems

Lesson 2: How to use computer to graph Quadratic Equation Function

Chapter 8 – Trigonometry

Lesson 1: How to use computer to find height of a building

Lesson 2: How to use computer to determine angle of elevation of a building

Chapter 9 - Logical Reasoning

Lesson 1: How to use computer for employees’ performance analysis

Lesson 2: How to use computer for performance – based commission

Lesson 3: How to use computer for special discounts

Chapter 10 - Linear Programming

Lesson 1: How to use computer to formulate linear programming Matrix Table

Lesson 2: How to use computer to determine Cell Reference values

Lesson 3: How to install Linear Programming Solver

Lesson 4: How to use Solver to solve Profit Maximization problems

Lesson 5: how to use Solver to solve Cost Minimization problems

Target group

1. Educators and Students at all levels worldwide

2. Graduates looking for employment worldwide

3. Workers who want to secure their jobs in the midst of digital technology