Teacher: Mrs. Traci PraterLocation: Magoffin County Career & Technical CenterCourse SyllabusComputer LiteracyTeacher: Mrs. Traci PraterLocation: Magoffin County Career & Technical CenterLength: 1 yearPrerequisite: Word ProcessingKDE Course #: 110110CIP Code: 47.0104.00KCTCS Articulation Equivalent: CIT 105 (Introduction to Computers) ****Note: For students to receive credit for this course, they must pass all three sections of the IC3 Internet and Computing Core Certification (Computing Fundamentals, Key Applications, and Living On-line)Course Description:This course introduces students to the main components of computer literacy including Computer Fundamentals, Key Applications and Living Online. It provides an introduction to the computer and the convergence of technology as used in today’s global environment. The course is designed to introduce topics including computer hardware and software, file management, the Internet, e-mail, the social web, green computing, security and computer ethics. It presents basic use of application, programming, systems and utility software. Basic keyboarding skills are strongly recommended.Course Objectives:Upon completion of this course and based on the Program of Studies, students will be able to:1. Considering the Computer:a. Identify what a computer doesb. Provide a brief history of the computerc. Explain the different types of persona and multiuser computersd. Identify other computer devices such as handheld, mobile, and video gamesystemse. Identify proper ergonomics to improve comfort and safety of the end user2. Hardware:a. Identify the CPU, the parts of the system unit and the motherboardb. Briefly describe binary codec. Identify different storage devicesd. Highlight different input and output devices and their usese. Explain the different types of printersf. Describe communication devices and their purposeg. Explain the impact of computers upon society including effects of social technologies, green computing, dangers of excessive use, and disposal of obsolete equipmenth. Maintain computer equipment and solve common problems relating to computer hardware3. File Management:a. Use a graphical user interface-based operating system to manage files, folders and disksb. Create folders to organize filesc. Explain file extensions and file propertiesd. Review the importance of backing up files and how to do it within the operating systeme. Demonstrate how to compress filesf. Use search possibilities to locate filesg. Re-associate files to a different program4. Application and System Software:a. Use course management systemb. Utilize computer technology as a tool to access, manage, prepare and present informationc. Identify trends in information processing and new emerging technologiesd. Identify and analyze ethical issues such as copyright, privacy and security as related to computinge. Explain the difference between application, programming, systems and utility softwaref. Use application software packages to prepare basic documents, spreadsheets, databases and presentations.g. Identify different types of business and personal softwareh. Explain system requirements for installing and using softwarei. Explain licensing, freeware, shareware, open source and retail softwarej. Review different types of system softwarek. Manipulate text and format a document using word processing softwarel. Manipulate text and format a document using word processing softwarem. Create worksheets, use basic formulas and create graphs using spreadsheetsoftware5. Networking:a. Describe and explain basic data communications and network technologies and functionsb. Review the history of the Internetc. Explain how networks operate and how to connect to themd. Compare different web browserse. Identify different ways to navigate and search the webf. Review social networking sand its impact on today’s societyg. Review forums, discussion boards, blogs, podcasts, etc.h. Review e-commerce and social media marketingi. Identify and use basic e-mail and Internet functions and understand their capabilitiesj. Describe globalization and challenges including technological barriers, electronic payments and varying culturesk. Describe cloud computing and its impact on business and personal systems6. Online/Internet:a. Apply Internet etiquette and safetyb. Explain the differences between a web browser and a search enginec. Navigate a World Wide Web browserd. Identify Internet search engines and their advantages and disadvantagese. Demonstrate proficiency in the use of the Internetf. Discriminate between ethical and unethical use of computers and informationg. Demonstrate an understanding of copyrights and licensingh. Demonstrate an awareness of computer security and a basic understandingof ways to protect a computer (e.g. viruses, Trojans, and Malware)Nationally Recognized Certification Exam:- IC3 – Internet and Computing Core Certification (Must pass all three (3) parts)o Computer Fundamentalso Key Applicationso Living OnlineCourse Approach:Instructional methods of this course include lecture, discussion, group activities, independent research, field research projects, examinations, and presentations.Course Content:- Module 1 – Computing Fundamentalso Lesson 1 – Computers & Computer Systemso Lesson 2 – Input, Output, and Processingo Lesson 3 – Computer Protectiono Lesson 4 – Computer Maintenanceo Lesson 5 – Computer-Related Issueso Lesson 6 – Software & Hardware Interactiono Lesson 7 – Software Fundamentalso Lesson 8 – Operating Systemso Lesson 9 – Windows Managemento Lesson 10 – Operating System Customization- Module 2 – Key Applicationso Lesson 11 – Exploring MS Office 2010o Lesson 12 – Getting Started with Word Essentialso Lesson 13 – Editing & Formatting Documentso Lesson 14 – Sharing Documentso Lesson 15 – Working with Tableso Lesson 16 – Enhancing Documentso Lesson 17 – Working with Graphicso Lesson 18 – Getting Started with Excel Essentialso Lesson 19 – Organizing and Enhancing Worksheetso Lesson 20 – Creating Formulas & Charting Datao Lesson 21 – Getting Started with PowerPoint Essentialso Lesson 22 – Enhancing Presentations with Multimedia Effectso Lesson 23 – Getting Started with Access Essentialso Lesson 24 – Managing & Reporting Database Information- Module 3 – Living Onlineo Lesson 25 – Network Fundamentalso Lesson 26 – Communication Serviceso Lesson 27 – Communications & Collaborationo Lesson 28 –