Bachelor of Computer Application (BCA) Community Share and Help

Syllabus BCA-SEM-I-CC-107

PC Software (Practicals)

Gujarat University FY BCA Sem - I New Syllabus (Revised) Effective from June, 2011

Course Introduction:
The course would make students acquainted with the features of Micrsoft Office tools. It lays down emphasis on basic as well as advance features of MS Office tools.

Objectives:
The student would be able

  1. To gain knowledge of various MS office tools.
  2. To develop skills for effective use of the MS office tools.

No. of Credits: 3
Theory Sessions per week: 3
Teaching Hours: 40 hours

UNIT
TOPICS / SUBTOPICS
 TEACHING HOURS
 
 
1. Introduction to Operating System, DOS and Windows
10 Hours
  • DOS
6 Hours
    • Definition
    • Types
    • Functions
    • Booting Process
    • Introduction To DOS
    • Comparison with GUI
    • Wildcard characters
    • Working with DOS cmds:
      • DIR, MD, RD, CD,Copy, Type, DEL, REN, Date, time CLS, VER, Move, ATTRib, Xcopy
  • Windows
4 Hours
    • Components Of Windows
      • Desktop
      • Icon
      • My computer
      • My documents
      • Network Neighborhood
      • Recycle bin
      • Start menu
      • Taskbar
      • Windows explorer
    • Control Panel
      • Date & time
      • Display
      • Mouse
      • User accounts
      • Add & remove programs
    • Files and Folders
5 Hours
      • Creating Folder
      • Folder Operations(copying , moving and deleting)
      • Creating files & file operations
      • Creating Shortcuts
    • System Tools
      • Disk Defragmentation
2. MS Word & Introduction to Excel
10 Hours
  • MS Word Introduction
2 Hours
    • Creating word documents
    • Navigating and editing word documents
    • Formatting, viewing and printing a document
  • MS Word Advanced Features
5 Hours
    • Working with tables and graphics
    • Mail Merge
    • Other Features
      • Autocorrect
      • Autotext
      • Macros
      • Protecting documents
  
  • Excel
3 Hours
    • Introduction To Excel
    • Concept of Workbook
    • Worksheet, Workspace
    • Types of data
    • Formatting Workbook
    • Conditional formatting
    • Sorting Data
3. MS PowerPoint
10 Hours
  • MS Powerpoint Introduction
6 Hours
    • Creating ,browsing &saving Presentation
    • Editing & formatting slides
    • Working with objects
  
  • Enhancing presentation using multimedia
4 Hours
    • Transitions
    • Preset Animation
    • Rehearse Timings
    • Pack & go wizard
    • Pen
    • Custom Show
4. Advanced Excel
10 Hours
  • Advanced Excel Features
6 Hours
    • <Data validation>
    • Data filter (Auto & Advance)
    • Charts
    • What if analysis
      • Goal seek
      • Scenario
    • Protecting Worksheet
    • Types of error
  
  • Functions and Formulas
4 Hours
    • Mathematical
      • Round, ceil, floor, fact, subtotal, sum , sumif
  
    • Logical
  
      • AND, OR, NOT, if
    • Statistical
      • Min, max, avg, count if
    • Text
      • Concatenate, Exact, find, left, right, len, lower, upper, trim
    • Lookup
      • Hlookup, Vlookup
    • Date and Time
      • Date, day, days360, hour, minute, now, second, time, today, year, datediff

Textbook:  
   
Working with Personal Computer Software(Second Edition 2010)  
Publisher: Wiley India, New Delhi  
By R.P.Soni, Harshal Arolkar , Sonal Jain  

Textbook:  
   
Office 2003 in Simple Steps  
Publisher: Dreamtech Press  
By Kognent Learning Solutions Inc  

Reference Books:
 
Microsoft Office Plain And simple (Edition - 2003)
Publisher: Microsoft Press
By Jerry Joyce & Marianne Moon

Advertisement