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.
ASSESSMENT OF STUDENT LEARNING OUTCOMES
At the conclusion of this course, the student will be able to:
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 | |
|
|||
|
-13 save as business_cards_yourname | ||
|
-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 |
|
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: |
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.