Basic Instructions for the Course

Addenda

Basic instructions for the course

Each lab will have specific instruction that modify the instructions in the book. Some of these addenda will add to the book, some will correct the book and some will tell you to skip steps in the instructions.
For All labs, you must use any specific fonts and sizes specified in the book. If not specified, make yours look as close to the book's example as possible especially honoring serif vs. sans-serif fonts. You MUST know the difference
Make your document look like the one in the picture (do this for ALL assignments), but do not worry about matching the number of words in a line (although you CAN do it by adjusting the left and right margins if you want to try).
Margins that are significantly different than the picture in the book (or the amount specified in the lab addenda) will cost 10 pts.
For ALL CS105 assignments, whenever a specific color is specified in the book or the addenda, ANY color is OK (except pure black or pure white), since you do NOT have to actually PRINT in color. Save your color ink. It's expensive. Print usingthe "grayscale" printer option which will make all colors appear as a shade of gray, so we will know you actually applied SOME color.

Instructions for specific labs

Word Lab 1-1 (Fall Semester only)

Set your margins to the built-in margin-style called “narrow”.
There should only be one empty paragraph, for inserting the photo. Extra paragraphs will cause the last line to overflow onto a second page. To see paragraph marks, you can turn on "Options/Show all formatting marks".
Change the inter-paragraph spacing of your bulleted lines to 0 pixels after the bulleted paragraphs. This should also help prevent any page overflow.
Step 5: Theme Colors are found under the design tab
Step 6: To apply the text effects use the “glowing A” icon in the home tab listed in the font grouping, and select the Fill- Dark Purple Accent 1 Note: by hovering over the buttons the names will appear.
Set the gradient stop to 50% and the brightness to 25%.
To do this font color- gradient- more gradient- gradient fill- adjust the settings
Step 16: The image to insert is on Prof.Foreman's website in the "Downloads" folder #17
Step 20: Replace the phone number in the signature line (at the bottom of the page) with YOUR OWN First Initial and your full Last name, only delete the phone number and Vivian.
Save this document on your H: drive. (Everyone should have an H: drive. If not, go to the Computer Services Help Desk.)

You will lose 10 points on every lab in Word and Excel for not saving onto your H: drive. Adding a footer in the next step (using Insert Parts/QuickParts in Word or Insert/Footer/FilePath in Excel) BEFORE printing, will prove you did it.

ADD A FOOTER with the complete file path for this document. Left bottom corner
To do this in Office 2013, 2007 or 2010:
click on “Insert” tab
click on “footer” and click on “edit footer” at the bottom of the menu
click on “Quick Parts” on the Word ribbon
Click on “Field”
Under “Categories” select FileNameand click the checkbox for “Add path to FileName”. Save your file again BEFORE printing.
Include your initials and print step number in the footer on the right corner
Go to File/Print/Printer properties and set "grayscale" before printing. Color printing is NOT required (save your ink)!
Include COVER PAGE see example on Prof.Foreman's website #11

Word Lab 1-2 (Spring Semester only)

Set your margins to the built-in margin-style called “narrow”.
There should only be one empty paragraph, for inserting the photo. Extra paragraphs will cause the last line to overflow onto a second page. To see paragraph marks, you can turn on "Options/Show all formatting marks".
Change the inter-paragraph spacing of your bulleted lines to 0 pixels after the bulleted paragraphs. This should also help prevent any page overflow.
Step 3: Theme Colors are found under the design tab
Step 5: To apply the text effects use the “glowing A” icon in the home tab listed in the font grouping, and select the Fill- Dark Purple Accent 1 Note: by hovering over the buttons the names will appear.
Set the gradient stop to 50% and the brightness to 25%.
To do this font color- gradient- more gradient- gradient fill- adjust the settings
Step 13: The images to insert are on Prof.Foreman's website in the "Downloads" folder
Step 18: Replace the phone number in the signature line (at the bottom of the page) with YOUR First Initial and your full Last name.
Save the document on your H: drive. (Everyone should have an H: drive. If not, go to the Computer Services Help Desk.)

You will lose 15 points on every lab in Word and Excel for not saving onto your H: drive. Adding a footer in the next step (using Insert Parts/QuickParts in Word or Insert/Footer/FilePath in Excel) BEFORE printing, will prove you did it.

ADD A FOOTER with the complete file path for this document. Left bottom corner
To do this in Office 2013 or older:
click on “Insert” tab
click on “footer” and click on “edit footer” at the bottom of the menu
click on “Quick Parts” on the Word ribbon
Click on “Field”
Under “Categories” select FileNameand click the checkbox for “Add path to FileName”. Save your file again BEFORE printing.
Include your initials and print step number in the footer on the right corner
Go to File/Print/Printer properties and set "grayscale" before printing. Color printing is NOT required (save your ink)!
Include COVER PAGE see example on Prof.Foreman's website #11

Word 3-1 & 3-2 (Spring & Fall semesters)

Only create ONE cover page for these 2 labs.
For both labs Step 1 if using an older version of Microsoft Word Retrospect and Celestial theme may not be available. You may use Trek as an alternative for 3-1 and Opulent for 3-2.
Step 2 Also if there is no Snip Same Side Corner rectangle shape offered on your version of Word use Rounded Rectangle shape
Symbols are found under the Insert tab
SKIP steps3eand 4in lab 3-1 and 3-2
Change the dates from the figure to today’s date on both labs
Change the name in the signature line for both 3-1 and 3-2 from Jonathon White\Victoria Holland with YOUR OWN NAME.
Replace the email addresses & "web addresses" with your own email address everywhere those things appear in both the documents
Leave the post-office mail address & phone number as they are in the original figures.
Any clip art is OK. Match the fonts from the book.
Address the 2 labs as done in the book. (10 pts). Incorrect placement is also -10 pts.
Lab 3-2 :
Table: Check off only Headed Row and Banded Rows
Ribbon banner at top: Insert your own name instead of “Victoria Holland”
Save your file to your H:drive (as usual). Do it before you add the filepath in the footer
For each lab add a footer with the inserted quick parts “filepath”
Note anytime a lab instructs you to “submit/print/display” make it your print step. For lab 3-1 and 3-2 make step 3 the print step

Spreadsheets

General rules

When you print your spreadsheets, always print in landscape mode. All prints must have gridlines on and row & column headers on. Don't forget Foreman's Laws (see your notes.)

There are several spreadsheet assignments, some are in the book, some will be downloads from the CS105 website (NOT the publisher’s site). For all formulae used in this class, you MUST use explicit row and column addresses (like A1, $A1, A$1 or $A$1), not defined names.

In EVERY spreadsheet assignment, before printing:

in Excel 2007:
click on Insert
click on “Header & Footer”
enter this header info: Your name
click on “Header” on the left end of the ribbon.
in the Dropdown menu, click on the FilePath icon, then type a semicolon, then click on the current date icon ,then type a semicolon, then click onthe time icon
click outside the header box, then click on View/Normal
save the file. NOW you can print it.
in Excel 2010 and Excel 2013:
click on Insert
click on “Header & Footer”
in the header & footer tools menu, Navigate to Footer.
While in the left corner footer : On the ribbon click on the “FilePath” icon, then type a semicolon, then click on the current date icon ,then type a semicolon, then click on the time icon
click outside the header/footer box, then click on View/Normal.
save the file. NOW you can print it.

Excel 1-1 (Fall semester)

Be sure you see ALL the pages for this assignment! The term “chart” means “graph”. A spreadsheet is NOT a chart. When typing the values, it is OK to enter a decimal point for the fractional part.
Step 1: Region data should be formatted to have two decimal places
Step 2: You must create a totals row calculating region totals. Add a column that calculates product totals and a grand total cell at the bottom in the new “Totals” row.
Step 3: After using the Title cell Style to center the title across columns A through F, highlight column A through F and click the “merge & center” found in the home tab in the alignment group
Step 5: Make sure you adjust the column widths. If there are ### in the cell you have to make the column wider. Points will be taken off if a cell has pound signs
Step 6: Resize the pie chart to 4.4 height and 6.7 width and drag chart. Drag the chart so it will fit on one page. Format your graph to look like the one from the book, but you do NOT have to print it in color. Proofread it before you hand it in
Step 8- Save as just Lab 1-1
Step 9: Print both worksheets (table & graph)
Step 11- Print table
Step 12- Instead of the directions in book PRINT Formula view.
Formula view is only required once for the whole lab. The print step for formula view should be 12
To switch views on the keyboard click CTRL and the backtick` sign.

Excel 1-2 (Spring semester)

Be sure you see ALL the pages for this assignment! The term “chart” means “graph”. A spreadsheet is NOT a chart. When typing the values, it is OK to enter a decimal point for the fractional part.
All data should be ENTERED (do NOT use “format”)with two decimal places
Make sure you adjust the column widths. If there are ### in the cell you have to make the column wider. Points will be taken off if a cell has pound signs
Step 2: You must createformulasin cells B12 through F12.
Step 3: After using the Title cell Style to center the title across columns A through F, highlight column A through F and click the “merge & center” found in the home tab in the alignment group
Step 5: Resize the pie-graph to 4.4 height and 6.7 width and drag the chart. Format your graph to look like the one from the book, but you do NOT have to print it in color. Proofread it before you hand it in. Since the graph is on a separate tab, it does not have to have grid lines or the usual “row & column headings”.
Step 7- Save as specified in the book andPrint both worksheets (“yearly sales chart” & graph). Also print the formula view.
Step 8: Re-open Excel, re-open the file and make the changes.Print ONLY the spreadsheet, AFTER making the changes.
Step 12 – write the answer by hand at the TOP of your previous printout
Formula view is only required once for the whole lab. The print step for formula view should be 7.

Excel 3-1 (Fall semester)

Be sure you see ALL the pages for this assignment - there are 3 parts to the assignment! The term “chart” means “graph”. A spreadsheet is NOT a chart.

For all formulae that use constants, be sure to create cells that contain those constants, then use absolute references to refer to those constants,
Also you are permitted to use the "1" as seen in many of the formulas, ONLY because that “1” represents 100% and would ALWAYS be a “1” for that kind of calculation.
The ONLY numbers you will enter by typing them are in B23 to B27. All the other numbers come from formulas you type into their cells. When you type thesenumbers, do NOT enter the $ signs or commas. Do not put cell references in these cells, just the actual data.
For the named values (such as Units Sold in Prior Year) from the Assumptions, be sure to use an absolute address to reference the value in your formula.
Formula view is only required for Part 1, step 13. Be sure your data is not too small. If your C.A can’t read it they can’t grade it and you will lose points
Insert a Header with your name (First and Last) and a footer with the FilePath (Insert/Header&Footer)
If you don’t have the specific themes or fonts mentioned in the book, use one that is “close”.

Step 2: Cell I2 uses the NOW function, not a typed or handwritten date. =NOW( ) then right click- format cells to mm/dd/yy
Step 3: Be sure to change the column heights to measurements in points, not pixels!! (Pixel measurements do not have decimals.) See chapter 2 of the Shelly-Cashman book for how to change the row height in points if needed.
Step 5: to indent, select the titles in rows A5, A8-14 & A18 (click A5, then press & hold the CTRL key while clicking each of the other specified rows.) When you are done selecting, click on the "Home" tab- alignment group and click on "indent" once. Be sure to indent the data if shown in the figure. Do NOT use "spaces" to do the indenting. (See Excel Chapter 2 for instructions on how to do this if need be.)
Step 8: Do NOT use the Comma icon. Instead, select the given area, then click on: Format/Format Cells/Number then click on "Number" INSIDE the Category box, then in the "Negative numbers" box click on the BLACK version of "(1234.10)", that is, the version in black with parentheses.
Step 9: Remember to use Cell Referencing appropriately. Note: may help organize spreadsheet if in the cell next to number references you write a label for the numbers
If done accurately your numbers should match the ones from figure 3-84 in the book
The book gives you: named cell (actual cell address)= formula. For example:Year 2 Sales (cell C4)”) = formula. You only need to type the = and the formula that follows it, using cell references, NOT named cells.
Step 11: You may save the file as Lab 3-1 instead of the long name given in the book
Step 12: If the instructions say to use "Fit-to", do this instead:
Click on "Page Layout/Margins/Narrow", then move your mouse across the ribbon on "Scale" and change it to a value from 87% to 90%, to get it onto one page. Sometimes it may help if you reduce the size of some of your columns first.
When printing the Formula view do NOT use "Fit-to" for formula view, EVER! Just print it normally and it's OK if it takes multiple pages!!! Be sure your formula font is not too small. If your C.A can’t read it they can’t grade it and you will lose points
Use Landscape view. Use as many pages as you need. Be sure your formulae are not cut-off. You will lose points for having formulas cut off

For Parts 2 and 3, label the pages (in a footer) "Part 2" and "Part 3 Case 1", etc., respectively.

Step 3: Use a Rotated Title for the vertical axis title
For the graph to come out correctly, you need to insert the left (vertical) axis. Check to make sure the vertical axis has 50,000 unit markers.

Only one graph is required for the whole lab.

For Part 3:

Step 1: For each case study you are supposed to change the values for "Annual Sales Growth" and "Annual Price Increase" then print the normal view to illustrate the changes in tow 19. These 3 prints are what they mean by “analyze the effect...” Do NOT do a 'SAVE' during this Part OR at its end. Just close the sheet and select "Don't save".
Step 2: Print in normal view results of Goal- Seek
After running the analysis cell I18 should change to $500,000.
Margin is the only Assumption number that should change

Total printouts required, by Part:

Part# / printouts
1- / 1 normal view, 1 formula view
2- / 1 graph
3- / 3 normal views (case 1, case 2, case 3) of the spreadsheet itself, NO
graphs, no formulas
PLUS: 1 normal view for the results of the goal-seek

Excel 3-2 (Spring semester)