uCertify

BIS 221T - Introduction to Computer Applications and Systems

(UOP-BIS221T.AE1)
Lessons
Lab
AI Tutor (Add-on)
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Introduction to Computers, Networks, and Information Systems

  • Introduction to Hardware
  • Introduction to Software
  • Introduction to Operating Systems
  • Introduction to the Internet
  • Introduction to Networking
  • Introduction to the World Wide Web
  • Introduction to AI Hardware
  • Cell Phones and Mobile Computing
2

Word Processing, Email, and Emerging Technologies

  • Cranking Out a Shiny, New Word Document
  • Fussing with the View
  • Snappier Ways to Edit and Format Text
  • Navigating Like a Pro
  • Them's the Breaks
  • Managing Margins
  • Shifting Text Sideways with Indents
  • Making Heads and Tails of Headers and Footers
  • Breathing Room: Setting the Spacing
  • Making Lists, Optionally Checking Them Twice
  • Getting Things to Line Up Nice and Neat with Tabs
  • Hyphenating Text
  • Getting Acquainted with Styles
  • Making Your Documents Stylish
  • Concocting a New Style
  • Tweaking a Style
  • Creating and Managing Templates
  • What Is a Table?
  • Constructing a Table
  • Finding and Replacing Text
  • Giving a Document a Makeover with a Theme
  • Adding Some Finishing Touches
  • Corralling Text into Columns
  • Laying Out Text in Linked Text Boxes
  • Trying Out More of Word’s Page Setup Options
  • Getting to Know Copilot
  • Drafting New Text
  • Adding Text to an Existing Document
  • Transforming Existing Text
  • Referencing a File
  • Getting Copilot's Help with a Document
  • Setting Up Your Accounts
  • Getting Acquainted with Outlook
  • Shipping Out a New Message
  • Reading Incoming Mail
  • Using Rules to Process Messages Automatically
  • Exploring the People App
  • Adding a New Contact
  • Working with Your Contacts
  • Getting Together with the Calendar App
  • Items You Can Schedule in Calendar
  • Setting Up an Event
  • Scheduling an All-Day Event
  • Requesting a Meeting
  • Introduction to Emerging Technologies
3

Spreadsheets and Data Entry Tools

  • Getting Comfy with the Excel Window
  • Creating Fresh Workbooks
  • Data Entry 101
  • Selecting Cells and Ranges
  • Adjusting Columns and Rows
  • Formatting Cells from the Ribbon
  • Formatting Numbers, Dates, and Time Values
  • Hiring Out the Format Painter
  • Getting Started with Formulas
  • Augmenting Formulas with Functions
  • Copying Formulas
  • Adding Array Formulas
  • Naming Cells and Ranges
  • Getting Quick Analyses from Excel
  • Eyeballing Trends and Outliers with Conditional Formatting
  • Managing Information in Tables
  • What If You Used What-If Analysis?
  • Summarizing Data with PivotTables
  • Learning Some Crucial Chart Basics
  • Forging a Fresh Chart
  • Selecting Chart Elements
  • Dressing Up Your Charts
  • Getting Copilot on the Job
  • Analyzing Data
  • Creating Formulas
  • Highlighting Data
  • Sorting and Filtering Data
  • Visualizing Data
  • Understanding Access Databases
  • Creating an Access Database
  • Working in the Navigation Pane
  • Designing a Table
  • Creating a Table
  • Importing External Data
  • Creating and Using Forms
  • Getting comfy with the Datasheet view
  • Navigating field-to-field
  • Entering data
  • Adding more records
  • Navigating records
  • Selecting a record
  • Deleting a record
  • Putting Things in Apple-Pie Order: Sorting Records
  • Sorting on a single field
  • Sorting on multiple fields
  • Knocking Things Down to Size: Filtering Data
  • Relating Multiple Tables
  • Understanding referential integrity
  • Relating tables
  • Designing a Simple Query
  • Adding fields to the query
  • Specifying the query criteria
  • Running the query
  • Getting Comfy with Query Criteria
  • Using operands in criteria expressions
  • Using operators in criteria expressions
  • Getting Fancy with a Multiple-Table Query
  • Adding multiple tables to a query
  • Adding fields from multiple tables
  • Modifying Table Data with an Update Query
  • Removing Records from a Table with a Delete Query
  • Creating a New Table with a Make Table Query
  • Adding Records to a Table with an Append Query
4

Presentation and Communication Tools

  • Producing a New PowerPoint Presentation
  • Perusing the PowerPoint Window
  • It's All About the Slides
  • Adding a Slide to the Presentation
  • Filling Out a Slide with Data
  • Getting Copilot to Help
  • Messing Around with Slides
  • Building a Presentation from an Outline
  • Peeking Behind the Curtain: The Slide Master
  • Applying a Slide Theme
  • Formatting Slide Text
  • Formatting Tips and Techniques
  • Slide Formatting Best Practices
  • Animation Guidelines
  • Setting Up a Slide Transition
  • Defining Slide Animations
  • Setting Up Hyperlinks and Action Buttons
  • Rehearsing Slide Timings
  • Adding Voice and Video
  • Creating a Custom Slide Show
  • Running a Slide Show
  • Introduction to Zoom
5

Collaboration, Databases, and Industry Applications

  • Introducing Teams
  • Taking a Look Around
  • Personalizing Teams to Use It Effectively
  • Adding a profile photo
  • Setting your status
  • Noticing Notifications
  • Filtering and Searching
  • Filtering your Activity feed
  • Using Teams to Know Your Colleagues Better
  • What’s All This About a Team? And a Channel?
  • Managing and Working with a Team or Two
  • Joining an existing team
  • Opening a team and viewing its channels
  • Creating a team
  • Adding people to a team
  • Sharing a team
  • Managing team settings
  • Leaving a team
  • Getting to Know Channels
  • Creating a channel
  • Channels versus Chats
  • Conversing in a Channel
  • @mentioning in a conversation
  • Bouncing between Teams conversations and Outlook emails
  • Chatting with Your Team
  • Sending someone a quick message
  • Starting a private or group chat
  • Keeping the chat going: responding to a chat message
  • Renaming a chat
  • Adding and removing people (including yourself) from a chat
  • Setting chat and message options
  • Getting to Know Teams’ Files Tools
  • Getting a Meeting Off the Ground
  • Scheduling a meeting
  • Launching an immediate meeting
  • Using dial-in conference lines
  • Joining in the Meeting Fun
  • Joining from a browser
  • Joining a channel meeting
  • Setting your meeting video, audio, and effects options
  • Participating in a Meeting
  • Adding people to the meeting
  • Viewing the participants list
  • Changing the view
  • Pinning and spotlighting participants
  • Muting yourself and others
  • Sharing your screen and content
  • Using PowerPoint Live
  • Sharing files in a meeting
  • Viewing the meeting chat
  • Recording the meeting
  • Using live captions and transcription
  • Reacting and raising your hand
  • Messing with meeting options
  • Using breakout rooms
  • Leaving and ending the meeting
  • Finding Resources after a Meeting
  • Knowing when to Use OneDrive or SharePoint
  • When to use OneDrive
  • When to use SharePoint
  • Syncing Office 365 Files to Your Devices
  • Linking OneDrive to your Office 365 business account
  • Keeping files always available on your device
  • Syncing Teams and SharePoint files to your device
  • Editing Office files with colleagues
  • Keeping track of a file’s version history
  • Using the Recycle Bin to Restore Deleted Files
  • Copying and Moving Files between OneDrive and Teams
  • Sharing Files Outside Your Organization
  • Sharing a file
  • Getting Started in OneDrive
  • Navigating the navigation pane
  • Viewing and locating stuff in OneDrive
  • Managing Your OneDrive Content
  • Selecting files and folders
  • Performing actions on files and folders
  • Creating a folder
  • Creating a file
  • Uploading files and folders
  • Managing File and Folder Permissions
  • Adding SharePoint and Teams Files to OneDrive
  • Getting Oriented with SharePoint
  • Managing SharePoint Team Sites
  • Understanding the connection between SharePoint team sites and Microsoft 365 groups
  • Adding members
  • Getting familiar with site permissions
  • Working with SharePoint Pages
  • Creating a page
  • Taking a Brief Look at Microsoft Lists
  • Opening a document as read-only
  • Marking a document as final
  • Protecting a document with a password
  • Commenting on a Word Document
  • Entering comments
  • Viewing and displaying comments
  • Replying to and resolving comments
  • Caring for and feeding comments
  • Tracking Changes to Documents
  • Telling Word to start marking changes
  • Reading and reviewing a document with revision marks
  • Accepting and rejecting changes to a document
  • Marking changes when you forgot to turn on revision marks
  • Documenting a Worksheet with Notes
  • Collaborating on a Workcourse with Comments
  • Information Usage in Industry Contexts

1

Introduction to Computers, Networks, and Information Systems

  • Installing Motherboard Components
  • Installing an NIC on the Motherboard of a CPU
  • Installing Input and Output Devices
  • Connecting a USB Flash Drive to a CPU
  • Connecting Devices in a Peer-To-Peer Architecture
  • Identifying Clients and Servers
  • Connecting an iPhone to a Wi-Fi Network
2

Word Processing, Email, and Emerging Technologies

  • Creating and Saving a Document
  • Formatting the Text to Bold
  • Indenting the First Line of a Paragraph
  • Creating a Bulleted List
  • Setting the Tab Stop
  • Enabling Automatic Hyphenation
  • Applying the Heading Style
  • Modifying the Text Style
  • Creating a Document Using a Template
  • Inserting a Table
  • Using Find and Replace to Edit
  • Formatting the Text into Columns
  • Controlling Page Layout
  • Exploring Copilot's Features
  • Referencing Files
  • Sorting and Exporting Contacts in Microsoft Outlook
3

Spreadsheets and Data Entry Tools

  • Creating and Saving a Workbook
  • Adjusting the Columns
  • Hiding the Rows
  • Hiding the Columns
  • Creating Worksheet Formulas
  • Calculating the Sum
  • Using the TODAY Function
  • Creating a Forecast Sheet
  • Converting the Data into a Table
  • Adding Fields to the PivotTable
  • Creating the Combo Chart
  • Changing the Chart Type
  • Changing the Labels of the Line Chart
  • Using the MATCH Function
  • Using the INDEX Function
  • Using the VLOOKUP Function
  • Using the HLOOKUP Function
  • Using the SORT Function
  • Using the FILTER Function
  • Creating Sparklines
  • Creating Custom AutoFill Lists
4

Presentation and Communication Tools

  • Creating and Saving a Basic Presentation
  • Moving a Slide in the Normal View
  • Arranging a Slide in the Slide Sorter View
  • Inserting a New Slide into the Presentation
  • Reusing Slides from Another Presentation
  • Inserting Content into a Placeholder
  • Inserting an Image from the Desktop
  • Modifying the Slide Layout
  • Hiding a Slide
  • Applying a New Theme to the Slide Master
  • Modifying the Background Style of the Slide Master
  • Converting Text to a SmartArt Graphic
  • Using Underline in the Title Text
  • Using the Mini Toolbar to Change the Color of the Text on a Slide
  • Applying the Morph Transition to a Shape
  • Applying and Modifying Animation Effects to a Graphic
  • Animating a SmartArt Graphic
  • Adding an Action Button
  • Recording a Presentation
  • Annotating a Presentation
5

Collaboration, Databases, and Industry Applications

  • Joining an Existing Team
  • Creating a Team
  • Renaming and Managing Chats
  • Scheduling Meetings in Microsoft Teams
  • Sharing and Recording in Microsoft Teams Meetings
  • Syncing Files from SharePoint to Your Device
  • Logging into OneDrive
  • Creating and Organizing Folders in OneDrive
  • Creating a File in Microsoft Teams
  • Navigating and Sharing Files in OneDrive
  • Creating and Designing Pages in SharePoint
  • Creating and Designing Pages in SharePoint
  • Managing Permissions and Shortcuts in OneDrive
  • Creating and Managing SharePoint Team Sites
  • Managing Site Permissions in SharePoint
  • Managing Comments in Microsoft Word
  • Managing and Reviewing Document Changes
  • Working with Notes in Microsoft Excel
  • Assigning Password Protection to Office Documents
  • Sharing Files Securely in Microsoft 365

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us Now

Related Courses

All Courses
We use cookies for improving site experience and analytics. Learn More