Introduction to Computers Chapter 2 Assignment Sheet



Introduction to Computers Chapter 5 Assignment Sheet

Formatting Documents

Note: You are to continue working through the chapter until it is complete. Do not stop when Part I assignments are complete. Some will take longer than a day and some will take less than a day.

Remember to save all the assignments done in Chapter 5 to the EXCEL folder in your directory with the correct filename as directed in each practice or exercise. Turn in all the documents that you are directed to print out, as you complete them.

All documents printed out must have a header with your name left aligned, the file name (from the book) centered and this class period right aligned. You can follow the example at the top of this document.

Check off the practices and exercises as you turn them in.

Review Questions pages 225-226: 2, 3, 6, 8, 11-14, 16, 22, 24-28, 33, 35, 35, 36, 40)

Part 1

Read P 185 - 198 completing the practices as you come across them.

Practices:

______Grades Part 1 of 5 (Do the practice, but do NOT print)

______Grades Part 2 of 5 (Do the practice, but do NOT print)

______Examples (Do and print)

Part 2

Read P 199-211 completing the practices as you come across them.

Practices:

______Grades Part 3 of 5 (Do the practice, but do NOT print)

______Dept Memo

______Grades Part 4 of 5 (Do the practice, but do NOT print)

______Gadgets Invoice Part 1 of 2 (Do the practice, but do NOT print)

Part 3

Read P 212 - 221 completing the practices as you come across them.

Practices:

______Grades Part 5 of 5 (PRINT THIS PRACTICE - PRINT FORMULAS AND ATTACH BEFORE TURNING IN)

______Gadget Sales (Skip)

______Gadgets Invoice Part 2 of 2 (PRINT THIS PRACTICE - PRINT FORMULAS AND ATTACH BEFORE TURNING IN)

Begin the exercises (over)

Exercises

Follow the directions carefully – where the directions say to use a formula, you MUST use a formula for credit. Where the directions say use cell reference, you MUST reference a cell for credit.

For each of these exercises, you will print the spreadsheet and the formulas for that spreadsheet and staple them together before you turn them in.

_______ Exercise 2 Balance Sheet

_______ Exercise 3 Temp Conversion (Cells E3 and E5 must be formulas)

_______ Exercise 4 Metric Conversions (You must enter formulas in column C to calculate the metric values HINT: in cell C4 the formula is =A4 * 0.0283)

_______ Exercise 7 Personal Finances (Use one formula in cell E3 and use the fill handle to fill `down HINT: use the balance in the row above minus the debit of the current row plus the credit of the current row)

_______ Exercise 8 Income Statement

_______ Exercise 9 Franklin Tours (some files are Word documents and some are Excel spreadsheets so you have to open Word and Excel)

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download