Excel tip (blank rows)

I needed to add several blank rows to my excel spread sheet..
found these cool tips!
1) add a new colunm A
2) number your existing rows (excel is smart enough to fill with odd numbers 1, 3, 5)
3) number the corresponding rows 2, 4, 6
4) sort the column smallest to largest
5) you could modify this to insert a row above or a row below
6) delete your sorting colunm

This method works well to randomize data in a spreadsheet.
1) use the formula =RANDBETWEEN(1,100) or however many numbers you want
2) drag the formula down the column
3) sort that column and presto! random information for students to sort

OR write a macro!  I have NOT tested this method!!

 Sub insertrow()
' insertrow Macro

Application.ScreenUpdating = True
Dim count As Integer
Dim X As Integer

For count = 1 To 20
If activecell.Value <> "" Then
activecell.Offset(1, 0).Select
Range(activecell, activecell.Offset(0, 0)).EntireRow.Insert
activecell.Offset(1, 0).Select
For X = 1 To 1
Next X
Else
activecell.Offset(1, 0).Range("a1").Select
End If
Next count

End Sub

By: Neville

Microsoft Office Page Numbers

This is interesting.........
I haven't tried it, but it might work!
So you want pages numbered as follows:
page 1 numbered as 1
page 2 not numbered
page 3 numbered as 2
page 4 not numbered
page 5 numbered as 3
page 6 not numbered
page 7 numbered as 4
etc. If I understand the question correctly, then:

In Word 2003 or earlier, open your document, click on
File | Page Setup | Layout tab | check the "Different
odd and even" box | OK. In the odd-page header or
footer where you want the page numbers to appear,
insert a calculated page number field:

{ = { = { page } + 1 } / 2 }

but do not type the curly braces; instead, insert each
pair by pressing Ctrl+F9. When you've finished entering
the page number field, press Alt+F9 to switch back to
display of field results (the page number) instead of
field codes.

Display the field results
By default, Word displays the field results seamlessly with the content of your document so that someone reading the document is unaware that part of the content is in a field. However, fields can also be displayed with a shaded background, to make them more visible in the document.
You can make the field results blend into the content of the document by turning off the option to display fields with a shaded background and by formatting the field results.
If you want to call attention to fields, you can display them with a shaded background, either all the time or only when the field is selected.
You can format the field results by applying text formatting to the field or by adding formatting switches to the field code.

Change the shaded background of fields

1. Click the File tab.
2. Click Options.
3. Click Advanced.
4. Under Show document content, in the Field shading list, do one of the following:
• To make fields stand out from the rest of the document content, select Always.
• To make fields blend in seamlessly with the document content, select Never.
• To make users of Word aware that they have clicked in a field, select When selected.

 Note   When the field shading option is set to When selected, the field displays a gray background when you click within the field. However, the gray shading does not indicate that the field is selected. When you select the field by double-clicking or dragging the mouse, highlighting that indicates selection is added to the gray shading.

Apply text formatting to a field

• Select the field that you want to format, and then apply the formatting by using the commands in the Font group on the Home tab.

For example, to underline the name that is inserted by an AUTHOR field, select the entire field code, including brackets (or select the entire field result), and then click Underline in the Font group on the Home tab.

 Note   If you update a field, any formatting that you applied to the field results may be lost. To retain the formatting, include the \* MERGEFORMAT switch in the field code. When you insert fields by using the Field dialog box, the \* MERGEFORMAT switch is included by default.

Add a formatting switch to a field code

1. Right-click the field, and then click Edit Field.
2. Do one of the following:
• If Field properties and Field options are displayed, select the formatting options that you want.
• If only the field code is displayed, click Options, and then select the formatting options that you want.

If the Options button appears dimmed, additional formatting options may not be available.

You can use three formatting switches to format field results:

• Format switch (\*)
• Numeric format switch (\#)
• Date-Time format switch (\@)

REFERENCES:
 http://www.techrepublic.com/blog/windows-and-office/pro-tip-calculate-the-current-page-number-within-a-section-in-word/

http://office.microsoft.com/en-us/word-help/insert-and-format-field-codes-in-word-2010-HA101830917.aspx

http://www.addbalance.com/usersguide/fields.htm

Experimental Post

Well, this was some Hallmark occasion.  That is a prayer angel and a prayer chicken up front  :-)

John Venn's 180th Birthday

http://www.google.com/doodles/john-venns-180th-birthday

Boolean logic can be demonstrated with Venn diagrams! 

My two favorite examples are cats, birds, and puppies; and vanilla, strawberry, and chocolate ice cream!!

Microsoft 2013 Master Document

http://www.dummies.com/how-to/content/how-to-create-a-master-document-in-word-2013.html
I really needed this last year and I forgot about it!

Do you create really long documents in Word? If so, you probably know that Word doesn’t always play well with them. It’s usually smarter to split your long documents into multiple Word files. But, then, how do you make sure the pages are numbered correctly and easily create a table of contents and an index for the whole document? That’s where Word’s master document feature can help. It allows you to combine multiple Word files into a single Word file. A master document is a Word file that contains links to a set of other, separate Word files, called subdocuments. The content of the subdocuments is not inserted into the master document. The master document only contains links to the subdocuments. This allows you to edit the subdocuments separately. Any changes made to subdocuments are incorporated into the master document automatically. If there are multiple people working on a single document, a master document allows you to send different parts of the document to different people to work on. In this article, we show you the basics of creating a master document and subdocuments from scratch, and creating a master document from existing subdocuments. We also show you how to easily add a table of contents to the beginning of the master document. Create a Master Document from Scratch If you are starting a fresh master document with no existing subdocuments, you can create one from scratch. To do so, create a new, blank Word document and save it, indicating in the file name that it is a master document. Once you have saved your master document file, click the View tab and click Outline in the Document Views section of the tab. How to Create a Master Word Document

Student learning objectives action verbs

Student Learning Objectives (SLO) Action Verb List

Suggested Verbs to Use in Each Level of Thinking Skills
Below are terms (verbs) that can be used when creating student learning outcomes for a course or degree program.

Knowledge	Comprehension	Application
Count Define Describe Draw Identify Labels List Match Name Outlines Point Quote Read Recall Recite Recognize Record Repeat Reproduces Selects State Write	Associate Compute Convert Defend Discuss Distinguish Estimate Explain Extend Extrapolate Generalize Give examples Infer Paraphrase Predict Rewrite Summarize	Add Apply Calculate Change Classify Complete Compute Demonstrate Discover Divide Examine Graph Interpolate Manipulate Modify Operate Prepare Produce Show Solve Subtract Translate Use
Analysis	Synthesis	Evaluation
Analyze Arrange Breakdown Combine Design Detect Develop Diagram Differentiate Discriminate Illustrate Infer Outline Point out Relate Select Separate Subdivide Utilize	Categorize Combine Compile Compose Create Drive Design Devise Explain Generate Group Integrate Modify Order Organize Plan Prescribe Propose Rearrange Reconstruct Related Reorganize Revise Rewrite Summarize Transform Specify	Appraise Assess Compare Conclude Contrast Criticize Critique Determine Grade Interpret Judge Justify Measure Rank Rate Support Test

Source/Reference: These steps were derived from information collected at various conferences by Dr. Cia Verschelden, the original source is unknown. This information was original posted on the Office of Assessment Web site in the summer of 2005.
(www.k-state.edu/assessment)
 Look for more information here!
http://www.k-state.edu/assessment/toolkit/

Sharlene Silva

Professional Resume Writer
http://susanireland.com/letter/write-a-follow-up-job-search-email/