HUMPHREYS COLLEGE	6650 Inglewood Ave., Stockton, CA 95207
SPREADSHEETS Course Outline
CATALOG NUMBER: ADM 134	CREDIT: 4 UNITS
INSTRUCTOR: Assistant Professor Jim DeCosta Office: Room 218 Email address: jdecosta@humphreys.edu Phone: 478-0800 ext 303 Web Site: /faculty/jdecosta Office hours: Monday, Tuesday and Thursday, 10:30a.m. - 12:30 a.m., Wednesday 3:30 p.m. – 5:30 p.m., and by appointment.

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 134 Spreadsheets, 4 units

Prerequisite: ADM 120

Learning objectives from basic spreadsheet concepts of managing workbooks, automating tasks, using and analyzing list data, enhance charts and worksheets and working with Excel and the Internet, to advanced tasks such as performing "what if" analysis, creating PivotTables, exchanging Excel data with other programs, controlling worksheet properties and calculations, perform "what if" analysis, create PivotTables, and perform data analysis.

COURSE DESCRIPTION:

This course is a complete instructional set in Microsoft Excel 2003 from introductory to expert concepts. Basic experience with the Windows Operating system is assumed. After completing this course, you will have covered all the skills necessary to pass the MOUS (Microsoft Office User Specialist) Exam to become certified in Excel 2003 at the core and expert levels.

If this is a face to face class, then it will be conducted as a web enhanced course. A web enhanced course utilizes the Humphreys College online interface for the submission of assignments and the posting of grades, in addition it supplies links to additional course resources not available through your text.

LEARNING OBJECTIVES:

The student will acquire introductory through advanced instruction on Microsoft Office Excel 2003. In these nine projects, the student will learn basic through advanced skills, including building, editing, and formatting worksheets, charts, analyze lists data, use what-if analysis and pivot tables, enhance charts and worksheets, exchange data with other programs, incorporate Web information, and finally, how to gain control over your work and work with programming in Excel. Students will successfully complete the skill sets associated with the Microsoft Office User Specialist Certifications at both the User and Expert Levels.

LEARNING OBJECTIVES:

The student will acquire introductory through advanced instruction on 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), working with a master document, an index, a table of contents, and XML, and linking an Excel worksheet and charting its data in Word. Students will successfully complete the skill sets associated with the Microsoft Office User Specialist Certifications at both the User and Expert Levels.

PREREQUISITE:

Successful completion of ADM120 with a C or better.

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

• Develop editing and proofreading skills for documents in the following formats: Excel.

HOURS OF INSTRUCTION: 2 hrs 5 min on TTH, 1 hr 20 min on MWF, or 3 hrs 30 min when meeting one night per week. Check your schedule for exact times. Online versions of this course have no synchronous meeting times.

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 TEXTBOOK AND MATERIALS:

1. Microsoft Office Excel 2003 Comprehensive Concepts and Techniques. Gary B. Shelly, Thomas J. Cashman, and Misty Vermaat, Course Technology: Thomson Learning.

2. SAM2003 Assessment Software – Students who have obtained their seat license last quarter taking ADM130 or ADM120 can continue to use their license.

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. Citations should conform to either the MLA or APA style. 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. A tutor will be available in the room 5 computer lab during some afternoons, see schedule to be posted on the 2^nd week of the quarter.

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. 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: 110 Points (10 per week)

Project Exercises and In The Labs: 600 Points (22 @ 25 points each + Project 7 @ 50 points)

Project online Quizes: 800 Points (100 points each)

Mid-Term: 200 Points

User Specialist Cert. 100 Points

Exp Cert: 100 Points

Final: 200 Points

Total Points 2110 Points = 100%

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.

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 able to makeup a test. Any and all makeup test dates are determined solely by and at the discretion of the instructor. The following grid is a fair representation of the most probable assignments on a week by week basis throughout the course. The instructor reserves the right to make changes to the following assignments and these changes will be posted in the online portion of the course. When in doubt, check the course website http:/http://online.humphreys.edu/.humphreys.edu