Tip of the Week: Using Jump Lists

Application: Windows 7
A Jump List is a new feature allowing quick access to the documents or applications you use most frequently. Jump Lists can include recently opened files or folders, websites, and pinned items.  The Start menu contains a jump list recently opened and pinned programs. The Taskbar contains a jump list of open programs and programs or documents that you have pinned.
Adding documents to a Jump List Choose one of the following:    If the program appears on the Start menu Jump List, hover over that program title to see the list of recently used files. To the left of each document, click the pin icon. -or- Click Start, navigate to the program and open. When the program opens, click the File menu to see the list of recently used files. To the left of each document, click the pin icon.
Removing documents from a Jump List Highlight the selected closed document and click the pin icon.

A Blackboard Tip of the Week: Grade Center Smart Views

Tip: In Blackboard 9, you can create different views of your Grade Center which allow you to filter which students you view, the columns you view, or a combination of both which you can then switch to using the Current View dropdown.

Smart Views are useful for sorting groups of students. For example, if you have assigned individual graders specific students, you can create a different Smart View for each grader. If you have combined multiple sections into one Blackboard shell, you can create a Smart View for each section.

Here’s how to create a Grade Center Smart View:

1. Log into your course and ensure Edit Mode is ON.


2. Click on the Evaluation area of the Control Panel then select Grade Center in the expanded menu.


3. On the Grade Center page, click on the Manage button and then select Smart Views from the dropdown menu.


4. On the Smart Views page, click on the Add Smart View button.


5. On the Create Smart View page, enter a name (required) and description (optional) then select a Type of View from one of the following:
• Group (select individual groups)
• Benchmark (select users based on performance criteria)
• Focus (select individual users)
• Investigate (a combination of the first three)


6. Select the criteria you would like to use to limit users.
• NOTE: If you would like to create a view that only limits which columns you view but includes all students, select Benchmark for your view type and then make the criteria “Grade on Total Greater than or Equal to” 0.


7. Use Filter Results to choose which columns you would like to view.


8. Click Submit then OK. Your new Smart View will now be an option on the Current View dropdown located on the light blue filter bar.
• NOTE: If you do not see the Current View dropdown, click on the Filter button on the bottom right of the Grade Center header field.


• NOTE: You can make your commonly-used Smart Views favorites by clicking on the star in the Add as Favorite column so that it is green rather than grey. It will then appear in the Grade Center dropdown of the Control Panel.

Excel 2010 Conditional Formatting

Application: Excel 2010
Conditional formatting is a way of visually analyzing sets of data. Cells can be highlighted by pattern or color for criteria set in the rules.  Criteria can be high or low values, top or bottom numbers in a set, duplicate or single items, cells containing certain information, and even formula based. In Excel 2010, conditional formatting has been improved to include more icon sets, more options for data bars, and formatting across worksheets in a workbook.
Apply Conditional Formatting 1.    Select the data to apply conditional formatting. 2.    On the Home tab, in the Styles group, click the down arrow under Conditional Formatting. 3.    Select from the following: ·      Highlight Cells Rules-after selecting rule type (greater than, less than, = to, etc.) a dialog box will appear so that determining values can be entered. ·      Top/Bottom Rules -after selecting rule type (top 10, top 10%, bottom 10, bottom 10%, etc.) a dialog box will appear so that determining values can be entered. ·      Data Bars-choices include both solid and gradient fill patterns and colors. ·      Color Scales-choices include both two and three color scales. ·      Icon Sets-various types of icon patterns are offered. ·      New Rule-various rule types, format styles, value fields, and color options are available. To manage or clear rules, click the down arrow under Conditional Formatting  and select Manage Rules or Clear Rules.  For more information about conditional formatting in Excel 2010, visit the Microsoft Office article Add, change, find, or clear conditional formats.

Tip of the Week: Live Taskbar Preview

Application: Windows 7
The improved taskbar in Windows 7 allows you to see open items. This feature allows you to quickly switch between windows or documents.  Windows or documents can also be opened or closed from the taskbar.
Using Live Taskbar Preview ·         Hover the mouse over an icon on the taskbar. o   If the item is not open, a description will be shown. Click the icon to open. o   If the item is open, a thumbnail of each window or document will be shown. Click the thumbnail to open. o   To close a window or document, hover the mouse in the upper right corner of the item and click the red X.

Tip of the Week: Using Instant Search

Application: Outlook 2010
Instant Search has been improved in Outlook 2010. It is now possible search by fields such as sender, subject, or even attachments.  Using the Instant Search feature enables the Search toolbar which includes specific tools to search by field, recent search items, and what areas of Outlook to search.
Using Instant Search 1.    From the navigation pane, select the folder to search. 2.    Type search text in the Instant Search box located in the upper right part of the screen. 3.    A list of items containing the search text will appear. To search all folders for the search text, click Try Searching again in All Mail Items.

Sparklines

Application: Excel 2010
Sparklines are small charts that fit into one cell to visually summarize trends alongside data. Sparklines can be shown as a line, column, or win/loss format. When Sparklines are created, the Sparklines tools become available so that colors, placement, and styles can be modified.
Adding Sparklines 1.    In Excel, select an empty cell. 2.    Click the Insert tab. In the Sparklines group, select Line, Column, or Win/Loss. 3.  The Create Sparklines dialog box will appear. In the Data Range field, enter the cells to be used in the Sparkline calculation. In the Location Range field, enter the cell where the Sparkline is to be placed. 4.  Click OK.

Microsoft Office 2010 Tip of the Week

Application: Excel, Outlook, PowerPoint, Word 2010
New in Office 2010 is the Backstage View. The File tab replaces the Office Button. The Backstage view is a place to create, manage, and save files and to set options for the application. Each application will offer specific features in Backstage View to adjust settings.
Backstage options ·     Info tab: for adjusting permissions; viewing document properties (status, categories, last modified and printed dates, etc.), using the document inspector. ·  Save & Send: offers multiple options for sharing and sending documents via email, PDF or as an XPS, or save to SharePoint. ·  Options tab: application specific features to adjust settings.

Bookmarks within a document

Application: Word 2010
When Word documents are lengthy it can be useful to use bookmarks to aid in navigation of the document. For example, if a document contains a table of contents, it can be convenient to make it interactive. Each entry in the table of contents can be bookmarked with the corresponding area of the document. This feature can be used with table of contents, headings, key words, or pictures and images in the document.
Adding a Bookmark 1. Select the information to apply the bookmark. 2. On the Insert tab, select Bookmark. 3. The bookmark dialog box will open. Enter a name for the bookmark (with no spaces). Hyperlinking the Bookmark 1. Select the heading, table of contents entry, keyword, picture or image that will go to the bookmark. 2. Right-click and select Hyperlink. The Insert Hyperlink dialog box will open. In the Link to section, be sure that Place in this Document is selected. 3. Select the bookmark name. 4. Click OK. For more information, see the Microsoft Office article Add or delete bookmarks.