| CSC1009 Quiz 7 | Contact Info |

   
Herbert J. Bernstein Professor of Computer Science
Dept. of Mathematics and Computer Science, 1300 William Floyd Parkway, B205, Shirley, NY 11967

90466 CSC 1009N -- Introduction to Spreadsheets and Data Analysis -- Fall 2012
Online Course

Quiz 7

 

This web page is http://www.bernstein-plus-sons.com/.dowling/CSC1009F12/CSC1009_Quiz_7.html
Copyright © 2009, 2012 Herbert J. Bernstein and other parties. All rights reserved.

This is the weekly quiz for 1 November 2012 for the CSC 1009 course. Please do this quiz after you have completed the rest of assignment 7. It should take between one half hour and 2 1/2 hours to complete if you are well prepared, longer if not.

  <==== Do this AFTER you've answered all the questions

You probably DON'T want to do this ===>  

Please fill in the following information:

Name:


Email:

Skype ID:

  1. Carefully, and in detail, explain what a simulation spreadsheet is and give a detailed example of a practical application of a simulation spreadsheet.

  2. Assume you are a teacher trying to grade your students fairly on an assignment that has a numeric grade between 0 and 37. There are 17 students in the class. Design a spreadsheet into which you can type the 17 grade in 17 separate cells, A1, A2, ..., A17. In answer to this question, Write the formula to put into cell B18 to compute the average numeric grade, and into cell B19 to compute the maximum numeric grade.

  3. Continuing the previous question, write a formula for cell B20 to compute the number of students with better than average grades.

  4. Continuing the previous question, write the formula to put in cell B1 to compute the amount by which the student's grade in A1 is higher than the class overage, divided by the amount by which the maximum grade is higher than the class average. Design the formula so that it can be copied to cells B2, ... B17 and work correctly.

  5. Continuing the previous question, write the formula to put in cells C1, to assign a letter grade of A to that student if the amount in B1 is greater than or equal to .8, to assign a letter grade of B if the amount in B1 is greater than or equal to .3, to assign a letter grade of C if the amount in B1 is greater than or eaual to -.3 and a grade of D, otherwise. Design this formula so it can be copied from cell C1 to cells C2, ... C17 and work correctly.

  6. Now evaluate the spreadsheet you have just created and write a short essay on how you might improve it to grade more fairly and to avoid cases that might cause it to malfunction.

  7. Report on your progress on your simulation project for the past week.

  <==== Do this AFTER you've answered all the questions

You probably DON'T want to do this ===>  

Revised 27 October 2012