Information Technology Class 10 (IT 402 Class 10) – has been designed by the teachers and examiners team. The team have collected all Important MCQs and Subjective Questions and Answers from the Textbook.
Information Technology Class 10 Question Answer – This article provides solutions for Class 10 IT code 402. As per the latest updates from CBSE Syllabus. The article contains solutions for both Part A: Employability Skills and Part B: Subject Specific Skills. Part A has 5 chapters with a total of 10 marks for the board exam, and solutions for all chapters of Employability Skills are provided.
Part B has 4 chapters with a total of 40 marks, making it the most important section for students to score well in their Class 10 Information Technology Code 402 exams. It is suggested to thoroughly read the notes and then move on to the questions and answers section to understand the chapter in an easy manner.
IT is part of the larger field of Information and Communications Technology (ICT). Students aiming for a career in engineering should perform well in this subject as IT is a widely pursued branch of engineering. Practicing question and answer with Class 10 IT sample papers can help students prepare effectively for their board exams and increase their chances of scoring well.
Information Technology Class 10 MCQ – MCQs have become increasingly important in Class 10 Information Technology exams, so it is essential for students to practice answering these types of questions. We have compiled the best collection of chapter-wise MCQs questions for Class 10 Information Technology based on the latest NCERT textbooks. Students can click on the links to practice these questions.
Multiple choice questions are a common feature of Class 10 Information Technology exams, where a question is presented with four options and the student must choose the correct answer. To ensure the student can accurately answer these questions during the exam, it is important for them to practice these MCQs regularly as time is limited during the actual exam.
Information Technology Class 10 Notes – These Class 10 IT notes are concise and comprehensive, designed to save you valuable time. They cover all the important aspects of the Class 10 IT NCERT textbook. The Information Technology curriculum has been updated and is now divided into two parts: Part A focuses on Employability skills, and Part B covers Subject Specific skills.
This article provides a notes for CBSE Class 10 Information Technology (Code 402) according to the revised syllabus for the Board Examination. CBSE has made changes to the syllabus and exam pattern for almost all subjects, including a new format for the final term exam where only 50 marks are theory, with the remaining 50 marks given by the school through internal and practical assessments. The practical examination will consist of a written computer-based test, as well as a VIVA-VOCE oral test where the teacher will ask questions to assess the students’ complete understanding. These changes aim to provide students with a more relaxed examination experience.
Teachers and Examiners (CBSESkillEduction) collaborated to create theWeb Application and Security Class 10 Notes. All the important Information are taken from the NCERT Textbook Information Technology (402).
Web Application and Security Class 10 Notes
Session 1 : Working with Accessibility Options
Computer Accessibility means making computer systems user-friendly for everyone, including individuals with disabilities, with the help of Assistive Technology. It allows people with disabilities or impairments to use computers effectively. There are various types of disabilities that can affect computer usage, such as –
Visual Impairment
Hearing Impairment
Motor Impairment
Cognitive Impairments and Learning disabilities.
Attention Deficit Hyperactivity Disorder (ADHD) and autism
How to Launch Accessibility Option
To launch accessibility options in Windows XP Click on Start > Control Panel > Accessibility Option
Various tabs in Accessibility Option
Keyboard Tab
Sticky Keys : Sticky Keys makes it easier for people with disabilities to use keyboard shortcuts and commands Sticky Keys allowing them to push one key at a time rather than many keys at once. For those who have trouble pushing many keys at once or have motor disabilities.
Filter Keys : People with motor disabilities or who have difficulty typing quickly. When Filter Keys is enabled, the computer will ignore brief or repeated keystrokes, which can reduce accidental keystrokes and improve typing accuracy. This feature also allows the user to adjust the keyboard’s repeat rate and delay.
Toggle Keys : Toggle Keys makes an audible sound whenever the Caps Lock, Num Lock, or Scroll Lock keys are depressed. This feature is useful for people with visual impairments or who have difficulty recognizing when these keys are pressed.
Sound Tab
SoundSentry : If the user have hearing loss, hearing difficulties, or who prefer visual signals can benefit from SoundSentry. SoundSentry helps the computer shows a visual warning indication to the user such as a flashing title bar or taskbar button, to draw the user’s attention.
ShowSounds : This feature is designed to help users who are deaf or hard of hearing or who have difficulty hearing system sounds. This feature provides visual warning and sounds warning both, such as startup sounds with startup logo, error beeps with warning message, flashing windows with sound, bouncing icon with sound, and other system alerts.
Display Tab
Hight Contrast : High Contrast is an accessibility feature in computer which helps to change the font size and color of the text, increases the contrast between foreground and background colors, bolder colors for text, increasing the thickness of lines and borders, This will making text and images more visible and easier to read for people with visual impairments.
Cursor Options : Cursor Options refer to the settings that control the behavior and appearance of the mouse or other pointing device in a computer system, for example change in the cursor speed, pointer size, and mouse button configuration. This option is particularly those who having mobility impairments or difficulties using a standard mouse or touchpad.
Mouse Tab
MouseKeys : MouseKeys is an accessibility feature in computers that allows users to control the mouse cursor using the numeric keypad instead of a standard mouse or touchpad. This feature is particularly useful for people with mobility impairments or difficulties using a standard mouse.
Serial Keys : Serial keys is an accessibility feature that allows users to control a computer using special input devices that can be connected to the computer’s serial port. These input devices, such as sip-and-puff switches or breath controllers, enable users with limited mobility or dexterity to provide input to the computer without using a keyboard or mouse.
Sip-and-Puff input devices typically consist of a mouthpiece or tube that users can sip or puff into, and a sensor that detects the airflow and translates it into input signals that the computer can recognize.
Session 2 : Networking Fundamentals
A network is a group of computers or other devices that are connected together to enable resource sharing, information sharing and communication with the help of communcation channels between the devices in a network. With the help of communication channels user can share file, printers, and other resources, as well as communicate with other using chat, email or video conferencing.
Network are designed based on following architectures –
Peer-to-Peer Architecture: This type of architecture enables devices to communicate and share resources directly with each other, without the need for a central server. This type of network has an equal status and competent CPU.
Client-Server Architecture: This type of architecture uses servers to manage resources and provide services to clients. Clients send requests to the server, and the server responds with the requested information.
Types of Network
Local Area Network (LAN): A network that covers a small area, such as a home or office, and connects devices together to enable communication and resource sharing.
Wide Area Network (WAN): A network that spans a large geographic area, such as a country or the world, and connects different LANs and other networks together.
Metropolitan Area Network (MAN): A network that covers a geographic area larger than a LAN but smaller than a WAN, such as a city or region.
Advantages of using Network
Resource Sharing: Networks allow to share resources, such as printers, scanners, and storage devices, among multiple users.
Communication: Networks allow users to communicate and collaborate with each other through email, chat, video conferencing, and other tools.
Data Transfer: Networks enable high-speed data transfer and sharing to multiple users.
Centralized Management: Networks allow for centralized management of devices making it easier to monitor and control access to sensitive data and applications.
Internet
The Internet is a global system of interconnected computer networks which connect billions of people world wide using a internet porotocol. It is made up of many different networks, including public, private, commercial, academic and government networks. The basic work of Internet is access and sharing information, resources and services.
What are the different uses of Internet
Communication: Online messaging, video calls and social media.
Information: Access to vast information through search engines like Google.
Entertainment: Streaming music, movies, TV shows, online gaming, and social media.
Education: Online learning and educational resources.
Commerce: Online shopping and e-commerce.
Research: Collaboration and information sharing for breakthroughs in medicine, engineering, and technology.
a)World Wide Web: The World Wide Web, also referred to as the Web or W3, is a collection of connected hypertext pages that may be accessed online. Web pages that contain text, photos, videos, and other multimedia can be viewed using a web browser, and one can use hyperlinks to move between them.
b)Web Browser: A web browser is a software application that allows users to access and view web pages on the World Wide Web. Some of the popular web browsers include Chrome, Firefox, Safari, and Edge.
c)Web Server: A web server is a computer system that stores websites and their associated files for access over the internet.
d)Internet Service Provider: An Internet Service Provider (ISP) is a company that provides internet access to customers. ISPs connect users to the internet via various technologies such as dial-up, DSL, cable, fiber-optic, or wireless connections. ISPs offer various internet plans with different speeds, data limits, and prices.
Example – Bharat Sanchar Nigam Limited (BSNL), Airtel, MTS, Vodafone, Tata Docomo, etc.
e)Modem: A modem is a device that enables computers to transmit data over telephone lines or cable lines. It converts digital signals generated by computers into analog signals that can be transmitted over a telephone or cable line, and vice versa. Its is also known MOdulator/DEModulator.
f)Types of Common Internet Connectivity: The many types of Internet connectivity that are currently accessible can be broadly divided into wired and wireless access. The table below provides a summary of several Internet access options, divided into wired and wireless:
Technology
Type of Connectivity
Dial-up
Wired
DSL
Wired
Cable Internet Access
Wired
3G
Wireless
WiMax
Wireless
Wi-Fi
Wireless
Some of the commonly used Internet connectivity are –
a) Dial-up: Uses a modem to establish a connection over a phone line. Slow and outdated technology.
b) DSL: Digital Subscriber Line uses existing phone lines to provide high-speed internet access. Offers faster speeds than dial-up.
c) Cable Internet Access: Uses a cable television line to provide high-speed internet access. Offers faster speeds than DSL.
d) 3G: Third-generation cellular network that offers mobile internet access.
e) WiMAX: WiMAX (World Wide Interoperability for Microwave Access) is a wireless broadband technology that offers high-speed data transmission over a wide area.
f) Wi-Fi: Wi-Fi (Wireless Fidelity) is a wireless networking technology that allows devices to connect to the internet using radio waves.
Session 3 : Introduction to Instant Messaging
Instant Messaging: Instant messaging (IM) is a real-time or online communication method that enables users to send and receive text messages and other digital files through a network or the internet.
Features of an instant messaging are as follows:
Quick and easy communication between individuals or groups.
It is a cost-effective communication method as it does not require expensive phone calls or postage.
Instant messaging allows for real-time collaboration and decision-making.
It enables users to share files, images, and other multimedia quickly and easily.
Users can stay connected with friends and family around the world in real-time.
It provides a record of conversation history.
Type of Instant Messaging : There are two Types of Instance Messaging (IM) Application Based and Web Based.
a) Application Based: Application based instant messaging software can download and installed in Computer and mobile phone. Some of the popular Instance Messaging Software are –
Google Talk
Yahoo! Messanger
Skype
Windows Live Messenger
Rediff Bol, etc
b) Web Based: Web based instant messaging software can open in web browsers for example Google Chrome, Mozilla Firefox, Microsoft Edge etc. Some of the popular web based Instant messaging software are –
Yahoo! Messenger (Support Application and Web both)
Meebo
MSN Web Messanger
IMO, etc.
Session 4 : Chatting With A Contact – Google Talk
Google Talk: A free instant messaging service offered by Google was called Google Talk. Users could make audio calls, send files, and chat with other Google Talk users on a computer or mobile device.
Google Talk was officially discontinued by Google in 2017, and its features have been merged into Google Hangouts.
There are some general rules and etiquettes to be followed while chatting.
Use appropriate language and tone
Avoid using all caps as it can be interpreted as shouting
Use proper grammar and spelling to ensure clear communication
Respect other people’s privacy and personal information
Do not share sensitive or confidential information
Stay on topic and avoid excessive or irrelevant messages
Be mindful of other people’s time and avoid sending too many messages in a short period
Avoid using offensive language or making derogatory comments about others
Do not send spam or unsolicited messages
Be polite and courteous in all communications.
Session 5 : Creating and Publishing Web Pages – Blog
Blog: A blog is a type of website or online platform where an individual or group of individuals can share their thoughts, opinions, experiences, or knowledge on various topics in the form of written articles or posts. Blogs can be personal or professional in nature, and can cover a wide range of topics such as food, travel, politics, technology, and more.
Some of the popular Website provide blog services are –
www.WordPress.com
www.blogger.com
www.blog.com
www.weebly.com
www.blogsome.com
Session 6 : Using Offline Blog Editors
Offline blog editors are software tools that allow users to create and edit blog posts offline, without the need for an internet connection. These editors typically offer more features and customization options than online editors, and they allow bloggers to work on their posts at their own pace and on their own schedule.
Free offline blog editors are –
Qumana
Windows Live Writer
Blogdesk
Session 7 : Online Transactions
Online transactions have made transactions very convenient and simplified the workflow in many forms in a business. Online transactions deals with transfer of money over the internet. Revolution in the electronic media has made transaction handling easy .
Online shopping could be useful in situations when:
A customer does not have sufficient time to visit stores.
When you are unable to leave your home due to illness, disability, or other constraints.
When you want to take advantage of online-exclusive deals and discounts.
Visiting a store is more expensive than purchasing a product online.
A product or service that is not available in the local market is available online.
Some of the popular online transaction websites are:
IRCTC, an online portal for booking flight and train tickets.
Flipkart, an online shopping portal for buying consumer products.
EBay, an online portal for buying and selling goods.
Redbus, an online portal for booking bus tickets.
Session 8 : Internet Security
Internet security is a branch of computer security specifically related to the Internet, often involving browser security but also network security.
Best Practices for Security
Use strong passwords. You can make a password that is difficult for other users to guess or crack by combining alphanumeric and special characters. Avoid using single or combination passwords that include your favourite colour, names of friends or family members, bike number, or mobile number.
Following is a general guideline for managing strong passwords.
Length: Make sure the password is at least 12-14 characters long if possible.
Avoid repetition: Do not use the same character or set of characters repeatedly in the password.
Avoid dictionary words: Do not use words that can be found in a dictionary.
Avoid sequences: Do not use letter or number sequences such as “abcdefg” or “123456”.
Avoid personal information: Do not use usernames, pet names, relatives’ names, or something that the public or workmates know you strongly like or dislike.
Include numbers and symbols: If allowed, include numbers and symbols in the password.
Use both upper and lower case letters: Use a mix of upper and lower case letters in the password.
Avoid reusing passwords: Do not use the same password for multiple sites or purposes.
Consider using a random password generator: If possible, use a random password generator to create a strong and unique password.
Example: A strong password example is “u1vX:,4Hd{]$”.
Encryption Software
Encryption Software convert the data or information into a secret code or cipher, which can only be accessed with a specific decryption key. This type of software is commonly used to protect sensitive data from unauthorized user or theft.
How to prevent our personal information
Don’t share your personal information related to your credit card or online banking, such as your credit card number, account information, etc.,
Use antivirus and antispyware software
Antivirus and Antispyware programs also offer real-time protection monitoring your computer for any changes by malware software.
Do not immediately respond to mails from unknown users
Clear browser cookies frequently
Keep the operating system and software applications up to date
Never install software from unknown sources
Remove unwanted or unknown software applications
Install firewalls
A firewall, which could be hardware or software, can help keep a network and computer secure. Firewalls examine network traffic to decide whether or not it should be permitted.
Clearing Data Stored In Browsers
Passwords entered into online forms can be stored using the built-in password management features of web browsers. When users try to enter into websites, browsers frequently ask if they want to save their usernames and passwords.
To clear personal data from a web browser such as Mozilla Firefox, launch the browser.
Click Tools Menu, click Options.
Click Security Tab. The following window will be displayed:
Session 9 : Maintain Workplace Safety
Maintain Workplace Safety
A uniform set of safety guidelines and practises must be followed by every organisation. These guidelines must be expressed and prominently displayed in key locations. To follow safety regulations, all staff must get training and demonstrations.
Workplace safety basics to follow: fire safety, slip-and-fall prevention, electrical safety, and first aid.
Basic Fire safety rules in an organization are
Fire escape plans must be installed at proper levels
Conduct regular drills
Smoke alarms must be placed at proper intervals
Keep workplace a no-smoking zone
Maintenance of safety equipment must be taken care of regularly
Falls and Slips Safety rules
Keep the moving area clean and clutter free.
Workplace must be proper ventilated receive light.
Wear non slippery footwear.
Floors must be clean and dry
Oil spills, dust must be immediately cleaned.
Electrical Safety Rules
Electrical equipment used should be approved by a recognised organization.
Workers should be trained to handle the electric equipment safely
Damaged and hazardous electrical equipment should be immediately replaced. All old and workout and frayed switches and wires should be changed.
Heat emanating equipment should be kept away from the electrical equipment.
Take care that the outlets/ circuits should not be overloaded .
Switch off and unplug the electrical appliances before cleaning or relocating them.
Some rules of First Aid are
Assure the injured to remain calm and not to panic
Keep them warm if they are under shock
Do not move the victim in case of back/neck injury
Session 10 : Prevent Accidents and Emergencies
Types of Accidents:
Accidents may be of following types :
Accidents at workplace : Slips and fall accidents, fire
Industrial disease/illness
Road traffic accidents
Clinical Accidents
Sports related accidents
Handling Accidents
Every organization must follow SOP for accident handling
Safety measures must be placed to prevent workplace accidents
Immediately call the medical team for any injury
Stay alert
Pay attention to and follow emergency drills
Emergency
To stop more losses and to reduce the loss, an emergency needs to be treated right away. To spot any form of disaster, one must be vigilant. There are numerous crises that could happen at home. in job or in school.
Types of Emergency
There are many different kinds of emergencies, thus it is important to have an emergency management plan in place. The following are some examples of emergencies:
Chemical spills
Extreme heat waves
Droughts
Pandemics
Terrorist attack
Fire
Floods
Thunderstorms
Leakage of some hazardous gas/ chemical
Some of the types of emergencies that require evacuation are:
A company may face health risks that risk the lives of its employees. A hazard is something that could potentially cause harm, damage, or any type of loss of life or health.
Hazards can be of different types depending on the industry and the environment in which the employees work. The different types of hazards include:
Physical
Chemical
Biological
Mechanical
Sources of Hazards
Checklist for Workstations : The workstation should:
provide sufficient space for the user to alter position comfortably
provide adequate lighting
have windows fitted with adjustable coverings to alter the sunlight level
be spacious enough when a workstation is shared by more than one person
The display screen should:
display well-defined characters of adequate size and spacing
have a stable image
have easily adjustable brightness and contrast
tilt and swivel easily to suit the user
be free from glare and reflection.
Use a separate base for the screen or an adjustable table
The keyboard should:
be able to tilt easily and should be able to separate from the screen to allow the user to adopt a comfortable working position
have space in front to provide support for the hands or arms of the user
have a matt surface
have clearly legible symbols on the keys
The work surface should:
provide adequate space for the user
have a low reflective surface
be of an adequate size to allow the screen, keyboard and other peripherals to be flexibly arranged
have a stable and adjustable document holder, which should be at the same level as the screen and at the same viewing distance
Workplace Evacuation
There should be a plan in place for evacuation in an emergency. In the event of an emergency or disaster, evacuation is the process of vacating a location.
Every business must take the following precautions to ensure a safe evacuation in an emergency:
Every organization must have an evacuation policy
Organization must have a designated assembly point for emergencies.
A ‘buddy system’ for individuals with special needs or disabilities must be designated.
Floor plans with evacuation routes in work areas.
Assembly areas, where you are required to assemble after evacuation, must be properly taken care of.
Periodic evacuation drills should be conducted. Ensure that you pay attention during these drills
Healthy Living
A healthy lifestyle helps to keep and improve people’s health and well being.
Teachers and Examiners (CBSESkillEduction) collaborated to create the Database Management System Class 10 Notes. All the important Information are taken from the NCERT Textbook Information Technology (402).
Database Management System Class 10 Notes
What is Database?
An organised group of data that is kept and accessible electronically is referred to as a database. It is a digital repository that enables the effective management, storage, and retrieval of both organised and unorganised data. Information like client records, financial data, inventory listings, and much more can be stored in databases. Example of database are – Microsoft Access, OpenOffice Base, Oracle, MySQL and PostgreSQL etc.
What is a Database Management System?
Data is stored, retrieved, and analyzed using software called database management systems (DBMS). Users can create, read, update, and remove data in databases using a Database Management System, which acts as an interface between them and the databases. Example of database Management System are – Microsoft Access, OpenOffice Base, Oracle, MySQL and PostgreSQL etc.
Data can be organized into two types:
Flat File: Data is stored in a single table. Usually suitable for less amount of data. basically for small-scale organization where data does not need to be strucutred in a complex way. Example of database software are Microsoft Excel or Google Sheets.
Relational: Data is stored in multiple tables and the tables are linked using a common field. Relational is suitable for medium to large amount of data. Example of database software are MySQL, Microsoft SQL Server, and Oracle Database..
What is Database Server?
Database servers are dedicated computers that are designed to store data and provide database services to other computers. We use a database to store, organize, manage and retrieve data efficiently and effectively. The database servers run only database and database related software.
Advantages of Database
Reduces Data Redundancy
Data redundancy means when same data is stored more than one places, which increased complexity and wasted of storage space, so, database helps to reduce data redundacy.
Sharing of Data
A database allows its users to exchange data among themselves. The data can only be shared with users who have received the appropriate degrees of authorization because there are different levels of access to the data.
Data Integrity
Data integrity refers to the accuracy and consistency of data stored in a database management system (DBMS). Database ensures that the data is reliable and can be trusted for decision making and other critical business processes.
Data Security
A database’s concept of data security is important. The database should only be accessible to authorised users, whose identities must be verified using a username and password.
Privacy
The privacy rule in a database ensures that only authorized users can access the database and view data according to the specific privacy constraints. To maintain data security, access levels are set in the database so that a user can only view data that they are not allowed to modify if the permission is not given.
For example, in social networking sites, different accounts have different access constraints, and users are only allowed to view the other account data that is permitted for their specific account.
Backup and Recovery
Database Management System automaticlly take backup and recovery processes to ensure the protection and availability of data. This means that the DBMS automatically creates and manages backups of the database at regular intervals, and also provides tools to recover data in the event of a failure or data loss.
Data Consistency
Data consistency refers to the accuracy and reliability of data stored in a database or other data storage system. It means that the data is consistent and valid across all instances where it is stored or accessed.
For example, if a customer’s name and address are stored in multiple tables within a database, the data must be consistent across all table.
Database Management System Class 10 Notes
Features of Database
There are some key features of a database:
One or more tables can be added in the database.
Decreased storage costs and space requirements
Users can use query languages in a database.
Multiple users can access the data from the database .
Unique keys aid in preventing errors caused by human or technological mishaps.
Primary Key, Composite Primary Key and Foreign Key in a Database
In the RDBMS data can be integrated using keys. These are Primary Key, Composite Primary Key, and Foreign Key, Key are used to make the relationship between the tables.
Primary Key – This unique field is called the Primary Key (PK). primary key is a field or a set of fields that uniquely identify each record in a table. A primary key must be unique and cannot contain null values.
Composite Primary Key – A composite primary key is a primary key that consists of two or more fields that together uniquely identify each record in a table.
Foreign Key –A composite primary key is a primary key that consists of two or more fields that together uniquely identify each record in a table.
What is RDBMS?
A database management system that is based on the relational model is called an RDBMS (Relation Database Management System). Tables are used to organise data in relational databases. A relational database management system (RDBMS) is used to store, manage, query, and retrieve data.
Database Objects
a. Tables: Data is arranged into rows and columns in a table, which is a type of data structure. It can be applied to both the storage and presentation of structured data.
b. Columns or Fields or Attributes: Data is arranged vertically from top to bottom in columns. Each row of the table has one column, which is a collection of data values of a specific basic type. The structure by which the rows are put together is provided by the columns.
c. Rows or Records or Tuples: A row, also known as a Record or Tuple, in a table represents a single data item. A database table can be represented graphically as being made up of rows and columns, or fields. Every row in a table has the same structure and represents a group of connected data.
Difference between DBMS and RDBMS
Aspect
DBMS
RDBMS
Data structure
Data is stored in various formats such as flat files or hierarchical structures.
Data is stored in tables that are related to each other using a relational model.
Data integrity
DBMS systems may or may not enforce strict data integrity rules.
RDBMS systems enforce strict data integrity rules that ensure data consistency and accuracy.
Data normalization
DBMS systems may or may not follow normalization rules.
RDBMS systems follow normalization rules to minimize data redundancy and improve data integrity.
Query language
Typically, DBMS systems use proprietary query languages.
RDBMS systems use standard query language like SQL.
Scalability
DBMS systems may not be scalable to handle large amounts of data.
RDBMS systems are highly scalable to handle large amounts of data.
Cost
DBMS systems are generally less expensive than RDBMS systems.
RDBMS systems are generally more expensive than DBMS systems.
Database Management System Class 10 Notes
How to create a database using Open Office
Step 1 : Click on Start > Programs > OpenOffice > OpenOffice Base
Step 2 : Click on Create a new database
Step 3 : In the Database Wizard, Click on Finish
Step 4 : Specify a the Name of database and click on Save
How to create a table in Database
The database’s tables are used to store data. In the database, In OpenOffice Base the tables can be created in two different ways.
Create Table in Design View
Use Wizard to Create Table
Create Table in Design View
Step 1 : Click on Create Table in Design View
Step 2 : Select Field name and suitable datatype
Step 3 : Set the Primary Key
Step 4 : Change the table name
Step 5 : Save the table
Use Wizard to Create Table
Step 1 : Click on Table > Use Wizard to Create table
Step 2 : Click the Select Fields > Choose Category > Select the table > Click on Next Button
Step 3 : Select data types from the given field
Step 4 : Set the Primary Key
Step 5 : Rename the table and Click on Finish
Database Management System Class 10 Notes
Data Types
The type of data (value) that will be stored in the database is defined by its datatype. Important to know the different types of data helps to ensure that each property’s value is as expected and that data is collected in the correct format.
Data types in OpenOffice base are broadly classified into five categories listed below.
Numeric Types
Alphanumeric Types
Binary Types
Date time
Other Variable types
Numeric Types
Numerical data types are data types that store numeric values in a database. Numeric data types can be further divided into several subtypes, including:
Alphanumeric Types
Data that has both letters and numbers is referred to as alphanumeric type.
Binary Types
For storing data in binary formats, binary data types are utilised. In a database, binary data types can be used to store things like music and image files. The binary data type can generally be used to store files in any format.
Date Time
When specifying date and time values for a column used in a database table, date time data types are used. Information like dates of birth, admissions, product sales, and other dates can be stored in databases using date and time data types.
Other Data Types
Database Management System Class 10 Notes
Session 3 : Perform Operations on Table
In Base, data is kept in tables that may be added to, changed, or deleted by using the proper options.
Insert Data in the Table
Step 1 : Select the table > Double click on it
Step 2 : The table will open in Datasheet View
Step 3 : Now you can Insert Number of records in Datasheet View
Editing Records in the Table
Step 1 : Select the table > Double click on it.
Step 2 : The table will open in Datasheet View
Step 3 : Edit the record as per the requirement
Deleting Record From the Table
Step 1 : Select the table > Double click on it.
Step 2 : The table will open in Datasheet View
Step 3 : Right click on data and select delete option
Field Properties
To modify the field’s attributes It is necessary to modify the table structure in design view. The following actions will be taken to set the field’s properties:
Select the table > Right click > Select the option Edit > the table Design View window will open
Following are some properties of data of the numeric type:
AutoValue – if set to yes then field will get the auto numeric values.
Length – By default length of the field is 10 but the size of the field can be set to maximum length.
Default Value – A default value can be set for a field if user don’t provide any value while entering the values in the table.
Format example – This property helps to set the format of the data entered in the field such as 91-222-333.
Following are some properties of data of the character type:
Entry Required – if set to yes then it will be must to insert the value in the field which means that field cannot be left blank.
Length – By default length of the field is 10 but the size of the field can be set to maximum length.
Default Value – A default value can be set for a field if user don’t provide any value while entering the values in the table.
Format example – This property helps to set the format of the data entered in the field such as 91-222-333.
Sorting Data
Sorting means to arrange the data in either ascending order of descending order. Sorting is the process of putting data into a meaningful order so you can evaluate it more efficiently.
Referential Integrity
The relationship between tables is referred to as referential integrity. Referential integrity is used to maintain accuracy and consistency of data in a relationship. In Base, data can be linked between two or more tables with the help of primary key and foreign key constraints.
Referential integrity helps to avoid:
1. Adding records to a related table if there is no associated record available in the primary key table. 2. Changing values in a primary if any dependent records are present in associated table(s). 3. Deleting records from a primary key table if there are any matching related records available in associated table(s).
Creating and Editing Relationships between Tables
An association or link between two or more tables is referred to as a relationship. You don’t have to enter the same data again in different tables when you relate two tables.
Relationships between tables helps to
Save time as there is no need to enter the same data in separate tables.
Reduce data-entry errors.
Summarize data from related tables.
Type of Relationships in Database
There are three types of relationships which can be created in tables:
1. ONE to ONE 2. ONE to MANY OR MANY to ONE 3. MANY to MANY
ONE to ONE
In this relationship, both the tables must have primary key columns.
ONE to MANY OR MANY to ONE
In this relationship, one of the table must have primary key column. It signifies that one column of primary key table is associated with all the columns of associated table.
MANY to MANY
In this relationship, no table has the primary key column. It signifies that all the columns of primary key table are associated with all the columns of associated table.
Note Removing the Relationships – With the use of the Delete option, the relationships that have been applied to the tables can also be deleted. When you right-click a relationship thread, the Delete option will appear.
Session 4 : Retrieve Data using Query
In order to describe the data structure and to modify the data in the database, queries are used as instructions. A query enables the joining and filtering of data from various tables.
Database Languages having two type:
DDL (Data Definition Language)
DML (Data Manipulation Language)
DDL Statements:
Create: Using this statement, a database or set of tables can be created.
Alternate: This statement is used to change the table’s structure.
Drop: This statement is used to remove database objects from the system.
DML statements:
SELECT: The statement “SELECT” is used to get data from the database.
INSERT: The statement “INSERT” is used to add a new record to the database.
DELETE: The database can be cleaned out by using the statement DELETE.
UPDATE: This statement is used to modify the database’s information.
Database Query
Query is a computer languages. In order to describe the data structure and to modify the data in the database, queries are used as instructions. Query can extract particular data from a database. We can filter and join data from various tables with the help of a query. By using the criteria you supply query will filter the data.
Select Statement
A select query is a language in a database that displays data in Datasheet view. Data from tables is displayed by a query rather than being stored by it. A query may display data from one or more tables, from other queries, or from both of these sources simultaneously.
The SELECT statement has many optional clauses:
WHERE specifies which rows to retrieve.
ORDER BY specifies an order in which to return the rows.
Syntax of Select Statement is –
SELECT * FROM <TABLENAME>;
Query related to Simple Select Statement –
Table Name – product
Product_No
Product_Name
Price
Quantity
25
Soap
40
80
31
Powder
80
30
45
Shampoo
250
25
52
Soap Box
120
100
Database Management System Class 10 Notes
Question – Write a Query to display all record from the table;
Select * from product;
Output –
Product_No
Product_Name
Price
Quantity
25
Soap
40
80
31
Powder
80
30
45
Shampoo
250
25
52
Soap Box
120
100
Database Management System Class 10 Notes
Question – Write a Query to display product name from the table;
Select Product_Name from product;
Output –
Product_Name
Soap
Powder
Shampoo
Soap Box
Database Management System Class 10 Notes
Question – Write a Query to display Product_Name and Price from the table;
Select Product_Name, Price from product;
Output –
Product_Name
Price
Soap
40
Powder
80
Shampoo
300
Soap Box
120
Database Management System Class 10 Notes
Query related to Select Statement with Mathematical function –
Table Name – product
Product_No
Product_Name
Price
Quantity
25
Soap
40
80
31
Powder
80
30
45
Shampoo
250
25
52
Soap Box
120
100
Database Management System Class 10 Notes
Question – Write a Query to find the total no of quantity available in table;
Select sum(quantity) from product;
Output – 235
Question – Display the total amount of each item. The amount must be calculated as the price multiplied by quantity for each item.
Select Product_No, Product_Name, Price * Quantity from product;
Output –
Product_No
Product_Name
Price*Quantity
25
Soap
3200
31
Powder
2400
45
Shampoo
6250
52
Soap Box
12000
Database Management System Class 10 Notes
Question – Write a query to find the average price of the total product;
Select avg(Quantity) from product;
Output – 58.75
Query related to Select Statement with Where clause
Table Name – product
Product_No
Product_Name
Price
Quantity
25
Soap
40
80
31
Powder
80
30
45
Shampoo
250
25
52
Soap Box
120
100
Question – Write a Query to display the product whose price is less than 90
Select * from product where price < 90;
Output –
Product_No
Product_Nam
Price
Quantity
25
Soap
40
80
31
Powder
80
30
Database Management System Class 10 Notes
Question – Write a Query to find the total amount of the Shampoo product;
Select Price*Quantity from product where Product_Name = ‘Shampoo’;
Output – 6250
Or
Select Product_No, Product_Name, Price*Quantity from product where Product_Name = 'Shampoo';
Output –
Product_No
Product_Nam
Price*Quantity
45
Shampoo
6250
Question – Write a Query to display the data whose quantity is equal to 80.
Select * from product where quantity = 80;
Output –
Product_No
Product_Nam
Price
Quantity
25
Soap
40
80
Database Management System Class 10 Notes
Question – Write a Query to display a list of Products whose Price between 40 to 120.
Select * from product where Price >= 40 and Price <= 120;
Output –
Product_No
Product_Nam
Price
Quantity
25
Soap
40
80
31
Powder
80
30
52
Soap Box
120
100
Query related to Select Statement with Order by
Table Name – product
Product_No
Product_Name
Price
Quantity
25
Soap
40
80
31
Powder
80
30
45
Shampoo
250
25
52
Soap Box
120
100
Question – Write a Query to display the list of Product_Name in alphabetical order.
Select * from product order by Product_Name ASC;
Or
Select * from product order by Product_Name;
Output –
Product_No
Product_Nam
Price
Quantity
31
Powder
80
30
45
Shampoo
250
25
25
Soap
40
80
52
Soap Box
120
100
Database Management System Class 10 Notes
Question – Write a Query to display the list of Price in ascending order.
Select * from product order by Price ASC;
Or
Select * from product order by Price;
Output –
Product_No
Product_Nam
Price
Quantity
25
Soap
40
80
31
Powder
80
30
52
Soap Box
120
100
45
Shampoo
250
25
Question – Write a Query to display the list of Price in descending order.
Select * from product order by Price DESC;
Output –
Product_No
Product_Nam
Price
Quantity
45
Shampoo
250
25
52
Soap Box
120
100
31
Powder
80
30
25
Soap
40
80
UPDATE statement
To edit or update already-existing records in a table, use the UPDATE statement. Using the WHERE clause, you can either define a specific subset of entries to edit or use it to update everything at once.
Syntax of Update Statement –
UPDATE <table name> SET = value [, column_name = value ...] [WHERE ];
Table Name – product
Product_No
Product_Name
Price
Quantity
25
Soap
40
80
31
Powder
80
30
45
Shampoo
250
25
52
Soap Box
120
100
Database Management System Class 10 Notes
Question – Write a Query to update the price of Shampoo in the product table.
Update product Set Price = 300 where Price = 250;
Output –
Product_No
Product_Name
Price
Quantity
25
Soap
40
80
31
Powder
80
30
45
Shampoo
300
25
52
Soap Box
120
100
Question – Write a Query to update the Quantity of Powder in the product table.
Update product Set Quantity = 50 where Product_Name = ‘Powder’;
Output –
Product_No
Product_Name
Price
Quantity
25
Soap
40
80
31
Powder
80
50
45
Shampoo
250
25
52
Soap Box
120
100
Database Management System Class 10 Notes
Create Table
To create a new table in the database you can use Create Table Command.
Insert into product values(72, “Hair Conditioner‟, 350, 60);
Output –
Product_No
Product_Name
Price
Quantity
25
Soap
40
80
31
Powder
80
30
45
Shampoo
300
25
52
Soap Box
120
100
72
Hair Conditioner
350
60
Database Management System Class 10 Notes
Session 5 : Create Forms and Reports using Wizard
Forms
The Form allows you greater control over your outcomes. The form allows you to customize various parts of the form’s design and then generates a form based on your instructions.
Steps To Create Form Using Wizard
Step 1 : Click Use Wizard to Create Form
Step 2 : Select the selective Fields using Arrow button
Step 3 : Click Next
Step 4 : Add Subform if you need to insert
Step 5 : Click Next
Step 6 : Arrange selected field in a form
Step 7 : Click Next
Step 8 : Click Finish
Reports
A report helps in the presentation of data in a summarized format. It is utilized to create a clear format for the entire work product. In the database, you can build reports.
Steps To Create Report Using Wizard
Step 1 : Click on Use Wizard to Create Report
Step 2 : Select the selective Fields using Arrow button
Step 3 : Click Next
Step 4 : Redefine the label of the fields in the reports or else you can set the default name
Step 5 : You can define grouping for the fields of the table
Teachers and Examiners (CBSESkillEduction) collaborated to create the Electronic Spreadsheet Class 10 Notes. All the important Information are taken from the NCERT Textbook Information Technology (402).
Electronic Spreadsheet Class 10 Notes
Session 1 : Analyze data using Scenarios and Goal Seek
Data Consolidation
In OpenOffice, data consolidation refers to the combining of data from various sources or sheets into a single area for easy analysis and manipulation. It helps when working with data that is spread across multiple files or sheets and enhances productivity, accuracy, and decision-making abilities.
Advantages of using Consolidation Data –
Saves time by combining information from various sources into one document.
reduces the possibility of errors that could happen when manually copying data, which increases accuracy.
allows you to examine and interact with the combined data in one place, which improves efficiency.
improves decision-making by giving a thorough perspective of the data.
Having all the data in one location makes it simpler to share it with other people.
Consolidation Data Window
To use the Consolidate tool in OpenOffice, follow these steps:
Open a new or existing spreadsheet in OpenOffice.
Select the cell where you want the consolidated data to appear.
Click on Data > Consolidate from the menu bar.
In the Consolidate dialog box, select the range of cells or sheets you want to consolidate.
Choose the function you want to use to consolidate the data (such as sum or average).
Specify any additional settings, such as whether to include labels or empty cells.
Click OK to consolidate the data.
Creating Subtotal in Electronic Spreadsheet
Subtotal in OpenOffice electronic spreadsheet refers to a function that calculates the subtotal of a range of values within a list or table. This function can be used to summarize data by category or group, allowing you to quickly see the total for each group.
Advantages of using Subtotal in OpenOffice electronic spreadsheet:
Easy data analysis by grouping and summarizing data based on criteria.
Improved accuracy by automating subtotal calculations and reducing errors.
Increased efficiency by saving time and effort.
Enhanced organization by grouping data into categories and subcategories.
Customizable grouping and calculation criteria for flexibility in data analysis.
SubTotal Window
To use the Subtotal function in OpenOffice, follow these steps:
Open a new or existing spreadsheet in OpenOffice.
Select the range of data you want to subtotal.
Click on Data > Subtotals from the menu bar.
In the Subtotals dialog box, select the column you want to group by and the function you want to use (such as sum or count).
Click OK to apply the subtotals.
Using “What-if” Scenarios in Electronic Spreadsheet
Scenarios in OpenOffice electronic spreadsheet refer to a feature that allows you to create and compare different sets of data to explore different outcomes or possibilities. Scenarios are useful when you want to explore how changes in data will affect your calculations, such as in financial modeling or forecasting.
What is use of What-if in scenario
“what-if” analysis in scenarios, you can test different possibilities and explore the potential impact of changes to your data, helping you make more informed decisions.
Advantages of using Scenarios in OpenOffice electronic spreadsheet:
Allows you to explore different outcomes or possibilities based on changes to your data.
Helps you to better understand your data and make more informed decisions.
Particularly useful in financial modeling, forecasting, and other areas where you need to explore the impact of different variables on your data.
Provides a way to compare and contrast different sets of data and their potential impact.
Can save time by allowing you to easily create and test different scenarios.
To use Scenarios in OpenOffice, follow these steps:
Open a new or existing spreadsheet in OpenOffice.
Enter the original data that you want to use as the basis for your scenarios.
Click on Tools > Scenarios from the menu bar.
In the Scenarios dialog box, click on Add to create a new scenario.
Give your scenario a name and select the cells you want to vary in your scenario.
Enter the new values for each cell in your scenario.
Click OK to save your scenario.
Repeat steps 4-7 to create additional scenarios.
To compare scenarios, click on Tools > Scenarios and select the scenarios you want to compare.
Goal Seek in Electronic Spreadsheet
Goal Seek in electronic spreadsheet refers to a feature that allows you to find the input value needed to achieve a specific output value. This can be useful when you know the desired result of a calculation, but you are not sure what input value is needed to achieve that result.
For example, you might use Goal Seek to determine what interest rate is needed to pay off a loan in a specific amount of time, or what sales volume is needed to achieve a certain profit margin.
To use Goal Seek in an electronic spreadsheet, follow these steps:
Enter the formula that you want to use in the cell where you want the output value to appear.
Enter an initial value for the input cell that you want to change.
Click on Tools > Goal Seek from the menu bar.
In the Goal Seek dialog box, enter the output value you want to achieve and select the cell containing the input value you want to change.
Click OK to run the Goal Seek analysis.
The Goal Seek feature will calculate the value needed to achieve the desired output and update the input cell with the new value.
Solver in Electronic Spreadsheet
The Solver is a more advanced version of Goal Seek. While Goal Seek is designed to find a single variable solution, Solver can handle equations with multiple unknown variables. It is used to find the best possible outcome that meets a set of defined conditions, such as minimizing or maximizing a particular result based on a set of rules or constraints that you define.
Note : if you have a set of data with multiple variables, you can use Solver to find the combination of values that will produce the desired outcome.
Solver example
Consider investing $10,000 over the course of a year in two mutual funds. Fund X is a lower risk fund with an interest rate of 8%, whereas Fund Y has a greater risk interest rate of 12%. How much should be put into each fund in order to generate a total interest of $1,000?
Difference between goal seek and solver
Goal Seek
Solver
Purpose
Find a single variable solution to a problem
Find an optimal solution to a problem with multiple variables
Input variables
One input variable
Multiple input variables
Output
Finds the value of the input variable that produces a specific output
Finds the best combination of input variable values that meet a set of conditions or constraints
Problem complexity
Simple problems with one unknown variable
Complex problems with multiple unknown variables and constraints
Algorithm
Iterative method
Optimization algorithm
Optimization
None
Minimize, maximize, or target a specific value
Constraints
None
Multiple constraints can be added
Session 2 : Link Data and Spreadsheets
You may also link cells from several worksheets and spreadsheets to summarise data from numerous sources using spreadsheets. This allows you to build formulas that combine data from several sources and perform computations using both linked and local data.
Inserting New Sheet
When you open a new spreadsheet, it usually contains three sheet named Sheet1, Sheet2 and Sheet3. If you want to insert a new sheet into the spreadsheet, there are different methods you can use.
Steps for Creating New Sheet –
Choose Insert > Sheet from the menu bar,
Insert the sheet by right-clicking on the tab,
Click in the empty area at the end of the sheet tabs.
Renaming Sheets
Step 1 : Double-click on the name of a current worksheet.
Step 2 : Use the context menu that appears when you right-click on the name of an existing worksheet to select Rename.
Step 3 : Click on the worksheet tab to choose the worksheet you want to rename, and then choose the Sheet option from the Format menu. The Rename option should be chosen from the submenu that is displayed when you do this.
Cell Reference
Cell referencing in a spreadsheet is the process of referring to a specific cell or range of cells within a worksheet by using a unique identifier. This unique identifier is called a cell reference and it is made up of a combination of a column letter and a row number that identifies the location of a particular cell.
There are two ways to reference cells in other sheets –
Creating The Reference With The Mouse
Creating The Reference With The Keyboard.
Creating The Reference With The Mouse
Both spreadsheets must be open in order to construct the reference with the mouse. Choose the cell where the formula will be entered.
Creating The Reference With The Keyboard
Referencing It’s easy to enter a cell reference using the keyboard in a formula. The reference consists of three parts:
Path and file name
Sheet name
Cell
Example – =’file:///Path &File Name’#$SheetName.CellName.
Working with Hyperlinks
In Calc, you can utilise hyperlinks to navigate between spreadsheet cells and to other areas of the same or different files, websites, or even other spreadsheets.
Hyperlinks can be stored within your file as either relative or absolute.
Relative And Absolute Hyperlinks
Relative and absolute hyperlinks are used in spreadsheet applications, such as OpenOffice Calc, to create links between cells or other resources within the same spreadsheet or to external files and web pages.
a. Relative Hyperlinks – Relative hyperlinks are links that are specified in relation to the current cell’s location. They typically use a path that is relative to the current file’s location. For example, if you are currently on cell A1 and you want to link to cell B1 in the same sheet, you can use the relative hyperlink “B1”.
b. Absolute Hyperlinks – Absolute hyperlinks, on the other hand, specify the full path or URL of the resource being linked to. For example, to link to a web page located at “http://cbseskilleducation.com/information-technology-class-10-notes/”, you can use the absolute hyperlink “http://cbseskilleducation.com/information-technology-class-10-notes/”.
Linking to External Data
To insert external data, such as tables from HTML documents or named ranges from other spreadsheets, into OpenOffice Calc, you can use the External Data dialog or the Navigator.
Using the External Data dialog: Go to “Data” > “External Data”, select the source of the data, and choose the specific data to insert. You can link to the external data or copy it into your spreadsheet.
Using the Navigator: Click on the “Navigator” icon or press F5, expand the “Data Sources” section, select the source of the data, and drag and drop the table or named range into your spreadsheet.
Session 3 : Sharing Worksheet Data
Spreadsheet software gives users the option to share and store workbooks in a network location so that numerous users can view the same workbook at once. This function helps users collaborate more effectively by increasing the efficiency of data entering.
Setting up a Spreadsheet for Sharing
You can create a spreadsheet at any moment and share it with others. Open the spreadsheet document and select Tools > Share Document to enable the document’s collaborative features. You can choose whether to activate or disable sharing from a dialogue that appears.
Record Changes
You may track changes made to a spreadsheet by yourself or other users using the “Record Changes” option in OpenOffice Calc. When working on a spreadsheet with others, reviewing and editing data, and keeping track of multiple people’s edits, this capability comes in handy.
Any changes you make to the spreadsheet are noted in the document and recorded when the “Record Changes” option is turned on in OpenOffice Calc.
Turned on Record Changes featue ON
Open the Spreadsheet
Click on Edit > Changes > Record
Now, You can start Editing the worksheet
Viewing Changes
Calc gives the control over the spread sheet to view the changes you or other have done in Worksheet. To change the available filters, select Edit > Changes > Show. The following dialog opens.
In OpenOffice Calc, you can view changes made to a spreadsheet using the “Record Changes” feature.
Date filter: Shows only the changes made within a specified time range.
Author filter: Displays changes made by a specific person, which is useful when multiple reviewers are working on the worksheet.
Range filter: Shows only changes made within a specific range of cells, helpful for large spreadsheets.
Comment filter: Displays changes that have comments matching the search criteria.
Show accepted changes: Displays only the changes that you have accepted.
Show rejected changes: Displays only the changes that you have rejected.
Accepting or Rejecting Changes
You have the choice to accept or reject the changes once you’ve done editing the document. When changes are accepted, they are made permanent parts of the document; when changes are rejected, the document returns to the way it was before the changes were made.
Go to the “Edit” menu and select “Changes” followed by “Accept or Reject.”
In the Accept or Reject Changes dialog box, you can either accept or reject changes one-by-one or all at once.
Merging Worksheets
Merging worksheets in OpenOffice Calc is a feature that allows you to combine two or more worksheets into a single worksheet. This is useful when you have data spread across multiple worksheets that you want to consolidate into a single worksheet for analysis or reporting purposes.
Open the Worksheet
Select Edit > Changes > Merge Document
Select the file from selection dialog box
Use Accept or Reject changes
Comparing Document
You can compare two or more spreadsheets in OpenOffice Calc using a feature called “Document Comparison” to find discrepancies between them. This can be helpful when you want to evaluate edits made to a spreadsheet by another person or when you want to compare two spreadsheet versions for inconsistencies or errors.
Open worksheet
Select Edit > Compare Document
Select the original worksheet
Now, You can find the changes
Create and use Micros in Spreadsheet
Using Micors
A macro in OpenOffice is a set of commands or keystrokes that are stored for later usage. Macro might be simple, like inputting an address automatically, or sophisticated, like automating a sequence of calculations. Because the OpenOffice macro language is so flexible, users can automate a variety of processes. When repetitive actions need to be carried out repeatedly in the same manner, macros are especially helpful.
Advantages of Micro
The repetitive and routine processes are automated by macros.
As digital documentation becomes more prevalent in both academic and professional settings, it is crucial that Class 10 students develop this competence. Students can boost their effectiveness, productivity, and teamwork abilities by learning the fundamentals of digital documentation.
Teachers and Examiners (CBSESkillEduction) collaborated to create the Digital Documentation Class 10 Notes. All the important Information are taken from the NCERT Textbook Information Technology (402).
Digital Documentation Class 10 Notes
Session 1 : Create and apply Style in the Document
Style refers to a pre-defined set of formatting attributes that can be applied to text, paragraphs, pages, and other elements of a document. Styles help to ensure consistency in formatting throughout the document and make it easier to manage and modify the document’s formatting.
Style and Formatting Window
Advantages of Style
Provides consistency throughout the document
Saves time and increases efficiency
Allows for easy updates and modifications
Makes document management simpler and more organized
Enhances accessibility for readers who use assistive technologies.
There are several types of styles in OpenOffice, including:
Character styles: These are used to apply formatting to specific characters or words within a paragraph. For example, you might use a character style to make a particular word bold or italicized.
Paragraph styles: These are used to apply formatting to entire paragraphs, including text alignment, spacing, and indentation.
Page styles: These are used to define the layout and formatting of individual pages, including margins, headers, and footers.
List styles: These are used to define the formatting of bulleted or numbered lists.
Frame styles: These are used to define the formatting of frames, which are used to hold graphics or other elements within a document.
Table styles: These are used to define the formatting of tables, including cell borders, backgrounds, and text alignment.
Graphics styles: These are used to define the formatting of graphics or images within a document, including borders, backgrounds, and text wrapping.
How to Apply Style in OpenOffice.org
Step 1 : Select the text, paragraph, or other element where you want to apply the style. Step 2 : Click Format > Style and Formatting or press F11 Step 3 : Select any one of the style (e.g., Paragraph, Character, etc.)
Note : Style and Formating Windows is given above.
What is Fill Format Mode and How to apply
Fill Format Mode is a feature in OpenOffice that allows you to copy the formatting from one element of a document and apply it to another element. This can be useful when you want to quickly apply consistent formatting to multiple elements within a document.
How to Apply Fill Format Mode
Step 1 : Select the element that contains the formatting you want to copy. Step 2 : Click on the “Fill Format mode” icon in the Style and Formatting window. Step 3 : Select the element or elements that you want to apply the formatting to. Step 4 : Click on the element that you want to apply the formatting.
Creating New Custom Style in OpenOffice.org
There are two diffierent ways to create a Style
1) Creating a new Style from a selection 2) Dragging and Dropping to Create A Style
Create New Style from Selection
By replicating an existing manual format, you can make a new style. This new style will only be applied to this document and will not be saved in the template.
Step 1 : Select the formatted text or paragraph. Step 2 : From the top menu, select “Styles” > “New Style” (or press F11). Step 3 : In the New Style window, enter a name for the new style and select the type of style you want to create. Step 4 : Make any additional changes to the style options. Step 5 : Click “OK” to save the new style.
Drag and Drop to create New Style
You can drag and drop a text selection into the Styles and Formatting window to create a new style.
Step 1 : Open the Styles and Formatting window. Step 2 : Select text and drag it to the Styles and Formatting window. Step 3 : In the Create Style dialog box, type a name for the new style. The list shows the names of existing custom styles of the selected type, if any. Click OK to save the new style. Step 4 : If the Paragraph Styles list is showing in the Styles and Formatting window, a new paragraph style will be added to the list. If Character Styles are active, the character style will be added to the list.
Digital Documentation Class 10 Notes
Modifying Custom or Pre defined Styles
There are two different ways to modify Style in OpenOffice –
Updating a style from a selection •
Load or copy styles from another document or template
Updating a Style from a selection
To update a style from a selection:
Step 1 : Open the Styles and Formatting window. Step 2 : In the document, select an item that has the format. Step 3 : In the Styles and Formatting window, select the style you want to update (singleclick, not double-click), then long-click on the arrow next to the New Style from Selection icon and click on Update Style.
Load or copy styles from another document or template
You can copy styles by loading them from a template or another document:
Step 1 : Open the document into which you wish to paste styles. Step 2 : Long-click on the arrow next to the New Style from Selection symbol in the Styles and Formatting window, and then select Load Styles. Step 3 : Locate and choose the template you wish to copy styles from on the Load Styles box. Step 4 : Decide which style categories should be duplicated. Step 5 : Click OK to copy the styles.
Digital Documentation Class 10 Notes
How to Insert and use Image in Digital Document
There are various ways to insert images into a document, including via the Drag and Drop, Insert Image from File, Insert Image from Clipboard, Open Office Gallery, and a scanner.
Drag and Drop
Insert Image from Dialog Box
Insert Image from Clipboard
Insert Image from Gallery
Insert Image from Scanner
Drag and Drop
To drag an image file into a digital document, follow these steps: –
Step 1 : Open a File browser window and locate the image you want to insert. Step 2 : Drag the image into the Writer document and drop it where you want.
Insert Image from Dialog Box
To insert an image file into a digital document, follow these steps –
Step 1: Click in the Open Office document in the first step to place the image there. Step 2: From the menu bar, select Insert > Picture > From File. Step 3: Navigate to the file that needs to be inserted on the Insert Picture dialogue, select it, and click Open.
Insert Image from Clipboard
Step 1 : Open the document in which you want to insert the image. Step 2 : Place the cursor where you want the image to be inserted. Step 3 : Press “Ctrl+V” or right-click and select “Paste” to insert the image from the clipboard. Step 4 : Resize or move the image as necessary.
Digital Documentation Class 10 Notes
Insert Image from Gallery
Step 1 : Open the document in which you want to insert the image. Step 2 : From the top menu, select “View” > “Gallery” (or press F6). Step 3 : In the Gallery window that appears, browse through the categories to find the image you want to insert. Step 4 : Click on the image to select it. Step 5 : Click and drag the selected image into the document where you want it to appear.
Insert Image from Scanner
If your computer has a scanner attached, Open Office may access the scanning software and enter the scanned item as an image into the Open Office document. To insert image
Click the area where the image to be placed, then choose Insert > Picture > Scan > Select Source to begin the process.
Modifying Image in OpenOffice.org
You might need to edit a new image you include so that it matches the document. Here, we’ll go through how to use the Picture toolbar, as well as how to resize, crop, and rotate a photo using a workaround.
Picture Toolbar
The Picture toolbar displays when you insert a picture or choose one that is already in the page. View > Toolbars > Picture allows you to set it to always be visible.
Graphics mode
You can change color images to grayscale by selecting the image and then selecting Grayscale from the Graphics mode list.
Flip vertically or horizontally
Select the image, then click the corresponding icon to turn it vertically or horizontally.
Filters
The filters are briefly described in the following table, but the best way to comprehend them is to use them. Try around with the various filters and their settings.
Digital Documentation Class 10 Notes
Transparency
To make a picture more transparent, change the percentage value in the Transparency box on the Picture toolbar. When making a watermark or enclosing the image in the background.
Using The Formatting Toolbar And Picture Dialog
a. Cropping Images
You could want to crop (cut off) a portion of the image if you’re only interested in it for your document. Right-click the image and choose Picture from the pop-up menu to begin cropping it.
b. Keep scale / Keep image size
When the Keep scale option is used (the default), cropping an image does not alter its scale.
When the option to Keep Picture Size is used, cropping results in either an increase in image size (for positive cropping values), a decrease in image size (for negative cropping values), or an image distortion.
c. Width and Height
As you input values in the Left, Right, Top, and Bottom fields under Scale or Image size, the Width and Height fields change. To find the precise amount to crop by, use the thumbnail next to these fields.
Digital Documentation Class 10 Notes
d. Resizing an Image
If the inserted image is too big or too small, it might not fit into the paper completely. You can resize the image in Writer.
e. Rotating a Picture
With the aid of the rotation option in digital documentation, you can rotate the image.
f. Creating Drawing Objects
Display the Drawing toolbar by selecting View > Toolbars > Drawing to start utilising the drawing tools.
Session 3 : Create and use Template
A template is a sample that you can follow while writing new documents. Documents that have previously been designed are called templates. Simply substitute your own text for the sample text.
Creating a Template
You can create your own templates in two ways:
from a document,
and using a wizard.
Creating A Template From A Document
Step 1 : Open a new or existing document of the type you want to make into a template (text document, spreadsheet, drawing, presentation). Step 2 : Add the content and styles that you want. Step 3 : From the main menu, choose File > Templates > Save.
Digital Documentation Class 10 Notes
Creating A Template Using A Wizard
Step 1 : Choose File > Wizards >[type of template required] Step 2 : Follow the instructions on the pages of the wizard like the date, subject line , salutation, and complimentary close Step 3 : In the last section of the wizard, you can specify the name and location for saving the template. Step 4 : Finally, you have the option of creating a new document from your template immediately, or manually changing the template.
Session 4 : Create and customize Table of Contents
A table of contents (TOC) is a list of the main sections or chapters in a document, a table of contents gives readers a quick summary of the document’s content and a mechanism to quickly search for a specific piece of information within it. The table of contents typically includes section or chapter titles and the corresponding page numbers.
Advantages of Table of Content
Provides quick navigation
Efficient organization
Improved comprehension
Professional appearance
Accessibility for readers with disabilities
What is the purpose of Table of Content
It provides users with a summary of the contents and structure of the document.
It enables users to jump right to a certain area of a document.
How to Insert Table of Content in Digital Documentation
To insert table of Content in Digital Document follow the following link – Insert > Indexes and Tables > Indexes and Tables.
Basic Setting in Table of Content
Adding A Title
Put a title in the Title area if you want one for the table of contents. (If Writer automatically entered a title in this field, you may edit it by typing over the value.) Clear the Title field to remove the title.
Digital Documentation Class 10 Notes
Protecting Against Manual Changes
Select the Protected against manual changes checkbox to prevent accidental changes to the table of contents.
If this box is checked, the context menu or the Insert Table/Index window are the only ways to modify the table of contents.
If this box is unchecked, The table of contents can be modified immediately on the document page, just like regular text..
Changing The Number Of Levels
When creating the table of contents, Writer by default considers 10 levels of headings.Enter the required number in the “Evaluate up to level” spin box to adjust the number of levels examined.
Assigning Custom Styles
All paragraphs created using the default heading styles are automatically assigned to the table of contents by Writer (Heading 1, Heading 2, and so on).
Using The Entries Tab
Entries table help to customize the formatting of the TOC entries. This tab allows you to specify how the headings and subheadings in the document should appear in the TOC, including the font, style, indentation, and page number formatting.
E# – The chapter number is indicated by the E# button.
E – The entered text is represented by the E button.
T – A tab stop is represented by the T button.
# – The page number is indicated by the # button.
LS – The beginning of a hyperlink is indicated by the LS button. (This button is absent from the Structure line by default.)
LE – A hyperlink’s conclusion is indicated by the LE button. (This button is absent from the Structure line by default.)
Deleting Elements
Click the button next to the element you want to remove from the Structure line, and then press the Delete key on your computer. For instance, click the T button and then press the Delete key to remove a tab stop.
Using The Background Tab
To add colour or a graphic to the table backdrop, use the Background tab.
Saving The Table Of Contents
Click OK to save the table of contents and have it display in your document. The table of contents is displayed in your document once the Insert Index/Table window closes.
Session 5 : Implement Mail Merge
Using a mail merge, you can personalise a letter you’ve already written and send it to a large group of recipients, giving the impression that you wrote it specifically for them. A mail merge can also be a rapid technique to create labels or envelopes with the addresses for various persons on each label or envelope using a list of people’s mailing addresses.
Anyone or any business that interacts frequently with customers, partners, parents, or other individuals must use the mail merge.
How to create Mail Merge in Digital Documentation
Step 1: Select starting document Step 2: Select document type Step 3: Insert address block or Selecting the data source Step 4: Create salutation Step 5: Adjust layout Step 6: Edit document and insert extra fields Step 7: Personalize documents Step 8: Save, print or send
What is Data Source
During the mail merge process, data from another document referred to as the data source, Data Source connects to the main document and retrieves the information like names, addresses, and phone numbers can be found in a document, spreadsheet, or database that serves as the data source.
What are the different type of Data Source available in Mail Merge
OpenOffice.org allows data sources to be accessed and then linked into OOo documents. For example, a mail merge links an external document containing a list of names and addresses into a letter, with one copy of the letter being generated for each entry.
Different type of File which support to insert data in Mail merge are –
Spreadsheet
Text File
Access or Base Database
Address Book
Revision QA based on Digital Documentation
Q. What are styles in OpenOffice?
Answer – OpenOffice styles are pre-defined formatting templates that make it simple and quick to apply unified styling to various elements of a document, such as headings, paragraphs, and tables.
Q. What are the advantages of using styles in OpenOffice?
Answer – Using styles in OpenOffice has certain benefits, such as simpler formatting and reformatting, more accuracy and consistency, quicker document production, and simpler updating of formatting across many documents.
Q. How do you create and apply styles in OpenOffice?
Answer – In OpenOffice, utilise the “Styles and Formatting” box and select “New Style” from the drop-down menu to create a style. You can use the “Styles and Formatting” pane and click on the appropriate style name to apply a style to a document.
Q. What are some best practices for using styles in OpenOffice?
Answer – Creating and adopting a consistent naming convention for styles, modifying styles as required, updating styles as required, and using the “Update Style” tool to make changes to all instances of a style in a document are some of the best practises for using styles in OpenOffice.
Q. How can you modify or delete styles in OpenOffice?
Answer – In the “Styles and Formatting” window, you may right-click on the style name and select “Modify” to change the style. You can choose “Delete” by performing a right-click on a style’s name. It’s crucial to remember that removing a style could also remove all occurrences of that style from the document.
Q. What is mail merge?
Answer – With the mail merge tool in Digital Document, users can combine a main document with a data source to produce a huge number of customised documents, such as letters, emails, or labels.
Q. What are the benefits of using mail merge?
Answer – The benefits of using mail merge include saving time, reducing errors, increasing productivity, and personalizing communications to recipients.
Q. What are the basic requirements for creating a mail merge in Microsoft Word?
Answer – A main document, a data source containing recipient details, and the capability to add fields to the document to personalise it are the prerequisites for constructing a mail merge in Digital Document.
Q. How do you insert fields into a mail merge document?
Answer – Place the cursor where you want the field to appear in the mail merge document and choose “Insert Merge Field” from the “Insert Merge Field” dropdown menu on the “Mailings” tab.
Q. What is the difference between the main document and the data source in mail merge?
Answer – The data source is the file that holds the information that is specific to each recipient, whereas the main document is the template or master document that provides the overall layout and content of the final message.
Q. What are the different types of data sources that can be used for a mail merge?
Answer – The different types of data sources that can be used for a mail merge include Excel spreadsheets, Access databases, Outlook contact lists, and text files.
Q. What is a table of contents in OpenOffice?
Answer – A table of contents in OpenOffice is a list of a document’s headers and subheadings together with the pages on which they appear. It enables readers to easily search the document for the information they require.
Q. How can you insert a table of contents in OpenOffice?
Answer – First, make sure your document has the proper headings and subheadings before attempting to incorporate a table of contents in OpenOffice. Then, choose “Indexes and Tables” from the “Insert” menu and then “Indexes and Tables” once more. Choose “Table of Contents” from the “Type” drop-down menu on the “Indexes and Tables” dialogue box’s “Type” tab. After making the necessary adjustments, click “OK” to enter the table of contents.
Q. Can you manually edit a table of contents in OpenOffice?
Answer – A table of contents can be manually edited in OpenOffice, but this is generally not advised. A table of contents that has been manually edited may have mistakes or inconsistencies, and it may be more challenging to update the table of contents if the document changes. Instead, it is advised to make advantage of OpenOffice’s automated table of contents capability, which may be rapidly and easily updated whenever the document changes.
Q. How do you update a table of contents in OpenOffice?
Answer – A table of contents in OpenOffice can be updated by right-clicking it and choosing “Update Index/Table.” Choose “Update complete table” from the “Update Index/Table” dialogue box, then click to update the table of contents.
Q. Can you customize the appearance of a table of contents in OpenOffice?
Answer – A table of contents’ appearance can be changed in OpenOffice, yes. A variety of pre-defined styles are available, or you can design your own. Go to the “Indexes and Tables” dialogue box and select the “Styles” option to change how a table of contents looks. From there, you can choose a pre-defined style or develop a new one by altering the ones that are already there.
Q. How do you remove a table of contents in OpenOffice?
Answer – A table of contents in OpenOffice can be eliminated by selecting it and pressing the “Delete” key on your keyboard. As an alternative, you can pick “Indexes and Tables” from the “Insert” menu and then select it once again. Remove the table of contents by clicking the “Type” tab and selecting “None” in the “Indexes and Tables” dialogue box.
IT 402 Class 10 Sample Paper 2021-22: Students may learn the CBSE Exam pattern by downloading all CBSE Board Sample Papers of Class 10 Information Technology 402 with Solutions (Answer Key). Students can get an overview of the CBSE exam structure and practice the questions to improve their scores.
Hi Students, Thank you for taking the time to reading IT 402 Class 10 Sample Paper. Please take a few moments and leave your thoughts in the comment box below.
Disclaimer – 100% of the Sample papers are taken from the CBSE Official Website. If you found any error please contact us anuraganand2017@gmail.com.
Teachers and Examiners collaborated to create the Digital Documentation Class 10 Questions and Answers. All the important Questions and Answers and taken from the NCERT Textbook Information Technology ( 402 ).
Very Important Subjective Questions from Textbook
Session 1: Create and Apply styles in the document
1. What are Styles ?. What are the advantages of using styles.
Answer – Styles are pre-defined formatting attributes in digital document processing that can be used to apply consistent formatting to text and other elements. The advantages of using styles include –
Consistency throughout the document
Efficiency in formatting the document
Flexibility in making changes to the document
Improved accessibility for users with assistive technologies.
Digital Documentation Class 10 Questions and Answers
2. Give any four styles supported by OpenOffice.org
Answer – OpenOffice.org supports various styles, including:
Paragraph Styles: Used to format paragraphs, including indentation, line spacing, and font size.
Character Styles: Used to format individual characters, including font type, size, color, and style.
Page Styles: Used to format the overall appearance of a page, including margins, headers, and footers.
List Styles: Used to format bulleted or numbered lists, including the type of bullet or number, indentation, and spacing.
Digital Documentation Class 10 Questions and Answers
3. What is the best way to load styles from a template or another document?
Answer – You can copy styles by loading them from a template or another document, for example:
Open the document into which you wish to paste the styles.
In the Styles and Formatting window, click on Load Styles after long-clicking on the arrow next to the New Style from Selection symbol.
Locate and choose the template you wish to copy styles from in the Load Styles window
Choose the style categories you want to copy. If you want the copied styles to overwrite any styles with the same names in the document you’re putting them into, select Overwrite.
To copy styles from another document, click the From File button to bring up a box where you may choose the required file.
Digital Documentation Class 10 Questions and Answers
4. How can you modify the style?
Answer – Styles can be changed in a variety of ways in OpenOffice.org. • Load or copy styles from another document or template • Update a style from a selection
5. How can we create our own styles?
Answer – There are two different ways to create a style –
Creating a new style from a selection – You can copy a new style from an existing style. This new style will only be applied to this document and will not be saved in the template.
Dragging And Dropping To Create A Style – You can drag and drop a text selection into the Styles and Formatting window to create a new style.
Digital Documentation Class 10 Questions and Answers
Session 2: Insert and use images
6. Explain any five Graphic filters.
Answer – The following are four graphic filters: a. Invert – Changing the color in the color image, and giving brightness in grayscale image. b. Solarization – Increasing the effects of excessive light in a photograph. c. Posterize – Reduces the number of colours in a picture to make it look like a painting. d. Charcoal – The image is displayed as a charcoal sketch. e. Mosaic – Combines groupings of pixels into a single colour area.
Digital Documentation Class 10 Questions and Answers
7. Explain Image Cropping
Answer – Image cropping is the process of removing unwanted parts of an image by selecting and keeping a specific portion of the image while discarding the rest. Method for cropping image are right-click the image and choose Picture from the pop-up menu to begin cropping it. Select the Crop page in the Picture dialogue box.
The following parameters can be controlled on the Crop page:
Keep scale / Keep image size –
When Keep scale is chosen (the default), cropping the image has no effect on the image’s scale.
Cropping creates enlargement (for positive cropping values), shrinking (for negative cropping values), or distortion of the image when Keep image size is selected, so the image size remains constant.
Left, Right, Top, and Bottom –
You can crop the image using the dialog box, you can enter left, right, top and bottom margins to crop the image.
Keep scale – using this option you can crop the image without changing the size of the image.
Keep image size – Without changing the height and width of the image you can crop the image using keep image size.
Digital Documentation Class 10 Questions and Answers
8. List any three methods of inserting images in a text document.
Answer – The three methods for inserting images in digital documents are –
Drag and Drop
Inserting image from clipboard
Insert image from Scanner
Digital Documentation Class 10 Questions and Answers
9. What do you understand by the terms: a. Text Wrapping b. Anchoring
Answer – a. Text Wrapping – Text wrapping describes the relationship between graphics and the surrounding text, which may wrap around the graphic on one or both sides, be overprinted behind or in front of the graphic, or be overprinted behind or in front of the graphic. b. Anchoring – The graphics’ reference point is referred to as IT. This point could represent the object’s location on the page or in the frame. An anchor point is always present in an image.
Digital Documentation Class 10 Questions and Answers
Session 3: Create and use template
10. What are templates? What are the advantages of using templates?
Answer – A template is a type of document that you can use to make a similar type of document. Templates can contain text, graphics, style, design.
Advantage of template are – a. Document creation is made easier with templates. b. It save time to giving style in document c. The use of templates helps to keep the audience’s interest.
11. What is the difference between styles and templates?
Answer – a. Style – Styles ensure that your formatting is consistent throughout a document.
b. Template – Templates allow you to reuse text and maintain a consistent look and feel across many projects.
Digital Documentation Class 10 Questions and Answers
12. Explain different ways of creating a template.
Answer – There are two ways to create templates in a document.
Creating a template from a document – 1. Create or edit a new or existing document of the type you wish to use as a template. 2. Fill in the blanks with the content and styles you desire. 3. Select File > Templates > Save from the main menu.
Creating a template using a wizard – Wizards can be used to construct letter, fax, agenda, presentation, and Web page templates. The Fax Wizard, for example, walks you through the following options: 1. Fax machine type (business or personal) 2. Document components such as the date, topic line (for business faxes), salutation, and closing 3. Information about the sender and receiver options (business fax) 4. Inclusion of text in the footer (business fax)
Digital Documentation Class 10 Questions and Answers
Session 4: Create and customize table of contents
13. What do you mean by table of content?
Answer – The table of contents tool in Writer allows you to create an automated table of contents from your document’s headings.
Many of the elements are used in table of content –
a. E# – It indicate chapter number b. E – It represents the entry text c. T – It represents tab stop d. LS – It represents start of a hyperlink e. LE – It represents End of a hyperlink
Session 5: Implement Mail Merge
14. Explain Mail Merge.
Answer – A mail merge is a method of personalizing a message you’ve written and sending it to a large group of people, giving the impression that you prepared the letter specifically for them.
Digital Documentation Class 10 Questions and Answers
15. What are the advantages of Mail Merge?
Answer – Advantages of mail merge are – a. It’s simple to send the same mail to a big group of recipients using the Mail Merge tool. b. We don’t have to type each recipient’s name separately in each letter when we use Mail Merge. c. It’s one of the most efficient ways to mass-produce hundreds of personalized letters in a short amount of time. d. It is simple to amend the letter because any change made in the main letter will be reflected in all other recipients’ letters.
16. Give examples of databases in which the Data Source can be created.
Answer – Any database that supports Open Database Connectivity (ODBC) can be utilized as a data source. They can also be made in spreadsheets using Excel, or other similar software. For example – a. Spreadsheet b. Text file c. CSV file d. OpenOffice base or Access
Extra Questions from Textbook
Q. Explain the concept of styles in digital documents and how they are useful for formatting text and paragraphs.
Answer – Styles in digital documents are a useful feature that enables users to apply a predefined set of formatting options to text and paragraphs in a single click. A style can encompass font size, typeface, color, paragraph spacing, alignment, and other formatting options. Consistent use of styles throughout a document can help ensure a consistent and polished appearance, enhance readability, and save time by avoiding manual formatting changes. Overall, styles are a powerful tool that can significantly improve the efficiency and effectiveness of digital document processing.
Digital Documentation Class 10 Questions and Answers
Q. How can styles be used to create a table of contents in a digital document?
Answer – To create a table of contents in a digital document, styles can be utilized by assigning particular styles to headings and subheadings throughout the document. By applying the “Heading 1” style to primary section headings and the “Heading 2” style to subheadings, users can generate an automatic table of contents that lists all of the document’s sections and subsections in a structured and organized manner.
This saves time and effort since users don’t have to manually create a table of contents, and it also ensures that the document is consistent and easy to navigate for the reader. In short, using styles to create a table of contents is a powerful feature of digital documents that improves the overall readability and usability of the document.
Digital Documentation Class 10 Questions and Answers
Q. How can the use of styles help to improve the accessibility of a digital document?
Answer – Styles are an effective means of enhancing the accessibility of digital documents as they provide a consistent structure and formatting that is easy for users with visual impairments to navigate. By utilizing styles to define headings and subheadings, document creators can establish a clear hierarchy of information that can be interpreted effectively by screen readers.
This results in a document that is more user-friendly and inclusive, as it enables individuals with visual impairments to easily access and understand the content. Ultimately, incorporating styles into digital documents can have a positive impact on the overall accessibility and usability of the document, which is a crucial consideration in today’s increasingly diverse and inclusive society.
Digital Documentation Class 10 Questions and Answers
Q. How can the use of styles improve the efficiency of document creation and editing?
Answer – Styles can enhance the efficiency of document creation and editing by enabling users to quickly and easily apply formatting options to text and paragraphs. By defining a set of styles that reflect the formatting options commonly used in the document, users can swiftly apply those styles to text and paragraphs with a single click, streamlining the process and saving time.
This feature allows for consistency in formatting, reduces the possibility of errors, and improves the overall productivity of document creation and editing. In summary, using styles is a powerful tool that significantly enhances the efficiency of digital document processing.
Digital Documentation Class 10 Questions and Answers
Q. How can styles be used to ensure consistency in a collaborative digital document?
Answer – Using styles in a collaborative digital document can ensure consistency by defining a set of agreed-upon formatting options. This allows all collaborators to use the same styles throughout the document, resulting in a consistent appearance and better readability.
Digital Documentation Class 10 Questions and Answers
Q. How can styles be used to format text or paragraphs in a way that reflects the document’s purpose or audience?
Answer – Users can use styles to ensure that the digital document effectively communicates its message by applying styles that reflect its purpose or target audience. Furthermore, they can modify existing styles or create new ones to satisfy the document’s unique requirements. This approach results in a more readable and engaging document that is tailored to its intended purpose.
Digital Documentation Class 10 Questions and Answers
Q. What is a table of contents in a digital document, and how can it benefit the reader?
Answer – A table of contents in a digital document is a list of the document’s sections or chapters with corresponding page numbers or hyperlinks. It provides an overview of the document’s structure and helps the reader navigate the document quickly and easily. By using a table of contents, the reader can locate specific sections of the document without having to manually search for them, saving time and improving the reading experience.
Digital Documentation Class 10 Questions and Answers
Q. How can a table of contents be created and formatted in a digital document?
Answer – To create and format a table of contents in a digital document, users can follow these steps:
Assign unique heading styles to each section or chapter of the document.
Insert a table of contents using the appropriate option from the menu or toolbar.
Customize the table of contents by choosing the desired style and formatting options to match the document’s design and layout.
Update the table of contents whenever changes are made to the document’s structure or content to ensure its accuracy and usefulness to the reader.
Digital Documentation Class 10 Questions and Answers
Q. What are some best practices for creating a table of contents in a digital document?
Answer – When creating a table of contents in a digital document, it is important to use descriptive and accurate section or chapter headings, update the table of contents as changes are made to the document, use accurate hyperlinks or page numbers, customize the formatting to match the document’s design, and test the table of contents to ensure it is user-friendly and easy to navigate.
Digital Documentation Class 10 Questions and Answers
Q. How can the use of a table of contents benefit the author of a digital document?
Answer – Using a table of contents can be advantageous for the writer of a digital document in various ways. By presenting a structured and well-organized summary of the document’s content, the writer can ensure that the document is easily comprehensible and coherent. Consequently, this can save time and minimize the possibility of mistakes that may arise when the reader has to search for particular sections or chapters manually.
Reference Textbook
The above Digital Documentation Class 10 Notes PDF was created using the NCERT Book and Study Material accessible on the CBSE ACADEMIC as a reference.
Your valuable Feedback
Hi Students, Thank you for taking the time to reading Digital Documentation Class 10 Important Questions and Answers. Please take a few moments and leave your thoughts in the comment box below.
Disclaimer – 100% of the questions are taken from the CBSE textbook digital documentation advanced class 10 notes, and our team has tried to collect all the correct Question and Answer from the textbook . If you found any suggestion or any error please contact us anuraganand2017@gmail.com.
Teachers and Examiners collaborated to create the Digital Documentation Class 10 MCQ. All the important MCQs are taken from the NCERT Textbook Information Technology ( 402 ).
Very Important MCQs from Textbook
Session 1: Create and Apply styles in the document
1. ___________ is a set of formats that you can apply to selected pages, text, frames, and other elements in your document. a. Style b. Format c. Design d. None of the above
Show Answer ⟶Hide Answer ⟵
a. Style
2. You can apply a whole group of formats at the same time using ___________. a. Style b. Format c. Design d. None of the above
Show Answer ⟶Hide Answer ⟵
a. Style
3. Give the example of style in OpenOffice.org __________. a. Page Style b. Paragraph Style c. Character Style d. All of the above
Show Answer ⟶Hide Answer ⟵
d. All of the above
4. How you can apply style in the digital documentation _________. a. Using the styles and formatting windows b. Using fill format mode c. Both a) and b) d. None of the above
Show Answer ⟶Hide Answer ⟵
c. Both a) and b)
Digital Documentation Class 10 MCQ
5. ___________affect the font and size of chosen text within a paragraph, as well as bold and italic forms. a. Page styles b. Paragraph styles c. Character styles d. Graphic styles
Show Answer ⟶Hide Answer ⟵
c. Character styles
6. Which style includes headers and footers, as well as borders and margins? a. Character Style b. Page Style c. Frame style d. Presentation Style
Show Answer ⟶Hide Answer ⟵
b. Page Style
7. Which style affects the font size, boldness, and italics format of the selected text? a. Cell Styles b. Numbering Styles c. Character Styles d. Frame Styles
Show Answer ⟶Hide Answer ⟵
c. Character Styles
8. How you can create a new style in digital documentation _____________. a. Creating a new style from a selection b. Dragging and dropping to create a style c. Both a) and b) d. None of the above
Show Answer ⟶Hide Answer ⟵
c. Both a) and b)
9. How you can modify style in digital documentation ___________. a. Updating a style from a selection b. Load or copy styles from another document or template c. Both a) and b) d. None of the above
Show Answer ⟶Hide Answer ⟵
c. Both a) and b)
Digital Documentation Class 10 MCQ
20. Styles and Formatting Window is available in ______ menu. a. Format b. Insert c. Tools d. View
Show Answer ⟶Hide Answer ⟵
a. Format
Session 2: Insert and use images
21. Images can be added to a document in several ways by inserting _____________. a. From Graphics Program b. From Scanner c. Form Open Office Gallery d. All of the above
Show Answer ⟶Hide Answer ⟵
d. All of the above
22. Krishna wants to create a flowchart in Word for his applications. Which option should he choose in order to do this work quickly? a. Drawing/Shapes b. Symbols c. Pictures d. All of these
Show Answer ⟶Hide Answer ⟵
c. Pictures
23. Using the ____________ option in a word processor, the user can insert lines, simple geometric forms, arrows, stars, banners, and callouts into the manuscript. a. Pictures b. Chart c. Symbol d. Shapes
Show Answer ⟶Hide Answer ⟵
d. Shapes
24. By selecting the ______ option, you can copy Styles from a template or another document. a. New Style from selection. b. Update Style. c. Load Style. d. None of the Above
Show Answer ⟶Hide Answer ⟵
c. Load Style.
25. How many resize handles will be there around the image? a. Six b. Eight c. Ten d. Five
Show Answer ⟶Hide Answer ⟵
b. Eight
26. Fatima has added a photograph to a document. She wishes to cut a portion of the image. Which method should she use to complete the task? a. Cut b. Copy c. Crop d. Layout
Show Answer ⟶Hide Answer ⟵
c. Crop
27. To insert hyperlink in digital document you have to use the following shortcut key: a. Ctrl+K b. Ctrl+H c. Ctrl+L d. Ctrl+P
Show Answer ⟶Hide Answer ⟵
a. Ctrl+K
Digital Documentation Class 10 MCQ
28. Area where cut and copied image stored is _________________ a. Clipboard b. RAM c. ROM d. Imageboard
Show Answer ⟶Hide Answer ⟵
a. Clipboard
29. Which of the following is not a Graphic filter component in digital documents? a. Invert b. Smooth c. Sharpen d. Wrapping
Show Answer ⟶Hide Answer ⟵
d. Wrapping
30. You can change color images to grayscale by selecting the image and then selecting Grayscale from the ____________. a. Graphics mode b. Filter c. Flip d. None of the above
Show Answer ⟶Hide Answer ⟵
a. Graphics mode
31. __________ helps to transport the image vertically or horizontally. a. Graphics mode b. Filter c. Flip d. None of the above
Show Answer ⟶Hide Answer ⟵
b. Filter
32. _________ options are used to convert the color values of a color image or the brightness values of a grayscale image. a. Smooth b. Invert c. Sharper d. Remove noise
Show Answer ⟶Hide Answer ⟵
b. Invert
33. __________ helps to mimic the effects of too much light in a picture. a. Smooth b. Invert c. Solarization d. Remove noise
Show Answer ⟶Hide Answer ⟵
c. Solarization
34. ___________ makes a picture appear like a painting by reducing the number of colors used. a. Smooth b. Posterize c. harper d. Remove noise
Show Answer ⟶Hide Answer ⟵
b. Posterize
35. __________ joins groups of pixels into a single area of one color. a. Smooth b. Invert c. Mosaic d. Remove noise
Show Answer ⟶Hide Answer ⟵
c. Mosaic
Digital Documentation Class 10 MCQ
36. _____________ helps to make the image transparent. a. Smooth b. Invert c. Transparency d. Remove noise
Show Answer ⟶Hide Answer ⟵
c. Transparency
37. ___________ helps to cut off the parts of the image without changing the scale of image. a. Smooth b. Cropping c. Invert d. Remove noise
Show Answer ⟶Hide Answer ⟵
b. Cropping
38. _________ helps to change the size of the image in a digital document. a. Smooth b. Invert c. Keep Scale d. None of the above
Show Answer ⟶Hide Answer ⟵
c. Keep Scale
39. The size of the image changes when you specify in percentages __________. a. Scale Width and Height b. Resize c. Nosize d. None of the above
Show Answer ⟶Hide Answer ⟵
a. Scale Width and Height
40. You can resize the image by selecting one of the corner handles and keep the _______ key pressed while dragging the handle to its new position. a. Ctrl b. Shift c. Alt d. None of the above
Show Answer ⟶Hide Answer ⟵
b. Shift
Digital Documentation Class 10 MCQ
41. Color toolbar allow us to change a. RGB Color Components b. Brightness c. Gamma effect of image d. All of the above
Show Answer ⟶Hide Answer ⟵
d. All of the above
42. Rotate option available on ________ toolbar. a. Picture b. Art c. Drawing d. None of the above
Show Answer ⟶Hide Answer ⟵
c. Drawing
43. Which of the following is the correct method for opening the Picture toolbar? a. View—> Tools—> Picture b. Insert—> Tools—> Picture c. View—> Toolbars—> Picture d. Insert—> Toolbars—> Picture
Show Answer ⟶Hide Answer ⟵
c. View—> Toolbars—> Picture
44. In the Graphics mode of the picture toolbar, which of the following options is not available? a. Grayscale b. Black/White c. Watermark d. Original
Show Answer ⟶Hide Answer ⟵
d. Original
Session 3: Create and use template
45. We can create temples in __________. a. Writer c. Spreadsheet d. Impress e. All of the above
Show Answer ⟶Hide Answer ⟵
d. All of the above
46. A __________ is a model that you use to create other documents. a. Document b. Template c. Design d. None of the above
Show Answer ⟶Hide Answer ⟵
b. Template
47. Which of the following does not allow the Templates dialogue to appear? a. File>New>Template b. File>Template>Manage Template c. File>New>Text Document
Show Answer ⟶Hide Answer ⟵
c. File>New>Text Document
48. In Writer, you can make a Template by saving a document with the _____ extension. a. .odt b. .ott c. .dbm d. .ods
Show Answer ⟶Hide Answer ⟵
b. .ott
49. Document templates can contain ____________. a. Text b. Graphics c. Style d. All of the above
Show Answer ⟶Hide Answer ⟵
d. All of the above
50. The ___________ is used to create a list of chapter names and page numbers at the beginning of a content. a. Index b. Heading c. Table of content d. None of the above
Show Answer ⟶Hide Answer ⟵
c. Table of content
Digital Documentation Class 10 MCQ
51. To create a table of content automatically you have to give ___________ style. a. Index b. Content c. Heading d. None of the above
Show Answer ⟶Hide Answer ⟵
c. Heading
52. Which options help to protect the table of content ____________. a. Protected any time b. Protected against manual changes c. Always Protect the changes d. None of the above
Show Answer ⟶Hide Answer ⟵
b. Protected against manual changes
53. E#, E, T, #, LS,ES belong to which feature? a. Mail Merge. b. Indexes and Tables c. Tables. d. None of these.
Show Answer ⟶Hide Answer ⟵
b. Indexes and Tables
54. Which of the following tabs is not available in the insert Index/Table dialog box? a. Entries b. Styles c. Background d. None of the above
Show Answer ⟶Hide Answer ⟵
d. None of the above
55. In Writer, which of the following levels of headers can be indexed? a. H1 b. H2 c. H3 d. All of the above
Show Answer ⟶Hide Answer ⟵
d. All of the above
56. __________ button represents the chapter number in the table of content. a. E# b. E c. T d. #
Show Answer ⟶Hide Answer ⟵
a. E#
57. ___________ button represents the entry text in the table of content. a. E# b. E c. T d. #
Show Answer ⟶Hide Answer ⟵
b. E
58. ___________ button represents the tab stop in the table of content. a. E# b. E c. T d. #
Show Answer ⟶Hide Answer ⟵
c. T
59. ___________ button represents the page number in the table of content. a. E# b. E c. T d. #
Show Answer ⟶Hide Answer ⟵
d. #
60. ___________ button represents the start of a hyperlink in the table of content. a. E# b. E c. LS d. #
Show Answer ⟶Hide Answer ⟵
c. LS
Digital Documentation Class 10 MCQ with Answers
61. ___________ button represents the end of a hyperlink in the table of content. a. E# b. E c. LE d. #
Show Answer ⟶Hide Answer ⟵
c. LE
Session 5: Implement Mail Merge
62. A _______________ is a method of sending a single letter to a large group of recipients. a. Table of content b. Mail Merge c. Style d. None of the above
Show Answer ⟶Hide Answer ⟵
b. Mail Merge
63. Which help us to send the same letter to different persons? a. Macros b. Mail Merge c. Template d. None of above
Show Answer ⟶Hide Answer ⟵
b. Mail Merge
64. Amrita has just turned 14 years old. She intends to invite her friends and family to the gathering. Which function will she employ to send the same invitation to a large number of individuals with various addresses without having to type it over and again? a. Mail Merge b. Letter wizard c. Document Type d. None of these
Show Answer ⟶Hide Answer ⟵
a. Mail Merge
65. Which type of data format we can add in mail merge ____________. a. .txt b. .csv c. .mdb d. All of the above
Show Answer ⟶Hide Answer ⟵
d. All of the above
66. A Cyber Awareness brochure must be created. Which of the Office Suite components should be used to complete this task: a. Spreadsheet b. Digital Documentation c. Database Management d. Mail Merge
The above Digital Documentation Class 10 MCQ with Answers was created using the NCERT Book and Study Material accessible on the CBSE ACADEMIC as a reference.
Your valuable Feedback
Hi Students, Thank you for taking the time to reading Digital Documentation Class 10 MCQ . Please take a few moments and leave your thoughts in the comment box below.
Disclaimer – 100% of the questions are taken from the CBSE textbook Digital Documentation Advanced Class 10 Notes, and our team has tried to collect all the correct MCQs from the textbook . If you found any suggestion or any error please contact us anuraganand2017@gmail.com.
