Unit I Homework Assignment

Course Syllabus

Course Description

Explores computer literacy topics in a very basic, hands-on environment. Presents the fundamentals of computer hardware and software, the Internet, operating systems, and current application software within Microsoft Office Suite.

Course Textbook(s)

Parsons, J. J., & Oja, D. (2014). New perspectives on computer concepts 2014, comprehensive [VitalSource Bookshelf version] (17th ed.). Boston, MA: Course Technology. Retrieved from https://online.vitalsource.com/#/books/9781305177000

Course Learning Outcomes

Upon completion of this course, students should be able to:

1. Describe the relationship between digital basics and computer hardware. 2. Generalize the impact of software applications on computer software and hardware. 3. Explain the relationship between peripheral equipment, networks, the Internet, and intranets. 4. Apply the principles of basic Excel functions. 5. Examine the current electronic media sources to include the components that make the World Wide Web operate

with webmail. 6. Discuss the impact recent trends within the computer industry have on information systems. 7. Describe file and database concepts such as data management tools, database design, structured query language

(SQL), and database security.​ 8. Identify the computerized tools and practices utilized in today's business sector.

Prerequisite(s)

No prerequisite courses are required by CSU for enrollment in this course.

Credits

Upon completion of this course, the students will earn 3 hours of college credit.

Course Structure

1. Study Guide: Course units contain a Study Guide that provides students with the learning outcomes, unit lesson, required reading assignments, and supplemental resources.

2. Learning Outcomes: Each unit contains Learning Outcomes that specify the measurable skills and knowledge students should gain upon completion of the unit.

3. Unit Lesson: Unit Lessons, which are located in the Study Guide, discuss lesson material. 4. Reading Assignments: Units contain Reading Assignments from one or more chapters from the textbook and/or

outside resources. 5. Suggested Reading: Suggested Readings are listed within the Study Guide. Students are encouraged to read the

resources listed if the opportunity arises, but they will not be tested on their knowledge of the Suggested Readings. 6. Learning Activities (Non-Graded): Non-Graded Learning Activities are provided to aid students in their course of

study. 7. Discussion Boards: Discussion Boards are part of all CSU Term courses. More information and specifications can

CS 1010, Computer Essentials

CS 1010, Computer Essentials 1

be found in the Student Resources link listed in the Course Menu bar. 8. Unit Assignments: Students are required to submit for grading Unit Assignments. Specific information and

instructions regarding these assignments are provided below. Grading rubrics are included with each assignment. Specific information about accessing these rubrics is provided below.

9. Ask the Professor: This communication forum provides you with an opportunity to ask your professor general or course content related questions.

10. Student Break Room: This communication forum allows for casual conversation with your classmates.

CSU Online Library

The CSU Online Library is available to support your courses and programs. The online library includes databases, journals, e-books, and research guides. These resources are always accessible and can be reached through the library webpage. To access the library, log into the myCSU Student Portal, and click on “CSU Online Library.” You can also access the CSU Online Library from the “My Library” button on the course menu for each course in Blackboard.

The CSU Online Library offers several reference services. E-mail ([email protected]) and telephone (1.877.268.8046) assistance is available Monday – Thursday from 8 am to 5 pm and Friday from 8 am to 3 pm. The library’s chat reference service, Ask a Librarian, is available 24/7; look for the chat box on the online library page.

Librarians can help you develop your research plan or assist you in finding relevant, appropriate, and timely information. Reference requests can include customized keyword search strategies, links to articles, database help, and other services.

Unit Assignments

Unit I Homework

Complete the homework assignment in the attached template. Click here for a copy of the template. Be sure to show your work in the sections where this is required. Some of the binary/decimal problems were solved for you to help you get started with this assignment.

You can find information about converting decimals and binary numbers in the Unit I Study Guide for this week. There are also tables that illustrate the binary to decimal/decimal to binary conversion and a link to a decimal/binary converter in the lecture as well.

Save your finished template, and upload it in Bb.

Information about accessing the grading rubric for this assignment is provided below.

Unit II Homework

Complete the homework assignment in the attached template. Click here for a copy of the template. Save your finished template, and upload it in Blackboard.

Information about accessing the grading rubric for this assignment is provided below.

Unit III Homework

Complete the homework assignment in the attached template. Click here for a copy of the template. Save your finished template, and upload it in Blackboard.

Information about accessing the grading rubric for this assignment is provided below.

Unit IV Homework

Excel Assignment

Requirements: You will need Excel 2007, 2010, 2013, or 2016 to complete this project. You will also need the following file(s): 1010excel.xlsx.

Project Background: You have been hired by the Bahamas Cruise Line as an analyst. You will assist the cruise line staff in record-keeping, revenue generation, and overall efficiency. Your project will be broken down into the following three sections: Worksheet& Workbook Management, Formulas & Functions, and Charts & Subtotals.

Should you need additional help for adding numbers in Excel, using functions, formulas, subtotals, or charts, please watch the following video:

Rocks, D. (August 9, 2008). See the "big picture" with Excel's subtotal function [Video file]. Retrieved from https://www.youtube.com/watch?v=X5w5uWJDct8

Part 1: Worksheet & Workbook Management—Rename and organize the worksheets within the workbook, and re-save the workbook itself by following the instructions below:

CS 1010, Computer Essentials 2

1. Click here to access and open 1010excel.xlsx. 2. Save the 1010excel.xlsx file as your “student ID number_last name.xlsx” (ex: 12345_Jones.xlsx). 3. Rename Sheet 1 to Formulas&Functions. 4. Rename Sheet 2 to Chart. 5. Rename Sheet 3 to Subtotals. 6. Move the Chart worksheet to the right of the Subtotals worksheet. 7. Create a fourth worksheet using your student ID number as the name. 8. Save the file.

Part 2: Formulas & Functions—In this section, you will assist the sales manager in categorizing the company’s revenue sources and how each one relates to each other. You will use formulas and functions to create totals and/or averages of the revenue data following the instructions below. Make sure you are in the Formulas&Functions active worksheet before you begin:

1. In cell B2, create a function that totals Jan. through Dec. sales for Online Reservations. 2. In cell B3, create a function that totals Jan. through Dec. sales for Telephone Reservations. 3. In cell B4, create a function that totals Jan. through Dec. sales for Sales Calls. 4. In cell B5, create a function that totals Jan. through Dec. sales for Activity Companies. 5. In cell B7, create a formula that adds the annual totals of all four categories using cells B2, B3, B4, and B5, which will

give you the total annual revenue for the Bahamas Cruise Line. 6. In cell C2, create a function that displays the average for online reservations from Jan. through Dec. Repeat this for

the other three categories of revenue. 7. Save the file.

Part 3: Charts & Subtotals—Create a pie chart that compares each revenue source in the month of January, and use the subtotals feature in Excel to total three separate categories of revenue. Use the following instructions:

Make sure the Chart worksheet is active before you begin.

1. Create a pie chart using the range A1 to B5. 2. Slightly detach the sales calls piece of the pie from the rest of the pie chart. 3. Save the file.

Make sure the Subtotals worksheet is active before you begin.

1. Sort the list by category (Activities, Hotels, and Retail) and add a row underneath each category, titled “Subtotal.” 2. Use the sum function in Excel to display totals for the three categories on this worksheet. 3. Save the file and submit for grading.

Information about accessing the Grading Rubric for this assignment is provided below.

Unit V Lab Assignment

Follow the directions on page 414 of your textbook under lab assignments, and complete the following lab assignments. Do not try to open the labs by clicking on the icons in your e-book. Simply follow the directions in each assignment, and complete the assignments in a single document.

Browser Security & Privacy: Complete numbers two through four. Working with Cookies: Complete numbers two through four. Working with HTML: Complete numbers two through seven.

You have three lab assignments. You must show your work (such as making screenshots to show your instructor that you completed a certain step). Make sure you identify each lab and each step (e.g., step 2, 3, etc.). You must submit a title page with this lab assignment. Submit all your labs together in one document titled Lab Report.

Information about accessing the grading rubric for this assignment is provided below.

Unit VI PowerPoint Presentation

Read pages 546-547 in your textbook about how changes in information technology (IT) have transformed the travel planning industry. For this assignment, you will create a PowerPoint presentation at least eight slides in length (not counting the title and reference slides). Your PowerPoint presentation must address web-based travel services and their value to the customer. The question is, what is the value of these travel services? Choose any web-based travel service that you want. Include information about the following aspects of the industry in your presentation:

Identify how recent technology trends in IT and the computer industry have changed the travel planning industry. Describe the role of computer technology in the travel business and how this affects the travel industry becoming part of today’s global economy.

Your PowerPoint presentation must address all of the following:

The first slide must be a title slide that includes the title of the presentation, date, your name, and course name and number. The last slide must be a reference slide using APA formatting. You must include at least one graphic in this presentation. Use the speaker notes section to discuss your slide so that the reader may follow along. You must include at least one resource from the CSU Online Library and one other resource (which may be your textbook).

CS 1010, Computer Essentials 3

Be sure to include in-text citations to properly cite your sources.

Note: For assistance in creating a basic PowerPoint presentation, click here to access PowerPoint Zero to Hero, a YouTube video created by the CSU Success Center.

Click here for PowerPoint Best Practices, a CSU Success Center tutorial that will help you learn to build a presentation that is easy to view and understand and that is appropriate for an academic setting.

Information about accessing the grading rubric for this assignment is provided below.

Unit VII Scholarly Activity

Answer the following questions thoroughly, and submit in a document. Each answer must be at least 150 words in length. Cite your sources.

1. Describe seven database models, and give examples of each type. 2. Provide five examples of data you would store in a real, integer, text, logical, date, memo, and BLOB data field. 3. Using a real-world entity like a recipe file or collection of some sort that can be stored in a database, divide this

information into fields and record types. Explain the steps you need to take to normalize the data. 4. Explain in your own words the differences between sorting and indexing. 5. Imagine that you must access a library card catalog using SQL. Write an SQL query that you would use to search for

any books by J. J. Parsons in a table called Books, where author’s names are stored in a field called Title. 6. Explain the extent to which encryption, user privileges, and audits can secure a database.

All sources used, including the textbook, must be referenced; paraphrased and quoted material must have accompanying citations.

Information about accessing the grading rubric for this assignment is provided below.

Unit VIII Article Critique

Using the CSU Online Library, locate an article related to answering the following question: Why are computerized programming tools and secure programming a concern in the business environment?

Be sure that you examine programming tools and determine secure programming principles and/or development. Your article critique should consist of no less than three pages, and the article you choose should be no older than three years. In your article critique, you should do the following:

Write your critique in APA format. Begin with an introduction that defines the subject of your critique and your point of view. You will need to identify and explain the author’s ideas. Include specific passages that support your description of the author’s point of view. Defend your point of view by raising specific issues or aspects of the argument. Offer your own opinion. Explain what you think about the argument. Describe several points with which you agree or disagree. Explain how the passages support your opinion. Conclude your critique by summarizing your argument and re-emphasizing your opinion. For each of the points you mention, indicate specific passages from the text that provide evidence for your point of view.

Please be sure that any sources you paraphrase or quote are cited and referenced properly.

For help in writing your Article Critique, please view the following webinar from CSU’s Success Center:

https://www.youtube.com/watch?v=csGZ3R79584

The following presentation provides valuable tips for locating articles in the CSU Online Library and evaluating them for use in a paper:

https://columbiasouthern.adobeconnect.com/_a1174888831/librarywctutorial/

For individualized help with your research for this assignment, you may contact the CSU Library. Email and phone assistance are available during regular CSU business hours (8:00-5:00 Monday-Thursday and 8:00-3:00 Friday in the Central time zone) by calling 877.268.8046 or emailing [email protected]. Chat reference service is available 24/7, 365 days a year from the “Ask a Librarian” chat widget on the right side of the library webpage.

Information about accessing the grading rubric for this assignment is provided below.

APA Guidelines

The application of the APA writing style shall be practical, functional, and appropriate to each academic level, with the primary purpose being the documentation (citation) of sources. CSU requires that students use APA style for certain papers and projects. Students should always carefully read and follow assignment directions and review the associated grading rubric when available. Students can find CSU’s Citation Guide by clicking here. This document includes examples and sample papers and provides information on how to contact the CSU Success Center.

CS 1010, Computer Essentials 4

Grading Rubrics

This course utilizes analytic grading rubrics as tools for your professor in assigning grades for all learning activities. Each rubric serves as a guide that communicates the expectations of the learning activity and describes the criteria for each level of achievement. In addition, a rubric is a reference tool that lists evaluation criteria and can help you organize your efforts to meet the requirements of that learning activity. It is imperative for you to familiarize yourself with these rubrics because these are the primary tools your professor uses for assessing learning activities.

Rubric categories include: (1) Discussion Board, (2) Assessment (Written Response), and (3) Assignment. However, it is possible that not all of the listed rubric types will be used in a single course (e.g., some courses may not have Assessments).

The Discussion Board rubric can be found within Unit I’s Discussion Board submission instructions.

The Assessment (Written Response) rubric can be found embedded in a link within the directions for each Unit Assessment. However, these rubrics will only be used when written-response questions appear within the Assessment.

Each Assignment type (e.g., article critique, case study, research paper) will have its own rubric. The Assignment rubrics are built into Blackboard, allowing students to review them prior to beginning the Assignment and again once the Assignment has been scored. This rubric can be accessed via the Assignment link located within the unit where it is to be submitted. Students may also access the rubric through the course menu by selecting “Tools” and then “My Grades.”

Again, it is vitally important for you to become familiar with these rubrics because their application to your Discussion Boards, Assessments, and Assignments is the method by which your instructor assigns all grades.

Communication Forums

These are non-graded discussion forums that allow you to communicate with your professor and other students. Participation in these discussion forums is encouraged, but not required. You can access these forums with the buttons in the Course Menu.

Click here for instructions on how to subscribe/unsubscribe and post to the Communication Forums.

Ask the Professor

This communication forum provides you with an opportunity to ask your professor general or course content questions. Questions may focus on Blackboard locations of online course components, textbook or course content elaboration, additional guidance on assessment requirements, or general advice from other students.

Questions that are specific in nature, such as inquiries regarding assessment/assignment grades or personal accommodation requests, are NOT to be posted on this forum. If you have questions, comments, or concerns of a non- public nature, please feel free to e-mail your professor. Responses to your post will be addressed or e-mailed by the professor within 48 hours.

Before posting, please ensure that you have read all relevant course documentation, including the syllabus, assessment/assignment instructions, faculty feedback, and other important information.

Student Break Room

This communication forum allows for casual conversation with your classmates. Communication on this forum should always maintain a standard of appropriateness and respect for your fellow classmates. This forum should NOT be used to share assessment answers.

Schedule/Grading

The following pages contain a printable Course Schedule to assist you through this course. By following this schedule, you will be assured that you will complete the course within the time allotted.

Unit I Computer Basics [ Weight: 10% ]

Read/View: Unit I Study Guide Chapter 1: Computers and Digital Basics, pp. 3-41 Chapter 2: Computer Hardware, pp. 55-105, 117

Discuss: Unit I Discussion Board 2%

Submit: Unit I Homework 8%

CS 1010, Computer Essentials 5

Unit II Software/Hardware [ Weight: 13% ]

Read/View: Unit II Study Guide Chapter 3: Software, pp. 119-153, 162-169, 181 Chapter 4: Operating Systems and File Management, pp. 183-231, 243

Discuss: Unit II Discussion Board 2%

Submit: Unit II Homework 11%

Unit III LANs/Internet [ Weight: 10% ]

Read/View: Unit III Study Guide Chapter 5: Local Area Networks, pp. 246-273, 282-287 Chapter 6: The Internet, pp. 302-311, 321-353

Discuss: Unit III Discussion Board 2%

Submit: Unit III Homework 8%

Unit IV Excel Principles [ Weight: 13% ]

Read/View: Unit IV Study Guide Reading Assignments (3 articles)

Discuss: Unit IV Discussion Board 2%

Submit: Unit IV Homework 11%

Unit V Electronic Media and the World Wide Web [ Weight: 13% ]

Read/View: Unit V Study Guide Chapter 7: The Web and E-mail, pp. 359-414

Discuss: Unit V Discussion Board 2%

Submit: Unit V Lab Assignment 11%

Unit VI Recent Trend Impacts [ Weight: 14% ]

Read/View: Unit VI Study Guide Chapter 9: The Computer Industry: History, Careers, and Ethics, pp. 486-509, 542-543, 546-547

Discuss: Unit VI Discussion Board 2%

Submit: Unit VI PowerPoint Presentation 12%

CS 1010, Computer Essentials 6

Unit VII Database Concepts [ Weight: 14% ]

Read/View: Unit VII Study Guide Chapter 11: Databases, pp. 622-659

Discuss: Unit VII Discussion Board 2%

Submit: Unit VII Scholarly Activity 12%

Unit VIII Computerized Tools [ Weight: 13% ]

Read/View: Unit VIII Study Guide Chapter 12: Computer Programming, pp. 674-729

Discuss: Unit VIII Discussion Board 2%

Submit: Unit VIII Article Critique 11%

CS 1010, Computer Essentials 7