Face-to-Face = T/TH 1:00-2:50 am (16 wks)
Course Alignment
Relationship to academic programs and transfer
COSC 1513 was designed to meet specific student needs either individually or within a program and is designed to transfer to other colleges and universities. KCC participates in the Illinois Articulation Initiative (IAI), a statewide transfer agreement for general education purposes. All colleges and universities participating in the IAI agree to accept a collective “package” of IAI general education courses; transfer of courses separately is not guaranteed. For more information about IAI, go to their website at www.itransfer.org. For the transferability of courses to specific four-year institutions, go to www.itransfer.org and choose CAS (Course Applicability System).
Goals and Objectives
Upon completion of this course, you will be able to:
- Develop skills and knowledge in computer concepts, history and industry trends.
- Develop skills in file management, Windows, Internet & Email and Networking concepts and Office Applications – Word, Excel, PowerPoint, and Access.
- Be ready to embark on more advanced study in computer technology and applications.
- Students will learn to utilize PCs safely and securely minimizing their risk to online threats.
IAI902 - Goals and Objectives
A. Use an operating system to perform file management techniques.
B. Browse the Internet to evaluate web sites for credibility, install and use business communication software and apps (including email and computer conferencing), and research and manage data to communicate with others safely and securely.
C. Utilize word processing software to create, edit, and format business documents and perform mail merges.
D. Utilize spreadsheet software to create and edit formulas, functions, charts, pivot tables, and `what if` analysis to solve business problems.
E. Use database software to create and design tables, forms, queries (selecting and filtering features), and reports.
F. Use presentation software to create, design, and share presentations that include enhanced features and web tools.
Faculty Contact Information
L338
Sherly Avvaru
savvaru@kcc.edu
Course Information
At the end of this course, students will be able to:
- Develop skills and knowledge in computer concepts, history and industry trends
- Develop skills in file management, Windows, Internet and Email and Networking concepts and Office Applications – Word, Excel, PowerPoint, and Access.
- Be ready to embark on more advanced study in computer technology and applications
MyLabIT Online Access Code – buy from the KCC Bookstore to get access to either the E-text or print copy of the following two required course textbooks. Register with your access code in Canvas.
Go! Microsoft Office 365/2019 with Windows 10 Introductory. Pearson. ISBN-13: 978-0-13-541781-2
Technology in Action, 16th edition- Evans, Martin and Poatsy. Pearson. ISBN-13: 978-0-13-543519-9
A PC with Windows 10 and Microsoft Office 2019/365 is required for successfully working with the materials to complete this course. KCC provides a free install of Office 365 software.
Student evaluation is based on points accrued via Pearson MyLabIT virtual assignments and quizzes as well as instructor assigned chapter quizzes and exams. Point values may change based on added or removed assignments.
- Assignments – 40%
- Discussions – 20%
- Quizzes – 10%
- Exams – 20%
- Professionalism – 10%
Corresponding grading scale:
90-100% = A
80-89% = B
70-79% = C
60-69% = D
59% or lower = F
Business, Technology & Human Services
Dean, Paul Carlson; 815-802-8858; V105; pcarlson@kcc.edu; Division Office – W102; 815-802-8650
Attendance Policy – Virtual or Face-to-Face
Attendance is mandatory. If a class or lab session must be missed, arrangements must be made prior to the absence. If an absence is not planned, a valid excuse (i.e., doctor’s note, etc.) must be provided to the instructor for each missed session at the beginning of the following class session. Make-up work, including assignments, quizzes, exams, etc., is provided at the discretion of the instructor and must be completed within one week of the missed class period.
Readings
This course requires you to read the assigned reading from the instructor. Lectures will provide only an overview of the reading material. You are expected to come to class prepared for that day’s lecture.
Quizzes, Assignments, & Exams
Each of you possess different test taking abilities, strengths, and weaknesses. With this in mind, due diligence has been used in designing all quizzes, assignments, and exams so that they may contain a mixture of multiple choice, matching, short answer recall and essay. Quizzes are meant to assess your recall and retention of lecture, reading, and lab materials. Assignments will be administered as a follow up for select topics throughout the semester. Exams are designed to assess retention of lecture and reading materials, while also assessing your ability to compare /contrast and apply concepts. Additional information:
- Quizzes may be posted on Canvas.
- On face-to-face quiz and exam days, students must arrive on time and be ready to take the quiz or exam at the start of class.
- If a student enters the classroom late on a quiz day, he/she may take the quiz as long as at least one student is still in possession of the quiz. If all students have completed and turned in the quiz, he/she may not take the quiz.
- Students will not be permitted to enter the classroom and take the exam once the exam has started.
- Once an exam or quiz has been administered, a student will not be permitted to leave for any reason until he/she turns the exam in.
- If a student’s cell phone is disruptive during an exam or quiz, the student will receive a zero on that exam.
- If a student is found using their cell phone in any way during an exam or quiz, it will be considered to be a case of cheating and the student will receive a zero on the exam as well as the possibility of receiving an F for the course grade.
- Late assignments will not be accepted unless arrangements are made – see Attendance Policy.
Lab
Labs will be hands-on and reinforce the concepts and practices discussed during lecture. After or during each lab exercise you may be required to complete a lab worksheet. These worksheets will be due to the instructor when directed.
- Turn off all cell phones and all other items that may beep, buzz, or otherwise interrupt the instructor and other students. If you must have your cell phone on for work or a family emergency, set it to vibrate and leave the classroom if you receive a call.
- No texting during class.
- Failure to follow either of the above rules will result in a warning (first offense), 5 point deduction from your class grade (second offense), and removal from the class period (third and beyond offense).
- This is your course! You will gain the most from this course if you actively participate in classroom and lab discussions and share your experiences and questions.
- Learn the names of your classmates and help one another whenever possible (but not during quizzes and exams).
- This is your classroom! Take responsibility for the classroom and lab areas by picking up after yourself.
- Audio/video recording of class is not permitted unless pre-approved by the instructor
- Laptop usage is not allowed during class, unless otherwise stated by instructor.
- iPod usage or headphone devices of any kind are not allowed during class
- Arrive promptly before class begins.
- No tobacco products may be used on campus.
- Know and follow basic safety rules. Report any accidents, injuries, spills, or problems to the instructor immediately.
- Do not come to class when you are ill and likely to infect others.
- Minor children are not allowed in the classroom or lab areas for safety reasons.
- No students will be allowed to work in lab areas outside of class time without instructor permission and appropriate supervision.
Student Integrity
All students are expected to take quizzes, exams, write papers, and conduct themselves with integrity, common sense, and respect for their fellow students, the instructor, and the academic institution. Students should not jeopardize their own honesty or that of other students.
Cheating will not be tolerated. Upon evidence of student cheating, the student will be dropped from the course and receive a grade of F in the course.
| Dates | Topic | Readings | Assignment |
| Week 1 | Microsoft Word | GO! Word Chapters 1, 2, and 3 Learning Outcomes: -Create a new document and insert text and proofing documents. -Insert and format graphics. -Preview and print documents. -Create and format tables and multiple columns. -Utilize cover letters and letterhead. -Create envelopes and utilize mail merge. | IAI902 – Course Objectives: C Project 1A – Flyer and 1B – Information Handout Project 2A - Resume and 2B – Cover Letter and Envelope Project 3B – Newsletter with Optional Mailing Labels Lab: Microsoft Word Simulation |
| Week 2 | Technology in Action Chapter 1 – The Impact of Technology -Technology in Society -Emerging Technologies and Ethical Computing | Discussion: Ensure access to the Pearson MyLabIT assignments and Microsoft Office 365 apps, Word, Excel, PowerPoint, and Access Read Chapter 1 Learning Outcome 1.1: You will be able to discuss the impact of the tools of modern technology on national and global issues. Learning Outcome 1.2: You will be able to describe emerging technologies, such as artificial intelligence, and how technology creates new ethical debates. TECH TALKS will be assigned to each student in the course | Familiarize yourself with the Windows interface and starting and stopping applications. Learn how to navigate the Windows Explorer program to locate files within folders. Examine the Office 365 apps, various icons, where they are located, and how they are started. Complete all Module Virtual Assignments for week, due by next lecture: -Technology Impacts -Quiz -Check Your Understanding -Virtual Computer Tour Lab: Microsoft Word Simulation |
| Week 3 | Chapter 2 – Looking at Computers: Understanding the Parts -Understanding Digital Components -Processing, Storage, and Connectivity | Read Chapter 2 Learning Outcome 2.1: You will be able to describe the devices that make up a computer system. Learning Outcome 2.2: You will be able to describe how computers process and store data and how devices connect to a computer system.
| IAI902 – Course Objectives: A and B Discussion: Examine the different Windows devices/drives/libraries, and how they store data. Complete all Module Virtual Assignments for week, due by next lecture: -Check Your Understanding -Exploring Storage Devices and Ports -Understanding Bits and Bytes -Binary Numbers Interactive -Finding Information on the Web Lab: Microsoft Word Simulation |
| Week 4 | Chapter 3 – Using the Internet: Making the Most of the Web’s Resources AI Ethics Prompt Engineering Foundations | Read Chapter 3 Learning Outcome 3.1: You will be able to explain how the Internet works and how it is used for collaboration, communication, commerce, and entertainment purposes. Learning Outcome 3.2: You will be able to describe the tools and techniques required to navigate and search the web. Learning Outcome 3.3: Setting up an email client to send and receive email. Learning Outcome 3.4: Evaluating websites for credibility and bias. | IAI902 – Course Objectives: A and B Discussion: How do computers connect to the Internet and the various tools afforded to you. Quiz -Smartphones Are Really Smart -Doing Business Online -Evaluating Websites Lab: Microsoft Word Simulation Prompt Engineering: Practice prompting |
| Week 5 | Microsoft Excel | GO! Excel Chapter 1, 2, and 3 Learning Outcomes: -Create, save, and navigate a worksheet. -Enter and utilize formulas and functions. -Create charts and utilize chart data. -Use flash fill and built-in functions. -Utilize conditional formatting and perform what-if analysis. -Create, sort, format, and filter. -Create pivot tables. | IAI902 – Course Objectives: D Project 1A – Sales Report with Embedded Column Chart and Sparklines and 1B- Inventory Evaluation Project 2A – Inventory Status Report and 2B – Weekly Sales Summary Project 3A – Enterprise Fund Pie Chart Lab: Microsoft Excel Simulation |
| Week 6 | Chapter 4 – Application Software: Programs That Let You Work and Play -Accessing, Using, and Managing Software -Application Software | Read Chapter 4 Learning Outcome 4.1: You will be able to explain the ways to access and use software and describe how to best manage your software. Learning Outcome 4.2: Describe the different types of application software used for productivity and multimedia. Learning Outcome 4.3: Install, configure, and utilize Microsoft Office Applications. | IAI902 – Course Objectives: A, C, D, E, F Discussion: Discover the Office 365 Suite and discuss the uses of the different applications. Complete all Module Virtual Assignments for week, due by next lecture: -Check Your Understanding -Quiz -Choosing Software -Where Does Binary Show Up? Lab: Microsoft Excel Simulation |
| Week 7 | Chapter 5 – System Software: The Operating System, Utility Programs, and File Management -Understanding System Software -Using System Software | Read Chapter 5 Learning Outcome 5.1: You will be able to explain the types and functions of operating systems and explain the steps in the boot process. Learning Outcome 5.2: You will be able to describe how to use system software, including the user interface, file management capabilities, and utility programs. Learning Outcome 5.3: Understand and explain file management techniques with various storage mediums and locations. | IAI902 – Course Objectives: A, C, D, E, F Discussion: To utilize a computer effectively and safely you must learn how the computer operates and how information flows through it. -Choosing Software -Buying and Installing Software -Hard Disk Anatomy -Starting the Computer: The Boot Process -File Management -Using Windows Task Manager to Update System Performance - Organizing Your Computer: File Management Lab: Microsoft Excel Simulation |
| Week 8 | Chapter 6 – Understanding and Assessing Hardware: Evaluating Your System -Evaluating Key Subsystems -Evaluating Other Subsystems and Making a Decision AI Ethics Prompt Engineering Foundations | Read Chapter 6 Learning Outcome 6.1: You will be able to evaluate your computer system’s hardware functioning, including CPU and memory subsystems. Learning Outcome 6.2: You will be able to evaluate your computer system’s storage subsystem, media subsystem, and reliability and decide whether to purchase new system or upgrade an existing one. | IAI902 – Course Objectives: A, B Discussion: The limits of the computer. Complete all Module Virtual Assignments for week, due by next lecture: -Check Your Understanding -Quiz -Evaluating Your CPU and RAM -Evaluating Your Computer System Components -Installing RAM -Installing an SSD Drive Lab: Microsoft Excel Simulation Prompt Engineering: Persona Prompting |
| Week 9 | Microsoft PowerPoint | GO! PowerPoint Chapter 1, 2, and 3 Learning Outcomes: -Create, edit, and present, multimedia presentations. -Format and sort presentation slides. -Utilize transitioning and bulleted lists. -Insert boxes, shapes, and objects. -Insert online web multimedia. -Presentation and sharing options. | IAI902 – Course Objectives: F Project 1A – Company Overview Presentation and 1B – Itinerary Presentation Project 2A – Employee Training Presentation Project 3A – Parks and Trails Presentation Lab: Microsoft PowerPoint Simulation |
| Week 10 | Chapter 7 – Networking: Connecting Computing Devices -How Networks Function -Your Home Network | Read Chapter 7 Learning Outcome 7.1: You will be able to explain the basics of networking, including the components needed to create a network, and describe the different ways a network can connect to the Internet. Learning Outcome 7.2: You will be able to describe what is necessary to install and configure a home network and how to manage and secure a wireless network. Learning Outcome 7.3: You will be able to explain how network and Internet communications work. | IAI902 – Course Objectives: A, B Discussion: How computers connect to each other to share and receive information. -Understanding Networking -Quiz -Managing and Securing Your Wireless Network -Installing a Home Computer Network Lab: Microsoft PowerPoint Simulation |
| Week 11 | Chapter 9 – Securing Your System: Protecting Your Digital Data and Devices -Threats to Your Digital Assets -Protecting Your Digital Property AI Ethics Prompt Engineering Foundations | Read Chapter 9 Learning Outcome 9.1: You will be able to describe hackers, viruses, and other online annoyances and the threats they pose to your digital security. Learning Outcome 9.2: Describe various ways to protect your digital property and data from theft and corruption. | IAI902 – Course Objectives: B, E Discussion: What are the dangers with Office apps? Why is it important to know about digital threats and what to do to protect your data. -Understanding Firewalls -Threats to Your Digital Life -Protecting Your Computer -Managing Computer Security with Windows Tools Lab: Microsoft PowerPoint Simulation Prompt Engineering: Zero-shot prompting |
| Week 12 | Microsoft Access | GO! Access Chapter 1 and 2 Learning Outcomes: -Understand database design. -Create a database, table, and fields. -Insert, view, filter, and query data. -Create forms and reports. | IAI902 – Course Objectives: E Project 1A – Student Advising Database with Two Tables and 1B – Student Workshops Database Project 2A – Instructors and Courses Lab: Microsoft Access Simulation |
| Week 13 | Chapter 11 – Behind the Scenes: Database and Information Systems -Database Fundamentals -How Businesses Use Databases | Read Chapter 11 Learning Outcome 11.1: You will be able to explain the basics of databases, including most common types of databases and the functions and components of relational databases in particular. Learning Outcome 11.2: You will be able to explain how businesses use data warehouses, data marts, and data mining to manage data and how business information systems and business intelligence are used to make business decisions. Learning Outcome 11.3: You will be able to create a database with multiple tables and enter and extract information using built in tools with Microsoft Access. | IAI902 – Course Objectives: B, E Discussion: Databases are not just for contact information anymore. BIG DATA Complete all Module Virtual Assignments for week, due by next lecture: -Check Your Understanding -Creating and Querying an Access Database -How Businesses Use Databases -Using Databases -Analyzing Data with Microsoft Power BI Suite Lab: Microsoft Access Simulation |
| Week 14 | Chapter 12 – Behind the Scenes: Networking and Security in the Business World -Client/Server Networks and Topologies -Setting Up Business Networks | Read Chapter 12 Learning Outcome 12.1: You will be able to describe common types of client/server networks, servers found on them, and network topologies used to construct them. Learning Outcome 12.2: You will be able to describe transmission media, network operating system software, and network navigation devices and explain major threats to network security and how to mitigate them. | IAI902 – Course Objectives: A, B Discussion: Office apps in a business setting. How they are used to their greatest potential. Complete all Module Virtual Assignments for week, due by next lecture: -Check Your Understanding -Quiz -Transmission Media and Network Adaptors -Using Servers -A Day in the Life of a Network Technician -Using Servers -Network Topology and Navigation Devices Lab: Microsoft Access Simulation |
| Week 15 | Chapter 13 – Behind the Scenes: How the Internet Works -Inner Workings of the Internet -Coding and Communicating on the Internet AI Ethics Prompt Engineering Foundations | Read Chapter 13 Learning Outcome 13.1: You will be able to explain how the Internet is managed and the details of how data is transmitted across the Internet. Learning Outcome 13.2: You will be able to describe the web technologies used to develop web applications. Learning Outcome 13.3: You will be able to understand how to communicate to others using internet technologies such as messaging, and video conferencing applications. | IAI902 – Course Objectives: A, B Discussion: Bringing the world to collaborate together. -Keeping Email Secure -Understanding IP Addresses, Domain Names, and Protocols -Client-Side Web Page Development -Creating Web Pages with Squarespace Lab: Microsoft Access Simulation Prompt Engineering: One-Shot Prompting |
| Week 16 | Final Exam |
College Policies, Resources and Supports
For information related to the Student Code of Conduct Policy, Withdrawal Policy, Email Policy, and Non- Attendance/Non-Participation Policy, please review the college’s Code of Campus Affairs and Regulations webpage, which can be found at catalog.kcc.edu under the Academic Regulations & Conduct Guide.
KCC offers various academic and personal resources for all students. Many services are offered virtually, as well as in person. Please visit Student Resources - Kankakee Community College to access student resources services such as:
- Clubs and organizations
- Counseling and referral services
- Office of disability services
- Student complaint policy
- Transfer services
- Tutoring services, etc.
The materials on this course are only for the use of students enrolled in this course for purposes associated with this course. Further information regarding KCC's copyright policy is available at https://kcc.libguides.com/copyright.
|Course syllabus/calendar is subject to change.