Skip Navigation
Utah Core  •  Curriculum Search  •  All CTE/Business Education Lesson Plans  •  USOE CTE/Business Education Home Page

 

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

 

arrow icon Course Description

 

Core Standards of the Course

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

Button to show lessons.

Objective 1
Identify and change default settings.

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

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

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

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


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

Objective 1
Review word processing skills learned in Computer Technology (see Standards and Objectives for Computer Technology Standard 3)

Objective 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

Objective 3
References

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

Objective 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

Objective 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

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

Button to show lessons. Button to show links.

Objective 1
Review spreadsheet skills learned in Computer Technology (see Standards and Objectives for Computer Technology Standard 4)

Objective 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.)

Objective 3
Formulas and Functions

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

Objective 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.)

Objective 5
Database Features

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

Objective 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

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

Objective 1
Review presentation skills learned in Computer Technology (see Standards and Objectives for Computer Technology Standard 8)

Objective 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

Objective 3
Presenting a Slide Show

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

Standard 5
Students will acquire database skills to manage data.

Button to show links.

Objective 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

Objective 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

Objective 3
Reports

  1. Create using wizard
  2. Preview and print

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


 

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 Office 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 Office of Education, 250 East 500 South, PO Box 144200, Salt Lake City, Utah 84114-4200.

 

For more information about this core curriculum, contact the USOE Specialist, Laura deShazo or visit the CTE/Business Education Home Page. For general questions about Utah's Core Curriculum, contact the USOE Curriculum Director, MARY SHUMWAY . UEN Contact Info: 801-581-2999 | 800-866-5852 | Contact Us