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 Business Office Specialist
Printable Version Printable Version (pdf)

 

arrow icon Course Introduction

 

Core Standards of the Course

Strand 1
Students will build on basic word processing skills to create and manage documents.

Standard 1
Review basic editing and formatting tools within a document

  1. Format and edit text options
    • Apply various font styles and font sizes to text within a document
    • Apply advanced text options using superscript, subscript, capitalization (lowercase, uppercase, title case)
    • Apply and modify styles, insert hyperlinks (to a web page, email, within a document), and clear formatting to text within a document
    • Format styles for use in text, tables, and lists (Normal, Heading, Title)
  2. Format and edit paragraph options
    • Apply before and after paragraph spacing
    • Identify text alignment (vertical and horizontal)
    • Apply various indent options to a paragraph (left, right, hanging, and first line)
    • Edit and customize text bullets and numbering (customize and list levels)

Standard 2
Identify and navigate through common software application (word processing, spreadsheet, presentation, and database) screen components

  1. Locate the various toolbars, menus, and document window
  2. Utilize the ruler to edit a document
  3. Explain the purpose of the status bar
  4. Identify and explore the different options within the navigation pane
  5. Apply and edit the different zoom options
  6. Utilize the scroll bars to navigate through a document

Standard 3
Customize graphic objects within a document

  1. Identify the purpose for different graphic objects (WordArt, image/picture, shapes, and text boxes)
  2. Apply and edit different graphic object formats (size and position, text wrapping, borders and shading, shape fill/outline, rotate/flip)

Standard 4
Review, navigate and edit a document

  1. Navigate through a document using Find and Replace
  2. Edit a document using spell check
  3. Use the thesaurus to explore alternative words
  4. Apply current formatting throughout a document using the format painter
  5. Explore and utilize different design themes within a document
  6. Create bookmarks to help navigate through a document

Standard 5
Create and modify a table within a document

  1. Insert a table and modify rows/columns (add, delete, select entire table)
  2. Format cells within a table (add, delete, size, merge, split)
  3. Enhance the appearance of a table using borders, shading/color, and styles
  4. Align text within a table and a cell (top, bottom, right, left, center)
  5. Sort data within a table alphabetically, chronologically, and numerically

Standard 6
Create and manage simple references within a document

  1. Apply simple references appropriately to a document (cover page, table of contents, citations, footnote/endnote, bibliography)
  2. Apply and modify caption properties to an image, textbox and figure
  3. Review and insert comments throughout a document

Standard 7
Format and customize page layout options within a document

  1. Understand the purpose of templates to enhance productivity
  2. Create, modify and apply custom margins within a document
  3. Identify and insert various section and page breaks within a document
  4. Edit page orientation
  5. Insert and customize headers and footers and page numbers within a document
  6. Apply and customize columns within a document (multiple columns, spacing between columns, lines between columns)
  7. Customize and set tabs within a document
  8. Customize background color/page color

Standard 8
Code macros within a document

  1. Record and play a macro
  2. Assign a keyboard shortcut to run a macro

Standard 9
(Optional for Industry Certification) Apply advanced document setting, properties, formatting, and options

  1. Edit document properties (title, keywords/tags, subject)
  2. Edit display options (enable/disable print background color, always show paragraph marks)
  3. Edit save option (auto recovery options, embed fonts)
  4. Edit advanced options (print pages in reverse order)
  5. Inspect the document for hidden properties and personal information
  6. Apply a theme (color, font style, effects)
  7. Insert and customize a page border

Performance Skills
Use word processing software to create:

  1. Reports that include: Title/cover page, headings, table of contents, page numbers, header or footer, section / page break(s), in-text citations, and footnotes / endnotes
  2. Table with merged / split cells, borders and shading, and sorted data (this table may be included in reports, letters, etc.)
  3. Code and record a macro and assign it to a keyboard shortcut

Strand 2
Students will build on spreadsheet skills to create and manage worksheets.

Standard 1
Create and edit worksheets and workbooks

  1. Create new workbooks and add worksheets from existing workbooks
  2. Open / Import files into an existing worksheet
  3. Copy and move worksheets within a workbook

Standard 2
Identify and navigate through common software application screen components

  1. Identify and manage cell data using the formula bar
  2. Explain the purpose of the name box
  3. Manage and customize sheet tabs options (rename, tab color)

Standard 3
Customize formatting and layout options within a workbook / worksheet

  1. Insert and customize headers and footers
  2. Edit and customize text formatting (Merge & center, wrap text, align text)
  3. Edit and customize number formatting (general, currency, accounting, date & time, decimal, etc.)
  4. Define and explore options with conditional formatting
  5. Insert, move, delete, and copy ranges of a worksheet
  6. Apply and modify styles to cell or table
  7. Apply and manage view options (Freeze panes, split window, zoom)
  8. Continue a series or pattern into neighboring cells using the fill handle
  9. Edit and customize cell size (row height, column width, AutoFit)
  10. Sort and filter data within a worksheet (ascending, descending, multiple fields)

Standard 4
Create and code formulas and functions within a workbook / worksheet

  1. Create customized formulas
  2. Identify relative and absolute cell references
  3. Differentiate and apply basic functions (MAX, MIN, COUNT, AVERAGE, SUM)
  4. Differentiate and apply logical functions (SUMIF, AVERAGEIF, COUNTIF)
  5. Differentiate and apply text functions (PROPER, RIGHT, LEFT, MID, LOOKUP, CONCATENATE)
  6. Name and reference a range of cells
  7. Record and play a macro
    • Assign a keyboard shortcut to run a macro

Standard 5
Create and edit charts/graphs within a worksheet

  1. Differentiate between chart / graph types (pie, bar, column, line)
  2. Create a chart in a new sheet or within a worksheet
  3. Customize chart elements (styles, legends, titles, labels, axis, borders, fill)
  4. Embed a chart as an object in current worksheet
  5. Understand the purpose of the “switch row/column data” option when editing a chart / graph

Standard 6
Set and manage page layout and print settings within a workbook

  1. Understand and manage printing options (Fit worksheet to specified number of pages, scaling, print area, print multiple sheets, print selection of cells)
  2. Understand and manage page layout options (Turn on / off gridlines, print row / column headings, Repeat rows and / or columns headings)
  3. Prepare a worksheet for review through show / hide formulas tool
    • Keyboard shortcut ctrl + ` (grave accent key)

Standard 7
(Optional for Industry Certification) Apply advanced document setting, properties, and options

  1. Edit document properties (title, keywords / tags, subject)
  2. Manage save options (auto-recovery options)
  3. Apply banded rows and columns within a worksheet

Performance Skills
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
    • Coding functions including MAX, MIN, COUNT, COUNTIF
    • Print options including formulas, gridlines, row/column headings, scaling
    • Sort and filter data
  2. Charts
    • Pie, bar, column, line
    • Apply various formatting
  3. Code and record a macro and assign it to a keyboard shortcut

Strand 3
Students will build on electronic presentation skills to create and manage slideshows.

Standard 1
Create and modify a slideshow

  1. Apply appropriate design principles (professional business presentation)
  2. Edit basic slide master options (size, theme, font style)
  3. Arrange and customize content placeholders
  4. Apply custom animation effects (entrance, emphasis, exit, motion path)
  5. Edit animation timing and order (stat, duration, delay)
  6. Apply a transition to a slide(s) within a presentation
  7. Insert and edit objects (picture, table, chart, diagram, sound, and video)
  8. Insert hyperlinks and action buttons
  9. Add speaker notes to slides

Standard 2
(Optional for Industry Certification) Apply advanced document setting, properties, and options

  1. Customize slide master (header/footer,
  2. Insert custom slides (slide layout, slides from outline, reuse slides)
  3. Create custom slide show (hide slides, record timing)

Performance Skills
Use presentation software to create:

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

Strand 4
Students will acquire basic database skills in order to create and manage data.

Standard 1
Create and modify a database

  1. Define database and database management systems
  2. Define and identify database terminology (data Source, field, record, table, primary key, queries, reports)
  3. Create and edit fields within a database (create new records, add/delete fields, change field names and properties)
  4. Preview and print reports within a database

Standard 2
Navigate effectively within a database

  1. Understand and demonstrate how to navigate to specific records
  2. Set navigation options (filter)
  3. Alternate between view options (database view, design view)

Performance Skills
Use database software to create a table including fields and records. Complete a project that combines the use of at least two of the following: 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 - Breckon Heywood and see the CTE/Business and Marketing Education website. For general questions about Utah's Core Standards contact the Director - THALEA LONGHURST.

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.