Wednesday, March 5, 2014

SPAM/PHISHing Email Information

Due to the rash of emails that got into the Google domain the past couple of weeks and the fact that many responded or provided his or her information figured this would be a good time to point out the TechFAQ article about SPAM and Phishing email context and what to look for if you are unsure if it is SPAM or valid.

The link to the article is

While this may never catch all scenarios, experience with these emails indicates most fraudulent emails have at least one aspect included in the article. One big trigger, which should be obvious, is that the "reply to" address is external or any links or addresses requesting the information are not associated with Saint Mary's University or

Again we do not ask for information in this manner unsolicited. You, as the customer of the SMU HelpDesks and/or  Information Technology Services, have already been in contact with us in some way regarding your account and we have responded, with some initial problem solving or directions, to you via email, chat, or phone.

We hope this helps you keep your information safe and assists you in helping us protect Saint Mary's University resources going forward.

Brian Behling
HelpDesk Manager - Winona Campus

Friday, February 21, 2014

Blackboards Item Anaylsis

Use Item analysis to see statistics on overall test performance and on individual test questions. Identify and easily correct ineffective or misleading questions and your tests are re-graded automatically.

To watch the video and learn more, click here.

Blackboards Retention Center

The Retention Center provides an easy way for instructors to discover which students in their courses are at risk. Instructors can communicate with struggling students and help them take immediate action for improvement.


And you can revise the Retention Center to show students that are high achievers!

Here is a summary of what can be done within the Retention Center.

To learn more, click here.

Thursday, February 20, 2014

Office for Mac - PowerPoint 2011

Tools you want, when you want them.

Making Every Presentation Professional

For more Microsoft 2011 for Mac, go here

Windows 7 Calculator

The calculator in Windows 7 has been improved, with more features.

Scientific Mode

Programmer Mode

Statistics Mode

Calculation History

Convert values from one unit of measurement to another

Calculate Dates

Calculate fuel economy, lease or mortgages payments

Look What is New in Office 2011 for Macs

Here are a few new items.  Click on the links for more fun new items.

Microsoft Office Mac Ribbon.  To learn more, go here.

Equation tools, now available on the Ribbon.  For More information, click here.

Finish your work sooner?  More information here.

Monday, February 17, 2014

New in Windows 7 - Snipping Tool

The Snipping Tool captures a screen shot of anything on your desktop, for example a picture or a section of a webpage.

I created this image with the Snipping Tool.

To view this video and see more on how to use this new feature, Click here.

Some new Features in Windows 7

Here is a video on the new Windows 7 Desktop.
   Some features are:

  • New ways to juggle windows
  • New wallpapers
  • Retooled taskbar and more
To see more, click here.

Going from Win XP to Win 7 - See New Features

For those who are seeing Windows 7 for the first time, here are new features you may want to check out.
(The 64 bit features do not apply.) 

To view these features, click here.

Training Videos for Office 2010 PC and Office 2011 Mac

Here are links to some video's for Office 2010 for PC.

Video's start from Beginner to Advanced Users.

Click here to view video's for Word 2010.

Click here to view video's for PowerPoint 2010.

Click here to view video's for Excel 2010.

Click here to view video's for OneNote 2010.

And for Mac users, here are links to Office 2011 for Macs.

Click here to view video's for Word 2011

Click here for view video's for PowerPoint 2011

Wednesday, January 29, 2014

New Functions Coming in Excel 2013

You’ll find several new functions in the math and trigonometry, statistical, engineering, date and time, look-up and reference, logical, and text function categories. Also new are a few Web service functions for referencing existing Representational State Transfer (REST)-compliant Web services.  To get more information on each Function, Click here.

ACOT functionMath and trigonometry:    Returns the arc-cotangent of a number
ACOTH functionMath and trigonometry:    Returns the hyperbolic arc-cotangent of a number
ARABIC functionMath and trigonometry:    Converts a Roman number to Arabic, as a number
BASE functionMath and trigonometry:    Converts a number into a text representation with the given radix (base)
BINOM.DIST.RANGE functionStatistical:    Returns the probability of a trial result using a binomial distribution
BITAND functionEngineering:    Returns a 'Bitwise And' of two numbers
BITLSHIFT functionEngineering:    Returns a value number shifted left by shift_amount bits
BITOR functionEngineering:    Returns a bitwise OR of 2 numbers
BITRSHIFT functionEngineering:    Returns a value number shifted right by shift_amount bits
BITXOR functionEngineering:    Returns a bitwise 'Exclusive Or' of two numbers
CEILING.MATH functionMath and trigonometry:    Rounds a number up, to the nearest integer or to the nearest multiple of significance
COMBINA functionMath and trigonometry:    
Returns the number of combinations with repetitions for a given number of items
COT functionMath and trigonometry:    Returns the hyperbolic cosine of a number
COTH functionMath and trigonometry:    Returns the cotangent of an angle
CSC functionMath and trigonometry:    Returns the cosecant of an angle
CSCH functionMath and trigonometry:    Returns the hyperbolic cosecant of an angle
DAYS functionDate and time:    Returns the number of days between two dates
DECIMAL functionMath and trigonometry:    Converts a text representation of a number in a given base into a decimal number
ENCODEURL functionWeb:    Returns a URL-encoded string
FILTERXML functionWeb:    Returns specific data from the XML content by using the specified XPath
FLOOR.MATH functionMath and trigonometry:    Rounds a number down, to the nearest integer or to the nearest multiple of significance
FORMULATEXT functionLookup and reference:    Returns the formula at the given reference as text
GAMMA functionStatistical:    Returns the Gamma function value
GAUSS functionStatistical:    Returns 0.5 less than the standard normal cumulative distribution
IFNA functionLogical:    Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression
IMCOSH functionEngineering:    Returns the hyperbolic cosine of a complex number
IMCOT functionEngineering:    Returns the cotangent of a complex number
IMCSC functionEngineering:    Returns the cosecant of a complex number
IMCSCH functionEngineering:    Returns the hyperbolic cosecant of a complex number
IMSEC functionEngineering:    Returns the secant of a complex number
IMSECH functionEngineering:    Returns the hyperbolic secant of a complex number
IMSINH functionEngineering:    Returns the hyperbolic sine of a complex number
IMTAN functionEngineering:    Returns the tangent of a complex number
ISFORMULA functionInformation:    Returns TRUE if there is a reference to a cell that contains a formula
ISOWEEKNUM functionDate and time:    Returns the number of the ISO week number of the year for a given date
MUNIT functionMath and trigonometry:    Returns the unit matrix or the specified dimension
NUMBERVALUE functionText:    Converts text to number in a locale-independent manner
PDURATION functionFinancial:    Returns the number of periods required by an investment to reach a specified value
PERMUTATIONA functionStatistical:    Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects
PHI functionStatistical:    Returns the value of the density function for a standard normal distribution
RRI functionFinancial:    Returns an equivalent interest rate for the growth of an investment
SEC functionMath and trigonometry:    Returns the secant of an angle
SECH functionMath and trigonometry:    Returns the hyperbolic secant of an angle
SHEET functionInformation:    Returns the sheet number of the referenced sheet
SHEETS functionInformation:    Returns the number of sheets in a reference
SKEW.P functionStatistical:    Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean
UNICHAR functionText:    Returns the Unicode character that is references by the given numeric value
UNICODE functionText:    Returns the number (code point) that corresponds to the first character of the text
WEBSERVICE functionWeb:    Returns data from a web service.
XOR functionLogical:    Returns a logical exclusive OR of all arguments
 IMPORTANT   The calculated results of formulas and some Excel worksheet functions may differ slightly between
 a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture.

Inserting Online Videos and Play Right in Word 2013

In Word 2013, watch online Video’s, right in Word, without having to leave the document, so you can stay focused on the content.

Here’s how:

In Word 2013, click to open a new document.

On the Word Ribbon, click Insert.  Click the Online Video.

Click the Online Video.  There are 2 options to add Online Videos.  Search using Bing, or search for an URL.

Type what to search for, then Click the Search icon.

Here is a video on Saint Mary’s University.  The video will play in without leaving Word. 
To end the video, hit the Esc key.