Spreadsheet Lab
In this assignment I would like you to create a spreadsheet that shows the options you have for purchasing software for a new business.
Your spreadsheet should account for the following factors:
  • Number of people at the business -- start with 25 but it should be a variable that you can change as the business grows
  • The functions needed to run the business -- let's make it a resort so you will need Reservations software, Accounting software, Timesheet software and some sort of Office software
  • Options between expensive, top-of-the-line software and inexpensive software
    **NOTE** You should try to provide 3 or more options
Since this is also a spreadsheet assignment, you should meet the following criteria:
  • A title that spans the top of your spreadsheet
    • Make it bold and in a larger font
  • Give your table some pizazz -- colored borders, colored cells, font changes -- things that will make your table stand out
  • A place to put the number of employees
  • Set the 3 or more options up in columns
  • Set up the rows for each type of software
  • Show the individual price for the software
  • Show the price for your business (25 copies)
    • I would like this number to change if I change the number of employees
  • Create totals for each option at the bottom of the columns
    Students should use formulas to add up column totals. Those who use these will receive more points than those who do not
NOTE: You can use Microsoft Excel, Open Office Numbers or the Libre Office spreadsheet app to do this assignment.
Attach your document to an email with 'CIS 110 - Lab 3 ' as the subject. Don't forget to include your name in the body of the email.
Return to Assignment Index