B. Com.: Semester III
B.Com CBCS Department of Commerce, University of Delhi, Delhi
Objective: To provide computer skills and knowledge for commerce students and to enhance the student understanding of usefulness of information technology tools for business operations.
Contents
Unit I: Introduction
Introduction to Computer-Characteristics of Computers, The Computer System, Parts of Computers); Computer H/W Setup, Configuration, Networking, Mobile H/W Device and types wireless Networking; Operating System- Introduction to Operating Systems, An overview of various Computer & Mobile OS & Application (UN IX / Linux, DOS, Windows, Android, windows mobile, iOS Like), Features of latest Windows Operating Systems & its Management & Networking (Installation, backup, security, User control), Usage of payment gateways.
Unit II: Introduction to essential tools
Introduction to facilities & commonly used features of:
a) Word: Working with word document, Inserting, filling and formatting a table, Mail Merge including linking with Access Database, Creating Macros -Sending E-mail from Word Import / Export of files Converting Word Document to Web Document, PDF files Hyperlinks; OLE Security features in MS-Word - Protection of Documents - Password for Documents - Checking for viruses in macros, referencing, creating bibliography, manage sources and citations, review documents.
b) PowerPoint: Preparing Presentations, Slides, Handouts, Speaker’s Notes - Outlines - Media Clips - Charts - Graphs, Adding the Transitions to the Slide Show - Special effects in detail, - Setting Slide timings.
c) Spreadsheet: Creating a work book, Rearranging Worksheet, Organizing Charts and graphs, Ranges and Functions & Formulae: Mathematical, Statistical Financial Functions such as NPV (Net present value), Future value, IRR (Internal Rate of Return), EMI (Equated Monthly Installments, Compounding Yearly, periodic and monthly) - Auto Calculate Using Names in a Formula, Formula Editing, Consolidation of Data & Data Analysis - Sorting List, Filter & More Filtering Techniques - Consolidate data in multiple worksheets - What-if analysis, Goal Seek Scenario Manager, Solver, Lookup Function - Sub Totals, Nested-IF, Statistical Analysis; Data Validation & Protection - Create a drop-down list from a range of cells - Apply data validation to cells - Copy data validation setting, remove data validation - Find cell that have data validation, protect cell data, using password to protect sheet and workbook. - Use validation to create dependent list; Pivot table Reports & Pivot Chart Reports.
Unit III: Using Spreadsheet for Data Analysis & Reporting Features
Using spreadsheet for following purposes and making reports: Loan & Lease statement, Ratio Analysis, Payroll statements, Capital Budgeting, Depreciation Accounting, Graphical representation of data, Frequency distribution and its statistical parameters. Correlation and Regression
Unit IV: Database Designs for Accounting and Business Applications
Reality- Expressing the Application; Creating Initial design in Entity Relationship(ER) Model; Transforming ER Model to Relational data model concepts; Implementing RDM design using an appropriate DBMS.
SQL and Retrieval of Information: Basic Queries in SQL; Embedded Queries in SQL; Insert, Delete and Update statements in SQL
DBMS Software: Environment; Tables; Forms; Queries; Reports; Modules; Applying DBMS in the areas of Accounting, Inventory, HRM and its accounting, Managing the data records of Employees, Suppliers and Customers.
Unit V: CAAT Tools
Capabilities & Importing Data from Accounting & other Application Systems - An Introduction; Analytical Reports, Duplicates/ Gaps. Sorting & Charting; Stratification, Summarization, Statistics & Aging - An Introduction; Sampling, Macros and Audit Trail.
Notes:
1. There shall be a practical examination of 50 Marks (Practical-35 Marks, Viva-5 Marks and Work Book- 10 Marks) and duration of Examination shall be 3 Hrs.
2. Teaching arrangements need to be made in the computer lab only.
3. There shall be 2 Lectures per class and 4 Practical periods per batch to be taught in computer Lab.
B.Com CBCS Department of Commerce, University of Delhi, Delhi
Objective: To provide computer skills and knowledge for commerce students and to enhance the student understanding of usefulness of information technology tools for business operations.
Contents
Unit I: Introduction
Introduction to Computer-Characteristics of Computers, The Computer System, Parts of Computers); Computer H/W Setup, Configuration, Networking, Mobile H/W Device and types wireless Networking; Operating System- Introduction to Operating Systems, An overview of various Computer & Mobile OS & Application (UN IX / Linux, DOS, Windows, Android, windows mobile, iOS Like), Features of latest Windows Operating Systems & its Management & Networking (Installation, backup, security, User control), Usage of payment gateways.
Unit II: Introduction to essential tools
Introduction to facilities & commonly used features of:
a) Word: Working with word document, Inserting, filling and formatting a table, Mail Merge including linking with Access Database, Creating Macros -Sending E-mail from Word Import / Export of files Converting Word Document to Web Document, PDF files Hyperlinks; OLE Security features in MS-Word - Protection of Documents - Password for Documents - Checking for viruses in macros, referencing, creating bibliography, manage sources and citations, review documents.
b) PowerPoint: Preparing Presentations, Slides, Handouts, Speaker’s Notes - Outlines - Media Clips - Charts - Graphs, Adding the Transitions to the Slide Show - Special effects in detail, - Setting Slide timings.
c) Spreadsheet: Creating a work book, Rearranging Worksheet, Organizing Charts and graphs, Ranges and Functions & Formulae: Mathematical, Statistical Financial Functions such as NPV (Net present value), Future value, IRR (Internal Rate of Return), EMI (Equated Monthly Installments, Compounding Yearly, periodic and monthly) - Auto Calculate Using Names in a Formula, Formula Editing, Consolidation of Data & Data Analysis - Sorting List, Filter & More Filtering Techniques - Consolidate data in multiple worksheets - What-if analysis, Goal Seek Scenario Manager, Solver, Lookup Function - Sub Totals, Nested-IF, Statistical Analysis; Data Validation & Protection - Create a drop-down list from a range of cells - Apply data validation to cells - Copy data validation setting, remove data validation - Find cell that have data validation, protect cell data, using password to protect sheet and workbook. - Use validation to create dependent list; Pivot table Reports & Pivot Chart Reports.
Unit III: Using Spreadsheet for Data Analysis & Reporting Features
Using spreadsheet for following purposes and making reports: Loan & Lease statement, Ratio Analysis, Payroll statements, Capital Budgeting, Depreciation Accounting, Graphical representation of data, Frequency distribution and its statistical parameters. Correlation and Regression
Unit IV: Database Designs for Accounting and Business Applications
Reality- Expressing the Application; Creating Initial design in Entity Relationship(ER) Model; Transforming ER Model to Relational data model concepts; Implementing RDM design using an appropriate DBMS.
SQL and Retrieval of Information: Basic Queries in SQL; Embedded Queries in SQL; Insert, Delete and Update statements in SQL
DBMS Software: Environment; Tables; Forms; Queries; Reports; Modules; Applying DBMS in the areas of Accounting, Inventory, HRM and its accounting, Managing the data records of Employees, Suppliers and Customers.
Unit V: CAAT Tools
Capabilities & Importing Data from Accounting & other Application Systems - An Introduction; Analytical Reports, Duplicates/ Gaps. Sorting & Charting; Stratification, Summarization, Statistics & Aging - An Introduction; Sampling, Macros and Audit Trail.
Notes:
1. There shall be a practical examination of 50 Marks (Practical-35 Marks, Viva-5 Marks and Work Book- 10 Marks) and duration of Examination shall be 3 Hrs.
2. Teaching arrangements need to be made in the computer lab only.
3. There shall be 2 Lectures per class and 4 Practical periods per batch to be taught in computer Lab.
