ROUTES: IVASS TRAINING - IVASS UPDATE
Ivass Thematic Area: INFORMATICA

DURATION

5 hours

CONTENTS

COURSE 1 MICROSOFT OFFICE 2013 - Word - Single Level

Contents:

MODULE 1 - Getting started with Word

  • Know the work environment
  • Open a Document
  • Save a Document
  • Print a Document

MODULE 2 - Text and paragraph formatting

  • The concept of paragraph
  • Character commands
  • Paragraph commands

MODULE 3 - Distribute the text

  • Page break
  • Layout
  • Text break
  • The Tabulations

MODULE 4 - The styles

  • Apply a style
  • Create a new style
  • Change a style

MODULE 5 - The Tables

  • Insert a new table
  • Format a table
  • Define the layout of a table

MODULE 6 - Images

  • Insert a picture
  • Adjust an image
  • Set the style of an image
  • Arrange the illustrative elements
  • Change the size

MODULE 7 - The text boxes and shapes

  • Insert a shape
  • Format a shape
  • Edit a shape
  • Insert a text box
  • Format a text box

MODULE 8 - Textual elements and symbols     

  • The Quick Parts button
  • The WordArt button
  • The Drop Cap button
  • The Date and Time button
  • The Equation button
  • The Symbol button

MODULE 9 - Page Layout and Sections

  • The themes
  • The background setting
  • Document formatting
  • The formatting of the sections
  • The header and footer

MODULE 10 - The final revision

  • Check spelling and grammar
  • The Thesaurus button
  • The Translate button
  • The Language button
  • The Word Count button

MODULE 11 - Collaborative review                           

  • The Comments group
  • The Change Tracking group
  • The Revisions group
  • The Protect group
  • The Compare group

MODULE 12 - References        

  • The Summary group
  • The Footnotes group
  • The Citations and Bibliography Group
  • The Captions group
  • The Index group
  • The Links group

MODULE 13 - Master documents         

  • Getting to know a master document
  • Create the structure of the master document
  • Create the master document
  • The Compress Subdocuments button
  • Manage secondary documents

MODULE 14 - The mail union            

  • The mail merge
  • The main document
  • Enter the data source
  • Insert the merge fields
  • Preview and merge the two documents

 

COURSE 2 MICROSOFT OFFICE 2013 -  Excel Base

Contents:

MODULE 1 - The basics of Excel

  • Know the work environment
  • Open a workbook
  • Know the folders
  • Activate a cell
  • Select the intervals
  • Enter and edit information
  • Save and close a folder

MODULE 2 - The cells

  • Set the format of a cell           
  • Choose cell styles        
  • Conditional formatting     
  • Apply conditional formatting            

MODULE 3 - Operations on cells

  • Use the Copy, Paste, Cut functions          
  • Use the Format Painter command     
  • Set the font  
  • Align the text            
  • Insert and delete items in a workbook         
  • Use the cell format options.       

MODULE 4 -  The tables

  • Insert a table      
  • Name a table  
  • Resize a table      
  • Convert a table to a range of cells  
  • Export the data of a table   
  • Set the style of a table             
  • Changing the style of a table: example of a total row

MODULE 5 -  The formulas

  • Use formulas     
  • Define ranges in functions
  • Insert a quick function     
  • Use the Fill command

MODULE 6 -  The graphs

  • Choose and insert a chart  
  • Edit a chart   
  • Change and customize the type of a chart
  • View the analysis of a graph           

MODULE 7 -  The page setup

  • Manage page settings 
  • The Page Layout tab       
  • Repeat row and column titles          
  • Insert page breaks            
  • Remove page breaks       
  • Set the margins      
  • Manage orientation
  • Set the print format
  • The Print Area button        
  • The Fit to Page group      
  • The Sheet Options group       
  • The Themes group

MODULE 8 - Images

  • Insert a picture   
  • Adjust the image    
  • Reset the image           
  • Set the style of an image         
  • Insert a picture from the web 
  • Arrange the illustrative elements
  • Change the size           

MODULE 9 -  The SmartArt

  • Use smartArt   
  • Edit SmartArt
  • Set the layout       
  • Choose styles             
  • Reset SmartArt           
  • Choose shapes, styles and WordArt
  • Define the size and position relative to other graphics                  

 

COURSE 3 MICROSOFT OFFICE 2013 -  Advanced Excel

Contents:

MODULE 1 - THE DISPLAY AND AUTOMATION OF DATA

  • The View tab
  • Manage zoom
  • The viewing modes
  • Set up a custom view
  • The visualization tools
  • Lock the worksheet titles
  • Divide the worksheet
  • Compare two worksheets
  • Compare multiple worksheets
  • Manage windows
  • Making macros
  • Manage macros

MODULE 2 - MODIFICATION OF DATA

  • Custom number formats
  • Automatic filling
  • Custom lists
  • Data validation
  • Apply Data Validation

MODULE 3 - DATA REVIEW

  • The auditing activity
  • Spell check
  • Apply spell check          
  • Use synonyms and antonyms
  • Use the multilingual dictionary
  • Enter a comment
  • Manage comments        
  • Protect the worksheet
  • Protect the workbook
  • Share the workbook
  • View revisions
  • Accept or reject revisions

MODULE 4 - IMPORT OF DATA

  • Introduction
  • Import data from Access
  • Text File
  • Import data from Text
  • XML file
  • Import data from XML

MODULE 5 - DATA ORGANIZATION

  • Define a database
  • Organize the data
  • Sort the data
  • Sort data based on multiple criteria
  • Sort data based on multiple criteria
  • Filter the data
  • Run the Filter command
  • Criteria for filtering
  • Divide the text into a column
  • Text to Columns Wizard
  • Remove duplicates
  • Calculate subtotals
  • Find and replace information
  • Use an Excel data list in the Word mail merge procedure
  • How to use an Excel data list in Word mail merge procedure

MODULE 6 - ADVANCED FORMULAS

  • Use formulas
  • Learn about the SE function
  • Understanding the syntax of the SE formula
  • Enter the formula SE
  • Use the Insert Function command
  • Know the COUNTIF formula
  • Enter the COUNTIF formula
  • Know the SUM formula
  • Enter the formula DB.SUM
  • Know the DB.MEDIA formula
  • Know the VLOOKUP formula
  • Know the syntax of the VLOOKUP formula
  • Enter the VLOOKUP formula
  • Know the STRING.EXTRACT formula
  • Enter the formula STRING.EXTRACT

MODULE 7 - TABLES AND THE PIVOT GRAPH

  • Get to know the pivot table
  • Examine a pivot table
  • Insert a pivot table          
  • Edit a pivot table
  • Update the data and view the detailed data
  • Filter the data of a report
  • Group the data
  • Grouping of text elements
  • Group by date and time or by numeric ranges
  • Pivot chart
  • Insert a pivot chart
  • Filter and edit data in a pivot chart

 

COURSE 4 MICROSOFT OFFICE 2013 -  Power point

Contents:

MODULE 1 - Getting started with PowerPoint

  • Know the work environment
  • Open a Presentation
  • Save and close a Presentation

MODULE 2 - Basic operations

  • Audio Video Title Code
  • Set up your slides
  • Choose a theme
  • Set the wallpaper
  • Choose the layout
  • Insert content
  • Insert a new slide

MODULE 3 - The text boxes and shapes

  • Insert a text box
  • Set the style
  • Insert and edit a shape

MODULE 4 - The Images

  • Insert a picture
  • Adjust an image
  • Set the style of an image
  • Arrange the illustrative elements
  • Change the size

MODULE 5 - The Tables

  • Insert a table
  • Set the style of a table
  • Set the style options
  • Insert and delete rows and columns
  • Merge or split cells
  • Set the size of the cells
  • Manage text alignment

MODULE 6 - The SmartArt

  • Use SmartArt
  • Edit SmartArt
  • Choose styles
  • Reset SmartArt
  • Change the individual elements

 

MODULE 7 - Graphs

  • Choose and insert a chart
  • Choose the graphic layout
  • Choose the styles of the chart
  • Change the chart type
  • Set the graphic format from the contextual tab
  • Other Formatting Modes

MODULE 8 - Multimedia elements

  • Insert a movie
  • Set options for a movie
  • Insert an audio contribution
  • Set the audio options
  • Set the audio changes
  • Enter a subject
  • Create a photo album

MODULE 9 - The text

  • Format the text
  • Format the paragraph
  • Copy, cut and paste
  • Search and replace

MODULE 10 - Review and comment

  • Use the spell checker
  • Use dictionaries
  • Manage comments

MODULE 11 - Notes and accessory text

  • Insert footers
  • Insert a symbol
  • Insert a WordArt
  • Edit a WordArt

MODULE 12 - The work area

  • Set the workspace display
  • Set the guides
  • Adjust the zoom
  • Set windows

MODULE 13 - Managing a presentation - Transitions and animations

  • Start a presentation
  • Use the tools during projection
  • Choose a transition
  • Set the speed and timing of the transition
  • Associate an audio effect
  • Set up an animation

MODULE 14 - Custom animations and interactions

  • Add an effect
  • Customize an effect
  • Insert a hyperlink
  • Set up an action

MODULE 15 - The slide design

  • Design the slide master
  • Format a schema
  • Set up the page
  • Close the schema view

MODULE 16 - The printed scheme

  • Design the printed diagram
  • Set up the page
  • Define the placeholders
  • Set the wallpaper
  • Close the schema view

 

COURSE 5 MICROSOFT OFFICE 2013 -  Outlook

Contents:

1 MODULE

  • First steps with Microsoft Outlook 2013

 2 MODULE

  • Managing the items in the address book

 3 MODULE

  • The management of agenda items

4 MODULE

  • Notes and Activities

 

TECHNICAL REQUIREMENTS:

Acrobat Reader

PDF documents are exported for version 5 but are compatible with later versions of Acrobat Reader released up to the date of update of this file.

Browser

  • Internet Explorer 10
  • Internet Explorer 11
  • Mozilla Firefox
  • Google Chrome

JavaScript enabled

Pop-up blocker disabled

Minimum video resolution

The courses are optimized for a 1024 × 768 display on PCs and tablets of at least 7 inches.

Speakers or headphones (in case of multimedia products)

DATA TRACKING METHOD: SCORM 1.2

Certification / Certificate

Certificate of use

DEVELOPMENT TECHNOLOGY:

HTML5

PRODUCED BY:

PIAZZA COPERNICO

Content edited by: PIAZZA COPERNICO

COURSE CODE:

 0065-15