Mastery in Computer Skills
Objective
The course is designed to equip a student, common person, females and who are self-employed that how they use computers, knowledge about computer hardware and software, MS Office tools, Computer network and internet for professional as well as day to day use. It provides theoretical background as well as in depth practical approach of MS Office.
Target Audience
Graduate or Post Graduate in Arts, Commerce, Science and Management Stream.
Duration of Course
8 weeks
Credit Weight
2 Credits
Certificate
The participants will be provided with a certificate upon successful completion of the course.
Career Advancement
Course will help students getting a career opportunity as Computer Operator, Data Entry Operator, Social Media Operator and Computer Assistant in industries of Finance, Accounting, Banking, Logistics, Store keeping, Inventory management and other sector.
Module - 1 Introduction to Computer and Hardware
Unit 1 : Introduction of Computers
- Computers & Its Applications
- IT Gadgets and Their Applications
- Basics of Hardware
- Central Processing Unit
- Input Devices
- Output Devices
- Computer Memory & Storage
- Connecting Keyboard, Mouse, Monitor and Printer to CPU and its working
Module - 2 Introduction to Software & Operating System
Unit 1 : Introduction to Software
- Software
- Application Software
- Systems Software
- Mobile Apps
- Overview on Operating System
- Operating Systems for Desktop and Laptop
- Operating Systems for Mobile Phone and Tablets
- User Interface for Desktop and Laptop
- Task Bar
- Icons & Shortcuts
- Running an Application
- Operating System Simple Setting
- Using Mouse
- Changing System Date and Time
- Changing Display Properties
- To Add or Remove Program and Features
- File and Folder Management
- Types of File Extensions
Module - 3 Word Processing
Unit 1 : Introduction to MS Word
- Word Processing Basics
- Opening Word Processing Package
- Title Bar, Menu Bar,
- Toolbars & Sidebar
- Creating a New Document
- Opening and Closing Documents
- Opening Documents
- Save and Save As
- Closing Document
- Using the Help
- Page Setup
- Print Preview
- Printing of Documents
- PDF file and Saving a Document as PDF
- Document Creation
- Editing Text
- Text Selection
- Cut, Copy and Paste 3.4.5 Font, Color, Style and Size Selection
- Alignment of Text
- Undo & Redo
- AutoCorrect, Spelling & Grammar
- Find and Replace
- Formatting the Text
- Paragraph Indentation
- Bullets and Numbering
- Change case
- Header & Footer
- Table Manipulation
- Insert & Draw Table
- Changing cell width and height
- Alignment of Text in cell
- Delete / Insertion of Row, Column and Merging & Splitting of Cells
- Border and Shading
- Shortcut Keys
Module - 4 Working with Spreadsheet
Unit 1 : Introduction of MS Excel
- Elements of Spread Sheet
- Creating of Spread Sheet
- Concept of Cell Address [Row and Column] and selecting a Cell
- Entering Data [text, number, date] in Cells
- Page Setup
- Printing of Sheet
- Saving Spread Sheet
- Opening and Closing
- Manipulation of Cells & Worksheet
- Modifying / Editing Cell
- Formatting Cell (Font, Alignment, Style)
- Cut, Copy, Paste & Paste Special
- Changing Cell Height and Width
- Inserting and Deleting Rows, Column
- AutoFill
- Formulas, Functions and Charts
- Using Formulas for Numbers (Addition, Subtraction, Multiplication & Division)
- AutoSum
- Functions (Sum, Count, MAX, MIN, AVERAGE)
- Introduction to Pivot Tables
- Implementation of Pivot Tables
- V-Lookup, H-lookup
Module - 5 Creating Presentations
Unit 1 : Introduction of Powerpoint
- Creation of Presentation
- Creating a Presentation Using a Template
- Creating a Blank Presentation
- Inserting & Editing Text on Slides
- Inserting and Deleting Slides in a Presentation
- Saving a Presentation
- Manipulating Slides
- Inserting Table
- Adding ClipArt Pictures
- Inserting Other Objects
- Resizing and Scaling an Object
- Presentation of Slides
- Choosing a Set Up for Presentation
- Running a Slide Show
- Transition and Slide Timings
- Automating a Slide Show
- Printing Slides and Handouts
Module - 6 Introduction to Network & Internet
Unit 1 : Introduction to Network & Internet
- Basic of Computer Networks
- Local Area Network (LAN)
- Wide Area Network (WAN)
- Concept of Internet & WWW
- Applications of Internet
- Website Address and URL
- ISP and Role of ISP
- Modes of Connecting Internet (Hotspot, Wi-Fi, LAN Cable, Broadband, USB Tethering)
- Popular Web Browsers (Internet Explorer/Edge, Chrome, Mozilla Firefox, Opera etc.)
- Exploring the Internet
- Surfing the web
- Popular Search Engines
- Searching on Internet
- Downloading Web Pages
- Printing Web Pages
Module - 7 E-mail, Social Networking and E-Governance Services
Unit 1 : Working with E-Mails
- Structure of E-mail
- Using E-mails
- Opening Email account
- Mailbox: Inbox and Outbox
- Creating and Sending a new E-mail
- Replying to an E-mail message
- Forwarding an E-mail message
- Social Networking & e-Commerce
- Facebook, Twitter, LinkedIn, Instagram
- Instant Messaging (WhatsApp, Facebook Messenger, Telegram)
- Netiquettes
- Overview of e-Governance Services like Railway Reservation, Passport, eHospital [ORS]
- Accessing e-Governance Services on Mobile Using “UMANG APP”
- Digital Locker
Module - 8 Digital Financial Tools and Applications
Unit 1 : Digital Financial Tools and Applications
- Digital Financial Tools
- Understanding OTP [One Time Password]
- QR [Quick Response] Code
- UPI [Unified Payment Interface]
- AEPS [Aadhaar Enabled Payment System]
- USSD[Unstructured Supplementary Service Data]
- Card [Credit / Debit]
- eWallet
- PoS [Point of Sale]
- Internet Banking
- National Electronic Fund Transfer (NEFT)
- Real Time Gross Settlement (RTGS)
- Immediate Payment Service (IMPS)
- Online Bill Payment
Learning Management System (LMS) Panel:
- Lifetime Access: Students can log in securely at any time.
Course Features
- Live Online Classes: Engage in real-time sessions with instructors
- Interactive Sessions: Participate in discussions and Q&A to enhance learning.
- Practical Sessions: Apply concepts through hands-on activities.
- Class Recordings: Access recordings of live classes for review at your convenience
- Self-Learning Videos: Benefit from pre-recorded videos to reinforce learning.
- Digital Course Materials: Receive a soft copy of all course content.
- Assignments: Complete practical assignments to apply your knowledge.
- Practice Assessments: Test your understanding with practice quizzes.
- Final Assessment: Evaluate your overall progress with a comprehensive exam.