_____________________________________________________________________
Case | Wizard Works
______________________________________________________________________________________________________________
Andrew Howe owns and operates Wizard Works, an online seller of fire-works based in Franklin, Tennessee. Andrew wants you to help him use Excel to develop an order form for his business. The form needs to contain formulas to calculate the charge for each order. The total charge is based on the quantity and type of items ordered plus the shipping charge and the 5% sales tax. Orders can be shipped using standard 3 to 5 day shipping for $4.99 or overnight for $12.99. Andrew is also offering a 3% discount for orders that exceed $200.00. Both the shipping option and the discount need to be calculated using formulas based on values entered into the worksheet.
Click here to open and print out the instruction.
____________________________________________________________________
Case | Chemistry 303
_____________________________________________________________________________________________________________
Karen Raul is a professor of chemistry at a community college in Shawnee, Kansas. She has started using Excel to calculate the final grade for students in her Chemistry 303 course. The final score is a weighted average of scores given for three exams and the final exam. Karen wants your help in creating the formulas to calculate the final score and to summarize the class score on all exams. One way to calculate a weighted average is by multiplying each student’s exam score by the weight given to the exam, and then totaling the results. For example, consider the following four exam scores:
• Exam 1 = 84
• Exam 2 = 80
• Exam 3 = 83
• Final Exam = 72
If the first three exams are each given a weight of 20% and the final exam is given weight of 40%, the weighted average of the four scores is:
84*0.2 + 80*0.2 + 83*0.2 + 72*0.4 = 78.2
Karen already entered the scores for her students and formatted much of the workbook. She wants you to enter the final formulas and highlight the top 10 overall scores in her class.
Click here to open and print out the instruction.
