Note: All lab assignments have a comment at the top of
the assignment that looks like this:
In the Lab
Don't forget your initials and the print-step number on the bottom right-hand corner
of every page.
In the following list, be sure you are looking at the correct problem number.
This list contains changes for MANY problems, only some of which will be
assigned in your semester.
Be sure your solutions look like the pictures in the book! Many assignments
do not specify the steps to make your solution come out that way. You have to
figure it out yourself.
Always save your lab on your H: drive regardless of the text's requirements. The word "submit" means "print"
and that will be the "print step number" you put on your paper.
Word Processing
Word 1-1 or 1-2(depending on semester's assignment):
You must use the specific fonts and sizes specified in the book.
Make your document look like the one in the picture (do this for ALL
assignments), but do not worry about the number of words in a line (although
you CAN do it by adjusting the left and right margins if you want to try).
step 2 of Word 1-1: there should NOT be any empty paragraphs between the lines starting with "Pilots",
"15-", and "Individual". Those extra paragraphs will cause the last line to overflow onto a second page.
step 19 of Word 1-2: change the inter-paragraph spacing of your bulleted lines to 0 pixels after the paragraph.
This should also prevent any page overflow.
Word 1-1: Step 13: First select the whole page.
Set your margins to the built-in margin-style called "narrow".
After the word "Call" (at the bottom of the page) insert YOUR OWN First Initial
and you full Last name, (Word 1-1: do not delete anything) (Word 1-2 Delete "Danvers").
Word 1-1, Step 17: The Airplane photo is located on Prof. Foreman's web server, in the downloads folder.
Word 1-2, step 18: The Bradford Pear photo is on Prof Foreman's website in the downloads folder.
Add an MS Word footer with the current date in it.
Word 3-1 & 3-2:
Use only ONE coverpage for these 2 labs. Replace
the name in the book with YOUR OWN NAME, everywhere it's used. You don't need
to insert your own email address.
Any clip art is OK. Use the samefonts as those in the book.
In 3-2, be sure your headings are in the SAME ORDER as in the book and there are no extras or any missing.
Save your file to your H: drive (EVERYBODY HAS ONE!!!). Do this before the next step.
In 3-1 AND 3-2, add a Word footer containing the automatically inserted path for your file.
To do this in Office 2003:
click on "Insert/Field..."
under "Category" find "Document Information".
select FileName and
click the checkbox for "Add path to FileName". Save your file again BEFORE printing.
To do this in Office 2007:
click on "Insert"
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 FileName and
click the checkbox for "Add path to FileName". Save your file again BEFORE printing.
in 3-1, SKIP step 5: addressng and printing the envelope.
in 3-1, set your document to use the "Office" theme from the page layout/themes selections.
Spreadsheets
When you print your spreadsheets, always
print in landscape mode. All prints must have grids 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
handouts in class. For all formulae used in this class, you MUST use row and
column addresses, not defined names.
In EVERY spreadsheet assignment, before printing:
in Excel 2003:
click on: File/Page Setup/Header and Footer;
click on: "Custom Footer"
click on THREE icons in this order: the folder, the calendar and the clock
click OK, then OK again.
Save the file. NOW you can print it.
in Excel 2007:
click on Insert
click on "Header & Footer"
enter this header info: Your name
click outside the header box, then click on "Go to Footer"
click on "Footer" on the left end of the ribbon.
in the drop down menu, click on the FilePath icon
click outside the footer box, then click on View/Normal
save the file. NOW you can print it.
From the book
Excel 1-1 or 1-2 (depending on what was assigned):
DO NOT TYPE THE DOLLAR SIGNS or do any formatting until told to do so!!
Be sure you DO apply any formatting specified in the book
unless instructions here say to use a different format.
Note that, if you have done ANY formatting of an area BEFORE you want to give it an Autoformat,
the pre-formatting BLOCKS the Autoformat.
To fix it, you will have to select the entire area and click on
Edit/Clear/Formats. Then select the proper area and do the Auto-format as required.
You will know it is correct if you get the $- on the left-hand side of the
graph where $0 would normally be.
A few examples of formatting that causes trouble (when applied to individual cells) in these labs, are:
typing $ signs,
typing commas,
clicking on the $ format icon,
using format/currency,
changing fonts.
It is OK to enter a decimal point for the fractional part of the money
values.
When formatting, use the specified colors. You do NOT have to print in actual color, but Laser and Ink Jet
printers do strange things when printing colored areas with only black ink,
so be careful. Proofread it before you hand it in.
For the graph to come out correctly, you need to format the left (vertical) axis
major and minor units with the proper values. Right-click the axis, then format the scale.
For lab 1-2, Change the MAJOR units on the vertical axis to 20000
(twenty thousand) instead of "automatic". If you did it right, the axis values will be $-, 40,000, 80,000, etc (yes,
that's a minus on the 1st one).
For 1-1 AND 1-2, do NOT use any of the "stacked" graph types. For 1-2, use the 3-D Column chart.
For both 1-1 and 1-2, formula is view only required once for the whole lab.
For BOTH Excel 3-1 and 3-2 (whichever is assigned), the following instructions are common:
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, as the book did for the formula in step 8 (look at the $B$5 in 3-1 or the $B$3 in lab 3-2). 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.
be sure to change the column heights to measurements in points,
not pixels!! (Pixel measurements do not have decimals.)
for all the formulae given in step 8, the book gives it to you 2 ways:
named cells and actual cell addresses (like "2004
Revenue (cell C4)")=formula, followed by the word "or" followed by the
actual formula. Using this method, you would ignore everything from the word "or" to the end of the step.
=formula All you need to do is enter the formula after the
word "or" (ignore everything before the "or").
Do NOT use "Fit-to", instead, do this:
Click on "Page Layout/Margins/Narrow", then move your mouse across the ribbon on "Scale"
and change it to 90%.
Be sure to indent the data as shown in the figure. Do NOT use "spaces" to do the indenting.
(See Excel Chapter 2 for instructions on how to do this.)
Insert a Header with your name (First and Last) and a footer with the FilePath (Insert/Header&Footer)
Excel 3-1 (if assigned):
All values from cell B11 through cell I24 (except the values in B16:I16 and B17) are entered by using the formulae in step 8.
You do NOT type ANY of these numbers. When you type numbers, do NOT enter $ signs or commas.
The values in B16:I16 & B17 should be typed directly into those cells (no formulas needed).
Formula view is only required for Part 1, step 14. Be sure your data is not too small.
Step 2: Cell I9 uses the NOW function, not a typed or handwritten date.
Step 3: See chapter 2 of the Shelly-Cashman book for how to change the row height inpoints.
Step 5: to indent, select the titles in rows A12, A15-19 & A23 (click A12,
then press & hold the CTRL key while clicking each of the other specified rows. When you are done,
click on the "Home" tab and click on "indent" once. Do not use spaces.
Step 6: 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.
For the graph to come out correctly, you need to format the left (vertical) axis's
major and minor units with the proper values. Right-click the axis, then format the scale.
Format the walls of the graph with Texture="newsprint", instead of plain green as shown. Format the text as "Black text 1".
When printing the Formula view, be sure your formual font is not too small.
Use Landscape view. Use as many pages as you need. Be sure your formulae are not cut-off.
For Parts 2 and 3, label the pages (in a footer) "Part 2" and "Part 3 Case 1", etc)" respectively.
Part 2, step 3: do NOT delete the legend, just reformat the box as "dashed".
Only one graph is required for the whole lab.
For Part 3,you are supposed to change the values for "Annual Sales Growth" and "Annual Price Decrease"
then print the normal view. Your value for Cell I24 should match the one in the book (column 3 of Table 3-10).
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), NO graphs
PLUS: 1 normal view for the results of the goal-seek
Excel 3-2 - Part 3
Step 1: You can EITHER:
a. Write down the formulas
b. Print the formula views (label them clearly)
Be sure to write your conclusions. You can do it with a pen or type it in a cell (as long as we can see it).
Step 2. Just write the “tip” on the FRONT of the previous step. Label it Part 3, step 2
Step 3: put the answers on a separate page (DO IT WITH WORD, print it and label it Part 3 step 3.) We don’t’ want to try to read your writing!
Excel 3-3 (if assigned):
Formula view is only required for Part 1, step 14. Be sure your data is not too small.
Step 5: use the indenting instructions inthe book to indent as shown. Do not use spaces.
Be sure to do all 3 Parts of the assignment.
All values from B4 through I16 are entered by using the formulae in step 8.
You do not have to be in Split Window view for printing.
For Parts 2 and 3, label the pages "Part 2" and "Part 3" respectively.
Total printouts required, by part:
Part#
printouts
1
2 normal, 1 formula view
2
1 normal, 1 graph
3
2 normal
Lookup Table
Create the Lookup Table in the same file as the spreadsheet. The
spreadsheet will use formulae to look up a price
markup and the formulas
compute the new price.
Be sure you understand what we mean by the "data part" of the table. It
includes the lookup column or row, but does not include the
comments (the captions)! See the instructor or your Course Assistant in the lab, if you don't understand this!
Be sure your constants (absolute values) appear in the printouts (normal AND formula views).
The instructions may have numbers for examples that do not match the
spreadsheet data as shown. Use the spreadsheet data in the figure.
Special Spreadsheet.
*** Remember, this
assignment counts double and therefore, a late lab gets a
double zero. ***
Do not format the Tot Items column as currency.
At the bottom of each monthly column (6 ITEM columns and 6 $SALES columns),
put a formula, using a range with a ":" for the sum
of that column.
There will be TWO totals on the "Grand Total" line: the <gtotal> result and "30% more".
Grid lines are REQUIRED in formula view and once turned on, will also
appear in normal view (which is good!)
Be sure your constants appear in the printouts (normal AND formula views).
Database
***WARNING*** If your DB is on a removable device (USB drive, etc), be sure
to CLOSE YOUR DATABASE (not just the tables) before you
remove the device from the PC!!!!
Click
here for Database addenda for Spring Semester