MID-TERM SAMPLE PAPER, CLASS-X, IT-SKILLS-402, CBSE

 

INFORMATION TECHNOLOGY (SUBJECT CODE 402)

Mid-Term CLASS X (SESSION 2023-2024)

Max. Time: 2Hours                                                                                                                                      Max. Marks: 50

MARKING SCHEME(SOLUTION)

SECTION A

Answer any 4 questions out of the given 6 questions                                           (1 x 4 = 4 marks)  

Q1

1.	You need to apply leave at work? Which method of communication will you use? (a) e-mail (b) Poster (c) Newsletter (d) Blog	1
2.	Which of the following statement is true about communication? (a) 50% of our communication is non-verbal (b) 20% communication is done using body movements, face, arms, etc. (c) 5% communication is done using voice, tone, pauses, etc. (d) 7% communication is done using words	1
3.	Which of these is NOT an appropriate non-verbal communication at work? (a) Keeping hands in pockets while talking (b) Talking at moderate speed  (c) Sitting straight (d) Tilting head a bit to listen	1
4.	Which of the following are effective components of a good feedback? (a) Detailed and time consuming (b) Direct and honest (c) Specific (d) Opinion-based	1
5.	What is feedback? Mention the types of feedback? Feedback is information about something, such as a product, service, or performance that is used to improve it. It can be positive or negative or No feedback. A good feedback is always • specific • helpful • kind Example of feedback: A customer tells a restaurant manager that the food was delicious, but the service was slow.	1
6.	Write any two Barriers of Effective Communication. 1.      Language 2.      Visual Perception 3.      Past Experience 4.      Prejudice 5.      Feelings 6.      Environment Noise or disturbance 7.      Personal factors (any relevant)	1

Q2 Answer any 5 questions out of the given 6 questions                                                 (1 x 5 = 5 marks)  

1.	Define Paragraph. A paragraph is a group of sentences that are related to each other and that support one main idea. Paragraphs are typically separated from each other by an empty line, and they may be indented at the beginning.	1
2.	When you open a new spreadsheet, by default, it has a sheet named ________ which is managed using tabs at the bottom of the spreadsheet. a. Sheet1             c. Worksheet1 b. Untitled1       d. New Sheet	1
3.	Which of the following is a valid file extension for image file? (a) .jpg (b) .doc (c) .text (d) .txt	1
4.	Which of the following application is not appropriate to store data about ABC Bank customers? a. Open Office Base             c. Open Office Writer b. MS Access                         d. MS Excel	1
5.	What is EUSTRESS or Good Stress? Mention one example It is the positive form of stress. It is for short duration of time which passes quickly. Example: A fire alarm is intended to cause stress that alerts you to avoid danger	1
6.	What makes you complete work or studies without others cheering you? a)      Self-confidence b)      Communication c)      Self-motivation d)      Self-esteem	1

Q3 Answer any 5 questions out of the given 6 questions                                             (1 x 5 = 5 marks)  

1.	What is the full form SMART in Smart Goal? 1.      S: Specific 2.      M: Measurable 3.      A: Achievable 4.      R: Realistic 5.      T: Time Bound	1
2.	What is Time management. Time management is the ability to plan and control how you spend the hours of your day well and do all that you want to do.	1
3.	Ravi works hard to get the best student award at the end of year. What type of motivation is this? a)      Internal b)      External c)      Both internal and external d)      Not any specific type of motivation	1
4.	______________can be defined as our emotional, mental, physical and social reaction to any situation.     Self-management	1
5.	Self-management MEANS _____________   ‘self-control’	1
6.	__________ is designed to help users with auditory impairments. a. Sound Sentry               c. Serial key b. High Contrast              d. Show Sounds Sound Sentry is an accessibility feature designed for people who have difficulty hearing system sounds generated by the computer.	1

Q4 Answer any 5 questions out of the given 6 questions                                                   (1 x 5 = 5 marks)  

1.	In Calc, Arguments passed to a macro from Calc are always ___________. a. Cell Reference                       c. Both a and b b. Values                                      d. Sheet Reference	1
2.	Write any 2 factors that cause stress to students. Social and academic(any relevant)	1
3.	__________refers to the reference point for the graphics. This point could be the page, or frame where the object is, a paragraph, or even a character. An image always has an anchor point. a)      Anchoring b)      Paging c)      Paragraphing d)      imaging	1
4.	Write any two Graphic filters and their effects available in open office writer.(any 2) Invert Reverses the colors of an image, so that black becomes white and white becomes black. Smooth Reduces the contrast between neighbouring pixels, giving the image a soft, hazy look. Sharpen Increases the contrast between neighboring pixels, making the image appear sharper. Solarization Converts some of the light pixels in an image to dark pixels and vice versa. Aging Applies a sepia tone to an image, giving it an aged look. Charcoal Sketch Converts an image into a charcoal sketch. Relief Creates a relief effect, giving the image a three-dimensional look. Mosaic Converts an image into a mosaic, made up of small, colored squares. Posterize Reduces the number of colors in an image, giving it a posterized look. Pop Art Converts an image into a Pop Art style, with bright, saturated colors and bold outlines.	1
5.	A _________ refers to a cell or a range of cells on a worksheet and can be used to find the values or data that you want formula to calculate. a. Cell reference                    c. Sheet Reference b. Block                                   d. Autofill	1
6.	How can you identify your strengths and weaknesses?	1

Q5 Answer any 5 questions out of the given 6 questions                                          (1 x 5 = 5 marks)

 

1.	What is the purpose of sharing worksheet? Sharing worksheet data refers to the process of allowing multiple users to access and edit the same worksheet. This can be done in a number of ways, depending on the spreadsheet software.	1
2.	Macros are useful to _____________ a task the same way over and over again.   Automate	1
3.	Spreadsheet software allows the user to share the workbook and place it in the __________ location where several users can access. Cloud	1
4.	Spreadsheet software can find the changes by ____________ Sheets.    Comparing	1
5.	At The bottom of each worksheet window is a small tab that indicates the ___________ of the worksheets in the workbook.          name	1
6.	A __________ refers to a cell or a range of cells on a worksheet and can be used to find the values or data that you want formula to calculate. cell reference	1

SECTION B

         Answer any 3 questions out of the given 5 questions                                              (2x 3 = 6 marks)

6.	Differentiate between Short-term Goals and Long-term Goals? Short-term Goals Long-term Goals ·         Time Period is less ·         Time Period is More ·         Means: What are your goals in the next 6 months to 2 years? ·         Means: What are your goals in the next 5-6 years? ·         For example: “I want to lose 10kg in the next 6 months.” ·         For example: “I want to become a MILLIONARE in 5 years”	2
7.	What are the Four Steps for Effective Time Management? 1.       Organise • We plan our day-to-day activities. 2.       Prioritise • We make a to-do list in the order of importance. 3.       Control • We have a control over our activities like not waste time in chatting on the phone and gossiping. 4.       Track • We identify and note where we have spent our time.	2
8.	Write the functions that are used in data consolidation? The data can be consolidated using a variety of functions, such as SUM, COUNT, AVERAGE, MAX, and MIN. Data consolidation is the process of combining data from multiple sources into a single location or Master Location.	2
9.	What do you mean by knowing yourself? It means you should know about your: 1.      Belief 2.      Background 3.      Strength and weakness 4.      Likes and dislikes 5.      Interest and abilities 6.      Values	2
10.	Write a short note on the following with diagram 1.          Rotating an image 2.          Resizing an image ·         Resizing an image changes its size, either making it larger or smaller. This can be done by adjusting the width and height of the image, or by changing its scale. Resizing an image can be useful for making it fit better in a document, or for making it more visually appealing. ·         Rotating an image changes its orientation. This can be done by rotating the image clockwise or counter clockwise by a certain number of degrees. Rotating an image can be useful for making it easier to read, or for aligning it with other images in a document.	2

        

         Answer any 4 questions out of the given 5 questions                                       (4 x 2 = 8 marks)

11.	Differentiate between Internal motivation and External motivation? Internal motivation External motivation ·         Internal Motivation: LOVE and self interest ·         External Motivation: REWARD ·         We do things because they make us happy, healthy and feel good. ·         We do things because they give us respect, recognition and appreciation. For example, Suresh participated in a 100m race and won a prize. This motivated him to go for practice every morning. ·         For example, when you perform on your annual day function and you learn something new, such as dancing, singing, etc., you feel good. ·         For example, Suresh participated in a 100m race and won a prize. This motivated him to go for practice every morning.	2
12.	What are templates? What are the advantages of using templates?  A template is a pre-formatted document that can be used as a starting point for creating new documents. Templates typically include the basic structure of the document, such as the font, font size, headers, footers margins, and page layout. Some common types of templates are: Business templates, such as invoices, letters, and reports. Personal templates, such as resumes, cover letters, and invitations.  Advantages Templates can help to ensure that your documents have a consistent look and feel. It increases the creativity by providing a starting point for new ideas.	2
13.	Write the steps to create a mail merge in OpenOffice Writer? 1)      Open a new document and save it as a mail merge document. 2)      Create the main document, which is the text that will appear in all of the merged documents. 3)      Create the data source, the data source can be a spreadsheet, a database, or a text file. 4)      In the main document, insert the merge fields. Merge fields are special codes that tell where to insert the data from the data source. 5)      Select the recipients of the mail merge. You can select recipients from a list, or you can type in the recipient names and addresses manually. 6)      Preview the mail merge. This will allow you to see how the merged documents will look before you actually send them. 7)      Merge the documents.	2
14.	What do you understand by the terms: 1.      Text Wrapping 2.      Anchoring  Text wrapping is a feature in word processing software that allows you to control how text flows around images and other objects. Anchoring is a feature in word processing software that allows you to attach an object to a specific location in a document.	2
15.	What is Goal-seek? Write the steps to apply Goal-seek? The Goal Seek feature allows you to set a target value for a cell and then Excel will automatically change the values in other cells to achieve that target value. To use Goal Seek, follow these steps: 1.     Click on the Data tab. 2.     In the What-If Analysis group, click on Goal Seek. 3.     In the Goal Seek dialog box, enter the target value in the To value box. 4.     Select the cell that contains the value you want to change. Then Click on OK.	2
16.	What are the steps for building self-motivation? There are four steps for building self-motivation: 1.      Identify your likes and dislikes. Understand what makes you happy. 2.      Define the goals you want to achieve and focus all your energy to achieve your goal. 3.      Plan a list of activities that you will do to achieve each goal. 4.      Work towards achieving your goal, even when you are facing difficult time.	2

         Answer any 3 questions out of the given 5 questions                                       (3 x 4 = 12 marks)

17.	What are Macros? How can we record a Macro? A macro is a series of commands that can be recorded and played back later. This can be useful for tasks that you do frequently. To record a macro, you can use the following steps: 1.     Open the spreadsheet where you want to record the macro. 2.     Click on the Developer tab. 3.     In the Macros group, click on Record Macro. 4.     In the Macro name box, enter a name for the macro. 5.     In the Store macro in box, select the workbook where you want to store the macro. 6.     Click on the OK button.	4
18.	What are the advantages of using templates? 1)      Templates can save lot of time and effort by providing a pre-formatted starting point for the documents. 2)      Templates can help to ensure that your documents have a consistent look and feel. 3)      Improves productivity by making it easier to create professional-looking documents. 4)      It increases the creativity by providing a starting point for new ideas.	4
19.	What are the advantages of using Mail-merge? 1.      Mail merge can save you a lot of time by automating the process of creating personalized documents. 2.      Mail merge can help to increase the accuracy of your documents. 3.      Personalizes your documents 4.      Mail merge is a flexible tool that can be used to create a variety of different documents, such as letters, emails, labels, and envelopes. 5.      Easy to use: Mail merge is relatively easy to use. 6.      Mail merge can help you to reduce errors by automating the process of inserting data into documents. 7.      Improves communication	4
20.	What is the difference between styles and templates? FEATURE STYLE TEMPLATE Definition A named collection of formatting attributes A pre-formatted document Purpose To quickly and easily format text To save time and effort when creating new documents Content Formatting attributes Basic structure of the document, such as font, font size, margins, and page layout Reusability Can be reused in different documents Can be used as a starting point for creating new documents Modification Can be modified to suit specific needs Can be modified to suit specific needs	4
21.	How can we rename a worksheet? There are three methods any one can be use: 1.       Method-1: Double-click on one of the existing worksheet names. 2.       Method-2: Right-click on an existing worksheet name, then choose Rename from the resulting Context menu. 3.    Method-3: Select the worksheet you want to rename (click on the worksheet tab) and then select the Sheet option from the Format menu. This displays a submenu from which you should select the Rename option.	4