SYLLABUS WITH EFFECT FROM : JUNE 2017

  • Course Code: PB01ACOM21
  • Title Of Paper: Computer Application in Business – I

OBJECTIVE:

To introduce the students with MS Excel which enable them to analyze and interpret of data for decision making and also enhance their skill based learning.

Unit Description of Detail Weighting(%)
I Introduction To Ms Excel-2007
Setting Up A Workbook: Creating Workbook, Modifying Workbook, Modifying Worksheet
Working With Data & Data Tables: Entering & Revising Data, Moving, Finding & Replacing Data, Correcting & Expanding upon Worksheet Data, Defining Tables
25%
II Performing Calculation on Data: Naming Group of Data, Creating Formulas to Calculate Values, Summarizing Data to Meet Specific Condition, Finding and Correcting Errors
Changing Documents Appearance: Formatting Cells, Defining Styles, Applying Workbook Theory & Table Styles, Making No. Easier to Read, Changing the Appearance of Data Based on its Value, Adding Images
25%
III Focusing on Specific Data Using Filters: Limiting the Data, Manipulating the Data, Defining the Valid Sets of Values for Ranges of Cells
Reordering & Summarizing Data: Sorting Data, Organizing Data, Looking up Information
Creating Dynamic Lists with Pivot Tables (Only Theory): Creating Dynamic Lists With Pivot Tables, Filter, Show & Hide the Pivot Table Data, Edit & Format Pivot Table Data
25%
IV Creating Charts: Create Charts, Customize the Appearance of The Charts ,Finds Trends in your Data
Printing: Adding of Headers and Footers, Prepare Worksheets for Printing, Prints Data List, Part of Data List & Charts
25%

BASIC TEXT BOOKS


  • Step-By-Step Microsoft Excel-2007 By Curtis D. Frye, Publish By Microsoft Press

Note:

  • Practicals are based on MS-Excel 2007.