ISyllabus – Advanced Course in Computer Application Duration – 1 year Sr. No. Modules 1. Basics of Information Technology 2. Operating System 3. Introduction to Data representation and Digital Logic 4. Basics of Web Page Designing 5. Data Communications and Networking Concepts 6. Object-Oriented Programming and Database Management System (C++ & SQL Concepts) 7. Advanced Programming – Choose any one (Elective) : Elective 1 : Programming with Python Elective 2 : Core Java 8. Introduction to Software Development Life Cycle (SDLC) 9. Employability Skills DGT (60 hrs.) 10. OJT/Project & Viva (60 hrs.) Module -1 Basics of Information Technology Computer Fundamentals • What is a Computer • Characteristics of a Computer • Basic Applications of Computer • Advantages and Disadvantages of a Computer • History of Computer • Generation of Computer • Classification of Computers • Components of computer (Input unit, Arithmetic and logic unit, Control unit, Storage /Memory unit, Output unit) • Computer Memory ( What is computer memory, Types of memory, Difference between Primary memory & Secondary memory) • Concepts of Hardware and Software (Definition of Hardware and Software, Input devices, Secondary Storage devices, Output devices, Mother board, Power supply, System software, Application Software) • Languages (Machine Language, Assembly Language, High Level Language) • Concepts of data and information • IECT (Information Electronics and Communication Technology) and its applications of IECT o E-governance o Multimedia and Entertainment MS-OFFICE Basics • Word processing Basics • Text creation and Editing • Formatting text and Paragraph • Header and footer • Graphics & Tables • Mail merge • Page setup and Print. • Elements of spread sheet • Manipulation of cells • Formula and Functions • Managing Data • Charts and Graphs • Page Setup and Print • Basics of presentation • Slide preparation and inserting objects • Templates and Color schemes • Animations and slide presentation • Printing handouts. Concept of Internet • What is Network • Types of networks • Concept of Client and Server • Network Topologies • Network communication media • Concept of Internet and its applications • Advantages and disadvantages of internet • Internet protocol, Domain Name System, IP Address, URL, Internet Connectivity, Using WiFi & Bluetooth on digital devices, WWW and Web browsers, Popular Search Engines, Navigating through web, Uploading & Downloading, Services on web, Using social media sites. • Navigating through web, Uploading & Downloading • Using e- governance websites and social networking sites Introduction to E-mail • History of Email • E-mail addressing • Creating new email account • Composing & sending email without and with attachments • Email Drafts and Scheduled sending • Replying & forwarding, Sorting & searching email • Sending email to multiple users, CC and BCC • Email protocol • Signatures (appended to the end of outgoing messages) Basic Internet Security Concepts • Need of Security over internet • security threats • viruses and malwares • e-mail spam • security and privacy issues related to online shopping and social networking sites • safety measures- choosing strong password • Antivirus, Firewalls, safe browsing Online Data storage : Cloud • What is cloud and cloud storage • Benefits of online storage over local storage and portable storage • Types of cloud storage (Public, private, hybrid and community cloud) • cloud storage service providers) Module -2 Operating Systems Introduction to Operating System • What is an Operating System? • History Of OS • Examples of Operating System (Windows, Android, IOS, Mac OS, Linux etc.) • Types of Operating System (Batch Operating System, Multitasking/Time Sharing OS, Multiprocessing OS, Real Time OS, Distributed OS, Network OS, Mobile OS) • Functions & Features of Operating System • Advantages & Disadvantages of Operating System • Architecture of Operating System • Kernel, Features of Kernel, Types of Kernel • Process Management • CPU Scheduling & Deadlock • Memory Management • Storage Management • File Systems • Security Introduction to GUI based Operating System • GUI Operating Systems. • Types of GUI Operating System (Desktop OS: Window, Linux, MAC OS, Mobile OS: Android, Apple IOS, Window Phone) • Elements of GUI Operating System(Desktop, Windows, Title Bar, Task Bar, Start Menu/ Launcher, Icon, Button, Menu, Dialogue Box, Tab, Toolbar, Ribbon) • How Graphical User Interface Works? • Advantages and Disadvantages of GUI • Difference between GUI and CUI Operating System • Window Operating System • Managing files and folders in Window Operating System • Control Panel • Connecting keyboard, mouse, monitor, printer and projector to CPU • Basic Troubleshooting for common computer issues (power Supply), Handling issues related to printer (paper jam, printer isn’t printing, paper size mismatch, Printer error etc.), Handling issues related to scanner (paper jam, poor image quality etc.) Module 3 Introduction to Data representation and Digital Logic • Information Representation (Number System & Binary Arithmetic, conversions, Fixed point & Floating Point representation, BCD Codes, Error Detecting and Correcting Codes, ASCII, EBCDIC & Unicode.) • Binary Logic & Boolean Algebra(Boolean Algebra, Boolean theorems and Functions, Truth Tables, Canonical and Standard forms of Boolean functions, Simplification of Boolean Function ( Venn Diagram & Karnaugh Map)) • Digital Logic (Basic Logic Gates (AND, OR, NOT), Universal & other Gates (NAND, NOR, XOR, XNOR etc.), NAND, NOR, AND-ORINVERT and OR-AND-INVERT implementations of digital circuits, Implementation of Digital Circuits, Combinational Logic.) Module 4 Basics of Web Page Designing HTML • Introduction to HTML • HTML elements • Tags and Attributes • Creating HTML Page • Closed and unclosed tags • Text formatting tags • HTML links • Lists & types of Lists • Creating HTML tables • Adding pictures & images • Adding audio & video • Working with Forms • HTML 5 new tags (new elements, Input Types, Form Elements, Form Attributes, Canvas, SVG, Video, Audio). CSS • What is CSS • Types of CSS(Inline, Internal & External) • CSS2 (Backgrounds, Margins, Padding, Border, Positioning, Float, Z-index, Links, Text, Outline) • CSS3 (Selectors, Border, Background, Text, Text effects, Box Shadow, 2D & 3D Transforms, Transition, Animation) JavaScript • Introduction to Client Side Scripting • Introduction to JavaScript • Application of JavaScript • External JavaScript • Variables, Data Types & Operators • Conditional Statements & Loops • JavaScript Popup Boxes(Alert, Prompt, Confirm) • JavaScript Functions and Events • JavaScript Objects and Browser Object Model (BOM) • Introduction to DOM & Document Object • getElementById, getElementsByName, getElementsByTagName • innerHTML, innerText property • JavaScript Forms and Validations. Module - 5 Data Communications and Networking Concepts Data Communications • What is data communication • Components of data communications • Analog and Digital Signals • Data Transmission modes (Simplex, Half-Duplex, Full-Duplex) • Digital Data Transmission Methods (Parallel Transmission, Serial Transmission- Synchronous Transmission, Asynchronous Transmission) • Transmission Mediums(Bounded/ Guided Transmission Media, UnBounded/ UnGuided Transmission Media) Computer Networks • Introduction To Computer Networks • Uses of Computer Networks • Network Architecture (Peer-To-Peer network, Client/Server network) • Components of Computer Network (Network Interface Card(NIC), HUB, Switch, Repeater, Router, Modem, Server, Bridge) • Types of Communication Networks (Local Area Network (LAN), Metropolitan Area Network (MAN), Wide Area Network (WAN), Wireless, Inter Network (Internet)) • Network Topology and Types (Bus, Ring, Star, Mesh, Tree, Hybrid) • Protocols and Standards • Reference Models in Communication Networks (OSI reference model, TCP/IP reference model, Functions of OSI Model and TCP/IP Model Layers, Difference between OSI and TCP/IP Model) • Physical Layer (Digital Transmission, Multiplexing, Switching, Circuit-Switched, Message-Switched Networks, Packet Switching) • Data Link Layer ( Error detection and Correction, Data Link Control & Protocols) • Network Layer (Network Addressing, Routing, Network Layer Protocols) • Transport Layer(Protocols: UDP , TCP) • Application Layer (Client & Server Model, Application Protocols: DNS, FTP, Telnet, SMTP,SNMP,HTTP) • Network Access Layer Protocols( ethernet, token ring, FDDI, X.25, frame relay) • Internet Layer Protocols • Network Security (Aspects, Privacy, Encryption/Decryption, Digital Signature) Module - 6 Object-Oriented Programming and Database Management System Introduction to C++ & Data Structures • Introduction to Programming Techniques- Introduction to program & programming history, objective of program design, various programming techniques (Unstructured Programming, Procedural Programming, Modular Programming, Object-oriented Programming), programming languages (machine language, assembly language, high level language), translators (compiler & assembler), algorithm and flow chart. • Introduction to C++ - Brief history of C++, Characteristics and use of C++, Comparison of C and C++, C++ compiler and installation, Basic syntax and program structure of C++, identifiers and keywords, data types, Variables and constants, operators, manipulators, variable scope and storage class. • Control flow statements and loops- Conditional Statements, Switch Statement, Looping Statements, break, continue and Goto, Type Casting. • Functions : Function and its types, Declaration, Definition and Calling a Function, Function Arguments, Return Value, Passing Array to Function, Call by Value and Call by Reference, Recursion. • Arrays and Strings- Declaring and initializing an array, Entering and accessing array elements, Sorting and Searching array elements, Declaring and initializing two dimensional arrays, Entering, accessing and other operations on elements in a two dimensional array. Handling Strings in C++, string functions. • Pointers- What is pointer, Declaring and Initializing Pointer, Pointers to pointer, Pointer to Array, Passing pointer to function, Pointer Arithmetic. • Structure- What is Structure, Defining and declaring a Structure, Accessing Structure Elements, Array of Structure, Nested Structure. Pointers to structure. • Objects and Classes - OOPS Concepts, Defining class and object, Class members, Accessing the Data members, Constructors and types of Constructors, Destructors, This Pointer, Static, Inline function, Friend Function • Inheritance- What is Inheritance, Base Class and Derived Classes, Access control and Inheritance, Types of Inheritance, Aggregation. • Polymorphism- What is Polymorphism, Types of Polymorphism, Function overloading, Operator overloading, Function Overriding, Virtual Function. • Abstraction- Abstract Classes, Interface. • File Handling - Concept of Files, File opening in various modes, File closing, File pointers and manipulation, Text File and operations on Text Files, Binary File and operations on Binary Files. • Data Structures - Introduction to Data Structure, Abstract Data Type ,Algorithm Efficiency and Analysis, Pointers and Dynamic Arrays, Linked List, Stacks & Queues, Recursion ,Trees, Sorting and searching techniques Database Concept • What is Data • Database & Database Management System • Characteristics of Database Management System • Advantages & Disadvantages of Database Management System • Components of DBMS • Database Architecture • Types of Database Model • DBMS - ER MODEL • Codd's Rule for Relational DBMS • Basic Relational DBMS Concepts(Table, Tuple, Attribute, Relation Scheme, relation Key, Relational Integrity Constraints.) • What is Relational Algebra, Relational Calculus • ER Model to Relational Model • Types of Database Key • Database Normalization SQL Concept • Introduction to SQL • Data types in SQL • SQL Command (DDL: Data Definition Language, DML: Data Manipulation Language, TCL: Transaction Control Language, DCL: Data Control Language, DQL: Data Query Language) • DDL COMMAND (Create query, Alter query, Truncate, Drop and Rename query) • DML COMMAND (Insert, Update, Delete Command) • TCL COMMAND (Commit, Rollback and Savepoint Command) • DCL COMMAND (Select query, where clause, Like clause, order by clause, order by clause, group by clause, having clause, Distinct keyword, AND & OR Operator). • SQL Keys (Unique, Primary, Foreign, Composite, Alternate keys) • Join and set operations • Views and subquery • Triggers • Stored Procedure Module 7 Elective Module : Option 1 - Core Java Option 2 - Programming with Python Core Java • Introduction to Java (History and Evolution, Features of Java, Java Virtual Machine (JVM), Installing Java Development Kit (JDK), Configuring Integrated Development Environment (IDE), Structure of a Java Program, Variables and Data Types, Operators and Expressions, Conditional Statements, Looping Statements) • Object-Oriented Programming (OOP) Concepts (Introduction to OOP, Objects and Classes, Inheritance, Polymorphism, Encapsulation, and Abstraction, Constructors and Destructors) • Packages (How to declare a package in a company project, Package naming conventions, Sub packages, Types of packages such as user-defined packages, built-in packages, Importing packages in Java) • Exception Handling (Try-catch blocks, Multiple catch blocks, Custom exceptions) • File Handling (Streams (Byte Streams and Character Streams), Reading and Writing to Files) • Collections Framework (Lists, Sets, Maps, ArrayList, LinkedList, HashSet, HashMap, Iterators and Enumerations) • Multithreading (Introduction to Threads, Thread Class and Runnable Interface, Synchronization, Thread Safety and Deadlock) • Introduction to AWT programming (Component Class, Container Class, Layout Managers, Event Handling, Listeners, Frame Class, Panel Class, Canvas Class, Button Class, TextField Class, Checkbox Class, Choice Class, Menu and MenuItem Classes) • Applets (Defining the applet and Applet class, life cycle of applets , Creating an Executable applet, Designing a Web Page, Applet Tag, Adding Applet to HTML File, Running the Applet, Passing Parameters to Applets, Getting Input from Users,Font class , Graphics) • Swings (Swing components and Container, different layout, FlowLayout, BorderLayout , GridLayout, event handling) Programming with Python Unit 1: Introduction to Python • What is Python • Features / characteristics of Python • Advantage of learning Python • History and Versions • Application of Python • Installing Python & Environment setup • Environment Variables • First Python Program • Working in Console and Python Shell • Introduction to PYcharm • Basic Syntax • Variables and Data Types • Keywords and Comments • Numbers and Strings • Strings • Booleans • Operators Unit 2: Control Statements • if-else • Nested If • For loop • While loop • Break and Continue • Pass Unit 3: Data Structures • Lists • Tuples • Sets • Dictionary Unit 4: Functions • Functions and its Types • DefiningCalling a function • Pass by reference vs value • Function Arguments and types • The return Statement • Recursion • Scope of variables – Global and local variables • Built-In Functions • Passing Function to Functions • Python Lambda function Unit 5: File Handling • Writing data to a file • Reading data from a file • Working with files • Working with directories Unit 6: Python Modules and Packages • Creating and using a Module • Package creation and importing Unit 7: Python – Object oriented • Overview of OOP Terminology • Creating Classes • Creating Instance Objects • Accessing Attributes • Constructors and Destructors • Class Inheritance • Overriding Methods • Overloading operators and methods • Encapsulation Unit 8: Exception Handling • What is Exception • Default Exception Handler • Catching Exception • Raise an Exception • User defined Exception Unit 9: Regular Expressions • Understanding regular expressions • Regular expression Operations(Search, Match, Findall, Split) • “re” module functions • Validating passwords and email address using regular expression Unit 10: Database • Introduction to database • MySQL database • Creating connection • Creating database & tables • Insert, Read, update, delete, join commands Module 8 Introduction to Software Development Life Cycle (SDLC) • SDLC (Definition, need and Importance, Benefits of using SDLC) • Phases of SDLC ( Planning, Requirement Analysis, Design, Implementation/ Coding, testing, Deployment, Maintenance & Support) • Software Development Life Cycle Models (Waterfall Model, Spiral Model, DevOps Approach) • SDLC best practices ( Proper Documentation, regular Code reviews, Continuous testing and integration, security consideration) Module- 9 Employability Skills (DGT 60 hrs.) • Introduction to Employability Skills • Constitutional values - Citizenship • Becoming a Professional in the 21st Century • Basic English Skills • Career Development & Goal Setting • Communication Skills • Diversity & Inclusion • Financial and Legal Literacy • Essential Digital Skills • Entrepreneurship • Customer Service • Getting ready for apprenticeship & Jobs Module - 10 OJT/Project & Viva