This course spans 15 chapters, each focusing on a different aspect of technology's role in modern society and the business world:
- Technology in Everyday Life and Business: Introduces the evolution of computing, computer hardware, networks, the internet, cloud computing, IoT, and discusses safety, security, privacy, and ethical use of technology.
- Essentials of Software Applications for Business: Covers software basics, file and folder management, communication and calendar applications, essentials of Microsoft 365 and Google Workspace, and collaboration tools.
- Creating and Working in Documents: Focuses on navigating and formatting in Microsoft Word and Google Docs, collaborative editing, document design, and version history.
- Document Preparation: Advanced formatting features in Microsoft Word and Google Docs, working with graphics and text tools, and managing long documents.
- Advanced Document Preparation: Creating various document types, mail merge, form creation in Microsoft Word and Google Docs, and advanced collaboration features.
- Preparing Presentations: Presentation design essentials, designing and formatting presentations in Microsoft PowerPoint and Google Slides, adding visuals, and layout principles.
- Advanced Presentation Skills: Effective presentation skills, finalizing slide collections, and preparing collections for presentation in PowerPoint and Google Slides.
- Content Management Systems and Social Media in Business: Understanding content management systems, common platforms, content creation, search engine optimization, and the use of social media in business.
- Working with Spreadsheets: Basics of Microsoft Excel and Google Sheets, working with text and numbers, calculations, basic formulas, formatting, and templates.
- Advanced Excel Formulas, Functions, and Techniques: Data tables and ranges, complex formulas, arithmetic, statistical, and logical functions, PivotTables, formula auditing, and advanced formatting.
- Advanced Excel Spreadsheets: Statistical and Data Analysis: Data understanding, validation, statistical functions, what-if analysis, advanced PivotTables/Charts, and data analysis charts.
- Using Excel in Accounting and Financial Reporting: Basic accounting principles, financial functions in Excel, and integrating Excel with accounting programs.
- Understanding and Using Databases: Database fundamentals, features and navigation of Microsoft Access, querying, record maintenance, report creation, and form creation.
- Advanced Database Use: Advanced queries in Access, multiple table forms, customizing forms and reports, using macros, data analysis, and integration.
- Integrating Applications: Collaboration and integration in Microsoft 365, integration between Microsoft Office applications, integrating data from other programs into Google Workspace, and the role of artificial intelligence in workplace software.
Each chapter includes a scenario, key terms, summary, review questions, practice exercises, written questions, and case exercises, providing a comprehensive understanding of technology's impact and application in everyday life and business environments.