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