Excel workshop_new

EXCEL WORKSHOPFOR ECONOMICS TEACHERSIN BUSINESS SCHOOLS Organized by L A V A S A ,P U N E ,I N D I A

MotivationThe use of economic principles and thinking have numerous applications in business and policy making. However theusefulness of these are critically influenced by the ability to quantify economic phenomenon. Inherent abstraction of theconcepts, archaic teaching materials and pedantic pedagogy pose serious challenges in effective delivery of economics in aBusiness School class room. However, the ability of class participants to visualize complex economic phenomena can beaugmented substantially with the help of technology. The interactive games and simulations in economics are aimed at makingthe learning more interesting.Working with economic data and economic model building have traditionally been the home turf of econometricians. Howeverdata and models can be extensively applied in teaching subjects like micro and macroeconomics. Such an approach can makethe classroom transactions more interesting and meaningful. The use of spreadsheets in teaching economics can make theteaching learning process more hands on, an aspect which is yet to gain acceptance in economics education. The workshop isconceived to promote excel based economics teaching and learning, which we hope will help in activating a data basedapproach to economic thinking.PurposeThe workshop intends to introduce excel templates and functions that can be helpful while teaching concepts in micro andmacroeconomics. The two day workshop will start with a quick brain storming session on the teaching challenges related tospecific economic concepts, and how some of those can be addressed using excel. At the end of the second day of theworkshop the participants will have created their own libraries of excel functions that can be used in a standard economicscurriculum in Business Schools. The major objectives are: Take stock of challenges in introducing economics concepts in Business School Education Introduce advanced excel applications for teaching economics Create own library functions for teaching economics Build dynamic excel templates that can be deployed while teaching economicsPedagogyThe workshop will be led by the resource person(s) for each session. Each session will start with a basic review of theeconomic concepts followed by excel application/introduction to templates for the same. The sessions will be conceptually andcomputationally intensive. The workshop sessions will have individual as well as group tasks to finish.Highlights of the work shop: Hands on training on financial and mathematical functions in Microsoft excel 2007 or later version Applications of Solver and Scenario Planning Introduction to VBA Introduction to Excel Dashboards Integration of Excel workbook with online economic data sources Training on conducting examinations in excel

Dates VenueMay 25 and 26 Christ Institute of Management2017 Lavasa, Pune REGISTRATION DETAILSREGISTRATION FEE The fee covers course material, meals (breakfast, lunch and dinner) and coffee on workshop days.Rs.8,000/- The participants will also have an option for boating in the beautiful Lavasa Lake.(Rupees Eight Thousand only) PAYMENT MODEPay TM 7264851230Bank Transfer South Indian Bank, Lavasa Branch A/C No. 0919053000000001 IFSC: SIBL0000919 State Bank of India, Lavasa Branch A/C No. 033701600928 IFSC: SBIN0014242Demand Draft DD drawn in favor of Christ Institute of Management payable at Lavasa.Accommodation: Rs. 750/- per night per participant (AC accommodation on twin sharing basis.) EARLY BID OFFER: There will be a 20 percent off on registrations before April 15.Cancellation Rules Workshop intake capacity Prior reading materialParticipants who wish to As this is a hands on workshop, The registered members willcancel their registration may maximum number of receive essential reading materialdo so without any penalty participants is limited to 30. 15 days prior to the workshop. It isbefore May 5th. Participants will be accepted on expected that the participants goAll cancellations after May first come first admit basis. through the material thoroughly5th will receive fifty percent of Maximum number of before attending the workshop tothe registration fees. participants that can be allowed make the transactions more from an institute is three. meaningful.

PARTICIPANT PROFILEThe ideal participant has finished a Master's programme in economics and have at least two years of experience teachingeconomics in a Business management programme at the undergraduate or postgraduate level. The participant will need to beconceptually strong. No particular background in mathematics or excel is assumed. INSTRUCTOR PROFILEBinu P Paul MBE, Ph.D.Prof. Paul is Associate Professor and Head of Academics at Christ Institute of Management Lavasa. His teaching interestsinclude Macro and Micro Economics, Operations Research, Statistics, Econometrics, Marketing Research, and certainaspects relating to Business Analytics. He was formerly Associate Professor at Christ University in their MBA programme. Hehas also worked as Senior Research Analyst at Frost and Sullivan's Economic Research and Analytics Team, and has alsoworked as Research Associate at Center for Study of Social Exclusion and Inclusive Policy (CSSEIP), International Center forEconomic Policy and Analysis (ICEPA) at Cochin University of Science and Technology. He finished his Master in BusinessEconomics and PhD in Applied Economics from Cochin University of Science and Technology.Mahidhara Davangere V. MBA, MFC, MSc (Maths), Associate Actuary (UK)Mahidhara is the Founder and Managing Director of Pramartha – an Actuarial Risk Management and Consulting firm.Pramartha is started in 2010 today has offices across (6 countries),i.e besides India, in Australia, South Africa, Malaysia, UAEand United States. Prior to this he has over 13 years of extensive experience in Research and financial valuation coveringindustries like Banking, Insurance and financial sectors in India, South Africa and other emerging African markets. Prior tostarting his own firm he worked in Citi Bank, Ocwen and Atom Funds Management (Australia). Mahidhara is a Board memberrepresenting Asia for Finance and Investment Board of Institute and Faculty of Actuaries (IFoA), UK. He is involved with invarious regulatory boards overlooking policies and frameworks. He was the Vice Chair for the recently conducted IFoA AsiaConference 2016 in Kuala Lumpur and Upcoming IFoAAsia conference 2017 in Hongkong. Mathematical Advisor in ScientificReview Committee, a National level Committee set up by Department of Science and Technology, Government of India andIntel to promote innovation in Basic Science and Maths. He was the Regional Co-ordinator for ASEAN Countries andBangladesh during Indian Science Congress 2014.

WORKSHOP CONTENTD AY-1Micro Economics (Concepts) Advanced review of Demand and Supply in the context of Marketing Decisions Review of Market structures in the context of industry performance Micro economics as a primer to strategic managementMicro Economics (Excel Applications Hands on) Data handling and chart building for marketing decisions using demand and supply data Application of regression for demand forecasting Solver applications for calculating equilibrium Dashboard creation for demand management decisions Solver applications for optimizing advertisement spendingD AY-2Macro Economics (Concepts) Primer on ISLM model as a framework for long term decision making Advanced review of product market components in greenfield investment decisions Advanced review of money market components while making capital sourcing decisionsMacro Economics (Excel Applications Hands on) ISLM excel template creation using VBA Solver applications in calculating money market and product market equilibrium Essential financial functions for money market calculations Application of Goal Seek and Scenario planning in macroeconomic decision making