Lab Manual to Accompany Peeking Into Computer Science 2^nd Edition

Current Contributors to this manual are: Maha Shouman, Mishtu Banarjee, Jalal Kawash, and Mahmudul Hasan

Module 1 – Microsoft Excel

· Lab 1 (Introduction to Excel)

o Support Files

· Lab 2 (Charts and Pivot Tables)

o Support Files

· Lab 3 (Conditionals and Lookup Tables)

o Support Files

· Lab 4 (Conditional Formatting and Lists)

o Support Files

· Lab 5 (Drop Down Lists and Dynamic Charts)

o Support Files

o Lab 6 (Interactive Content) -- Lab 6 is optional

o Support Files

Module 1 references:

http://office.microsoft.com

http://help.wugnet.com/office/MANUAL-Sort-Option-Pivot-Table-ftopict1155539.html

http://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=225

http://www.chicopee.mec.edu/pages/Excel%20-%20PPoint%20workshop/Excel%20samples/excel_samples.htm

http://www.get-digital-help.com/2007/11/03/excel-2007-how-to-create-a-dynamic-chart/

http://peltiertech.com/Excel/Charts/ChartByControl.html

Module 2 – Microsoft Access

· Lab 1 (Introduction to Access)

o No support files required

· Lab 2 (Relationships and Queries)

o Support Files: AccessLab2, AccessLab2Queries

· Lab 3 (Advanced Queries)

o Support File: AccessLab3

· Lab 4 (More Queries)

o Support File: WebsiteRankings (Excel file)

· Lab 5 (SQL)

o Support Files

Module 2 reference:

http://office.microsoft.com

Module 3 – Programming (Alice)

· Support Files

· Alice Web site and download

Module 3 – Programming (Jython)

· Lab 1

o Support Files

· Lab 2

o Support Files

· Lab 3

o Support Files

· Lab 4

o Support Files

· Lab 5

o Support Files

[HOME] [BOOK HOME]