Syllabus

POFT 1273.090 – Microsoft Excel 2007

 

Department: Administrative Computer Technology

Course: POFT 1273– Microsoft Excel 2007

Credit Hrs.: 2 Hrs. Hrs./Wk. Lec. 2 Hrs./Wk. Lab: 1

Instructor: Murat Tas Office: Nail Technical Center Room 207

Office Hrs: by appointment Phone: 733-2432

I. CATALOG DESCRIPTION

This course was specifically developed as an introductory personal computer applications course. It covers all essential aspects of EXCEL 2007. Students completing this course will have knowledge of Windows and will be able to solve a variety of spreadsheet problems. The windows environment places the students in the world of the mouse and a common graphic user interface between all applications.

II. REQUIRED BACKGROUND

EXCEL 2007 for Windows was specifically developed for an introductory spreadsheet course. No previous experience with a computer is assumed, and no mathematics beyond the high school freshman level is required.

III. TEXTS AND OTHER REFERENCE MATERIALS

Text: MICROSOFT OFFICE EXCEL 2007: COMPLETE CONCEPTS AND TECHNIQUES

Shelly, Cashman, Quasney (ISBN: 1428330267 )

IV. METHOD OF INSTRUCTION

A. Self-paced instructional method presented in textbook.

B. One-on-one explanation and problem solving

C. Student independent practice

V. COURSE GRADE

Assignments 50%

Tests 25%

Three comprehensive (open book) objective tests will be given. They will consist of T/F questions.

Test 1 will cover all material covered in Projects 1 and 2.

Test 2 will cover all material covered in Projects 3 and 4.

Test 3 will cover all material covered in Projects 5 and 6.

Final Examination 25%

Includes a comprehensive objective test.

VI. COURSE CONTENT

POFT 1273, Spreadsheets, is a course in which the student will develop a firm knowledge of Windows and will be able to solve a variety of spreadsheet problems.

VII. COMPETENCIES

At the completion of POFT 1273.090, the student will be able to:

  1. Understand EXCEL terminology, the EXCEL Window, and the basic characteristics of a worksheet an workbook by doing the following: Starting and exiting EXCEL; entering text and numbers, selecting ranges, using the Autosum button, copying using the fill handle, changing font sizes, bolding, centering across columns, using AutoFormat, charting using the ChartWizard button, saving and opening a worksheet, editing a worksheet, and obtaining on line Help.

  2. Use formulas and functions to build a worksheet format text, format numbers, add borders and color, change widths of columns and heights of rows, spell check, create 30-D columns, preview and print a worksheet and display and print the formulas in a worksheet.

  3. Copy objects between a source document and a destination document by using the three methods for copying objects–copy and paste; copy and embed; and copy and link. 

Attendance Policy

Monitored weekly via email. Students accumulating excessive absences (2) may be withdrawn from the course without further notification. Your weekly e-mails should keep pace with the schedule of Lab work described on the Assignments Due page, and is to include the labs you have completed in the current Projects. If you do not complete a project at the assigned time, you must still e-mail me on the day the Project is due for attendance purposes, otherwise you will be marked absent.

You will also include Projects as attachments to the email sent weekly.

Academic Dishonesty Policy

Students may be subject to disciplinary proceedings resulting in an academic penalty or disciplinary penalty for academic dishonesty. Academic dishonesty includes, but is not limited to, cheating on a test, plagiarism and collusion. For additional information refer to the "Student Code of Conduct" in the San Antonio College Bulletin.

ADA Statement for Students Requiring Special Accommodations

As per Section 504 of the Vocational Rehabilitation Act of 1973 and the Americans Disabilities Act (ADA) of 1990, if accommodation is needed, students must make the request through the Office of Disabled Student Services, CAC 124C, Phone: 733-2347.

No Tutorial Service on Internet Courses

Tutorial help is not available on the Internet Courses.

San Antonio College | Alamo Community Colleges | Administrative Computer Technolgy

Course Home