Courses/Computer Science/CPSC 203/CPSC 203 Template/Winter 2010 Lab Manual

From wiki.ucalgary.ca
Jump to: navigation, search

Labs Template

Three modules

  1. Problem Solving with Spreadsheet
  2. Problem Solving with Database
  3. Problem Solving with Alice Programming


Modules 1 and 2 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.

There will be 2 Take Home Assignments -- one on Spreadsheets, and one on Databases.

CPSC 203 Lab and CT Hour Schedule

/CPSC203 Winter 2010 Lab and CT Hour Schedule

Lab Resources

The following software is available on the lab computers:

Officeware: MSOffice, OpenOffice

Analysis: R

Databases: Sqlite

  • 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 Jan 18 2010
Week 1 - Lab 1: Introduction to Spreadsheets and Basic Calculations (revision)
Week 1 - Lab 2: Complex Calculations, If-Then Statements, and Pivot Tables
  • Starting Jan 25 2010
Week 2 - Lab 1: Charts and Visual Design Rules
Week 2 - Lab 2: Spreadsheet Design Rules
  • Starting Feb 1 2010
Week 3 - Lab 1: Analysis, Forecasting, Sorting, and Filtering
Week 3 - Lab 2: Spreadsheets review
  • Starting Feb 8 2010
Week 4 - Lab 1: Lab Quiz on Spreadsheets
Week 4 - Lab 2: No labs on Feb 10th and Feb 11th

Database

Material for the following lab modules can be found using the following links:

  • Starting Feb 22 2010
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 Mar 1 2010
Week 2 - Lab 1: Multi-table queries, Aggregate Queries
Week 2 - Lab 2: Crosstab queries and Custom Calculations
  • Starting Mar 8 2010
Week 3 - Lab 1: Query Analysis Examples (Union and append queries)
Week 3 - Lab 2: Databases review

Problem Solving

Material for the following lab modules can be found using the following links:

  • Starting Mar 15 2010
Lab Quiz on Databases|/Week 1 - Lab 1: Lab Quiz 2 on Databases
Problem Solving Week 1 - Lab 2: Introduction to Alice; create project teams
  • Starting Mar 22 2010
Problem Solving Week 2 - Lab 1: Flow-charts, do in order, do together
Problem Solving Week 2 - Lab 2: Conditionals and loops
  • Starting Mar 29 2010
Problem Solving Week 3 - Lab 1
Problem Solving Week 3 - Lab 2
  • Starting Apr 5 2010
Problem Solving Week 4 - Lab 1
Problem Solving Week 4 - Lab 2: Groups work on project
  • Starting Apr 12 2010
Problem Solving Week 5 - Lab 1: Groups work on project
Problem Solving Week 5 - Lab 2: Groups work on project

Take Home Assignments and Project

  • Assignment 1 on spreadsheets -- Due: Feb 12, 11:59PM -- No extensions under any circumstances
  • Assignment 2 on databases -- Due: Mar 23, 11:59PM -- No extensions under any circumstances
  • Project on Alice programming -- Due: Apr 16, 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.

Advanced Examples

The following links are examples of more advanced material to deepen concepts covered in lectures and labs

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

  1. Before each tutorial, read the online lab notes for that tutorial.
  2. 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.
  3. After tutorial, review example files from online lab notes and TA examples. Do you understand the examples thoroughly. Answer questions in the TA examples
  4. 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.
  5. 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]
  6. 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:

--Jey 09:10, 21 January 2009 (MST)