Idea Transcript
10/15/2015
www.curricunet.com/mdc/reports/Competencies.cfm?courses_id=39658
CGS1060C INTRODUCTION TO COMPUTER TECHNOLOGY & APPLICATIONS CGS1060C INTRODUCTION TO COMPUTER TECHNOLOGY & APPLICATIONS Course Description: This course provides the skills required for personal, academic and professional success. Students will learn essential computer concepts, skills and how to utilize popular applications. The course satisfies the College’s computer competency requirement. ( 3 hr. lecture 2 hr. lab )
Course Competency
Learning Outcomes
Competency 1: The student will demonstrate general knowledge of computer concepts by:
4. Information Literacy 8. Computer / Technology Usage
1. Explaining and identifying the four basic computing functions of the information processing cycle (input, process, output, and storage). 2. Comparing different types of computers (e.g., desktop, laptop, tablet, smartphones, embedded computers, mainframe, supercomputers, etc.) and the hardware components of a personal computer. 3. Demonstrating the proper use and handling of portable datastorage devices. 4. Explaining the proper use of cloud storage. 5. Distinguishing between a computer operating system and application software. 6. Comparing common types of computer application software (e.g., word processing, spreadsheets, databases, webbrowsing, and email) and their uses. 7. Identifying the components of a network and various topologies. Competency 2: The student will demonstrate proficiency using the Internet by:
4. Information Literacy 8. Computer / Technology Usage
1. Distinguishing between an email address and an Internet Uniform Resource Locator (URL). 2. Defining the elements of a URL and their functions. 3. Defining the elements of the Domain Name System (DNS) hierarchy. 4. Using a URL and a web browser to navigate to a specific website. 5. Formulating strategies to locate, evaluate, and apply online information. 6. Using an Internet search engine to find a website on a specific topic. 7. Using the MDC Bibliographic search engine to find books, eBooks, videos, and journal articles on a specific topic. 8. Organizing and saving a URL as a favorite or bookmark for later reference. 9. Managing browsing history (Internet temporary files, cookies, and passwords). 10. Saving a web page as a web archive file. 11. Using private browsing to protect personal information. 12. Configuring a web browser (e.g., compatibility view, certificates, trusted sites, privacy, popup blockers, etc.). Competency 3: The student will demonstrate knowledge of a personal computer operating system by: 1. Defining and describing the components of a typical operating system interface. 2. Identifying the components of an interface window. 3. Maximizing, minimizing, restoring, moving, and resizing windows. 4. Creating, naming, renaming, copying, moving, and deleting files. 5. Creating, naming, renaming, copying, moving, and deleting folders and subfolders. 6. Navigating through folders and subfolders to retrieve saved files. 7. Formatting an external storage device (e.g., USB, hard drive). 8. Using File Explorer to http://www.curricunet.com/mdc/reports/Competencies.cfm?courses_id=39658
4. Information Literacy 8. Computer / Technology Usage
1/4
10/15/2015
www.curricunet.com/mdc/reports/Competencies.cfm?courses_id=39658
download, compress, extract, and locate files and folders. 9. Opening and closing an application. 10 .Managing and recovering from application errors. 11. Using the Help system.
Competency 4: The student will demonstrate knowledge of the ethical use of computers by:
4. Information Literacy 7. Ethical Issues 8. Computer / Technology Usage
1. Identifying the ethical use of information as it affects privacy, accuracy, intellectual property, and accessibility. 2. Distinguishing between appropriate and inappropriate use of technology in an academic setting regarding plagiarism (such as in Internet research). 3. Discussing what constitutes intellectual property rights infringement. 4. Distinguishing between appropriate and inappropriate use of technology in a professional business setting. 5. Distinguishing between legal and illegal filesharing practices on a network such as the Internet. Competency 5: The student will demonstrate an understanding of basic computer security and privacy by:
4. Information Literacy 8. Computer / Technology Usage
1. Explaining safe computing practices. 2. Identifying the sources of computer viruses (e.g., email attachments, loading a file from a disk, file sharing, etc.). 3. Discussing the most common threats to computer security (e.g., viruses, worms, spyware, spam, phishing, identity theft, etc.). 4. Describing practices to safe guard against email phishing and identity theft. 5. Discussing how firewalls, virus scanners, passwords, and other practices act to safeguard a computer from security threats. 6. Distinguishing between appropriate and inappropriate social media postings and information sharing. Competency 6: The student will demonstrate proficiency using electronic email by:
1. Communication 8. Computer / Technology Usage
1. Identifying the standard form of an email address. 2. Creating, sending, and forwarding an email message with and without a file attachment. 3. Responding to an email using reply and reply all techniques. Competency 7: The student will demonstrate proficiency in using social media by:
7. Ethical Issues 8. Computer / Technology Usage
1. Describing how social media helps individuals and businesses interact, collaborate, share information, and build relationships. 2. Selecting social networking sites used for personal versus professional purposes. 3. Identifying privacy concerns associated with social networking. 4. Differentiating between the terms blog and blogger. 5. Explaining why microblogging services such as Twitter are popular and important tools for the quick dissemination of information. 6. Describing the purpose of social news sites such as Reddit. 7. Identifying terms associated with popular content or trends such as hashtag, viral, and meme. 8. Describing video streaming and video sharing, including the difference between premium/paid content and free (or adsupported) content. 9. Describing music streaming, purchasing, and downloading, including the difference between premium/paid streaming and adsupported streaming. Competency 8: The student will demonstrate the ability to use programming concepts by:
3. Critical thinking 8. Computer / Technology Usage
1. Constructing a set of statements to be acted out to accomplish a simple task. 2. Describing http://www.curricunet.com/mdc/reports/Competencies.cfm?courses_id=39658
2/4
10/15/2015
www.curricunet.com/mdc/reports/Competencies.cfm?courses_id=39658
and analyzing a sequence of instructions. 3. Defining an algorithm. 4. Performing the basic steps in algorithmic problem solving. 5. Participating in a coding experience (e.g., Hour of Code). Competency 9: The student will demonstrate knowledge of word processing software by:
1. Communication 8. Computer / Technology Usage
1. Creating, editing, and printing a document utilizing multiple formatting features and functions of the software, including: a. Creating a document and inserting text. b. Inserting and formatting graphics and online video. c. Inserting, formatting, and converting text to a SmartArt graphic. d. Inserting and modifying text boxes and shapes. e. Formatting and changing the layout of paragraphs and documents. f. Inserting page and paragraph borders. g. Creating and modifying lists. h. Setting and modifying tab stops. i. Inserting and modifying headers and footers in a document. j. Creating, adding, and formatting text in a table. k. Using proofing options for a document. 2. Creating a new document from an existing document. 3. Creating a document using a template. 4. Creating a research paper (e.g., MLA, APA, etc.). a. Inserting footnotes in a research paper. b. Inserting citations and a bibliography in a research paper. 5. Creating and formatting a multiplecolumn newsletter. 6. Using special characters in a document. 7. Saving a document in multiple formats (e.g., pdf, html, etc.). 8. Creating mailing labels using Mail Merge. 9. Using the Help system. Competency 10: The student will demonstrate knowledge of spreadsheet software and its uses 2. Numbers / Data by: 8. Computer / Technology Usage 1. Creating, editing, saving, and printing multiple worksheets in a workbook utilizing various formatting features and functions of the software, including: a. Creating, saving, navigating, and renaming worksheets. b. Inserting, copying, cutting, and pasting data into a worksheet using the paste options gallery. c. Grouping worksheets to format and edit multiple worksheets at the same time. d. Constructing and copying formulas for mathematical operations (+, , *, /). e. Moving data and resolving error messages. f. Defining and constructing functions (e.g., Sum, Average, Median, Count, CountIF, Min, and Max). g. Constructing and copying logical IF functions. h. Formatting cells with Merge & Center, cell styles, rotating text, and themes. i. Applying conditional formatting. j. Displaying and printing formulas in a worksheet. k. Using proofing options for a worksheet. l. Entering data by range. m. Using Flash Fill to enter data or separate data into multiple columns. n. Using Clear Contents and Clear Formats for editing a cell. o. Using Date & Time functions and Freeze Panes. 2. Creating summary worksheets with linking formulas. 3. Using Goal Seek to perform whatifanalysis. 4. Charting data to create bar, column, line, and pie charts. 5. Formatting bar, column, line, and pie charts and inserting sparklines. 6. Converting data. a. Converting a range to a table. b. Creating sort and filters in a table. 7. Using the Help system. Competency 11: The student will demonstrate knowledge of database software and its uses by:
3. Critical thinking 8. Computer / Technology Usage
1. Discussing how databases are used in daily transactions. 2. Defining the capabilities and uses of a relational database management system. 3. Defining good database design using referential integrity concepts. 4. Identifying the four objects of a database (table, query, form, and report). 5. Creating a database from a template. 6. Creating and modifying tables, queries, forms, and reports using various methods (e.g., tools, wizards, layout, and design views). a. Implementing a second table and changing the structure of tables. b. http://www.curricunet.com/mdc/reports/Competencies.cfm?courses_id=39658
3/4
10/15/2015
www.curricunet.com/mdc/reports/Competencies.cfm?courses_id=39658
Creating and identifying relationships between tables. c. Entering data into tables. d. Sorting records in a table. e. Importing external data. 7. Creating and using a form to add and delete records. 8. Using the filter by form feature to filter records in a table. 9. Creating a query using multiple tables, including: a. Creating a new query using an existing query. b. Sorting, specifying text, numeric, wildcards, and compound criteria, and using wildcards in a query. c. Creating calculated fields in a query. d. Calculating statistics and group data in a query. e. Creating a crosstab query. f. Creating a parameter query. 10. Creating and modifying a report to include grouping and sorting of data and adding functions (e.g., Sum, Average, Median, Count, Min, and Max). 11. Printing a report and keeping grouped data together in a printed report. 12. Using the Help system. Competency 12: The student will demonstrate the ability to create presentations using presentation software by:
1. Communication 8. Computer / Technology Usage
1. Selecting a design theme and applying it to a presentation. 2. Creating, editing, saving, and printing a presentation utilizing multiple formatting features and functions of the software, including: a. Adding text, pictures, objects, and multimedia elements to a slide. b. Formatting numbered and bulleted lists. c. Converting text to SmartArt and SmartArt to text. d. Customizing slide backgrounds and themes. e. Creating and modifying tables and charts. f. Aligning objects on slides. g. Inserting, deleting, copying, and moving slides. h. Formatting and editing a presentation using the outline view and the slides pane view. i. Creating headers and footers. 3. Applying animations and transitions to slides. 4. Switching views. 5. Delivering a presentation in Slide Show view. 6. Printing presentations, slides, and notes. 7. Using the Help system.
http://www.curricunet.com/mdc/reports/Competencies.cfm?courses_id=39658
4/4