Thursday, March 17, 2016

Presentation Rehab Tip 3 - Don't use a script or read from slides

When presenting, avoid using a script or reading the text displayed on the slides.


Television news anchors read the news to us every night. If they are experienced, you may have a difficult time detecting the motion of their eyes as they read the words from the teleprompter. Good news anchors are able to read but make it sound like they are simply talking. This technique takes considerable experience and time to master. It is also easier to read in the controlled environment of the studio.

You are not in a studio, and my guess is you are not trained to read from a teleprompter. This is actually a good thing. There are several reasons why it is much better to limit the text notes in front of you.

Pictures and diagrams are preferable to bullet points and text on your slides. One of those reasons is that you want to focus on the audience, not face away from them reading the text word-for-word from the screen or lean over a podium reading from your computer. Even if you use notes based on the slides, there is a tendency to focus on the text. When your focus is on reading your presentation, you can't connect with the audience to ensure they're engaged or even awake.

Many presenters choose to read prepared text - either on slides or notes - in order to stay focused on the message and avoid meandering off topic during the presentation. However, if you are locked in to a specific set of words and these are the ones you've practiced, it is very likely that a slight distraction could derail the presentation. Much like a train, focused practice in order to memorize a talk or read can easily cause you to lose focus and not be able to get back on track.

When my daughter was taking piano lessons, with the goal of performing memorized classical selections at a recital, the teacher encouraged her to pick random places within the song to start playing. That way, if something my daughter stumbled in the middle of a piece, she could find a place from which to keep playing.

Usually, the tone, pacing, and expression are different when reading as opposed to simply free speaking. The same holds for memorized text. Most people can immediately sense when you're not talking to them but using a script. If you've ever called a help desk number and been transferred to an overseas call center, you likely have experienced a scripted conversation. Because English is a second or third language for the staff, they must refer to their scripted notes in order to communicate and ensure a standard response to problems.

Sunday, March 13, 2016

Tales of a Dog Named Sex (Dear Abby Column)

Several years ago I came across this story as shared in a Dear Abby column. Dear Abby is an advice column started in 1956 by Pauline Phillips under the pen name Abigail van Buren. Today, Pauline's daughter, Jeanne Phillips maintains the column.

This is a hilarious story about what happens when a dog has a peculiar name, "Sex." Enjoy!


A Dog Named Sex


By Morty Storm

When I went to City Hall to renew my dog's license, I told the clerk I wanted a license for Sex. He said, "I'd like one, too!"

I said, "But this is a dog."

He said he didn't care what she looked like. Then I said, "You don't understand. I've had Sex since I was 9 years old." He winked at me and said, "You must have been quite a kid."

When I got married and went on my honeymoon, I took my dog with me. I told the motel clerk I wanted a room for my wife and me, and a special room for Sex. He said, "You don't need a special room for Sex. As long as you pay your bill, we don't care what you do."

I said, "Look, you don't seem to understand. Sex keeps me awake at night."

The clerk said, "Funny, I have the same problem."

Well, one day I entered Sex in a contest, but before the competition began, the dog got loose and ran away. Another contestant asked me why I was just standing there, looking disappointed. I told him I had planned to have Sex in the contest. He said, "Wonderful! If you sell tickets, you'll clean up!"

But you don't understand, I said. "I want to have Sex on TV." He said, "They already have that on cable. It's no big deal anymore."

Well, my wife and I decided to separate, so we went to court to fight for custody of the dog.

I said to the judge, "Your honor, I had Sex before I was married." The judge said, "The court is not a confessional. Please stick to the facts." I told him that after I was married, Sex left me. He said, "Me, too."

Well, last night Sex ran away again, and I spent hours looking all over for him. A cop came over to me and asked, "What are you doing in this alley at 4 o'clock in the morning?" I said, "I'm looking for Sex."

My case comes up Friday.

Source

Thursday, March 10, 2016

Today

Back in 2012, I shared a post on The Right Kind of People. Does it matter how you view a situation?


Read the poem below and consider if you've ever felt this way.

Today

Today was the absolute worst day ever
And don't try to convince me that
There's something good in every day
Because, when you take a closer look,
This world is a pretty evil place.
Even if
Some goodness does shine through once in a while
Satisfaction and happiness don't last.
And it's not true that
It's all in the mind and heart
Because
True happiness can be obtained
Only if one's surroundings are good
It's not true that good exists
I'm sure you can agree that
The reality
Creates
My attitude
It's all beyond my control
And you'll never in a million years hear me say that
Today was a good day.

Now read from bottom to top. 

One of my friends shared this on Instagram. The poem was written by Chanie Gorkin.

Perspective

In another post, I shared about a ship's captain who burned his ship to inspire his men to fight. Having the correct motivation, the proper perspective, definitely makes a difference your view of life.

My wife and I have one child, a daughter who is now seventeen years old. When she was younger, it was sometimes difficult for her to be excited about doing some activity her us. She would drag her feet, walk slowly, and appear disinterested. However, if we brought along a couple of her friends - in the same situation - she was a totally different individual. She was animated, alert, and happy.

What are you building?

Another classic story of perspective features three men on a construction site. A visitor approached the first man and asked, "What are you building?" He replied, "I'm laying bricks." The visitor proceeded to the second man and asked the same question, "What are you building?" The second brick layer responded, "I'm building a wall." As the visitor walked along, he came to the third worked, "What are you building?" The third man paused from his work, stood up straight, and said, "I'm building a cathedral."

Tuesday, March 8, 2016

Combine multiple Excel Worksheets Into One

In this post I share about a project where I needed to combine multiple Excel worksheets into one using Visual Basic coding. The code combined 66 worksheets into 1 containing the entire King James Version of the Bible.


I have started to work on a book project which requires several texts from the King James Version of the Bible to be included. Rather than type each text into the book, I wondered if there might be a better way.

KJV Bible in Excel Format

I searched online for "King James Version Excel," and found the following link to be helpful:

The Spreadsheet Page > King James Bible

However, when I viewed the Excel workbook after downloading, I realized that each book of the Bible (a total of 66) was included its own individual spreadsheet. In ordinary circumstances multiple spreadsheets would not be a problem, but 66 spreadsheets - far too many.

Combining Multiple Worksheets

Thus, I returned to the Internet to search for some technique to combine multiple Excel worksheets into one. The best option I found is the one listed below. The Visual Basic code combines all of the worksheets into a new worksheet entitled "Master."

VBA Express > Combine All Worksheets Into One

The code as written works well for the Microsoft Windows version of Excel. However, it only merged the first column of data on the Mac version of Excel. The Visual Basic code automatically calculates the number of columns to import. When I manually entered the number of columns (2 in my case), the code worked perfectly.

All of the worksheets should have the same structure with neatly arranged data and the same number of columns. A large number of worksheets takes a few seconds to process, but the end result saved a lot of time.

You can find my combined file at the link below.

King James Version Bible

Sunday, March 6, 2016

Presentation Rehab Tip 2 - Write the purpose

This is Tip 2 of several tips to create presentations and deliver them more effectively. This tip today is to write down the purpose of your presentation.



“Along the journey we commonly forget its goal. Almost every vocation is chosen and entered upon as a means to a purpose but is ultimately continued as a final purpose in itself. Forgetting our objectives is the most frequent stupidity in which we indulge ourselves.”—Friedrich Nietzsche

Academic Studies

Nearly every book and article on goal setting recommends that goals be written. Follow-through on goals is much more likely to occur when they are transformed from thoughts into printed words.

In a study that addressed poor academic performance, researchers divided the subjects into two groups. One group completed an online program focusing on setting and writing goals down. The other group, the control group, did not participate in the online program. At the conclusion of the 4-month evaluation period, the participants from the goal-setting group displayed significant improvements.

Another study looked specifically at the effectiveness of written goals. The participants were divided into five groups –
  • Unwritten goals
  • Written goals
  • Written goals with action commitments
  • Written goals with action commitments to a friend
  • Written goals with action commitments and progress reports to a friend

After the four-week trial, the participants were asked to evaluate the effectiveness of their experiences. There was a statistically significant difference between the unwritten goals group and the other groups.

Where are you going?

Taking the time to write out the purpose of your presentation is the first step of a multi-part process to capture the planning for your presentation in writing.

Imagine starting on a long journey without knowing the destination. While taking a leisurely, Sunday drive might occasionally be pleasant, it would be impractical to take a journey with no end in mind. How could you even anticipate how long such a journey would take? It would be impossible to plan for an endless journey. A destination is needed when traveling and a presentation also requires a destination, better known as a "purpose."

Stephen R. Covey, author of The 7 Habits of Highly Effective People, describes the very first habit as "Begin with the end in mind." Despite its banality from overuse in the business community, this is still excellent advice when planning a presentation. At the end of the day, what do you want people to take away from your presentation?

Complete this sentence: "When people leave my presentation they will _____________" to help determine purpose of your presentation. For example,
  • "When people leave my presentation they will know how to create a flow chart."
  • "When people leave my presentation they will agree to fund my project."

Thursday, March 3, 2016

So You Think You Can Write

Harlequin, the premier publisher of romance novels, provides several resources for authors as well as submission guidelines for each category of romance.


As I was wandering around my local Books-A-Million bookstore the other day, I accidentally passed into the romance aisle. There were hundreds of romance books available. Most, if not all of them, were all from the same publisher, Harlequin.

Harlequin was founded in 1949 and has been regularly turning out romantic fiction ever since. Harlequin publishes 110 titles per month.

Submission Guidelines

Unlike many publishers, which require agent representation in order to submit manuscripts, Harlequin welcomes manuscripts for any of its series. The Harlequin Submissions page contains a description of each series, the required documents to submit, and a general list of required elements for a story.

For the American Romance category, each story much reflect the following characteristics.

  • Central romance is driven by the hero's or heroine's (or both) desire to be a part of a family or community
  • Stories showcase the comforts of home and a sense of place – particularly the charm of small-town America and the ruggedness of western locales
  • Must be set in the USA
  • Western heroes and heroines are very popular – cowboys (ranchers, rodeo riders), law enforcement (sheriffs, deputies, Texas Rangers), etc
  • All stories must feature strong family elements such as pregnancy, young children, blended families, etc
  • Warmhearted stories offer a range of tones, from light humor to drama
  • Level of sensuality is low to moderate
  • Word count of 55,000 means stories must be fast-paced and plot-driven

Westerns and romance probably feature the most predictable plots. It's what the readers expect and want. The Longarm western series currently includes 436 titles. Like romance, each cover features similar images: Longarm with a gun, Longarm with a woman, and some other illustration suggestive of the plot.

http://www.amazon.com/Longarm-434-Rock-Springs-Reckoning-ebook/dp/B00KWG625Y/ref=sr_1_6?ie=UTF8&qid=1454468076&sr=8-6&keywords=longarm

So You Think You Can Write

In addition to publishing information, Harlequin has also created a website specifically for aspiring romance writers. So You Think You Can Write features contests, general advice, articles, and a blog.

Plot Points

I have collected a variety of books on storytelling techniques and the role of plot structure in writing and storytelling. I found the article Plot Points: How to outline your novel to be informative, both in terms of general approaches to plotting and some insight into what writing for romance looks like.

I have no plans to write a romance novel. However, if this is something you might be thinking about, definitely check out the free resources Harlequin offers.

Tuesday, March 1, 2016

Massive List of Story Prompts, Part 2

This is the second post of lists of story prompts. Find a category and pick a work. Take a few minutes to recall a memory centered around the word. Write a story about what you remember or an incident you experienced.


In Part 1, I shared lists from several different sources I have compiled over the years. The lists in this post are from the book, The Healing Art of Storytelling by Richard Stone. From the back cover:

Over the years, television and other cultural forces have robbed us of storytelling as a tool for communicating, learning, and healing. Professional storyteller Richard Stone describes this crisis and its devastating effects and then offers a step-by-step guide for creating a storytelling tradition that we can use to transform our families, our friendships, and ourselves.

http://www.amazon.com/Healing-Art-Storytelling-Personal-Discovery/dp/0786881070/ref=sr_1_1?ie=UTF8&qid=1456274566&sr=8-1&keywords=healing+art+of+story+telling

The House Tour+

  • The house tour - On a blank piece of paper, draw the floor plan of a house you grew up in.  Indicate where major pieces of furniture were placed, the location of windows and doors, and important features of the yard.  If more than one level, draw separate floor plans for each level.
  • Firsts - Think about things you did for the first time (driving, dating, etc.)
  • Funny things that have happened   
  • Sounds of childhood - noises (environmental), car sounds
  • Aromas of childhood - smells in the house, environmental/neighborhood smells
  • Music of youth   
  • Movie memories   
  • Family photo album   
  • School days - teachers, bullies, "special" students, favorite/least favorite subjects, vacations, grades, discussions at school
  • Turning points - Share one wonderful experience that changed the course of your life (move, job, having children, getting married, etc)