Computer Course

Daily Live Classes | Simulated Mock Tests

5 Full Length Tests | Speaking & Writing Evaluations

BOOK APPOINTMENT

Basic Computer Course (BCC)

 

Introduction:

Objective of BCC:  In step with effort to achieve the objective of achieving computer literacy in an inclusive manner, FIVESTEP EDUCATION has launched a new programme, “Basic Computer Course (BCC)”. The objective of the course is to impart basic level computer appreciation programme with more emphasis on hands on training. Initially, the course was conceived as to boost the concept of introducing a course on computer fundamentals, especially for students, studying vocational courses at ITIs/ITCs. However, the course has gained popularity amongst many more categories. The BCC was launched in year 2011. The programme can equip a person to use the computers in day-to-day life for professional and personal use. After completing the course the incumbent will be computer literate and will be able to:

  • Acquire confidence in using computer techniques available to users;

  • Recognize the basic components of computers and terminology;

  • Understand data, information and file management;

  • Create documents using Word processor, Spreadsheet & Presentation Software;

  • Understand computer networks, Internet;

  • Browse the internet, content search, email and collaborate with peers;

  • Use e-Governance applications;

  • Use computer to improve existing skills and learn new skills.

COURSE

1. Basic Concept of Computer

2. English Typing

3. MS Word

  • Font & Paragraph Formatting
  • Editing Saving & Printing Text Documents
  • Inserting Table
  • Header & Footer
  •  Smart Art
  •  Page Breaks
  • Using List & Styles, Spelling & Grammar Check
  • Understanding Document Properties & Tabs
  •  Mail Marge
  • Document Views & Macros
  • Saving & Protecting Sheets Documents
  • Project Work

4. Adv. Excel

  • Introduction (Ms. Excel Window/Interface Parts, File Extension, How to Open/Exit.)
  • All Definitions (Excel, Workbook, Worksheet, Cell, Row Column)
  • Entering and Editing Data.
  • Inserting and Deleting Row or Column.
  • Formatting Data
  • Auto fill Lists (Default lists & Creating new lists)
  • Simple formulas (SUM, AVERAGE, PRODUCT, COUNT, QUOTIENT, MAX, MIN, ABS, ROUND, PERCENTAGE etc.)
  • Sort, Filter, Adv. Filter, Subtotal, Macros, Protect Sheet, Protect Cell, Text to Columns, Name Manager. What if Analysis
  • Charts (Working With Charts)
  • Logical Functions (IF, AND, OR, NOT. IFERROR)
  • Financial Functions (PMT, PV, RATE, FV, DB)
  • Lookup Functions (CHOOSE. HLOOKUP, VLOOKUP. INDEX, MATCH, TRANSPOSE. HYPERLINK, ROW)
  • Math & Trig Functions (SUM, SUMIF, SUMIFS, RANDBETWEEN.ROMAN)
  • Text Functions (CHAR, CODE CONCATENATE. UPPER, LOWER, PROPPER, LEN, MID, SEARCH, TRIM)
  • MIS Report (PIVOT TABLE. PIVOT CHART, V LOOKUP, HLOOKUP, ADV. FILTER SLICER, SPARKLINES, CONSOLIDATE. CONVERT, ABS, SUMPRODUCT. FIND DUPLICATE, TEXT)
  •  Project Work
  • and many more…

5. MS PowerPoint

  • Creating & Printing Slides
  • Adding Custom Animation
  • Using Slide Transitions
  • Using Charts. Graphs & Photo Album
  •  Creating Professional Presentation
  • Project Work

6. Internet

  • Introduction to Internet
  • Browser Basics
  • Downloading. Searching, Surfing and Storing Data
  • Online Forms Submission
  • Online Bill Payment
  • Online Ticket Booking
  • and many more…