PC Software– 1 [BCA -105] Syllabus BCA 1st-I Sem Syllabus for DAVV Indore Affiliated Institutions

 DEVI AHILYA VISHWAVIDYALAYA (DAVV), INDORE

Bachelor Of Computer Applications (BCA) (Full-Time) 
First-1st-I Semester Curriculum/ Syllabus 2011-12 Academic Year Onwards

PC Software–  Syllabus 

PC Software [BCA – 105] Syllabus /Course contents

Objective : The objective of this course is to give knowledge about the basic of a computer and its application

Examination : The external examination will be of 50 marks. The question paper will contain questions equally distributed in all units. The balance will be maintained by including appropriate (numerical/objective/conceptual/analytical/theoretical) combination of subsection in each question.

UNIT I

MS-Windows: Operating system-Definition & functions, basics of Windows. Basic components of windows, icons, types of icons, taskbar, activating windows, using desktop, title bar, running applications, exploring computer, managing files and folders, copying and moving files and folders. Control panel – display properties, adding and removing software and hardware, setting date and time, screen saver and appearance. Using windows accessories.

UNIT II

Documentation Using MS-Word - Introduction to Office Automation, Creating & Editing Document, Formatting Document, Auto-text, Autocorrect, Spelling and Grammar Tool, Document Dictionary, Page Formatting, Bookmark, Advance Features of MS-Word-Mail Merge, Macros, Tables, File Management, Printing, Styles, linking and embedding object, Template.

UNIT III

Electronic Spread Sheet using MS-Excel - Introduction to MS-Excel, Creating & Editing Worksheet, Formatting and Essential Operations, Formulas and Functions, Charts, Advance features of MS-Excel-Pivot table & Pivot Chart, Linking and Consolidation.

UNIT IV

Database Management using Excel-Sorting, Filtering, Table, Validation, Goal Seek, Scenario.

UNIT V

Presentation using MS-PowerPoint: Presentations, Creating, Manipulating & Enhancing Slides, Organizational Charts, Excel Charts, Word Art, Layering art Objects, Animations and Sounds, Inserting Animated Pictures or Accessing through Object, Inserting Recorded Sound Effect or In-Built Sound Effect.

Text Book

Learn Microsoft Office – Russell A. Shultz – BPB Publication

References Books

1. Microsoft Office – Complete Reference – BPB Publication

2. Courter, G Marquis (1999). Microsoft Office 2000: Professional Edition. BPB.

3. PC Software – Shree Sai Prakashan, Meerut