Go and check all the topics on ITeS
Go and check all the topics of Skills
Go and check all the topics of Computer
Go and surf this website
Go and surf this educational site designed for vocational education
A picture speaks a thousand words. We use a lot of images in a presentation to make it simple and interesting. The steps to insert a clipart or an image are as follows:-
1. Click on Insert from the menu.
2. Select Image option.
3. An Insert Image dialog box appears.
4. Browse through folders and select the image you want to use.
5. Click on Open button.
In this way, we can insert images in our presentation slides and make it more interesting.
Shapes are a great way to make our presentations more interesting. LibreOffice provides different shapes, such as lines, square, circle, arrows, symbols, etc., that can be inserted into slides.
To add a shape, do the following:-
1. Click Insert menu.
2. Click Shapes Option. Different shapes are available.
3. Select a shape, and then click and drag to draw the shape.
After we add one or more shapes, we can add text, bullets, and numbering to them, and we can change their fill, outline, and other effects.
Once a shape is inserted in a slide, we can use the Properties tab to make changes to the properties of the shape, such as color, size, position, direction, etc.
A slide is a single page of a presentation. Collectively, a group of slides may be known as a slide deck. In the digital age, a slide most commonly refers to a single page developed using a presentation program such as MS PowerPoint, Apple Keynote, Google Slides, or LibreOffice.
Slides are like new pages, which are added to separate different topics in a presentation.
To add a new slide, do the following:-
1. Click on Slide.
2. Select New Slide from the drop-down menu.
3. We can also press Ctrl+M on the keyboard. This will add a blank New Slide to the presentation
4. The layout or arrangement of textboxes, etc., will be similar to the previous one
To Deleting slides, do the following:-
1. Select the slide that we want to delete.
2. Click on Slide menu.
3. Select Delete Slide option from the drop-down menu.
4. The selected slide will be deleted.
5. We can press ‘Del’ key on the keyboard to delete the selected slide.
A presentation program is a software package used to display information in the form of a slide show. It is defined as computer programs designed to allow the user to present information in such as with text, pictures, sound and video
It has three major functions:-
1. Editor: - An editor that allows text to be inserted and formatted.
2. Method: - A method for inserting and manipulating graphic images.
3. Slide show:- A slide-show system to display the content.
Presentation software is being widely used to make digital presentations. It has many advantages, which are as follows.
1. Visual: Visualizing information helps our readers (Audience) see what we are explaining.
2. Versatile: It incorporates photos, illustrations, sketches, and even video if it's posted online.
3. Interactive: We can embed links and jump around the document itself or out to the Internet.
There are a number of presentation software available,they are:-
1. LibreOffice Impress
2. Microsoft Office – PowerPoint
3. OpenOffice Impress
4. Google Slides
5. Apple Keynote
Most features in all these software are same.
Password protection allows we to protect our data set by assigning it a password. Another user cannot read, change, or delete our data set without knowing the password.
The steps to protect a spreadsheet are as follows.
1. Click on Tools menu and select Protect Spreadsheet.
2. A Protect Document dialog box appears.
3. Type in a password.
4. Type the same password in the Confirm textbox.
5. Click on OK button.
Now, when we close the file and open it again, it will ask for the password. Remember this password so that we can open the file.
Another way of protecting a spreadsheet is as follows.
1. Select File and select the option Info.
2. Select the Protect Workbook box and choose Encrypt with Password.
3. Enter a password in the Password box, and then select OK.
4. Confirm the password in the Reenter Password box, and then select OK.
Now, when we try to open the file, it will ask for a password. Type the password and click on OK button.
1. Sorting data :- Sorting in Excel is arranging data according to our requirements. It can be done alphabetically or numerically.
The steps to sort data are as follows.
1. Select all rows and columns that have to be sorted.
2. Click on Data, and then, select Sort. This will displays a Sort dialog box .
3. Click on Sort Key 1 and select total from the drop-down. By default the order is Ascending, which means from the lowest to the highest. We will change it to Descending. This will sort the data in the total field.
4. Click on OK.
The data will get rearranged in the entire list and the name of the cell with the highest number will appear at the top,and then, with the next highest number, and so on.
2. Filtering data:- Filtering data in MS Excel refers to displaying only the rows that meet certain conditions. (The other rows gets hidden.) Using the store data, if you are interested in seeing data where Roll No is 201, then you can set filter to do this.
The steps to apply filter to a table are as follows:-
1. Click on the AutoFilter icon on the Tool Bar.
2. This will put filters at the top of each column.
3. Click on the filter for (for example ‘class’) column.
4. The drop-down will show a list of all the values in that column, for example,Class XII- A and XII-B.
5. By default, all values are checked or selected.
6. If you want to see the data of students only from Class XII-A, uncheck Class XII-B .
7. Click on OK. Data of students only from Class XII-A will be displayed.
1. Saving the spreadsheet
After entering data, we can save the spreadsheet in the same way as a Notepad or any other word file.
Click File menu, and then, click the Save as option. This will open a Save As dialog box. Type the file name and click save button.
The default Save as type is ODF Spreadsheet (.ods) but we can save the spreadsheet in other types, such as Microsoft Excel 2003 (.xls).
2. Closing the spreadsheet
Once we have saved the data, we can close the spreadsheet by clicking File menu, and then, click the Close option. The opened file will be closed.
Another method to close the file click the close button on the title bar, the file will be closed.
3. Opening a spreadsheet
To open a file Click File menu and then, select Open option. This will show a dialog box with a list of existing files. Select the one file we want to open and click open button. The selected file will be opened.
4. Printing the spreadsheet
To print a spreadsheet, we can click File menu , and then, select Print option from the drop-down menu or press Ctrl+P on the keyboard.
A Print dialog box appears. Select the printer, range of pages and number of copies to be printed, and click OK.
1. Workbook — A workbook is the name given to an Excel file and contains one or more worksheets. Although you're limited to 255 sheets in a new workbook, Excel doesn't limit how many worksheets you can add after you've created a workbook.
2. Worksheet — A Worksheet is a collection of cells organized in rows and columns. A worksheet or sheet is a single page in a file created with an electronic spreadsheet program such as Microsoft Excel or Google Sheets.
3. Cell — A cell is a rectangle or block housed in a worksheet. Any data that you want to enter into your worksheet must be placed in a cell. An Active Cell is one that is currently opened for editing.
4. Columns and Rows — Columns and Rows refer to how your cells are aligned. Columns are aligned vertically while rows are aligned horizontally.
5. Ribbon — Above the workbook is a section of command tabs called the Ribbon. A multitude of options are found behind each tab of the ribbon
6. Cell Reference — A cell reference is a set of coordinates that identifies a specific cell. It's a combination of letters and numbers. A5, for example, would point to the cell located where column A and row 5 intersect.
7. Cell Range — A Cell range is a collection of cells that have been identified as a group based on a variety of criteria. By using a colon (:) between cell references. for example, A1:C1.
8. Merged Cell — When two or more cells are combined, it's become what is known as a merged cell.
9. Formula — A sequence inside a cell that is used to produce a value. It must begin with an equal (=) sign. This could be a mathematical equation, cell references, functions or operator. A formula is also known as an expression.
10. Formula Bar — The Formula Bar will display the contents of an active cell. In the case of formulas, the formula bar will display all components of the formula.
11. Function — Functions are formulas that are pre-built into Excel. They are designed to
help simplify potentially complex formulas in a worksheet.
LibreOffice Calc is a spreadsheet application that you can use to calculate, analyze, and manage your data. You can also import and modify Microsoft Excel spreadsheets. Steps to open LibreOffice Calc, do the following:-
1. The first thing we need to ensure is that LibreOffice must be installed on your computer.
2. Type LibreOffice Calc in the search bar of Windows.
3. Select LibreOffice Calc from the search results. LibreOffice Calc will open ablank sheet..
4. You can start typing and entering data as soon as you open the spreadsheet.
A spreadsheet or worksheet is a file made of rows and columns that help sort data, arrange data easily, and calculate numerical data. The three most common general uses for spreadsheet software are to create budgets, produce graphs and charts, and for storing and sorting data.
There are many types of spreadsheet available that have been created by different companies. Some of the mostpopular ones are:-
1. Microsoft Excel
2. LibreOffice Calc
3. Google sheet
ICT stands for Information and Communication Technology. ICT refers to all the methods, tools, Concepts related to storing, recording and sending digital information. ICT devices are tablets, smartphones and laptops. ICT skills help us to communicate, run our business and stay connected with our family and friends.
