Short notes-2 -Office Tools -NCERT – Class 9 -computer Science

Short notea-2 -Office Tools -NCERT – Class 9

Presentation Tool: 

◆A presentation tool is software used to create and deliver slideshows for presentations.

◆Examples include Microsoft PowerPoint, Google Slides, and Apple Keynote.

Basic elements of a slide:

◆Title, subtitle, text, images, charts, graphs, tables, and multimedia elements.

Different types of slide layouts:

◆Title slide, title and content slide, section header slide, two-content slide, comparison slide, and blank slide.

Creating and saving a presentation:

◆Open the presentation software and select a new presentation template.

◆Add slides, content, and multimedia elements to your presentation.

◆Click on “File” and select “Save” to save the presentation to your desired location.

Edit and Format a Slide: 

Adding titles, subtitles, text:

◆Click on the slide and enter the title, subtitle, or text.

Background and watermark:

◆Click on the “Design” tab and select a background style or apply a watermark to the slide.

Headers and footers, slide numbers:

◆Click on the “Insert” tab and select “Header & Footer” to add headers, footers, or slide numbers to your slides.

Insert Pictures from Files, Create Animations, Add Sound Effects, Rehearse Timings:

Inserting pictures from files:

Click on the “Insert” tab and select “Pictures” to insert pictures from files into your slides.

Creating animations:

Click on the “Animations” tab and select an animation effect for objects on your slides.

Adding sound effects:

Click on the “Insert” tab and select “Audio” to insert sound effects into your slides.

Rehearsing timings:

Click on the “Slide Show” tab and select “Rehearse Timings” to practice your presentation and record slide timings.

Spreadsheets: 

◆A spreadsheet is software used for organizing, analyzing, and presenting numerical data.

◆Examples include Microsoft Excel, Google Sheets, and Apache OpenOffice Calc.

Concept of a worksheet and a workbook:

◆A worksheet is a single page or “tab” within a spreadsheet file where data is organized into rows and columns.

◆A workbook is a collection of one or more worksheets contained within a single file.

Working with a Spreadsheet:

Entering numbers, text, date/time:

◆Click on a cell and enter numbers, text, or date/time values.

◆Use the auto-fill handle to quickly fill in a series of numbers or dates.

Editing and formatting a worksheet:

◆Use the formatting options to change the color, size, font, and alignment of text in cells.

◆Insert and delete cells, rows, and columns as needed.

Entering formulas using operators:

◆Use mathematical operators (+, -, *, /) to perform calculations in cells.

◆Refer to other cells by their cell references in formulas.

Printing a worksheet:

◆Click on the “File” tab and select “Print” to print the worksheet.

Using Simple Statistical Functions, Embedding Charts: 

◆Simple statistical functions (SUM(), AVERAGE(), MAX(), MIN(), IF()):

◆Use these functions to perform basic calculations