1st Semister

Introduction: What is Computer, Concepts of Data and Information, Data, Information, Processing, limitations of computers

Characteristics of Computer: Speed, Accuracy, Storage, Diligence, Versatility, Automatic, No I.Q, No Feelings. 

Evolution of Computer: Abacus, Napier's Bone, Slide Rule, Pascal's Machine, Leibnitz’s Calculating Machine, Charles Babbage, Difference Engine, Analytical Engine, SOME WELL-KNOWN EARLY COMPUTER.

Generations of Computer:

First Generation (1940 to 1956): Using Vacuum Tubes Hardware Technology.

Second Generation (1956 to 1963): Using Transistors Hardware Technology. 

Third Generation (1964 to 1971): Using Integrated Circuits Hardware Technology.

Fourth Generation (1971 to present): Using Microprocessors Hardware Technology.

Fifth Generation (Present and Next): Using Artificial Intelligence.

Classification of Computer: Classification of computers based on working principle, Classification of computers based on size and type.

Computer system: Hardware, Software, Live-Ware, Firmware. 

BASIC ORGANIZATION OF COMPUTER: Inputting, Outputting, Storing, Processing, Controlling.

Input device: Keyboard, Mouse, Joystick, Light pen, Track ball, Scanner, Digitizer, Microphone, Magnetic Ink Character Reader, Optical Character Reader, Bar Code Readers, Optical Mark Reader.

Output device: Monitors, Cathode-Ray Tube (CRT) Monitor, Flat-Panel Display Monitor, Printers, Impact Printers, Character Printers, Dot Matrix Printer, Advantages, Daisy Wheel, Line Printers, Drum Printer, Chain Printer, Non-impact Printers, Laser Printers, inkjet/Deskjet Printers. 

Central Processing Unit (CPU): Arithmetic Logic Unit, Control Unit.

Hardware: Input devices, Output devices, Secondary storage devices, Internal components.

Software: System Software, Application Software.

Number system: Decimal Number System, Binary Number System, Octal number system, Hexa Decimal number system.

    Important Abbreviations & their Short notes

Introduction Operating Systems: Definition CUI & GUI, what is system, what is Prompt/DOS prompt.

Basic DOS Command: Internal & External Command, Comparison of DOS and Windows, File/Directory Manipulations, copying of files and Disks, Delete/Undelete, Formatting a floppy.

Introduction of Windows: What is an operating system and basics of Windows, my computer Icon, The Recycle Bin, Status Bar, Start and Menu, Menu selection. 

Windows Setting: Control Panels, Wallpaper and Screen savers, setting the data and Sound, Concept of menu Using Help.

Advance Windows: Using right Button of the Mouse, Creating Shortcuts, Basics of Window Setup, Notepad, Window Accessories.

Introduction & Features: Table of Contants, Opening MS Word, Document information & properties, entering text & move around, Save, opening, closing documents, Content help using function key & using help icon.

Editing Documents: Insert and add text, replace text, select text & using selection bar & keyboard, Move, copy, zoom in-out, special symbol, undo changes.

Formatting Text: Setting text fonts, text decoration, change case, text color, alignment, bullet, numbering, line spacing and indentation.

Working with table: Create a table, row and column definition, Move, resize margin, split, formula, border and shader. 

Advance operating: Use templates, Graphic, auto correction, auto formatting, Table of content, Preview, printing, Email, Translate, compare, security, set watermark.

Introduction & Feature: Calculation or Computation Capabilities, Pivot Table % A Micro Programing Language Called Visual Basic for Application (VBA), Sparkline & Slicers. 

Programs Fundamentals: Starting Excels, New Workbook, Command shortcut, Printing Worksheet, Using Helf, Editing Worksheet, Formating text & Value, Cell Alignment, Conditional Formatting & Theme, Rules finding and                                                                          replacing.

Creating & working with chart: Inserting Chart, Editing, Sdding, Changing Chart Data, Layout & Style, Chart Lable & chart Gridlines, Chart Templates & Spark lines.

Managing Workbook: Using workbook view, selecting and switching between worksheet, Splitting & Freezing a window, Creating Header & Footer.

More Function & Formula: Multiple Operation , Editing Function, Using Logical , Financial , Numerical, Database, V Lookup, H Lookup Function.

Working with Data Range: Shorting Logical Sequence, Filtering Data, Auto Filtering & Advance Filtering, Shorting by One Column or Colors or Icon.

Working with Table: Creating a Table, Total Row & Total Column, Duplicate Row of Date, Using Data validation, Conditional Formatting.

Working with Pivot Table: Creating a Pivot Table, Changing a Pivot Table's Calculation, Filltering & Shorting a Pivot Table, Pivot Table Layout, Uploting, Grouping, Formatting .

Analyzing Data & Review: Creating Scenarios Report, Working With Data Table, Using Goal seek, Using Sub Total, Consolidate Data Using Formula. Inserting Hyperlink, Importing Data from an Access Database or Text File, Importing Data From The Web & Other Sources.

Working with Macros & Review: Recording, Playing, Deleting, Editing, Adding, Macro, Inserting Copied Code In a Micro, Using the if.....Then....Else Statement, Customizing Excel. 

Customizing & Security: Quick Access Toolbar & Ribbon, Using Auto Correct, number Format, Protect Workbook, Worksheet. 

Introduction & Features: Design professional presentation, Create and organize contents according to the objective, use graphical effects, animations and multimedia objects, Manage the publishing and the delivery of a presentation. 

Presentation planning & organizing: Analysis and preliminary choices, Designing, layout templates & themes, Designing according to time, audiences, place.

The visual communication: Using graphics & images, Inserting & importing images, Graphic object formatting editing shapes, SmartArt, chart & diagrams, other tools.

Multimedia: Using audio and video formats, inserting audio and video, troubleshooting of audio and video problem.

Animating & transition: Setting text & customize animation effects, Animated the element of a chart, Apply trigger, action etc., slide transition.