Basic Computing (MS Office, A+, Network Basics, Internet & E-Mail)

Basic Computing (MS Office, A+, Network Basics, Internet & E-Mail)

Intended Audience:  This course is recommended for those who are interested to work on IT related jobs.

 

Prerequisites:Knowledge of Typing, experience using Windows, and a Web browser.  Students are required to have at least High School Diploma or GED along with a good knowledge of computer.

 

Schedule: Total hours: 60,  Weeks: 10

MODULE – 1: Microsoft Word

Microsoft Word -  (06 hours)

   Lesson One: Getting Familiar with Microsoft Word

  • The Microsoft Word Title Bar
  • The Microsoft Word Menu Bar
  • Microsoft Word Toolbars
  • The Ruler
  • Document View
  • Text Area
  • Exiting Microsoft Word

  Lesson Two: Things You Need to Know About Microsoft Word

  • Click
  • Options
  • Highlighting Text
  • Highlighting Menu Items
  • Placing the Cursor
  • Menu Commands Using the Alt key
  • Shortcut Notations
  • Starting a New Paragraph
  • Exiting Microsoft Word

  Lesson Three: Microsoft Word Basic Features

  • Typing and Using the Backspace Key
  • The Delete Key
  • Inserting Text
  • Overtype
  • Bold, Underline, Italicize with Microsoft Word
  • Save File and Exit Microsoft Word

  Lesson Four: More Microsoft Word Basic Features

  • Open File
  • Cut and Paste
  • Copy and paste
  • Auto Text
  • Find and Replace
  • Font Size
  • Fonts
  • Save File and Exit Microsoft Word

  Lesson Five: Working with Paragraphs

  • Space Before and Space After
  • Line Spacing
  • First-Line Indent
  • Indentation
  • Alignment
  • Hanging Indent
  • Save File and Exit Microsoft Word

  Lesson Six: Tab Key, Bulleting, Numbering, Undo, Redo,       Printing, and Help

  • The Tab Key
  • Bullets and Numbering
  • Undo & Redo
  • Save File
  • File Close
  • Open New File
  • Printing

  Lesson Seven: Microsoft Word Tables

  • Creating a Table
  • Moving Around a Table
  • Entering Text into a Table
  • Selecting a Row and Bolding the Text
  • Right-Aligning Text
  • Adding a New Row to the End of the Table
  • Adding a New Row Within the Table
  • Resizing the Columns
  • Adding a New Column to a Table
  • Sorting a Table
  • The Sum Function
  • Deleting a Column
  • Deleting a Row
  • Recalculate
  • Merge Cells
  • Table Headings
  • Converting Text to a Table
  • Splitting a Table
  • Table AutoFormat
  • Save File

  Lesson Eight: Formatting paragraphs and Working with Styles

  • Open a Blank Document
  • Add Sample Text
  • Add Space Before or After Paragraphs
  • Change Line Spacing
  • Create a First-Line Indent
  • Indent Paragraphs
  • Align Paragraphs
  • Create a Hanging Indent
  • Choose a Style Set
  • Apply a Style
  • Change Style Sets

 Lesson Nine: Adding Bullets and Numbers, Undoing and   Redoing, Setting Page Layouts and Printing Documents

  • Add Bullets and Numbers
  • Undo and Redo
  • Set the Orientation 
  • Set the Page Size
  • Set the Margins
  • Add Page Numbers
  • Insert Page Breaks
  • Interview questions and answers discussion
  • Written test
  • Oral presentation test

 

MODULE – 2: Microsoft Excel

Microsoft Excel-  (06 hours)

Lesson 1: Entering Text and Number

  •  The Microsoft Excel Window
  • Moving Quickly Around the Microsoft Excel Worksheet
  • Selecting Cells
  • Entering Data
  • Editing a Cell
  • Changing a Cell Entry
  • Wrapping Text
  • Deleting a Cell Entry
  • Entering Numbers as Labels or Values
  • Smart Tags
  • Saving a File
  • Closing Microsoft Excel

Lesson 2: Formatting Text and Performing Mathematical Calculations

  •   Choosing a Default Font
  •   Adjusting the Standard Column Width
  • Cell Alignment
  • Adding Bold, Underline, and Italic
  • Changing the Font, Font Size, and Font Color
  • Working with Long Text
  • Changing a Single Column Width
  • Moving to a New Worksheet
  • Setting the Enter Key Direction
  • Making Numeric Entries
  •   Performing Mathematical Calculations
  • The AutoSum Icon
  • Automatic Calculation
  •   Formatting Numbers
  • More Advanced Mathematical Calculations
  • Cell Addressing
  • Deleting Columns
  • Deleting Rows
  • Inserting Columns
  • Inserting Rows
  • Creating Borders
  • Merge and Center
  • Adding Background Color
  • Using Auto Format
  • Saving Your File
  • Closing Microsoft Excel

Lesson 3: Numbers and Mathematical Calculations

  • Reference Operators
  • Functions
  • Typing a Function
  • Calculating an Average
  • Calculating Min
  • Calculating Max
  • Calculating Count
  • Filling Cells Automatically
  • Printing
  • Print Preview
  • Saving Your File
  • Closing Microsoft Excel

Lesson 4: Creating Charts

  • Creating a Column Chart
  • Changing the Size and Position of a Chart
  • Modify Your Chart
  • Saving Your File
  • Closing Microsoft Excel
  • Interview questions and answers discussion
  • Written test
  • Oral Presentation test

MODULE – 3: Microsoft Access

Microsoft Access -  (06 hours)

  • Introduction to the MS Access Tutorial
  • Intended Audience
  • Pre-Requisite Knowledge
  • Brief overview of Relational Databases and Database Applications
  • A Business Example
  • Starting Microsoft Access
  • Review of Starting Microsoft Access
  • Creating and Viewing Tables
  • Creating a Table Using the Design View
  • Exercise: Creating a Table
  • Viewing and Adding Data to a Table
  • Exercise: Adding Data to a Table
  • Creating Relationships Between tables
  • Review of Creating and Viewing Tables
  • Creating and Running Queries
  • Single Table Queries
  • Exercise: Single Table Queries
  • Multiple Table Queries
  • Exercise: Multiple Table Queries
  • Review of Creating and Running Queries
  • Creating and Running a Data Entry Form
  • Creating a Single Table Form using the Wizard
  • Exercise: Creating a Single Table Form
  • Review of Creating and Running a Data Entry Form
  • Creating and Running a Report
  • Creating a Single Table Report using the wizard
  • Exercise: Creating a Single Table Report
  • Review of Creating and Running a Report
  • Summary
  • Interview questions and answers discussion
  • Written test
  • Oral presentation test

MODULE – 4: Microsoft PowerPoint

Microsoft PowerPoint -  (06 hours)

Lesson One: The Microsoft PowerPoint Screen

  • Microsoft PowerPoint Title Bar
  • Microsoft PowerPoint Menu Bar
  • Standard and Formatting Toolbars
  • Rulers
  • Placeholders
  • Status Bar
  • Outline Tab
  • Slides Tab
  • View Buttons
  • Drawing Toolbar
  • Common Tasks Buttons
  • Task Pane
  • Vertical Splitter Bar
  • Minimize Button
  • Maximize/Restore Button

Lesson Two: PowerPoint Overview

  • Create New Slides
  • Change Your Slides
  • Apply a Design Template
  • Correct Spelling
  • Sorter View
  • Run Your PowerPoint Slide Show
  • Print your Slides

Lesson Three: Creating Your First PowerPoint Presentation

  • Insert a New Slide
  • Create a Title Slide
  • Create a Hierarchy
  • Use Two-Column Text
  • Apply a Design Template
  • Outline and Slides Tab
  • Slide Sorter View
  • Run Your Slide Show
  • Print Your Outline
  • Print Your Slides
  • Print Your Slides as a Handout
  • Interview questions and answers discussion
  • Written test
  • Oral Presentation test

MODULE – 5: Microsoft Outlook

Microsoft Outlook -  (06 hours)

Manage Contacts

  • Use the Contacts Window
  • Handle Duplicate Contacts
  • Update Contact Information
  • Create a Distribution List
  • Use Different Views
  • Change the Business Card
  • Print Contact Information

Manage Time

  • Schedule an Appointment
  • Change Appointments
  • Create and Delete an Event
  • Send Meeting Requests
  • Using the Calendar Views
  • Customize Calendar Views
  • More Calendar Customization
  • Change the Time Zone
  • Print a Calendar
  • Send a Calendar as E-mail

Tasks and Notes

  • Create a Task
  • Task Options
  • Task Views
  • Create a Note
  • Link a Note
  • Organize Notes
  • Create a Shortcut
  • Create a Shortcut Grouping
  • Assign Tasks

Customizing Outlook

  • Use the Contacts Window
  • Handle Duplicate Contacts
  • Using Search Folders
  • Deleting Items in Search Folders
  • Handling E-mail with Rules
  • Manually Create a Rule
  • Change the Quick Access Toolbar
  • Manage Editor Options
  • E-mail Signatures
  • E-mail Stationary
  • Manually Add a Signature
  • Delivery Options
  • Archive E-mail
  • Archive Items Manually
  • Archive for Performance
  • Customize Printing

Outlook maintenance

  • Use the Contacts Window
  • Handle Duplicate Contacts
  • Backup Your Personal Folders File
  • Restore Your Personal Folders File
  • Repair Personal Folders File
  • Deleted Items Folder
  • Retrieve Deleted Items
  • Use Other Data Files
  • Export Contacts
  • Import Contacts
  • Send/Receive Groups
  • Message Headers

INTERNET & EMAIL

Understanding the World Wide Web

  •  A discussion of Web basics, including links, major Web protocols, the makeup of URLs, and Web programming

Multimedia on the Web

  • A guide to the multimedia phenomenon

The Web and Your

  • A guide to the social Web and how you can participate SEARCH TOOLS

How to Choose a Search Engine or Directory

  • A chart listing numerous features and the search engines & directories that support them

The World of Search Engines

  • Covers search engine basics, general search engines
  • Choose a Google search engine and learn how it works
  • Google Maps - street maps or satellite maps, directions and business search, they even have traffic information for some cities

SEARCH TECHNIQUES

  • Boolean Searching on the Internet
  • The principles of Boolean search logic and the manifestations of this logic on Web search engines
  • Basic Search Techniques
  • A basic how-to guide for creating AND, OR, NOT, phrase, and field searches

FINDING CONTENT

  • Finding Scholarly Content on the Web
  • Tips on finding high quality content for your research
  • Keeping Current
  • A brief guide to keeping up with the latest happenings on the Web

What is Email?

  • Create a free e-mail account using Yahoo, Gmail, Hotmail.
  • Reading messages
  • Sending messages with file attachment

E-Mail Etiquette

  • Clearly summarize your message in the subject line.
  • Don't use the CC (Carbon Copy) function to copy your message to everyone.
  • Use BCCs (Blind Carbon Copies) when addressing a message that will go to a large group of people who don't necessarily know each other.
  • Avoid using all capital letters.

E-Mail Viruses

  • how to protect?

Facebook

  • Create a free account using Facebook
  • Post, view pictures in the Facebook
  • Interview questions and answers discussion
  • Written test
  • Oral Presentation test

Course Instructor