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.

2nd Semester

Introduction & Features: Definition RDBMS, Data Definition, Data Manipulation, Data Manipulation &Data Contral,
MS Access Object & Data type: Table, Query, Form, Report, other object.

MS Access Create Database: Create blank Database, Table design view, Adding Data, Grouping data, Summarizing data.

Formatting Data: Formatting report, Controls properties, MS access joining, Summarizing data.

MS Access Built-in-Functions: Functions, Date & time function, If & Format Function. 

MS Access Relationship: One to me Relationship, One to many Relationship, Many to many Relationship.

Query, Report & form: Simple, complex, update, append, delete, select, SQL query, Simple, unmatched, duplicate, crosstab wizard, Type of bound forms, multiple item, split form creation, Navigation form creation, Report design, report wizard, blank report.

Index, joins, micro

Dara import & export

     Introduction & Definition :

• HTML TAG
• HTML attribute
• HTML Element 
• Marquee

Learn how to design and develop a Web page using HTML and CSS: 

• Learn how to link pages so that they create a Web site.
• Design and develop a Web site using text, images, links, lists, and tables for navigation and layout.
• Style your page using CSS, internal style sheets, and external style sheets. 
• Learn how to use graphics in Web design. 

Learning Outcomes At the conclusion of the course, students should be able to:

• Create local HTML pages and move them to a remote web server.
• Design and develop basic web pages using HTML and CSS.
• Use graphics in Web pages.
• Use tables in Web pages.
• Link pages so that they create a Web site.
• Design and develop web pages using CSS styles, internal and/or external style sheets. 
• Design and develop web pages using CSS for layout. Topics
• HTML skeleton
• HTML tags for text, links and list
• HTML tags and web standards for images (graphics) 
• Simple layouts 
• Complex layouts 
• HTML tags for layout
• HTML tags for tables
• HTML tags for styles
• Internal CSS style sheets
• External CSS style sheets
  

Introduction & Definition: What is visual basic, What is software, What is program & programming language, Properties Windows, tools box, project explorer, The Importance of Visual basic Program, Elements of the Integrated Development Environment(IDE), Introduction to form, form properties, Code form, Events, Design a form contains label, Code for menu items, Menu editor.

Internet theory concepts: Evolution, Advantages, Disadvantages.

Internet Domain Name system: IP Address, Uniform Resource Locator (URL), Domain Name system Architecture.

Internet service & Web Services: World Wide Web (www), Video Conferencing, Internet Service Providers (ISP)

Connection Type: Dial-up Connection, ISDN, DSL, Cable TV Internet Connection, Satellite Internet Connection, Wireless Internet Connection.

Internet Protocols: Transmission Control Protocol (TCP), Internet Protocol (IP), File Transfer Protocol (FTP), Telnet, Hyper Text Transfer Protocol (HTTP).

Website Overview: Static Websites, Dynamic Website, Website Types, Internet Forums.

Blog & what to Blog about: Blogging Technologies, Websites Hosting.

What is SEO: Web pages, Web browser, Web Server, Search Engines.

Online Educational & connectivity: Online certification, Online Seminar, Webinar, Router, Email, E-Commerce, Encryption and Authentication, Cloud Computing, Firewall, Malware, Trojan, Phishing, Google Drive, Bitcoin, Cloud computing, Cyber, Dark web, Deep web, ICANN, Firefox, Paypal, Patreon, Quora.

Internet Practical: IRCTC Account create & Login, Online form fill up, Outlook configuration, Browser history delete, File Download.