Skip Navigation

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

 

CTE/Business Curriculum Business Office Specialist
Printable Version Printable Version (pdf)

 

arrow icon Course Introduction

 

Core Standards of the Course

STRAND 1
Students will be able to identify common features and organize files across a variety of software programs.

Standard 1
Demonstrate these common functions in software applications.

  1. Cut
  2. Copy
  3. Paste
  4. Undo
  5. Redo
  6. Save
  7. Modify print settings
  8. Export as PDF
  9. Find
  10. Find + Replace
  11. Spell check
  12. Zoom
  13. Format and edit text options
    • Font Style
    • Font Color
    • Font Size
    • Bold
    • Italicized
    • Underline
  14. Apply various font styles and font sizes to the text within a document
  15. Headers: located in the margin area at the top of a page. This information is repeated on each page and thus enables the reader to easily navigate the document.
  16. Footers: located in the margin area at the bottom of a page. This information is repeated on each page and thus enables the reader to easily navigate the document.
  17. Apply advanced text options using superscript, subscript, and capitalization (lowercase, uppercase, title case)
  18. Insert hyperlinks
  19. Insert symbols and special characters
  20. Identify the difference between Save and Save As.
    • Save is a command that creates an original file and location or updates changes made in a document while keeping the original file name and location.
    • Save As is a command that creates a copy of a current document and allows the user to rename and/or relocate the document.

Standard 2
Demonstrate best practices for file management.

  1. Perform basic file management system tasks.
    • Define file management system as software that manages the storage of data files.
  2. Create and delete files.
    • Define file as storage of computer-recorded data.
  3. Create and delete folders.
    • Define folders as an icon on a computer used to access a directory of file storage.
  4. Create subfolders.
    • Define subfolders as a folder contained within another folder.
  5. Duplicate files.
  6. Identify where deleted content is contained (i.e. recycle bin, trash can, permanently deleted).
  7. Demonstrate the ability to sort and locate files based on search terms and file type.
  8. Rename files and save in a new location.

Standard 3
Identify and navigate through common software application 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
  7. Identify the purpose for different graphic objects (WordArt, image/picture, shapes, and text boxes)
  8. Apply and edit different graphic object formats (size and position, text wrapping, borders and shading, shape fill/outline, rotate/flip)

STRAND 2
Students will explore word processing software and the many practical and creative applications for both personal and career development.

Standard 1
Apply and format basic editing and formatting tools within a document

  1. Built-in styles: combinations of formatting characteristics that you can apply to text to quickly change its appearance. For example, applying the Heading 1 style might make the text bold, Arial, and 16 point, and applying the Heading 2 style makes text bold, italic, Arial, and 14 point.
  2. Paragraph options: Paragraph formatting commands are in the Home -> Paragraph group. Left to right, from the top, you find buttons to add bullets and numbers, apply indents, and short paragraphs, show the paragraph mark, align paragraphs, adjust line spacing, change the background color, and add borders.
  3. Background: color/page color
  4. Watermark: a faint design made in some paper during manufacture that is visible when held against the light and typically identifies the maker
  5. Paragraph Spacing: determines the amount of space above or below a paragraph
  6. Vertical Text alignment: determines the position of the text within a section of a document relative to the top and bottom margins
  7. Horizontal Text alignment: positions the text evenly between the margins on either side of the page.
  8. Paragraph Indent options: (left, right, hanging, and first line)
  9. Text bullets and numbering: (customize and list levels)
  10. Format images: size & rotation, text wrapping, color adjustments, borders

Standard 2
Identify, and define functions used to review, navigate and edit a document.

  1. Thesaurus: to explore alternative words. Lists words in groups of synonyms and related concepts.
  2. Format painter: lets you copy all of the formatting from one object and apply it to another one
  3. Bookmark: used to help navigate through a document. A bookmark is a feature that lets you tag words, pictures, charts, or other objects to quickly find and view them again later.

Standard 3
Modify a table within a document through the use of insert, delete, and select the entire table. Define the parts of a table.

  1. Rows: horizontal alignment of data
  2. Columns: vertical alignment of data
  3. Cells: part of a table where a row and column intersect and leave a field to enter text into
    • Size, merge, and split cells within a table
  4. Enhance the appearance of a table using borders, shading/color, and styles
  5. Align text within a table and a cell (top, bottom, right, left, center) Use icons for test
  6. Sort data within a table
    • Alphabetically: the order of the letters of the alphabet
    • Numerically: sorted by numbers

Standard 4
Insert references appropriately to a document. References provide the information for readers to identify and retrieve each work cited in the text. Cover the following references and when it is important to use each one. Commonly used in formal reports, thesis papers, project reports, and business plans.

  1. Cover page: represents the main highlighted part of your document that contains the document title, pictures, company logo, or information about the document file.
  2. Table of contents: listing all the headings in the document in outline order, as well as the page number that each heading appears on.
  3. Citations: the way you tell your readers that certain material in your work came from another source and gives your readers the information necessary to find that source again. Citations may include Information about the Author(s) or Editor(s). The Title of the Work. The Publisher. The Date published.
  4. Footnote: appears on the bottom of the page that contains the sentence to which it refers.
  5. Endnotes: are listed at the end of the paper on separate pages
  6. Bibliography: list of sources referred to in a document
  7. Caption Properties: the text identifies or describes the object with which it is associated an image, textbox, and figure
  8. Comments: useful when needing to make note of something that requires attention or needs fixed, or provide additional information to others reading the document.

Standard 5
Format and customize page layout options within a document.

  1. Templates: predefined page layout, fonts, margins, and styles to enhance productivity
  2. Margins: the blank spaces that line the top, bottom, and left and right sides of a document.
  3. Section breaks: used to divide the document into sections, change the layout or formatting in one section of your document
  4. Page breaks: mark the point at which one-page ends and the next page begins
  5. Page orientation: portrait (vertical) or landscape (horizontal) layout
  6. Page numbers within a document
  7. Columns within a document (multiple columns, spacing between columns, lines between columns)

Performance Skills
Use word processing software to create a project. Encourage students to create a project with personal interest to promote the use and exploration of word processing programs for individual use.

  1. Create a Report, Newsletter, Brochure, Blog post, Magazine Article, or Infographic

STRAND 3
Students will explore spreadsheets and the careers that use them. Spreadsheets can be used to solve problems that require organization, calculation, scheduling, and other work-related needs.

Standard 1
Identify, define and modify cells, worksheets, and workbooks in a spreadsheet program. Include customizing, formatting, and layout options; creating, opening, importing and exporting, copying, and moving worksheets in a workbook.

  1. Workbooks: a single spreadsheet
  2. Worksheets: a group of worksheets, identified by tabs at the bottom of a worksheet.
  3. Cell References: A definition in a cell that refers to the contents of another cell
  4. Formula bar: a field at the top of a spreadsheet that shows the contents of the current cell and allows you to create and view formulas.
  5. Name box: lets you select cells or ranges by entering a reference or range name.
  6. Sheet Tabs: Reference labels on a workbook that identifies the data inside the worksheet.
  7. File formats for spreadsheets
    • .xls, csv
  8. Edit and customize text formatting
    • Merge & center
    • Wrap text: a command that formats the text in a cell to wrap a line underneath each other.
    • Align text
  9. Edit and customize Number formatting: to change the appearance of a number within a cell to reflect the type of information being displayed.
    • General
    • Currency
    • Accounting
    • Date & time
    • Decimal
  10. Apply and modify styles to cell
    • Wrap text
    • Cell styles
    • Cell alignment
  11. Apply and manage view options
    • Freeze panes: keeps specific rows or columns visible when you scroll in the worksheet.
    • Split window: you can view two areas of a sheet by splitting it into separate panes where you can scroll in both panes independently.
    • Zoom: changes the scale of a worksheet. When you want to see more or less of a worksheet, use Zoom to increase or decrease the magnification.
    • Continue a series or pattern into neighboring cells using the fill handle: a feature used to extend and fill several numbers, dates, or text to other cells.
  12. Edit and customize cell size (row height, column width,)
  13. AutoFit: automatically adapts to appropriate height and width based on font size.

Standard 2
Manage Data to create, format, and modify tables, charts, and graphs

  1. Insert, move, delete, and copy a worksheet range: a collection of cells
  2. Utilize named range: naming a range of cells.
  3. Manipulate data in worksheets
    • Auto Fill: when entering a predictable series, it will automatically enter data.
    • paste options
  4. Sort and filter data within a worksheet
    • Ascending: from A-Z or from the smallest number to largest.
    • Descending: from Z-A or from largest number to smallest.
    • Multiple fields
  5. Create charts
    • Line chart: displays data points connected by straight lines and shows information (trends) that changes over time.
    • Pie chart: displays data in a circular graph showing the percentage of the whole.
    • Column chart: displays rectangular bars to show a comparison between categories.
  6. Modify and format charts
    • Add data series: a row or column of numbers that are entered in a worksheet and then used to plot a chart.
    • Add and modify chart elements: this makes your chart easier to read such as chart titles, legends, and data labels.
    • Apply chart layouts: contains the information for the structure and design of the various graphs.
    • Apply chart styles: adjusts the format of several chart elements all at once.
  7. Summarize data visually
    • Sparklines: tiny chart in a worksheet cell that provides a visual representation of data.
    • Conditional formatting: changes the appearance of a cell range based on a condition.

Standard 3
Differentiate and apply formulas and functions

  1. Formulas vs. Functions
    • Formula: an expression that operates on values in a range of cells or a cell. For example, =A1+A2+A3, which finds the sum of the range of values from cell A1 to cell A3.
    • Function predefined formulas in Excel. For example: =SUM(A1:A3). The function sums all the values from A1 to A3.
  2. Insert cell references
    • Relative reference: a cell reference is a relative reference, which means that the reference is relative to the location of the cell.
    • Absolute reference: a reference that is "locked" so that rows and columns won't change when copied.
    • Mixed references: only part of the reference is fixed, either the row or the column, and the other part is relative.
  3. Coding functions including
  4. Apply total rows style: a preset style for totals.
  5. View in show formula mode: displays formulas and functions in the worksheet.
  6. Error messages
    • Formatting Error ######
    • Name Error ( #NAME? )
    • Value Error ( #VALUE! )
    • Division Error ( #DIV? 0! )
    • Null Error ( #NULL! )
    • Reference Error ( #REF! )

Performance Skills
Use spreadsheet software to problem-solve and create a project. Encourage students to create a project with personal interest to promote the use and exploration of spreadsheet programs for individual use.

  1. Create a budget, invoice, chart, or order form.

STRAND 4
Students will explore and create a slideshow to learn essential communication for real-world and office applications.

Standard 1
Identify, define and modify a slideshow by learning the essentials needed for the office.

  1. Customize slideshow:
    • Modify placeholders: a preformatted container on a slide for content (text, graphics, or video). The preset formatting makes it easier to format slides consistently.
    • Modify layout
    • Size: change the size of the slide(s)
    • Theme: preset formatting of a slideshow in text size, colors, placement, and graphic features.
    • Font style
    • Format background
  2. Edit basic slide master/theme builder: this is the top slide in a hierarchy of slides that stores information about the theme.
  3. Arrange and title Sections: to organize your slides into meaningful groups
  4. Insert and edit objects
    • Picture
    • Table
    • Chart
    • Diagram/SmartArt: is a visual representation of your information and ideas
    • Sound
    • Video
  5. Slide management
    • Insert
    • Move
    • Delete
    • Reuse: obtain slide(s) from another slideshow

Standard 2
Demonstrate and use enhanced tools to make slideshows more engaging to the audience.

  1. Apply custom animation effects: Applied to text, images, or graphics that move when entering or leaving a slide for added emphasis.
    • Entrance
    • Emphasis
    • Exit
    • Motion path
  2. Apply a transition: the visual effect that occurs when you move from one slide to the next during a presentation to a slide(s) within a slideshow
  3. Edit animation timing: the time that it takes for an object to enter or exit the slide.
  4. Slide order: rearrange the slides
  5. Format images and shapes:
    • Size & rotation
    • Text wrapping - formatting words around an image
    • Color adjustments
    • Borders
  6. Insert
    • Screenshots + screen clippings
    • Hyperlinks: a link from a file or document, typically activated by clicking on a highlighted word or image on the screen
    • Action buttons: an object on a slide that performs an action when clicked
    • Speaker notes: notes visible in the presenter view but not the audience
  7. Add alt text to graphic elements for accessibility: tells a screen reader what is in the image
  8. Configure slideshow options
    • Set up timings: slide(s) move on a chosen amount of seconds to the next slide
    • Presentation view: allows a presenter to preview the slide before it is seen by the audience.
    • Loop: to play the slideshow again without stopping
    • Speaker notes: help you remember what to say when you present. Print them, or use Presenter view to see your notes, while the audience sees only your slides.

Performance Skills
Use slideshow software to communicate and create a project. Encourage students to create a project with personal interest to promote the use and exploration of slideshow software.

  1. Use slideshow software to create a slideshow(s), demonstrating professional quality design following generally accepted slideshow guidelines that include:
    • Transitions with automatic timing
  2. Use slideshow software to create a slideshow(s), demonstrating professional quality design following generally accepted slideshow guidelines that include:
    • Custom animations
  3. Use slideshow software to create a slideshow(s), demonstrating professional quality design following generally accepted slideshow guidelines that include:
    • Objects (charts, diagrams, tables, sound, video)
  4. Use slideshow software to create a slideshow(s), demonstrating professional quality design following generally accepted slideshow guidelines that include:
    • Hyperlinks and action buttons
  5. Use slideshow software to create a slideshow(s), demonstrating professional quality design following generally accepted slideshow guidelines that include:
    • Speaker notes, handouts, and outlines

STRAND 5
Students will identify the courses that will help them to be a pathway completer as well as potential careers as an office administrator, executive assistant, project manager, information clerk, and many more.

Standard 1
Business, Finance and Marketing Pathways

  1. Identify the "Explorer" courses offered at your school
  2. Identify the "Concentrator" courses taught at you school
  3. Identify the "Completer" course for the Business, Finance and Marketing Pathways

Standard 2
Explore the Certifications, Degrees and Tech college programs in your local region

  1. Certifications available through your school
  2. Utah BOS Skills certification
  3. Microsoft Office Specialist certification
  4. Adobe Creative Associate certification Degrees
  5. Degrees Available in your local region
  6. Associate degree in Business Administration, Business Information, Business Technology
  7. Most state colleges offer a bachelors in Business Management, Human Resource Management
  8. Master's in Business Administration
  9. Western Governors University
    • MBA
    • Business Management
  10. University of Utah: Certificate in Digital Literacy
  11. MTEC, Ogden/Weber Tech, Uintah Basin Tech
    • Digital Media
  12. BTech: Business Technology
  13. UVU Marketing and Digital Marketing
    • Professional Sales Certificate
  14. USU Huntsman Business School

Standard 3
Careers in Business Administration

  1. Explore current job postings in this field to introduce students to the fact that this is a high wage high demand field. There are many options that are available based on different strengths.


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 - Racheal  Routt and see the CTE/Business 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.