Basic Computer Courses:PeopleNTech

Basic Computer Courses

About The Course


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.

Schedule: 

Total hours: 96

Module 1 : Microsoft Word - 2 Weeks (28 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, and 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
  • AutoText
  • Spell Check
  • 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
  • Preview and Print Documents
  • Interview questions and answers discussion
  • Written test
  • Oral presentation test

Module 2 : Microsoft Excel- 1 Week (14 hours)

Lesson 1: Entering Text and Numbers

  • 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
  • he 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 - 1 Week (14 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 - 1 Week(14 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
  • Close 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

  • Create a Title Slide
  • Insert a New 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 - 1 Week(14 hours)

Manage Contact

  • 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

 

Task 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

 

Optimizing Outlook 2007

 

  • 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
  • Interview questions and answers discussion
  • Written test
  • Oral presentation test

Module 6 : Internet & Email (12 hours)

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 You

  • 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

 

Email 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.

 

Email 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

Module 7: A+ - 1 Week (14 hours)

Personal Computer Components

  • Personal Computer Components
  • System Unit Components
  • Storage Devices
  • Personal Computer Connection Methods

Operating System Fundamentals

  • Personal Computer Operating Systems
  • Windows User Interface Components
  • Windows File System Management
  • Windows System Management Tools

PC Technician Professional Best Practices

  • Tools of the Trade
  • Electrical Safety
  • Environmental Safety and Materials Handling
  • Perform Preventative Maintenance
  • Diagnostics and Troubleshooting
  • Professionalism and Communication

Installing and Configuring Peripheral Components

  • Install and Configure Display Devices
  • Install and Configure Input Devices
  • Install and Configure Adapter Cards
  • Install and Configure Multimedia Devices

Installing and Configuring System Components

  • Install and Configure Storage Devices
  • Install and Configure Power Supplies
  • Install and Configure Memory
  • Install and Configure CPUs
  • Install and Configure System Boards

Maintaining and Troubleshooting Peripheral Components

  • Troubleshoot Display Devices
  • Maintain and Troubleshoot Input Devices
  • Troubleshoot Adapter Cards
  • Troubleshoot Multimedia Devices

Troubleshooting System Components

  • Troubleshoot Storage Devices
  • Troubleshoot Power Supplies
  • Troubleshoot Memory
  • Troubleshoot CPUs
  • Troubleshoot System Boards

Installing and Configuring Operating Systems

  • Install Microsoft Windows
  • Upgrade Windows
  • Add Devices to Windows
  • Optimize Windows

Maintaining and Troubleshooting Microsoft Windows

  • Operating System Utilities
  • Maintain Windows
  • Troubleshoot Windows
  • Recover Microsoft Windows

Network Technologies

  • Network Concepts
  • Network Communications
  • Network Connectivity
  • Internet Technologies

Installing and Managing Network Connections

  • Create Network Connections
  • Install and Configure Web Browsers
  • Maintain and Troubleshoot Network Connections

Supporting Laptops and Portable Computing Devices

  • Laptop and Portable Computing Device Components
  • Install and Configure Laptops and Portable Computing Devices
  • Maintain and Troubleshoot Laptops and Portable Computing Devices

Supporting Printers and Scanners

  • Printer and Scanner Technologies
  • Printer and Scanner Components
  • Printing and Scanning Processes
  • Install and Configure Printers and Scanners
  • Maintain and Troubleshoot Printers and Scanners

Personal Computer Security Concepts

  • Security Fundamentals
  • Security Protection Measures
  • Data and Physical Security
  • Wireless Security
  • Social Engineering

Supporting Personal Computer Security

  • Install and Configure Security Measures
  • Maintain and Troubleshoot Security Measure

Step By Step Instructions to Build a Computer

  • Getting Started
  • A List of Everything you Will Need
  • Choosing Your Parts and Operating System
  • Your Workspace
  • Preparing the Case
  • Power Supply Installation
  • Preparing the Motherboard
  • CPU and Heat sink Installation
  • Memory Installation
  • Motherboard Installation
  • Connect Case Cables to Motherboard
  • Install Video Card
  • Connect Power Supply to Motherboard
  • Quick Power up Test
  • Install the Hard Drive and Floppy Drive
  • Install CD-Rom and/or DVD Drive
  • Connect Internal Cables
  • Connect External Cables
  • First Boot
  • BIOS Setup
  • Preparing the Hard Drive for the OS
  • Install the Operating System
  • Update Drivers
  • Recommendations After You Are Done
  • Troubleshooting Your New Computer
  • Interview questions and answers discussion
  • Written test
  • Oral presentation test

Module 8: Network Basics - 1 Week (14 hours)

Describe the purpose of networking protocols and networking in general

Identify features of various network operating systems and the clients used to access them.

Describe the OSI networking model and its relationship to networking components.

Describe the network components relating to the Physical layer of the OSI model.

Describe the function of the Data Link layer of the OSI model.

Explain how data is transmitted over a network.

Describe the function of the Network layer of the OSI model.

Describe the function of the Transport layer of the OSI model.

Describe the function of the Session layer of the OSI model.

Explain the fundamental concepts of the TCP/IP protocol suite.

Explain the use of TCP/IP addresses and subnets.

Access and use a TCP/IP network.

Describe the requirements for remote network access.

Explain the need for and ways to implement network security and fault tolerance.

Describe the types of information that need to be gathered prior to installing or updating a network operating system.

Explain ways to monitor and manage a network.

Describe a systematic approach for troubleshooting network problems.

Course Outline

  • Basic Network Knowledge
  • Network and Internetwork Concepts
  • Network Topologies
  • Networking Strategies

Servers and Clients

  1. Network Operating System Basics
  2. Network Clients
  3. Directory Services

Introduction to the OSI Model

  • Introduction to the OSI Model
  • Families of Protocols

The Physical Media

  • Data-transmission Media
  • Unbounded Media
  • Signaling
  • Signal Transmissions

The Data Link Layer

  • Data Link Layer Considerations
  • Media Access Control (MAC) and Logical Link Control (LLC)
  • IEEE 802 Specifications

Data Transmission

  • Introduction to Network Connection Devices
  • Network Adapters
  • Putting Data on the Cable
  • Network Topologies
  • Bridges

The Network Layer

  • Addresses
  • Internet work Connection Devices
  • Routers

The Transport Layer

  • Transport Layer Addressing Issues
  • The Transport Layer Segmenting Process
  • Transport Layer Connection Services

The Session Layer

  • Dialog Control Modes
  • Managing the Session

TCP/IP Fundamentals

  • What is TCP/IP?
  • The TCP/IP Protocol Suite

IP Addressing, Subnetting and Supernetting

  • IP Addressing
  • Interior Gateway Protocols
  • Introduction to Subnetting
  • Supernetting

Accessing and Using a TCP/IP Network

  • Configuring Clients for TCP/IP Networks
  • TCP/IP Suite Utilities
  • Using TCP/IP Suite Utilities to Check Network Connectivity

Remote Access Protocols

  • Remote Access Protocols
  • Examining Remote Connection Options
  • Dial-up Networking

Network Security and Fault Tolerance

  1. Security Models
  2. Password Security
  3. Data Encryption
  4. Firewalls and Proxy Servers
  5. System Fault Tolerance
  6. Backing Up Data

Preparing for Network Installation

  • Planning and Gathering Information
  • Environmental Issues
  • Networking Components and Connectors
  • Compatibility Issues

Maintaining the Network

  • Network Documentation
  • Backup Strategies
  • Virus Protection
  • Patches and other Software Updates

Troubleshooting the Network

  • Exploring Troubleshooting Models
  • Identifying Troubleshooting Tools

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