IT 200 All Participations

IT 200 All Participations

Entire Course Link

https://zh.scribd.com/document/340327850/Uop-Tutorial

 

 IT/200

DIGITAL SKILLS FOR THE 21ST CENTURY

 

The Latest Version A+ Study Guide

 

**********************************************

IT 200 All Participations Link

https://uopcourses.com/category/it-200-participations/

**********************************************

 

 

IT 200 Week 1 Lynda.com®: Up and Running with the Chrome™ Browser
 

 

Watch Section 1 “Basic Website Navigation” of the Lynda.com® video, Up and Running with the Chrome Browser.
 

 

 

 

IT 200 Week 1 Lynda.com®: Windows® 10 Fundamentals for IT Pros
 

 

Watch the “Edge and IE” lesson from section 1 “Overview of Windows 10” of the Lynda.com video®, Windows 10 Fundamentals for IT Pros.
 

 

 

 

IT 200 Week 1 Office.com: Create your First Workbook
 

Complete the tutorial “Create your First Workbook” in Microsoft® Excel® Training.

Note: Students have access to Office365™ and can follow along using their own software. Following along with the tutorial will greatly assist your understanding of the software.

 

 
 

 

 

IT 200 Week 1 Week One Electronic Reserve Readings
 

 

Read this week’s Electronic Reserve Readings.
 

 

 

 

IT 200 Week 1 Lynda.com®: Excel® 2016 Essential Training
 

Watch the following sections from the Lynda.com® video, “Excel 2016 Essential Training”:

 

 

 

Section 1, Getting Started with Excel and
 

 

Section 3, Creating Formulas and Functions
 

 

 

 
 

 

 

IT 200 Week 1 Lynda.com®: Mobile for Business: Using Productivity Apps
 

 

Watch Section 3 “Working with Documents” of the Lynda.com® video, Mobile for Business: Using Productivity Apps.
 

 

 

 

IT 200 Week 1 Supporting Activity: Practice with Productivity Tools
 

Work with a classmate, co-worker, friend, or family member using a collaborative productivity tool of your choice.

Test out features such as sharing a screen, sharing a document, and communicate live.

Share with your classmates your thoughts on the product by addressing the following questions:

 

 

 

Which product(s) did you test?
 

 

What did you like and dislike about it?
 

 

Why was it useful?
 

 

What are some issues that can occur?
 

 

How can you use this in your professional life?
 

 

 

 
 

 

 

IT 200 Week 1 Office.com: Getting Started with PowerPoint® 2016
 

Complete the tutorial “Getting Started with PowerPoint® 2016.”

Note: Students have access to Office365™ and can follow along using their own software. Following along with the tutorial will greatly assist your understanding of the software.

 

 
 

 

 

IT 200 Week 2 Pluralsight: TCP/IP and Networking Fundamentals for IT Pros
 

Complete the following sections from the Pluralsight course, “TCP/IP and Networking Fundamentals for IT Pros by Ed Liberman”:

 

 

 

Introduction to TCP/IP and Networking Fundamentals
 

 

What is a Protocol?
 

 

What is TCP/IP?
 

 

 

 
 

 

 

IT 200 Week 2 Lynda.com®: Foundations of Networking: Networking Basics
 

Watch and complete the following sections and subsections from the Lynda.com® video, “Foundations of Networking: Networking Basics”:

 

 

 

Section 1, Network Topologies 

 

 

 

Understanding Logical and physical topologies
 

 

Understanding mesh, bus, and ring topologies
 

 

Exploring star hybrid star topologies
 

 

Section 2, Network Implementations 

 

 

 

Understanding wide area networks(WANs) and metropolitan area networks (MANs)
 

 

Exploring LANs, WLANs, and PANs
 

 

 
 

 

 
 

 

Section 5, Commonly Used Network Devices
 

 

Note:  Completing these exercises will benefit your Supporting Activity responses. Click on the button that is labeled “Exercise files” above the video you are viewing, then click the file name in the pop-up box to download the files to your computer.

 

 
 

 

 

IT 200 Week 2 Khan Academy: How the Internet Works
 

Watch the following sections of the Khan Academy course, “How the Internet Works”:

 

 

 

The Internet: Wires, cables, and WIFI
 

 

The Internet: IP addresses and DNS
 

 

The Internet: Packet, router, and reliability
 

 

The Internet: HTTP and HTML
 

 

Note:  All Khan Academy content is available for free at www.khanacademy.org.

 

 
 

 

 

IT 200 Week 2 Films on Demand®: IT Networks
 

 

Watch the Films on Demand® video, “IT Networks.”
 

 

 

IT 200 Week 2 Pluralsight: Microsoft® Azure: The Big Picture
 

 

Complete the Pluralsight course, “Microsoft® Azure: The Big Picture by Matt Milner.
 

 

 

IT 200 Week 2 Pluralsight: Cloud Computing: The Big Picture
 

 

Complete the Pluralsight course, “Cloud Computing: The Big Picture by David Chappell.
 

 

 

 

IT 200 Week 2 Pluralsight: Accessing and Creating Files Anywhere with Office® Online
 

 

Complete the module entitled, “Accessing and Creating Files Anywhere with Office Online” of the Using Microsoft Office Online (2016) by Heather Ackmann Pluralsight course.
 

 

 

 

IT 200 Week 2 OneDrive®: Why Use OneDrive® to Store Docs
 

 

Watch the video, “Why use OneDrive to store your docs?” from Microsoft® Office.
 

 

 

 

IT 200 Week 3 Week Three Electronic Reserve Readings
 

 

Read this week’s Electronic Reserve Readings.
 

 

 

IT 200 Week 3 Khan Academy: Hour of Databases
 

Complete the “Hour of Databases” module from the series, Hour of Code® by Khan Academy.

Note:  All Khan Academy content is available for free at www.khanacademy.org.

 

 
 

 

 

IT 200 Week 3 Supporting Activity: Tracking Sales
 

As the new manager of a small convenience store, the first thing you noted was that there were problems with the manual process for keeping track of sales. Each sale is written down on a ticket, then entered on a spreadsheet for tracking finances and sales tax to pass on to the state.

Reviewing last week’s sales you found some sales tickets which had not been put on the spreadsheet yet.

Using the Sales spreadsheet provided, add the sale date (mm/dd), customer, item, price, and tax rate for the following purchases from last week.

Use your local sales tax rate for the Tax % column. For example, enter 5% as 5. Use last week’s dates as your sale dates.

Monday:

Joe purchased water for $1.79 and chips for $.75

Sally purchased a candy bar for $.89

George purchased ice for $1.75

Jack purchased bread for $2.14

 

Tuesday:

John, purchased a LG bag of chips for $3.79

Joseph purchased a pen for $1.25

Suzie purchased popcorn for $1.75

Sally purchased a 2 liter bottle of soda for $1.49

George purchased a large bag of chips for $3.79

 

Wednesday:

No purchases were made.

 

Thursday:

Suzanne purchased milk for $2.19

Joe purchased bread for $2.14

 

Friday:

Sue purchased a candy bar for $1.25

Mary purchased popcorn for $1.75

After entering the missing purchases, go to the Sales Summary page and refresh the pivot tables by right clicking and selecting Refresh to see your results.

Discuss with your classmates your experience entering the data and advantages you can think of if the store would upgrade to an automated system using a sales database.

Note: The spreadsheet contains formulas. The cells will highlight in red if incorrect dates are entered and will highlight in yellow if data is missing.

 

 
 

 

 

IT 200 Week 3 Films on Demand®: Deluged by Data: The Infobesity Epidemic
 

 

Watch the segment, “Data Demand” from the Deluged by Data: The Infobesity EpidemicFilms on Demand® video.
 

 

 

IT 200 Week 3 Pluralsight: Data Analytics: Hands-On
 

Complete the following sections from the Pluralsight course, “Data Analytics: Hands on by Ben Sullins”:

 

 

 

Getting Started
 

 

Database overview
 

 

Intro to Data Modeling
 

 

Data warehousing basics
 

 

 

 
 

 

IT 200 Week 3 Data Storytelling: What It Is, Why It Matters
 

 

Read the article, “Data Storytelling: What It Is, Why It Matters,” from Information Week.  
 

 

 

IT 200 Week 3 Supporting Activity: Analytic Tools
 

Complete an Internet search for data analytic tools to review some tools that are available for both consumer and professional use.

Provide a brief summary of one of the tools.

Items to consider include:

 

 

 

Key features
 

 

Usefulness
 

 

Cost
 

 

 

 
 

 

 

IT 200 Week 3 Business Data Trivia
 

 

Complete the Business Data Trivia game, based on the information you gathered from this week’s videos and readings.
 

 

 

 

IT 200 Week 4 Lynda.com®: Working with Your Team
 

Watch the section, “Working with Your Team,” from the Lynda.com® video, Working Remotely.

Note:  Completing these exercises will benefit your Supporting Activity responses. Click on the button that is labeled “Exercise files” above the video you are viewing, then click the file name in the pop-up box to download the files to your computer.

 

 
 

 

 

IT 200 Week 4 Lynda.com®: Mobile and Cloud Computing
 

 

Watch the section, “Mobile and Cloud Computing” from the Lynda.com® video, Meeting the Challenge of Digital Transformation.
 

 

 

 

IT 200 Week 4 Lynda.com®: Understanding Mobile Marketing
 

 

Watch the section, “Understanding Mobile Marketing” from the Lynda.com® course, Mobile Marketing Fundamentals.
 

 

 

 

IT 200 Week 4 Week Four Electronic Reserve Readings
 

 

Read this week’s Electronic Reserve Readings.
 

 

 

IT 200 Week 4 Supporting Activity: Benefits of Mobile Devices
 

Read the article, “Tablets In The Field: Pipeline Post-Construction Restoration Monitoring Case Study” found within this week’s Electronic Reserve Readings.

Complete an Internet search for other studies where organizations have found efficiencies through the use of mobile technology.

List some ways mobile computing devices would benefit your current or future organization.

 

 
 

 

 

IT 200 Week 4 FAA’s Commercial Drone Rule Opens Business Opportunities
 

 

Read the article, “FAA’s Commercial Drone Rule Opens Business Opportunities” from Information Week.
 

 

 

IT 200 Week 4 Films on Demand®: Drone Delivery
 

 

Watch the Films on Demand® video, “Drone Delivery.”
 

 

 

IT 200 Week 4 Wearable Electronic Patch
 

 

Read the article, “Graphene-based wearable electronic patch for diabetes control” from SPIE.org.
 

 

 

IT 200 Week 5 Lynda.com®: Computer Security and Internet Safety Fundamentals
 

Watch the Lynda.com® video, “Computer Security and Internet Safety Fundamentals.”

Note: This video will assist with your Week Five Supporting Activity: Computer System Protection and Individual Assignment.

 

 
 

 

 

IT 200 Week 5 Lynda.com®: Securing Windows® 10
 

Watch the following sections and subsections of the Lynda.com® course, “Securing Windows® 10”:

 

 

 

Section 4. Virus and Malware 

 

 

 

Window Defender
 

 

 
 

 

Section 5. Network Security 

 

 

 

Window Firewall
 

 

 
 

 

Note: This video will assist with your Week Five Supporting Activity: Computer System Protection and Individual Assignment.

 

 
 

 

 

IT 200 Week 5 Lynda.com®: Ethical System Hacking
 

Watch the following sections and subsections of the Lynda.com® course, “Ethical Hacking: System Hacking”:

 

 

 

Section 4. Spyware
 

 

Section 5. Keyloggers 

 

 

 

Protect against keylogging
 

 

 
 

 

Note: This video will assist with your Week Five Supporting Activity: Computer System Protection and Individual Assignment.

 

 
 

 

 

IT 200 Week 5 New ‘Ranscam’ Ransomware Lowers The Bar But Raises The Stakes
 

 

Read the article, “New ‘Ranscam’ Ransomware Lowers The Bar But Raises The Stakes” from Information Week Dark Reading.
 

 

 

IT 200 Week 5 Khan Academy: CyberSecurity
 

Complete the “CyberSecurity” course from Khan Academy.

Note:  All Khan Academy content is available for free at www.khanacademy.org.

 

 
 

 

 

IT 200 Week 5 Stealthy Cyberespionage Malware Targets Energy Companies
 

 

Read the article, “Stealthy cyberespionage malware targets energy companies” from CIO.com.
 

 

 

IT 200 Week 5 Recovering from Viruses, Worms, and Trojan Horses
 

 

Read the article, “Recovering from Viruses, Worms, and Trojan Horses.”
 

 

 

IT 200 Week 5 Supporting Activity: Computer System Protection
 

Resources: Lynda.com® videos:

 

 

 

Securing Windows® 10: Firewall and Defender
 

 

Ethical Hacking: System Hacking
 

 

Follow along with the videos to review your computer system’s security.

Determine what anti-virus software is installed on your computer and explore its capabilities.

Discuss how you would prevent data breach. Do you think the installed software is the appropriate software for your machine? If you were to change it, what would you change it to?

Note: This activity will assist with your Week Five Individual Assignment.

 

 
 

 
Powered by