LSP 121 Lecture Notes, Activities, and Homework
Week 1
Lecture: Database basics and importing data into a database
Activities: Activity 1 - Importing spreadsheet data
Homework: Homework 1 - Importing a text file
Access Database Handout (Office 2003 version)
Access Database Handout (Office 2007 version)
Tips for Non-CDM students taking CDM (ISP 121) classes
Week 2
Lecture: Database normalization and queries
Activities: Activity 2 - Relational databases and queries ; Activity 3 - Advanced queries
Homework: Homework 2 - Relational databases
Excel dataset to accompany Activity 2 (cable customers)
Real estate database to accompany Activity 3
Week 3
Lecture: Database forms and reports
Activities: Activity 4 - Creating a form ; Activity 5 - Creating a report
Homework: Homework 3 - Access practice
Week 4
Lecture: Intro to descriptive statistics and SPSS
Activities: Activity 6 - Intro to statistics and SPSS
Homework: Homework 4 - Descriptive statistics
Week 5
Lecture: Correlation; Number systems
Activities: Activity 7 - Correlation; Activity 8 - Basic number systems
Homework: No homework this week - study for the midterm next week!
Week 6
Midterm exam
Lecture: Statistics that deceive
Activities: Activity 9 - Stats that deceive
Homework: Homework 5 - Working with logarithms
Week 7
Lecture: Probability and risk
Activities: Activity 10 - Probability and risk
Homework: Homework 6 - Probability and risk
Week 8
Lecture: Algorithms
Activities: Activity 11 - Intro to algorithms ; Activity 12 - Pseudocode ; Activity 13 - Alice
Homework: Homework 7 - Alice
Week 9
Lecture: Computer technology continued
Activities: Activity 14 - Creating an e-portfolio ; Activity 15 - JavaScript
Homework: none at this time
Week 10
Lecture: Computer technology continued
Activities: Activity 16 - Google Map Mashup ; Activity 17 - Google Search Activity
Homework: No homework this week - study for the final exam!
Week 11
(Final exam)