Week

Course Technology Excel 2003
Special Instructions
CIS 100

Note initially the requirements of the Class Standard for printing worksheets/formula sheets: Each (and every) worksheet will be set up (File, Page Setup) in Landscape Orientation/Fit to One page (Page Tab). Each worksheet will be centered both Vertically and Horizontally (Margins Tab). Each worksheet will contain a Custom Header (only/never a footer) comprised of your name, the File Name of the workbook, and the Date the workbook is printed. Use the appropriate buttons on the Header Toolbar for the File Name and the Date (Header/Footer Tab). When printing a formula sheet (the formula version of a worksheet which can be revealed in a number of ways, such as Tools, Options, View, Formulas), print the Gridlines and the Row and Column Headings (Sheet Tab). This (Gridlines and Row/Column Headings) applies only to a formula sheet. All charts will be placed on separate worksheets, not embedded and will contain the Standard Header (Name, File Name, Date). Please note well that these requirements supersede, override, take the place of – however one may wish to express it – any contrary instructions in the text. If in doubt, check the Class Standard at http://www2.volstate.edu/rdh/Class%20Standard%20Page%20Setup.xls.

Each (and every) assigned worksheet, formula sheet and chart will be printed and included under the Excel Tab of your CIS 100 Portfolio. By my count, your Portfolio will therefore contain 62 pages. These pages must be in the order they appear in these instructions and they must be further arranged thusly: First the Documentation or Title sheet, then the work sheet, then the formula version of the worksheet, followed by any charts (in the order they were prepared) that are a part of a particular assignment. Additionally, on all Documentation sheets, use the function =TODAY() for the date the worksheet was created, and if necessary, format the cell containing today's date thusly: Month [spelled out] Day, Year [in four digits].

Course Technology Excel 2003 Special Instructions [1] CIS 100
Excel Assignment	Excel Workbook	Special Requirement(s)
Tutorial 1
Tutorial	Dalton
Review Assignments	Dalton2 Dalton3	Print both Dalton2 and Dalton3. Do not print Dalton3 until the workbook has been saved under the new file name.
Case Problems
1.	CFlow2 CFlow3	Use the SUM function when adding more than two Cell References. Add a colon after the word, “Surplus,” in Cell A20. Format Cell References C6:C20 as numbers with commas, no decimals. Print both CFlow2 and CFlow3.
2.	Balance2	Use the SUM function when adding more than two Cell References.
3.	Site2	Not Assigned
4.	Budget	Not Assigned

Course Technology Excel 2003 Special Instructions [2] CIS 100
Excel Assignment	Excel Workbook	Special Requirement(s)
Tutorial 2
Tutorial	Budget2 Budget3	Print both Budget2 and Budget3. On the “Loan Analysis” worksheet format the following cells as currency showing two decimals: B9; B20; B22; E11; and E15. Format the following cells as currency showing no decimals: B4:B6; B10:B19; E4; and E14.
Review Assignments	Family2 Family3	Not Assigned Not Assigned
Case Problems
1.	Stock2	Print entire work sheet, not just the portion of the work sheet requested in the text.
2.	Maxwell2	Not Assigned
3.	Sonic2	If necessary, review pages EX 58-60 concerning relative cell references versus absolute cell references. The use of the IF function is required in F13:F45 and E13:E45. Print only one version of this workbook, either the one that has health care costs of $6,500 and $5,500 or the one with health care costs of $7,000 and $6,100, but not both.
4.	Soup2	Not Assigned

Course Technology Excel 2003 Special Instructions [3] CIS 100
Excel Assignment	Excel Workbook		Special Requirement(s)
Tutorial 3
Tutorial	Sales2	Remember the Class Standard. Do not use any page breaks or print ranges. Do not use any footers, only the standard header.
Review Assignment	Region2	Remember the Class Standard. Do not use any page breaks or print ranges. Do not use any footers, only the standard header.
Case Problems
1.	Running2	In addition to the written instructions match figure 3-40 at page EX 138, except change the font color to white, not yellow, in the first three rows of the worksheet.
2.	WBus2	Not Assigned
3.	Blades2	Add colons on the Documentation worksheet after the text in cells A3:A5. For cells B10:I10, B15:I15, B20:I20, and B25:I25, use white font color, not the font colors specified in the text. In addition to the written instructions, match figure 3-42 at page EX 140.
4.	Payroll2	Not Assigned

Course Technology Excel 2003 Special Instructions [4] CIS 100
Excel Assignment	Excel Workbook	Special Requirement(s)
Tutorial 4
Tutorial	Vega2		Print Documentation Sheet, Sales worksheet and formula sheet [only] in Black and White [see Sheet Tab of File, Page Setup]. In the text box on the column chart, use white font and white line color, not ivory as required by the text. Print both charts, in addition to all worksheets.
Review Assignments	VegaUSA2		Note well: The Fill Effect “Late Sunset” is a “Preset.” Print Documentation Sheet, Monthly Sales worksheet and formula sheet [only] in Black and White [see Sheet Tab of File, Page Setup]. In Step 12, use a 3-D Pie Chart. Print both charts, in addition to all worksheets.
Case Problems
1.	CIC2		Print Documentation Sheet, Sales worksheet and formula sheet. Do not embed the chart. Place it on a separate sheet with the tab name 3D Column Chart. Ignore Step 13 of this Case Problem.

Course Technology Excel 2003 Special Instructions [4/2] CIS 100
Excel Assignment	Excel Workbook	Special Requirement(s)
Case Problems
2.	Powder2	The Pareto Chart is a Custom Type. By default, apparently, the Pareto Chart inserts a footer. Be certain to remove the footer. It is not part of the Class Standard. Pay close attention to the steps in the text concerning alignment of various parts of the chart. Print Documentation Sheet, Quality Control Data worksheet and formula sheet, in addition to the Pareto Chart. Ignore Step 13 of this Case Problem.
3.	Pixal2	Not Assigned
4.	BCancer	Not Assigned