2 - CSI 1306F HOMEWORK 02 From Lecture 4 Excel part 1 1...

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

View Full Document Right Arrow Icon
CSI 1306F – HOMEWORK 02 From Lecture 4: “Excel – part 1” 1. Complete the following cash flow forecast worksheet: A B C D E 1 Monthly Budget 2 Monthly Income = Hourly Pay Rate 37.83 3 Nr. Hours Worked 32.5 4 EXPENSES 5 Rent 300 6 Hydro 50 7 Heat (Gas / Oil) 50 8 Cable 30 9 Car Insurance 0 Note: The tax amounts to 15% of the total income 10 Car Payment 0 11 Gas 0 12 Phone 70 13 Cell Phone 30 14 Food 300 15 Taxes = 16 Total Expenses = 17 Net Per Month = 2. Student Marks: c Draw the layout of the marking sheet for this course (follow marking scheme in lecture 1 omitting the bonus point system) c Fill your worksheet with fictitious data from at least five students. c Compute the final mark for each student according to the marking scheme. c Include a column with a text label indicating whether the student passed or failed. c Compute the class’ average final mark and the percentage of students who failed. c
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 09/01/2010 for the course COMPUTER S CSI1306 taught by Professor Aziri during the Spring '10 term at University of Ottawa.

Page1 / 2

2 - CSI 1306F HOMEWORK 02 From Lecture 4 Excel part 1 1...

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