Standards - Career & Technical Education

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

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.

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

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

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

Add trendlines to charts and create dual-axis charts.

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

Create and modify pivot charts by manipulating options in existing charts, applying styles, and drilling down into details, using spreadsheetsoftware.

Build tables using database software.

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

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

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

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

Create and manage database forms.

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

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

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.

Create database reports .

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

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

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

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

Present a digital portfolio encompassing all programs used during the course.

Collaborate using cloud computing by designing, saving, uploading, and sharing documents, presentations, and calendars in an online account.

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

Devise and apply methods of modifying documents to be more accessible to people with disabilities.

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.

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

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

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

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

Discuss and demonstrate ways to value diversity.

Create a formal, narrative proposal that communicates a specific concept, creates a process, or develops a product proposal related to Business Management and Administration.

Conduct independent research related to the selected Business Management and Administration project.

Write a detailed report on the chosen Business Management and Administration pathway project, following established conventions for format, grammar, and usage.