Courses/Computer Science/CPSC 203/CPSC 203 Template/Fall 2009 Lab Manual
Please note that this page WAS used for CPSC 203 Winter 09 and previous semesters. For the updated schedule and assignments for FALL 09, please use this link
Contents
Labs Template
Four three week modules
- Problem Solving with Spreadsheet
- Problem Solving with Database
- General Problem Solving
- Design in Problem Solving
At the end of each module there will be an in-class quiz. Modules 1-3 will have a Lab Quiz, where students must complete a series of tasks during the scheduled tutorial period. The final module will have a group collaborative project whose final outcome is a system design developed over two tutorial sessions.
There will be 3 Take Home Assignments -- one on Spreadsheets, and two on Databases.
CPSC 203 Lab and CT Hour Schedule
/CPSC203 Fall 2009 Lab and CT Hour Schedule
Lab Resources
The following software is available on the lab computers:
Officeware: MSOffice, OpenOffice
Analysis: R
Databases: Sqlite
Programming: Python, Jes
- JES can be downloaded at: http://www.cc.gatech.edu/classes/AY2006/cs1315_summer/software.html
- A simple tutorial on Python (the language behind Python and Jes) is at: http://en.wikibooks.org/wiki/Non-Programmer's_Tutorial_for_Python
- TA's -- Try and incorporate these resources into lab tutorial sessions
CPSC 203 Lab Important Dates and Materials Covered during that Lab
Spreadsheet
Material for the following lab modules can be found using the following links:
- Starting Sep 14 2009
- Week 1 - Lab 1: Introduction to Spreadsheets and Basic Calculations (revision)
- Week 1 - Lab 2: Complex Calculations, If-Then Statements, and Pivot Tables
- Starting Sep 21 2009
- Starting Sep 28 2009
Database
- The material below is from: http://inpics.net/access07.html
Material for the following lab modules can be found using the following links:
- Starting Oct 05 2009
- Week 1 - Lab 1: Intro to Databases (quick): Basic Parts of a Database
- Week 1 - Lab 2: Fields, Keys, Simple Queries (single table)Intro to Assignment 1
- Starting Oct 12 2009
- Week 2 - Lab 1: No labs on Oct 12th and Oct 13th
- Week 2 - Lab 2: Multi-table queries, Aggregate Qureies
- Starting Oct 19 2009
- Week 3 - Lab 1: Crosstab queries and Custom Calculations
- Week 3 - Lab 2: Query Analysis Examples (Union and append queries). Review for Assignment 3
Problem Solving
Material for the following lab modules can be found using the following links:
- Starting Oct 26 2009
- Lab Quiz on Databases|/Week 1 - Lab 1: Lab Quiz 2 on Databases
- Problem Solving Week 1 - Lab 1: Introduction to JES, variables and constants
- Starting Nov 2 2009
- Starting Nov 9 2009
- Week 3 - Lab 1: Programming review
- Week 3 - Lab 2: No Labs on Nov 11th and 12th
Design Skills
Material for the following lab modules can be found using the following links:
- Starting Nov 16 2009
- Week 1 - Lab 1: Lab Quiz 3 on Problem Solving
- Week 1 - Lab 2: Defining the problem: Use case diagrams
- Starting Nov 23 2009
- Week 2 - Lab 1: Use cases: Use case descriptions
- Week 2 - Lab 2: Planning: Comprehensive example including UI (form and report), excluding ER diagram
- Starting Nov 30 2009
- Week 3 - Lab 1: Prototyping: A simpler, comprehensive example including ER diagram
- Lab Quiz 4 (Part 1): Go to the Start
- Starting Dec 07 2009
Take Home Assignments
Material for the following take home assignments can be found using the following links:
- Assignment 1 on spreadsheets -- Due: Oct 13 2009, 11:59PM -- No extensions under any circumstances
- Assignment 2 on databases -- Due: Nov 09 2009, 11:59PM -- No extensions under any circumstances
- Assignment 3 on databases -- Due: Dec 04 2009, 11:59PM -- No extensions under any circumstances
TA Examples
The following links are examples to be used by Students and TAs for Lab Quizzes and Assignments.
- TA Examples for Spreadsheets
- TA Examples for Access
- TA Examples for JES
- TA Examples for Design Skills
Advanced Examples
The following links are examples of more advanced material to deepen concepts covered in lectures and labs
- Advanced Examples for Spreadsheets
- Advanced Examples for Databases
- Advanced Examples for Programming
- Advanced Examples for Design Skills
Note
If you the student are not familiar with the Office 2007 suite of software, it will be your responsibility to become more familiar with its applications and features. Take advantage of the Fluency textbook, as it provides you with more information and guides you through the Office 2007 applications.
Also, if you are not familiar with using the Windows Operating System, please refer to the Fluency textbook.
Tips for Success in Tutorials and on Lab Quizzes
- Before each tutorial, read the online lab notes for that tutorial.
- In tutorial ask questions, use the time to practice the skills beginning with a blank file. Take notes from the TA's mini-lecture, and use them to augment the online lab notes.
- After tutorial, review example files from online lab notes and TA examples. Do you understand the examples thoroughly. Answer questions in the TA examples
- At home, or during CT hours, practice by making up your own examples. If you think your example would help others, please post it to Student Examples above.
- A week before the Lab Quiz, review the skills list for that Lab Quiz, and practice those skills beginning with a blank file. The skills lists are on the Week 3 - Lab 2 link for each module, and also at: [Skills List]
- On the day of the Lab Quiz, arrive early, with any notes in hand, ready to write the Lab Quiz. If you've diligently followed the tips above, relax, you are well prepared and ready. Good luck!.
TAs Deadlines
- TAs have one week from the day of the quiz/assignment to submit the grades
Academic Misconduct Links
The following links are to inform you of the Universities Academic Misconduct Policies, and provide guidance so you do not commit Academic Misconduct in the course of completing assignments:
- U of C Honesty Policy
- U of C's definitions of Plagiarism/Cheating/Other Academic Misconduct
--Jey 09:10, 21 January 2009 (MST)
