IT Tools and Business Systems notes (‘O’ level)

IT Tools and Business Systems notes (‘O’ level)

Computer Appreciation

• Characteristics of Computers
• CPU – Input, Output, Storage units
• Computer System concept
• Binary number system
• Binary to Decimal Conversion
• Decimal to Binary Conversion
• ASCII Code
• Unicode.

Computer Organization

MEMORY

• PRIYMARY MEMORY
  
  • Cache Memory
  • RAM and ROM
  • Booting Process
• Secondary MEMORYs
  • Floppy and Hard Disks
  • Optical Disks
  • CD-ROM
  • DVD
• Mass Storage Devices
  • USB thumb drive
• Managing disk Partitions
• File System
• Input Devices
  • Keyboard
  • Mouse
  • Scanner
  • web cam
• Output Devices
  • Monitors
  • Printers – Dot matrix, inkjet, laser
• Multimedia
  • What is Multimedia
  • Multimedia Application in Education, Entertainment, Marketing
  • Names of common multimedia file formats
• Computer Software
  • Relationship between Hardware and Software
  • System Software
  • Application Software
  • Compiler
  • Names of some high level languages
  • free domain software.

Operating System

• Microsoft Windows-
  • An overview of different versions of Windows
  • Basic Windows elements
  • File management through Windows
• Using essential accessories: System tools
  • Disk cleanup
  • Disk defragmenter
  • Entertainment
  • Games
  • Calculator
• Imaging – Fax, Notepad, Paint, WordPad
• Command Prompt-
• Directory navigation
• path setting
• creating and using batch files.
• Drives
• files & directories
• directory structure.
• Application Management:
  • Installing
  • uninstalling
  • Running applications.
• Linux–
  • An overview of Linux
  • Basic Linux elements
  • Features of linux
  • File Structure
  • H/W, S/W requirements
  • Preliminary steps before installation
  • specifics on Hard drive repartitioning and booting a Linux system.

Word Processing

• Word processing concepts

  • Creating Documents
  • saving document
  • closing document
  • Opening an existing document
  • Selecting text
  • Editing text
  • Finding and replacing text
  • Printing documents
  • Character and Paragraph Formatting
  • Page Design and Layout

• Editing and Profiling Tools:

  • Checking and correcting spellings
  • Handling Graphics
  • Creating Tables and charts
  • Document Templates and Wizards.

Spreadsheet Package

• Spreadsheet Concepts
• Creating Sheet
• Saving
• Editing a Workbook
• Inserting, Deleting Work Sheets
• Entering data in a cell 
• formula Copying and Moving from selected cells
• handling operators in Formula
• Functions: Mathematical, Logical, statistical, text, financial, Date and Time functions
• Using Function Wizard
• Formatting a Worksheet:
• Formatting Cells
• changing data alignment
• changing date, number, character or currency format
• changing font
• adding borders and colors
• Printing worksheets
• Charts and Graphs – Creating, Previewing, Modifying Charts
• Integrating word processor, spread sheets, web pages.

Presentation Package

• Creating Presentation
• Opening and Saving Presentations
• Working in Different Views
• Working with Slides
• Adding and Formatting Text
• Formatting Paragraphs
• Checking Spelling and Correcting Typing Mistakes
• Making Notes Page
• Handouts
• Drawing and Working with Objects
• Adding Clip Art and other pictures
• Designing Slide Shows
• Running and Controlling a Slide Show
• Printing Presentations.

Data Base Operations

• What is Database
• Relational Database
• Integrity

• Operations:

  • Creating Table
  • dropping
  • manipulating table structure

• Manipulation of Data:

  • Query
  • Data Entry Form
  • Reports.

Information Technology and Society

Indian IT Act