IT/200 Digital Skills for the 21st Century

The Vice President of Sales for your company has asked you for more information on cloud-based office productivity suites. He tells you that the Sales team is often remote and needs to be able to stay connected to the office.    

Or You May Purchase Tutorials by the Week below.
IT/200 Cloud-based Office Productivity Suite Presentation
IT/200 WEEK 1 Presentation Software Comparison
IT/200 WEEK 1 Presentation Software Comparison
IT/200 Cloud-based Office Productivity Suite Presentation

IT/200 Week 1

Everything listed for this week is included in purchase!

 

Individual: Cloud-Based Office Productivity Suite Presentation

Presentation #1 with Full Speaker Notes

Presentation #1 with Full Speaker Notes

Presentation #1 with Full Speaker Notes

Presentation #1 with Full Speaker Notes

Presentation #1 with Full Speaker Notes

Presentation #1 with Full Speaker Notes

The Vice President of Sales for your company has asked you for more information on cloud-based office productivity suites. He tells you that the Sales team is often remote and needs to be able to stay connected to the office. They need to be able to view price sheets, prepare memos and sales agreements, make presentations to clients, have access to their email and schedule, and attend meetings remotely. He asks you to present your productivity suite recommendation at next week's team
meeting.
Create a 6- to 10-slide presentation about a cloud-based office productivity suite, identifying how each of the above needs can be met and the collaborative benefits provided by the suite.
Your presentation must include:
      • A title slide (not included in the slide count)
      • Appropriate and relative graphics or images
      • Detailed speaker notes or recorded audio narration
      • Instructions on how to add audio to Microsoft PowerPoint presentations can be

           found on the Microsoft Office Support site.
      • A reference slide citing all resources used in presentation and speaking notes

         (not included in the slide count)
Note: Students may use a presentation software of their choice.
Submit your presentation using the Assignment Files tab above.

 

Individual: Presentation Software Comparison
Includes Option #1

Includes Option #2

Includes Venn Diagram
Create a matrix comparing five features of presentation software.
Using these five features, compare two presentation programs.
Include a brief reflection on how the programs meet or fail to meet your expectations.
Choose a delivery format for your comparison:
   • Matrix created in a Microsoft Office program
   • Venn Diagram
   • Tips can be found at the Microsoft Office Support website: Create a Venn

       Diagram
    • 1-page summary
Submit your matrix and comparison (two deliverables) to the Assignment Files tab.

 

Supporting Activity: Practice with Productivity Tools

Includes 5 Full Answers to Discussion Question

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?

Supporting Activity: Web-Based Presentation Tools

Includes 5 Full Answers to Discussion Question

Identify three to five important features of web-based collaborative presentation tools.
Based on these characteristics, compare two web-based presentation tools (like PowerPoint, Prezi, Google Slides, or some other presentation software) and share your thoughts with your peers.
Consider including the following thoughts in your response:

  • Which features did you focus your quest?
  • Which tool offered the most features?
  • Which browsers are compatible?
  • Which tool has more useful features?
  • Which tool can you see yourself using in current and future courses?
  • Which tool can you see yourself using in your current or future employment?

Respond to at least two peers who used a tool that you did not use.
Note: This activity will assist with the Week One Presentation Software Individual Assignment. 

 

Discussion: Lynda.com®: Windows® 10 Fundamentals for IT Pros

Includes 5 Full Answers to Discussion Question

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

 

Discussion: Prezi: Overview

Includes 5 Full Answers to Discussion Question

Watch the Prezi Overview video. Discuss with your classmates.

 

IT/200 Computer Networking & Configurations
IT/200 Software Security
IT/200 Computer Networking & Configurations
IT/200 Computer Networking & Configurations

IT/200 Week 2

Everything listed for this week is included in purchase!

 

Individual: Computer Networking and Configurations

Presentation #1 - 7 Slides with Full Speaker Notes

Presentation #2 - 7 Slides with Full Speaker Notes

Presentation #3 - 7 Slides with Speaker Notes

Presentation #4 - 7 Slides with Full Speaker Notes

You are hired as a Chief Technology Officer (CTO) of a startup company, which has two branches; one Los Angeles and one in San Francisco. The company hired employees to begin working on the design of the product. As CTO, you need to explain to the Board of Directors your idea in interconnecting the two offices to ensure consistency and collaboration. Employee's computer systems need to
be connected and permitted to connect remotely (from outside of the office).
The following needs to be taken into consideration:
      • Network topology
      • Network protocols
      • Cost of implementation
      • Cloud Productivity software
Choose a delivery method from the following to present your explanation to the Board of Directors:
      • Visual diagram with a brief explanation (PDF format)
      • Diagrams can be made using any Microsoft Office product or sites such as

          Lucidchart.
      • Matrix
      • 5- to 7-slide presentation with narration or detailed speaker notes
         Instructions on how to add audio to Microsoft PowerPoint presentations can be

         found on the Microsoft Office Support site: Add audio to your presentation.
Submit your explanation to the Assignment Files tab above.

 

Learning Team Collaborative Activity: Software Security

Includes Option #1

Includes Option #2

The head of a large health care provider is very concerned about the security across all its departments. You are approached by the IT Security Chief to assist him in figuring out the best security application in preventing computer security holes.
As a group, discuss your ideas on how to go about selecting the right software to provide protection to the company's computer system.

 

 

 

Note: Discussion questions may be different, depending on which Instructor you get.

 

 

Supporting Activity: Microsoft Azure vs. Oracle Cloud Solutions

The new CEO of your organization is planning to move your company to the cloud. He needs your help comparing Microsoft Azure and Oracle cloud solutions to allow his sales teams to make decision from anywhere, 24/7, and to have access to customers' and sales data.
Based on your Collaborative Activity discussion, share your recommendation.
Note:  While you should reference your group discussion, you need to make your own decision and final recommendation when responding to this activity.
Respond to at least two people who were not in your Collaborative Activity group about how your answers differed. 

 

Discussion Question: Networking Basics from Lynda.com: Foundations of Networking: Networking Basics

Includes 5 Full Answers to Discussion Question

As you watch this video, you might be wondering about the whole "topology" aspect. That term used to mean more than it does today, so just take it in as food for thought. Local Area Networks are almost universally laid out the same way today, Ethernet over either fiber or copper going to a "switch."  Or, it's just a bunch of devices connected via WiFi.  Like I said, watch the video but don't think that you need to have a mastery of what a network topology is.  I can go in depth on the topic if you'd like, just give me a shout. Any questions on network technology so far?

 

Supporting Activity: Unified Communication Terminologies

Includes Answer #1

Includes Answer #2

Following are terms often used in the unified communication platform. Research and pick two to three terms, and describe them to the best of your knowledge and research:

     * VoIP

     * Softphone

     * Full Duplex

     * Half Duplex

     * PBX

 

Supporting Activity: Unified Communication Platforms

Based on what you have learned about using unified communication platforms in a collaborative environment, create a 5-slide presentation to a department head or the CEO of a company to convince the audience that this would benefit their business.
Remember to state the business problem, articulate the current setup, explain how unified communication platforms are different, and how they benefit the business.

Click the Assignment Files tab to submit your assignment.

 

 

 

IT/200 Week 3 Point of Sale Data Collection
IT/200 Week 3 Automating Sales & Inventory
IT/200 Week 3 Automating Sales and Inventory
IT/200 Week 3 Automating Sales and Inventory

IT/200 Week 3

Everything listed for this week is included in purchase!

 

Individual: Point of Sale Data Collection

Includes Option #1

Includes Option #2

Includes Option #3

During your weekly trip to the grocery store, you purchase bread, milk, cold cereal, bananas, and ice cream. The purchase was made using a debit card.
Create a table listing at least seven data items collected in this transaction and how they are entered into the system.
Submit your table in a Word document or on an Excel® spreadsheet to the Assignment Files tab above.

 

Individual: Automating Sales and Inventory

Includes Option #1 Business Proposal

Includes Option #2 Business Proposal

Includes Option #3 Business Proposal

Includes Optiion #4 PowerPoint Presentation with Speaker Notes!

Includes Option #5 PowerPoint Presentation with Speaker Notes!

Includes Option #6 PowerPoint Presentation with Speaker Notes!

As the new manager of a convenience store, you have noticed issues with the manual method of tracking sales using paper sales tickets and spreadsheets, as well as, shortages on some of the more popular items carried in the store.
Present your case for upgrading to a database driven solution for tracking sales and inventory to the store owners. They are concerned about the cost and want to know what this upgrade would entail.
Include the following:
      • How a system could improve efficiency
      • How a system could improve accuracy
      • How sales of individual items would be entered
      • How the database would store the data compared to the current spreadsheet

          method
      • How monitoring of inventory levels based on sales using the database would

          work
Choose one of the following presentation deliverables:
      • An 8- to 10-narrated slide presentation, with appropriate graphics
      • A written business proposal (approximately two pages)
      • Another deliverable approved by your faculty member
Submit your presentation to the Assignment Files tab above.

 

 

Note: Discussion questions may be different, depending on which Instructor you get.

 

Learning Team Collaborative: Impacts of Inaccurate Data

Includes 2 Full Answers

When you look at data you are looking at individual facts. Data organized in a meaningful way becomes information. Information is used in making business decisions.
After reading this week's Electronic Reserve Readings, discuss with your team, the impacts on a business providing inaccurate data, intermediate organizations making decisions based on that data, and the impact on the business' consumers.

 

Discussion Question: Data Storytelling: What It Is, Why It Matters

Includes 5 Full Answers to Discussion Question

Read the article, "Data Storytelling: What It Is, Why It Matters," from Information Week.  
Discuss with your classmates.

 

Supporting Activity: Analytic Tools

Includes 3 Full Answers to Discussion Question

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

Supporting Activity: Tracking Sales

Includes 3 Full Answers to Discussion Question

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 4 Social Media Marketing
IT/200 Medical Technologies
IT/200 Medical Technologies
IT/200 Medical Technologies

IT/200 Week 4

 

Everything listed for this week is included in purchase!

 

Individual: Mobile Devices and Social Media (aka Social Media Marketing)

Includes Option #1

Includes Option #2

Includes Option #3

Includes Option #4

The local Chamber of Commerce has asked you to speak at the next meeting on your business' successful social media campaign. They asked you to specifically touch on how social media can be used to make potential customers aware of what the company has to offer.
Create a 1-page outline of your speaking points on this topic.
Include the following information:
      • Benefits of social media
      • How social media can be used to promote a company's services
      • Brief examples
Submit your outline to the Assignment Files tab above.

 

Individual: Medical Technologies

Option #1 included: Presentation with Speaker Notes PLUS MP4 Movie

Option #2 included: Presentation with Speaker Notes PLUS MP4 Movie

Option #3 included: Infographic (from Easel.ly)

You are hired as a research coordinator by the new hospital in town. One mission of the hospital is to work hard in preventing health issues by using new technologies created by health conscious engineers. Your task is to review health-related videos and articles and provide a summary of current technology being used in the medical field to prevent health issues for the hospital stakeholders.
Your summary must include:
      • A summary of at least three health-related technologies
      • The advantages of each one, including how it helps in preventing a health issue
      • An explanation of how robots and artificial intelligence can benefit hospitals
Choose one of the following options for your summary:
      • A 2- to 3-minute podcast using the software of your choice, such as Sound

         Recorder or Audacity to create your audio file and save as a MP3 or WAV.
      • A 2- to 3-minute video delivered as an MP4 or MOV file.
      • Infographic delivered as a PDF. You may use any Microsoft Office product or free

          sites such as Piktochart, Easel.ly, or Canva to create an infographic.
Submit your summary to the Assignment Files tab above.

 

Learning Team Collaborative Activity: Incorporating Social Media

Includes PowerPoint with Full Speaker Notes #1

Includes PowerPoint with Full Speaker Notes #2

The Director of Marketing assigned your team to present on the usage of social media for business at the next company meeting.
As a group, research social media for business sites and discuss the following:

  • The importance of incorporating social media into a business
  • Compare different social media sites and identify their key cool features
  • Identify which social media site is appropriate for which types of business
  • Describe how mobile computing helps a business when integrated with social media

Discussion Question: Benefits of Mobile Devices

Includes 3 Full Answers to Discussion Question.

Based on what you have learned about using social media in today's enterprises, prepare a 5-slide presentation to a department head or the CEO of a company to convince the audience that this would benefit their business.

Remember to state any business goals, articulate the current setup, explain how social media is different, and how it benefits the business.

Click the Assignment Files tab to submit your assignment.

 

 

IT/200 Week 5 Data Breaches Presentation
IT/200 Week 5 Data Breaches Presentation
IT/200 Week 5 Data Breaches Presentation
IT/200 Week 5 Data Breaches Presentation

IT/200 Week 5

 

Everything listed for this week is included in purchase!

 

Individual: Data Breaches

Option #1 included: PowerPoint plus MP4 Movie (with instructions and fully editable!))

Option #2 included: PowerPoint plus MP4 Movie (with instructions and fully editable!)

Option #3 included: PowerPoint plus MP4 Movie (with instructions and fully editable!))

Option #4 included: PowerPoint plus MP4 Movie (with instructions and fully editable!))

The head of the IT security department expressed her concerns about series of data breaches that occurred in the company and mentioned that many employees ignored their system security warnings.
You have been asked to provide a summary of information to the entire team about data breaches and suggest proactive and preventative measures for warding off viruses. Your presentation will be sent out to all company employees, so the information must be clear, concise, and informative.
To prepare your presentation, use your personal computer to perform the following tasks:
      • Identify whether you have an anti-virus software running on your machine and

          from which company.
      • Identify if a firewall is enabled on your machine and if you need Windows firewall

          running in addition, if that anti-virus software is installed on your machine.
Include the following in your summary:
      • Definition of a data breach
      • Ways to determine if your system was infected with a virus
      • At least three preventive measures against data breaches, both physical or

         digital

     • Instructions on locating anti-virus and firewall software
     • Instructions on what to do if a virus has infected your computer
Choose one of the following options for your summary:
       • A 2- to 3-minute podcast using the software of your choice, such as Sound

          Recorder or Audacity to create your audio file and save as a MP3 or WAV.
      • A 2- to 3-minute video delivered as an MP4 or MOV file.
      • Infographic or visual diagram delivered as a PDF. You may use any Microsoft    

         Office product or free sites such as Piktochart, Easel.ly, or Canva to create an

         infographic.
      • Another deliverable approved by your faculty member.
Submit your summary to the Assignment Files tab above.

 

Learning Team Collaborative Activity: Security Software
The head of a large health care provider is very concerned about the security across all its departments. You are approached by the IT Security Chief to assist him in figuring out the best security application in preventing computer security holes.
As a group, discuss your ideas on how to go about selecting the right software to provide protection to the company's computer system.

 

 

Supporting Activity: Computer System Protection
Includes 3 Full Answers to this Discussion Question
• 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?