IT Tools and Business Systems notes (‘O’ level)
Computer Appreciation
- Characteristics of Computers
- CPU – Input, Output, Storage units
- Computer System
- Binary number system
- Binary to Decimal Conversion
- Decimal to Binary Conversion
- ASCII Code
- Unicode.
Computer Organization
- Central Processing Unit
- Secondary Storage Devices
- Mass Storage Devices
- USB thumb drive
- Managing disk Partitions
- File System
- Input Devices
- Output Devices
- 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-
- Using essential accessories: System tools
- 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
-
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:
-
Manipulation of Data:
Information Technology and Society
- Indian IT Act
- Intellectual Property Rights – issues
- Application of information Technology in Railways, Airlines, Banking, Insurance, Inventory Control, Financial systems, Hotel management, Education, Video games, Telephone exchanges, Mobile phones, Information kiosks, special effects in Movies.