IFSM 300

Videos of weekly LEO topics

Week 1:
Excel G: making small spreadsheets
G.pdf     p159.pdf
Assignment:Unit G assignment

Excel H: more spreadsheets, table sort and filter
H.pdf     p181.pdf    p187.pdf
Unit H datafiles folder  
Assignment:Unit H assignment

Excel I: charts
I.pdf    p209.pdf    p211.pdf
Unit I datafiles folder  
Assignment:Unit I assignment


Week 2
Excel: Widgets in-class exercise        Books and Beans optional exercise
Assignment:Gas assignment

Notepad notes
Paired data correlXY.txt    n    Mean:μ,x̄    SD:σ,s    Median    Correlation:r    Scatter plot
kana.txt large data file     Notepad exercise     Excel: kana

Assignment:Excel counties assignment      counties2010.txt

Excel memes

Excel certification


Week 3
Assignment:H-192

Generate random "kana" data
Assignment:Excel j1M_lab.txt      Statistical sample

K, M, G, b, B etc      ASCII    Assignment:Exercise
Computer architecture
Disks

Dell Inspirons      Dell Precision     


Week 4:
WWW intro      HTML intro      simple stylesheet
HTML lab           Mac Safari, TextEdit notes
Assignment:Assignment: HTML Web page

HTML memes

CMST 385 Web Design course      199,000 jobs: BLS OOH Web Developers and Digital Designers
Another example webpage: J-Prop w/structural elements. No CSS.      Same with CSS    its CSS
Another example webpage: Starbuzz w/structural elements. No CSS.      Same with CSS    its CSS

Single pixels      RGB colors      Compare RGB colors      Your Favorite colors    Projector   
Assignment: Exercise

Sounds folder
Bach vs Sine wave


Week 5:
Program, software, code
Javascript template
Javascript tutorial
Compound interest calculator w/form

CMSC 105 Programming 1 course      CMIS 141 Programming 2 course      CMIS 242 Programming 3 course
1,848,000 jobs: BLS OOH Software Developers, Quality Assurance Analysts, and Testers

tracert windowshots: www.yahoo.com      www.bpl.org      www.louvre.fr      www.cenpac.net.nr      www.anadyr.ru
Networking lab ...

CMIT 265 Networking course     
165,000 jobs: BLS OOH Computer Network Architects     
350,000 jobs: BLS OOH Network and Computer Systems Administrators     
163,000 jobs: BLS OOH Information Security Analysts

Security


Week 6:
Access J: making small database tables
J.pdf    p227.pdf    p229.pdf    p231.pdf    p233.pdf    p235.pdf
Assignment:Access J assignment

Access K: using small databases: sort and search. Queries. Relationships.
K.pdf    K images .pdf
Unit K datafiles folder  
Assignment:Access K assignment ...
Week 7:
Access:
Import and aggregate
Assignment:Access 3 ...

Assignment:Access Counties ...    counties2010.txt

DB SQL meme

CMIS 320 Database course      168,000 jobs: BLS OOH Database Administrators and Architects


Week 8:
Assignment:Access Weather in-class exercise ...    stations.accdb