Bachelor of Arts (B.A.) Computer Applications in Economics II Syllabus - Mumbai University 2026
Syllabus for Computer Applications in Economics - II
The University sets this paper under Scheme II only, so your college may not run it.
Module 1: Introduction to Microsoft Word: ( 15 hours)
- text formatting, insert tab, create table and list, create and manage references, document properties, Mail Merge. Introduction to PowerPoint presentation: creating layouts, inserting objects, shapes, tables, pictures, inserting charts and graphs from Excel
Module 2: Introduction to MS Excel ( 15 hours)
- Spreadsheet basics, creating, editing, saving, and printing spreadsheets, working with functions and formulas, and graphically representing data. Charts & Graphs, speeding data entry: Using Data Forms, Filtering Data, formatting worksheets, VLOOKUP.
Module 3: Basic Statistics with Excel ( 15 hours)
- Measure of Central tendency: mean (arithmetic, geometric, and harmonic), Median (odd and even number of observations), and Mode (only Unimodal) Measure of Dispersion: Range (Maximum and Minimum), Variance, Standard Deviation, Quartile Deviation Case Study: Refer to the “Handbook of Statistics on Indian Economy” available from the RBI Website Install the RBI DATA App from the Google Play Store. -then select “Database on Indian Economy” and choose dataset(s) from the below-mentioned sectors: Real Sector, Financial Sector, Public Finance, External sector Macroeconomics Indicators (Tables 1 and 2), Employment (Table 14), Price Index (Tables 36 and 37), Money (Table 39), and Foreign Exchange (Tables 138 and 139)
Module 4: Application of Google Tools ( 15 Hours)
- Google tools: Google Forms, Google Sheets, Google Docs, Google Presentations and Google Collaboratory. Google search engine
References
- 1 Sharma J.K.: Business Statistics, 5/e Vikas Publishing
- 2 Ross Sheldon M. . : Introductory Statistics. 4th Edition, Academic Press
- 3 Levine M David. , Kathryn A. Szabat, David F. Stephan: “Business Statistics: A First Course” 7th edition, Pearson Education
- 4 Guerrero Hector: “Excel Data Analysis: Modeling and Simulation” –Springer
- 5 “Handbook of Statistics on Indian Economy” Reserve Bank of India (RBI) (Online Resource)
- 6 Kumar Bittu:“Mastering Microsoft Office”, V&S Publisher Kindle edition
- 7 Alexander Michael, Richard Kusleika: Microsoft Excel 365 Bible, Wiley (Digital and paperback)
- 8 Gabet Serge: “Google Apps Script for Beginners”, Packel Publishing
- 9 Joan Lambert: “Microsoft PowerPoint Step by Step”, MicrosoftPress
- 10 Ian Lamon“Google Drive & Docs In 30 Minutes”
- 11 Joan Lambert:“Microsoft Word Step by Step”, MicrosoftPress
- 12 Curtis Frye: Microsoft Excel Step by Step, MicrosoftPress