Computer Fundamental

Introduction to computer

Computer and Latest IT gadgets, Evolution of Computers & its applications, IT gadgets and their applications, Basics of Hardware and Software, Central Processing Unit Input devices Output devices ,Computer Memory & storage , Application Software, Systems Software, Utility Software, Open source and Proprietary Software ,Mobile Apps

 Introduction to Operating System

Operating System, Basics of Operating System, Operating Systems for Desktop and Laptop, Operating Systems for Mobile Phone and Tablets, User Interface for Desktop and Laptop, Task Bar, Icons & shortcuts, running an application, Operating System simple setting, using mouse and changing its properties, changing system date and time, changing display properties, to add or remove Program and its features, adding, removing &sharing Printers, File and Folder management, types of file extensions.

Introduction to Internet and Networking Concept

Basic of Computer Networks, Local Area Network (LAN), Wide Area Network (WAN), Network Topology , Internet, Concept of Internet & WWW, Applications of Internet, Website Address and URL, Introduction to IP Address, ISP and Role of ISP, Internet Protocol, Modes of Connecting Internet (Hot Spot, Wi-fi, LAN Cable, Broad Band, USB Tethering), Identifying and uses of IP/MAC/IMEI of various devices, Popular Web Browsers (Internet Explorer/Edge, Chrome, Mozilla Firefox, Opera etc.), Exploring the Internet, Surfing the web, Popular Search Engines, Searching on Internet, Downloading Web Pages, Printing Web Pages

AI and Machine Learning

Introduction to Artificial Intelligence (AI),What is AI?, Difference Between AI and Regular Computers, How Does AI Work?, Examples of AI in Everyday Life, AI in Our Phones ,and Computers, How AI Helps in Different Fields, History of AI, Why is AI Important?, Popular AI Assistants, AI in Transportation, Fun AI Facts, Misconceptions About ,What is Machine Learning?, History of Machine Learning, Why is Machine Learning Important?, Features of Machine Learning, Applications of Machine Learning, Types of Machine Learning ,                                                             

Supervised Learning, Unsupervised Learning, Supervised vs Unsupervised Learning, Reinforcement Learning

Examples on reinforcement learning

Office Package

Word Processing

Word Processing Basics, Opening Word Processing Package, Title Bar, Menu Bar, Toolbars & Sidebar, Creating a New Document, Opening and Closing Documents, Opening Documents, Save and Save As, Closing Document, Using The Help, Page Setup, Print Preview, Printing of Documents, PDF file and Saving a Document as PDF file ,Text Creation and manipulation, Document Creation, Editing Text, Text Selection, Cut, Copy and Paste, Font, Colour , Style and Size selection, Alignment of Text ,Undo & Redo, AutoCorrect, Spelling & Grammar, Find and Replace, Formatting the Text, Paragraph Indentation, Bullets and Numbering, Change case , Header & Footer ,Table Manipulation, Insert & Draw Table, Changing cell width and height , Alignment of Text in cell , Delete / Insertion of Row, Column and Merging & Splitting of Cells, Border and Shading, Mail Merge , Shortcut Keys

Spreadsheet

Elements of Spread Sheet, Creating of Spread Sheet, Concept of Cell Address [Row and Column] ,and selecting a Cell, Entering Data [text, number, date] in Cells Page Setup, Printing of Sheet, Saving Spreadsheet, Opening and Closing , Manipulation of Cells & Sheet, Modifying / Editing Cell Content ,Formatting Cell (Font, Alignment, Style ),Cut, Copy, Paste & Paste Special, Changing Cell Height and Width, Inserting and Deleting Rows, Column AutoFill, Sorting & Filtering, Freezing panes, Formulas, Functions and Charts, Using Formulas for Numbers (Addition, Subtraction, Multiplication & Division), AutoSum Functions (Sum, Count, MAX, MIN, AVERAGE),Charts (Bar, Pie, Line)

Presentation

Introduction, Creation of Presentation, Creating a Presentation Using a Template, Creating a Blank Presentation, Inserting & Editing Text on Slides, Inserting and Deleting Slides in a ,Presentation, Saving a Presentation, Manipulating Slides, Inserting Table ,Adding ClipArt Pictures, Inserting Other Objects, Resizing and Scaling an Object, Creating & using Master Slide, Presentation of Slides, Choosing a Set Up for Presentation, Running a Slide Show, Transition and Slide Timings Automating a Slide Show, Providing Aesthetics to Slides & Printing ,Enhancing Text Presentation, Working with Colour and Line Style, Adding Movie and Sound

Adding Headers, Footers and Notes, Printing Slides and Handouts

Web Designing and Publishing

Introduction to web designing

Introduction of Internet, WWW, Website, Working of Websites, Webpages, Front End, Back End, Client and Server Scripting Languages, Responsive Web Designing, Types of Websites (Static and Dynamic Websites).

Editors

Downloading free Editors like Notepad++, Sublime Text Editor, Making use of Editors, File creation and editing, saving.

HTML

HTML: Introduction, Basic Structure of HTML, Head Section and Elements of  Head Section, Formatting Tags: Bold, Italic, Underline, Strikethrough, Div, Pre Tag Anchor links and Named Anchors Image Tag, Paragraphs, Comments, Tables: Attributes –(Border, Cellpadding, Cellspacing , height , width), TR, TH, TD, Rowspan, Colspan Lists : Ordered List , Unordered List , Definition List, Forms, Form Elements, Input types, Input Attributes, Text Input Text Area, Dropdown, Radio buttons , Check boxes, Submit and Reset Buttons Frames:

Frameset, nested Frames. HTML 5 Introduction, HTML5 New Elements: Section, Nav, Article, Aside, Audio Tag, Video Tag, HTML5 Form Validations: Require Attribute, Pattern Attribute, Autofocus Attribute, email, number type, date type , Range type, HTML embed multimedia, HTML Layout, HTML Iframe

CSS

Introduction to CSS, Types of CSS, CSS Selectors: Universal Selector, ID selector, Tag Selector, Class Selector, Sub Selector, Attribute Selector, Group Selector, CSS Properties: Back Ground properties, Block Properties, Box

properties, List properties, Border Properties, Positioning Properties, CSS Lists, CSS Tables, CSS Menu Design CSS Image Gallery,

CSS FRAMEWORK

Web Site Development using W3.CSS Framework, W3.CSS Intro, W3.CSS Colors, W3.CSS Containers, W3.CSS Panels, W3.CSSBorders, W3.CSSFonts, W3.CSS Text, W3.CSS Tables, W3.CSS List, 3.CSSImages, W3.CSS Grid

JavaScript

Introduction to Client Side Scripting Language, Variables in Java Script, Operators in JS, Conditions Statements, JS Popup Boxes, JS Events, Basic Form Validations in JavaScript. Introduction to Angular JS: Expressions, Modules and Directives

Data Base Management System (DBMS)

An Overview of the Database Management System,An Architecture of the Database system,Relational Database Management System (RDBMS),SQL Commands

Web Publishing and Browsing

Overview, SGML (Standard Generalized Markup Language), Web hosting Basics, Documents Interchange Standards, Components of Web Publishing, Document management, Web Page Design Considerations and Principles, Search and Meta Search Engines, WWW, Browser, HTTP, Publishing Tools.

Python Programming Language

Introduction to Programming

The basic Model of computation, algorithms, flowcharts, Programming Languages, compilation, testing & debugging and documentation.

Algorithms and Flowcharts to Solve Problems

Flow Chart Symbols, Basic algorithms/flowcharts for sequential processing, decision based processing and iterative processing. Some examples like: Exchanging values of two variables, summation of a set of numbers, Decimal Base to Binary Base conversion, Reversing digits of an integer, GCD (Greatest Common Divisor) of two numbers, Test whether a number is prime, factorial computation, Fibonacci sequence, Evaluate ‘sin x’ as sum of a series, Reverse order of elements of an array, Find largest number in an array, Print elements of upper triangular matrix, etc.

Introduction to Python

Python Introduction, Technical Strength of Python, Introduction to Python Interpreter and program execution, Using Comments, Literals, Constants, Python’s Built-in Data types, Numbers (Integers, Floats, Complex Numbers, Real, Sets), Strings (Slicing, Indexing, Concatenation, other operations on Strings), Accepting input from Console, printing statements, Simple ‘Python’ programs.

Operators, Expressions and Python Statements

Assignment statement, expressions, Arithmetic, Relational, Logical, Bitwise operators and their precedence, Conditional statements: if, if-else, if-elif-else, simple programs, Notion of iterative computation and control flow –range function, While Statement, For loop, break statement, Continue Statement, Pass statement, else, assert.

Sequence Data Types

Lists, tuples and dictionary, (Slicing, Indexing, Concatenation, other operations on Sequence datatype),concept of mutability, Examples to include finding the maximum, minimum, mean; linear search on list/tuple of numbers, and counting the frequency of elements in a list using a dictionary.

Functions

Modular programming and functions, Function parameters, Local variables, the Return statement, DocStrings, global statement, Default argument values, keyword arguments, VarArgs parameters. Library function-input(), eval(),print(), String Functions: count(), find(), rfind(), capitalize(), title(), lower(), upper(), swapcase(), islower(), isupper(), istitle(), replace(), strip(), lstrip(), rstrip(), aplit(), partition(), join(), isspace(), isalpha(), isdigit(), isalnum(), startswith(), endswith(), encode(), decode(), String: Slicing, Membership, Pattern Matching, Numeric Functions: eval(), max(), min(), pow(), round(), int(), random(), ceil(), floor(), sqrt(), Date & Time Functions, Recursion.

File Processing

Concept of Files, File opening in various modes and closing of a file, Reading from a file, Writing onto a file, File functions-open(), close(), read(), readline(), readlines(),write(), writelines(),tell(),seek(), Command Line arguments.

Scope and Modules

Scope of objects and Names, LEGB Rule Module Basics, Module Files as Namespaces, Import Model, Reloading Modules.

NumPy Basics

Introduction to NumPy, ndarray, datatypes, array attributes, array creation routines, Array From Existing Data, Array From Numerical Ranges, Indexing & Slicing.

Tally

Basic Accounting Concept

Introduction to Tally Prime, What is accounts What is accounting, Golden Rules of Accounting, Types of Business Organization, Create Master, What is Ledger, Pre Define Tally Group, Types of Voucher, Terminology of Accounting

Overview of Tally Prime

Download and Install, Create Company, Configuration, Introduction of Features, Voucher Transaction of Entry, View Reports,

Accounting

Service organization, Financial year from 1-Apr-2020 to 31-Mar-2021, Debit, Credit – By, To Voucher, Create Ledger, Create Group, Cost Centre, Cost Categories, Transaction Entry 12 Months, Provision Entries, Adjustment Entries, Closing Entries, Day Book, Trial Balance ,Profit & Loss accounting, Balance Sheet, Export Closing Balance, Create New Company , Import Opening Balance

Inventory Management with GST             

Trading organization with GST ,Financial year from 1-Oct-2020 to 31-Mar-2021, Taxation System CGST, SGST, IGST, Stock Item, Unit of measure, Stock Group, Stock Category, Create Godown / Locations, Transaction Entry 12 Months, Purchase, Sales, Invoice, Purchase returns, Sales returns

Service Organization with GST

Interest calculation, GST Report,GSTR-1,GSTR-2,GSTR-3B,Pay GST

Manufacturing Organization with GST

Manufacturing Organization with GST

Payroll Management

Payroll Management

TDS

TDS

Internet of Things

Things and Connections

Working of Controlled Systems, Real-time systems with feedback loop e.g. thermostat in refrigrator, AC, etc. Connectivity models – TCP/IP versus OSI model, different type of modes using wired and wireless methodology, The process flow of an IoT application.

Sensors, Actuators and Microcontrollers

Sensor - Measuring physical quantities in digital world e.g. light sensor, moisture sensor, temperature sensor, etc.Actuator – moving or controlling system e.g. DC motor, different type of actuators Controller – Role of microcontroller as gateway to interfacing sensors and actuators, microcontroller vs microprocessor, different type of microcontrollers in embedded ecosystem"

Building IoT Applications

Introduction to Arduino IDE – writing code in sketch, compiling-debugging, uploading the file to Arduino board, role of serial monitor.Embedded ‘C’ Language basics - Variables and Identifiers, Built-in Data Types, Arithmetic operators and Expressions, Constants and Literals, assignment Conditional Statements and Loops - Decision making using Relational Operators, Logical Connectives - conditions, if-else statement, Loops: while loop, do while, for loop, Nested loops, Infinite loops, Switch statement.Arrays – Declaring and manipulating single dimension arrays Functions - Standard Library of C functions in Arduino IDE, Prototype of a function: Formal parameter list, Return Type, Function call.Interfacing sensors – The working of digital versus analog pins in Arduino platform, interfacing LED, Button, Sensors-DHT, LDR, MQ135, IR. Display the data on Liquid Crystal Display(LCD), interfacing keypad,Serial communication – interfacing HC-05(Bluetooth module) Control/handle 220V AC supply – interfacing relay module.

Soft skills Personality Development

Personality Development - Determinants of Personality- self-awareness, motivation, self-discipline, etc., building a positive personality, gestures. Self-esteem - self-efficacy, self-motivation, time management, stress management, Etiquettes & manners. Communication and writing skills- objective, attributes and categories of communication, Writing Skills – Resume, Letters, Report, Presentation, etc. Interview skills and body language.

Data Structure Through Object Oriented Programming Language

Object Oriented Concepts

Object Oriented Programming- a new paradigm, Abstraction, forms of Abstraction, OOP concepts- Classes, Objects, Polymorphism, Data Encapsulation, Data Hiding, Inheritance

Basics of C++, Classes and Objects

Features of C++, Tokens, keywords, Data types, Operators, Manipulators, Console input, output, Control statements (conditional and loops), Functions, Classes, Instantiation, Destructor, constructor, Polymorphism - Operator Overloading, Function Overloading, Inheritance-Single, Multiple, Multilevel, Pointers

Analysis of Algorithm

Introduction to algorithm design and Data structures, Comparison of Algorithms, Complexity in terms of space and time, Calculation of O- notation. Abstract Data type and its implementation with a Rational number example

Searching and Sorting

Searching- Linear and Binary Search, Sorting- Bubble Sort, Selection Sort, Insertion Sort, Quick Sort, Merge Sort, Comparison of various searching and sorting techniques in terms of time complexity

Elementary Data Structures:

Arrays, Linked Lists Representation of arrays-single and multidimensional, Address calculation using row major ordering, Various operations on arrays, Linked Lists-Singly Linked List, Double linked List, Circular Linked List- traversing, deleting, inserting, searching, counting, reversing, printing of nodes.

Stacks and Queues

Stack ADT, Implementation of stack using array and linked list, Application of Stack- Evaluation of postfix/prefix expression, Queue ADT, Implementation of queue using Array and Linked List

Trees

Definition and notations, Binary Search Trees Implementation. Traversals using stacks and recursion - In-order, post-order, pre-order techniques, Threaded binary tree, B-trees with implementation of 2-3 trees.

Graphs

Definition and notations, Components of Graphs, Types of Graphs, Graph Implementation using Adjacency Matrix and Adjacency List algorithms and programs, Graph Traversal Methods: Depth First Search and Breadth First Search.

Computer Organization and Architecture

Basic Structure of Computers     

Structure of a Computer System, Arithmetic Logic Unit, Control Unit, Bus Structure, Von Neumann Architecture

Computer Arithmetic Operations

Introduction to logic gates, Boolean algebra, Data Representation-Number system, Fixed and Floating point numbers, Floating point representation, Signed numbers, Binary Arithmetic, 1’s and 2’s Complements Arithmetic, Binary adder, 2’s Complement method for multiplication, Map Simplification.

Central Processing Unit and Instructions 

General Register Organization, Types of Instructions, Instruction Formats, Addressing Modes, Data Transfer and Manipulation, Program Control, Instruction cycle.

Memory Organization

Characteristics of Memory Systems, Type of memories, Main memory, Static & Dynamic memories, Secondary Memory, Performance Considerations, Cache Memory with mapping, Virtual Memory, Address memory used pages, page replacement, Introduction to RAID.

I/O Organization            

Peripheral Devices, Input-Output Interface, Asynchronous Data Transfer Modes, Interrupt handling, Types of Interrupts, Priority Interrupt, Direct Memory Access, Input-Output Processor (IOP), Synchronous and Asynchronous Data Transfer.

Operating System

Operating Systems Overview       

Overview of Computer Operating Systems, Types of OS, Functions of OS, Protection and Security, Distributed Operating Systems, System Calls, Scheduling algorithms, memory management, threads.

Linux Basics

Open source, Overview of Linux, Basic Linux commands, structure of kernel and shell, Getting help, Linux File System, Some Important Directories, Inodes, Current Working Directory, File and Directory Names, Absolute and Relative Pathnames, Creating and Removing Directories, Changing Directories, Listing Directory Contents, Creating and Removing Files, Copying Files and Directories, Moving and Renaming Files and Directories, fundamental file types, Hard Links, Symbolic ( or soft) Links, Viewing and working with large Text files – cat, more, less, head, tail, cut commands, search text within a file, grep.

Process Management and Shell Script      

Processes: Definition, Process Relationship, Process states, Process State transitions, Process Control Block, Context switching – Threads – Concept of multithreads, Listing Processes, Finding Processes, Foreground and background processes, Interactive Process management tools, Sending signals to processes. Shell Script, shell variables, control structure using variables in shell script.

Users, Groups and Permissions   

Users, Groups, Linux File Security, Examining Permissions, accessing root user, creating user and groups, Changing File Ownership, Changing Permissions – Symbolic Method, Numeric Method, /etc/passwd, /etc/shadow and /etc/group files, Monitoring Logins, Default Permissions, Special Permissions umask, passwd

Standard I/O and Pipes  

Standard Input and Output, Redirecting Output to a File, Redirecting STDOUT to a Program(Piping), Combining Output and Errors, redirecting to Multiple Targets (tee), Redirecting STDIN from a file.

Finding and Processing Files       

Locate, find, Basic find Examples, find and Logical Operators, find and Permissions, find and Access Times.

DATABASE MANAGEMENT SYSTEMS (DBMS)

Introduction to Databases and Transactions          

What is database system, purpose of database system, view of data, relational databases, database architecture, transaction management,

Data Models

The importance of data models, Basic building blocks, Business rules, The evolution of data models, Degrees of data abstraction.

Database Design ,ER-Diagram and Unified Modeling Language      

Database design and ER Model:overview, ER-Model, Constraints, ER-Diagrams, ERD Issues, weak entity sets, Codd’s rules, Relational Schemas, Introduction to UML Relational database model: Logical view of data, keys, integrity rules. Relational Database design: features of good relational database design, atomic domain and Normalization (1NF, 2NF, 3NF, BCNF).

Relational Algebra and Calculus Relational algebra:

Introduction, Selection and projection, set operations, renaming, Joins, Division, syntax, semantics. Operators, grouping and ungrouping, relational comparison. Calculus: Tuple relational calculus, Domain relational Calculus, calculus vs algebra, computational capabilities

Constraints, Views and SQL        

What is constraints, types of constrains, Integrity constraints, Views: Introduction to views, data independence, security, updates on views, comparison between tables and views SQL: data definition, aggregate function, Null Values, nested sub queries, Joined relations. Triggers.

Transaction management and Concurrency contro             

Transaction management: ACID properties, serializability and concurrency control, Lock based concurrency control (2PL, Deadlocks),Time stamping methods, optimistic methods, database recovery management.

System Analysis and Design

Basic Concept of Systems             

The System: Definition and Concepts; Elements of a System: Input, Output Processor, Control, Feedback, Environment, Boundaries and Interface; Characteristics of a System; Types of systems -Physical and Abstract System, Open and Closed Systems, Man-made Systems; Information and its categories

Information System and System Analyst  

Information systems : TPS, OAS, MIS, DSS, ESS; System Analyst: Role and need of system analyst, System Analyst as an agent of change.

System Development Life Cycle  

Introduction to SDLC, Various phases: study, analysis, design, development, testing, implementation, maintenance; System documentation: Types of documentation and their importance.

System Planning and Information Gathering         

Initial Investigations, Identification of user needs, Project Identification and Selection; Needs of Information Gathering, Determination of requirements, Information gathering tools: interviews, group communication, questionnaires, presentations and site visits.

Feasibility Study             

Definition, Importance of feasibility study, Types of feasibility study, System selection plan and proposal, Prototyping, Cost-Benefit Analysis: Tools and Techniques.

Tools for System Analysis            

Data Flow Diagram (DFD), Logical and Physical DFDs, Developing DFD; System Flowcharts and Structured charts, Structured English, Decision trees and Decision tables.

System Design   

Module specifications, Module Coupling and cohesion, Top-down and bottom-up design; Logical and Physical design, Structured design.

Input and Output            

Input design: Input data, Input media and devices; Output design; Form Design: Classification of forms, Requirements of Form design.

System Implementation and Maintenance

Need of System Testing, Types of System Testing, Quality Assurance; System Conversion, Conversion methods, procedures and controls, System evaluation and performance, Maintenance activities and issues.

System Security and Audit           

System Security, Security Threats, Risk Analysis, Control measures, System Audit, Disaster Recovery Planning

Project Work/Internship