Course on Computer Concepts - CCC

IT/Digital Era - Entering into Computer World Keep your Data (Storage Device)

• Computer Definition & Features
• Application of computer
• How to start Computer
• login screen - user & Password
• Desktop- Taskbar, Wallpaper, Icons
• How to start paint, some basic tools

• Computer Architecture Diagram
• Father of computer
• Devices of computer: Input, output & processing Memory Unit(MU)
• Primary memory, Secondary memory
• Unit of measurements
• Hardware & Software
• File & folder

Find your Space in Computer (File & Folder)

• Window explorer , File & folder

Searching : Find your File/Folder Wild Cards

• Extensions of program
• Wild card Asterisk(*), Question mark(?)
• Searching for file and folder

1.Start your Career - CV/Resume Creation

• Definition, Feature
• How to start Ms Word
• File, font group

2.Beautifying your CV/Resume (Formatting)

• Quick Access Tool Bar
• Paragraph Group, Clipboard group, Editing group

3.Letterhead - Show case of Your Company

• Insert tab: Header & footer group
• Date & Time, Symbol Picture
• Home tab: change Case, Border & Shading

4.News Paper & Magazine Creation (Column)

• Page layout tab: columns, column break
• Insert tab: Drop cap, Book cover
• file:Auto correct
• Review tab: Word Count, Spell Check, Thesaurus

5.Create your Own Book

• Refrence tab: Insert endnotes, Insert footnotes, table of content
  watermark, Hyphenation

6.Links and Security

• Refrence tab: Insert caption, index entry,
• Links: Booksmarks, Hyperlink, cross Reference
• Review tab: Track changes, Protect document

7.Connect your Customer (Bulk Mailing)

• Mail Merge , Main document & Data source

8.Connect your selected customer(Record filtration)

• Sorting of Record
• Filter of Record
• Lables
• Envelope

9.Mark sheet Creation (Tabular format data )

• Insert table, Draw table
• Layout tab
• Design tab

10.Document is ready to print/Record your actions

• Page setup
• Print preview
• Print
• Macro

1.World of Row and Column - First interaction with excel

• Introduction of excel, Workbook, Worksheet, Row, Column, Cell, type of entries
• Home tab: Cell group, Font group, Alignment

2.Invoice / Bill of Supply

• Type of Reference : Absolute, Relative
• Basic formulas
• Sum, Product, Minus, Quotient, Mod, Percentage)

3.Result Declared (Automatic Calculation)

• Function

4.Secure your Data/ Lock your data/ Restrict editing

• Styles group :  Format as table, Conditional Formatting, Cell styles
• Protection: Track Changes, Protection

5.Data Analysing Tool (Expense Limit & Comparision)

• What if Analysis: Goal seek, Scenario, Data table

6.Pictorial Representation of Data (Chart Magic)

• Pictorial Represntation of data
• Chart, type of chart, formatting of charts

7.Organize your Data (Easier to Analyze)

• Data validation, Data filtration, sort, subtotal

8.Analyzing Complex Data (Pivot Table)

• Logical function: if and, if or
• Pivot table, Pivot chart, Paste special

9.Lookup & Reference , Extract Your Data

• Lookup functions : lookup, vlookup, hlookup
  match, index

10.Data is ready to Print /Page Setup

• Page setup
• Print preview

1.Welcome to Presentation World

• PowerPoint - Definition feature, purpose ,view of slides
• Home tab-slide group

2.Beautifying presentation (Formatting of presentation)

• Font & Alignment Group
• Inset tab - Illustration group
• Themes & Background

3.Masters of Slide/ Slide Automation

• Masters
• Animation(triggers
• Transition
• Hyperlink, Actions
• Slide background

4.Its presentation time now

• Slide show tab - From beginnng, from current slide, Custom slide show,setup slide, Hide slide, Record narratio, Rehearse timing, slide show
• Inset tab- photo album

5.Advance feature of Presentation

• Running Clock, Moving Car, Making Picture, Bouncing Ball

1.World of Internet 

• Internet introduction & Benefit
• Computer Network: LAN, WAN, MAN
• Services of internet
• Search engine, Web browser

2.Online Communication

• Inbox , Reply, Forward, composing, Attachments of file,
  Change password(setting of E-mails) , Facebook account handling, 
  Facebook page creation

3.Downloads/Booking

• Ticket Reservation & Booking, Online shopping, Online Bill payment, Book movie ticket
• Download: Image, font style, app, pdf, song, movie

4.Digital India

• Cash less society
• E-wallets, UPI, Plastic money, USSD, Net Banking