Information Technology 11th HSC Commerce Maharashtra State Board Topics and Syllabus

• An Introduction to It (Information Technology) 
  • Definition of Information Technology
• Data and Information 
  • Need of information
• Computer 
• Computer - Input Unit 
• Computer - Central Processing Unit (Cpu) 
• Computer - Types of Memory 
  • Primary Memory - Cache, RAM, ROM 
  • Secondary Memory - Fixed and Removable Storage (Hard Disk Drive, Cd/Dvd Drive, Pen Drive, Blue Ray Disk) 
• Computer - Output Unit 
• Units of Memory 
• Computer Hardware 
• Computer Software 
  • MS Excel or Spreadsheet
  • Data Entry and Storing Procedures in Excel
  • Data Processing and Computation
  • Central Tendencies
• Categories of a Software 
  • Open source software
  • Closed source software
• Application Software 
• System Software 
• Operating Systems for Personal Computers 
• Operating Systems for Mobile Phones 
• Introduction to GNU/Linux 
• Graphical User Interface (GUI) 
• Command Line Interface (CLI) 
• The GNU/Linux File System Hierarchy Standard 
• Advantages of GNU/Linux 
• Types of Computer Networks 
• Local Area Network (Lan) 
• Metropolitan Area Network (Man) 
• Wide Area Network (Wan) 
• Peer-to-peer Architecture 
• Client-server Architecture 
• Internet 
• History of Internet 
• Protocols 
• IT Enabled Services 
• Recent Trends in IT 
  • Green Computing 
  • Internet of Things (IoT)
  • Cloud Computing
  • Data Analytics (DA)
  • Artificial Intelligence (AI) 
  • Machine Learning (ML)
  • Big Data 
  • Blockchain

An introduction to IT (Information Technology)

• Definition of Information Technology

Data and Information

• Need of information

Computer

Computer - Input unit

Computer - Central Processing Unit (CPU)

Computer - Types of memory

> Primary Memory

> Secondary Memory

Computer - Output Unit

Units of Memory

Computer Hardware

Computer Software

Categories of a software

• Open source software
• Closed source software

Application Software

System Software

Operating Systems for Personal Computers

Operating Systems for Mobile Phones

Introduction to GNU/Linux 

Graphical User Interface (GUI)

Command Line Interface (CLI)

The GNU/Linux File System Hierarchy Standard

Advantages of GNU/Linux

Types of computer Networks

Local Area Network (LAN)

 Metropolitan Area Network (MAN)

Wide Area Network (WAN)

Peer-to-Peer Architecture

Client-Server Architecture

Internet

History of Internet 

Protocols

IT Enabled Services

Careers in IT

Recent trends in IT

• Green Computing 
• Internet of Things (IoT)
• Cloud Computing
• Data Analytics (DA)
• Artificial Intelligence (AI) 
• Machine Learning (ML)
• Big Data 
• Blockchain

• Definition of a Database 
• Data Vs Information 
• Concept of Database Management System (DBMS) 
  • Introduction to DBMS
  • Evolution of DBMS
  • DBMS Concepts
  • Characteristics of Database Management System
  • Advantages of DBMS
  • Components of DBMS
• Applications of DBMS 
• Advantages of DBMS 
  • Reducing Data Redundancy 
  • Sharing of Data 
  • Data Integrity 
  • Data Security 
  • Privacy 
  • Backup and Recovery 
  • Development and Maintenance Time 
• Data Types in the DBMS 
• Data Model 
  • Types of Data Model

  1. Hierarchical Model
  2. Relational Model
  3. Network Database Model
  4. Entity Relationship Model
  5. Object Model

  • Types of DBMS Users
• Relational Model of DBMS 
• Properties of Transactions (ACID) 
  • Atomicity
  • Consistency
  • Isolation
  • Durability
• Introduction of RDBMS 
• Basic Database Concepts 
  • Table 
  • Field 
  • Record 
  • Key 
  • Primary Key 
  • Foreign Key 
• Relationships in a Database 
  • One-to-one 
  • One-to-many (Or Many-To-One) 
  • Many-to-many 
• Introduction to SQL 
  • Types of SQL Commands

  1. Data Definition Language (DDL)
  2. Data Manipulation Language (DML)
  3. Data Query Language (DQL)
  4. Transaction Control Language (TCL)
  5. Data Control Language (DCL)
• Data Definition Language (DDL) Commands 
• Data Manipulation Language (DML) Commands 
• Data Control Language (DCL) Commands 

Definition of a Database

Data vs Information

Introduction to Database Management System (DBMS)

Applications of DBMS

Advantages of DBMS

> Reducing Data Redundancy

> Sharing of Data

> Data Integrity

> Data Security

> Privacy

> Backup and Recovery

> Development and Maintenance Time

Data types in the DBMS

Data model

Relational Model of DBMS

Properties of Transactions (ACID)

• Atomicity
• Consistency
• Isolation
• Durability

Introduction of RDBMS

Basic Database Concepts

> Table

> Field

> Record

> Key

> Primary key

> Foreign Key

Relationships in a database

> One-to-One

> One-to-Many (or Many-to-One)

> Many-to-Many

Introduction to SQL

Data Definition Language (DDL) Commands

Data Manipulation Language (DML) Commands

Data Control Language (DCL) Commands

• Common Terms Used on the Web 

  Webpage, Website, Web Browser, Web Server, URL(Uniform Resource Locator), HTTP, HTML

• Introduction to HTML5 
  • Basic structure
  • An attribute
• HTML Text Formatting Element 
• HTML Heading Levels 
• HTML Image 
• HTML Table 
  • Tags 
  • Attributes 
  • Rowspan 
  • Colspan 
• Html Hyperlinks 
  • Text hyperlinks
  • Image hyperlinks
• HTML Forms 
  • Basic HTML Form Controls

  1. PHP Basic Form Handling
  2. Basic PHP Form Validation
• HTML Input Tag 
  • Attributes of Input
• HTML Textarea Tag 
• HTML Select Tag 
• Insertion of Javascript in HTML 
• JavaScript Variables 
  • Basic Data types and Declaring variables
  • Rules for naming variable
  • Scope of variables
  • Assigning values to variables
  • JavaScript Literals
  • Type casting in JavaScript
• JavaScript Data Types 
  • Number 
  • String 
  • Boolean 
  • Infinity 
  • Null 
  • Undefined 
• JavaScript Arithmetic Operators 
• "+" Operator in Javascript 
• JavaScript Assignment Operators 
• JavaScript Relational Operators 
• Javascript Logical Operators 
• JavaScript Increment and Decrement Operators 
• JavaScript Comments 
• JavaScript "If" Statement 
• JavaScript "Else" Statement 
• JavaScript Functions 
• JavaScript Event Handling 

Common terms used on the web

Webpage, Website, Web Browser, Web Server, URL(Uniform Resource Locator), HTTP, HTML

 Introduction to HTML5

• Basic structure
• An attribute

HTML tags

HTML Text formatting element

HTML Heading Levels

HTML Image

HTML Table

> Tags

> Attributes

> rowspan

> colspan

HTML hyperlinks

• Text hyperlinks
• Image hyperlinks

HTML Forms

HTML Input tag

• Attributes of Input

HTML Textarea tag

HTML Select tag

Insertion of JavaScript in HTML

JavaScript variables

JavaScript data types

> Number

> String

> Boolean

> Infinity

> null

> undefined

JavaScript arithmetic operators

"+" operator in JavaScript

JavaScript assignment operators

JavaScript relational operators

JavaScript logical operators

JavaScript increment and decrement operators

JavaScript comments

JavaScript "if" statement

JavaScript "else" statement

JavaScript functions

JavaScript event handling

 

• Introduction to Cyberlaw 
• Advantages of Cyber Law 
• Cyber Crimes 
• Cyber Crime Examples 
  • Software Piracy
  • Unauthorized access
  • Copyright violation
  • Cracking
  • Cyberbully or Cyberstalking
  • Phishing
  • Plagarism
  • Hacking
• Cyber Safety and Security 
  • Identify threats and risk
  • Protection of data
  • Recovery from a cyber attack
• Do’s and Don’ts for Students in Cyber World 
• Security Procedures 
  • Encryption
  • SSL (Secure Socket Layer)
  • Firewall
• Cyber Crime Parental Guidance 
• IT Act of India 2000 
  • Salient Features of I.T. Act
• Cyber Crime Case Studies 

Introduction to Cyberlaw

Advantages of Cyber Law

Cyber Crime

Cyber Crime examples

• Software Piracy
• Unauthorized access
• Copyright violation
• Cracking
• Cyberbully or Cyberstalking
• Phishing
• Plagarism
• Hacking

Cyber Safety and Security

• Identify threats and risk
• Protection of data
• Recovery from a cyber attack

Do’s and Don’ts for students in cyber world

Security Procedures

• Encryption
• SSL (Secure Socket Layer)
• Firewall

Cyber Crime Parental guidance

IT Act of India 2000 

• Salient Features of I.T. Act

Cyber Crime Case studies