Each week, the IT Representatives Network (IT-REPS/REPTICs) offers brief tutorials in the form of video clips that were developed to support the development of ICT Profile abilities. These clips are specifically designed for students, but are useful to anyone that wants to improve their technology skills.

Please note that it is possible for you to embed the video clips from the ICT Profile for Students into your blog or web page. To do this:

• Click on the link that appears to the lower left of each video (it looks like this: © World of Images, CCDMD). This link will take you to the clip on the World of Images web site.
• Near the top of the page click on “</> Embed Video”
• Copy and paste the text that corresponds to the size of the video you would like to integrate into your blog or web page.

List of Clips

• Documenting Data, Facts, Observations, Concepts, Ideas or Reflections
• Main parts of a spreadsheet
• Marking-up and Annotating Digital Documents
• Perform Visual Representation of the Information Using a Concept Map
• Selecting the Presentation Format and Tool for Your Information
• Using Graphics to Display Information Visually
• Use Graphics to Represent Ideas
• Use the “Average” and “Sum” Functions
• Use the Data Filter

Documenting Data, Facts, Observations, Concepts, Ideas or Reflections

Documenting data, facts, observations, concepts , ideas or reflections allows you to better organize the information that you gather as well as facilitating its analysis. This tutorial shows you how to consolidate your notes and gather them in one place, thus avoiding scattering yourself when achieving your schoolwork.

The video clip Documenting data, facts, observations, concepts, ideas or reflections is a tutorial that helps to develop the following skill of the ICT Profile for College Students:

• Skill  2 Process Information
  • 2.1 Identify Pertinent Elements of Information
    • 2.1.2 Document data, facts, observations, concepts, ideas or reflections

Main parts of a spreadsheet

To optimize your work, what better way is there than to master the main elements of a spreadsheet interface: the workspace, the options and the menus. This 3 minutes tutorial describes how to insert data in a spreadsheet, add, copy or delete cells, rows, columns or a whole sheet. The 2010 version of Excel is used in this clip: even if spreadsheet software varies from one to another, they remain quite similar.

The clip Master the basic functions of a presentation software is a tutorial that helps to develop the following skills of the ICT Profile for College Students:

• Skill 2 Process information
  • 2.1 Analyze Information
  • 2.3 Visually Represent Information
• Skill 5 Use ICTs in an Efficient and Responsible Manner
  • 5.2 Learn on a Self-Sustaining Basis
    • 5.2.2 Explore new software

Marking-up and annotating digital documents

Marking-up and annotating digital documents are efficient ways to highlight information which is considered important, and therefore to retain and understand the essence of their content. This greatly contributes to collaborative work. This tutorial will help you to use these techniques in different software such as Adobe Reader, word processing, spreadsheet or presentation software.

The video clip Marking up and annotating digital documents is a tutorial that helps to develop the following skill of the ICT Profile for College Students:

• Skill 2 Process Information
  • 2.1 Identify Pertinent Elements of Information
    • 2.1.1 Mark and annotate digital documents

Perform visual representation of the information using a concept map

Visually representing information using a concept map allows you to organize ideas and to structure them into diagram. This 6 minute tutorial explains how to create a concept map that will help you to prepare an oral presentation, review your course and lecture notes before an exam, create resumés or simply bring your ideas together.

The clip Perform visual representation of the information using a concept map is a tutorial that helps to develop the following skill of the ICT Profile for College Students:

• Skill 2 Process Information
  • 2.3 Visually Represent Information
    • 2.3.3 Perform visual representation of the information

Selecting the Presentation Format and Tool for Your Information

Selecting the presentation format and tool for your information that is best adapted to processing your data allows you to present the most important elements, clearly and effectively. This tutorial helps you choose the right type of presentation and to better organize your ideas, reflections and observations.

The video Selecting the representation format and tool for your information is a tutorial that helps to develop the following skills of the ICT Profile for College Students:

• Skill 2 Process Information
  • 2.3 Visually Represent Information
    • 2.3.1 Organize the information to be represented
    • 2.3.2 Choose the type and appropriate tools of representation

Using graphics to display information visually

Using graphics to display information visually allows you to communicate complex ideas clearly and with precision, as long as certains rules are followed. This tutorial explains the structural elements that should be used to make graphics, as well as advice that will help you to take full control of your tools.

The clip Using graphics to display information visually is a tutorial that helps to develop the following skill of the ICT Profile for College Students:

• Skill 2 Process Information
  • 2.3 Visually Represent Information
    • 2.3.3 Perform visual representation of the information

Use Graphics to Represent Ideas

It can be very useful to use tables or graphics to represent ideas, to process data or even to compare qualitative information. This 4 minutes video clip explains how to create a diagram that will illustrate a process, using the SmartArt tool in PowerPoint 2010. Several other programs or on-line applications could also be useful to elaborate concept maps or tables for qualitative data processing.

The clip Use graphics to represent ideas is a tutorial that helps to develop the following skill of the ICT Profile for College Students:

• Skill 2 Process Information
  • 2.3 Visually Represent Information
    • 2.3.3 Perform visual representation of the information

Use the “Average” and “Sum” Functions

With a spreadsheet, there are many ways to add or to calculate the average for data from a range of cells. To efficiently use a spreadsheet, you should familiarize yourself with the AVERAGE and AutoSum functions. This is the topic for the following 4-minutes video. The 2010 version of Excel is used to illustrate in this example. You will notice that spreadsheets vary from one software package to another. However, they have many similarities.

The clip Use the “Average” and “Sum” Functions is a tutorial that helps to develop the following skills of the ICT Profile for College Students:

• Skill 2 Process information
  • 2.2 Analyze Information
    • 2.2.2 Conduct an analysis of the information
• Skill 5 Use ICTs in an Efficient and Responsible Manner
  • 5.2 Learn on a Self-Sustaining Basis
    • 5.2.2 Explore new software

Use the Data Filter

Automatic and custom filters are very useful to quickly consult and process data within a spreadsheet. This 3-minute video clip explains how to create and use filters to display data that corresponds to very specific criteria.

The video Use the data filter is a tutorial that helps to develop the following skill of the ICT Profile for College Students:

• Skill 2 Process Information
  • 2.2 Analyse information
    • 2.2.2 Conduct an analysis of the information
  • 2.3 Visually Represent Information
    • 2.3.1 Organize the information to be represented