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