Excel Assignment - Excel Assignment #1 For information on...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Excel Assignment #1 For information on how to do any of these processes, search the Excel help or go to www.microsoft.com/ office Exercise 1: Student Grade Book (expected time – less than 45 minutes) Learning Objective : Become familiar with aggregate functions (sum, average, standard deviation, max, min, etc.) and complex IF statements. Please download the spreadsheet Excel Assignment #1 Worksheet.xls from Blackboard. Click on worksheet E1 (you may be in Worksheet E1 by default). This spreadsheet keeps track of students’ grades. There are two exams – Exams 1 and Exam 2. There are two more columns – Total Weighted Score and Final Grade. Exam 1 is weighted 35% of the total, and Exam 2 is weighted 65% of the total. These weights are in cells B4 & C4. (Hint: you might want to use absolute cell references when referring to these cells.) Please do the following : (a) Find the total weighted score for the semester based on Exam 1 and Exam 2 and their respective weights. (i.e., Exam 1 * Weight 1 + Exam 2 * Weight 2) This formula belongs in the Weighted Total column. (b) Find the average (AVERAGE), standard deviation (STDEV), maximum (MAX), and minimum (MIN) for Exam 1, Exam 2 and Total Weighted Score. (Use INSERT FUNCTION and select “Statistical” from the category drop down box.) Put these formulas in cells C40:D43, as appropriate. (c) Assign a grade for each student based on the following rule: If Total >=90, then the grade is an A; between 80 and 89.99 it is a B; between 70 and 79.99 it is a C, otherwise D. Please use an IF statement to calculate the grade. Here you will use a nested IF. That is an IF statement within an IF statement. Place this formula in the Final Grade column for all students. Consider the following hypothetical example.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 06/24/2011 for the course MIS 301 taught by Professor Mccleod during the Fall '08 term at University of Texas at Austin.

Page1 / 4

Excel Assignment - Excel Assignment #1 For information on...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online