Diploma IN OFFICE MANAGEMENT ( S-005 )

Course: Basic Computer Skills (Word, Excel, PowerPoint, Nudi)

Duration: 8 weeks (60 days)
Target Audience: Beginners
Total Training Hours: ~40 hours (5 hours/week)

Week 1: Introduction to Computers and Microsoft Word

• Overview of Computer Hardware and Software
• Introduction to Operating Systems (Windows)
• MS Word Basics:
• Interface Overview
• Creating a New Document
• Text Formatting (font, size, color, alignment)
• Paragraph Formatting (indentation, line spacing)

• Inserting and Formatting Tables
• Adding Headers and Footers
• Page Setup (margins, orientation, page breaks)
• Inserting Images, Shapes, and SmartArt
• Spell Check, Thesaurus, and Grammar Tools

• Creating and Using Styles and Themes
• Working with Bulleted/Numbered Lists
• Introduction to Mail Merge
• Document Protection and Review Tools (Track Changes)
• Printing Documents (preview, print settings)

Week 4: Microsoft Excel

• Introduction to Excel Interface
• Creating and Formatting Worksheets
• Basic Formulas (SUM, AVERAGE, MIN, MAX)
• Cell Formatting (alignment, number format, borders)
• Using Autofill and Quick Analysis Tools

• Sorting and Filtering Data
• Introduction to Charts (Column, Pie, Line)
• Working with Multiple Worksheets
• Conditional Formatting
• Using Text Functions (LEFT, RIGHT, CONCATENATE)

• Advanced Formulas (IF, VLOOKUP, HLOOKUP)
• Introduction to Pivot Tables
• Data Validation (drop-down lists)
• Protecting and Sharing Workbooks
• Importing/Exporting Data to/from Excel

Week 7: Microsoft PowerPoint

• PowerPoint Interface Overview
• Creating and Formatting Slides
• Using Slide Layouts, Themes, and Backgrounds
• Adding Images, Charts, and Tables to Slides
• Applying Transitions and Animations

• Customizing Animations and Slide Transitions
• Working with Slide Master for Consistent Design
• Inserting Audio and Video
• Slide Show Setup and Presentation Techniques
• Introduction to Nudi (Kannada Typing Software):

Week 9: Nudi (Intermediate)

• Keyboard Layout and Basic Typing Practice
• Formatting Text in Kannada
• Typing Kannada in MS Word, Excel, and PowerPoint
• Using Special Characters and Symbols in Kannada

• Advanced Formatting in Kannada
• Saving and Printing Kannada Documents
• Review of Key Topics from Word, Excel, PowerPoint, and Nudi
• Final Practical Exercises and Assessment

Course Objectives:

• Master the creation and formatting of documents in MS Word.
• Acquire proficiency in managing data and performing calculations in MS Excel.
• Learn to create professional presentations using MS PowerPoint.
• Gain competence in typing and formatting Kannada documents with Nudi.

Eligibility Criteria for Basic Computer Skills Course

1. Education: Basic literacy (reading/writing); 7th grade recommended.
2. Computer Knowledge: No prior experience needed; familiarity with basic computer use is helpful.
3. Age: 10 years and above.
4. Language: Basic understanding of English or the local language; Kannada knowledge for the Nudi module.
5. Device: Access to a computer with MS Office and Nudi installed.