CIS 150 Spreadsheet Assignment

Due: April 28, 1999

We Do Computers, Inc., a local company, has asked you to set up an accounting system for several of its customers. To do this, you will develop a set of templates from which work sheets will be prepared. A template is a spreadsheet with labels, formulas, and charts predefined, a framework for the collection of data. The templates for your system are described below.

Template 1 A quarterly report template to capture information for each customer for each month in a quarter with monthly and customer summaries.
Template 2 A semi-annual report to capture information for each customer for each month on a semi-annual basis with monthly and customer summaries.
Template 3 A quarter-by-quarter annual report to capture totals information for each customer by quarters for a year with quarterly and customer summaries.


Using the data provided, you will simulate the actions of the customers over the course of a year. At the beginning of each quarter, you will use a copy of Template 1 to start a new page for each quarter. At the end of each month, you will enter the data for that month (using Template 1), accumulate semi-annual data (using Template 2), accumulate quarter-by-quarter annual data (using Template 3). The following items are required for submission.
  1. A printed copy of each of your templates displaying the formulas (3 total)

  2. A printed copy of each quarterly report displaying results (4 total)

  3. A printed copy of both semi-annual reports displaying results (2 total)

  4. A printed copy of the quarter-by-quarter annual report displaying results (1 total)

  5. A pie chart from quarter 3 using totals data (1 total)

  6. A bar chart from one of the semi-annual reports (1 total)

  7. A stacked bar chart from the quarter-by-quarter annual report (1 total)

  8. Prepare in report format with a word processed title page and highlighting and labeling all components to be graded.
All charts are to be fully labeled and have legends for each data grouping.

Name
Jan
Feb
Mar
Apr
May
Jun
Your Name
4335
3454
4852
5675
4374
5842
Schmidt
4581
4874
5258
3598
5547
4658
McGraw
5214
2354
4215
5367
4155
5865
Ripken
4258
4341
5844
5345
4468
5941
Griffey
4536
4374
5414
5367
4974
5624
Salvino
3848
1579
6151
8383
2135
6121


Name
Jul
Aug
Sep
Oct
Nov
Dec
Your Name
5231
4741
5642
4834
4422
4325
Schmidt
5841
4988
4752
5847
6124
5642
McGraw
5418
4552
4469
5314
4854
6611
Ripken
4988
4555
5125
6717
5423
4355
Griffey
5224
4212
5712
6045
4545
4215
Salvino
2551
2831
5605
6100
4815
4112


The maximum grade for minimum submission is 85.

Ideas for extra credit include:

In the following templates the label in cell C1 is We Do Computers, Inc

When you print out these pages, the templates will probably be split up, but I think you will be able to piece them together. If the templates are broken up and you have to put them back together, then you can always look back at this page to make sure you are using the right template.
Template 1
Template 2

Template 3