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