Software Proficiencies

Many positions in the library require varying levels of proficiency with a growing range of software applications, depending on which tasks need to be accomplished.  This category attempts to cover the breadth of technology use in libraries and allow for differing levels of proficiency.

Basic proficiencies of the most common software programs are described under Technology Core Competencies.

Last updated: April 5, 2016

Competency:  Demonstrates intermediate proficiency with e-mail programs

Associated Knowledge, Skills and Abilities:

  • Performs calendar operations to manage meetings and appointments
  • Configures rules, alerts and junk mail settings
  • Uses tasks, notes and journal features
  • Adjusts email interface to suit individual needs as required.

 

Competency:  Demonstrates advanced proficiency with e-mail programs

Associated Knowledge, Skills and Abilities:

  • Manages e-mail archiving and storage
  • Uses remote access, instant messaging, fax and voice-mail features
  • Uses advanced features to manage contacts
  • Uses advanced calendar features to manage meetings and group schedules
  • Performs advanced printing operations
  • Applies awareness of organizational retention policies to email management.

 

Competency:  Demonstrates intermediate proficiency with word processing programs

Associated Knowledge, Skills and Abilities:

  • Inserts header, footer and page numbers
  • Inserts and formats columns and tables
  • Creates and applies styles
  • Inserts and manipulates images, charts and graphs
  • Formats and prints envelopes and labels
  • Adjusts page layout and ribbons as needed
  • Inserts and edits hyperlinks.

 

Competency:  Demonstrates advanced proficiency with word processing programs

Associated Knowledge, Skills and Abilities:

  • Creates and uses templates/ master documents
  • Creates and formats footnotes, endnotes and a table of contents
  • Uses advanced features for formatting pages and tables
  • Creates and uses mail merges, macros, forms, frames and controls
  • Understands and uses document security and collaboration features

 

Competency:  Demonstrates intermediate proficiency with spreadsheet programs

Associated Knowledge, Skills and Abilities:

  • Applies a variety of formatting options (number, date, etc.)
  • Manages page settings, previews and print areas
  • Inserts hyperlinks, objects and images
  • Uses formulas and functions; finds maximum and minimum values
  • Creates basic charts to display worksheet data
  • Imports and exports data.

 

Competency:  Demonstrates advanced proficiency with spreadsheet programs

Associated Knowledge, Skills and Abilities:

  • Applies advanced formulas and functions
  • Performs advanced data analysis (pivot tables, pivot charts, goal seek, scenarios)
  • Applies advanced number and condition formatting
  • Applies advanced data management (sorts, filters and consolidates; applies mathematical, text and database functions)
  • Creates, edits and runs macros
  • Applies validation, protection and collaboration options.

 

Competency:  Demonstrates beginner-level proficiency with presentation programs (Microsoft PowerPoint, for example)

Associated Knowledge, Skills and Abilities:

  • Creates, opens, runs and saves a basic presentation slide set
  • Applies slide designs, layouts and basic formatting
  • Inserts images & graphics and modifies as needed
  • Understands and applies the printing options.

 

Competency:  Demonstrates intermediate to advanced proficiency with presentation programs

Associated Knowledge, Skills and Abilities:

  • Creates and applies custom themes or templates and manages slide masters
  • Understand slide transitions, custom animations and action buttons and uses discretion in their application, with special consideration for those with accessibility needs
  • Uses multiple sources for images and graphics, manipulating various formats
  • Inserts hyperlinks, sound clips and video clips; records narration
  • Optimizes presentations for a variety of output options, including the web or automated kiosk display
  • Identifies the most effective use of text and graphics to convey meaning and engage audiences.

 

Competency:  Demonstrates familiarity and beginner-level proficiency with document management programs (SharePoint, for example)

Associated Knowledge, Skills and Abilities:

  • Understands the file and workspace structure of the document management system
  • Adds new files, retrieves existing files, checks files in/out and edits files
  • Understands and uses collaboration and information-sharing features.

 

Competency:  Demonstrates familiarity and beginner-level proficiency with web-based office applications for online collaboration

Associated Knowledge, Skills and Abilities:

  • Understands the advantages of using web-based applications for collaboration
  • Identifies and selects appropriate online applications
  • Collaborates with other content-creators
  • Identifies and uses help menus, tutorials and support communities to acquire the necessary skills.

 

Competency:  Demonstrates beginner-level proficiency with database applications

Associated Knowledge, Skills and Abilities:

  • Designs a database to meet specified needs and identifies the data relationships
  • Creates a basic database and accesses different views of the data
  • Creates and modifies tables, relational tables and forms
  • Runs basic queries and reports on data.

 

Competency:  Demonstrates intermediate to advanced proficiency with database applications

Associated Knowledge, Skills and Abilities:

  • Applies advanced processes for retrieving and validating data
  • Applies advanced manipulations of tables and forms
  • Applies advanced methods for queries and reports on data.

 

Competency:  Demonstrates beginner-level proficiency with photo-editing programs

Associated Knowledge, Skills and Abilities:

  • Opens, saves and prints images
  • Resizes, crops, uses basic selection tools, and performs basic color and contrast adjustments
  • Reverses changes made to an image
  • Recognizes various file formats for images and their uses.

 

Competency:  Demonstrates intermediate to advanced proficiency with photo-editing programs

Associated Knowledge, Skills and Abilities:

  • Uses the array of tools in the toolbox and image adjustment options
  • Uses a variety of detailed selection options
  • Uses layers, creates montages and applies special effects
  • Optimizes images for a variety of output options.

 

Competency:  Demonstrates beginner-level proficiency with electronic publishing applications

Associated Knowledge, Skills and Abilities:

  • Creates or opens files, chooses layouts and saves files
  • Inserts and manipulates text blocks and tables
  • Inserts and manipulates graphical shapes, images and clip art
  • Understands and applies the printing options.

 

CompetencyDemonstrates intermediate to advanced proficiency with electronic publishing applications

Associated Knowledge, Skills and Abilities:

  • Works with page masters and advanced layout configurations
  • Applies advanced techniques to text blocks, tables, paths and graphics
  • Creates customized publications, including books with table of contents and index
  • Optimizes publications for a variety of output options, including the web and commercial printing.

Please review sols.org's Terms of Use. For questions, comments and suggestions regarding this website, please Contact SOLS Helpdesk.

The Southern Ontario Library Service  is working to make our website accessible to all. We welcome comments and suggestions on access improvements and encourage you to take a look at our updated Accessibility Policy. If you require a particular PDF or word document in an accessible format, please do not hesitate to contact us. We also offer BrowseAloud reading support - click on the orange graphic to the right to launch.  Learn more about BrowseAloud.

The support of the Government of Ontario through the Ministry of Tourism, Culture and Sport is gratefully acknowledged.