Search ALEX...

Create and modify custom workbook elements using spreadsheet software.

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

Create advanced workbook formulas using spreadsheet software.

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.g SUMIFS, AVERAGEIFS, and COUNTIFS functions in spreadsheet software.

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

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.

Database Management

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.

Productivity

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.

Career Pathway Project in Business Management and Administration

Foundational Standards