CLASS VII

• Computer hardware and components
• Number System – An Introduction
• Computer Virus
• Ethnics and Safety Measures
• Spreadsheets – An Introduction
• Database and DBMS – An introduction
• HTML – Advanced Features

CLASS VIII

• Operating System and Graphical User Interface – Role and Functions
• Spreadsheets – Functions and Charts
• Algorithms and Flow Charts
• Program Coding
• App Development
• Networks

Computer Hardware and Components

Key Concepts

• Computer Hardware – external and Internal
• Brief explanation with examples of hardware and some of its parts (CPU, Disk drives, Power supply (SMPS), Motherboard, Ports, Modem, peripheral devices (keyboard, mouse, pen drive, scanner, printer etc.).

Number System – An Introduction   

Key Concepts

• Introduction to Number system: need for number systems and examples of various number systems.
• Digits and bases of different number systems
• Represent value in different number systems (Decimal, Binary, Octal and hexadecimal number system)
• Conversion from decimal to binary and vice versa

COMPUTER VIRUS

KEY CONCEPTS

• Definition and example of Virus
• Type of Virus (boot sector and Program file virus – definition and examples)
• Virus Symptoms and Harm causes by virus
• Antivirus – definition and example
• Ways to prevent a virus (scanning of CDs and pen drives etc, downloading from a secured source)
• Definition and example of forms of virus attack (malware, worm, spyware, Trojan horse, sweeper)

Ethics and Safety measures in Computing

KEY CONCEPTS

• Advantages and disadvantages of using internet - A brief introduction to ethics in computing.

• Unethical practices prevalent in the society, related to internet:
  • Plagiarism
  • Cyber bullying
  • Hacking
  • Phishing
  • Spamming
  • Software Piracy
  • Intellectual property rights

,

• Meaning and a brief explanation of the different unethical practices stated above in point no. 3. along with the preventive measures.

• Safety Measures to be taken while using the computer and internet. Parental assistance for minors, such as- viewing age appropriate websites, keeping strong password, not sharing passwords, frequently changing passwords, responding to emails only from known person or organization etc. Protection using Firewall (meaning and a brief explanation). ?

• Digital footprints (meaning and sensitising children about it.)

Spreadsheets – An Introduction

KEY CONCEPTS

• Features of spreadsheet and its advantages.

• Components of Spreadsheet
  • window: workbook and worksheet, sheet tab, cell, cell address, active cell, formula bar, row, column, name box.

• Entering data in a spreadsheet
• Types of data (number, string and formula).
• Perform calculations.
• Enter simple formulae.
• Select cells.
• Change cell contents.
• Use Undo and Redo features.
• Insert and deleting columns and rows.
• Copy and move data.
• Use auto fill feature.

Database and DBMS – An Introduction

KEY CONCEPTS

• Meaning of Database and DBMS.
• Uses of database with examples.
• Create and Save a database.
• Primary Key.
• Querying a Database

HTML – Advanced Features

KEY CONCEPTS

• Create lists ( , )
• Insert Images in web pages 
• Insert links tables
• Display objects through
• Create forms using tag.

Operating System and Graphical User Interface – Role and Functions

KEY CONCEPTS

• Introduction, need, functions, features and types of Operating System: definition and examples of single user.
• Meaning of user interface and its types (CUI, GUI).
• Introduction to GUI and its advantages.

Spreadsheet – Functions and Chart

KEY CONCEPTS

• Method to enter formulae.
• Meaning of Range, selecting range, naming a range.
• Cell referencing and its types (relative, absolute, mixed –with examples).
• Naming, renaming and deleting a sheet from sheet tab.
• Meaning of Functions.
• Rules to enter a function like Sum, Average, Max, Min, count, etc.
• Creating a chart.

Algorithms and Flowcharts

KEY CONCEPTS

• Introduction to algorithm – definition and its use.
• Characteristics of a good algorithm.
• Steps to develop an algorithm.
• Writing algorithms.
• Definition of flowcharts.
• Various symbols used in flowcharts.
• Solving problems by writing algorithms and drawing flowcharts till decision making. (excluding loops).

Program Coding

KEY CONCEPTS

• Introduction to Program
• coding/ programming.
• Components of a program: identifiers, their naming rules.
• Literals (like integer, real and string).
• Data types and the need for different data types (like int, char, float, etc.).
• Declaration and initialisation of variables.
• Arithmetic operators (+, -, *, /, %), relational and logical operators.
• Assignment operator and its use.
• Compiling and executing programs.

• Concept, use and syntax of if, if else, if else if ladder