Instrucciones

docx

School

Embry-Riddle Aeronautical University *

*We aren’t endorsed by this school

Course

202

Subject

Computer Science

Date

Feb 20, 2024

Type

docx

Pages

Uploaded by AmbassadorIce439

Instrucciones Module 4 - Assignment: Spreadsheet/Workbook Pt. 2 100 Possible Points Due: Sun Sep 3, 2023 11:59pm In Progress Attempt 1 & l O NEXT UP: Submit Assignment @ Add Comment Unlimited Attempts Allowed v Details Module 4 Assignment ‘ Spreadsheet/Workbook ] Description For this assignment, you will submit an Excel spreadsheet applying formulas and functions to the workbook created last in the last module. Read all the instructions in this module item and view the required tutorials before you begin. If you are familiar with the 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 (DOCX) ¥, « Read: Excel Formulas: Functions (GFC Global) & « Read:|Excel Formulas: Using the IF Function (GFC Global) E‘H Instructions Spreadsheet Functions Part 1 Access the file you posted in the last module and Save As the same file name but add 'Part 2 to the end of the file name. « Use at least two different functions (e.g. SUM, MAX, AVERAGE, MIN, COUNT, etc.) to summarize each data set created in the last module. o Use cell ranges with these and do not use the same functions on both sheets. o Use yellow cell highlighting to signify the location of the functions. o Ensure any decimals depict meaningful values. i.e., are limited to one or perhaps two decimal places. To illustrate, noting the average temperature was 71.23456 degrees is not meaningful to most people. Write this as 71 degrees or perhaps 71.2 degrees. « Next, create an IF statement that evaluates at least one cell on each sheet. o For example, you might create a function to evaluate the results of the SUM function. It might read something like: IF the cell > 100 then 'True' else 'False'. Or perhaps you might compare scores in a game to have the text 'Win' or 'Loss' appear based on the cell values evaluated. o Be sure to add a label next to the cell that contains the IF statement. o Feel free to be creative but be sure to use cell references here. o As needed, reference the tutorials and the help areas within Excel. Knowing how to access Help is an important skill. Spreadsheet Functions Part 2 On a new 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 annual interest rate if you financed its purchase. « Enter text labels in Column A for Loan Amount, Interest Rate (APR), Term in Years, Payment, etc., onto the spreadsheet. « Enter the numbers for each item in Column B, except the monthly payment of the course. We'll use a function to determine this. « Apply appropriate number formatting (currency, percentage) where appropriate. « To calculate the monthly payments, use the PMT function with cell references. Ensure you are converting the term and interest per the tutorial. Do so within the function.

Requirements « Utilize cell references with all functions and formulas. « Apply text and number formatting. « Save your workbook in .xlsx format. Use a naming convention that includes your first and last name and the activity number (or description). Do not add punctuation or special characters. Refer to the assignment rubric for detailed grading criteria. © This activity supports Module Objective 8 and Learning Outcome 1. v View Rubric CSCl 109 Module 4 Assignment Rubric (1) Criteria Ratings Pts Part 1: Two separate data sets on 10 pts 7 pts 5 pts renamed worksheets Proficient Competent Developing /10 pts view longer description Part 1: Two different functions used with each data set (example: SUM; AVERAGE; MAX; MIN); functions are 20 pts 14 pts 10 pts different between the data sets; Proficient Competent Developing / 20 pts cell references and a range of cells are using with the functions; limited decimal places view longer description Part 1: IF statement correctly 20 pts 14 pts 10 pts evaluates at least one cell on Profic c Dvelont both data sets soncient ompetent eveloping / 20 pts view longer description Part 1: All values labeled ADpts 7ot 2P Proficient Competent Developing / 10 pts view longer description Part 2: Correct function used: 10 pts 7 pts 5pts PMT; number formatting applied. Proficient Competent Developing /10 pts view longer description Part 1: All values labeled . pts_ Zpts 2pt y Proficient Competent Developing / 10 pts view longer description Part 2: Correct function used: 10 pts 7 pts 5pts PMT; number formatting applied. Proficient Competent Developing / 10 pts view longer description Part 2: Interest and term 20 pts 14 pts 10 pts correctly represented Proficient Competent Developing / 20 pts view longer description Part 2: Use of cell references in 10 pts 7 pts 5pts calculation Proficient Competent Developing /10 pts view longer description Total Points: O Video que el profesor envio para referencia. https://www.youtube.com/watch?v=-9d4m79twdA&ab channel=GCFLearnFree

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Related Documents

HW3-2.py

Lab 6 Network Enumeration (W2024).pdf

Lab3 Troubleshoot Static and Default Routes.docx

Amoebiform_zoharite_tugboat.docx

74803025.pdf

CECS 524 Program 3 DP Decorator_030849570.pdf

MAT-FPX2001_TemenMelissa_Assessment2-2.docx

ECE668 Quiz3.docx

POD 2403 HR Analytics Assignment #2.docx

CPR workshop4.docx

Review Q & A-4.docx

CPR 10.docx

Recommended textbooks for you

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:9781337508841

Author:Carey

Publisher:Cengage

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

Computer Science

ISBN:9780357392676

Author:FREUND, Steven

Publisher:CENGAGE L

Microsoft Visual C#

Computer Science

ISBN:9781337102100

Author:Joyce, Farrell.

Publisher:Cengage Learning,

Programming with Microsoft Visual Basic 2017

Computer Science

ISBN:9781337102124

Author:Diane Zak

Publisher:Cengage Learning

C++ for Engineers and Scientists

Computer Science

ISBN:9781133187844

Author:Bronson, Gary J.

Publisher:Course Technology Ptr

CMPTR

Computer Science

ISBN:9781337681872

Author:PINARD

Publisher:Cengage

SEE MORE TEXTBOOKS

Recommended textbooks for you

Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Microsoft Visual C#
Computer Science
ISBN:9781337102100
Author:Joyce, Farrell.
Publisher:Cengage Learning,
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
C++ for Engineers and Scientists
Computer Science
ISBN:9781133187844
Author:Bronson, Gary J.
Publisher:Course Technology Ptr
CMPTR
Computer Science
ISBN:9781337681872
Author:PINARD
Publisher:Cengage