Vikas MADAN

Snail Mail

Assistant Professor
Department of Computer Science
Shri Ram College of Commerce
University of Delhi
Delhi - 110085 INDIA

E-Mail

vikasmadan.srcc@gmail.com (primary)
vikas.madan@srcc.du.ac.in (rarely checked)

Tel: +91-11-2766-7905

Cell: +91-11-98993-23136

B.Com. (H) CBCS Paper: Computer Applications in Business (BCH 4.3)
Week Date Class Date & Topic Notes Presentations Questions
102/01/2017 1,2 02/01/2017
Course Introduction & Warming Up		 N1 P1 Q1
03/01/20173,4 Unit I - Introduction to Computer
Topics of this unit will be covered either in the power point presentation section or in the end
Unit II - Introduction to Essential Tools
Advanced Features of Word - Page - orientation, margins; Fonts, Paragraph, Indentation, Drop Cap, Columns, Text Vertical Orientation, Pictures, Tables, Styles - headings 1, 2, 3 .. , normal etc., Hyperlinks, Equations, Special Symbols, Documents with Multiple Sections 		N2 P2 Q2
04/01/2017
6/01/2017		5,6 Professional Documentation - Headers, Footers, Page Numbering, Table of Contents, Headings, References- footnote, endnote, citations, bibliography, Reviewing documents - P3 Q3
209/01/20177,8 Mail Merge - Creating multiple letters/envelops/emails etc. Using mail merge while data is stored externally - in text files, excel files, access files - - Q4_Partial
210/01/20179,10 Utilities Operations, Macros & Secuirity - Importing data from other files, Saving/Exporting Word documents for different versions, text file, pdf, web documents; Creating macros; Securing Documents: Password protection for documents, OLE security features, Checking & removing viruses in macros N5 - Q5
11/01/2017
13/01/2017		11,12 Leftovers from Word - Charts & drawings. Practice
- - -
14/01/201711,12 PowerPoint
Preparing Presentations, Slides, Media clips, Charts - Graphs		 - - Q6
316/01/201713,14 Speaker Notes, Outlines, Handouts - - -
17/01/201715,16 Special Effects in detail - Setting Slide timings, Adding the transition to slide view show - - -
18/01/201717 C-Spreadsheet:
Creating a workbook, Rearranging Worksheet, Formula - writing formula, making formula generic , editing formula. 		- - Q8
20/01/201718 20/01/2017 - FDP - Day 1 - - -
21/01/201719,20 20/01/2017 - FDP - Day 2 - - -
423/01/201721,22 Types of addressing 23/1/2017
Writing formula using mathematical opertors, functions, ranges, named ranges, Writing formula in vector mode.
Functions Explained: - Syntax of functions, Parameters, Calling of Vector functions
23/1/2017
Mathematical Functions: ABS, EXP, LN, RANDBETWEEN, RAND, ROUND, ROUNDUP, ROUNDDOWN, SQRT, SUM, SUMIF, SUMSQ, TRUNC, SUBTOTAL
 - - Q9
24/01/201723,24 24/01/2017
Logical Functions: AND, NOT, OR, IF,
Lookup Functions: VLOOKUP, HLOOKUP
 - - Q10
Q11
25/01/2017
27/01/2017		25,26 25/01/2017
27/01/2017 		- - -
28/01/201727,28 Statistical Functions:
28/01/2017 - MIN, MAX, LARGE, 		- - Questions
SkeletonAttendanceSheet
530/01/201729,30 30/01/2017 - COUNTA, COUNT, COUNTBLANK, - - -
Unit III - Using Spreadsheet for Data Analysis & Report Features
31/01/201731,32 31/01/2017 - COUNTIF, - -
01/02/2017
03/02/2017		33,34 01/02/2017 - FREQUENCY,
03/02/2017 - AVERAGE(MEAN), MEDIAN, MODE, VAR, CORREL, STDEV, 		- -
04/02/201735,36 On Leave - - -
606/02/201737,38 On Leave - - -
07/02/201739,40 SLOPE, INTERCEPT, KURT - - -
08/02/2017
10/02/2017		41,42 - - -
11/02/201743,44 - - -
713/02/201745,46 13/02/2017
Graphical Representation of Data - Visualization - Tables & Pictorial representations,
Basic Structure of a chart - Horizontal Axis, Vertical Axes - for one or multiple data sets.
Process of Creating a Chart - 1) Expanded Method 1) Quick method
Types of charts - Pie, Column (Default, Stacked, 100% stacked), Bar(Default, Stacked, 100% stacked), Pareto Chart, Line and Stock Charts , Box and Whisker Chart
Additional elements on Charts - Data Values, Data tables, Error Bars, Droplines, Trendlines, Text Boxes, Pictures etc.
Layout and Designs of Charts		 - - ChartsDemo (Not Avaialable)
14/02/201747,48 14/02/2017
Other Charts - Histogram (Column Chart of Frequency Data), Scatter, Area, Surface, Radar, Combo, Pivot(To be done later)
Sparklines
Conditional Formatting
Complex Charts - Parts of Scatter line in different color, Grouped horizontal axis, Something else in place of columns, PERT Chart, Butterfly chart, Customer Arrival Chart, Depreciation Accounting,		 - - -
15/02/2017
17/02/2017		49,50 15/02/2017
Pivot Tables & Charts
1. Structure of a Pivot Table - Category, Row, Column, Value
2. Summarizing on different fields - Taking different Fields to different parts of a Pivot Table
3. Summarizing over user created groups
4. Filter pivot table for values that match some numerical criterion
5. Adding new filds in to a pivot table - e.g % of Total, calculated fields
6. Pivot Table as Frequency distribution summary

17/02/2017
Financial Functions: - Compound Interest
 - - -
18/02/201751,52 Financial Function-
1.Time Value of Money- FV, PV, RATE, NPER, PMT		 - - Questions
820/02/201753,54 90th Year Celeberation Inaugration - - -
21/02/201755,56 Contd.. with Time Value of money functions - - -
22/02/2017
24/02/2017		57,58 22/02/2017
24/02/2017 - Holiday due to Shivratri 		- - -
25/02/201759,60 Financial Function -
2.Components of Annuity- PPMT, IPMT, ISPMT
3.Cummulative Components Value of Annuity - CUMPMT, CUMIPMT		 - - -
927/02/201761,62 Financial Functions -
4.Capital Budgeting - NPV, IRR, MIRR, XNPV, XIRR		 - - -
28/02/201763,64 Financial Functions - 5.Depreciation: - DB, DDB, SLN, SYD, VBD
 - - -
01/02/2017
03/02/2017		65,66 01/02/2017 - Sorting, Filtering, Consolidating Data. Data Validation & Protecting worksheet and cells - - -
04/03/201767,68 What-If Analysis - Goal Seek, Data Table and Scenario Manager Notes - Questions
1006/03/201769,70 Cross Road - - -
07/03/201771,72 Cross Road - - -
08/03/2017
10/03/2017		73,74 Cross Road
Post-CrossRoad Holiday		 - - -
11/03/201775,76 To Be rescheduled - - -
1113/03/201777,78 Holi - - -
14/03/201779,80 Mid-Sem Break - - -
15/03/2017
17/03/2017		81,82 Mid-Sem Break - - -
18/03/201783,84 Mid-Sem Break - - -
1220/03/201785,86 Solver Notes - Questions
21/03/201787,88 Payroll Computation (Selected Problems) Notes - Questions
22/03/2017
24/03/2017		89,90 Loan Amortization (Selected Problems) - - -
25/03/201791,92 Frequency Distribution, Regression (Selected Problems)
Ratio Analysis (Self Study)		 - - -
Unit IV - Database Design for Accounting and Business Applications
1327/03/201793,94 Class Test - - -
28/03/201795,96 Reality - Expressing the Application; Creating Initial design in Entity Relationship Model; - - Questions_Draft
29/03/2017
31/03/2017		97,98 Transforming ER Model to Relational data model; - - -
01/04/201799,100 Creating Tables, Defining Primary Key, Seeting Properties, Creating Relationships - - -
1403/04/2017101,102 TBD - - -
04/04/2017103,104 TBD - - -
05/04/2017
07/04/2017		105,106 TBD - - -
08/04/2017107,108 TBD - - -
1510/04/2017109,110 TBD - - -
11/04/2017111,112 TBD - - -
12/04/2017
14/04/2017		113,114 TBD - - -
15/04/2017115,116 TBD - - -
1610/04/2017117,118 TBD - - -
11/04/2017119,120 TBD - - -
12/04/2017
14/04/2017		121,122 TBD - - -
15/04/2017123,124 Last Class Revision to follow - - -
Solver,
Loan and Lease statement,
Ratio Analysis,
Payroll Computation,
Frequency distribution and its statistical parameters,
Correlations and regression.
Unit IV - Database Design for Accounting and Business Applications
702/01/201749,50 Reality - Expressing the Application; Creating Initial design in Entity Relationship Model; - - -
02/01/201751,52 Transforming ER Model to Relational data model; - - -
02/01/201753,54 Implementing RDM design sing an appropriate DBMS - - -
02/01/201755,56 SQL and Retrieval of Information - Basic Queries in SQL; - - -
802/01/201757,58 Embedded Queries in SQL; Insert Delete and Update statements in SQL. - - -
02/01/201759,60 DBMS Software: Environment Tables; Forms; Queries; Reports; Modules; - - -
02/01/201761,62 Applying DBMS in the areas of Accounting, - - -
02/01/201763,64 Applying DBMS in the areas of Inventory, HRM and its accounting - - -
902/01/201765,66 Managing the data records of Employees, Suppliers and Customers. - - -
02/01/2017 Unit V - CAAT Tools
02/01/201767,68 Capabilities and Importing Data from Accounting and other Application Systems" - - -
02/01/201769,70 An introduction; analytical reports, duplicates/Gaps, - - -
02/01/201771,72 Sorting and Charting - - -
1002/01/201773,74 Statistics - - -
02/01/201775,76 and Aging - An introduction , sampling Macros, and Audit Trail. - - -
02/01/201777,78 - - - -
02/01/201779,80 - - - -
1102/01/201781,82 Practice - - -
02/01/201783,84 - - - -
02/01/201785,86 - - - -
02/01/201787,88 - - - -
1202/01/201789,90 - - - -
91,92 - - - -
93,94 - - - -
95,96 - - - -
97,98 - - - -
99,100 - - - -