|
|
 |
|
Main Page Introduction to Computer Applications |
|
|
|
Microsoft Excel Schedule / Assignments All Excel assignments (chapters 7 - 10) are due by October 31, 2008 for credit in term 1. No credit will be given for any work handed in after this date. The Excel final project will count towards your grade for term 2. The Excel Final Project is due by 11/14/08 for full credit. The last date to turn in the project (for partial credit) is 11/21/08.
Please See print requirements for submitting spreadsheets
Chapter 7 - 9
Introduction to Excel, cancel button, enter button, edit cell contents, gridlines, header & footers, column width, row height, format numbers, formulas for calculations, cell references in formulas, functions, display formulas, fit-to-one-page, round function, fill handle, paper orientation Please read chapter 7 to be sure that you are familiar with the topics listed above. We went over these in class but you may need to review the material before you begin to work on the class assignment. Items that must be turned in: 3. Review Questions - (page 7 - 25) #21 - #37, odd only (develop using Microsoft Word: spacing = 1.5, include your name, date, and the chapter number) Note: To get the formulas to display on a spreadsheet, press the control key and the tilde key at the same time. When you print the spreadsheets please be sure that the all of the formulas are displayed so that I can see exactly what you did. You will most likely have to use a landscape paper orientation and always be sure that the spreadsheets fit on one page. Chapter 8 Spreadsheet Techniques Lesson 8 focuses on the following topics of interest: Plan large spreadsheets, locate data and replace, copy & move, MAX, MIN, function command, absolute references, insert / delete rows & columns, margins, IF function
Please read chapter 8 to be sure that you are familiar with the topics
listed above. We went over these in class but you may need to review the
material before you begin to work on the class assignment. 1.
Net Provider -
***** You must
download this file and save it into your MY Documents / Excel
folder. 2. grades.xls - 3.
Payroll -
*****
You must download this file and save it into your MY Documents /
Excel
folder. 4. Exercise #7 - (page 8 - 19 Pizza Palace.xls (Continue to use your spreadsheet from Chapter 7 exercise #7.) HINT: Calculation of Menu Price for Exercise #7 - (page 8 - 19 Pizza Palace.xls The basic setup of the If functions is as
follows: In order to calculate the menu price of the pizza, we need to first determine the question and the 2 possible outcomes of the question. SO, I might at first set up my problem as follows: Question: Is the cost of Pizza > 4 Possible outcome 1 (Yes): If the pizza is > 4, then the menu price equals 2 times the cost Possible outcome 2 (No): If the pizza is not > 4,then the menu price equals 1.5 times the cost So, we'll have a function that needs to be setup something that looks like this: =IF (Cost of Pizza > 4, Cost of Pizza *2, Cost of Pizza * 1.5) Of course you'll have to put this in an
appropriate Excel function format! Chapter 9 Worksheets and Charts (from the handouts) Lesson 9 focuses on the following topics of interest: Use & print multiple sheets within a single workbook, copy & move data between sheets, refer to data in different sheets, charts (create, modify, format & print) Please read chapter 9 to be sure that you are familiar with the topics listed above. We went over these in class but you may need to review the material before you begin to work on the class assignment. Items that must be turned in:
1.
Car Sales.xls - *****
You must download this file and save it into your MY Documents
/ Excel folder.
2.
Continents.xls - *****
You must download this file and save it into your MY Documents /
Excel
folder.
3.
Plant Growth.xls - *****
You must download this file and save it into your MY Documents /
Excel
folder. Please staple all of the printed output from practices 6 & 7 together.
4. Exercise #7 - (page 9 - 27) Pizza Palace.xls
(Continue to use your spreadsheet from Chapter 8
exercise #7.)
5. Review Questions - (page 9 - 22) 1 - 15 odd
only (develop using Microsoft Word: spacing = 1.5, include your name, date, and
the chapter number) Chapter 10 Rotation Cycle 5 Chapter 10 Advanced Spreadsheet Techniques Lesson 10 focuses on the following topics of interest: What If?, sort data, CHOOSE, VLOOKUP, freeze Please read chapter 10 to be sure that you are familiar with the topics listed above. We went over these in class but you may need to review the material before you begin to work on the class assignment. ChooseVlookup.xls (class exercise) Items that must be turned in:
1. Payroll.xls - (Continue
to use your spreadsheet from Chapter 8 Practice 6)
2. grades.xls - (Continue
to use your spreadsheet from Chapter 8 Practice 7)
3.
Loan.xls - *****
You must download this file and save it into your MY Documents /
Excel
folder.
4. Exercise #7 - (page 10 - 22) Pizza Palace.xls
(Continue to use your spreadsheet from Chapter 9
exercise #7.) Additional Spreadsheet Formula Rank: Returns the rank of a number in a list of numbers. The rank of a number is its size relative to other values in a list. (If you were to sort the list, the rank of the number would be its position.) Syntax: RANK(number,ref,order) Number is the number whose rank you want to find. Ref is an array of, or a reference to, a list of numbers. Nonnumeric values in ref are ignored. Order is a number specifying how to rank number.
Duplicate Numbers RANK gives duplicate numbers the same rank. However, the presence of duplicate numbers affects the ranks of subsequent numbers. For example, in a list of integers, if the number 10 appears twice and has a rank of 5, then 11 would have a rank of 7 (no number would have a rank of 6). Items that must be turned in: Modify the following worksheets to include the RANK formula (print the formular and the non-formula worksheets when completed):
Payroll.xls: Rank (descending order) the Net Pay column |
|
| TOP Last Updated: 11/12/2008 This site was developed by Lori Alighieri | ||