Essential Computer Skills
CSCI 1300 -  Tentative Schedule
 
Date
Lecture Topics
Required Readings
Lab Assignments
1/13
Introduction To Course 
Discuss Course Outline 
Discuss Academic Integrity
Select A Computer Next Class!
Course Outline
Read Chapter 1 [CC]
 
1/15
Hardware vs Software 
Hardware Terminology
Show & Tell
Hardware Terms
Read Chapter 2 [CC]
Hardware Lab [1]
Chapter 1 Reading Lab [1]
1/18
NT Lab Login & Logout 
Operating Systems 
Introduction To Windows 95/NT
Windows
Read Chapter 3 [CC]
Windows 95/98 /NT Lab [2]
Chapter 2 Reading Lab [1]
 1/20
HW[1]
 Operating Systems 
Introduction To Windows 95/NT
 
 Chapter 3 Reading Lab [2]
1/22
 Introduction To Paint Shop Pro
Image Compression
jpg & gif image formats
 
  Paint Shop Ad Lab [2]
1/25
 Network Neighborhood Navigation To Tucc8//Users
& Tucc8/Class

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

 
 
1/27
HW[2]
 Resizing An Image With Paint Shop Pro
Cropping An Image With Paint Shop Pro
Screen Capture With Paint Shop Pro

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]

 Paint Shop Pro 
Screen Capture
 

Install Stone 
Text Tools

HTML Language

 Personal Page Lab [3]
1/29
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]
Horizontal Rule
Image Source Element
A First Home Page
 
Paint Shop Scan & 
Crop Lab [3]
2/1
 Review
 
 
2/3
HW[3]
HomePage Lab
Adding Backgrounds
Changing Font Colors
Work On HomePage
 
 Home Page 1 Lab [4]
2/5 
 Presentation Manager
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

Group & Ungroup Objects

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

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

Slide Show

 
 PowerPoint I  Lab [4]
2/8
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

 Buttons on A Read Part II [EMA]
 Create Users Database Lab [4]
2/10
HW[4]
 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

 Netscape Composer Basics
 Home Page II Lab [6]
2/12
Posting A PowerPoint Presentation On The WWW
Conversion To HTML

Snap-Shot Images
Directories & Subdirectories
../
A HREF Review
Img SRC Review

 
 Power Point II  [WWW] Lab[5]
2/15
 Digital Camera Information

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 precison - 4 bytes}, Double {at least 12  digits of precison - 8 bytes}

AddingDeleting/Editing Records
AddingDeleting/Editing Fields

 Draft Access Database Tutorial
 Trinity Friends DB Lab [5]
2/17
HW[5]
 Tables
Netscape Communicator
Table Alignment, Color, Width
Cell Text, Image, Link, Format, Hight, Width, Alignment, Span Cells
Row Hight, Width, Color

Frames

<FRAMESET COLS="120,*" >
<FRAME SRC="Menu.html"  Name = "Menu">
<FRAME SRC="Home.html"   Name = "DisplayWindow">
</FRAMESET>
<A HREF="PersonalInfo/PersonalInfo.html 
                     TARGET="DisplayWindow">Personal</A>

 Netscape Communicator Tables Tutorial
 
2/19
 Web Site Design
 Web Site Design Slide Presentation

 Web Site Design Principles

 
2/22
 
 Read Part IV Database
"Using Satabase Forms"
 
2/24
HW[6]
 Reviewed For Exam I
Custom Database Forms
Next, Previous, Top, Bottom, Add, Delete Buttons
Duplicate Record - Archaeology App

Will Be Making 3 Exams Off Campus Thursday
Will Be In Office Fri Morn for Questions

 Tutorial: Microsoft Access :  Data Types, Table Processing & Design Layouts 
 Microsoft Access :  Data Types, Table Processing & Design Layouts Lab [7] 
2/26
 Exam I
 
 
3/1
 Review Exam I
Import Images Into Word
Wrap Text Around Images
 Sample Resumes
 Resume Lab [7]
3/3 
HW[7]
 Database Reports and Labels
 Read PartVI Database
"Creating And Using Reports"
 Southwest Custom Form Lab [8]
3/5
 Review - Questions & Answer Session
Small Group Digital Scanning & Imaging Lab
 
 
3/6-3/14
 Spring Break - Be Careful!
3/15
 Mid Semester Grades Due
3/15
 Small Group Digital Camera Lab
No Lecture
 
 Digital Camera Lab[9]
3/17
HW[8]
 Compression & Decompression 
WinZip
Download & Install WinZip

Data Communications
Download & Install Talk-R
Chat Rooms - [Private]
Talk-R 

 Install WinZip

Using WinZip

Installing TalkR

 Using Talk R

 Resume To HTML Lab [9]
3/19
 Graphic Animation
Create Original Gif Images With Paint Shop Pro
Download, Decompress, and Install A Graphic Animator
 
Chapter 6 Reading Lab [9]

Animation Lab [9]

3/22
Last Day To Withdraw With A W
3/22
 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)
 Introduction To UNIX
 Chapter 7 Reading Lab [9]

 UNIX Lab [9]

3/24 
HW[9]
 -- Review UNIX --
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)
 
  Talk-R Lab [10]
3/26
 -- Review UNIX --
talk, ntalk, ytalk
 
 
3/29
Introduction To Communications 
OnLineServices
Human Need To Communicate
Physical Connections
Coaxial Wire
Twisted Pair Wire
Fiber Optic
Infrared Wireless
Radio Frequency Wireless
Microwave Wireless

Intranet vs Internet

Digital and Analog Signals
Digital - higher quality - music CD
DAT - Digital Audio Tape
Transmission Speed (bits per second bps)
Modem - (Modulate and Demodulate)
Modem Speeds
Baud Rate vs bps
Simplex Tranmission
Half Duplex Transmission
Bandwidth - measure o fcapacity of a link
(Twisted Pair Bandwidth = 10-100 Mbps)
(Coaxial Bandwidth = 10-100 Mbps)
(Fiber Optic Bandwidth = 100-2400 Mbps)
14.4-28.8-56-ISDN-T1-T3-STS-?
Network - 2 or more devices connected
Node - printer, fax, computer, etc.

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

 
 Chapter 8 Reading Lab [11]
 3/31
HW[10]
 -- Review Communications --

DAN - Desk Area Network
LAN - Local Area Network
MAN - Metropolitan Area Network
WAN - Wide Area Network
DQDB - Distributed Queue Dual Bus
Firewall
Internet- collection of networks linked together by set of programs/rules/protocols
TCP/IP Protocol Suite

Architecture Of Internet
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)
UDP - User Datagram Protocol (Live Audio and Live Video Standard - Small Error Tolerence)
IP - Internet Protocol (manage TCP and UDP)

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) 

UseNet (News groups with hundreds of topics - reference)
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 -  by National Science Foundation - all major colleges and universities by 1986 and companies

Too Expensive - Private Enterprise - Backbone
CSNet became Internet 
Information Super Highway

 
 
 4/2
Good Friday
4/5
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

Internet2 - Late 1996
UCAID - University Corporation for Advanced Internet Development (100 Research Universities)
Additional Bandwidth for voice and video distance learning classes)

Query Language
SQL - Structured Query Language
Searching A Microsoft Access Database
Query Design

 Read Part V Database
"Getting Information From A Database"
 DB Query Lab [11]
 4/7
HW[11]
 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

 
 
 4/9
 Microsoft Excel
Insert Rows
Insert Columns
Relative Formula Reference
Copying Relative Formulas
Inserting Rows and Cols In Relative Range 
Absolute Formula Reference
Copying Absolute Formulas
AutoSum 
Paste Function Wizard
Save, Print, Print Region
Multiple Sheets
Rename Sheets
Spell Check
Sorting Row/Col
Sorting Table Of Related Information
=today()
=PMT(5%/12,5*12, 6000) [Monthly Payment 113.23]
 
 Budget Lab [12]
4/12
Review Payment Formula
Review Absolute Addressing
Sorting Data
Graphs
 
 Excel Graph Lab[12]
4/14
HW[12]
 Muti-Media & Sound
Wave File Format
Adding Sound To Web Pages
 
 
4/16
 No Class - Dr. Hicks Presenting A Paper At Small Computer Conference
Work On Projects
 
 
4/19
 Record Wave Sound
 
 Add  Recorded Wave Sound To Either
HomePage1 or Project
15 Points
4/21
 Ethics
Review For Exam
   
4/23
Exam 2
 
 
4/26
HW[13]
FTP - Upload Web Site
 
 Upload Site
In Class
10 Points
 Final Projects & Late Labs Must Be Turned In By 4:30 on 4/27/99