Enriching Lives Through Technology
 
 
 
about us
membership
computer training
certification testing
cyberyouth program
techworks
volunteer
donation
resource room
photo gallery
job openings

• course schedule • course descriptions • testimonials • registration •

bullet

Introduction To The PC

bullet

Practical Word-Processing

bullet

Introduction To The PC - Spanish

bullet

Spreadsheets with Excel

bullet

PC Repair

bullet

Microsoft Outlook

Introduction To The PC

This is a Beginner Level Course designed for people who have never used a computer or have limited experience with a computer. This course familiarizes students with the computer and helps students overcome their fear and anxiety of this useful technology.

We work with Personal Computers, running Microsoft’s Windows XP Operating System. We also use  Microsoft Office 2003.

To take this course you must only show up for class on time and come with an open mind, a desire to learn and and a willingness to have fun!

In this class, we will:

bullet

Look inside a computer and learn about different storage devices

bullet

Become expert as using a mouse (pointing, clicking, highlighting)

bullet

Understand what a “window” is and how to use it

bullet

Learn about our desktop and different ways to personalize it (that is why they are called Personal  computers!)

bullet

Create files and folders

bullet

Open an email account and learn how to reply to a message, compose a new message and send a message

bullet

Search on the Internet using Search Engines (we will do a Scavenger Hunt!)

bullet

Learn Basic Word Processing, opening a file, saving a file, formatting text and editing text.

By the end of the class:

bullet

You will have an email account using a free web-based product

bullet

You will have a certificate of completion that you have designed yourself!

bullet

You will have the confidence to move to the next level

Practical Word-Processing

This is an Intermediate Level Course that will teach you word processing tools to use at home and in an office.

To take this course you must be able to use a mouse (point, right click, left click and highlight), must be familiar with opening, minimizing and restoring multiple windows, and must have basic knowledge of opening, saving and editing documents with some word processing software (such as Word, WordPerfect or Works).

 

We work with Personal Computers, running Microsoft’s Windows XP Operating System. We also use  Microsoft Office 2003.

In this class, we will cover the following topics:

bullet

Editing, Revising, Spell/grammar check

bullet

Formatting fonts, alignment, paragraph and character spacing, and indenting

bullet

Design and drawing tools like autoshapes, clip art, borders and shading, wordart and text boxes.

bullet

Creating tables within Word Documents

bullet

Developing a list and merging the list with a document to personalize the document

bullet

Designing templates for letterheads, faxes, etc (home or office)

bullet

File and folder management.

To apply these skills we will be:

bullet

Editing a marked-up document and tracking the changes

bullet

Creating a marketing flyer (office)

bullet

Creating a birthday card with art and sound (home)

bullet

Developing a table to create a shopping list (home)

bullet

Developing a table for a project plan (office)

bullet

Sending party invitations to a list of guests (home) using mail merge

bullet

Sending a marketing letter to a list of customers (office) using mail merge

bullet

Creating folders to keep track of all our new documents!

bullet

Creating our own certificate of completion

bullet

Extracurricular: work on formatting a jazzy resume

Introduction To The PC - Spanish
Este es el curso de introducciόn a la computadora, diseñado para las personas que jamàs han usado una computadora o tienen limitada experiencia con una computadora. Este curso familiarisará a los estudiantes con la computadora y ayudará a los estudiantes a vencer su temor y a relacionarce con esta tecnología que le será útil para toda su vida.

Nosotros trabajamos con computadora personales, tambien usamos Microsoft Windows XP y Microsoft Office 2003.

Para tomar este curso usted solo tiene  que ser punctual a la hora que empiencen las clases y sobre todo venir con una mente abierta, el deseo de aprender y  pasarla bíen.

Dentro de estas clases tendremos:

bulletComo mirar dentro de la computadora y aprender sobre los diferentes datos que existen dentro de ella
bulletEntender que es “Window” y como usarlo
bulletTe combertirás en un experto usando el mouse (clikiando y sombriando)
bulletAprender sobre nuestro desktop y las diferentes formas de personalizarla (es por eso que es llamada computadora personal)
bulletComo crear archivos y folder
bulletComo abrir una cuenta de correo electronico y aprender como contestar un mensaje, escribir un mensaje nuevo y como enviarlo
bulletExplorar el Internet usando un programa de busqueda (nosotros haremos una busqueda dentro del Internet) Aprender el basico procedimiento de Word, abriendo un archivo, salvando un archivo, cambiando textos y a corregir un texto

Para el fínal de las clases:

bulletUsted tendrá una cuenta de correo electronico gratis
bulletUsted tendrá un certificado de cumplimiento que usted diceñará
bulletUsted tendrá la confiaza de moverte para el próximo nivel

Spreadsheets with Excel

This course covers Beginner and Intermediate level topics for use at home or in an office.

To take this course you must be able to use a mouse (point, right click, left click) and you must be familiar with opening, minimizing and restoring multiple windows and must have knowledge of opening, saving and formatting text. Knowledge of Microsoft Word is very helpful as many of the menus and toolbars are the same.

We work with Personal Computers, running Microsoft’s Windows XP Operating System. We also use  Microsoft Office 2003.

In this class, we will cover the following topics:

bullet

Setting up, naming and saving worksheets

bullet

Entering and formatting text and data

bullet

Creating and using formulae and functions

bullet

Using absolute and relative cell references

bullet

Setting up a table, sorting, filtering, autofill and formatting

bullet

Creating charts (bar, line and pie charts)

bullet

Creative formatting of charts – colors, etc.

To apply these skills we will be:

bullet

Creating a home budget, tracking, and charting expenses

bullet

Creating a department budget

bullet

Creating a employee database

bullet

Allocating overhead expenses to multiple company divisions

bullet

Temperature charts for Boston and San Francisco

PC Repair

This course is designed for people who want to do basic support and installations on their own computers and for anyone who just likes to understand how things work.

 A computer is merely the assembly of many pre-fabricated parts and subassemblies into a single package.  The parts, such as the hard drive, CD drive, floppy drive, memory, motherboard etc., are connected together with a series of wires and cables and then all the parts are packaged in a metal case called the chassis.   We will teach you how to replace or upgrade the most common parts and subassemblies.  You will learn the meaning of computer jargon words such as Dimm and Simm and Gigabyte vs. Megabyte as we go along. By the end of the course you and your teammate will have taken components out and then put them back in, connected the correct cables, and installed the operating system until the computer is back up and running.

In this class, we will:

bullet

Teach you to identify the different parts inside the computer such as memory, modems, network and video cards. We will explain their role in the system

bullet

Learn about computer memory, different types of memory (RAM, ROM, etc.), function of computer memory

bullet

Show you how to upgrade the memory

bullet

Teach you about storage devices, Hard drives, CD-ROMS, CD-RW, Floppy drives, showing you how to disconnect and reconnect them

bullet

Explain the terms master/slave and why they are important

bullet

Learn what formatting and partitioning a Hard drive means and reasons for doing it

bullet

Understand the power supply. Terms associated with it. How it provides power to all the computer components.  How to replace it, if it breaks

bullet

Learn about the operating system and how to install it

bullet

Review preventative maintenance suggestions such as the importance of Anti Virus, and keeping your computer running smoothly using disk Defrag and Scandisk

bullet

Go over a few troubleshooting tips as we go along

To apply these skills we will be:

bullet

Working in teams of 2 in a hands on project

bullet

Disassembling/Reassembling the computer piece by piece

bullet

Examining the System board, Processor, Memory and other components

bullet

Learning how the different disk drives connects with System board

bullet

Partitioning the Hard drive, loading the operating system, applications

bullet

Learning how and when to run preventative programs such as Scandisk

Microsoft Outlook:Curriculum Overview

Classes 1 and 2 are for beginner students who have had no, or very limited, experience using Outlook

Classes 3 – 6 are designed for people who have been using Outlook to write, send and receive email but want to learn the other features.

 

 

Class 1:

 

Hour 1: Explain the mail setup for class; Background on Email, Security, Spam, Bouncebacks and Etiquette, Exchange Server vs. POP mail, Size of storage on server

 

Hour 2: Explaining folders, menu items, Fields

Sending and Receiving email, saving a draft, finding an email

 

Class 2:

Hour 1:More Sending/Receiving email

 

Hour 2: Replying, Replying to All, Forwarding

 

Class 3:

Hour 1:

Review use of CTRL and SHIFT keys and right click

Set up Folder List or Outlook Bar

Creating an address/contact list

Creating new contact from same company

Editing contact info and lists (double click on contact to edit)

Delete by clicking on contact and then clicking on delete shortcut

Creating group distribution lists

Discussing use of folders, categories

Sorting/Searching/Customizing Contact Views

Toolbar View

Personal address vs global address

Different ways to print your contact list

 

Hour 2 – Setting up Views for Sent Folder

Sorting your Boxes by clicking on Header – search alphabetically

Adjusting column widths

 

Composing a message

Select and forward a contact via email (Actions>Forward)

Shortcuts to find a name or list from global or contact list

Save As Draft – Draft Folder

Formatting Tools (set up toolbar) – only when composing a new message

Setting flags (do not overuse)

Creating a signature block (Inbox/Sent Folder, Tools, Options, Mail Format) Note: In XP, Tools, Option, Email Options)

Rules Wizard

Class 3:

Hour 1:

Review use of CTRL and SHIFT keys and right click

Set up Folder List or Outlook Bar

Creating an address/contact list

Creating new contact from same company

Editing contact info and lists (double click on contact to edit)

Delete by clicking on contact and then clicking on delete shortcut

Creating group distribution lists

Discussing use of folders, categories

Sorting/Searching/Customizing Contact Views

Toolbar View

Personal address vs global address

Different ways to print your contact list

 

Hour 2 – Setting up Views for Sent Folder

Sorting your Boxes by clicking on Header – search alphabetically

Adjusting column widths

 

Composing a message

Select and forward a contact via email (Actions>Forward)

Shortcuts to find a name or list from global or contact list

Save As Draft – Draft Folder

Formatting Tools (set up toolbar) – only when composing a new message

Setting flags (do not overuse)

Creating a signature block (Inbox/Sent Folder, Tools, Options, Mail Format) Note: In XP, Tools, Option, Email Options)

Rules Wizard

 

Class 4:

Hour 1: Attachments – documents, pictures, Outlook messages

 

Reply to all, Forward

Email trail and confidentiality

 

11:30 – Noon:

Resend, Recall

Delete multiple messages by date, sender, etc.

Using shift and CTRL keys to delete

Deleted Items Folder

Bouncebacks

 

Hour 2:

 

9:00 – 9:30 Receiving Email

 

Add Sender to Address Book

Opening Attachments and saving them to the right place (File>Save Attachments)

Creating folders for incoming mail

n      drop and drag

n      Creating a rule

n      Saving to Desktop vs network

 

Junk e-mail

Out of Office Assistant

Reply vs Forward (attachments)

 

Class 5:

Hour 1: Using the Task feature

 

Setting Views and Tools

Tracking and Assigning

Creating and Choosing Fields

 

 

10:30 – 11:30 Setting up Calendars

Customizing Tools and Views

Making an appointment

Setting up a recurring appointment

Sharing your Calendar

Setting up a meeting, inviting multiple persons and checking availability

Accepting a meeting

Print views for calendar

Attach email to a meeting request

Notification options (Tools, Options, Preferences)

 

Class 6:

Searching and Archiving

Review

 

 

Exercises:

 

Throughout the two days create a Job Search Task List, Folders and Calendar.

 

 

Set up contacts for job search using business, location and categories

 

Set up a folder to track sent and received email related to job search

 

Set up a task list to track follow up,

 

Use calendar to track interviews, appointments, etc.