Computer – Based Economics using Excel
Learn how to use Excel to solve complex economic problems and gain in-demand digital skills. This course is designed for business students and teachers worldwide.
What you’ll learn
- 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
Business Students and Teachers at all levels worldwide
Business Graduates looking for employment worldwide
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
