WELCOME TO YOUR COURSE
INTRODUCTION TO TECHNOLOGY FOR SUCCESS: COMPUTER CONCEPTS
MODULE 1. IMPACT OF DIGITAL TECHNOLOGY
MODULE 2. THE WEB
MODULE 3. COMPUTER HARDWARE
MODULE 4. OPERATING SYSTEMS AND FILE MANAGEMENT
MODULE 5. SOFTWARE AND APPS
MODULE 6. SECURITY AND SAFETY
MODULE 7. DIGITAL MEDIA
MODULE 8. PROGRAM AND APP USE AND DEVELOPMENT
MODULE 9. WEB DEVELOPMENT
Module 10. Networking
Module 11. Digital Communication
Module 12. Digital Transformation: Cloud, E-commerce, and AI
Module 13. Databases
Module 14. Digital Ethics and Lifestyle
Career Readiness
Getting Started with the Resume Assistant
Pathbrite Portfolio Builder Activity
WORD MODULES
Module 1: Creating and Editing a Document: Writing a Business Letter and Formatting a Flyer
Formatting a Document: Editing an Academic Document According to MLA Style
Module 3: Creating Tables and a Multipage Report: Writing a Recommendation
Module 4: Enhancing Page Layout and Design: Creating a Newsletter
Module 5: Working with Templates, Themes, and Styles: Creating a Summary Report
Module 6: Using Mail Merge: Creating a Form Letter, Mailing Labels, and a Phone Directory
Module 7: Collaborating with Others and Integrating Data: Preparing an Information Sheet
Module 8: Customizing Word and Automating Your Work: Automating
Module 9: Creating Online Forms Using Advanced Table Techniques:
Module 10: Managing Long Documents: Creating a Survey Report
INDEX
EXCEL
MODULE 1: GETTING STARTED WITH EXCEL: TRACKING MISCELLANEOUS EXPENSES FOR A CONFERENCE
MODULE 2: FORMATTING WORKBOOK TEXT AND DATA: CREATING A SALES REPORT
MODULE 3: PERFORMING CALCULATIONS WITH FORMULAS AND FUNCTIONS: STAFFING A CALL CENTER
MODULE 4: ANALYZING AND CHARTING FINANCIAL DATA: PREPARING AN INVESTMENT REPORT
MODULE 5: GENERATING REPORTS FROM MULTIPLE WORKSHEETS AND WORKBOOKS: SUMMARIZING PROFIT AND LOSS STATEMENTS
MODULE 6: MANAGING DATA WITH DATA TOOLS: ANALYZING EMPLOYMENT DATA
MODULE 7: SUMMARIZING DATA WITH PIVOTTABLES: PREPARING A SOCIAL MEDIA MARKETING REPORT
MODULE 8: PERFORMING WHAT-IF ANALYSES: MAXIMIZING PROFITS WITH THE RIGHT PRODUCT MIX
MODULE 9: EXPLORING FINANCIAL TOOLS AND FUNCTIONS: ANALYZING A BUSINESS PLAN
MODULE 10: ANALYZING DATA WITH BUSINESS INTELLIGENCE TOOLS: PRESENTING SALES AND REVENUE DATA
MODULE 11: EXPLORING PIVOTTABLE DESIGN: SUMMARIZING SALES AND REVENUE DATA
MODULE 12: DEVELOPING AN EXCEL APPLICATION: CREATING A DATA ENTRY APP
INDEX
ACCESS MODULES
Module 1: Creating a Database: Tracking Patient, Visit, and Billing Data
Module 2: Building a Database and Defining Table Relationships: Creating the Billing and Patient Tables
Module 3: Maintaining and Querying a Database: Updating and Retrieving Information about Patients, Visits, and Invoices
Module 4: Creating Forms and Reports: Using Forms and Reports to Display Patient and Visit Data
Module 5: Creating Advanced Queries and Enhancing Table Design: Making the Clinic Database Easier to Use
Module 6: Using Form Tools and Creating Custom Forms: Creating Forms for Lakewood Community Health Services
Module 7: Creating Custom Reports: Creating Custom Reports for Lakewood Community Health Services
Module 8: Sharing, Integrating, and Analyzing Data: Importing, Exporting, Linking, and Analyzing Data in the Clinic Database
Module 9: Using Action Queries and Advanced Table Relationships: Enhancing User Interaction with the Health Database
Module 10: Automating Tasks with Macros: Creating a User Interface for the Health Database
Module 11: Using and Writing Visual Basic for Applications Code: Creating VBA Code for the Health Database
Module 12 Managing and Securing a Database: Administering the Health Database
APPENDIX A: RELATIONAL DATABASES AND DATABASE DESIGN
INDEX
POWERPOINT MODULES
Presentation Concepts: Planning, Developing, and Giving a Presentation: Preparing a Presentation for a Resort
Module 1: Creating a Presentation: Presenting Information about an Insurance Company
Module 2: Adding Media and Special Effects: Using Media in a Presentation for a Veterinary Hospital
Module 3: Applying Advanced Formatting to Objects: Formatting Objects in a Presentation for a Sales and Marketing Company
Module 4: Advanced Animations and Distributing Presentations: Creating an Advanced Presentation for Agricultural Development
Module 5: Integrating PowerPoint with Other Programs: Creating a Presentation for a Rowing Convention
Module 6: Customizing Presentations and the PowerPoint Environment: Creating a Presentation for a City-Wide Green Challenge
INDEX
Office Integration Project
Outlook
Outlook Module 1: Managing Email Messages with Outlook
Outlook Module 2: Managing Calendars with Outlook
Outlook Module 3: Managing Contacts and Personal Contact Information with Outlook
Outlook Module 4: Creating and Managing Tasks with Outlook
Outlook Module 5: Customizing Outlook
Career Readiness
