| |
| |
| |
|
1)
How do I quickly double space my Word document?
Answer:
Select the entire document (CTRL+A or
Edit ->Select All) and then use the shortcut
CTRL+2.
|
|
2)
How can I display more toolbars in Word, Excel
and PowerPoint?
Answer:
In each of the programs click the View menu
and then look in the Toolbars sub-menu for additional
ones you can use.
|
| 3)
How do I remove the page number from the first
page of my Word document?
Answer:
Choose
Page Numbers from the Insert menu. Clear the
Show Numbers on First Page check box and click
the OK button.
|
| |
| |
"The
Right Click"  |
|
In
a Word document you can see a list of synonyms
by right-clicking on a word, then choosing
Synonyms
from the menu. If the word is in a bullet or
numbered list item, the synonym option does
not appear when you right-click. |
| |
| |
"Cell
Space" |
|
Display
Zero Values in Excel
From the Tools menu, select Options, View tab.
Unchecking the Zero values box prevents the
digit 0 from being displayed on the worksheet.
This option is useful for printing.
|
|
| "Surfing
the Net" |
Behind the Blackboard
behind.blackboard.com
Gain access to user manuals, discussion
boards, tutorials, knowledge base and
more.
Turn It In
www.turnitin.com
Turnitin is an online plagiarism prevention
system which allows you to check your
students's work for plagiarism. For the
account id information, please contact
mwilliams@sjcny.edu
Presenters University
www.presentersuniversity.com
Read dozens
of articles from presentation experts
or browse through hundreds of tips for
setting up your slide shows. |
|
| |
| In
the Next Issue... |
 Rules
for Creating & Sorting a Database in Excel |
 PowerPoint
Slide Show Controls |
 Setting
Blackboard Course Availability |
... and much more! |
| |
| Contact
Us |
|
|
TIS
Help Desk
In Brooklyn x263
In Patchogue x1263
TIS Help Form
or send an e-mail to
techhelp@sjcny.edu
|
|
We
welcome article suggestions & feedback! |
| |
| |
| |
| |
|
|
|
|
| |
| A
publication from
TECHNOLOGY
AND INFORMATION SERVICES |
|
|
We are pleased to announce the expansion of “Tips
& Tricks” into a more in-depth e-newsletter
format that includes additional features and sections.
The Tech Times e-newsletter
will focus on a variety of topics in each issue including
program specific articles, commonly asked questions,
keyboard shortcuts, useful web links and tips for working
more efficiently and quickly with a variety of computer
hardware and software programs.
Tech Times
is being provided to all staff and faculty as an extension
to the current technology training classes offered by
the Technology and Information Services department.
In addition, each issue will be archived on the Training
web page. We welcome suggestions and ideas for topics,
including your favorite shortcuts and tips.
|
 Adding
a Drop-Down List to a Spreadsheet
Inserting
a drop-down list to a cell is a slick trick that
can add a touch of professionalism to your worksheets—and
also ensure that erroneous data is not entered
into the cell. And best of all: Macros are not
required!
Assume that you have an input cell in which the
user is supposed to enter a month name: January,
February, and so on. Here's how to add a drop-down
list to your cells to make data entry a breeze:
1) Enter the items for your drop-down list into
a list on the worksheet, one item per cell. In
this example, I'll assume that the month names
start in cell G1 and extend down to G12, but they
can be in any out-of-the-way location on the worksheet.
2) Select the cells that will contain the drop-down
list. If you'd like more than one cell to display
the same list, just select them all now rather
than setting them up one at a time. (Click and
drag to select a range; hold down Ctrl while you
click to select non-adjacent cells.) For our example,
select cells A1 to A12.
3) Click Data->Validation
to display the Data Validation dialog box.
4) Click the Settings tab.
5) In the Allow field, select List.
6) In the Source field, specify the range
that contains the list items. In this example,
the items are in cells G1 to G12, so type =G1:G12
into the field. Click the OK button.
After performing these steps, you'll see a drop-down
arrow whenever any of the drop-down cells you
just defined (cells A1 to A12) are "active"
- that is, selected and awaiting input. Click
the arrow and choose a month from the list. If
you try to type something else into the cell,
you'll get scolded in the form of a pop-up message. |
 |
|
 AutoFormat,
AutoCorrect, AutoText...Auto Who?
Try
this: open Word and on a new sheet type teh and
press the space bar. What did Word do? It not
only corrected the misspelled word, but it capitalized
it also. Try this now: type (c) and press the
space bar. Word converts your text into a copyright
symbol. Try this next: type Auth and press the
F3 key at the top of your keyboard. Ah, that's
nice right? Word enters your name (or the computer
name) the page # and date. Here's another: save
the file first (give it a name and save it anywhere
you want—to your desktop is fine) and then
type Filename and path and press the F3 key. Here's
the last one: type 1/2 and press the space bar.
Word converts your 3 characters to the fraction
one-half (½). So…why do these changes
take place?
AutoCorrect — The first
two examples are instances of Word's AutoCorrect
feature. Sometimes it works with you and sometimes
it seems like it's fighting you. Word has a predefined
list of entries that it refers to when it thinks
you have typed an item stored in the list. The
copyright symbol is one of these entries —
as well as (r) and (tm). In addition, there's
a whole series of commonly misspelled words that
are already entered into an AutoCorrect
list. You can find this list by clicking the menu
choice for Tools->AutoCorrect.
The other AutoCorrect feature in use in the first
example is the option that automatically capitalizes
the first letter of a sentence. Sometimes
you have to fight with this one, especially if
you type a line of text, leave off the period
at the end, and then press the enter key. When
you type the second line of text, Word will automatically
capitalize the first letter of the second line,
thinking you are starting a new sentence, even
if you are not. You can manually change the upper
case letter to a lower one to override the setting.
Some people would rather not use this feature
and decide to turn it off (and any of the others)
from the Tools->AutoCorrect
box.
AutoText — The third and
fourth examples (the auth and filename ones) use
a Word feature called AutoText.
Word has a predefined list of items that refer
to a series of text. When you type the first four
letters of certain items, such as dates or AutoText
names, you can press the enter key or F3
to accept the suggestion, or just keep typing
to reject it. You can easily add your own, more
meaningful, entries to the list. For example,
type St. Joseph's College and press enter. Now,
select the entire phrase and click Insert->AutoText->New.
Give the entry a name in the box that appears
and click the OK button. Use a short, simple name
for your entries so you can remember them. Then,
erase everything on your page and type the name
you just used for the SJC entry. When you see
the yellow popup box, press the F3
key. Any text you type frequently, can be stored
as an AutoText entry. You'll find these, and more,
by clicking Tools->AutoCorrect
and then the AutoText tab.
AutoFormat — The last example
(the fraction one) is iniatiated through a Word
feature called AutoFormat. There's
only a few instances when this feature kicks in.
Typing a fraction character is one of them (although
not all fractions initiate the change...don't
get me started on that one). Here's a few more:
AutoFormat changes straight quotes (") to
smart quotes (curly ones ”); changes ordinals
(1st) to superscript style; changes symbols such
as two hyphens (--) to a solid dash (—);
and changes hyperlinks to formatted "hot
links" (when you type www.sjcny.edu and press
the space bar it turns to blue and underlined
and you can click to launch the web page).
For the most part, these features are useful.
Familirize yourself with the options found in
the Tools->AutoCorrect dialog
box and then decide which ones you can use and
which ones you can do without. |
|
|
 Sending
an E-mail Message to Multiple Students
To
comply with FERPA regulations, The Family Educational
Rights And Privacy Act, use the BCC (blind carbon
copy) function when sending messages to multiple
students or groups.
1.
From within Webmail, select Compose.
2. Address your message:
·
If you are sending to a single student, type
the address into the To textbox or select the
address from your address book and click To.
·
If you are sending to multiple students or a
group, either type the email addresses in the
BCC: field of the message or select the recipients
from your address book and click bcc (blind
carbon copy suppresses the entire list from
showing up in the recipient's To: field, in
compliance with FERPA regulations).
Typing
emails into the BCC field
Selecting
emails from an address book
·
You can leave your To textbox blank if you wish,
or enter your own name so you'll have a record
of the sent message.
3. Enter a subject.
4. Type your message.
|
|
|
 What
is Blackboard?
Blackboard
is an online course management system that allows
an Instructor to effectively manage online teaching
and learning through the World Wide Web. It may
be used to teach a full online class or it may
be used to supplement a face-to-face course.
Course
sites are hosted on St. Joseph's College Blackboard
server, where faculty and students can access
them at any time, from any web browser.
Intuitive
and easy-to-use, the Blackboard Learning System
provides a full spectrum of capabilities in
three key areas:
1. Instruction
· Posting
of Course Documents (Word, Excel, PowerPoint,
etc.)
·
Calendar
·
Staff Information
2. Communication
·
Discussion Board
·
Group Projects
·
Virtual Classroom/Collaboration
3. Assessment
·
Assessments and Surveys
·
Assignments
·
Gradebook
To
learn more about Blackboard, send an email to
mwilliams@sjcny.edu
|
|
|
Combine
Several Documents into a Single One
To
combine several relatively simple documents into
a single document, repeat the following procedure
until all of the individual documents have been
combined. The original documents are unaffected
by this procedure.
1. Start a new, blank Word document.
2. Choose File from the Insert
menu.
3. Browse to the document you want to insert.
4. Select the document, then click Insert.
5. Usually, you will want to insert a page break
after each file you insert: Choose Break
from the Insert menu, select
Page break, then click the OK
button.
Some attributes of the documents you insert after
the first one may be lost (e.g., margins, headers,
and footers). Once you get all the documents combined,
you can work on finishing up document formatting
details, page numbering, etc. If your individual
documents are more complex, Word's Master- and
Sub-document feature is what you need. This feature
is too complex for coverage here, but Word's Online
Help will get you started
|
|
|
 PowerPoint
Slide Creation & Presentation Tips
Many
presentations crash and burn because the presenter
fails to properly prepare for an audience and
anticipate what could reasonably go wrong. There
are a few tricks you can use to help you master
the mechanics of creating slides and delivering
presentations.
·Stick to the general
design guidelines for presentations: Use a title
slide in the beginning and a summary slide at
the end; Use consistent colors throughout the
slides; Avoid using more than 7 bullets per slide;
Use italics sparingly and only in sizes of 36
point and larger. Try using bold instead.
·If you need some
help, either when you are practicing the presentation
or during the show (in Full Screen mode), simply
press F1 to see the Slide Show Help dialog box
with some useful keyboard shortcuts.
·The pace of your
presentation affects audience response—going
too fast exhausts audience members, and going
too slow puts them to sleep. Set the pace early
in the presentation.
·You want the effects
you use, such as animations and transitions, to
emphasize your points, not draw the audience’s
attention to the effects themselves.
·With color choice,
more is not better. Try to stick to using only
one or two colors throughout the presentation.
Use tints and shade variations to change the appearance
of a particular color.
·If possible, try
to get to the room where you will present ahead
of time. Check out the lighting, position of podium,
where the audience will be sitting, where the
screen is located, etc.
·PowerPoint contains
a vast number of options to help you run a slide
show. Remember one important piece of advice:
If you are not sure what to do during the show,
right-click the screen. Do not press the ESC key.
Right-click instead. |
|
|
Internet Bandwidth
Usage
You
may recall that our bandwidth was increased last
spring in an effort to provide adequate Internet
access for the academic and administrative needs
of the college. Please keep in mind that each
portion of bandwidth used for recreation or personal
business takes away from the bandwidth needed
for instructional usage. Please refrain from using
the Internet for non-academic purposes. |
|
Technology
Help Desk
Having
computer problems? Phone not working? Printer
making you sad? Smart classroom not so smart?
The
Technology & Information Services Department
has one central contact for all your computer,
printer, Smart Classroom and telephone technical
issues or for any hardware/software installation
questions.
If
you are having any type of technical issue please
call:
In Brooklyn, dial x263
In Patchogue, dial x1263
Please
leave a message. Your call will be recorded
and a TIS staff member will be dispatched to
your office or location. This central dispatch
will allow for a faster response to your technical
problems.
|
|
| |
|
| |
Copyright
©2006 St. Joseph's College, New York
Microsoft product screen shot(s), logos and images
used with permission from Microsoft Corporation.
|
 |
|
|
