Document Properties in Microsoft

Application: Word, Excel, PowerPoint 2007 & 2010


Microsoft documents contain properties that can include the document title, author name, subject, and keyword tags. Using keyword tags can make searching for documents quicker and easier. When sharing documents with others, it is important to restrict editing if you do not want document properties changed.


Office 2007 document properties
1. In Word, Excel, or PowerPoint, click the Microsoft Office button.
2. Scroll to Prepare and then click Properties.
3. The Document Information Panel will appear. Update any fields listed.
Optional: Click the down arrow by Document Properties to view or update Advanced Properties.


Office 2010 document properties
1. In Word, Excel, or PowerPoint, click the File tab.
2. Click Info to view the document properties.
3. To update fields, click the field.
Optional: To see advanced properties, click Show All Properties.


Want to know more about document properties? Microsoft has more information for Office 2007 and Office 2010 users. When sharing documents with others, use the document inspector feature to reveal and remove hidden information. The Microsoft website features application specific articles about the document inspector feature.


For faculty, an interesting article from the Chronicle of Higher Education on Keeping Blind Review Blind by Anonymizing Documents.

Tip of the Week: mybrainshark

Web 2.0 Tools mybrainshark
Presentations that integrate both visual and audio can convey a message in ways that are appealing to audiences. Mybrainshark is a Web 2.0 tool that can be used to add audio via microphone or telephone to PowerPoint slides, documents, photos, videos, and creation of podcasts. The final product can be viewed online in a blog, unique URL on the mybrainshark site, email, or social media sites.


Highlights of the basic (free) account:
• Insert poll or survey questions
• Tracking data shows who, what, when, and where
• PowerPoint animations transfer
• Can add voice or MP3 files
• When uploading files, can add descriptions, categories, and keyword tags for easier searching
• Presentations can be modified at any time

Dividing Text in Excel

Application: Microsoft Excel 2007 & 2010


Have you ever needed to separate last name and first names in an excel spreadsheet? There are frequently times when spreadsheet data needs to be divided into more granular information in order to better sort, filter, alphabetize, or use in a mail merge independently.
Spreadsheets can be updated with Excel’s Text to Column command that can divide the data into separate columns.


Divide data in one column
*These steps apply to data where a space is used to divide. For data that is divided by commas or other, please see the article listed below.
1. Insert a column(s) where the divided data will be placed.
2. On the Data ribbon, select Text to Columns.
3. The Text to Columns Wizard will appear. In Step 1, select Delimited.
4. Click Next. In Step 2, select Space. Be sure to uncheck all other options.
5. Click Next. In Step 3, select Text.
6. Click Finish.

             

        becomes

For more information about this feature, please visit the Microsoft Office article.

Web 2.0 Tool of the Week: Second Life

Second Life is a 3-D virtual world entirely built and owned by its Residents. Since opening to the public in 2003, it has grown explosively and today is used by universities, businesses and individuals from around the globe.


An Invitation to See Second Life in Action
On April 12-13, TWU will host the Annual Student Creative Arts and Research Symposium. TWU uses Second Life during the symposium to allow students to present a virtual poster from off campus. As in real-life, presenters attend one session of the symposium by logging into Second Life from a computer and having their avatar present during a session. Students present their research to a global audience in addition to the visitors on the TWU campus.
A real-life viewing of Second Life will be available in ACT 225 and is open to the public. Student research will be presented at the following times in world:


Tuesday, April 12
12:00-12:50 p.m.
6-7:20 p.m.


Wednesday April 13
9-10:20 a.m.
12:15-1:00 p.m.
6-7:20 p.m.


In addition to a guided tour in ACT 225, visitors are welcome to try Second Life hands on in ACT 603 or from the convenience of your home. We invite you to join us in this celebration of student research!

Tip of the Week: Adding to My Links

Application: SharePoint
SharePoint has its own bookmarking option to allow for direct navigation to frequently used sites. Both SharePoint and other internet sites can be bookmarked. This list of links or bookmarks can be accessed anywhere through SharePoint.

How to add a link or bookmark in SharePoint
1. Go to Share.twu.edu. (From on campus)
2. Navigate to a specific page. For example, click on Instructional Support Services, then select Denton, then select Training.
3. In the upper right corner of the page, click on My Links.
4. Select Add to My Links.
5. A dialog box appears. Make any optional changes needed such as the name of the link, who can view the links, which group to add the link to or create a new group of links.
6. Click OK.

Tip of the Week: Managing Multiple Schedules

Applications: Outlook & SharePoint
Scheduling a meeting with multiple people or managing multiple schedules for various projects can be challenging. Offices use calendars to schedule meetings, vacations, phone coverage, appointments and more. To manage multiple schedules, there are several technology tools available.

Scheduling MeetingsMicrosoft Outlook calendars offer schedule availability options. Each faculty and staff member can designate times as busy, free, tentative, or out of the office. To schedule a meeting in Outlook:

1. Click on the calendar tab in the navigation pane
2. Select the date for the meeting
3. Right-click to open the dialog box and choose an option such as New Appointment, New All Day Event, New Meeting Request, etc.
4. A new dialog box will open. Select options for title, location, length of meeting, reminders, importance, etc.

When inviting others to a meeting with a meeting request, they are given the option to accept, decline, or mark tentative. The meeting request then keeps track of who has responded and how.

Office Calendars
When working with a group of people, SharePoint calendars can be used. The flexibility of SharePoint allows multiple calendars to be built in any site. A different calendar can be used for each project or person. SharePoint calendars can be connected to Outlook for ease of adding and modifying events. SharePoint also has options to determine levels of access to view, edit, or delete events.

Tip of the Week: Dropbox

Web 2.0 Tools Dropbox

Many people work from multiple locations or computers. Some need to access the same file from any location. Files uploaded to Dropbox can be accessed from different computers (Windows, Mac, and Linux), smartphones, or the Dropbox website.

What are the advantages?
• As files are saved in a Dropbox folder, the file is updated from every access point (multiple computers, smartphone)
• Entire folders or individual files can be shared with others
• Files are backed up on the Dropbox server
• Basic account is free with up to 2GB
• File history is kept for 30 days so earlier versions can be restored
• Unlimited undo option
• Files of any type can be stored
• Encryption for both storage and transfer of files
• When using Dropbox to collaborate with others, everyone can see changes when file is saved

Tip of the Week: Using My Site in SharePoint

Application: SharePoint

Each TWU faculty and staff has a My Site space in SharePoint. This is an internal website that can be used to store documents, keep a calendar, project tasks and more. SharePoint is available from on or off campus, making it a flexible way to store and manage information. There are two parts of My Site: My Home and My Profile.

Using My Home in SharePoint
• Personal place to store documents, calendars, surveys, tasks, and lists
• Permissions can be set by item to determine who can view or edit
• Many items can be linked to your Outlook account to view and edit through Outlook

Using My Profile in SharePoint
• Professional public profile page
• Fields to offer information about professional affiliations, skills, contact info, reporting hierarchy
• Option to display a picture