INF2080 Spreadsheet 2

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

Description: Students develop skills in the proper use of spreadsheet software through advanced data manipulation and preparation of appropriate reports and printouts in text and graphic format.
Prerequisite: None
Parameters: Access to an appropriate computer work station and spreadsheet software.
Supporting courses: INF1060: Spreadsheet 1

Outcomes The student will:

1 create and manipulate data
- 1.1 insert data using fill including:
  - 1.1.1 change font colour
- 1.2 change worksheet views including:
  - 1.2.1 split, freeze and unfreeze workbooks
  - 1.2.2 hide, unhide and arrange workbooks
  - 1.2.3 insert and modify page breaks
- 1.3 manage worksheets by:
  - 1.3.1 inserting, deleting and rearranging worksheets
  - 1.3.2 creating a workbook from a template
2 format data and content
- 2.1 insert and modify rows and columns including:
  - 2.1.1 use text to create columns
  - 2.1.2 change row and column width and height
  - 2.1.3 hide and unhide columns and rows
  - 2.1.4 apply changes to horizontal and vertical alignment
  - 2.1.5 centre titles across a series of cells
  - 2.1.6 use a function to display current date and time
- 2.2 format data and table including:
  - 2.2.1 apply styles to cells
3 create and modify formulas
- 3.1 use functions to create average, minimum and maximum; e.g., AVERAGE, MIN, MAX
- 3.2 use functions to count numbers, and count both text and numbers; e.g., COUNT, COUNTA
- 3.3 use functions to calculate interest rates, monthly payments and present value; e.g., PMT
- 3.4 use conditional logic in a formula; e.g., IF
- 3.5 summarize data using subtotals
- 3.6 format and modify text using formulas
- 3.7 look up data using a formula
- 3.8 protect formulas using lock and unlock
4 present data visually
- 4.1 create and format charts including:
  - 4.1.1 insert various chart types; e.g., 2-D column, pie, scatter
  - 4.1.2 use chart tools to create a clustered column graph
- 4.2 modify and position chart elements in a clustered graph
- 4.3 insert and modify illustrations by:
  - 4.3.1 inserting, moving and sizing graphics from an outside source; e.g., the Internet
- 4.4 sort and filter data including:
  - 4.4.1 two component simple sort
  - 4.4.2 two component filter sort
  - 4.4.3 outline data
5 collaborate and secure data
- 5.1 manage all changes to workbooks including:
  - 5.1.1 save and publish workbooks and worksheets as Web pages
  - 5.1.2 convert files to different formats
- 5.2 protect and share workbooks
- 5.3 prepare workbooks for distribution
6 apply consistent and appropriate work station routines
- 6.1 demonstrate good health and safety; e.g., posture, positioning of hardware and furniture
- 6.2 employ practices that provide security for hardware, software, supplies and personal work
7 demonstrate basic competencies
- 7.1 demonstrate fundamental skills to:
  - 7.1.1 communicate
  - 7.1.2 manage information
  - 7.1.3 use numbers
  - 7.1.4 think and solve problems
- 7.2 demonstrate personal management skills to:
  - 7.2.1 demonstrate positive attitudes and behaviours
  - 7.2.2 be responsible
  - 7.2.3 be adaptable
  - 7.2.4 learn continuously
  - 7.2.5 work safely
- 7.3 demonstrate teamwork skills to:
  - 7.3.1 work with others
  - 7.3.2 participate in projects and tasks
8 make personal connections to the cluster content and processes to inform possible pathway choices
- 8.1 complete/update a personal inventory; e.g., interests, values, beliefs, resources, prior learning and experiences
- 8.2 create a connection between a personal inventory and occupational choices