DUAL CREDIT COMPUTER APPLICATIONS CS119 MISSOURI VALLEY

Course Rationale: Non-technical introductory courses for the general student to have a "hands-on" experience with the personal computer. Students will learn keyboarding and mouse operation skills as well as the basic commands of Windows XP, and how to perform word processing, spreadsheet, presentation, and data base operations using MICROSOFT OFFICE 2010 and iWorks 09.

Download Syllabus PDF

STUDENT LEARNING OUTCOMES
This course builds on the student’s knowledge and understanding through the introduction of computer usage. The basic programs of a software suite are used to provide the foundation for education and business. The student will acquire knowledge and understanding that will be useful throughout their student and work careers. There are no prerequisites for this class, however, it is important for the student to begin to think and apply their analytical skills and learn on their own. This is a “hands-on” course in learning the personal computer on one of the popular application suites. The student can enhance their learning experience by using and learning additional suites.

Helpful Links: SAM 2010 Log-In

ASSESSMENT OF STUDENT LEARNING OUTCOMES
At the conclusion of this course, the student will be able to:

  1. Utilize the Windows commands and functions necessary to operate a PC or Mac, and understand the basic functions commonly used on the personal computer.
  2. Create documents using MS Word, MS Excel, MS Access, MS PowerPoint, Keynote, Pages, and Numbers. Save the documents, then edit and print them. The student will also pull spreadsheet and database information into the word processor.
  3. Utilize the program help features and the manuals to learn new features of the programs.
  4. Set up and use a spreadsheet and relational database and then utilize them for calculations.
  5. Demonstrate an understanding of storage operations on personal computers.

REQUIRED TEXT - Provided
Microsoft Office 2010 Introductory, Shelly Cashman Series, Course Technology (2011),
ISBN: 10-4239-7838-6

GRADING POLICY AND PROCEDURES
Final grades will be determined by the percentage of possible points earned from exams and homework according to the following scale:

90% or above : A
80-89% : B
70-79% : C
60-69% : D
Below 60% : F

Grades will be based on daily assignments worth 10 pts each which make up 60 % of the grade and at least three exams which will make up 30% with 10 % for classroom participation and behavior.

TENTATIVE SCHEDULE

Week/Date Unit Lesson Lesson Title
 

Introduction

Com 1 Introduction to Computers/Office 2010 Essential Concepts and Skills
9-19-14 InDesign   Book Cover - Two Page Spread Web - PDF
       
       
 

Publisher

  No Book
8-22-14
Flyer assigned
8-26-14
Get familiar with Publisher   Creating a Flyer with Tear-Offs
Assignment Need a Math Tutor?
8-27-14 Learn how to make a program   Softball Program
 

Make book fold/Set tabs

   
 

Business Cards

  -13 save as business_cards_yourname
 

Learn how to make a newsletter
Scoring Guide - Must Print PDF

  -13 save as personal_newsletter_yourname
       
 

Microsoft Word

1 Creating, Formatting, and Editing a Word Document with Pictures
      Create 3 Folders in your WORD folder called
Word P1
Word P2
Word P3
 

Helpful Links: SAM 2010 Log-In

  Word 2010 - Ch1 In the Lab 1
      Word 2010 - Ch1 In the Lab 1b
  Rescheduled because of FLASH player   Microsoft Office Word - Ch1 Exam
       
      Jr. High Basketball Programs - Criteria 80 Points Possible
       
  Work independently thru project 2 Creating a Research Paper with Citations and References
save in your Word P2 folder as Triangulation Paper
      SAM Word Project 2 In the Lab 1
      SAM Word Project 2 In the Lab 1b
      SAM Word Project 2 EXAM
       
  Work independently thru project 3

Creating a Business Letter with a Letterhead and Table
save in your Word P3 Folder as Heartland Advertisement Letter
Print Assignment

      SAM Word Project 3 In the Lab 1
      SAM Word Project 3 In the Lab 1b
      SAM Word Project 3 EXAM
 

Pages

   
 

Microsoft Excel

1 Creating a Worksheet and an Embedded Chart
       
 

Helpful Links: SAM 2010 Log-In

  End of Chapter Assignments
      SAM Excel Project 1 In the Lab 1
      SAM Excel Project 1 In the Lab 1b
      SAM Excel Ch1 Review for Exam 1
      SAM Excel Ch1 Review for Exam 2
      SAM Excel Project 1 Exam
       
       
    2 Formulas, Functions, and Formatting
      SAM Excel Project 2 In the Lab 1
      SAM Excel Project 2 In the Lab 1b
      SAM Excel Project 2 Exam
       
    3 What-If Analysis, Charting, and Working with Large Worksheets
      SAM Excel Project 3 In the Lab 1
      SAM Excel Project 3 In the Lab 1b
      SAM Excel Project 3 Exam
       
      Semester Final Word - 15 pts
      Semester Final Excel - 15 pts
       
  Numbers    
       
 

Microsoft Access

1 Databases and Database Objects: An Introduction
      SAM Access Project 1 In the Lab 1
      SAM Access Project 1 In the Lab 1b
      SAM Access Project 1 Exam
       
    2 Querying a Database
      SAM Access Project 2 In the Lab 1
      SAM Access Project 2 In the Lab 1b
      SAM Access Project 2 Exam
      SAM Access Project 2 Exam 1-Performance
      SAM Access Project 2 Exam 2-Performance
       
    3 Maintaining a Database
       
 

Microsoft PowerPoint

1 Creating and Editing a Presentation with Clip Art
  Work through Project 1 on your own. Be sure and read all of the steps, the Other Ways, and the Q&As.    
      SAM PowerPoint Project 1 In the Lab 1
      SAM PowerPoint Project 1 In the Lab 1b
      SAM PowerPoint Project 1 Exam
       
    2 Enhancing a Presentation with Pictures, Shapes and WordArt
  Work through Project 2 on your own. Be sure and read all of the steps, the Other Ways, and the Q&As.    
 

Student data files are located with the following path:
RuckerShare/student/Shelly_Cashman_Student_Resources/

  SAM PowerPoint Project 2 In the Lab 1
      SAM PowerPoint Project 2 In the Lab 1b
      SAM PowerPoint Project 2 Exam
       
  Work through Project 2 on your own. Be sure and read all of the steps, the Other Ways, and the Q&As. 3 Reusing a Presentation and Adding Media
      SAM PowerPoint Project 3 In the Lab 1
      SAM PowerPoint Project 3 In the Lab 1b
      SAM PowerPoint Project 3 Exam
       
      Final - Word, Powerpoint, Excel

OPTIONAL INSTRUCTOR POLICIES
No use of any electronic devices in class!!!

STUDENT CODE OF CONDUCT
It shall be the responsibility of every student enrolled at Missouri Valley College to support the academic integrity of the institution. This applies to personal honesty in all aspects of collegiate work, all student records, and all contacts with faculty and staff. Academic dishonesty will not be tolerated.
It shall also be the responsibility of every student enrolled at Missouri Valley College to be respectful of the right of other students, staff, and instructors to ensure a safe, peaceful atmosphere conducive to the educational goals of an institution of higher learning. Rude or disruptive behavior will not be tolerated.

Student actions that do not adhere to the MVC Student Code of Conduct will be addressed according to College policies regarding academic dishonesty and disruptive behavior. Students who exhibit dishonest, disruptive, or disrespectful behavior risk suspension or expulsion from the institution.

ACADEMIC DISHONESTY
Faculty creates an environment conducive to honest student work through clear communication of expectations. In the case of suspected academic dishonesty, the faculty member deals with and documents the situation as they deem appropriate. Each documented incident is put in the student’s file in the office of the Chief Academic Officer. Documentation will include the student response to the incident. After three offenses, the CAO, the faculty member(s), and the student meet to discuss the consequences. Consequences include, but are not limited to, course failure or dismissal from school. Students who have had one offense will be required to successfully complete a tutorial on understanding and avoiding plagiarism.

ATTENDANCE POLICY
Attendance is expected and required at each class meeting.

Any student who misses two consecutive weeks of class or has missed 50% of class periods by mid-term may be administratively withdrawn from class. If the withdrawal takes place within the first 6 weeks of class, the student will receive a grade of “W”. If the withdraw takes place after the 6th week of class, the student will receive a “WF” or “WP”. The student will be notified of this action by the Registrar’s Office. Readmission will be considered only for extenuating circumstances as approved by the Chief Academic Officer and Registrar. In such cases, where readmission is approved, a readmit fee of $350 will be charged. If a student drops below full-time status of 12 hours, financial aid may be adversely affected. Resident students dropping below 12 hours will be asked to move out of campus housing.

ADA STATEMENT

The College seeks to comply fully with Section 504 of the Rehabilitation Act of 1973 and the Americans with Disabilities Act of 1990. The ADA Coordinator works with the programs to assist the faculty in understanding and implementing accommodations.

Students with disabilities should have documentation of their disability sent to the campus ADA coordinator, Jamie Gold, Baity Hall, Room 206, 831-4170, and set up an appointment as soon as they arrive on campus. Failure to do so could delay accommodations. After proper documentation, reasonable efforts will be made to accommodate students’ needs. If you have any questions about how to initiate this process, please contact your instructor.