Diploma IN COMPUTER APPLICATION ( S-016 )

Diploma in Computer Application (DCA) - 60 Days

Course Overview:

This course is designed for beginners to gain fundamental skills in Microsoft Office applications, including Word, Excel, and PowerPoint. Students will learn essential tools and techniques to effectively use these applications for personal, academic, or professional purposes.

Course Duration: 60 Days

• Mode of Instruction: Classroom/Online
• Total Hours: 120 hours (2 hours/day)

Week 1-2: Microsoft Word (Basic)

• Introduction to Microsoft Word

  • Overview of the interface: Ribbon, Tabs, Groups
  • Creating a new document
  • Saving and opening documents
  • Document views and navigation

• Basic Text Formatting

  • Font styles, size, color
  • Bold, Italic, Underline
  • Alignment: Left, Center, Right, Justify
  • Line and paragraph spacing
  • Bullets and numbering

• Working with Pages

  • Page setup: Margins, Orientation, Size
  • Page breaks and section breaks
  • Header and footer
  • Inserting page numbers

• Inserting Elements

  • Tables: Inserting, modifying tables
  • Images: Inserting, resizing, and positioning
  • Shapes and WordArt

• Proofreading Tools

  • Spell check and grammar
  • Find and replace
  • Thesaurus

Week 3-4: Microsoft Excel (Basic)

• Introduction to Microsoft Excel

  • Overview of Excel interface: Worksheets, Workbooks
  • Creating and saving Excel files
  • Basic navigation and cell referencing

• Working with Data

  • Entering and editing data
  • Formatting cells: Text, numbers, currency
  • Adjusting row and column sizes
  • Inserting and deleting rows/columns

• Basic Formulas and Functions

  • Basic arithmetic (addition, subtraction, multiplication, division)
  • SUM, AVERAGE, MIN, MAX functions
  • Relative and absolute cell referencing

• Working with Worksheets

  • Managing multiple worksheets
  • Linking data between sheets
  • Inserting, deleting, and renaming sheets

• Introduction to Charts

  • Creating basic charts (bar, line, pie)
  • Editing and formatting charts

Week 5-6: Microsoft PowerPoint (Basic)

• Introduction to Microsoft PowerPoint

  • Overview of the interface: Slides, Outline, Slide Sorter
  • Creating a new presentation
  • Slide layouts and themes

• Working with Slides

  • Adding and deleting slides
  • Applying transitions between slides
  • Arranging slide order

• Design and Formatting

  • Inserting text, images, and shapes
  • Formatting text and objects
  • Slide backgrounds, themes, and color schemes

• Animations and Effects

  • Adding animations to text and objects
  • Customizing animation timings
  • Transition effects between slides

• Presenting the Slideshow

  • Starting the presentation
  • Using presenter view
  • Setting up and running slide shows

Week 7-8: Project Work and Assessment

• Week 7: Practical Projects

  • Creating a Word document (e.g., report or resume)
  • Developing an Excel sheet with basic data analysis (e.g., budget or sales tracking)
  • Designing a PowerPoint presentation (e.g., academic or business presentation)

• Week 8: Final Assessment

  • Theory and practical exam on Word, Excel, and PowerPoint
  • Evaluation of project submissions
  • Feedback and review session

Course Outcomes:

By the end of this course, students will be able to:

1. Create and format professional documents in Microsoft Word.
2. Organize and analyze data in Microsoft Excel using basic functions and charts.
3. Design engaging and structured presentations using Microsoft PowerPoint.

Eligibility Criteria for Diploma in Computer Application (DCA) - 60 Days

To enroll in this 60-day DCA program, candidates should meet the following criteria:

1. Educational Qualification:

   • Minimum Qualification: Completion of 10th standard or equivalent.
   • Candidates with higher educational qualifications (PUC/12th grade, Diploma, or Graduation) are also eligible.

2. Basic Knowledge:

   • No prior knowledge of computers is required, as this is a beginner-level course.
   • However, a basic understanding of English (reading and comprehension) is recommended to navigate the software interface.

3. Age Limit:

   • There is no specific age limit for this course. Candidates from all age groups are welcome to apply.

4. Interest in Learning:

   • Candidates should have a genuine interest in learning Microsoft Word, Excel, and PowerPoint, as well as improving their computer proficiency.