Friday, October 13, 2017

TED

I love TED talks.......

TED is a nonprofit devoted to spreading ideas, usually in the form of short, powerful talks (18 minutes or less). TED began in 1984 as a conference where Technology, Entertainment and Design converged, and today covers almost all topics — from science to business to global issues — in more than 100 languages. Meanwhile, independently run TEDx events help share ideas in communities around the world.

More on TED: https://www.ted.com/about/our-organization

Saturday, September 27, 2014

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

Thursday, September 25, 2014

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.
Office 14 Ribbon
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:
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


Sunday, September 21, 2014

Experimental Post

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

Monday, August 4, 2014

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!!

Friday, May 9, 2014

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/