INF3095 Productivity Software Integration

Advanced · 1 credit · BIT - Business, Admin, Finance and IT

Description: Students enhance production skills by integrating data from a variety of sources into a finished product.
Prerequisite: INF3060: Word Processing 3 INF2070: Database 2 INF2080: Spreadsheet 2 INF1070: Digital Presentation
Parameters: Access to appropriate computer equipment, software and support materials.

Outcomes The student will:

1 demonstrate competencies in word processing, spreadsheet, database and presentation software by creating integrated products
- 1.1 integrate data from a spreadsheet into a text document
- 1.2 integrate text from a document into a spreadsheet
- 1.3 create a linked object in a spreadsheet
- 1.4 import data and formatting from a variety of source files into a spreadsheet
- 1.5 import spreadsheet data into a database
- 1.6 link a spreadsheet to a database table
- 1.7 export database data to a spreadsheet
- 1.8 export database data to a text document
- 1.9 import data from a text document into a database
- 1.10 import an outline from a text document into a presentation
- 1.11 insert formatted text into a presentation
- 1.12 import linked objects into a presentation
2 demonstrate competence in producing integrated documents, spreadsheets, databases and presentations
- 2.1 describe the purpose of the product including:
  - 2.1.1 target audience
  - 2.1.2 single/multiple/presentation copy
- 2.2 apply word processing, spreadsheet, database and presentation commands, as appropriate, to import, export and link word processing, spreadsheet, database and presentation files
- 2.3 manipulate word processing, spreadsheet, database and presentation files from drafts including:
  - 2.3.1 edited, unedited and unformatted
  - 2.3.2 edited and formatted
- 2.4 follow instructions to customize/personalize existing text and data files including:
  - 2.4.1 load, redesign, reformat or modify existing templates and files containing information from spreadsheet, presentation, Web or graphics files
  - 2.4.2 revise documents to be aesthetically pleasing and well-formatted
  - 2.4.3 save file for print or display in audience-appropriate format
3 apply consistent and appropriate work station routines
- 3.1 demonstrate good health and safety; e.g., posture, positioning of hardware and furniture
- 3.2 employ practices that provide security for hardware, software, supplies and personal work
4 demonstrate basic competencies
- 4.1 demonstrate fundamental skills to:
  - 4.1.1 communicate
  - 4.1.2 manage information
  - 4.1.3 use numbers
  - 4.1.4 think and solve problems
- 4.2 demonstrate personal management skills to:
  - 4.2.1 demonstrate positive attitudes and behaviours
  - 4.2.2 be responsible
  - 4.2.3 be adaptable
  - 4.2.4 learn continuously
  - 4.2.5 work safely
- 4.3 demonstrate teamwork skills to:
  - 4.3.1 work with others
  - 4.3.2 participate in projects and tasks
5 create a transitional strategy to accommodate personal changes and build personal values
- 5.1 identify short-term and long-term goals
- 5.2 identify steps to achieve goals