BIT-200 Syllabus PDF

Preview

Summary

syllabus...

Description

BIT-200 Introduction to Computer Technology Course Syllabus

Version 16.0

Introduction to Computer Technology Course Code

Type

Duration

Credit Hours

BIT-200 v:16. 0

Credit Based

105 Days

4.0

Course Description This course provides the foundation of core knowledge within the field of information technology. Topics include technology-centric organizations, the type and role of fundamental information technology systems, data management to include privacy and security, e-business and m-business, hardware, software, and computer networks.

Pre-Requisites None

Co-Requisites None

BIT-200 C

Course Materials

GO! All in One: Computer Concepts and Applications Description: Gaskin, S., Vargas, A., Goeghan, D., & Graviett, N. (2017). GO! All in one: Computer concepts and applications(3rd ed.). New York, NY: Pearson. ISBN-13: 9780134505749

Audio PowerPoints to Accompany GO! All in One: Computer Concepts and Applications Description: Gaskin, S., Vargas, A., Goeghan, D., & Graviett, N. (2017). Audio PowerPoints to accompanyGO! All in one: Computer concepts and applications (3rd ed.). New York, NY: Pearson. ISBN-13: 9780134505749 Copyright 2017 by Pearson Education, Inc. Reprinted with permission of the publisher.

page 1 of 26

Microsoft Office 365 ProPlus Description: Microsoft Office 365 ProPlus will be used to complete some of the assignments in the course. To access this software, you must locate and install it on your selected device using the link provided. Please note that each type of device has a link to its own specific installation guide, and you will need to select your device for proper installation.

Creating Effective PowerPoint Presentations Description: Refer to the resource, "Creating Effective PowerPoint Presentations," located in the Student Success Center, for additional guidance on completing this assignment in the appropriate style.

Honors Materials Description: The attached"Honors Addendum" provides essential information for students who are enrolled in this course for honors credit. Additional documents, including honors rubrics, may also be included. Honors students should review the "Honors Addendum" and any associated documents thoroughly. Please find time within the first week of class to meet with your instructor to discuss the "Honors Addendum," any changes to it, and expectations for successful completion of the instructional activities in this course for honors credit.

Excel Help and Learning Description: Use the Excel Help and Learning page of the Microsoft Support website for assistance with assignments and discussion questions.

T

Topic 1: Microsoft Office Essentials

Description

Objectives:

1. Utilize common software programs for business communications. 1/7 Participation- Field of study? Description: Class, in 75-100 words...please describe the following: Using the technologies discussed today, which are you most interested in. How do you think the technology can be used in your selected field of study? Greg

page 2 of 26

S

Study Materials

GO! All in One: Computer Concepts and Applications Description: Read Chapters 12, 15, and 18 in GO! All in One: Computer Concepts and Applications.

Microsoft Office 365 ProPlus Description: Microsoft Office 365 ProPlus will be used to complete some of the assignments in the course. To access this software, you must locate and install it on your selected device using the link provided. Please note that each type of device has a link to its own specific installation guide, and you will need to select your device for proper installation.

Audio PowerPoints to Accompany GO! All in One: Computer Concepts and Applications Description: View the audio PowerPoint presentations to accompany Chapters 12, 15, and 18 in GO! All in One: Computer Concepts and Applications. Copyright 2017 by Pearson Education, Inc. Reprinted with permission of the publisher.

12 Tips for Delivering a Knockout Business Presentation Description: Read "12 Tips for Delivering a Knockout Business Presentation" by Russell (2018), located on the Lifewire website.

Simple Rules for Better PowerPoint Presentations Description: Read "Simple Rules for Better PowerPoint Presentations," located on the GCF Global website.

Microsoft Office 365 ProPlus: Windows Description: Read "Microsoft Office 365 ProPlus: Windows," located on the GCU Technical Support website.

Microsoft Office 365 ProPlus: Mac Description: Read "Microsoft Office 365 ProPlus: Mac," located on the GCU Technical Support website.

Excel Help Center Description:

page 3 of 26

Utilize the Excel Help Center for assistance in using Excel software.

Word Help Center Description: Utilize the Word Help Center for assistance in using Word software.

PowerPoint Help Center Description: Utilize the PowerPoint Help Center for assistance in using PowerPoint software.

Welcome to Office Help and Training Description: Utilize "Welcome to Office Help and Training" for assistance in using Microsoft Office software.

Office Templates and Themes Description: Utilize the Office Templates and Themes as needed to complete the topic assignments.

T

Tasks

Employee Health Opportunities Memo and Video Sales Spreadsheet Description: In the following assignment, you will utilize both Microsoft Word and Microsoft Excel to demonstrate competency in Microsoft Office software. Part 1 The purpose of Part 1 is to utilize a template in Microsoft Excel to create a spreadsheet and an associated visual aid. As a sales manager at Lopes Athletic Productions, a company specializing in fitness video production, you are required to report your sales numbers weekly to the vice president of sales. Create an Excel spreadsheet that provides the following information. Label each column with the following headings: 1. 2. 3. 4. 5.

Total Sales for Each Type of Video Total Sales of All Videos Percentage of Total Sales for Each Type of Video Use Formulas to Calculate All Totals A Chart That Summarizes the Sales Data

The data needed for the spreadsheet is as follows: 1. 2. 3. 4. 5.

Pilates sold 156 videos at $29.99 each. Step sold 392 videos at $14.99 each. Weight Training sold 147 videos at $54.99 each. Kickboxing sold 282 videos at $29.99 each. Yoga sold 165 videos at $34.99 each.

page 4 of 26

Add a second worksheet to your workbook 1. Insert a chart in a bar format linked to data on your first worksheet. 2. This bar chart should reflect the total sales of each type of video. Part 2 The purpose of Part 2 is to utilize a business memo template in Microsoft Word to create a memo discussing your results. Write a memo (250 words minimum) to inform employees of the importance of fitness in the workplace. Ensure that the memo contains the following elements: 1. 2. 3. 4. 5. 6.

Date To From CC Re Fictional company information, including name, phone number, street address, city, state, ZIP, website address, and e-mail address 7. Logo (Locate and insert an appropriate image.) The following information should be included in the body of the memo: 1. 2. 3. 4. 5.

The fitness courses will be taught each year by industry professionals and are designed to improve skills Employees who have been with the company for at least 2 years are eligible to view the videos free of cost. The video classes provide employees with opportunities to improve their health and achieve fitness certification. All video courses can be viewed at the Sturgeon Point website. Interested employees should contact Elana Springs in Human Resources to sign up. Her contact information is [email protected] and her phone extension is 5555. 6. Informational meetings are being held at 5:30 p.m., according to the following schedule: Television Development on June 15, Motion Picture Production on June 17, and Recording Services on June 21.This information should be presented as a bulleted list. 7. Viewing the video and completing the survey will qualify employees for a discount on their health insurance. In addition to the written content, the memo will be assessed on the following formatting criteria. 1. 2. 3. 4.

Use of Times New Roman 12-point font. Use of left justified margin. Use of 1-inch margins Use of single spacing with double spacing between headings and paragraphs and among paragraphs.

General Requirements Submit only the Microsoft Excel spreadsheet file and the Microsoft Word document files. Both documents should be submitted at the same time. Do not submit any other file format, such as an Adobe PDF file, or you will not earn full credit. While APA style is not required for the body of this assignment, solid academic writing is expected, and documentation of sources should be presented using APA formatting guidelines, which can be found in the APA Style Guide, located in the Student Success Center. This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion. You are not required to submit this assignment to LopesWrite.

Benchmark - Sales Results PowerPoint Presentation Description:

The purpose of this assignment is to utilize Microsoft PowerPoint to create a business presentation. As a sales manager at Lopes Athletics Productions, you are required to report your sales numbers weekly and share them with the vice president of sales. Create a PowerPoint presentation with a minimum of five slides based upon the Excel spreadsheet you created for the Video Sales Spreadsheet assignment. Utilize the bar chart from the spreadsheet as a graphic element on at least one slide in the presentation. The presentation should summarize the following information for the vice president of sales: 1. Total sales for each type of video. 2. Total sales of all videos. 3. Percentage of total sales for each type of video. page 5 of 26

4. A chart that summarizes the sales data. In addition to the content, the presentation will be assessed on the following criteria: 1. Slide structure includes correct use of bullet points and the 6 x 6 rule. 2. Slide appearance includes consistent theme, text alignment, readable font, and clear photos/charts. 3. Slide content is accurate, concise, and focused on a single topic. 4. Use of chart enhances the presentation and illustrates slide information. 5. Speaker notes are appropriate, explain slide content, and add details not presented on the slide. Submit the Microsoft PowerPoint presentation file. Do not submit any other file format, such as an Adobe PDF file, or you will not earn full credit. Refer to the resource, "Creating Effective PowerPoint Presentations," located in the Student Success Center, for additional guidance on completing this assignment in the appropriate style. APA style is not required, but solid academic writingis expected. This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion. You are not required to submit this assignment to LopesWrite. Benchmark Information This benchmark assignment assesses the following programmatic competencies: BS Business Secondary Education 7.1: Demonstrate computer literacy skills. Welcome to Class Description: Explore your classroom in LoudCloud. What are you excited about learning? What do you think will be most challenging?

Topic 1 Participation Description: NA

T

Topic 2: Hardware and Software

Description

Objectives:

1. Evaluate hardware and software used in business organizations.

S

Study Materials

GO! All in One: Computer Concepts and Applications page 6 of 26

Description: Read Chapters 1-3 in GO! All in One: Computer Concepts and Applications.

Audio PowerPoints to Accompany GO! All in One: Computer Concepts and Applications Description: View the audio PowerPoint presentations to accompany Chapters 1-3 in GO! All in One: Computer Concepts and Applications. Copyright 2017 by Pearson Education, Inc. Reprinted with permission of the publisher.

How Computers Work: Hardware and Software Description: View "How Computers Work: Hardware and Software," by Code.org (2018), located on the YouTube website.

Excel Help Center Description: Utilize the Excel Help Center for assistance in using Excel software.

Word Help Center Description: Utilize the Word Help Center for assistance in using Word software.

PowerPoint Help Center Description: Utilize the PowerPoint Help Center for assistance in using PowerPoint software.

Office Templates and Themes Description: Utilize the Office Templates and Themes as needed to complete the topic assignments.

T

Tasks

Laptop Computer Cost Comparison and Computer System Options Memo Description:

page 7 of 26

The purpose of this assignment is to use Microsoft Excel to create a laptop computer system cost comparison spreadsheet and to utilize Microsoft Word to report the costs and the pros and cons of various computer systems. Your manager has approved the purchase of new laptop computers for your department. You have been tasked with researching various computer systems. Part 1: Laptop Computer Cost Comparison Create a Microsoft Excel spreadsheet that summarizes the cost base for three laptop computer systems. In Excel, identify three laptop systems and the costs. The following hardware and software parameters were specified for the new laptop computers. Include information on the specifications listed below: 1. 2. 3. 4. 5. 6. 7.

Computer brand and model Price CPU: type, clock speed, number of cores RAM: amount and type Screen size and resolution Primary disk: capacity, hard drive or SSD Optical disc drive (optional)

Next, identify and describe three software programs specific to your career field of study (should not include Microsoft Office). Programs should be used for productivity, data management, unique needs of the field, increasing market share, and increasing competitive advantage. At the bottom of the spreadsheet, merge a block of several cells to create a large cell. In this area, provide a link to the website where this product can be found. 1. Add a new worksheet page and create two pie charts. 2. Pie Chart 1 should compare the cost of the three laptop systems. 3. Pie Chart 2 should compare the cost of the three software programs. Part 2 - Laptop Computer Systems Options Memo The purpose of this assignment is to utilize Microsoft Word to report the costs and pros and cons of various computer systems. Your manager has asked you to create an e-mail to present your findings about the cost of the laptop computer system options to management. Use the data and pie charts from the Part 1 spreadsheet as the basis for the e-mail, including: 1. 2. 3. 4.

Summary of the laptop computer systems to be considered. Cost base. At least one pro and one con for each of the systems. Three pictures that represent each of the computer systems being considered.

General Requirements Submit both the Microsoft Excel spreadsheet file and the Microsoft Word document files. Do not submit any other file format, such as an Adobe PDF file, or you will not earn full credit. While APA style is not required for the body of this assignment, solid academic writing is expected, and documentation of sources should be presented using APA formatting guidelines, which can be found in the APA Style Guide, located in the Student Success Center. This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion. You are not required to submit this assignment to LopesWrite.

Laptop Computer System and Selection Presentation Description: Now that you researched three different laptop computer systems, select a laptop computer system that you chose to recommend to the management for the purchase. Create a PowerPoint presentation with a minimum of six slides that summarizes and justifies the one laptop computer you have selected. Management has asked that you address the following in the presentation: 1. 2. 3. 4. 5.

Computer brand and model Price CPU: type, clock speed, number of cores RAM: amount and type Screen size and resolution

page 8 of 26

6. Primary disk: capacity, hard drive or SSD 7. Optical disc drive (may be optional) 8. Detailed discussion of software specific to your career field of study that will be used for productivity, data management, unique needs of the field, increasing market share, and increasing competitive advantage (QuickBooks, SalesForce, Google Analytics, Epic, etc.), including the associated cost. Submit the Microsoft PowerPoint presentation file only. Do not submit any other file format, such as an Adobe PDF file, or you will not earn full credit. Refer to the resource, "Creating Effective PowerPoint Presentations," located in the Student Success Center, for additional guidance on completing this assignment in the appropriate style. While APA style is not required for the body of this assignment, solid academic writing is expected, and documentation of sources should be presented using APA formatting guidelines, which can be found in the APA Style Guide, located in the Student Success Center. This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion. You are not required to submit this assignment to LopesWrite.

Topic 2 Participation Description: NA

T

Topic 3: Networks, Security, and Privacy

Description

Objectives: 1. Identify the risks of network, security, and privacy breaches in business systems and data. 2. Identify ethical and legal issues related to privacy and network and information security. 3. Explain measures businesses can take to maintain privacy and security within an organization.

S

Study Materials

GO! All in One: Computer Concepts and Applications Description: Read Chapter 4 in GO! All in One: Computer Concepts and Applications.

Audio PowerPoints to Accompany GO! All in One: Computer Concepts and Applications Description: View the audio PowerPoint presentations to accompany Chapter 4 in GO! All in One: Computer Concepts and Applications.Copyright 2017 by Pearson Education, Inc. Reprinted with permission of the publisher.

Security Description:

page 9 of 26

Explore the Security page of the Wired website for relevant articles.

Why Is Cybersecurity Important Description: Read “Why Is Cybersecurity Important?” by Tunggal (2020), located on the UpGuard website.

Study Shows Employees Steal Corporate Data and Don't Believe It's Wrong Description: Read "Study Shows Employees Steal Corporate Data and Don't Believe It's Wrong," located on the ITBUSINESSEDGE website

The Deep Web vs. the Dark Web: Do You Know the Difference Description: Read “The Deep Web vs. the Dark Web: Do You Know the Difference?” located on the Dictionary.com website.

How Can I Create an Outline in Word Easily Description: Read “How can I create an outline in Word easily?” by Carver (2018), located on the Maranatha Christian Academy website.

T

Tasks

Security Breach and Acceptable Use Policy Description: The purpose of this assignment is to identify the risks business organizations face when security is breached, the key components of an accep...