ICT Training

University of Saskatchewan

Archive for August, 2007

Training Schedule for the Week of September 3rd

Posted in Uncategorized on August 31, 2007 by

Podcasting – Use, Production and Distribution, Education rm 3126
September 4, 2007 1:30 pm – 4:30 pm
Access – Intermediate Course, Arts 110A
September 4, 2007 9:00 am – 12:00 pm and
September 6, 2007 9:00 am – 12:00 pm and
September 11, 2007 9:00 am – 12:00 pm

Sorting/Grouping Emails in Outlook

Posted in Did you Know? on August 31, 2007 by

To quickly view all emails from one person:
Highlight one email from that person. Then click heading label at the top of the From: column
This will cause emails in that mailbox folder to be sorted on whom the email is from, and also place you down the list within the emails from the person you highlighted.
To show by date, grouping dates:
Click on Received: heading label to sort on Date. (Note: clicking a second time on the same heading label sorts in reverse order) Open the View Menu > Arrange By > Show in Groups. The emails within the folder will be in Date order and dates will be grouped.

Do You Talk to Your Computer?

Posted in Did you Know? on August 31, 2007 by

Most of you have probably heard of speech recognition, but did you know it can be accessed through the Microsoft Application Suite? This feature allows you to dictate content and execute instructions, verbally, within Excel, Word, Outlook, PowerPoint and Access. For example, to exit any application, you simply say “File Exit”.
To implement speech recognition functionality, you must first train the application to recognize your voice. Like anything else, the more you train, the better the results.
The Speech tool is found in the “Tools” menu of each Microsoft application. Try it out!

Training Schedule for the Week of August 27th

Posted in Uncategorized on August 24, 2007 by

PowerPoint Intermediate – Getting To Your Audience, Arts 110A
August 27, 2007 9:00 am – 12:00 pm and
August 29, 2007 9:00 am – 12:00 pm
Microsoft Project – Intermediate Course, 6E04, Agric
August 28, 2007 9:00 am – 4:00 pm
Podcasting – Use, Production and Distribution, Education rm 3126
August 28, 2007 1:30 pm – 4:30 pm
PAWS Introduction Course, 281, John Mitchell
August 30, 2007 9:00 am – 12:00 pm
Blackboard Learning System Quizzes & Surveys Workshop (formerly WebCT), Arts 110A
August 30, 2007 1:30 pm – 4:30 pm

What is a “Clicker” Anyway?

Posted in Did you Know? on August 17, 2007 by

Do you know about the “Clickers” technology on Campus? This technology is facilitated through a response device or keypad. It provides an interactive learning experience for students allowing instructors to quickly gather, compile and assimilate student feedback into the current lecture. When the instructor poses a question, students reply by pressing a button on the clicker. All of the participant responses are tallied and graphically displayed on a PowerPoint slide. As a result, both presenter and student can immediately assess the conceptual understanding of a particular topic.
Not all classes require clickers at this time but soon this technology will be campus wide.For more information, search for “clickers” on the U of S website.

Training Schedule for the Week of Agust 20th

Posted in Uncategorized on August 17, 2007 by

Access – Introduction Course, Agriculture, 2E17
August 20, 2007 9:00 am – 12:00 pm and
August 22, 2007 9:00 am – 12:00 pm
Blackboard Learning System Course Design Basic – Intro Course, Arts 110A
August 21, 2007 2:00 pm – 5:00 pm
UniFi – Extended FAST Queries, 281 John Mitchell
August 22, 2007 1:30 pm – 3:00 pm
Outlook – Introduction Course, Library 161
August 24, 2007 1:30 pm – 4:30 pm

Web Queries for Excel

Posted in Did you Know? on August 10, 2007 by

Did you know …?
You can pull table information directly from a Website on the Internet into Excel quite easily. “Cut & Paste” does not always work well, often merging cells and setting formats that are quite difficult to manage and contradict data rules that would allow for sorting, etc.
The Data menu has a tool available for bringing Internet information into Excel cleanly.
Position in your worksheet where you would like your data to appear. Select Data menu > Import External Data > New Web Query … Use the New Web Query dialog box to navigate to the website information you desire. You will notice a number of small arrow buttons located to the left of each distinct unit of data within the webpage. Click the arrows to select the table(s) of data you wish to import. Once your selections are made, click the Import button. Press the OK button to consent to the location for the information to be placed.
You will notice a special External Data toolbar appears. This allows you to click Refresh (!) button to re-summon the website table for any changes. If you wish to remove the link to the website data, click the Data Range Properties button on the External Data toolbar, and remove the checkmark from Save Query Definition.

Training Schedule for the Week of August 13th

Posted in Uncategorized on August 10, 2007 by

Digital Imagery – Introduction Course, Physics 130
August 13, 2007 9:00 am – 11:30 am and
August 15, 2007 9:00 am – 11:30 am
Dreamweaver – Introduction Course, Arts 110A
August 14, 2007 9:00 am – 12:00 pm and
August 16, 2007 9:00 am – 12:00 pm
ArcGIS Introduction Course, Arts 277
August 14, 2007 9:00 am – 4:00 pm
PAWS Intermediate Course, 281, John Mitchell
August 14, 2007 9:00 am – 12:00 pm
UniFi – Purchase Requisition Training, 281 John Mitchell
August 15, 2007 1:30 pm – 4:30 pm
Word Speech Recognition, 63.1, Physics
August 16, 2007 1:30 pm – 3:30 pm