|
|
|
Mar 20, 2025
|
|
2025-2026 Academic Catalog
|
BAS 220 - Spreadsheet Applications 3 CR
Through a step-by-step, project-based approach, students will acquire the skills necessary to use spreadsheet applications to plan, design, and deliver effective professional workbooks for various audiences and business functions. Students will develop competency creating simple spreadsheets with data, calculations, and formatting. Students will progress to more advanced workbook designs using advanced functions to transform and analyze data, perform what-if analysis, charting, data validation, and workbook automation to address business scenarios. Students will apply industry best practices for accessibility, usability, and developing content for target audiences to create a custom workbook.
Lab Fee
Course Learning Outcomes:
- Enter and format text, numbers, formulas, and functions to structure and organize data within a spreadsheet.
- Create and edit tables and charts to visually present numerical data.
- Import, format, and transform data from external sources.
- Create and modify PivotTables and PivotCharts to transform and visually present large quantities of data.
- Create and modify macros to automate complex and repetitive tasks.
- Prepare workbooks for collaboration and editing.
|
|
|
