COURSE DESCRIPTION


This is a class for beginning computer users. You are only expected to know how to use the mouse and keyboard, open a program, and turn the computer on and off. You should also be familiar with the Microsoft Windows operating system.

word

Microsoft Word is an example of a program called a “word processor.” Word processors are used to create and print text documents in much the same way that you would use a typewriter. The key benefit to using a word processor is that you can make changes easily, including correcting spelling; adding, deleting, formatting, and relocating text; and inserting images. Once you create a document, you can effortlessly print it (as many copies as you want!), save it for later modifications, or send it to a friend via e-mail. Microsoft Word is a very powerful word processor—This handout was created using just a small number of its features!


SYLLABUS :


Get Started with Microsoft Word :

  • How to Open Microsoft Word
  • Finding Your Way Around
  • Typing Your First Letter
  • How to Save Your Work
  • Highlighting Techniques
  • Opening Word Documents
  • Add an Address To A Letter
  • Spelling and Grammar Checking

Document Formatting :

  • Crime Statistics Document
  • Bold Text
  • Italics and Underline
  • Setting Tab Stop Positions
  • Creating Bulleted Lists
  • Working With Fonts
  • Setting Up Page Margins

Copy and Paste & Clip Art :

  • Techniques for Cutting Text
  • Cut and Paste Techniques
  • Inserting Clip art
  • Copy and Paste Techniques
  • How to Resize and Move Clip Art

Multi-Page Documents :

  • Downloading a Text File
  • Setting Up Page Margings and Tab Stops
  • How to Insert a Text File
  • Setting Up Headers and Footers
  • Print Preview in Word 2013

How to Create a Booklet :

  • Downloading the Stories
  • Creating Your Own Word Style
  • Page Breaks And Section Breaks
  • Adding a Cover Page
  • Adding a Contents Page
  • Working With Section Breaks
  • Headers And Section Breaks

Word Shapes :

  • Word Shapes - Create a Logo
  • Logo Continued
  • Word Art
  • Completing The Logo

Letterheads and Templates & Mail Merge :

  • Create a Letterhead
  • Adding Columns to a Page
  • Create a Mail Merge Data Source
  • Saving Word Documents as a Template
  • Create a Mail Merge Letter

Microsoft Word Tables / Document Collaborationl / Word Options :

  • Tables in Microsoft Word
  • Document Collaboration
  • Displaying The Word Options
  • Changing The Language Settings
  • Proofing Options
  • Table Styles
  • Accepting and Rejecting Changes
  • Advanced Options
  • The Quick Access Toolbar
  • Keyboard Shortcuts


Microsoft Excel :

excel

This is a class for beginning computer users. You are only expected to know how to use the mouse and keyboard, open a program, and turn the computer on and off. You should also be familiar with the Microsoft Windows operating system.

SYLLABUS :


Make a Start with Excel :

  • A first look at Excel 2010
  • Excel Rows and Columns
  • Enter text and numbers in a Cell
  • How to Edit text in a Cell
  • How to Centre text and numbers
  • Font Formatting in Excel 2010
  • How to change the colour of a Cell
  • How to Save your work in Excel
  • Currency Symbols in Excel 2010
  • How to Merge Cells
  • Review Number One

A more complex spreadsheet :

  • Introduction to Section Two
  • How to use AutoFill in Excel 2010
  • Entering Simple Addition Formula
  • The SUM Function in Excel
  • The SUM Function Continued
  • Copy and Paste
  • How to use Paste Special
  • How to Multiply in Excel 2010
  • Finishing your spreadsheet for this section
  • How to Add a Comment to a Cell
  • Review Number Two

Excel 2010 Charts :

  • How to Sort Data in Excel
  • Create an Excel Chart
  • Move and Resize your Chart
  • Chart Styles and Layouts
  • Chart Titles and Series Titles
  • Chart Layout Panel in Excel 2010
  • The Format Chart Panel
  • Create a Pie Chart in Excel
  • Add Labels to a Pie Chart
  • Format Pie Chart Segments
  • Create a 2D Line Chart in Excel
  • Format your Axis Titles
  • Predict the future with a Trendline Chart
  • Sparkline Charts

Formulas in Excel 2010 :

  • The SUM Function
  • How to Multiply in Excel
  • Subtract and Divide
  • Combining the Arithmetic Operators
  • A Budget Spreadsheet

Functions in Excel 2010 :

  • The Average Function
  • The Date Function
  • Time Functions in Excel
  • A TimeTable Project
  • Financial Functions
  • The Student Averages Project

Conditional Logic in Excel :

  • The IF Function
  • Conditional Formatting in Excel 2010
  • CountIF
  • SumIF

Processing Data in Excel :

  • Data Tables in Excel 2010
  • A Second Data Table
  • Excel Scenarios
  • Goal Seek
  • Absolute Cell References
  • Named Ranges in Excel 2013
  • Create a Custom Name in Excel
  • Excel Pivot Tables
  • Pivot Tables, Part Two
  • Reference other Worksheets
  • The LOOKUP Function
  • The VLOOKUP Function in Excel
  • Create a Business Invoice, Part One
  • Excel Business Invoice, Part Two
  • Business Invoice, Part Three


Microsoft Power Point :

power point

This lesson introduces you to the basic features of PowerPoint which are particularly valuable in the teaching and learning environment. You will learn how to use PowerPoint to capture your ideas in outline form and convert those ideas into multimedia presentations. You will also learn how to use the application to create your own presentations both from scratch and with the help of one of the PowerPoint Wizards.

Most people think of a slide show as a way of presenting a series of still images or photographs using a slide projector. If you think about it, however, a slide does not have to be a still image; using PowerPoint it can also be an audio or video clip. For that matter, a slide does not have to be even a picture; it can also be text, an outline of ideas, whatever you want.
PowerPoint provides an easy-to-use multimedia presentation production system, which you will no doubt enjoy learning and which you and your students will find useful for individual or group projects of all kinds. In the various courses that

SYLLABUS :


Foundation:

  • The PowerPoint Interface
  • Getting Started
  • Terminology and Overview
  • Templates and Slide Masters
  • Principles of Slide Design

Basic Slide Editing :

  • SmartArt
  • Drawing Shapes and Lines
  • Text Boxes
  • Aligning Objects
  • Tips and Shortcuts

Administration and Efficiency :

  • Editing and Working Collaboratively
  • Printing and Other Output
  • Customising PowerPoint
  • Housekeeping

Communicating Analysis :

  • Tables
  • Graphs & Charts - How
  • Graphs & Charts - When and Why
  • Making a Presentation Flow
  • Slide-type Toolkit

Making an Impact :

  • Incorporating Images
  • Transitions and Animation
  • Presenting Your Slides
  • What Not To Do