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