IFSM 300

Videos of weekly LEO topics

Week 1:
anatomy of a window
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


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

bits&bytes K, M, G, b, B etc      ASCII table      Kanji text file
Assignment:Ascii characters

Textfiles and Notepad notes
kana.txt large data file     Assignment:Notepad exercise

Excel memes

Excel certification


Week 3
Statistics:
Histogram    n    Mean:μ,x̄    SD:σ,s    Median
Paired data correlXY.txt    Correlation:r    Scatter plot
correlXY.xlsx

Assignment: Excel: kana      kanaXYchart.pdf

KMGTPE
Assignment:Computer sizes assignment

Computer architecture           Inside PC      Disks

Dell Inspirons      Desktops      Dell Precision


Week 4:
WWW intro      HTML intro      simple stylesheet           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: Colors

Sound demo


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

Excel: Widgets in-class exercise
Assignment:Gas assignment

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


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

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 7:
Assignment:Access Weather in-class    stations.accdb


SKIP:

Assignment:Excel counties assignment      counties2010.txt

Books and Beans optional exercise

Assignment:H-192


Program, software, code
Javascript tutorial      Javascript template
BMI calculator (w/form)      Compound interest calculator (w/form)
Python programming How to      welcome.py      bmi.py      compound_interest.py
Assignment:Programming exercise

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

Assignment:Networking exercise

tracert windowshots: www.yahoo.com      www.bpl.org      www.louvre.fr      www.cenpac.net.nr      www.anadyr.ru
Submarine cables Okinawa

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