LSP 121 Lecture Notes, Activities, and Homework
Week 1
Lecture: Intro to course and simple databases; importing a database
Activities: Activity 1 - Simple databases Activity 2 - Importing a database
Access Database Handout (Office 2010 version)
Tips for Non-CDM students taking CDM classes (LSP 121)
Week 2
Lecture: Advanced databases
Activities: Activity 3 - Relational databases Activity 4 - Advanced queries
Week 3
Lecture: Database forms and reports
Activities: Activity 5 - Forms
Activity 6 - Reports
Activity 7 - Switchboard
Week 4
Lecture: Intro to statistics
Activities: Activity 8 - Statistics
Week 5
Lecture: Probability
Activities: Activity 9 - Probability
Week 6
Lecture: Midterm exam ; Correlations
Activities: Activity 10 - Correlations
Week 7
Lecture: Number systems and logs
Activities: Activity 11 - Number systems and logs
Week 8
Lecture: Computer Algorithms
Activities: Activity 12 - Introduction to algorithms
Activity 13 - Alice
Week 9
Lecture: Computer algorithms continued
Activities: Activity 14 - VBA
Activity 15 - Compression and security
Week 10
Lecture: Computer algorithms continued
Activities: Activity 16 - Data errors
No homework this week - study for the final exam!
Week 11
Final exam -