General knowledge about Computer

• Hardware
• Software
• Install and Uninstall Software
• Control Panel, System Property, Services, Process
• Typing Method

Operating System

• Definition
• Function
• Evolution of OS

Microsoft word

The Microsoft Word 2013 screen

• Starting Microsoft Word 2013
• The Microsoft Word 2013 opening screen
• To create a new blank document
• The levels of command organization
• The file tab
• Ribbon tabs
• Groups
• Dialog box launcher

Starting to use Microsoft Word 2013

• Using the default Microsoft Word document
• Saving Microsoft Word documents
• Opening and closing documents
• Save as
• Creating a new, blank document using a keyboard shortcut
• Using help within Microsoft Word
• Alt key help
• Closing Microsoft Word

Using templates to create documents

• Creating new documents using different templates
• Using online templates

Manipulating text

• Select, then format
• Selecting text
• Inserting, deleting, undo and redo
• Insert and overtype mode
• Copying text within a document
• Moving (cutting) text within a document

Pining files and folders and opening documents

• Pinning
• Recently open documents
• Viewing a document where you left off

Microsoft Word 2013 text formatting

• What is text formatting?
• Font type
• Font size
• Decrease and increase font size icons
• Font size keyboard shortcut
• Bold, italic and underline
• Subscript and superscript
• Case changing
• Highlighting
• Font colour
• Copying text formatting
• Removing formatting
• Using zoom
• Inserting special characters and symbols

Microsoft Word 2013 paragraph formatting

• Paragraph marks
• Soft paragraph (line break) marks
• Recommended techniques for aligning and indenting text
• Aligning text
• Indenting paragraphs
• Applying single or double line spacing within paragraphs
• Applying spacing above or below paragraphs
• Using paragraph spacing rather than using the return key
• Applying bullets to a list
• Applying numbering a list
• Modifying bullet and numbering formatting
• Removing bullet or numbering formatting

Borders and shading within Microsoft Word 2013

• Using borders and shading
• Adding a border
• Modifying borders
• Adding shading
• Modifying your shading
• Applying borders to selected text

Tabs

• Tab stops
• Displaying the ruler
• Setting and removing tabs using the ruler
• Viewing tab marks using the show/hide icon

Microsoft Word 2013 styles

• What are styles?
• Applying styles

Using Word 2013 design themes

• Applying a theme colour
• Apply a customised font

Microsoft Word 2013 page formatting

• What is page formatting?
• Page orientation and paper size
• Changing the page size
• Page margins
• Inserting page breaks
• Deleting page breaks
• Use page breaks rather than repeatedly pressing the return key
• Headers and footers
• Easy header and footer creation
• Page numbering
• Header and footer fields
• Editing text within a header or footer
• Cover pages
• Applying automatic hyphenation

Word 2013 views and document navigation

• Switching between Word views
• Using the zoom tool
• Navigating through documents

Tables

• Using tables
• Inserting a table
• Navigating within a table
• Selecting and editing text within a table
• Selecting cells, rows, columns or the entire table
• Inserting and deleting rows and columns
• Modifying column width or row height
• Modifying the table width
• Modifying table styles

Using illustrations within Microsoft Word

• Types of illustrations that you can insert within Word 2013
• Inserting pictures
• Inserting online pictures
• Inserting shapes
• Inserting SmartArt
• Inserting a chart
• Modifying the chart type
• Modifying the chart style
• Modifying the chart data
• Inserting a screenshot
• Selecting, resizing and deleting illustrations
• Copying or moving graphics

Finding and replacing text within a Microsoft 2013 document

• Using find and replace
• Finding text
• Replacing text

Using multiple open documents

• Multitasking with Word 2013
• Switching between open documents
• Tiling or cascading documents on your screen
• Comparing documents side by side
• Copying or moving selected items between documents

Microsoft Word 2013 mail merge

• What is mail merging?
• Starting the mail merge wizard
• Mail merge wizard – step 1 of 6 ‘select document type’
• Mail merge wizard – step 2 of 6 ‘select starting document’
• Mail merge wizard – step 3 of 6 ‘select recipients’
• Mail merge wizard – step 4 of 6 ‘write your letter’
• Mail merge wizard – step 5 of 6: previewing your letters
• Mail merge wizard – step 6 of 6 printing options
• Creating a mailing list to be used within a mail merge
• Merging a mailing list to produce labels

Microsoft Excel

Getting started with Excel 2013

• Starting Excel 2013 using windows 7 (or previous versions)
• Selecting the blank worksheet template
• The Excel 2013 cell referencing system
• Entering numbers and text
• Default text and number alignment
• Summing a column of numbers
• Entering a date
• Worksheets and workbooks
• Saving a workbook to your hard disk
• Closing a workbook
• Creating a new workbook
• Opening a workbook
• Opening a recently used workbook
• Pinning files and folders
• Switching between workbooks
• Saving a workbook using another name
• Saving a workbook using a different file type
• Getting help within Excel 2013
• Searching for help
• The help ‘table of contents’
• Printing a help topic
• Alt key help
• Using other Excel templates

Excel 2013 selection techniques

• Why are selection techniques important?
• Selecting a cell
• Selecting a range of connecting cells
• Selecting a range of non-connecting cells
• Selecting the entire worksheet
• Selecting a row
• Selecting a range of connecting rows
• Selecting a range of non-connected rows
• Selecting a column
• Selecting a range of connecting columns
• Selecting a range of non-connecting columns
• Recommended techniques when creating or editing lists

Manipulating rows and columns within Excel 2013

• Inserting rows into a worksheet
• Inserting columns into a worksheet
• Deleting rows within a worksheet
• Deleting columns within a worksheet
• Modifying column widths
• Modifying column widths using ‘drag and drop’
• Automatically resizing the column width to fit contents
• Modifying row heights

Manipulating cells and cell content within Excel 2013

• Copying a cell or range contents within a workbook
• Deleting cell contents
• Moving the contents of a cell or range within a workbook
• Editing cell content
• Undo and redo
• Copying data between worksheets (within the same workbook)
• Moving data between worksheets (within the same workbook)
• Moving data worksheets (between different workbooks)
• Copying data between worksheets (in different workbooks)
• AutoFill
• Copying a data range using AutoFill
• Sorting a cell range
• Searching and replacing data

Excel 2013 worksheets

• Switching between worksheets
• Renaming a worksheet
• Recommended techniques with naming worksheets
• Inserting a new worksheet
• Deleting a worksheet
• Copying a worksheet within a workbook
• Moving a worksheet within a workbook
• Copying or moving worksheets between workbooks

Font formatting within Excel 2013

• Font formatting options
• Font type
• Font size
• Bold, italic, underline formatting
• Cell border formatting
• Formatting the background colour
• Formatting the font colour

Alignment formatting within Excel 2013

• Horizontally aligning contents in a cell range
• Centring a title over a cell range
• Cell orientation
• Text wrapping within a cell
• Aligning cell contents vertically
• Format painter

Number formatting within Excel 2013

• Number formatting
• Decimal point display
• Applying and removing comma style formatting (to indicate thousands)
• Currency symbol
• Date styles
• Percentages

Freezing row and column titles within Excel 2013

• Freezing row and column titles

Excel 2013 formulas

• Creating formulas
• The easy way to create formulas
• Copying formulas
• Operators
• Using operators in formulas
• Formula error messages
• Relative cell referencing within formulas
• Absolute cell referencing within formulas

Excel 2013 functions

• What are functions?
• Common functions
• Sum function
• Average function
• Max function
• Min function
• Count function
• The counta function
• The countblank function
• What are ‘if functions’?
• Using the if function

Excel 2013 charts

• Inserting a column chart
• Inserting a line chart
• Inserting a bar chart
• Inserting a pie chart
• Resizing a chart
• Deleting a chart
• Chart title or labels
• Changing the column, bar, line or pie slice colours in a chart
• Modifying the legend fill colour
• Changing the chart type
• Modifying charts using the layout tab
• Copying and moving charts within a worksheet
• Copying and moving charts between worksheets
• Copying and moving charts between workbooks

Microsoft Power Point

Using PowerPoint 2013

• Opening PowerPoint 2013
• Opening a presentation
• Navigating between slides
• Using the zoom tool
• Changing PowerPoint views
• Using help
• Searching for help
• Using the help table of contents
• Saving a presentation
• Closing a presentation
• Closing PowerPoint
• Opening multiple presentations
• Switching between multiple presentations

Creating a PowerPoint 2013 presentation

• Creating a new presentation
• Inserting a new slide
• Recommended techniques when creating slide content
• Undo and redo
• Saving a presentation
• Saving a presentation using a different name

Manipulating slides within PowerPoint 2013

• Inserting slides with a particular slide layout
• Modifying the slide layout
• Changing the background colour on the active slide
• Changing background colour on all the slides within a presentation

PowerPoint 2013 design themes

• Applying a theme to a presentation
• Modifying the theme colours
• Modifying the theme fonts

Text boxes

• Editing text boxes (placeholders)
• Resizing a text box (placeholder)
• Moving a text box (placeholder)

Manipulating text in PowerPoint 2013

• Selecting text
• Moving text within a slide
• Moving text between slides within a presentation or between presentations
• Copying text within a slide
• Copying text between slides within a presentation or between presentations
• Deleting text
• Using find
• Using replace

Font formatting within PowerPoint 2013

• Font formatting options
• Changing the font type
• Changing font size
• Increasing or decreasing the font size
• Bold, italic or underline formatting
• Strikethrough effects
• Shadow effects
• Character spacing
• Changing case
• Font colour
• Clearing all text formatting

Paragraph formatting within PowerPoint 2013

• Text alignment
• Columns
• Modifying bullet point formatting
• Using numbering instead of bullet points
• Changing the list level
• Indenting bulleted text
• Line spacing vs. Paragraph spacing
• Line spacing
• Paragraph spacing
• Using outline view
• PowerPoint presenter notes
• Text direction
• Text alignment within a text box (placeholder)
• Text AutoFit
• Using the format painter

Tables and PowerPoint 2013

• Table selection techniques
• Column selection
• Row selection
• Entire table selection
• Creating a table
• Applying a style to a table
• Cell background shading
• Applying table effects
• Adding ‘quick styles’ to selected text
• Applying borders to cells
• Deleting a column
• Deleting a row
• Inserting rows or columns
• Modifying column width and row height
• Distributing rows and columns

PowerPoint 2013 & illustrations

• Selecting an illustration
• Selecting multiple illustrations
• Moving an illustration
• Copying an illustration
• Deleting an illustration
• Resizing an illustration
• Stretching an illustration
• Copying illustrations between presentations
• Moving illustrations between presentations
• Inserting illustrations within PowerPoint
• Inserting pictures from your hard disk
• Inserting online pictures or clip art
• Inserting shapes
• Inserting text into a shape
• Inserting perfect circles or perfect squares
• Inserting a line
• Inserting a free drawn line
• Inserting an arrow
• Inserting a text box
• Inserting SmartArt

Manipulating illustrations within PowerPoint 2013

• Formatting the shape background fill colour style
• Applying a shadow to an illustration
• Modifying arrow line shapes and size
• Rotating or flipping an illustration
• Rotating illustrations by dragging with the mouse
• Layering illustrations to the front or back
• Aligning graphics relative to each other or relative to the slide
• Aligning shapes relative to the left of a slide
• Aligning shapes relative to the centre of a slide
• Aligning shapes relative to the right of a slide
• Aligning shapes relative to the top of a slide
• Aligning shapes relative to the bottom of a slide
• Grouping and ungrouping objects

Charts in PowerPoint 2013

• Inserting charts and editing the chart data
• Changing the chart type
• Changing the background colour in the chart
• Changing the column, bar, line or pie slice colours in the chart
• Chart title manipulation
• Adding data labels to a chart

Manipulating slides within PowerPoint 2013

• Moving slides within a presentation or between presentations
• Copying slides within a presentation
• Deleting a slide or slides
• Copying slides between presentations
• Moving slides between presentations

PowerPoint 2013 slide masters

• What is a slide master?
• Inserting a picture (clipart) into a master slide
• Removing a picture or shape from a master slide

Headers, footers and slide numbering

• Creating a footer
• Automatic slide numbering
• Inserting dates into the footer

PowerPoint 2013 slide shows

• Running a slide show
• Adding slide show transition effects
• Removing transition effects
• Adding slide show animation effects
• Modifying slide show animation effects
• Removing animation effects
• Hiding slides
• Displaying hidden slides within a slide show

Video creation using PowerPoint 2013

• Inserting hyperlinks into slides
• Converting a PowerPoint presentation into a video
• Uploading a video to YouTube

Printing and proofing in PowerPoint 2013

• Spell-checking a presentation
• Using portrait or landscape slide orientation
• Switching between standard and widescreen formats
• Selecting your output format
• Visually inspect each slide before printing
• Printing options
• Setting the number of copies to print
• Selecting a different printer
• Printing selected slides
• Setting the number of slides per page to be printed
• Single or double sided (duplex) printing
• To print a presentation

Microsoft Access

ACCESS 2013 DATABASE CONCEPTS

• What is a database?
• Database examples
• What is a relational database?
• What is a table?
• What is a record (row)?
• What is a field (column)?
• What is data?
• The difference between data and information
• Data types
• Common uses of large-scale databases
• Keeping data discrete
• Each field should contain only one item
• Database designers, database administrators and database users

OPENING A DATABASE & SECURITY ISSUES

• Opening a database within your samples folder
• Trusted locations – using the trust centre
• Setting the default folder location within Access

ACCESS 2013 TABLES, FIELDS AND FIELD TYPES

• Creating a new blank database
• Adding fields and setting the field type
• About Access data types
• Closing and naming a table

ACCESS 2013 TABLE NAVIGATION & MODIFICATION

• Opening a table within a database
• Switching between ‘datasheet view’ and ‘design view’
• Adding records to a table
• Saving the changes made to a table
• Navigating through records within a table
• Adjusting the column width
• Automatically resizing a column width to fit contents
• Moving a column to rearrange the column order

ACCESS 2013 FIELD PROPERTIES

• Field properties
• Input masks
• Validating numbers
• Validating dates
• Data entry required / not required
• Field properties – reference materials
• Field properties – logical operators
• Field properties – validation rule examples
• Field properties – general
• Field properties – format
• Field properties – input mask characters
• Field properties – input mask examples

MANIPULATING TABLES & RECORDS IN ACCESS 2013

• Renaming a table
• Editing data within a record
• Deleting data within a record
• Using the undo command
• Deleting a single record
• Deleting multiple records
• Using save as to back up the database using a different file name
• Deleting a table

ACCESS 2013 PRIMARY KEYS & INDEXING

• Defining a primary key
• Indexing – reference notes
• Creating a single-field index
• Creating a multiple-field index
• Deleting multi-field indexes

FILTERING WITHIN ACCESS 2013

• Text filters
• Applying a single filter
• Clearing a single filter
• Creating multiple filters
• Clearing multiple filters

SORTING WITHIN ACCESS 2013

• Sorting records a-z
• Sorting records z-a
• Removing a sort
• Sorting on multiple fields

SEARCHING WITHIN ACCESS 2013

• Searching through records
• Access 2013 relationships
• Table relationships
• One-to-many relationship
• Many-to-many relationship
• One-to-one relationships
• Creating relationships between tables
• About referential integrity
• Enabling referential integrity
• Cascade options
• Cascade update related fields
• Cascade delete related records
• Enabling cascade options
• Deleting relationships

ACCESS 2013 FORMS

• Forms overview
• Creating forms
• Modifying forms
• Modifying a form title
• Changing a form logo
• Modifying a form label
• Saving a form
• Form view
• Adding and formatting attachments
• Modifying data within records
• Deleting records using a form
• Adding records using a form
• Adding or deleting text in a record using a form
• Closing forms
• Opening forms
• Deleting a form
• Filtering a form
• Removing a filter from a form
• Inserting and modifying a form header
• Inserting and modifying a form footer

Microsoft Outlook

A FIRST LOOK AT OUTLOOK 2013

• Starting outlook 2013
• The Microsoft outlook 2013 screen
• Help in outlook 2013
• Printing help sheets
• Microsoft outlook navigation pane
• Microsoft outlook ribbon
• Closing outlook

TERMINOLOGY & CONCEPTS

• What is email?
• The structure of an email address
• The advantages of using email
• SMS (Short Message Service)
• Voice over internet protocol (VOIP)
• Instant messaging
• Online (virtual) communities
• Social networking websites
• Internet forums
• Chat rooms
• Online computer games

SECURITY ISSUES

• Spam
• Viruses
• Phishing
• Digital signatures

SENDING MESSAGES

• Creating and sending your first email
• Checking that your email was sent
• Sending emails to more than one person
• Receiving and reading emails
• Sending a copy of a message to another address
• What is a blind carbon copy?
• Sending a copy of a message to another address using blind carbon copy (bcc)
• Think about the message subject – short and descriptive
• Spell checking your messages
• Attaching a file to a message
• Deleting an attached file
• Issues when sending file attachments
• Setting message importance
• Setting message sensitivity
• Saving a draft copy of an email

RECEIVING, READING AND REPLYING TO MESSAGES

• The inbox folder
• Opening the inbox folder
• The inbox screen
• Selecting a message
• Reading a message
• Switching between open message windows
• Forwarding a message
• Opening or saving an attached file
• Replying to the sender of a message
• Replying to the sender and all recipients of a message
• Setting message reply options so that the original message is inserted, or not inserted
• Printing a message
• Printing options

MANIPULATING TEXT AND FILES

• Selecting a word within the message window
• Selecting a line within the message window
• Selecting a paragraph within the message window
• Selecting all text within the message window
• Selecting text using the mouse
• Copying text to the clipboard from a message
• Pasting text from the clipboard into a message
• Copying text from one message to another
• Cutting text to the clipboard from a message
• Moving text from one message to another
• Deleting text in a message
• Deleting text to the left of the insertion point
• Deleting text to the right of the insertion point

PEOPLE AND CONTACTS

• What are people contacts?
• Opening the people folder
• Creating a contact
• Adding the sender of a message to your contacts list
• Addressing an email to a contact
• Deleting a contact
• What is a contact group?
• Creating a new contact group
• Adding an email address to a customised contact group
• Removing an email address from a contact list
• Sending an email to an entire contact group list

ORGANISING MAIL

• Searching for a particular email message
• Searching for messages by sender, subject or content
• Creating a new mail folder
• Moving a message to a different folder
• Deleting a mail folder
• Sorting the contents of the inbox
• Deleting a message
• Opening the ‘deleted items’ folder
• Restoring a message from the ‘deleted items’ folder
• Emptying the ‘deleted items’ folder
• Automatically emptying the ‘deleted items’ folder when you exit outlook
• Flagging a message
• Removing a flag mark from a mail message
• Marking a message as unread
• Marking a message as read

Microsoft Publisher

MICROSOFT PUBLISHER 2013

• Opening Publisher 2013
• The Publisher 2013 window
• Closing Publisher
• Where to save files to

 CREATING A PUBLICATION

• Selecting a publication type and template
• Searching for online templates
• Opening an existing publication
• Using colour schemes
• Modifying the font scheme

TEXT FORMATTING

• Creating a text box and entering text
• Selecting text
• Modifying font colour & fonts
• Modifying line spacing
• Modifying text alignment
• Inserting drop caps
• Creating a custom drop down cap style
• Inserting symbols
• Inserting the date and time
• Using the format painter
• Using undo and redo
• Using kerning, tracking & scaling
• Inserting bullets & numbers
• Text AutoFit

 PAGE FORMATTING

• Inserting pages
• Moving pages
• Deleting pages
• Inserting page numbers
• Inserting sections
• Inserting headers and footers

PICTURES

• Inserting an online picture
• Inserting a picture from a file
• The picture tools format tab
• Inserting AutoShapes
• Modifying AutoShape properties
• Grouping and ungrouping AutoShapes
• Rotating and flipping AutoShapes
• Inserting a WordArt object
• Modifying WordArt properties

ARRANGING OBJECTS

• Displaying the rulers
• The horizontal and vertical guides
• The layout guides dialog box
• Baseline guides
• Grid guides
• Margin guides
• Align commands
• Distribute commands
• Nudge commands

PERSONALISING THE PUBLICATION

• Customizing the background
• Applying a colour scheme
• Creating a customised colour scheme
• Deleting a colour scheme that you have created
• Applying, creating & deleting a font scheme
• Inserting information into a publication
• Creating a new business information set
• Editing your business information

TABLES

• Inserting tables
• Selecting tables
• Merging & splitting cells
• Deleting tables
• Using table AutoFormat
• Format table dialog box options

TEXT BOXES

• Inserting a text box
• Moving a text box
• Modifying text box direction
• Resizing a text box
• Text fit
• Deleting a text box

MASTER PAGES

• Master pages
• Creating, editing & applying master pages

PUBLISHER CUSTOMISATION OPTIONS

• AutoRecover options
• AutoCorrect options
• Spelling options

PROOFING & PRINTING

• Spell checking a publication
• Print preview & zoom
• The design checker
• Printing options
• Packing a publication options

Scanning & Printing

• Scan required document
• Setting the pixel of scanned image
• Setting the default location for storage
• Printing the document
• Photocopy the required document

Surfing Internet

• Introduction to the WWW
• Concept of Cloud Storage and Servers
• How to find the required material in web
• Search engine working mechanism

Basic Webpage Designing

• Introduction to HTML
• Basic HTML Tags
• Working with fonts
• Display images in your web page
• Hyperlink the internal and external link