ENGR 1111-F10 Excel Assignment

ENGR 1111-F10 Excel Assignment - Introduction to...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Introduction to Engineering, ENGR 1111, Secs 307, 313, 315, 317, &320 Fall 2010 MICROSOFT EXCEL ASSIGNMENT – Total Points Available = 100 DUE BEGINNING OF CLASS Nov 2-4, 2010 Identify the costs of the following items for the Fall 2010 semester using your fee statement from the OSU Bursar’s office, textbook receipts, housing contract, and any appropriate estimates. Note: If you are not required to pay a particular fee, use zero for that fee. If you do not have a copy of your fee statement on hand, you may obtain the information on the web at: bursar.okstate.edu/tuition.html. If you are concerned about privacy, you can estimate reasonable charges for a typical student. 1. Tuition $/credit hour 2. Student Activity Fee $/credit hour 3. Student Facility Fee $/credit hour 4. Student Union Renovation $/credit hour 5. Advising & Assessment Fee $/credit hour 6. Library Automation & Tech Fee $/credit hour 7. Academic Records Fee $/credit hour 8. Daily O’Collegian Fee $/credit hour 9. Student Development Fee $/credit hour 10. Health Services Fee $/credit hour 11. Consumable Materials Fee $/credit hour 12. Academic Facilities Fee $/credit hour 13. Academic Excellence Fee $/credit hour 14. Energy Fee $/credit hour 15. Life Safety & Security Fee $/credit hour 16. Parking & Transit Fee $/credit hour 17. University Tech. Infrastructure Maintenance Fee $/credit hour 18. Engineering Technology Fee $/credit hour 19. Engineering Facilities/Equip. $/credit hour 20. Academic Excellence Fee $/credit hour 21. New Student Orientation & Enrollment Fee $/semester (one time) 22. International Student Status/ Maintenance Fee $/semester 23. Health Risk Assessment Fee $/semester (first time students only) 24. Late Enrollment Fee $/semester 25. Textbooks & school supplies $/semester 26. Room/apartment (your share) $/semester 27. Board (food) $/semester 28. Miscellaneous expenses $/semester (leisure, car, etc) Use Microsoft Excel to implement the following: A. Prepare and print a table to calculate your costs for one semester. The following columns should be included and labeled in the table: item (i.e. Tuition, Student Union Renovation, etc), $/credit hour or $/semester, # of credit hours or semesters, cost of each item for one semester, and the % cost of each item relative to the total cost. The total cost of all items for the semester must (O V E R) Page 2 of 2 MS Excel Assignment, ENGR 1111 Fall 2010 also be shown by adding the costs of each item. You must use the Excel spreadsheet for all calculations. B. Prepare and print a pie graph, in multiple colors (i.e., just black and white is not acceptable), showing the % cost of each item. The pie graph should be appropriately labeled such that someone else can easily read the graph. Choice of good font, font size, and placement of labels is important. C. Prepare and print a bar graph, in multiple colors (i.e., just black and white is not acceptable), showing the actual cost in dollars of each item. The bar graph should be appropriately labeled such that someone else can easily read the graph. Choice of good font, font size, and placement of labels is important. Turn in all work on hard copy (i.e. paper) at the start of class on Nov 2-4, 2010, including your printed name and your ENGR 1111 section number. YOU MUST PRINT YOUR HARD COPY IN COLOR. Therefore, you must find, well ahead of when the assignment is due, a color printer where you can print your results in color!! Black and white print will not be accepted. ...
View Full Document

This note was uploaded on 11/28/2011 for the course ENGR 1111 taught by Professor Staff during the Fall '08 term at Oklahoma State.

Ask a homework question - tutors are online