Module 4 – Assignment: Spreadsheet/Workbook

Description

Description For this assignment, you will create several spreadsheets in an Excel® workbook and demonstrate different functions. Read all the instructions in this module item and view the required tutorials before you begin. If you are familiar with functions used in Excel, you will still want to review these to see what is expected. To prepare, use the directions as follows: Read Excel Formulas and Functions (PDF). View the videos # 1, 3-10, and 13-16 in the playlist Microsoft Excel 2016 (YouTube).  (Links to an external site.) Viewing other titles is optional. Need Excel? Go to the Productivity Software page. 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.  Instructions View each section and complete both parts. Spreadsheet Functions Part 1: Spreadsheet Functions Part 2: Create a new spreadsheet that contains three separate data sets. Place each dataset onto its own worksheet. Example lists of datasets are the following: Temperature of your city for the past 5-10 days Scored points per game of your favorite sports team for their past 5-10 games Amount you paid for gas for the past few months Miles flown/driven per day/trip etc. for the past month Most anything else you can tabulate or can track 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 pts Proficient 7 pts Competent 5 pts Developing 10 pts This criterion is linked to a Learning Outcome Part 1: Each data set on its own worksheet 10 pts Proficient 7 pts Competent 5 pts Developing 10 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 pts Proficient 14 pts Competent 10 pts Developing 20 pts This criterion is linked to a Learning Outcome Part 1: All values labeled 10 pts Proficient 7 pts Competent 5 pts Developing 10 pts This criterion is linked to a Learning Outcome Part 2: Correct function used: PMT 20 pts Proficient 14 pts Competent 10 pts Developing 20 pts This criterion is linked to a Learning Outcome Part 2: Interest and term correctly represented 20 pts Proficient 14 pts Competent 10 pts Developing 20 pts This criterion is linked to a Learning Outcome Part 2: Use of cell references in calculation 10 pts Proficient 7 pts Competent 5 pts Developing 10 pts Total Points: 100

 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"
Order Now

Need assignment help for this question?

If you need assistance with writing your essay, we are ready to help you!

OUR PROCESS

Order

Payment

Writing

Delivery

Why Choose Us: Cost-efficiency, Plagiarism free, Money Back Guarantee, On-time Delivery, Total Сonfidentiality, 24/7 Support, 100% originality