uCertify

BIS 221P - Introduction to Computer Applications and Systems

(UOP-BIS221P.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

  • Summative Assessment: Integrated HR Leave Management System
5

Collaboration, Databases, and Industry Applications

  • Summative Assessment: Managing Comments and Track Changes in a Word Document
  • Summative Assessment: Setting Up Team Collaboration in Microsoft Teams
  • Renaming and Managing Channels
  • Scheduling Meetings in Microsoft Teams
  • Sharing and Recording in Microsoft Teams Meetings
  • Summative Assessment: Managing SharePoint Sites, Permissions, and OneDrive Shortcuts
  • Summative Assessment: Managing OneDrive, Microsoft Teams, and SharePoint Collaboration
  • Summative Assessment: Securing and Sharing Documents in Microsoft 365
  • Working with Notes in Microsoft Excel

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us Now

BIS 221P - Introduction to Computer Applications and Systems

$139.99

Buy Now

Related Courses

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