| CSC1009 Quiz 8 | 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 8


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

This is the weekly quiz for 8 November 2012 for the CSC 1009 course. Please do this quiz after you have completed the rest of assignment 8. 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:



Skype ID:

  1. Carefully, and in detail, explain the characteristics of a good gradebook spreadsheet for use by a teacher.

  2. Carefully and in detail explain the characteristics of a good course management spreadsheet for use by a student.

  3. Carefully and in detail describe how you could populate column A of a spreadsheet with all the dates for an entire year.

  4. Continuing the previous question, assume you have all the days of the year in column A, and assignments due for one course entered by their due date given in column A and the text of that assignmentin column B, assignments due for a secondcourse entered by their due date given in column A and the text of that assignment in column C, etc, through column F. Write a formula to put in the cells of column G to give a count of the assignments that are due either that day or in the 7 days prior.

  5. Continuing the previous question, explain how you would track late assignments on the same spreadhseet.

  6. Now give the URL of the blog entries for the spreadsheets you did for assignments 7 and 8.

  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