Project

P2 - Spreadsheets (Derrick)

Overview of project

• Author: Derrick Whittle
• Indices on this project:
  • Example Of-P2-Spreadsheet
  • Design Issue-Gen-Spec
  • Design Issue-Whole-Part
  • Example Of-OOP-HIC (GUI)
• Complexity of this project: Medium
• What you will have when you're done: The result of this project is three spreadsheets, in one of them the values of all cells are displayer, while in the other two sum and average values are calculated and shown.
• Strategy for this problem: (Many thanks to Derrick Whittle for allowing us use of his design document and code for STABLE!)

  Derrick's approach to this project in 2390 W96 was to make an abstract class Spreadsheet, and all the results, including average and sum, are all displayed in a Spreadsheet. He used a class called LinkedSpreadsheets, which is also a subclass of Spreadsheet, to "link" spreadsheets together.

Steps in this project

• Problem Statement -- Create linear spreadsheet objects
• Problem Domain Analysis
• Design of Spreadsheet Classes
• Object Interactions
• Build the Program: SpreadSheet classes and LinkedSpreadSheet classes, as well as the view-container class for them.
• Reflect on potential reuse of this project

Representations of this project

• Steps in the Procedure

Concepts used in this project

• What is a Human-Interface Component (HIC)
• What is a Problem-Domain Component (PDC)?
• What is a generalization-specialization (gen-spec) relationship?
• What is the Model-View-Controller paradigm?

Generics appearing in this project

• How to build a GUI using the C+N library