CSC101: Introduction to Computer Education

Fall 2007

Project 2

Deadline: November 10, 2007

Excel

Requirement:

1. Use Excel to produce the following course scoring document for CSC101. The course grading policy is described in the course syllabus. Your Excel document should include two worksheets:

• The first worksheet shows 20 students with their grades for attendance, homework, project, midterm test, and presentation, as well as the total, where the total should be defined as a formula in terms of the grading policy.

• The second worksheet shows a simple curve similar to the curves in the course webpage for homework and midterm test.

2. Use Excel to produce a pizza calculator as below.

Pizza Calculator
Find out how much you are paying for a square inch of pizza.
Instructions:
1	Find out the diameter of the pizza, in inches
2	Record that information in the red box below
3	Find out the price of the pizza, before taxes
4	Record the price in the yellow box
	See the price per square inch in the green box
Next	Repeat the process with a different size or brand pizza
size, in inches		18
price, in dollars		$9.95
Cost of the pizza, in cents per square inch					3.91

The cents per square inch is defined according to the size and prize.

1. Use Excel to produce a temperature calculator.

Temperature Converter
	Enter a temperature reading in one of the yellow boxes.
	Convert Fahrenheit to Celsius
	Enter the Fahrenheit temperature below
		88.6
	The Celsius temperature is:
		31.4
	Convert Celsius to Fahrenheit
	Enter the Celsius temperature below
		37.0
	The Fahrenheit temperature is:
		98.6
	Note: Change only the numbers in the yellow boxes. Each time you close
	Excel, do not save the changes. Do not enter data into the green boxes

The conversion between the Fahrenheit temperature and the Celsius temperature should be updated accordingly automatically when one of them is changed.

Submission:

• You have to send your three Excel documents required above to the instructor at jhan@csudh.edu as attachments of an email.

• Hard copy of documents will not be accepted.