SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 3 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 14 Oct 2017 My Price 10.00

Please make an Excel file follow the instruction attached below.

Take advantage of class/contact hours to clarify any ques±ons you have.Refer to the syllabus on Academic Dishonestyand group/individual work and allowable help for all projects – also remember it’s your responsibility to protect yourwork.Before you start-- read this whole assignment and use an op±onal text and/or review the tutorials as necessary.I’veposted a project overview as well as some individual skills ±ps.You want to create a spreadsheet to keep track of your grades in this class.From the syllabus, course grades arecalculated as follows:When ²nished, your grade calculator should look like this:Feel free to use di³erent colors, fonts, but keep the layout thesame.Details1.Open a blank workbook.Name it using your Last name followed by your ini±als and _ GradeCalc.xlsx.For Example:mine would be called WarnerBL_GradeCalc.xlsx.2.Type in the labels, grades and ±tles (black text above)3.Use the ‘merge and center’ feature on your ±tles to create one large cell with the text centered.4.Add background colors and borders to the cells5.The orange cells with red text above contain formulas.These formulas should include:oReferences to other cells
Background image of page 1
View the Answer
oFormulas you write using addiTon, subtracTon, division, mulTplicaTon, etc. and may have to be combinedwith funcTonsothese required funcTons:MIN – to idenTfy the drop gradesSUM – display totals and used in the ‘Percent Grade’ formulasIF – to be sure the ’Project Percent Grade w/EC’ doesn’t exceed 100SUMPRODUC± – used to ²nd the weighted average6.For the ‘Final Le³er Grade’ cell, ²rst create the grading scale cells (right) on another worksheetwithin your workbook.Give this block of cells a name (use the named range feature).On the²rst worksheet with the grades, use a VLOOKUP formula (with your named range) to determinethe le³er grade, based on the value in the ‘Final Weighted Average’ cell.7.±est your worksheet by entering all perfect scores and see if the average is 100% and the le³ergrade an A+.±hen enter the same scores as in the project sample at the top of these instrucTonsand see if your formula results match.8.Use Data ValidaTon to ensure that scores entered are within a reasonable range.For example, if an assignment isworth 20 points, be sure the points entered are between 0 and 20, include a custom input message and custom erroralert (messages that you write).±est your validaTon by trying to enter a grade outside the acceptable range.9.Worksheet ProtecTon: Once your project is working, protect your labels and formulas so that these cells can’t bemodi²ed.±he only cells that should be updateable will be the individual grade cells.Do not use a password on this.10.**Before you save your project for the last Tme, enter the grades on the screenshot sample at the top of theinstrucTons and save it.Submit it with these grades to show that your project calculates the ²nal grade correctly.We’ll change a few grades when we grade it to check the formulas more fully.Finishing Up11. Check your worksheet and be sure there are no errors or error symbols in your ²nished worksheet.If you don’t havethis feature come into the lab to do this step.12. Check your forma´ng – grades and formula results should be displayed with 1 decimal place.13. Check your formulas, be sure they are correct and make sense.For example, if you are subtracTng 2 numbers don’tuse the SUM formulas (sum is for adding).Excel may ²gure out what you mean, but we want the formulas to beused correctly and show that you understand how to use them.
Background image of page 2

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 14 Oct 2017 06:10 AM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)