To prepare, use the directions as follows:

Your workbook requirements are as follows:

  • Label all values and name the worksheet tabs.
  • Apply formatting such as bold text, colors, etc. as appropriate.
  • Save your workbook in .xlsx format.
      1. Create a new spreadsheet that contains three separate data sets. Place each dataset onto its own worksheet. Example lists of datasets are the following:
        1. Temperature of your city for the past 5-10 days
        2. Scored points per game of your favorite sports team for their past 5-10 games
        3. Amount you paid for gas for the past few months
        4. Miles flown/driven per day/trip etc. for the past month
        5. Most anything else you can tabulate or can track
      2. Use at least four different functions (e.g. SUM, MAX, AVERAGE, MIN, COUNT, etc.) to summarize each data set. You choose which to use, but be sure each worksheet has at least four. It is acceptable if the functions are common between the three sheets.

      Rubric

      CSCI 109 Module 4 Assignment Rubric
      CSCI 109 Module 4 Assignment Rubric
      Criteria Ratings Pts
      This criterion is linked to a Learning Outcome
      Part 1: Three separate data sets

      10.0 pts

      Proficient

      7.0 pts

      Competent

      5.0 pts

      Developing
      10.0 pts
      This criterion is linked to a Learning Outcome
      Part 1: Each data set on its own worksheet

      10.0 pts

      Proficient

      7.0 pts

      Competent

      5.0 pts

      Developing
      10.0 pts
      This criterion is linked to a Learning Outcome
      Part 1: Four different functions used with each data set (example: SUM; AVERAGE; MAX; MIN)

      20.0 pts

      Proficient

      14.0 pts

      Competent

      10.0 pts

      Developing
      20.0 pts
      This criterion is linked to a Learning Outcome
      Part 1: All values labeled

      10.0 pts

      Proficient

      7.0 pts

      Competent

      5.0 pts

      Developing
      10.0 pts
      This criterion is linked to a Learning Outcome
      Part 2: Correct function used: PMT

      20.0 pts

      Proficient

      14.0 pts

      Competent

      10.0 pts

      Developing
      20.0 pts
      This criterion is linked to a Learning Outcome
      Part 2: Interest and term correctly represented

      20.0 pts

      Proficient

      14.0 pts

      Competent

      10.0 pts

      Developing
      20.0 pts
      This criterion is linked to a Learning Outcome
      Part 2: Use of cell references in calculation

      10.0 pts

      Proficient

      7.0 pts

      Competent

      5.0 pts

      Developing
      10.0 pts

    • On another sheet of the same file, create a worksheet that contains data and a calculation determining monthly payments for a proposed purchase. Include the following:
    • Identify your dream vehicle (plane, automobile, boat, etc.) and estimate its cost and the interest rate if you financed its purchase.
    • Enter data (loan amount, interest rate, term, etc.) onto the spreadsheet and use the PMT function and cell references to determine the monthly payments.
    • Important! The spreadsheets must be original (student created) for this assignment; recycled files and templates are not permitted. Start with a new worksheet and create from scratch.

    Rubric

    CSCI 109 Module 4 Assignment Rubric
    CSCI 109 Module 4 Assignment Rubric
    Criteria Ratings Pts
    This criterion is linked to a Learning Outcome
    Part 1: Three separate data sets

    10.0 pts

    Proficient

    7.0 pts

    Competent

    5.0 pts

    Developing
    10.0 pts
    This criterion is linked to a Learning Outcome
    Part 1: Each data set on its own worksheet

    10.0 pts

    Proficient

    7.0 pts

    Competent

    5.0 pts

    Developing
    10.0 pts
    This criterion is linked to a Learning Outcome
    Part 1: Four different functions used with each data set (example: SUM; AVERAGE; MAX; MIN)

    20.0 pts

    Proficient

    14.0 pts

    Competent

    10.0 pts

    Developing
    20.0 pts
    This criterion is linked to a Learning Outcome
    Part 1: All values labeled

    10.0 pts

    Proficient

    7.0 pts

    Competent

    5.0 pts

    Developing
    10.0 pts
    This criterion is linked to a Learning Outcome
    Part 2: Correct function used: PMT

    20.0 pts

    Proficient

    14.0 pts

    Competent

    10.0 pts

    Developing
    20.0 pts
    This criterion is linked to a Learning Outcome
    Part 2: Interest and term correctly represented

    20.0 pts

    Proficient

    14.0 pts

    Competent

    10.0 pts

    Developing
    20.0 pts
    This criterion is linked to a Learning Outcome
    Part 2: Use of cell references in calculation

    10.0 pts

    Proficient

    7.0 pts

    Competent

    5.0 pts

    Developing
    10.0 pts
    Total Points:
    100.0

Get 15% discount on your first order with us
Use the following coupon
FIRST15

Order Now

Hi there! Click one of our representatives below and we will get back to you as soon as possible.

Chat with us on WhatsApp