Computer – Based Economics using Excel

Computer – Based Economics 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 level to 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 course provides them with the insight to uncover a new set of digital skills they need for employment and job security.

This “Computer – Based Economics” is demand-driven skill course that shows how to translate Economics Concepts into computer language to solve complex digital problems. Therefore, the central focus is how to learn Economics through computer. The objective of this course, “Computer – Based Economics”, is to equip every teacher and student in high school, college and university with demand driven digital skills and prepare them to meet the requirements in the job market.

In furtherance of this objective, Microsoft Excel has been chosen as a tool of teaching and learning of Economics through computer. Given that Microsoft Excel Spreadsheet is standard software used in commerce and industry across the globe, it is essential to teach teachers and students in their use as an integrated part of their courses.

What you’ll learn

• Learn how to use computer to forecast Demand and Supply and draw their Curves.

• Learn how to use computer to determine Elasticity of Demand and Supply in classroom and workplace.

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

• Learn how to use computer to solve Time Value of Money problems in classroom and workplace.

• Learn how to use computer to solve The Money Market problems in classroom and workplace.

• Learn how to use computer to solve Scarce Resource Allocation problems using Linear Programming in classroom and workplace.

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

The course comprises 8 chapters. Chapter 1 deals with Excel Basics. Chapter 2 deals with how to forecast Demand and Supply and draw their Curves. Chapter 3 covers Elasticity of Demand and Supply. Chapter 4 deals with The Theory of Production and Costs. Chapter 5 covers Time Value of Money. Chapter 6 covers The Money Market. Chapter 7 covers Scarce Resource Allocation using Linear Programming. Chapter 8 covers National Income Determination.

Course Content / Title

Chapter 1: Excel Basics

Lesson 1: How to use Keyboard

Lesson 2: How to use Goal Seek Tool for decision making

Lesson 3: How to use Data Table Tool for Sensitivity Analysis

Lesson 4: How to use Scenario Manager Tool for Scenario Analysis

Chapter 2: Demand and Supply Analysis

Lesson 1: How to forecast Demand

Lesson 2: How to draw Demand Curve

Lesson 3: How to derive Demand Equation

Lesson 4: How to forecast Supply

Lesson 5: How to draw Supply Curve

Lesson 6: How to derive Supply Equation

Chapter 3: Elasticity of Demand and Supply

Lesson 1: Price Elasticity of Demand

Lesson 2: Cross – Price Elasticity of Demand

Lesson 3: Income Elasticity of Demand

Lesson 4: Elasticity of Supply

Chapter 4: Production Theory

Lesson 1: Production

Lesson 2: Production Costs

Chapter 5: Time Value of Money

Lesson 1: Simple Interest Analysis

Lesson 2: Compound Interest Analysis

Lesson 3: Annuity Payments

Lesson 4: Mortgage Repayment Plan

Lesson 5: Retirement Planning

Lesson 6: Investment Planning

Lesson 7: Bank Loan Repayment Schedule

Chapter 6: The Money Market

Lesson 1: Velocity of Money

Lesson 2: Money in Circulation

Lesson 3: Printing Currency Money

Chapter 7: Scarce Resource Allocation using Linear Programming

Lesson 1: Formulation of Objective Function

Lesson 2: Installation of Linear Programming Solver

Lesson 3: Application of Linear Programming Solver in Profit Maximization Problems

Lesson 4: Application of Linear Programming Solver in Cost Minimization Problems

This Course includes:

• 6+ hours of 83 video tutorials (3 – 5 minutes each)

• 62 Spreadsheets on how to learn Economics through computer

• Certificate of Completion

Requirements

• The course requires laptop or desktop with Microsoft Window 2007, 2010, 2013 and above.

Target group

1. Business Students and Teachers at all levels worldwide

2. Business Graduates looking for employment worldwide

3. Accounts and Finance Officers and Managers

Course Tutor

ISAAC ALORMENU – MBA (International Finance) Brandeis University, USA – 2009

Who this course is for:

• Business Students and Teachers