MVCC Workplace Computer Applications Syllabus
Instructor: Mrs. Smith
MOHAWK VALLEY COMMUNITY COLLEGE
UTICA AND ROME, NEW YORK
Center for Social Sciences, Business and Information Sciences
IS101 Computer Applications & Concepts 1 C-2, P-2, Cr-3
This course provides knowledge of relevant computer skills and a solid foundation in the terminology and concepts of computer technology. Experience is provided with a variety of microcomputer software applications, including word processing, electronic spreadsheets, graphics, file management, and integrated software. Concepts and terms focus on preparing for a technologically oriented society and using the computer as a tool for productivity, research and communication.
COURSE OUTCOMES (lecture):
The student demonstrates an understanding of:
1. How computers are used in business and society by:
a. Defining electronic commerce
b. Examining components business-to-business, business-to-consumer, and consumer-to-consumer e-commerce
c. Evaluate changes in consumer and societal behaviors dealing with shopping habits
d. Research methods to assist in preventing identity theft
2. The impact of technology on societies (e.g. Third World, United States, Korea, China) by:
a. Examining the cultural barriers and changes that result from the introduction of technology into the society
b. Analyzing effects of social networking
c. Evaluate social responsibilities dealing with such issues as cyber bullying, employer examination of employees’ web presence, etc.
d. Recognizing the impact of cyber terrorism
3. The evolution of computer technology by:
a. Examining the first development of binary language during the Renaissance (1600)
b. Examining the first use of computers in the military (WWI and WWII)
c. Discussing the progression of the use of computers from the military to business and then to personal use.
d. Identifying the development of the hardware components from vacuum tubes, to transistors to microchips
4. Basic software packages (ex: Word Processing, Data Base, Spreadsheets).
5. Basic hardware components (ex: RAM, ROM, Motherboard, Microprocessors).
6. Basic computer processes (ex: Input, Output).
7. Basic communication software (ex: E-mail, Web Browser, Search Tools).
8. Storage Fundamentals (ex: disks, CD’s, DVD).
9. Basic data organization and data base hierarchy.
10. Communication technology (networks).
COURSE OUTCOMES: (LAB)
The student demonstrates the ability to use:
1. Operating System (Windows 7).
2. File Management (saving files, create folders).
3. Word Processing (Microsoft Word) – create a document, edit a document, and format a document.
4. Spreadsheets (Microsoft Excel) – Organize data, write formulas, create basic charts.
5. Data Base (Microsoft Access) – Store data, create a database, run queries.
6. Presentation Software (Power Point) - Create a slide presentation.
· Basic Computer Concepts and Terminology
· Getting Started with Windows 7
· File Management & Student-Servers
· Computer Connectivity and Networks
· Getting Started with Internet Explorer
· Why Computers Matter to You
· Intro to Microsoft Office 2013
· Creating, Editing and Formatting a variety of documents in Word
· Application Software Variety and Functions
· Personal Computer Hardware
· Creating, formatting and effectively using spreadsheets and charts in Excel
· Role and Use of Systems Software
· Purpose and Use of Databases
· Creating basic database tables, forms, queries and reports in Access
· Understanding and Using the Internet
· Creating, Editing, Formatting and Presenting slides, handouts, notes and presentations in PowerPoint
· Adding and formatting images, tables and charts in Word, and PowerPoint
· Understanding Online Risks and Practices for Protecting Your Safety and Identity Online
· Recognizing the Impact of Computers on Society
· Review and Final Exam
My expectations for my students:
Be in class on time and attend class each day.
Conduct yourselves in a proper manner showing respect for fellow students and your teacher.
Do not talk when your teacher is talking or when other students have the floor. You will be recognized when you raise your hand to ask for help.
Be in your seats when the class bell rings.
Bring all needed materials to class and be prepared to work.
Participate in all classroom activities and projects.
Treat the classroom furniture and computer equipment with respect.
My Students Expectations for me:
Be kind & courteous
Treat us fairly.
Discipline: Classroom discipline problems will be handled as follows: Minor problems will be given a warning; if problems persist, a call will be made home. Problems that cannot be solved within the classroom will be referred to the principal.
Computer: Students will be required to use the computer at times during the course. Students are expected to follow the computer usage agreement. Students who should be working on an assignment but are using the Internet for personal reasons will receive a zero for that assignment.
Homework/Assignments: Assigned work and/or Homework is expected to be completed by its assigned due date. Late work will be reduced by 10% of points each day it is late. If turned in work is more than 5 days late, maximum credit of 50% will be awarded. If student knows of an anticipated delay, it must be communicated to the teacher before the assigned due date.
Grading: Students will be assessed on daily work which includes: workbooks, book work, homework, class activities, day-to-day assignments, quizzes, tests, portfolios, writing assignments, presentations, projects and hands-on activities. Work ethic includes: attitude, professionalism, initiative, cooperation and work quality. Participation grades are based on unexcused absences from the program and participation in classroom projects.
Grades will be calculated using the following point percentage system:
Business Management Pathway:
Participation/Attitude/Work Ethic (see Work Ethic Rubric)........ 20%
Knowledge & Hands-on activities.......... 80%
In order to be successful in this class, students must attend, complete assignments and study for tests. Assignments will not be accepted after the due date without penalty. Students will be given five school days to turn in late work due to an absence. In class assignments missed as a result of an absence may result in a ZERO. Students are expected to check for missed assignments resulting from an absence at an appropriate time. Failure to meet state attendance mandates may result in loss of credit regardless of grade. Students need to log in to the Business Math Google Classroom to see their assignments.
Cheating will result in a ZERO for all students involved. Cheating can take the form of talking to another student during a test, copying, pasting, and/or using other students’ work.
Students are responsible for proper saving and file management. Technical difficulties will not be accepted as an excuse for late work.
Computer Skills: Excel, Google Apps, Google Sites, Google Sheets. Word, Publisher. Google Docs, PowerPoint, etc.
Resources: Students please refer to our MVCC Workplace Computer Applications google site for additional instructional resources.
Worksheets & Handouts: Worksheets and handouts will be available to students through our MVCC Workplace Computer Applications Google Site.
Textbook: Go! Office 2013