Skip Navigation

Utah Core  •  Curriculum Search  •  All CTE/Business and Marketing Education Lesson Plans  •  USBE CTE/Business and Marketing Education website

 

CTE/Business and Marketing Education Curriculum Computer Technology II
Printable Version Printable Version (pdf)

 

arrow icon Course Introduction

 

Core Standards of the Course

Strand 1
Students will apply features in a variety of applications.

Standard 1
Identify and change default settings.

Standard 2
Identify and customize screen components (toolbars, ruler, status bar, document window, task pane, etc.) in each application.

Standard 3
Graphic Objects (examples: clipart, pictures, WordArt, drawing tools, text boxes).

  1. Change size
  2. Text wrapping
  3. Borders and shading
  4. Rotate

Standard 4
Headers and footers, spell check, zoom and view, format painter.

Performance Objective
Use the following features in at least two software applications.

  1. Graphic objects
  2. Headers and footers

Strand 2
Students will build on word processing skills to create and edit documents using advanced features.

Standard 1
Review word processing skills learned in Computer Technology. (see Standards and Objectives for Computer Technology Standard 0000-03)

Standard 2
Tables

  1. Create
  2. Insert and delete rows/columns
  3. Merge and split cells
  4. Enhance appearance with borders and shading/color
  5. Sort data

Standard 3
References.

  1. Hanging indent
  2. Footnotes/Endnotes
  3. Bibliography/work cited
  4. In-text citations

Standard 4
Formatting and Page Layout

  1. Section and page breaks
  2. Headers and footers
  3. Page numbering
  4. Columns
  5. Tabs
  6. Apply and modify styles

Standard 5
Mail Merge

  1. Create a data source
  2. Create a main document and insert merge fields
  3. Merge a main document and data source

Performance Objectives:
Use word processing software to create:

  1. Reports that include
    • page numbers, header or footer, section/page break(s),
    • in-text citations, footnotes/endnotes, and works cited/bibliography.
  2. Table with merged/split cells, borders and shading, and sorted data (this table may be included in reports, letters, etc.).
  3. Mail merged letter with envelopes or labels

Strand 3
Students will build on spreadsheet skills to create and edit worksheets.

Button to show lessons. Button to show links.

Standard 1
Review spreadsheet skills learned in Computer Technology (see Strands and Standards for Computer Technology Standard 0000-04)

Standard 2
Formatting and Layout

  1. Cell alignment (horizontal, vertical, rotate, wrap text, merge cells)
  2. Number formatting
  3. Conditional formatting
  4. Insert, move, delete, and copy portions of a worksheet
  5. Apply and modify styles
  6. Change page orientation
  7. Freeze panes and split window
  8. Manipulate worksheet tabs (insert, rename, delete, move, color, etc.)
  9. Fill data in a row or column (formulas, series, etc.)

Standard 3
Formulas and Functions

  1. Create formulas
  2. Relative and absolute cell references
  3. Functions: MAX, MIN, COUNT, IF, VLOOKUP, HLOOKUP

Standard 4
Charts

  1. Create charts to appropriately represent data (pie, bar, column, line, etc.)
  2. Place chart as an object in current worksheet or in a new sheet
  3. Format chart elements (legends, titles, borders, fill, etc.)

Standard 5
Database Features

  1. Sort in ascending/descending order and by multiple fields
  2. Define and apply filters
  3. Subtotals
  4. Lists

Standard 6
Printing

  1. Fit worksheet to specified number of pages (scaling)
  2. Formulas
  3. Gridlines and row/column headings
  4. Selection of cells
  5. Multiple sheets
  6. Repeat rows and/or columns

Performance Objectives:
Use spreadsheet software to create:

  1. Workbooks (with two or more worksheets) that include:
    • references to other worksheet cells in the workbook
    • formulas with absolute and relative cell references
    • functions including IF, PMT, VLOOKUP, and HLOOKUP
    • print options including formulas, gridlines, row/column headings, scaling
  2. Charts
    • pie, bar, column, line, etc.
    • formatted
  3. Worksheet with database features o Sort on multiple fields
    • Filter
    • Subtotals

Strand 4
Students will build on electronic presentation skills to create and edit slide shows.

Standard 1
Review presentation skills learned in Computer Technology 1 (see Standards and Objectives for Computer Technology Standard 0000-08)

Standard 2
Create and Modify

  1. Apply appropriate design principles (professional business presentation)
  2. Customize slide master
  3. Apply custom animation and transitions
  4. Insert objects (clipart, picture, table, chart, diagram, sound, and video)
  5. Insert hyperlinks and action buttons
  6. Add speaker notes to slides

Standard 3
Presenting a Slide Show

  1. Print handouts, speaker notes, and outlines
  2. Oral presentation skills

Performance Objectives:
Use presentation software to create:

  1. Slide shows, demonstrating professional quality design following generally accepted presentation guidelines that include:
    • Transitions with automatic timing
    • Custom animations
    • Objects (charts, diagrams, tables, sound, movie)
    • Links and action buttons
  2. Speaker notes

Strand 5
Students will acquire database skills to manage data.

Standard 1
Create and Manage Tables

  1. Define databases and database management systems
  2. Define database terminology (field, record, table, primary key, etc.)
  3. Create database
  4. Create and enter data in a table
  5. Restructure (add and delete fields, change field names and properties, etc.)
  6. Preview and print

Standard 2
Queries

  1. Create in design view and using wizard
  2. Edit (add, delete, move, and hide fields)
  3. Use criteria (text, wildcard, numeric, compound, and comparison operators)
  4. Sort
  5. Change field properties
  6. Preview and print

Standard 3
Reports

  1. Create using wizard
  2. Preview and print

Performance Objective:
Complete a project that combines the use of word processing, spreadsheet, and electronic presentation software.


Strand 6
Students will integrate word processing, spreadsheet, and electronic presentation software.



UEN logo http://www.uen.org - in partnership with Utah State Board of Education (USBE) and Utah System of Higher Education (USHE).  Send questions or comments to USBE Specialist - Laura deShazo and see the CTE/Business and Marketing Education website. For general questions about Utah's Core Standards contact the Director - THALEA LONGHURST .  
Email:  thalea.longhurst@schools.utah.gov

These materials have been produced by and for the teachers of the State of Utah. Copies of these materials may be freely reproduced for teacher and classroom use. When distributing these materials, credit should be given to Utah State Board of Education. These materials may not be published, in whole or part, or in any other format, without the written permission of the Utah State Board of Education, 250 East 500 South, PO Box 144200, Salt Lake City, Utah 84114-4200.