Lab Proficiencies

Jump down menu

Adding Analysis or Solver to the tools list in Excel
Printing from Adobe Reader
Printer paper jams
No pop-up or something wont print
Scanning

Adding Analysis or Solver to the tools list in Excel do this: [here is the long version]

Drop the menu under Tools and click Add-Ins...
Put a check in the box beside Analysis ToolPak or Solver Add-in
Click OK

Now when you drop the menu under Tools, Data Analysis is available

Printing from Adobe Reader - The secret is to "Print as Image" ,usually found in the Print Dialogue box.

Printer paper jams - Read the instructions in the window on the printer. If it keeps happening, put paper in the upper tray to feed through.

No pop-up or something won't print -

When the user sends a print job, it is automatically paused. Then the pop-up should appear on their screen and allow them to enter their password and click "Print it". If this is successful, the job is taken off pause and is printed.
If it does not print, here are some possible causes -- find solutions below:
- no paper, or printer off line
- job sent to wrong printer
- no pop-up
- not enough balance to cover the job
- printer itself is paused -- you can't fix this yourself, but it is unlikely to occur
If the job does not print:
- If there was no Pop-up, it will not print -- to fix it, see below.
- Check that the printer is on line and has paper.
- Click File > Print
  - Make sure the correct printer is selected.
  - When the Pop-up appears, check their account balance to see if there is enough for the job. If they put in their password and click "Print It" but their balance is not enough to cover the job, the job will remain "on pause" for a while and then be automatically deleted.
- If there is no Pop-up:
  - On their computer, check to see if the green pyramid is in the system tray.
    - If it is not, from the Start button, go to All Programs > Startup > Pop-up. This will put it there.
  - If the pyramid is in the tray and they have not gotten the pop-up, exit the pop-up and restart it:
    - In the tray, right-click the green pyramid and choose "exit".
    - From the Start button, go to All Programs > Startup > PPopup.
- This should make the pyramid reappear in the tray. Wait about 10 seconds to see if the pop-up window appears asking for a password to print. If not, go back into the document they are trying to print, and try a new "Print" command of the document.
When you see the Pop-up, check to see if they have enough in their account to do the job. If not, they must put money on their account at the Library Circulation Desk or wait to give it to Searle or Claire in the Computer Lab.

Scanning -- Use different procedures to get an image file (use a "picture" for anything) vs. converting printed material to text to use in MS Word.

IMAGE: (Do not push the green button on the scanner) Put image on scanner at top right. Open Paint Shop Pro. Go to: File, Import, Twain, Acquire. (This manages the scanning process) The scanner will do a preview scan. When image appears: with the mouse, put the cursor at the top corner of the image and draw a box to define the picture area. Check the settings in the box; resolution, etc. Click "Scan" then click "Close." Do this for one or more images. When finished scanning, "close" puts you back in Paint Shop Pro where the image may be manipulated. To save, click File, Save As, name the file and select the JPEG extension.
TEXT (OCR): Put text on scanner and push the green button on the scanner. The scanned image will appear on the monitor. Click "scan" and "done" then "File, Send Text to Word". In Word you may proof read and spell check. Save your document.