Administrative Management Department Learning Objective - Business Technology Skills

A solid foundation in current software and use of the Internet are absolute necessities in the modern office. A series of software courses in areas such as word processing, spreadsheets, databases, and presentation software with progressive degrees of difficulty are required to prepare students to function effectively in the computer-oriented workplace.

CATALOG DESCRIPTION:

ADM 121 Word Processing, 4 units

Prerequisite: ADM 120, the ability to type 25 wpm on a five-minute test or approval of instructor.

This course provides a comprehensive introduction to Microsoft Office Word 2003. Topics include creating and editing a Word document, creating a research paper, creating a resume using a wizard and a cover letter with a table, creating Web pages using Word, creating a document with a table, chart, and watermark, generating form letters, mailing labels, and directories, creating a professional newsletter, using Word’s collaboration tools, Creating an Online Form, Working with Macros and Visual Basic for Applications (VBA) and Working with a Master Document, an Index, a Table of Contents, and XML
Integration Feature: Linking an Excel Worksheet and Charting Its Data in Word

COURSE DESCRIPTION:

This course provides instruction in the use of a Microsoft Word in life like business settings. Microsoft’s Office Suite has become a near standard for business software. This comprehensive course provides a complete set of the application skills necessary for successful completion of the Microsoft Office Professional User Certification as well as the Expert Certification skill sets required by Microsoft. The course does not guarantee that the student will successfully pass the Microsoft Certification but the materials covered in the course cover all concepts and skills addressed in the User and Expert online examinations developed by Microsoft.

LEARNING OBJECTIVES:

Utilizing Microsoft Word 2003, the student will be able to change margin settings and line spacing. Create headers and footers, insert page numbering, page breaks, create hyperlinks, insert graphics, size and position graphics, use the research task pane, proof and revise a document. The student will be able to use tab stops, format paragraphs, and characters, create auto text entries, tables, merged documents, watermarks, work with smart tags, modify file properties, address and print envelopes and labels as well as to insert date and time functions.

PREREQUISITE:

Completion or test out of ADM120 with keyboarding skills of 25 wpm or greater.

WRITING ACROSS THE CURRICULUM: Students will focus on the following writing skills and objectives:

• Develop editing and proofreading skills for Word documents.

HOURS OF INSTRUCTION:

Two 125-minute periods per week, or one 210 minute period.

METHOD OF INSTRUCTION:

This class is a skills lab, and as such students, are working at their own pace, self-teaching utilizing the required text, aided by lecture, demonstrations and hands on individual help from the instructor. A combination of lecture, text reading and exercises are used to present concepts and skills. Students are encouraged to work at their own pace with assistance from instructor when requested, however; theory and machine tests dates are final. It is up to the student to maintain a pace that will match the minimum pace set forth in this outline.

Instruction is Composed of Two Major Areas

Skill Attainment - These are the individual operations necessary in order for the application (Word, Excel, Access, PowerPoint, Publisher) to respond appropriately to what you are asking it to do. Typically this depends on you (the operator) recognizing the present state that the application is in, and what steps are necessary for you to complete one or more operations through keyboard or mouse movements which is your way of communicating with the software (Word, Excel, Access, PowerPoint, Publisher).

Application - This is the ability to bring the skill set (see above) into the real world in order to help facilitate the calculation, presentation, and communication of useful information. This part of the instruction is designed to help you see (by example) how the business application software is used in the real world. Your job is to spend time noting the format and design of the individual application documents and what they are attempting to accomplish and to convey to others who may have access to them. This requires what is known in the psychological and educational literature as higher order thinking skills, i.e. your ability to take what you have practiced and experienced in one situation or environment and extrapolate it to new situations and environments, like your home, school, and place of employment.

Course Components Related to the Two Major Areas

Skill Attainment -

Text Projects - Text projects identify the skill learning objectives that will be covered within the project and each subsequent project builds on the other to some degree but not to the degree that would require you to complete all previous projects before attempting a later project. The textbook moves the student from one small step to the next in a sequence of steps to complete a successful operation. The text is filled with numerous visual aids that closely represent what should be on your monitor as you follow along with the instructional set. Often the text will include side-bars and or additional comments that inform you of alternative methods of completing an individual task, pay attention to these as you may find these methods more to your liking. Moving through each project takes patience, time and a full understanding of where you are going and where you have been in order to fully appreciate what the project is trying to convey to you the student. So take time to look at the completed document presented at the beginning of each project and understand that you will be creating that document during the completion of the project, many times beginning from a blank document, spreadsheet or database.

Skill Set Demonstrations - Skill set demonstrations are examples of the individual items that make up the skill learning objectives for each project. These skills are the skills that the sam2003 online environment assess and make up the complete set of all items that you could be tested on during the project of study. The demonstrations themselves are flash presentations of your instructor completing the items individually and correctly. They are presented individually so that you can choose what skills you need to work on without having to view them all. Skills like keyboarding and software have traditionally been taught through the techniques known as drill and practice, the skill set demonstrations in conjunction with the practice tests are designed to be used in conjunction to give you drill and practice experience within the learning objectives for each project.

Practice Tests - Practice tests are made available on the sam2003 testing site. You may take each practice test up to 5 times. Practice tests include every skill that is presented during the project of study and usually two or three items from a previously completed project. Use your practice test to assess your learning after you complete the project.

Application -

Text Projects - Projects are presented as cases, cases are real world examples of how the document might be used in a home or business environment. Take special note of how documents are formatted (layout) and what information they are designed to convey.

In The Lab Assignments - These assignments are shorter versions of the project itself. They typically are cases based on alternative businesses or alternative home uses that utilize the very same skill sets developed during the project. These additional assignments help you to gain additional perspective on how similar documents are used in settings other than the one presented in the Text Project Lesson. These assignments typically include less detailed instruction than the project itself and your critical thinking and problem solving skills are needed for the successful completion of these assignments.

Lecture Demonstrations - Lecture/Demonstrations are of two basic types; the first being discussions of the completed documents, relating how the particular document is utilized in business situations and the second type is an actual demonstration by the instructor on how an In The Lab assignment is to be completed. Often the instructor will verbalize the problem solving process in order to help the student integrate just how the skill sets presented in the project can be used to create the desired final product with the software application under study.

How to be successful in this computer applications course

Suggestions For What To Do When

• View/Pay Attention to the Lecture/Demonstration
• Complete the Project in the textbook
• Go online and take the skill set practice test
• Go online and review the sill set demonstrations
• Go online and take the skill set practice test
• Complete the In The Lab assignment for the project
• Go online and re-take the skill set practice test, returning to the skill set demonstration as necessary

REQUIRED TEXTBOOKS AND MATERIALS:

Microsoft Office Word 2003: Comprehensive Concepts and Techniques

Shelly Cashman Vermaat (ISBN: 0-619-20037-5)

SAM2003 Course Testing Software, Course Technology, Thomson Learning. Students may use their seat license obtained in ADM120 for this and all computer business application courses here at Humphreys College .

USB Drive for saving files done at home or on Library workstations.

COURSE CONTENT:

The class will be set up a lecture/lab basis. Students will be required to work on the personal computers to complete lab projects assigned each week. WARNING: You should expect to spend one to two hours outside of regular class time on the computer for every hour spent in the classroom.

BASIS OF EVALUATION:

Attendance: 120 Points (10 per week)

Exercises: 975 Points (25 points each)

Tests: 500 Points (100 points each)

Final: 400 Points

Total Points 1995 Points

ATTENDANCE POLICY:

Ten points will be deducted from the attendance portion of the grade for any days’ absence during a scheduled class meeting, or missing 1-1/2 hours of any night class meeting.

LATE ASSIGNMENT POLICY: Late assignments will not be graded until the current weeks assignment has been completed, the instructor notified that the current weeks work is in the student folder, the instructor has then given the student permission to submit specific late assignments and the assignments committed to by the student are in the student’s folder at the agreed upon time. All late work will be penalized.

PLAGIARISM: Plagiarism is not condoned or excused. Term papers, research reports and essays are expected to be the individual work of the student. References and sources of information should be identified and accurately documented within the body of any written work. Violation of the honor code or plagiarism is cause for dismissal.

STUDENT SERVICES: Reading, writing, researching, and math tutorial services are available from the Libraries Student Service Center . The Computer Labs are open on the main campus from 1-6 p.m. daily and the Library has workstations available during all business hours.

CLASS SCHEDULE:

Since the students work at their own pace, this schedule is to be used as a guideline for minimum standards. Students are encouraged to work as accurately and rapidly as they can to complete the course. Tests dates are permanent unless changed by the instructor during the quarter. Students absent on test days are required to contact instructor on the assigned testing day in order to be eligible for a makeup test.

Assignments submitted and accepted late will be lowered 10%