Common Planner
K–12 Standards

Business Software Applications II

Other Alabama CTE sets

Foundational Standards 

  • 1

    Incorporate safety procedures in handling, operating, and maintaining tools and machinery; handling materials; utilizing personal protective equipment; maintaining a safe work area; and handling hazardous materials and forces. F.1

  • 2

    Demonstrate effective workplace and employability skills, including communication, awareness of diversity, positive work ethic, problem-solving, time management, and teamwork. F.2

  • 3

    Explore the range of careers available in the field and investigate their educational requirements, and demonstrate job-seeking skills including resume-writing and interviewing. F.3

  • 4

    Advocate and practice safe, legal, responsible, and ethical use of information and technology tools specific to the industry pathway.  F.4

  • 5

    Participate in a Career and Technical Student Organization (CTSO) to increase knowledge and skills and to enhance leadership and teamwork. F.5

  • 6

    Discuss and demonstrate ways to value diversity. F.6

Word Processing 

  • 1

    Manage advanced word processing document options and settings.  1

    1. a

       Manage templates, macros, and multiple documents using word processing software.  1.a

    2. b

      Prepare documents for collaboration using editing functions and protecting documents using passwords. 1.b

    3. c

      Use language-specific features, configure editing, and display languages to set language options. 1.c

  • 2

    Utilize advanced word processing editing and formatting features.  2

    1. a

      Perform advanced editing and formatting with word processing software. Examples: wildcards to replace special characters, formatting, styles, paste options2.a

    2. b

      Configure paragraph layout options. Examples: hyphenation, line numbers, pagination options2.b

    3. c

      Create and modify paragraph and character styles using word processing software. 2.c

  • 3

    Create custom document elements using advanced word processing software.  3

    1. a

      Mark, create, and update index entries software, including tables of contents, captions, and tables of figures. 3.a

    2. b

      Create and manage document building blocks.  3.b

    3. c

      Create custom design elements. Examples: color sets, font sets, themes, style sets3.c

    4. d

      Create and manage tables of figures using captions and configuring caption properties.  3.d

  • 4

    Create and modify advanced word processing features.  4

    1. a

      Manage forms by adding custom fields, modifying field properties, and inserting and configuring standard content controls. 4.a

    2. b

      Create and modify macros. Examples: Record, name, and edit simple macros. Copy macros to other documents or templates.  4.b

    3. c

      Create mail merged documents, labels, and envelopes using recipient lists and merged fields. 4.c

Spreadsheets

  • 5

    Manage workbook options and settings. 5

    1. a

      Manage workbooks using advanced features including save as template, copy macros, and reference data from other spreadsheets. 5.a

    2. b

      Manage workbook review in word processing software, including restrict editing, protect, encrypt with password, configure formula calculation options, manage workbook versions, and protect workbook structure features. 5.b

  • 6

    Apply custom data formats, layouts, and validation to workbooks. 6

    1. a

      Apply advanced conditional formatting and filtering to workbooks using spreadsheet software. 6.a

    2. b

       Create and modify custom workbook elements using spreadsheet software.  6.b

    3. c

      Prepare a workbook for internationalization, modifying currency, text, and other elements as needed, using spreadsheet software. 6.c

  • 7

     Create advanced workbook formulas using spreadsheet software.  7

    1. a

      Apply functions in formulas by performing logical operations including AND, OR, NOT, and nested functions and statistical operations including SUMIFS, AVERAGEIFS, and COUNTIFS functions in spreadsheet software.7.a

    2. b

      Look up data by using functions VLOOKUP, HLOOKUP, MATCH, and INDEX with spreadsheet software. 7.b

    3. c

      Apply advanced date and time functions including NOW and TODAY functions and serializing numbers using spreadsheet software.  7.c

    4. d

      Use financial functions of spreadsheet software to perform data analysis and business intelligence including import, transform, combine, display, connect, and consolidate data; perform what-if analysis; use cube functions; and calculate data.  7.d

    5. e

      Troubleshoot formulas by utilizing trace precedence and dependence, monitor cells and formulas, validate formulas by using error checking, and evaluate formulas. 7.e

    6. f

      Define and manage named ranges and objects by name cells, data ranges, and tables. 7.f

  • 8

    Create advanced charts and tables with workbook data in spreadsheet software.  8

    1. a

      Add trendlines to charts and create dual-axis charts.  8.a

    2. b

      Create and modify pivot tables by changing field selections and options, creating slicers, grouping data, adding calculated fields, and formatting data.8.b

    3. c

      Create and modify pivot charts by manipulating options in existing charts, applying styles, and drilling down into details, using spreadsheet software. 8.c

Database Management 

  • 9

    Build tables using database software. 9

    1. a

      Import data into tables and from other databases, create linked tables from external sources, and create a table from a template with application parts.  9.a

    2. b

      Customize tables by hiding fields, adding total rows and descriptions, and renaming tables.  9.b

    3. c

      Manage records in tables by updating, adding, deleting, sorting, and filtering records, appending records from external data, and finding and replacing data.9.c

    4. d

       Create and modify fields using add and delete fields; add validation rules; change field captions, sizes, and data types; configure fields to auto-increment; set default values; and use input masks.  9.d

  • 10

    Create and manage database forms.  10

    1. a

      Create and save forms and create a form from a template with application parts. 10.a

    2. b

      Configure form controls by moving, adding, and removing form controls; modifying data sources; setting form control properties; managing labels; and adding subforms.  10.b

    3. c

      Format forms using modify tab order; configure print settings; sort records by form field; apply a theme; control form positioning; and insert backgrounds, headers, footers, and images.  10.c

  • 11

    Create database reports .  11

    1. a

      Create reports based on query or table, in design view, and using a wizard. 11.a

    2. b

      Configure report controls by group and sort fields, modify data sources, add report controls, and add and modify labels.  11.b

    3. c

      Format reports using multiple columns, add calculated fields, control report positioning, format report elements, change report orientation, insert header and footer information, insert images, and apply a theme. 11.c

Productivity

  • 12

    Utilize digital technology applications on the Internet for business, personal, and educational uses.  12

    1. a

      Present a digital portfolio encompassing all programs used during the course. Examples: website, b12.a

    2. b

      Collaborate using cloud computing by designing, saving, uploading, and sharing documents, presentations, and calendars in an online account. Example: cloud-based filing repositories12.b

    3. c

      Utilize social networking as a business tool to create professional portfolios and blogs. 12.c

  • 13

    Devise and apply methods of modifying documents to be more accessible to people with disabilities. Examples: use headings, lists, meaningful hyperlinks, alternate text for images, tables; identify document language 13

Frequently asked questions

What grade levels do these standards cover?
Grade 10, Grade 11, Grade 12, and Grade 9

Keep exploring

Keep exploring CTE standards

Sibling grade bands, other subjects in this jurisdiction, and the same subject across other states.

More Alabama CTE sets

CTE