- Description
IT/200
DIGITAL SKILLS FOR THE 21ST CENTURY
The Latest Version A+ Study Guide
**********************************************
IT 200 All Participations Link
https://hwsell.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.