Ch 1: Online Essentials
Chapter 1 Introduces students to the history of computing and the basics of how computers work. It covers the Internet and social media, giving students the opportunity to work within a secure internet environment. Students will learn different methods of digital communication, including Outlook email, instant messaging, forums, text messaging, video chat, and social networking. This chapter also covers online safety and security, how to configure security settings, how to respond to social engineering tactics, and how to evaluate and use information found on the internet.
Ch 2: Computer Essentials
Chapter 2 presents computer hardware components and how to set up peripheral and internal parts of a computer. It also introduces operating systems, allowing students to interact with the Windows 10 user interface, including: display settings, screen savers, printing features and file management. Students will learn about application software and collaboration tools before being introduced to computer networking and setting up user accounts. This chapter will cover principles of databases with an introduction to SQL and Access. It introduces computer programming logic and language such as HTML, CSS, and JavaScript. The chapter concludes with an introduction to Information systems and potential careers.
Ch 3: Common Office Features
Chapter 3 explores common features across Microsoft Office products, such as the ribbon and the backstage view. It also covers how to customize the user's view and options. Students will learn to print files, as well as navigate and search documents within Microsoft Office. This chapter concludes with practicing how to insert and format objects such as shapes and images.
Ch 4: Microsoft Word
Chapter 4 provides extensive practice with features found in Microsoft Word, so that students can become proficient with word processing. This chapter covers creating documents, inserting and modifying text within a document, using the clipboard, and formatting pages and paragraphs. Students will learn how to edit documents, using editing tools like spell check and the thesaurus. They will learn to insert illustrations, objects, and tables; modify tables; and apply styles, templates and themes. Important skills covered in this course are: managing citations and references, inserting content as headers and footers, and using collaboration tools within Word. This chapter concludes with a short introduction to macros.
Ch 5: Microsoft Excel
Chapter 5 introduces several important features of Microsoft Excel. It covers creating spreadsheets, managing workbooks, entering data, formatting cells, organizing data, and validating data. Students will learn about protecting data and printing worksheets. They will also be introduced to creating formulas and advanced functions to analyze data and input that data into charts and tables. The chapter concludes by introducing tools that help with data analysis such as outlines and PivotTables.
Ch 6: Microsoft PowerPoint
Chapter 6 explores many important features of PowerPoint for creating presentations. It covers how to manage, design, and edit presentations. Students will learn how to format text and content placeholders, use themes and template designs, and use slide masters. As they build diverse presentations, they will learn to format objects like SmartArt, shapes, tables, and charts. This chapter covers how to format pictures and apply animations and transitions to make presentations more visually appealing. It concludes by covering tools and best practices when delivering a presentation.
Ch 7: Microsoft Access
Chapter 7 is an introductory course to databases in Microsoft Access. It starts by covering relational databases and managing an existing Access Database. It covers designing and creating tables, creating relationships, importing data, and creating simple queries. Students will learn how to create forms to control data entry and how to build reports to share. This chapter concludes by introducing advanced features such as managing records, cross tab queries, query parameters, and calculated fields.
Ch 8: Microsoft Outlook
Chapter 8 introduces students to email features within Microsoft Outlook. Beginning with how to send and receive messages, it covers tools that are meant to help manage messages, including file management, flagging, and automation. Students will work with their calendar and schedule meetings. This chapter concludes by introducing how to create and manage contacts and groups.
Ch 1: Online Essentials
The Information Age
- Introduction to Desktop Computer Systems
- A Brief History of Computing
- The Binary Number System
- Bits & Bytes
- Digital Sound & Video
- Digital Images
- File Compression
- Technology and Ethics
The Internet and Social Media
- The Web and Other Internet Technologies
- Using Web Browsers
- Web Browser Troubleshooting
- Website Navigation
- Google Chrome Facts
- Mozilla Firefox Facts
- Microsoft Edge Facts
- Social Media
- Cloud Computing
- Online Streaming
Digital Communication
- Digital Communication
- Smartphone Facts
- Digital Privacy
- Gmail and Google Calendar
- Introduction to Outlook
- Checking Your Email
- Formatting and Sending Messages
- Email Etiquette
- Attachments and Hyperlinks
- Rules of Netiquette
Online Safety and Security
- Computer Security Risks
- Windows Firewall
- Malware Protection on Windows
- Windows 10 Security Measures
- Configuring Web Browsers
- Internet Safety and Security
- Ecommerce Safeguards
- Encryption and Authentication
Evaluating Online Information
- Online Searches
- Copyright and Intellectual Property
- Online Academic Research
Ch 2: Computer Essentials
Computer Hardware
- Desktop and Mobile Devices
- PC Hardware Components
- Ports and Connectors
- Peripheral Devices
- Printers
- Checking System Requirements
System Software
- System Software
- Operating System Functions
- Common Operating Systems
- The Windows 10 Operating System
- Windows 10 Components
- Windows Settings
- Windows Printing Features
- Windows Update
File Management
- Storage Devices
- File Storage Options
- Windows File Management
- Shared Storage
- Cloud Storage
Application Software
- Desktop Applications
- Collaboration Tools
- Installing Applications
Networking and User Accounts
- Wired and Wireless Networks
- Networking Facts
- The Internet
- Internet Protocols
- Internet Service Types
- Network Servers
- Windows User Accounts
Databases
- Introduction to Relational Databases
- Database Terminology
- Tour of Access
- SQL
- Database Terms
- Big Data
Computer Programming
- Basic Programming Concepts
- Programming Languages
- Object-Oriented Programming
- Programming Logic
- HTML, CSS, and JavaScript
- Careers in Computer Programming
- Computer Science Careers
- Artificial Intelligence
Information Systems
- Introduction to Information Systems
- Systems Analysis & Design
- The ICT Industry
- Information Technology Careers
Ch 3: Common Office Features
Getting Started with Office
- Introduction to Office Applications
- Microsoft Office Versions
- Learning Office Applications
- The Ribbon
- Beyond the Ribbon
- Backstage View Options
- Common Office Application Features
- Desktop vs. Web Applications
Customizing Views and Options
- Document Views
- Customizing Toolbars and Ribbons
Printing Files
- Printing Options in Office Applications
Navigating Files
- Navigating Through a Word Document
- Navigating Through an Excel Workbook
Working With Objects
- Formatting Images
- Formatting Shapes
- Object Formatting
Ch 4: Microsoft Word
Creating Documents and Using the Clipboard
- Text Selection
- The Clipboard
- Document File Formats
- Word Printing Tips
- Text Importing
- Document Creation Tips
Modifying Fonts
- Font Changes
- Font Choices
- Font Tips
Formatting Paragraphs
- Paragraph and Line Spacing
- Indentation and Tabs
- Bulleted and Numbered Lists
- Paragraph Borders and Shading
- Paragraph Formatting Tips
Formatting Pages
- Page Layout Options
- Page and Column Breaks
- Tab Stops
- Page Formatting Tips
Editing Documents
- AutoCorrect Options
- Spell Checking
- The Thesaurus
- Document Editing Tips
Inserting Illustrations and Other Elements
- Text Wrap Options
- Illustration Formatting
- Building Blocks and Other Elements
- 3D Models
- Word Illustration Tips
Creating and Formatting Tables
- Word Tables
- Table Formatting
- Advanced Table Formatting
- Word Table Tips
Using Themes, Styles, and Templates
- Word Styles
- Themes and Style Sets
- Word Templates
- Word Theme & Style Tips
Managing References
- Citations and References
- Footnotes, Endnotes, and Advanced Citations
- Captions
- Table of Contents
- Reference Tips
Managing Headers, Footers, and Sections
- Headers and Footers
- Header and Footer Options
- Next Page Section Breaks
- Continuous Section Breaks
- Word Header, Footer, & Section Tips
Using Office Collaboration Features
- Track Changes and Comments
- Combining Revisions
- Distributing Files
- Collaboration Tips
Using Macros
- Macros
Ch 5: Microsoft Excel
Creating and Managing Workbooks
- Spreadsheet Basics
- Worksheet Management
- Templates and Themes
- External Data
- Workbook Management Tips
Organizing and Entering Data
- Deleting and Clearing Cells
- Copy and Paste Options
- Large Data Sets
- Data Entry Tips
Changing Properties and Printing Worksheets
- Data Protection
- Data Validation
- Excel Printing Tips
- Worksheet Printing Tips
Formatting Cells
- Number Formats
- Cell Formats
- Cell Styles and Colors
- Cell Borders
- Cell Formatting Tips
Entering Simple Formulas
- Formulas and Functions
- AutoFill Options
- Add and Average
- Text Functions
- Concatenating in Excel
- Formula Tips
Using Advanced Functions
- Relative and Absolute References
- Advanced Cell References
- Named Cells and Ranges
- The IF Function
- Logical Functions
- Excel Error Messages
- Advanced Function Tips
Displaying Data Charts
- Chart Formatting
- Chart Types
- Chart Tips
Organizing Data in Tables
- Conditional Formatting
- Excel Tables
- Table Customization
- Formulas in Tables
- Excel Table Tips
Summarizing Complex Data
- Creating Outlines
- PivotTables
- Advanced PivotTables
- VLOOKUP
- Complex Data Tips
Ch 6: Microsoft PowerPoint
Introduction To PowerPoint
- Best Practices in Design
Creating and Managing Presentations
- Slide Management
- Presentation Sections
- Presentation Management Tips
Formatting Textual Content
- Text and Content Placeholders
- Text Formatting
- Managing Presentation Content
- PowerPoint Text Formatting Tips
Designing Slides
- Themes and Templates
- Slide Backgrounds
- Slide Design Tips
Using the Slide Master
- Slide Masters
- Slide Footers
- Handout and Notes Masters
- Slide Master Tips
Formatting SmartArt and Shapes
- SmartArt
- Object Formatting
- Digital Ink
- SmartArt and Shape Tips
Formatting Tables and Charts
- PowerPoint Charts
- PowerPoint Tables
- Table and Chart Formatting Tips
Formatting Pictures and Other Media
- Media Formatting
- Advanced Media Formatting
- Media Formatting Tips
Applying Animations and Transitions
- Animation
- Transitions
- Slide Zoom
- 3D Models
- Motion Paths
- Section and Summary Zoom
- Animation and Transition Tips
Delivering Presentations
- Presentation Tools
- PowerPoint Print Options
- Advanced Slideshow Options
- Presentation Delivery Tips
Ch 7: Microsoft Access
Introduction to Access
- Relational Databases
- Access Tasks
Managing Databases
- Tour of Access
- Database Terminology
- Database Management Tips
Designing and Creating Tables
- Database Planning
- Table Design
- Default Values
- Relationships and Lookups
- Data Importing
- Table Design Tips
Use Simple Queries
- Introduction to Queries
- Query Criteria
- Queries with Totals
- Query Tips
Creating Forms
- Access Forms
- Form Formatting
- Form Tips
Creating Reports
- The Report Wizard
- Reports with Totals
- Report Formatting
- Report Tips
Surveying Advanced Access Features
- Managing Databases
- Formatting Tables and Managing Records
- Application Parts
- Crosstab Queries
- Query Parameters
- Action Queries
- Calculated Fields and Conditional Logic
- Advanced Form Options
- Navigation Forms
- Advanced Report Options
- Advanced Query Facts
Ch 8: Microsoft Outlook
Introduction to Outlook
- Checking Your Email
- Outlook Tasks
Sending and Receiving Messages
- Formatting and Sending Messages
- Email Etiquette
- Signatures
- Attachments and Hyperlinks
- Tracking Options
- Message Tips
Managing Messages
- Organizing Messages
- Automating Outlook
- Junk Mail and Clutter
- Conversations
- Searching in Outlook
- Importing and Exporting
- Message Management Tips
Working With Calendars
- Creating and Managing Calendars
- Calendar Items
- Meetings
- Tasks
- Calendar Tips
Managing Contacts and Groups
- Creating Contacts
- Contact Groups
- Using the Navigation Bar
- Working With Multiple Accounts
- Contact and Group Tips