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
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech