Want to know how to change the default line spacing in Word 2007? Or how to create multiple signatures in Outlook? Need help submitting a paper through TurnItIn? Are you interested in learning more about Second Life?  Check out the new TTC video tutorials on YouTube! http://youtube.com/user/cortlandttc

Over thirty videos created by the technology trainer, Tera Doty-Blance, are now available and cover various topics on Outlook 2007, Word 2007, Excel 2007, Adobe Acrobat Professional, iTunesU, SecondLife, TurnItIn and more! 

Go to http://youtube.com/user/cortlandttc  to see the currently available videos, more will be added soon.  If you have a suggestion for a video tutorial, please send it to Tera Doty-Blance at dotyblancet@cortland.edu

To add the Anova Data Analysis function to Excel 2007, start by opening Excel and clicking on the Office button at the top left of the screen. At the bottom of the drop down menu, click on the’ Excel Options’ button.

The Excel Options window will open. In the column on the left, click on the Add-Ins heading. On the right side of the window, scroll down to Inactive Application Add-Ins and click on ‘Analysis ToolPak’ to select it. Then click the Go Button.

An ‘Add-Ins’ window will open. Click in the checkbox next to ‘Analysis ToolPak’ and click the OK button. Another window may open that says Excel can’t run the add-in until you install the feature. Click Yes.

The Microsoft Office Configuration window will launch. This can take a minute or two to configure. When it is finished, click on the Data tab and the Anova Data Anaylsis function will appear in the Anaylsis group on the right side of the ribbon.

For more text tutorials, visit the Technology Training Center website at http://library.cortland.edu/ttc/materials.asp 

Below you will find links to many useful text based (with screen shots) tutorials on Microsoft PowerPoint 2007 from the University of Wisconsin-Eau Claire

PowerPoint Background Information

• The Office 2007 Environment
• PowerPoint Terminology
• Keyboard Shortcuts
• The PowerPoint Views

PowerPoint Basics

• Basic PowerPoint Tasks
• Making Your Presentation
• Working with a Slide Master
• Working with Text
• Working with Bullets and Numbering
• Printing Your Presentation
• Viewing Your Presentation Outline
• Working with Handouts

Working with Objects

• Modifying Objects
• Using Color
• Using Fill Effects
• Working with Images
• Using Animation
• Creating an Organization Chart

Customizing PowerPoint

• Customizing Slide Elements
• Using the Slide Sorter View
• Customizing a Master Slide
• Working with Design Themes
• Capturing Images, Sounds, and Movies
• Using Sounds and Video

PowerPoint Diagrams

• Working with SmartArt: An Overview
• Working with SmartArt
• SmartArt Formatting Options
• Animating SmartArt

More PowerPoint Features

• Charting Information
• Adding Links
• Making Your Presentation Portable

Viewing Online Presentations

• The Environment
• Creating a Web Presentation
• Working with Online Presentations

Inserting Clip Art

• Overview of Clip Art
• Using Clip Art
• Importing Clip Art from the Web

Using Microsoft Office Help

Below you will find links to many more useful text based (with screen shots) tutorials on Microsoft Excel 2007 from the University of Wisconsin-Eau Claire

Working with Excel

• Getting Started with Excel
• The Office 2007 Environment
• Pointer Shapes
• Worksheet Terms
• Formatting Cells
• Formatting Numbers
• Working with Conditional Formatting
• Editing Cell Contents
• Calculating with Functions
• Calculating Subtotals
• Working with Rows and Columns
• Importing an External Data File

Printing with Excel

• Printing Basics
• Using Printing Options
• About the Page Setup Dialog Box
• Customizing Page Layout
• Adding Headers and Footers
• Modifying Headers and Footers
• Other Printing Options
• Using Print Preview

Special Features

• Working with Comments
• Using the Fill Command
• Using the Paste Special Feature
• Using the Find and Replace Features
• Hiding Columns, Rows, and Cells
• Separating Cell Data
• Sorting Data

Working with Tables (database functions)

• Tables Overview
• Creating Tables
• Establishing Criteria
• Filtering Your Table
• Analyzing Your Tables with Functions
• Working with Pivot Tables href=”Excel07/subtotal.htm” mce_href=”Excel07/subtotal.htm”>

Managing Your Excel Worksheet

• Organizing Worksheets
• Working with Groups of Worksheets
• Referenceing Cells with Names
• Navigating Your Large Workbook
• Performing Calculations with Formulas
• Cell References: Relative and Absolute
• Correcting Circular References
• Protecting Your Files and Worksheets

Charting with Excel

• About Charting
• Guidelines for Charting
• Getting Ready to Chart
• Creating a Basic Chart
• Formatting Your Chart
• Working with Chart Elements
• Charting Extras

Favorite Excel Functions

• Rank
• Countif and Sumif
• Concatenate
• Subtotal
• Inserting Dates and Times

Automating Excel with Macros

Inserting Clip Art

• Overview of Clip Art
• Using Clip Art
• Importing Clip Art from the Web

Using Microsoft Office Help

Below you will find links to even more useful text based tutorials (with screen shots) on Microsoft Word 2007 from the University of Wisconsin-Eau Claire

Word Environment

• The Office 2007 Environment
• Customizing Toolbars

Word Basics Series

• Learning Document Basics
• Editing a Document
• Working with Spell Check
• Using Grammar Check
• Paragraph Formatting Options
• Page Formatting Options
• Working with Text Options
• Saving in Alternate Formats
• Printing Options for Specific Pages
• Hyphenation Options
• Inserting Symbols and Special Characters (video: Inserting Symbols)
• Setting Tabs
• Borders and Shading Options

Bullets & Numbering

• Using Bulleted Lists
• Using Numbered Lists
• Customizing Bulleted and Numbered Lists

Using Outlining

• Outlining: Using Outline Numbering
• Outlining: Bullet and Numbering Options
• Outlining: Using the Outline View

Organizing Information with Word Tables

• Table Basics
• Creating a Table from Existing Text
• Table Options
• Navigating and Selecting within a Table
• Merging and Splitting Table Cells
• Resizing Table Elements
• Formatting Tables
• Adding Borders and Shading
• Using the Sort Feature
• Calculations within Tables

Inserting Fields and Text

• Summary of Word Fields
• Inserting Fields

Using Word Styles

• Styles: An Overview
• Style Basics
• Advanced Style Options
• Style Organizer

Working Collaboratively

• Working with the Track Changes Feature
• Protecting a Document
• Combining Word Files

Curing Auto Headaches

• AutoCorrect: Corrections and Replacements
• AutoCorrect: Automatic Formatting

Automating Your Work

• Working with Templates
• Automatic Page Cross-References
• Generating a Table of Contents
• Using Find and Replace
• Creating Macros
• Working with Macros
• Working with Bibliographic Sources
• Working with Bibliographic References

Labels and Envelopes

• Labels: An Overview
• Creating Labels
• Customizing Labels
• Working with Envelopes
• Additional Options for Creating Envelopes

Mail Merge and Form Letters

• Mail Merge: An Overview
• Mail Merge Terminology
• Working with the Recipient List
• Filter and Sort Options
• Creating Merged Letters
• Using an Excel Database for Mail Merge
• Creating Merged Mailing Labels
• Creating Merged Envelopes
• Creating an Email Merge

Customizing Word

• Changing Word Default Selections
• Adding a Dictionary
• Removing Hyperlink Formatting from URLs
• Working with File Properties

Inserting Clip Art

• Overview of Clip Art
• Using Clip Art
• Importing Clip Art from the Web
• Importing Clip Art from the Office 2003 Server

Inserting WordArt

• Using WordArt
• Editing WordArt

Working with the Equation Editor

• The Equation Editor Environment
• Creating Fractions
• Inserting Built-in Equations and Structures
• Equation Editor Options
• Creating Custom Mathematical Expressions

Miscellaneous Topics

• Working with Columns
• Creating Headers and Footers
• Working with Images
• Adding and Removing Watermarks
• Adding Line Numbers
• Using Microsoft Office Help

The University of Wisconsin-Eau Claire has made all their fantastic tutorials on Office 2007 available online. Below you will find links to text based tutorials (with screen shots) on Microsoft Outlook 2007.

General Information

• The Office 2007 Environment
• The Outlook Environment
• Managing Your Account Quota
• Off Campus Access to Email: POP3 Server
• Off Campus Access to Email: Without VPN
• Emptying the Deleted Items Folder

Email Overview

• Basic Email Activities
• Locating Recipients
• Additional Email Activities (forward,reply, send to contacts)
• Working with Attachments
• Working with Signatures
• Automating Appearance with Stationery
• Automating Content with Templates

Organizing & Managing Email

• Options for Managing Email: An Overview
• Managing Your Email
• Sorting Your Email Messages
• Managing Email with Folders
• Viewing Email with Filters
• Using Junk E-mail Filters
• Using Rules to Organize Your Email
• Modifying Existing Rules

Additional Options

• Message Options
• Creating Out of Office Replies
• Email Message Formats
• Customizing Email Settings
• Customizing Column Headings
• Recalling Sent Messages

Archiving

• AutoArchiving: An Overview
• Working with AutoArchive Default Settings
• Customizing AutoArchive Settings
• Enabling and Disabling AutoArchiving
• Working with Archived Items
• Manual Archiving
• Compacting the Archive Folders

Navigation Pane

• General Navigation Pane Options

Calendar Basics

• The Calendar Environment
• Scheduling Appointments
• Scheduling Events
• Modifying Appointments & Events

Additional Calendar Features

• Using the Scheduling Assistant
• Working with Group Schedules
• Granting Others Access to Your Calendar
• Working with Shared Calendars
• Viewing a Public Calendar as Shared
• Adding a Mailbox to Your Folder List
• Creating a Public Calendar

Calendar Customization & Options

• Customizing Your Calendar
• Calendar: Working with Holidays
• Color Coding Appointments
• Printing Your Calendar

Contacts Overview

• Contacts Viewing Options
• Working with Contacts
• Assigning Contacts to Categories
• Working with Distribution Lists

Using Microsoft Office Help

Faculty, Staff and Students can activate space on web.cortland.edu or studentweb.cortland.edu, respectively, for creating a website.  This tutorial, http://library.cortland.edu/ttc/materials/setting_up_dreamweaver.pdf with screenshots and step by step instructions, will walk you through the process of connecting to the server space through Dreamweaver.

Additional Tutorials can be found at http://library.cortland.edu/ttc/materials.asp 

The Office 2007 rollout has begun! With the new Office suite, comes new file formats which result in backwards compatability issues with previous versions of Word, Excel, and PowerPoint.  Fortunately, there is a free tool from Microsoft that will allow previous versions of these programs to open, edit, save and create files using these new formats.

For more information, and a link to download the compatibility pack, visit Microsoft’s website at http://office.microsoft.com/en-us/products/HA101686761033.aspx 

Starting this Fall, we are inviting faculty to participate in the iTunesU program.  Below are the policies and procedures for the program.  If you have any questions, please contact Tera Doty-Blance ( dotyblancet@cortland.edu )

Registration – An online form will be available at the Cortland iTunesU website http://www.cortland.edu/itunesu , where instructors can request course space in iTunesU.  Instructors will need to provide their course name, course number, and CRN from Banner.  After this information has been submitted to the iTunesU administration, training must be scheduled before the course space will be created. Until the online form is made available, iTunesU course requests should be made directly to the Technology Trainer (Tera Doty-Blance – dotyblancet@cortland.edu , 753-4056) 

Training – Instructors will be required to participate in two workshops, one on course management and one on podcast production, before the creation of their course space in iTunesU.  The first workshop, on managing the course space will provide information on logging into the system, how and what sections of the course interface to edit, managing the student drop box, student versus instructor interfaces, proper file naming schemes and file management.  The second workshop will cover podcast production on either the mac or pc platform, using Garageband, iMovie and/or Camtasia Studio.  This production workshop will provide instruction in use of the software as well as additional hardware and file storage considerations.  Student podcast production considerations and support will also be discussed. 

Support –   Instructors can request in class presentations on Garageband, iMovie or Camtasia Studio by the Technology Trainer (Tera Doty-Blance) or the Multimedia Production specialist (Dawn VanHall).  Such requests and scheduling will be made through the Coordinator of Instruction Librarian (Daniel Harms – 753-4042, harmd@cortland.edu ) Instructors are requested to provide information on student podcast assignments, such as scope of project, required elements, due date, etc, to the Coordinator of Instruction.  This is for the purpose of coordinating support and equipment availability. 

Equipment –  Multimedia production and recording equipment is available at the circulation desk in the Memorial Library.  External Hard drives, Digital Video Cameras, Digital Still Cameras, TuneTalk Microphones and iPods are available for loan and use outside the library. USB Microphones are available for in house use only.  The two multimedia rooms in the library are available for 3 hour periods and each contain a production level Mac and PC and software.

On the Information Resources Website, there is link to a PDF guide to Using USB Drives at SUNY Cortland

You should review this guide BEFORE you purchase one. Please note, we are starting to see users having problems using their usb drives on the campus computers because certain brands of usb drives require drivers or backup programs to be installed on Windows computers. (Macs will ignore the software and do not experience this problem). That means they will not work on the authenticated machines on campus.  Keep this in mind before you make your purchase.

Also, you should be aware that users have 200 MB of storage space on the network, which they can access from any computer on campus. Just log in using your network id, then open ‘my computer’. The ‘Username on Shares: U:’ drive is listed here