Back to Home


INLS 461-002 Information Tools, 2010 Fall

Instructor: Xi Niu

Schedule

Aug 25, Wed
Introduction/Syllabus
Basics 1: Hardware vs. Software

Readings: How Operating Systems Work
Slides: Lecture 1
Aug 30, Mon
Basics 2: Networking

Readings: How Web Servers Work
Slides: Lecture 2
Sept 1, Wed
Basics 3: The Web and the Internet

Readings: How Internet Infrastructure Works
                Foreseeing the Future: The legacy of Vannevar Bush
                Fluency 4 (Snyder, 2010): Chapter 3
Slides: Lecture 3
Sept 6, Mon
Labor Day, no class
Sept 8, Wed
Basics 4: Search engine basics

Readings: How Internet Search Engines Work
                 How a Search Engine Works
Slides: Lecture 4
Sept 13, Mon
Guest speaker (Chad Haefele): Citation managment using Refworks
Sept 15, Wed
no class
Sept 20, Mon
Unix/Linux 1: Intro & basic commands

Readings: Unix/Linux: Getting Started
Slides: Lecture 5

Assignment 1 Due
Sept 22, Wed
Unix/Linux 2: Input, output and pipes

Readings: UNIX/Linux: Intermediate
                 Commonly Used UNIX Commands
                 UNIX Command Acronym List
Slides: Lecture 6
Sept 27, Mon
Unix/Linux 3: Text processing

Slides: Lecture 7
Sept 29, Wed
Web design 1: HTML

Readings: UNC's Guidelines: Personal Web Pages
                 ATN's Creating Web Pages at UNC-CH
                 W3C's HTML & WWW
                 W3C's Introduction to HTML
                 W3C's HTML Elements
                 W3C's Basic HTML Tags
                 W3C's HTML Text Formatting
                 W3C's HTML Examples
Slides: Lecture 8
Oct 4, Mon
Web design 2: XML

Readings: W3C's XML Tutorial
Slides: Lecture 9

Assignment 2 Due
Oct 6, Wed
Web design 3: CSS

Readings: W3C's CSS Tutorial
Slides: Lecture 10
Oct 11, Mon
Web design 4: Web editors and web design

Readings: Top Ten Mistakes in Web Design
                A Better Way for Design
                Web Design that Won't Get You into Trouble
                ITS's Help for Dreamweaver
                Web Editors
Slids: Lecture 11        
Oct 13, Wed
Web design 5: Javascript I

Readings: Kompozer Tutorial
                W3C's JavaScript Tutorial
Slides: Lecture 12
Oct 18, Mon
Web design 6: Javascript II

Readings: W3C's JavaScript Tutorial
                 Fluency 4 (Snyder, 2010): Chapter 18 and Chapter 19
Slides: Lecture 13
Oct 20, Wed
Web design 7: Wrap-up of XHTML, CSS, XML, and JavaScript

Readings: W3C's XML Tutorial Only XML JavaScript Part
Slides: Lecture 14
Oct 25, Mon
ASIST conference, no class
Oct 27, Wed
ASIST conference, no class

Assignment 3 due, extended to Oct 29.
Nov 1, Mon
Database 1: Introduction and ER model

Readings: Database design basics
                 Fluency 4 (Snyder, 2010): Chapter 16
Slides: Lecture 15
Nov 3, Wed
Database 2: Access tables and relationships

Readings: Guide to table relationships
                 Access 2007: The missing mannual: Chapter 5 only: Linking tables with relationships
                 Learn the structure of an Access database
Slides: Lecture 16
Nov 8, Mon
Database 3: ER to Access tables and relationships

Readings: No reading
Slides: Lecture 17
           MS Visio Tutorial
Nov 10, Wed
Database 4: SQL

Readings: Introduction to queries
                 SQL on Wikipedia for background knowledge
                 Access 2007: The missing mannual: Chapter 6 only: Queries that select records
                
Slides: Lecture 18

Assignment 4 due
Nov 15, Mon
Database 5: SQL (cont'd)
                   Forms and report

Readings: Access 2007: The missing mannual: Chapter 10 and Chapter 12
                 W3C's SQL tutorial
Slides: Lecture 19
           SQL graphic queries in Access
Nov 17, Wed
Database 6: An practical example

Readings: No reading
Slides: Lecture 20
           Database Example: Northwind
Nov 22, Mon
Spreadsheet 1: Basic and functions

Readings: Excel 2007: The missing manual: Chapters 1, 2, 8, and 11
                 Fluency 4 (Snyder, 2010): Chapter 14
Slides: Lecture 21

Assignment 5 due
Nov 24, Wed
Thanksgiving break, no class
Nov 29, Mon
Spreadsheet 2: Data analysis and charting

Readings: Excel 2007: The missing manual: Chapters 15 and 17
                 Fluency 4 (Snyder, 2010): Chapter 15
Slides: Lecture 22
Dec 1, Wed
Statistical computing (SAS) 1: Introduction to SAS

Readings: get started with SAS
Slides: Lecture 23
Dec 6, Mon
Statistical computing (SAS) 2

Readings: no reading
Slides: Lecture 24
SAS code: sas_code.txt
Data: survey.txt
Dec 8, Wed
Presentation Design and Wrap-up

Readings: Big Dog's Leadership Page - Presentation Skills
                 Presentation Pointers
                 PowerPoint Tips & Tricks
                 PowerPoint and Presentation Tips

Slides: Lecture 25