Tuesday, 24 March 2015

Ms Office Applications Syllabus



Ms office Syllabus

Introduction and Windows
-        Start the computer.
-        Shut down and Restart the computer using an appropriate routine.
-        View the computer’s basic system information:
-        Operating system and version number,
-        Change the computer’s desktop configuration: date & time2, volume settings, desktop display options (colour settings, screen pixel resolution, screen saver options).
-        Recognize common desktop icons such as those representing: files, directories/folders, applications, printers, recycle bin/wastebasket.
-        Select and move desktop icons.
-        Open a file, directory/folder, application from the desktop.
-        Identify the different parts of a window: title bar, menu bar, toolbar, status bar, scroll bar.
-        Collapse, expand, resize, move, and close a window.
-        Switch between open windows.
-        Understand how an operating system shows drives, folders, files in a hierarchical structure.
-        Know that the devices used by an operating system to store files and folders are the hard disk, diskette, CD-ROM, network drives.
-        Navigate to a file, folder on a drive.
-        Create a directory/folder and a further sub-directory/sub-folder.
-        The recycle bin
-        Open a window to display directory/folder name, size, and location on drive.
-        Managing files and folders

Ms Word
-        Understanding the Word Screen   
-        Using Toolbars and Creating a New Document
-        Closing a Document, Creating a New Document, and Entering Text        
-        Selecting and Replacing Text        
-        Opening a Document and Saving a Document
-        Printing and Previewing a Document and Exiting Word    
-        Cutting, Copying  and Pasting Text           
-        Using the Thesaurus and Word Count
-        Inserting Symbols and Special Characters
-        Using Undo, Redo, and Repeat     
-        Formatting Characters Using the Toolbar
-        Using the Format Painter, Using the Font Dialog Box       
-        Paragraphing
-        Change case
-        Bullets and Numbers
-        Borders and shading
-        Adjusting Margins 
-        Creating Headers and Footers       
-        Changing the Paper Orientation and Size  
-        Previewing a Document, Controlling Where the Page Breaks       
-        Arranging Text in Multiple Columns         
-        Introduction to Tables and borders
-        Adding Shading and Patterns        
-        Mail merge

Ms Excel
-        Introduction to spreadsheets
-        Enter a number, date, text in a cell.
-        Select a cell, range of adjacent cells, range of non-adjacent cells, entire worksheet.
-        Select a row, range of adjacent rows, range of non-adjacent rows.
-        Select a column, range of adjacent columns, range of non-adjacent columns.
-        Insert rows, columns in a worksheet.
-        Delete rows, columns in a worksheet.
-        Modify column widths, row heights.
-        Insert additional cell content, replace existing cell content.
-        Use the undo, redo command.
-        Duplicate the content of a cell, cell range within a worksheet, between worksheets, between open spreadsheets.
-        Use the autofill tool/copy handle tool to copy, increment data entries.
-        Move the contents of a cell, cell range within a worksheet, between worksheets, between open spreadsheets.
-        Delete cell contents.
-        Use the search command for specific content in a worksheet.
-        Use the replace command for specific content in a worksheet.
-        Sort a cell range by one criterion in ascending, descending numeric order, ascending, descending alphabetic order.
-        Insert a new worksheet, Rename a worksheet, Delete a worksheet.
-        Duplicate a worksheet within a spreadsheet, between open spreadsheets.
-        Move a worksheet within a spreadsheet, between open spreadsheets.
-        Generate formulas using cell references and arithmetic operators (addition, subtraction, multiplication, division).
-        Recognize and understand standard error values associated with using formulas.
-        Understand and use relative, mixed, absolute cell referencing in formulas.
-        Generate formulas using sum, average, minimum, maximum, count, functions.
-        Format cells to display numbers to a specific number of decimal places, to display numbers with, without commas to indicate thousands.
-        Format cells to display a date style, Format cells to display a currency symbol.
-        Format cells to display numbers as percentages.
-        Change cell content appearance: font sizes, font types.
-        Apply formatting to cell contents such as: bold, italic, underline, double underline.
-        Align contents in a cell, cell range: left, centre, right, top, bottom.
-        Centre a title over a cell range, Adjust cell content orientation.
-        Add border effects to a cell, cell range.
-        Create different types of charts/graphs from spreadsheet data: column chart, bar chart, line chart, pie chart.
-        Add a title, label to the chart/graph. Remove a title, label from the chart/graph.
-        Change the background colour in a chart/graph.
-        Change the column, bar, line, pie slice colours in the chart/graph.
-        Change the chart/graph type, duplicate, move charts/graphs within a worksheet, between open spreadsheets. Resize, delete charts/graphs.
-        Change worksheet margins: top, bottom, left, right.
-        Change worksheet orientation: portrait, landscape. Change paper size.
-        Adjust page setup to fit worksheet contents on one page, on a specific number of pages.
-        Add; modify text in Headers, Footers in a worksheet.
Access
-        Understand what a database is.
-        Understand how a database is organised in terms of tables, records, fields, and with field data types, field properties.
-        Understand what a primary key is.
-        Understand what an index is.
-        Understand the purpose of relating tables in a database.
-        Understand the importance of setting rules to ensure relationships between tables are valid.
-        Change between view modes in a table, form, report.
-        Display, hide built-in toolbars.
-        Create and save a table and specify fields with their data types.
-        Add, delete records in a table, add a field to an existing table.
-        Add, modify data in a record, and Delete data in a record.
-        Use the undo command.
-        Navigate within a table to next record, previous record, first record, last record, specific record.

PowerPoint
-        Understand the uses of different presentation view modes.
-        Change between presentation view modes.
-        Add a new slide with a specific slide layout  such as: title slide, chart and text, bulleted list, table.
-        Change between built-in slide layouts.
-        Change background colour on specific slide(s), all slides.
-        Apply an available design template to a presentation.
-        Change between available design templates.
-        Insert a picture, image, drawn object into a master slide. Remove a picture, image, drawn object from a master slide.
-        Add text into Footer of specific slides, all slides in a presentation.
-        Apply automatic slide numbering, automatically updated date, non-updating date into Footer of specific slides, all slides in a presentation.
-        Add text into a presentation in standard, outline view.
-        Edit slide content, notes pages content by inserting new characters, words.
-        Change text appearance: font sizes, font types.
-        Apply text formatting such as: bold, italic, underline.
-        Apply case changes to text.

Internet and Email
-        Bookmark a Web page.
-        Display a bookmarked Web page, Create a bookmark folder.
-        Add Web pages to a bookmark folder.
-        Delete a bookmark.
-        Select a specific search engine.
-        Carry out a search for specific information using a keyword, phrase.
-        Combine selection criteria in a search.
-        Duplicate text, image, URL from a Web page to a document.
-        Save a Web page to a location on a drive as a txt file, html file.
-        Download text file, image file, sound file, video file, software, from a Web page to a location on a drive.
-        Preview a Web page.
-        Change Web page orientation: portrait, landscape. Change paper size.
-        Change Web page margins top, bottom, left, right.
-        Choose Web page print output options such as: entire Web page, specific page(s), specific frame, selected text, number of copies and print.
-        Email addresses
-        Compose new mail, CC,  BCC, save as draft
-        Read, reply, delete, move  and forward email
-        Email folders

Propellerads