L-1 Indian Heroes in IT/ 8th computer

 

Class 8^th

Subject : Computer Science

L-1 Indian Heroes in IT

Make a list of Indian Heroes in IT with their achievement

S.No.	Name	Achievements
1	Satya Narayan Nadella	CEO of Microsoft (2014 – present). Awarded the Padma Bhushan by the Government of India.
2	Sabeer Bhatia	Co-founder of Hotmail. Aims to replicate Silicon Valley's innovation ecosystem with Nanocity.
3	Vinod Dham	Inventor of the Pentium Chip, known as the Father of the Pentium processor.
4	Shiv Nadar	Pioneer of the computing and IT industry in India, founder of HCL in the 1970s.

 

A)   Multiple Choice Questions:

1)    Who is the inventor of Pentium Chip?

a)    Sabeer Bhatia

b)    Shiv Nadar

c)    Satya Narayan Nadella

d)    Vinod Dham

Ans: d)      Vinod Dham

 

2)    Sabeer Bhatia was born on ______________

a)    1968

b)    1970

c)    1978

d)    1980

Ans: a)1968

 

 

3)    Which award was given to Satya Narayan Nadella by the Government of India?

a)    Padma Bhushan

b)    Padma Vibhushan

c)    Padma shree

d)    Bharat Ratan

Ans: a)      Padma Bhushan

 

4)    Name the founder of Hotmail.

a)    Vinod Khosla

b)    Shantanu narayen

c)    Sabeer Bhatia

d)    Vinod Dham

Ans: c)      Sabeer Bhatia

 

B)  

586,       nano city,      Pentium ,    SabseBolo.com,    Hotmail,     Silicon

Fill in the blanks using the words from the help box:

 

1)    Sabeer Bhatia, a leading Indian Businessman is the co-founder of Hotmail.

2)    Bangalore is known as the silicon  Valley of India.

3)    Vinod was in-charge of developing the Pentium  processor.

4)    The aim of nano city  is to replicate the vitality and eco-system of innovation found in the Silicon Valley.

5)    Sabeer Bhatia had announced the launch of his latest venture SabseBolo.com.

 

C)   State “T” for True or “F” for False:

1)    Nadella was born on August 19, 1969 in Hyderabad, India. TRUE

2)    Shiv Nadar, a leading Indian businessman is the co-founder of Hotmail. FALSE

3)    Hotmail was an impressive innovation. TRUE

4)    Shiv Nadar was born in Mumbai, India. FALSE

5)    Vinod Dham is inventor of Pentium Chip. TRUE

 

D)   Short answer type questions:

1)    Who is the chief executive officer of the computer software company Microsoft?

Ans: Satya Narayan Nadella

 

2)    AMD stands for?

Ans: Advanced Micro Devices

 

3)    When was Sabeer Bhatia born?

Ans: 1968

 

4)    Who is the founder of HCL?

Ans: Shiv Nadar is the founder of HCL

 

5)    Where was Vinod Dham born?

Ans: Vinod Dham was born in Pune, India.

 

E)    Long answer type questions:

1)    Briefly explain Pentium Chip.

Ans: The Pentium Chip, developed by Intel and significantly contributed to by Vinod Dham, was a breakthrough in microprocessor technology. It featured advanced processing capabilities, increased speed, and efficiency, which revolutionized personal computing in the 1990s and established new standards for the industry.

 

2)    What was the achievement of Shiv Nadar in the IT industry?

Ans: Shiv Nadar founded HCL Technologies, transforming it into a global IT services company. His contributions significantly shaped India's IT landscape, making HCL one of the leading firms in the industry. He also established the Shiv Nadar Foundation to promote education and social development.

 

3)    Explain the advantages of IT in the field of education.

Ans: IT in education provides access to vast information, enhances learning through interactive tools, facilitates distance learning, and supports administrative efficiency. It enables personalized learning experiences and prepares students for a tech-driven future, making education more engaging and accessible.

 

4)    Name the IT companies if India.

Ans: Major IT companies in India include Tata Consultancy Services (TCS), Infosys, Wipro, HCL Technologies, and Tech Mahindra.

 

F)    Who am I?

1)    I am provided option to store, send and receive emails.

Ans: Hotmail

 

2)    I am chip, 90% computers run on me.

Ans: Pentium Chip

 

3)    I am one of the first webmail services that could be accessed from any web browser.

Ans: Hotmail

 

4)    I am a device and I store different types of information.

Ans: Hard Drive

 

G)   Discuss the role and importance of IT in personal life and in workplace.

Ans: IT plays a crucial role in personal life by enabling communication, access to information, entertainment, and online services. In the workplace, IT enhances productivity, streamlines operations, supports remote work, and fosters innovation. It is essential for data management, decision-making, and maintaining a competitive edge.

 

H)   In the time of globalization tell the importance of electronic commerce in the modern industrialization or multinational.

Ans: Electronic commerce is vital in globalization, providing businesses with access to global markets, reducing operational costs, and enhancing customer reach. It supports efficient supply chain management, facilitates international trade, and enables businesses to operate 24/7. E-commerce drives innovation and competitiveness in modern industrialization and multinational operations.

 

 

UNIT 3: DATABASE MANAGEMENT SYSTEM IT402 Class 10th

   Class -10th 

Information Technology (402)

UNIT 3:  DATABASE MANAGEMENT SYSTEM

using LibreOffice Calc

Practical Marks : 10

Download Libre Office:

1) Appreciate the concept of Database Management System:

• Identify the data and information,
• Identify the field, record, table in the database,
• Prepare the sample table with some standard fields.
• Assign the primary key to the field,
• Identify the primary key, composite primary key, foreign key.

2)  Create and edit tables using wizard and SQL commands :

• Start the Libre Office Base and observe the parts of main window,
• Identify the data base objects
• Create the sample table in any category using wizard,
• Practice to create different tables from the available list and choosing fields from the available fields.
• Assign data types of fields, Set primary key,
• Edit the table in design view, Enter the data in the fields

3)  Perform operations on table:

• Demonstrate to:
• Insert data in the table,
• Edit records in the table,
• Delete records from table,
• Sort data in the table,
• Create and edit relationships
• one to one, one to many, many to many,
• Enter various field properties.

4)  Retrieve data using query  :

• Prepare a query for given criteria,
• Demonstrate to create query using wizard, and using design view,
• Edit a query,
• Demonstrate to apply various criteria in query – single field, multiple fields, using wild card,
• Performing calculations using query in Base,
• Demonstrate to group data,
• Use basic SQL commands,

5)  Create Forms and Reports using wizard :

• Illustrate the various steps to create
• Form using Form Wizard,
• Enter or remove data from Forms,
• Demonstrate to modify Forms,
• Demonstrate to change label, background,
• Search record using Form,
• Insert and delete record using Form View,
• Illustrate the various steps to create
• Report using Report Wizard,
• Demonstrate various examples of Report.

UNIT 2: Electronic Spreadsheet (Advanced) using LibreOffice Calc IT402 class10th

  Class -10th 

Information Technology (402)

UNIT 2:  Electronic Spreadsheet (Advanced)

using LibreOffice Calc

Practical Marks : 5

Download Libre Office:

1) Analyse data using scenarios and goal seek.:

• Use consolidating data
• Create subtotals
• Use “what if” scenarios Use “what if” tools
• Use goal seek and solver

2)  Link spreadsheets data :

• Setup multiple sheets by inserting new sheets.
• Create reference to other sheets by using keyboard and mouse.
• Create references to other documents by using keyboard and mouse.
• Create, Edit and Remove hyperlinks to the sheet.
• Link to external data.
• Link to registered data source

3)  Share and review a spreadsheet:

• Set up a spreadsheet for sharing.
• Open and save a shared spreadsheet.
• Record changes.
• Add, Edit and Format the comments.
• Review changes – view, accept or reject changes.
• Merge and compare sheets

4)  Use Macros in spreadsheet  :

• Demonstrate the use of a macro recorder.
• Create a simple macro.
• Use a macro
• Pass arguments to a macro
• Pass the arguments as values
• Write the macros that act like built – in functions
• Access cells directly
• Sort the columns using macro

L-9 Cyber Security/Class-6 Computer

 

Class – VI

Subject : Computer Science

L-9 Cyber Security

 
 A)   Answer the following questions:
1)    What do you mean by cyber security?
Ans: Cybersecurity refers to the practice of protecting computer systems, networks, and data from theft, damage, or unauthorized access. It involves implementing measures to ensure the confidentiality, integrity, and availability of digital information.
 
2)    What do you mean by Malware? Define its types.
Ans: Malware, short for malicious software, is a type of software designed to harm or exploit computer systems. Types of malware include:
 
Viruses: Programs that replicate and spread by attaching to other programs.

Worms: Self-replicating programs that spread independently over networks.

Trojans: Programs that appear legitimate but contain malicious code.

Spyware: Software that secretly gathers information about a user.

Ransomware: Malware that encrypts files and demands a ransom for their release.
 
3)    What are the types of Cyber-attacks.
Ans: Types of cyber-attacks include:
 
Phishing: Deceptive attempts to obtain sensitive information by posing as a trustworthy entity.

Denial-of-Service (DoS) attacks: Overloading a system to make it unavailable to users.

Man-in-the-Middle (MitM) attacks: Intercepting communication between two parties.

SQL Injection: Exploiting vulnerabilities in database query languages.

Cross-Site Scripting (XSS): Injecting malicious scripts into web pages.
 
4)    What are the prevention steps of Cyber-attacks?
Ans: Prevention steps for cyber-attacks include:
 

• Keeping software and systems up-to-date with the latest security patches.
• Using strong, unique passwords and enabling multi-factor authentication.
• Implementing firewalls and antivirus software.
• Educating users about phishing and social engineering tactics.
• Regularly backing up data to prevent loss in case of an attack.

 
B)    State ‘T’ for True or ‘F’ for False:
1)    Malware is the common cyber threats. TRUE
2)    SL injection is not a type of cyber-attacks. FALSE
3)    E-mail attachment could be infected with Malware. TRUE
4)    Trojan is a type of Malware. TRUE

C)    Fill in the blanks:
1)    Malware means malicious software .
2)    Network Security is a practice of  securing  a computer network.
3)    Cyber attack is an example of  a security breach .
 
 

L-8 Python/ Class-6th Computer

 

Class – VI

Subject : Computer Science

L-8 Introduction to Python

 

Paste and Label  components of Python Window

 

Introduction to Python

Download

A)   Fill in the blanks:

1)    Guido Van Rossum  invented python at CWI, Netherland.

2)    The full form of CWI is Centrum Wiskunde &  Informatica .

3)    There are  two  modes in python language.

4)    IDLE is an acronym of Integrated Development and Learning Environment.

 

B)    Short answer type questions:

1)    What is difference between compiler & Interpreter.

Ans: A compiler translates the entire source code into machine code before execution, producing a standalone executable file. An interpreter, on the other hand, translates and executes the source code line by line without producing a separate executable.

 

2)    What is difference between Interactive & Script mode.

Ans: Interactive mode allows users to enter commands directly into the Python shell, and the results are immediately displayed. Script mode involves saving a sequence of Python commands in a script file and executing the entire script at once.

 

3)    What is the use of print statement?

Ans: The print statement is used to display output in Python. It allows you to print text, variables, or expressions to the console, making it a useful tool for debugging and providing information to the user.

 

4)    What is python?

Ans: Python is a high-level, interpreted programming language known for its readability and simplicity. It supports multiple programming paradigms and is widely used in various domains, including web development, data science, artificial intelligence, and more.

 

5)    Write down any two features of Python language.

Ans: Two features of Python language are:

 

Readability: Python code is easy to read and understand, promoting a clean and concise coding style.

Extensive Libraries: Python has a rich standard library and numerous third-party libraries, providing pre-built modules for various tasks.

C)    State ‘T’ for True or ‘F’ for False:

1)    Python is a platform Independent language. TRUE

2)    Python is an example of compiled language. FALSE

3)    Script mode is the command line shell mode. FALSE

4)    Multiline comment is also known as block comment. TRUE