2011—9:30 TR
Madisonville Community College—North Campus
2000 College Drive; Madisonville, KY 42431 /
Course
Description / Instructs in use of microcomputer and current word processing, database, and spreadsheet software. Includes thesaurus and spell checker. Includes requirements, capabilities, limitations, and applications of these software packages.
2011 Fall Semester CIS 130—Microcomputer Applicationa
: Page 1 of 3 :
2011 Fall Semester CIS 130—Microcomputer Applicationa
: Page 1 of 3 :
Instructor / Ms. Clarissa R. HillJohn H. Gray Building 230, Office #266
(270) 824-8620
Prerequisite / CIS 100
Classroom / BBC 142
Classroom
Materials / : Exploring Microsoft Office 2010 Volume2*
: Myitlab access code*
: Storage device(s)
*These items are bundled and sold through the Madisonville Community College Bookstore
Course
Topics / : Advanced Microsoft® Word 2010
: Advanced Microsoft® Excel 2010
: Advanced Microsoft® Access 2010
: Advanced Microsoft® PowerPoint 2010
Evaluation
Weights / 20% Exams
30% Quizzes (drop one)
50% Exercises (drop one)
Drop/Add
Policy
/ August 17, 2011 Last day for a registered student to enter an organized class—faculty approval is required
August 19, 2011 Last day to officially withdraw from this course with no grade.
August 20—October 17, 2011 A student officially withdrawing will receive a “W.”
October 18—December 2, 2011 A student officially withdrawing will receive a “W” if the student’s current class grade point average at the time of request is 60% or greater. If current class grade point average is less than 60%, withdrawal with a “W” will be denied.
Instructor
Office Hrs*
/ Monday 9:30 a.m.—12:00 p.m. CST
Tuesday 11:00 a.m.—12:00 p.m. CST
Wednesday 9:30 a.m.—12:00 p.m. CST
Thursday 11:00 a.m.—12:00 p.m. CST
Friday 8:00 a.m. – 12:00 p.m. CST
*Excluding Holidays
Student Code of Conduct
/ Please refer to the KCTCS Student Code of Conduct for a description of student rights, student offenses, and the appeals process for infringement of those rights. The KCTCS Student Code of Conduct may be found at the following website:
http://www.kctcs.edu/en/Students/Admissions/Academic_Policies/Code_of_Student_Conduct.aspx
Attendance, Late Work, & Make-up Policies
/ 1. Regular attendance and punctuality are expected for successful completion of this course.
2. Hands-On Exercises (textbook) must be submitted within the designated time frame and will never be accepted late. Each submitted Hands-On Exercise from the textbook will earn points toward a cumulative exercise grade to be awarded at the end of each unit (i.e. Word, Excel, etc)
3. Hands-On & Grader Projects (Myitlab) must be completed within the designated time frame and will never be accepted late. Hands-On Exercises may be completed three times and Grader Projects may be completed twice to earn the desired grade.
4. Practice Exercises (textbook) must be submitted within the designated time frame and will never be accepted late. Exercises submitted within the designated time frame may be resubmitted for a better grade according to the resubmit policy in the “Evaluation Clarification” section of this syllabus.
5. Quizzes must be taken within the designated time frame. Quizzes not taken at that time will receive a grade of “0.”
6. Exams must be taken within the designated time frame. Exams not taken at that time will receive a grade of “0.”
7. One 24-hour extension may be requested for one exercise or one quiz. The “Extension Coupon” and its restrictions can be found at the end of the syllabus and in your Blackboard account under the “Assignments” button.
Academic Honesty / “Plagiarism also includes the practice of employing or allowing another person to alter or revise the work that a student submits as the student’s own. Students may discuss assignments among themselves or with an instructor or tutor, but when the actual material is completed, it must be done by the student and the student alone. The use of the term ‘material’ refers to work in any form including written, oral, and electronic.” Any student who is determined by the instructor to have plagiarized any activity, quiz, or exam will be subject to the penalties as detailed in the “Student Code of Conduct.”
Classroom Etiquette
/ 1. Finish all food and drinks before entering the classroom. Accidental spills can result in equipment damage for which you could be responsible.
2. Maintain punctuality and attendance. Failure to do so will result in missed points and loss of valuable information.
3. Once class begins, please refrain from using the computer for purposes other than those being demonstrated in class. Failure to do so may result in your dismissal from class on that day.
4. Always remove your storage device from the computer at the completion of class. Failure to do so may result in the loss of points or the inability to resubmit summative evaluated lab activities.
5. Maintain a professional attitude in class and continue to show respect for your peers and instructors.
6. Please feel free to offer assistance to peers during hands-on activities when the instructor is busy with another student. Teamwork benefits all of those involved.
Course
Competencies / 1. Use a word processing program to create, save, print, and modify documents including, but not limited to, several font styles and colors, text with borders, tables, images, sections, custom margins, custom tab settings, bullets, headers, footers, dropped capital letters, text art, and columns
2. Use a word processing program to create, save, print and modify form letters and mailing labels
3. Use a word processing program to address and print envelopes
4. Use a word processing program to maintain a collection of records that can be used for mailing labels
5. Use the macro language of a word processing program to automate repetitive tasks
6. Use an electronic spreadsheet to create, maintain, and derive worksheets from templates
7. Use an electronic spreadsheet to create and use multiple-page spreadsheets including, but not limited to, 3-D formulas and consolidation techniques
8. Use an electronic spreadsheet to enhance the appearance of spreadsheets by adding text art, charts, clip art, headers, footers, predefined formats, etc.
9. Use an electronic spreadsheet’s macro language to automate repetitive tasks
10. Use absolute and relative references in formulas and functions
11. Use basic financial functions including, but not limited to, future value, present value, amortization schedules, and compound interest
12. Use a database program to customize the user interface by designing custom reports, custom forms, and custom queries
13. Use a database program to create multi-table relational databases including, but not limited to, databases containing two or more related tables, fields containing OLE objects, fields containing URL’s, and databases containing customized user interface
14. Use the database program’s macro language to automate repetitive tasks
15. Use a query language to perform queries including, but not limited to, queries involving two or more related tables, update queries, delete queries, queries involving conditions that contain two or more logical operators, and queries containing calculated fields
16. Create and use forms with sub-forms
17. Use presentation software to create, maintain, and display presentations of varying degrees of complexity
General Education
Competencies / : Communicate Effectively:
§ Read and listen with comprehension: Construct comprehensive Word, Excel and Access projects after reading the text and hearing the presented course content.
§ Speak and write clearly using standard English: Originate a mail merge letter using appropriate and correct English grammar to address a presented scenario. Demonstrate information processing through basic computer skills: Research articles on current technology and then compose article summarizes utilizing newly acquired computer skills demonstrated in class.
: Think Critically:
§ Make connections in learning across the disciplines and draw logical conclusions: Apply newly developed technical skills acquired when constructing research papers, resumes, graphs and other documents for other courses.
§ Demonstrate problem solving through interpreting, analyzing, summarizing, and/or integrating a variety of materials: Problem-solve and choose the best method to construct comprehensive projects to achieve accurate and desired outcome.
§ Use mathematics to organize, analyze, and synthesize data to solve a problem: Construct Excel worksheets that compare and analyze data for decision-making evaluating amortization information.
: Learn Independently:
§ Use appropriate search strategies and resources to find, evaluate, and use information: Utilize internal Microsoft Online Help feature to locate necessary steps to complete unlearned tasks.
§ Make choices based upon awareness of ethics and differing perspectives/ideas: Demonstrate an awareness of ethical considerations in making value choices by discussing issues related to professional ethics in the technology field.
§ Apply learning in academic, personal, and public situations: Apply all acquired skills when constructing required materials for other classes, for self, or in employment situations.
: Examine Relationships in Diverse and Complex Environments:
§ Recognize the relationship of the individual to human heritage and culture: Discuss the evolution of computer technology and email “netiquette.”
§ Demonstrate an awareness of the relationship of the individual to the biological and physical environment: Develop a PowerPoint presentation focusing on “Healthy Living.”
§ Develop an awareness of self as an individual member of a multicultural global community: Utilize PowerPoint to design and publish a flyer announcing Martin Luther King, Jr. Commemoration.
Evaluation of Writing
/ “Instructors in all courses are expected to call attention to proper English usage and may penalize for errors and/or require the rewriting of papers which do not meet acceptable standards in English.
Any instructor who finds the written work of any student seriously defective in English may recommend remedial work or refer the student for additional assistance from local resources.”
Faculty Senate Rules Section V, 2.33
Inclement Weather
/ Madisonville Community College’s standard procedure during inclement weather is to remain open and hold classes as scheduled. Campus closures are rare; however, should the weather become severe enough to warrant closing the campus, we will contact local media as well as relay the information using SNAP to your phone, email, or text message. Please watch for a SNAP announcement and/or the local news or listen to local radio for the latest information. As always, use your own judgment when determining whether or not it is safe to travel in your area.
For more information or to sign up for SNAP, visit http://legacy.kctcs.edu/snap/.
Student Safety Information / Madisonville Community College is concerned with the safety of the students attending classes at any of the four campuses. The following points are for your benefit as a student.
· In case any life threatening event, call 911. The local emergency responders are better equipped to take care of these situations.
· To sign up for the Safety Notification Alert Process (SNAP) go to the MCC webpage and click on the SNAP section. After completing this, you will receive notifications on school closings, inclement weather, and other safety notifications.
· To report a safety concern, call the MCC Tip Line at 824-1900 to report safety concerns or suspicious behavior. This line is monitored once a day Monday through Friday.
· There is a Maintenance #836-5330 for students on the North campus for use after the switchboard closes at 4:30. This is a cell phone that is answered by one of the Maintenance & Operations personnel.
· The MCC emergency number is answered by selected personnel during the day and by a cell phone when these are not available. 824-1911
If you have a documented disability and need any type of accommodation, you are required to register with the Disability Resource Coordinator. Contact Valerie Wolfe, Disability Resource Coordinator, Room JHG 139 (270) 824-1708.
Tutoring Services
/ Tutoring services for most academic areas are available through the Learning Lab located in the JHG, Room 306.
For appointments, call 824-1718.
For computer-specific tutoring, ask for
Jeri Page
2011 Fall Semester CIS 130—Microcomputer Applications
: Page 6 of 6 :
Tentative Weekly Course OutlineDay / Topics / Evaluation
Week 1 / Course Introduction and Account Setup/Orientation
Microsoft Word: Chapter 5 (1-12) / Hands-On Exercises (TB)
§ Desktop Publishing
Week 2 / Microsoft Word: Chapter 5 (13-48) / Hands-On Exercises (TB)
Hands-On Exercises (Myitlab)
Practice Exercises #1, #2 (TB)
Grader Project (Myitlab)
Quiz—Word Chapter 5
§ Decorative Text and Drawing Tools / § Object Linking and Embedding
Week 3 / Microsoft Word: Chapter 6 (49-93) / Hands-On Exercises (TB)
Hands-On Exercises (Myitlab)
Practice Exercises #1(TB)
Grader Project (Myitlab)
Quiz—Word Chapter 6
§ Document Templates
§ Multiple Documents / § Document Themes
Week 4 / Microsoft Word: Chapter 7 (95-144) / Hands-On Exercises (TB)
Hands-On Exercises (Myitlab)
Practice Exercises #1, #2 (TB)
Grader Project (Myitlab)
Quiz—Word Chapter 7
§ Forms
§ Introduction to Macros / § Document Protection and Authentication
Week 5 / Microsoft Word: Chapter 4 (Supplemental) / Hands-On Exercises (Myitlab)
Exam—Word Chapters 5-7
§ Mail Merge
Week 6 / Microsoft Excel: Chapter 5 (191-244) / Hands-On Exercises (TB)
Hands-On Exercises (Myitlab)
Practice Exercises #2 (TB)
Grader Project (Myitlab)
Quiz—Excel Chapter 5
§ Outlines and Subtotals
§ PivotTable Basics / § PivotTable Options
§ PivotTable Design and PivotCharts
Week 7 / Microsoft Excel: Chapter 7 (289-346) / Hands-On Exercises (TB)
Hands-On Exercises (Myitlab)
Practice Exercises #3 (TB)
Grader Project (Myitlab)
Quiz—Excel Chapter 7
§ Math and Statistical Functions
§ Logical and Lookup Functions / § Database Filtering and Functions
§ Financial Functions
Week 8 / Microsoft Excel: Chapter 8 (347-390) / Hands-On Exercises (TB)
Hands-On Exercises (Myitlab)
Practice Exercises #1(TB)
Grader Project (Myitlab)
Quiz—Excel Chapter 8
§ Multiple Worksheets
§ 3-D Formulas and Linked Workbooks / § Formula Audits and Data Validation
Week 9 / Microsoft Excel: Chapter 11 (485-533) / Hands-On Exercises (TB)
Hands-On Exercises (Myitlab)
Practice Exercises #1, #2 (TB)
Grader Project (Myitlab)
Quiz—Excel Chapter 11
§ Templates, Themes, and Styles
§ Custom Templates and Workbook Protection / § Macros
Week 10 / Microsoft Access: Chapter 6 (589-606) / Exam—Excel Chapters 5, 7-8, 11
Hands-On Exercises (TB)
§ Data Validation in Tables
§
Week 11 / Microsoft Access: Chapter 6 (607-642) / Hands-On Exercises (TB)
Hands-On Exercises (Myitlab)
Practice Exercises #1, #2
Grader Project (Myitlab)
Quiz—Access Chapter 6
§ Data Validation in Forms and Data Macros / § Data Validation with Queries and Reports
Week 12 / Microsoft Access: Chapter 7 (643-694) / Hands-On Exercises (TB)
Hands-On Exercises (Myitlab)
Practice Exercises #1, #2 (TB)
Grader Project (Myitlab)
Quiz—Access Chapter 7
§ Action Queries / § Queries for Special Conditions
Week 13 / Microsoft Access: Chapter 9 (763-812) / Hands-On Exercises (TB)
Hands-On Exercises (Myitlab)
Grader Project (Myitlab)
Quiz—Access Chapter 9
§ Normalizing Database Tables
§ Using the Built-In Analysis and Design Tools / § Safeguarding Your Database Application
Week 14 / Microsoft Access: Chapter 10 (813-836) / Hands-On Exercises (TB)
Hands-On Exercises (Myitlab)
Practice Exercise #1 (TB)
Quiz—Access Chapter 10
§ Working with Macros / § Working with Data Macros
Week 15 / Microsoft PowerPoint: Chapter 5 (861-916) / Exam-Access Chapters 6-7, 9-10
Hands-On Exercises (TB)
Hands-On Exercises (Myitlab)
§ Text-Based Charts
§ Table Design / § Statistical Charts and Graphs
§ Chart Modification
Week 15 / Microsoft PowerPoint: Chapter 6 (917-960) / Hands-On Exercises (TB)
Hands-On Exercises (Myitlab)
§ Hyperlinks and Action Buttons / § Advanced Animation
Week 16 / Thursday, December 8, 2011 / Exam-PowerPoint Chapters 5-6
Note: In addition to this detailed outline, a list of daily activities and topics covered in class will be posted in your Blackboard account, so check that account daily. Class convenes and continues even when you are absent J