Essential Computer Skills - Computer Science 1300 
Tentative Schedule - Summer 2001
Dr. Thomas E. Hicks
/12Date
Lecture Topics
Required Readings
Lab Assignments
5/22
Introduction To Course 
Discuss Course Outline 
Discuss Academic Integrity

Hardware vs Software 
Hardware Terminology
Show & Tell

Introduction To Windows 95/NT/2000

Introduction To Paint Shop Pro
Image Compression
jpg & gif image formats
Image Formats

Course Outline
Read Chapter 1 [CC]

Hardware Terms
Read Chapter 2 [CC]

Windows 95/98 /NT

 Hardware Lab
 

Windows 95/98 /NT Lab

Paint Shop Ad Lab

5/24
Quiz - Windows NT/95/98 & Hardware Terms

Introduction To Paint Shop Pro Continued
Image Compression
jpg & gif image formats
Image Formats

TIFF Image converted To JPG
TIFF Image converted To GIF
TIFF Image converted To BMP
Internet Download Times For Graphics

Resizing An Image With Paint Shop Pro
Cropping An Image With Paint Shop Pro

Graphic Manipulation
Resize Images
JPG for Scan/Photo
GIF for Drawing



HTML
URL
WWW

Compression & Decompression 
Self-Extracting Archive

Web Search For Stone Text Tools
DownLoad & Install Stone Text Tools

Definitions & Acronyms
HTML Element
Header Element
Title Element
Body Element
Normal Text
Paragraph Break Element
Line Break Element
BoldFace Element
Italics Element
Center Element
Underline Element
Heading Elements [H1, H2, H3, H4, H5, H6]

 

Read Chapter 1

Read Chapter 2

Read Chapter 3

Install Stone 
Text Tools
 

HTML Language


 
 
 

Digital Camera Lab

Home Page 1 Lab

5/29
Quiz - Chapter 1 & 2 & 3 & HTML

Power Point Presentation Manager
Drop Text Box, Bound Text Box, Changing Text Font Style, Changing Text Font Color, Changing Text Font Size, Bold, Italic, Underline, Increase Font Size, Decrease Font Size

Word Art, Changing Word Art Line Color, Changing Word Art Fill Color, Resizing Word Art

Lines, Arrows, Ovals, Rectangles, Auto Shapes, Fill Colors, Line Colors, Resizing, Line Thickness, Arrow Styles

Insert Clip Art, Insert .JPG & .GIF
Clip Art Collection From CD's
Group & Ungroup Objects

Animation - Drive In Effect, Flying Effect, Camera Effect, Off

Slide Sorter View, Duplicate Slides, Re-order Slides, Delete Slides

Slide Show


WWW Editors
WYSIWYG

Netscape Composer
Basic Web Definitions & Acronyms
Composer Tool Bars
Creating A New Web Document
Selecting Text
Font Availability
Changing & Selecting a Font
Changing & Selecting a Font Size
Changing & Selecting a Font Color
Changing & Selecting Alignment  [Center - Right Justify, Left Justify]
Changing & Selecting Font Bold
Changing & Selecting Font Italics
Changing & Selecting Font Underline
Increasing Indention
Decreasing Indention
Creating A New File
Opening A File
Saving A File
Previewing A Document
Deleting The Selection
Copying The Selection
Pasting The Selection
Finding The Desired Text
Adding Graphic Images (Same Directory As Web Page)
Adding The Horizontal Rule/Line
Adding HyperLinks To A WWW Document
Adding HyperLinks To A Local Document
Adding A Title To A Document
Adding A Background To A Document
Checking The Spelling
Web Page Guidelines

 Scan Chapters 9 & 10 Office 

Read Chapter 4

Read Chapter 5

Netscape Composer Basics

     Web Site Design Guidelines
















 

Power Point Lab

Home Page II Lab
Due In One Week














 

5/31 
Quiz - Chapter 4 &5 & Composer

Review HTML 
Relative Addressing
vs 
Absolute Addressing

Resizing Digital Images Reviewed

Tables
Netscape Communicator
Table Alignment, Color, Width
Cell Text, Image, Link, Format, Hight, Width, Alignment, Span Cells
Row Hight, Width, Color

Netscape Communicator Tables Tutorial

Read Chapter 6

Read Chapter 7

Read Chapter 8

Web Site Design Guidelines
 

 Finish 
Web
Page
 6/5
What Is A Database, Why Database
About Tables, About Records
Manage Large Quantities of Data With Rapid Access

Introduction To Access Database
Creating A Blank Database [Design View]
New Table, Adding Fields To A Table
Character/Text Datatype [A-Z, 0-9, @,#,$,%,&,etc] ASCII
Logical Datatype [T/F. Y/N]
Date Datatype [ 12/25/99]

Logical Datatype, Memo Datatype [ Open, Unlimited, Unformatted Block]
Numeric {Byte {0<=>255 - 1 byte}, Integer {-32,768<=>32,767 - 2 bytes}, long int {-2,147,483,648<=>2,147,483,647 - 4 bytes}, Single {at least 6  digits of precision - 4 bytes}, Double {at least 12  digits of precision - 8 bytes}

Y2K Problem
Changing Datatypes & Data Sizes

Adding/Editing Records From Table->Open 
Creating An Autoform
Next, Previous, Top, Bottom, Delete, & Add Buttons on Autoform

Access Reports
Access Report Buttons
Access Forms

Search Engines 
Efficiently Searching The Internet
Copernic

 
Create Users Database Lab 

SouthWest Form
 

Educational Links Project

 6/7
Take Exam I & Work On Project
 
 
6/12
Go Over Exam

Introduction To Communications 
OnLineServices
Human Need To Communicate

Physical Connection Types
Coaxial Wire
Twisted Pair Wire
Fiber Optic

Wireless Connection Types
Infrared Wireless
Radio Frequency Wireless
Microwave Wireless

Intranet vs Internet

Digital and Analog Signals
Transmission Speed (bits per second bps)
Modem - (Modulate and Demodulate)
Modem Speeds
Baud Rate vs bps

Bandwidth - measure o fcapacity of a link
(Twisted Pair Bandwidth = 10-100 Mbps)
(Coaxial Bandwidth = 10-100 Mbps)
(Fiber Optic Bandwidth = 100-2400 Mbps)

Connection Speeds
14.4-28.8-56-ISDN
Network - 2 or more devices connected
Node - printer, fax, computer, etc.

Architecture Of Internet
Point To Point connection - Cross-over Cable
Bus Topology
Ring Topology
Star Topology
Tree Topology
Fully Connected Topology

Protocols
FTP - File Transfer Protocol (files between two computers)
HTTP - Hyper Text Transfer Protocol (Web pages in and out)
NV - Network Video (live video protocol)
TFTP - Trivial File Transport Protocol (Telnet login & E-Mail & SMTP - Simple Mail Transfer Protocol)
TCP - Transmission Control Program (provide path/stream in which to pass information to application on remote computer - No Tolerence For Errors)

Why are Protocols/Standards so Important?
ISP - Internet Service Provider

Hub - (broadcast local network)
Bridge -(Link between 2 networks with same rules)
Gateway -(Link between 2 networks with different rules)
Router - (Sends packets in one of many directions to get to destination)
Switch - (receives packets from input link, sorts, and transmits them to addressed node - direct)

Paul Baron & Donald Davies - Independently Developed Packet Switching
Packet - Destination, Source, Info (often smaller piece of whole)

1969 Arpanet - Network Control Protocol - Original Internet - Military Defense - Research Universities - taken back by Defense Agency 1975 - evolved into  Milinet

1980 CSNet - TCP/IP developed - 

Internet taken over  by National Science Foundation - all major colleges and universities by 1986 and companies

Too Expensive - Private Enterprise - Backbone

CSNet became Internet 
Information Super Highway
IP Address ___.___.___.___
Internet Address

Original Internet Difficult To Navigate
Gopher - Text based -University Of Minnesota -  File Folders
Gopher Problem - Needed to know where to look
Veronica - Very Easy Rodent-Oriented Network Index To Computing Archives - Searches Using a Master Index Of Gopher System
Archie - First Internet Database Search System for FTP
Gopher/Veronica/Archie - "duct tape that held Internet together till software cought up"
Archie Web Page Available



Review A Couple Of The 
Better Web Site Projects
Suggestions To Make Better


Introduction To Spreadsheets
Microsoft Excel
Cell/Region (Alignment, Font Size, Font Color, Font Style, Background Color, Bold, Italic, Underline)
Center Text On Page
Cell/Region Format (Number, General, Currency, Date, Percentage, Text, Border, Orientation






 

 
 Budget Lab

1 Week

 6/14
Formulas
Cell Labeling and Range
+, -, *, /, Order Operations
Insert -> Function
= Sum(A2:B5), = Sum(2,3,4,5,6) [Summation=20]
= Average(A2:B5), = Average(2,3,4,5,6) [Mean=4]
= Min(A2:B5), = Min(2,-3,4,5,6) [Minimum=-3]
= Max(A2:B5), = Max(2,-3,4,15,6) [Maximum=-15]
= Count(A2:B5) [How Many Numerical Values]
=PI() [PI = 3.14...]
=Fact(A5), Fact(4) [Factorial Value=4*3*2*1=24]
Relative Formula Reference
Copying Relative FormulasWeb Site Design Principles

Excel Graphing



Access Forms 
Muti-Table Applications
Pull-Down Combo Field Access
Radio Field Access
Exam I (Second Half Of Class)
 

Introduction To Spreadsheets
Microsoft Excel
Cell/Region (Alignment, Font Size, Font Color, Font Style, Background Color, Bold, Italic, Underline)
Center Text On Page
Cell/Region Format (Number, General, Currency, Date, Percentage, Text, Border, Orientation

Formulas
Cell Labeling and Range
+, -, *, /, Order Operations
Insert -> Function
= Sum(A2:B5), = Sum(2,3,4,5,6) [Summation=20]
= Average(A2:B5), = Average(2,3,4,5,6) [Mean=4]
= Min(A2:B5), = Min(2,-3,4,5,6) [Minimum=-3]
= Max(A2:B5), = Max(2,-3,4,15,6) [Maximum=-15]
= Count(A2:B5) [How Many Numerical Values]
=PI() [PI = 3.14...]
=Fact(A5), Fact(4) [Factorial Value=4*3*2*1=24]
Relative Formula Reference
Copying Relative Formulas

 Skim Chapters 5, 6, 7, 8 in Office Text

Review Chapter 7 & 8
Read Chapter 9

Excel Graph Lab

NorthWind Form

 

 6/19
2 Quizes 30 Points - 
Communication, Excel, Chapters 7& 8 & 9
Skim Chapters 5, 6, 7, 8 in Office Text

Database Design Forms & Controls
Combo Box
Option Group
Radio Button

Graphic Animation
Create Original Gif Images With Paint Shop Pro
Download, Decompress, and Install A Graphic Animator

Gif Animation
Three Reasons For Compression
Smaller In Size - Take Less Space
Download Faster 
Package Multiple Files/Folders

  Database Form Guidelines

Read Chapter 10

Gif Animation Lab
 

 Form Control Database Users Lab
 
Work On 
Educational Link
Project 

Work On Final 
HomePage

 6/21
UNIX Operating System
login:  thicks
password: XXXXX
Term=<vt100> Carriage Return
tcsh shell - (username/path, backspace, file completion, history of commands with up/down arrow)
vaild file names
ls, ls -a, ls -l, ls -al, ls t*, ls -l *.c
d rwx rwx rwx (owner, group, world permissions)
vi junk.txt (text editor)
cat junk.txt (display text file)
cp junk.txt new.txt (copy file)
rm junk.txt (erase file)
man ls, man cp, man (manuals)

talk, ntalk, ytalk
Instant Messenger

vi junk.txt (text editor)
cat junk.txt (display text file)
cp junk.txt new.txt (copy file)
rm junk.txt (erase file)
mv junk.txt newjunk.txt (rename file)
mkdir Temp (create directory)
cd Temp (change current directory)
cd .., cd ../, cd 
rmdir Temp (delete directory)
man ls, man cp, man (manuals)
passwd old new new (change password)
elm or pine (e-mail)
ctrl -c (abort)

Not WYSIWYG in Telnet

Introduction To UNIX

Introduction To VI

 

 UNIX Lab

 VI Lab
 

Work On 
Educational Link
Project 

Work On Final 
HomePage

 6/26

2 Quizes 30 Points - 
 UNIX - VI

Database Queries
 


WWW Editors 
Download/Decompress/Install

 
 DB Query Lab

Study For Exam

Work On 
Educational Link
Project 

Work On Final 
HomePage

 
 6/28
 Collect Home Page Project
Collect Educational Link Project
First Half Of Class

Exam II


Moving Home Page To Trinity
 

Web Communication
talk, ntalk, ytalk
Instant Messenger

Last Day To Turn In Any Work!