Introduction

Windows

1. Basic differences between NT, UNIX and home computer (Windows 3.x, Macintosh)

2. Logging on to NT in the lab

3. The Desktop

   • My Computer

   • Start Menu

   • Program Files

   • Desktop Shortcuts

   • Saving Files

   • Local Drives and Remote Drives (C: Vs Z: in lab)

4. Programs

   • Internet Explorer (proper use, downloading files from the internet)

   • WEBCT (Logging On, Taking a quiz, Submitting a homework )

   • Telnet (Logging In and Out, Using it from Home)

   • Secure Shell (Logging In/Out, Benefits over Telnet, )

UNIX

E-mail - Pine

Folders

creating a folder
sent, received, Inbox
organizing e-mail within folder sort
searching a folder

Sending an E-mail

someone else on the system
CC, BCC
Attachments
Moving around in pine
paragraph justification

Reading , Deleting, Forwarding and E-mail

UNIX Contd.

Files and Directories

What is a directory tree, explain whata file is, what a directory is, use cd with complete path, cd .., cd <enter>, cd~. etc. Move around and use cd and pwd to see where you are.

Commands

Listing files and directories using (ls -l)
Copying files and directories (cp and cp -r)
Moving files and directories (mv and mv -r)
Deleting/removing files and directories (rm and rm -r)
Creating a directory (mkdir)
Removing a directory(rmdir and rmdir -r)
Looking things up in manual (man)
passwd(just know it exists - I think it is too dangerous)

Accessories
cal
calc
date
webster

Unix Text editors

Pico

Creating a file using Pico
Spell check
Saving a file in Pico

EXCEL

• DEFINITIONS - cell, row, colum, sheet, workbook
• FORMATTING
• what can you format?, a cell, row, column, selection, sheet, a page
• Font, different types
• Color
• Borders - around cell, around selection, dotted, full, etc.
• Bold, Underline, Italic
• Alignment - right, left, center, center across selection
• Number formating - Decimals, Percent, Comma, Currency, Negatives
• Size of objects - a cell, a row height, a column width, autofit a column, row, sheet, selection
• page formatting
• FORMULAS
• Examples - SUM, MEDIAN, AVERAGE, MIN, MAX, SMALL, LARGE
• Selecting cells for formula - a range, individually, typing and mouse
• Using formula buttons, pointing out the dangers as well as benefits
• Fill down - how to fill down or across with a formula, fixing columns and rows within formulas for fill down using the $

Excel - Part 2

CHARTS

• Selecting Data
• Walk through wizard
• Different Chart Types, column, pie, scatter, etc.
• Axis - data by rows or columns
• In a new spreadsheet or as an object in the Same spreadshhet

DATA ANALYSIS

• Historgram
• Selecting Data
• Creating Bins
• Walk through wizard
• Chart Data in another spreadsheet
• Statistical Data
• Walkthrough wizard
• Standard Deviation, Mean, Average etc.

 

Powerpoint

• Open an existing prsentation or create a new presentation using blank presentation
• Choose an Auto LayOut
• Like in Excel: how to use bold, italic, underline, how to change font and font size, align left,right,center.
• How to create a new slide
• Slide types, text, chart, image, movie, etc.
• Add a hyperlink
• How to format a presentation using design templates
• How to do custom animation on the slide, and for the slide transition
• How to view the show and rehearse timings