Scribd
Upload
2 views6 pages

Copa Index

The document provides a comprehensive overview of computer fundamentals, including hardware, software, operating systems, and applications like MS Word and Excel. It covers networking concepts, internet technologies, web design, programming languages like JavaScript and Visual Basic, as well as accounting and e-commerce principles. Additionally, it addresses cyber security, risks, and legal aspects related to information technology.

Uploaded by

SomanathMali
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2 views6 pages

Copa Index

The document provides a comprehensive overview of computer fundamentals, including hardware, software, operating systems, and applications like MS Word and Excel. It covers networking concepts, internet technologies, web design, programming languages like JavaScript and Visual Basic, as well as accounting and e-commerce principles. Additionally, it addresses cyber security, risks, and legal aspects related to information technology.

Uploaded by

SomanathMali
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Index

Introduction to Computers and Windows Operating System


 Computer: An introduction
 History of computer
 Computer generation
 Computer in india
 Types of computers
 Advantages of computers
 Applications of computers
 Limitations of computers
 Computer hardware, software, a firmware
 Introduction to various processors
 Introduction of operating system
 Windows operating system
 Hardware
 Input devices
 Output devices

Computer Hardware and Software Installation


 Introduction of computer hardware and software
 Anatomy of computer
 Booting
 Bios setting
 Memory
 First aid maintenance
 Trouble shooting
 Formatting and loading OS
 Virus and antivirus

Introduction of DOS and Linux OS


 Introduction of desk operating system/DOS
 Introduction to open source software
 Linux operating system
 Components of linux OS
 Shell
 Basic linux commands

MS Word
 Introduction of MS word
 Features/Characteristics of MS word
 System requirement for MS word
 Loading of MS word
 Parts of Ms word window
 Different menu in MS word 2003
 Cursor movement keys and shortcut keys in MS word
 Ms word practical work
 Create macro
 Special effects in text
 Creating drop cap
 Inserting book mark
 Mail merge

MS Excel
 Introduction of MS excel
 Features of MS excel
 Workbook and worksheet
 Loading MS excel
 Parts of excel windows
 Menu bar in excel
 Cursor movement, shortcut and function keys
 Making entries in worksheet
 Data editing
 Function in Microsoft excel
 Operators
 Charts in MS excel
 MS excel practical work
 Printing
 Deletion
 Move or copy worksheet
 Merge cells
 Changing column width and row height
 Insert blank cells, rows or columns
 Hide/unhide of row/column
 Cut, copy and paste
 Delete the contents of cells row columns
 Clear cell formats or contents
 Add numbers using autosum
 Formatting worksheet
 Limitations of worksheet protection
 Charts
 Sort the records
 Autofilter the data list
 Pivot table
 Report

Open Office and Power Point


 Open office
 Power points

Database Management System


 Concept of data, information and database
 Database management system/ DBMS
 Overview of popular databases : RDBMS, OODB and NOSQL
 Rules for designing good tables
 Integrity rules and constrains in a table
 Relationship in tables
 Introduction to various types of queries and their uses
 Commands uses in SQL
 MS access
 Features of MS access
 Important units used in database management
 Start Microsoft access
 Design database by using wizard
 Create database by design view
 Creative table by design view
 Shortcut keys used in MS access
 Designing accesses reports and forms
 Macros

Networking Concepts
 Introduction of computer networks
 Client server networking concepts
 Peer to Peer networking concept
 Proxy server
 Firewall proxy server
 Network topologies
 Types of network LAN, MAN and WAN
 Components of network
 Network cables
 Wireless network and bluetooth technology
 Physical, logical addresses and classes of network
 Network security
 Firewall
 Concepts of DHCP
 Concept of ISO-OSI 7 layer model
 Network protocol

Internet Concepts
 Introduction
 World wide web- WWW
 Internet and web
 Domain naming system
 Electronic mail
 Video chatting
 Voice over IP/VOIP
 Social networking
 Cloud storage
 Open web server
 Introduction to internet security, threat and attacks
 Malicious software
 Internet security products

Web Designing Concepts


 Concepts of static and dynamic web pages
 HTML
 Introduction of cascading style sheet
 Content management system
 Joomla
 Wordpress
 Drupal
 Plone
 Web authoring tool

JAVAScript
 Introduction
 Algorithm : Flowchart, pseudocode
 Web server
 Introduction to programming and scripting languages
 JAVAscript basics elements of JAVAscript
 Statements of JAVAscript
 Arrays
 Functions in JAVAscript
 Dialog boxes
 Message box
 Input box
 Document object model
 Event handling in JAVAscript
 Using forms with JAVAscript
 Functions and methods in JAVAscript
 User defined objects

Visual Basic for Application


 Introduction
 VBA data types, variables and constants
 Operators
 Mathematical expression
 Conditional and branching statement
 Looping
 Introduction to string in VBA
 Arrays
 VBA message box
 VBA input box
 Procedures and functions
 Builtin function/methods
 Object oriented programming concepts
 Even driven programming
 User forms and control
 Properties events and methods associated with controls
 Macro
 ADO
 Debugging technique

Smart Accounting
 Introduction of accounting
 Book keeping
 Practical system of accounts
 Golden rules of accounting
 Financial according
 Voucher entry
 Ledger posting
 Cash book
 Ratio analysis
 Stock management
 Introduction of tally
 Point of sales invoicing
 Tax deducted at source (TDS)
 Tax collected at source (TCS)
 Fringe benefit tax (FBT)
 Service tax processing in tally
 Budgeting system
 Scenario management
 Inventory processing system
 Financial statement analysis
 Value added tax (VAT)
 Variance analysis
 Costing system
 Cash flow and fund flow accounting

E-Commerce
 Introduction
 Difference between e-commerce and traditional commerce
 Using technology in E-commerce
 Types of E-commerce
 Application of E-commerce
 Construction of E-commerce
 Different modes of payment in E-commerce
 Concepts of online catalogue
 Shopping cart
 Concept of check out pages
 Payment processing in E-commerce
 E-Commerce order processing
 Authorization
 Settlement
 Charge back
 Security in E-commerce
 Payment gateway

Cyber Security
 Introduction to information security
 Do’s and don’t’s in information security
 Security threads
 Information security vulnerabilities
 Risk management
 Directory services
 Security in software development
 Cyber crimes
 Cyber law
 Information technology act-2000
 Rules related with cyber crime under IPC

You might also like