Navigate Up
Sign In
POFI 1301 Syllabus
Brazosport College

 

 

BRAZOSPORT COLLEGE

 

LAKE JACKSON, TEXAS

 

 

SYLLABUS

 

 

POFI 1301:  COMPUTER APPLICATIONS I

(File Management/PowerPoint/Word/Excel)

 

 

 

COMPUTER TECHNOLOGY & OFFICE ADMINISTRATION DEPARTMENT

 

 

CATALOG DESCRIPTION

 

 

POFI 1301 Computer Applications I (File Management/PowerPoint/Word/Excel).  CIP 5204070004

Overview of computer applications including current terminology and technology. Introduction to computer hardware, software applications and procedures. (3 SCH, 2 lecture, 3 lab)

Prerequisites:  POFT 1329 or approval of the division chair. Concurrent enrollment in POFT 1321 or passing score on business math placement test is recommended.

Required skill level code:  Not applicable

 

 

PREPARED BY:

 

 

DATE:

 

 

INSTRUCTOR

 

 

 

 

RECOMMENDED BY:

 

 

DATE:

 

 

DIVISION CHAIRMAN

 

 

 

 

RECOMMENDED BY:

 

 

DATE:

 

 

DEAN

 

 

 

 

APPROVED:

 

 

DATE:

 

 

 

 

 

 

 

The Brazosport College District shall not discriminate against, or exclude from participation in any benefits or activities either on the staff or in the student body, any person on the grounds of sex, race, color, religion, national origin, age, or handicap




This page left intentionally blank for printing purposes.

BRAZOSPORT COLLEGE

SYLLABUS

POFI 1301:  COMPUTER APPLICATIONS I

 

COURSE EVALUATION

 

STUDENT EVALUATION

 

  1. Daily work will account for no more than 20% of the total grade.

 

  1. Tests will account for no more than 55% of the total grade.

 

  1. Final exam will account for no more than 25% of the total grade.

 

INSTRUCTOR EVALUATION

 

  1. Students will be given an opportunity to evaluate their instructor and the course content.

 

  1. The instructor will review and evaluate in terms of withdrawal rate.

 

  1. Final grades given will be reviewed in an effort to determine if a pattern of high or low grades exists.

 

DEPARTMENT EVALUATION OF COURSE

 

  1. Faculty and the Division Chair will review student grades and withdrawal trends.

 

  1. Faculty and the Division Chair will review the Course Competencies and Perspectives Assessment.

 

 


BRAZOSPORT COLLEGE

SYLLABUS

POFI 1301:  COMPUTER APPLICATIONS I

 

 

COURSE CONTENT

 

GENERAL GOALS/OBJECTIVES

 

The student will learn computer fundamentals and the basics of Windows 7, Word 2010, Excel 2010, and PowerPoint 2010 on a personal computer.

 

The following list of course goals will be addressed in the course. (* designates a CRUCIAL goal)

 

*1. Log on and off the brazosport college network

 

 2. Cursor movement

 

 3. Operating system

 

*4. Menus, folders, files

 

 5. Maximize, minimize, restore windows

 

 6  Move and size windows/scrolling/bars, title bar, menu bar

 

 7. Clicking and dragging

 

*8. Shortcut menu/right mouse

 

*9. Help

 

10. Recycle bin

 

11. Multiple windows

 

12. Active windows

 

13. Tile and cascade

 

*14. Clipboard

 

*15. Copy, cut and paste

 

*16. Explorer


 

Related to Word 2010, the student will learn about:

 

*17. Exhibit accuracy

 

18. Word saving retrieving/opening closing status bar-minimize

 

19. Edit text

 

*20. Follow directions

 

*21. Format documents

 

*22. Navigate within a document

 

23. Word screen

 

*24. Word wrap

 

25. Correct/incorrect use of spacebar

 

26. Undo and redo

 

27. Nonprinting characters

 

*28. Alignment

 

*29. Indenting

 

30. Hanging paragraphs

 

31. Copying and deleting files

 

32. Changing fonts

 

33. Manipulating text within and between documents

 

34. Format painter

 

35. Spell check

 

36. Thesaurus

 

37. Grammar check

 

38. Autocorrect

 

39. Insert and overtype mode

 

40. Printing options

 

41. Headers and footers

 

42. Manipulating tabs

 

43. Changing margins

 

44. Section breaks

 

45. Wordart

 

46. Graphics

 

Related to Excel 2010, the student will:

 

*47. Identify spreadsheet terms

 

48. Design spreadsheets

 

*49. Create spreadsheet documents

 

*50. Edit spreadsheet documents

 

*51. Format spreadsheet documents

 

52. Cells and cell references

 

53. Standard and formatting toolbars

 

54. Formula bar

 

55. Status bar

 

*56. Enter formulas—order of operations

 

57. Insert

 

*58. Format

 

59. Alignment

 

60. Borders and patterns

 

61. Row heights and column widths

 

62. Autoformat

 

63. Headers/footers

 

64. Page setup

 

65. Autosum

 

66. Function wizard

 

67. Help

 

68. Entering row titles

 

69. Creating and copying formulas with relative cell references

 

70. Creating and copying formulas with absolute cell references

 

71. Charts

 

Related to PowerPoint 2010, the student will:

 

72. Use software

 

73. Create new presentations

 

74. Create an outline

 

75. Build an organization chart

 

76. Enter, edit, adjust, and format text

 

77. Use master and template documents

 

78. Draw and modify objects

 

79. Use Build

 

80. Use clipart and graphics

 

81. Use the autocontent wizard

 

82. Create speaker notes

 

83. Apply and modify design template

 

84. Use slide transition

 

85. Create and edit hyperlinks

 

86.  Integrate with other programs


 

SPECIFIC GOALS/OBJECTIVES

 

Items 1-16

The student will be tested on and will perform the item using the computer within each software used through semester.

 

WORD

 

17.  The student will be provided tools. The student will exhibit accuracy. Performance will be satisfactory if accuracy is exhibited. (See Addendum A)

19.  The student will be allowed references. The student will edit text. Performance will be satisfactory if text is edited. (See Addendum A)

20.  The student will follow directions. Performance will be satisfactory if directions are followed and are consistent with text and teacher instruction.

21.  The student will be allowed references. The student will format documents (lines, navigate within a document). Performance will be satisfactory if documents are formatted and the formatting is consistent with text and instructions. (See Addendum A)

22.  The student will be allowed references. The student will navigate within a document. Performance will be satisfactory if student is able to move within a document with the shortest amount of keystrokes.

 

Items 17-46

The student will be tested on and will perform the items using the computer.

 

EXCEL

47.  The student will identify spreadsheet terms. Performance will be satisfactory if terms are identified and the identification is consistent with text.

 

48.  The student will be allowed references. The student will perform the specified function to create and design a spreadsheet. Performance will be satisfactory if the spreadsheet is created and designed in accordance with exercise directions.

 

Items 47 – 71

The student will be tested on and will perform the item using the computer.

 

POWERPOINT

 

Items 72 – 86

The student will be given a written test.

 

 


BRAZOSPORT COLLEGE

SYLLABUS

POFI 1301:  COMPUTER APPLICATIONS I

 

 

LEARNING OUTCOMES

 

POFI 1301 – Computer Applications I (File Management/PowerPoint/Word/Excel)

 

1.      Create, edit and format documents using Microsoft Word.
Average score of 70 on Lab work and average score of 70 on Test1.

 

2.      Perform Desktop Publishing using Microsoft Word.
Average score of 70 on Lab work and average score of 70 on Test1.

 

3.      Create and format a spreadsheet using Microsoft Excel.
Average score of 70 on Lab work and average score of 70 on Test2.

 

4.      Develop simple formulas and graphs using Microsoft Excel data.
Average score of 70 on Lab work and average score of 70 on Test2.

 

5.      Demonstrate the ability to create a PowerPoint Presentation.
Average score of 70 on Lab work and average score of 70 on Test3.

 

6.      Demonstrate knowledge of vocabulary.
Average Score of 70 on Tests 1-3.

 


BRAZOSPORT COLLEGE

Syllabus

POFI 1301 COMPUTER APPLICATIONS I

 

Instructor :  DeLeon, Alicia

Office :  D-225

Office Phone :  230-3573

Email :  Alicia.deleon@brazosport.edu

Alt. Phone :  979-230-3229 Div Secretary

Web site:

 

 

COURSE DESCRIPTION

 

Overview of computer applications including current terminology and technology. Introduction to computer hardware, software applications (File Management/Word/Excel/PowerPoint) and procedures.

 

PREREQUISITES

 

Concurrent enrollment in POFT 1329 or the ability to keyboard 35 wpm or consent of division chair.

Note:  concurrent enrollment in POFT 1321 is recommended.

 

TEXTBOOK OR COURSE MATERIAL INFORMATION

 

Zimmerman, S. Scott, Zimmerman, Beverly B. and Ann Shaffer. New Perspectives on Microsoft Office Word 2010—(Comprehensive Course Card Edition). Thomson Course Technology, 2011.

                    [TUTORIALS 1-4]

 

Parsons, June Jamrich, Oja, Dan, Carey, Patrick and Roy Ageloff. New Perspectives on Microsoft Office Excel 2010—(Comprehensive). Thomson Course Technology, 2011.

                    [TUTORIALS 1-4.1, 5.1-5.2 and 6.1]

 

SAM 2010 Assessment, Training, and Projects v 2.0 Printed Access Card, 1st Edition.

 

LAB REQUIREMENTS        (None)

 

ATTENDANCE AND WITHDRAWAL POLICIES

 

The student is expected to attend all classes, to be on time, and to read text prior to class meetings. All computer assignments are to be completed on campus DURING THE LAB TIME SCHEDULED FOR THIS CLASS and must be turned in by the due date designated by the instructor. An office atmosphere is to be maintained at all times with students exhibiting business-like attitudes and habits (see ADDENDUM B).

Students will be dropped if they miss more than 20% of the classes before the drop date. Tardies and leaving early will count as part of an absence.

 

Fall and Spring 15-week Semesters

Class Meetings

Maximum absences before being dropped

One per week

2

Two per week

4

 

It is the student's responsibility to withdraw from a course if circumstances occur that could prevent the student from successfully completing that course. Students should notify instructor of decision to withdraw and must not expect nor assume the instructor will complete the paperwork for the student. The instructor will complete required paperwork only if the instructor decides to drop a student for cause. Failure to notify instructor of withdrawal could result in the student failing the course.

 

Please note that changes in the Texas Education Code state that students enrolling for the first time in a Texas public institution of higher education in the fall of 2007 or after, will not be permitted to withdraw from more than a total of six courses (no minimum number of credit hours on each course) in which the student is officially enrolled during the student's period of undergraduate study at all such institutions (this includes any course a transfer student has dropped at another institution of higher education). See http://www.brazosport.cc.tx.us/CurStu.mhtl for more information.

 

COURSE REQUIREMENTS AND GRADING POLICY

 

Determining factors for final evaluation are:

 

 

Daily Work

20%

 

 

Tests

55%

 

 

Final Exam

25%

 

 

TOTAL

100%

 

 

TESTING

 

1.   FILE MANAGEMENT AND FUNDAMENTALS IN WINDOWS 7, WORD 2010, EXCEL 2010,            and POWERPOINT 2010.  Daily grades will be graded on a points basis (see Addendum A).

 

         Tests will be based on lecture and lab. Each test will be based on a 100 point scale. Each activity on the exam will test one or more course goals.

 

         A final exam will be given at the end of the semester and will cover Windows 7 Fundamentals, Word 2010, Excel 2010, and PowerPoint 2010.

 

MAKE-UP POLICY

 

               There are NO MAKEUP  EXAMS. There will be three tests and a final exam. If a student misses one test, the final exam grade -11 points will be recorded for the missed test.

 

               The student will receive a zero “0” for all other tests missed.

 

NO WORK WILL BE ACCEPTED AFTER THE UNIT EXAM.

 

STUDENT RESPONSIBILITIES

 

The class period will consist of 2 lecture hours and 3 lab hours per week.

Students will be given an opportunity to evaluate the course and the method of presentation at the end of the semester. Students are also expected to take care of the equipment in the classrooms. PLEASE DO NOT BRING FOOD, DRINKS, OR UNAUTHORIZED PERSONS INTO THE CLASSROOM.

 

PROJECTS, ASSIGNMENTS, PORTFOLIOS, SERVICE LEARNING, INTERNSHIPS, ETC.

 

As assigned.

 


SCANS COMPETENCIES

 

The Secretary's Commission on Achieving Necessary Skills (SCANS) identified competencies in the areas of Resources, Interpersonal, Information, Systems, and Technology; and foundation skills in the areas of Basic Skills, Thinking Skills, and Personal Qualities. This course is part of a program in which each of these competencies and skills are integrated. For application of specific SCANS competencies and skills in this course, see Addendum C.

 

ACADEMIC HONESTY

 

Brazosport College assumes that students eligible to perform on the college level are familiar with the ordinary rules governing proper conduct including academic honesty. The principle of academic honesty is that all work presented by you is yours alone. Academic dishonesty, including, but not limited to, cheating, plagiarism, and collusion shall be treated appropriately. Please refer to the Brazosport College Student Guide for more information. This is available online at http://www.brazosport.edu (click on the link found on the right side of the homepage).

 

STUDENTS WITH DISABILITIES

 

Brazosport College is committed to providing equal education opportunities to every student. Brazosport College offers services for individuals with special needs and capabilities including counseling, tutoring, equipment, and software to assist students with special needs. Please contact the Special Populations Counselor at (979) 230-3236 for further information.

 

OTHER STUDENT SERVICES INFORMATION

 

Information about the Brazosport College Library is available at www.brazosport.edu/sites/CurrentStudents/Library/default.aspx or by calling (979) 230-3310.

 

Information about study skills and tutoring for math, reading, writing, biology, chemistry, and other subjects is available in the Learning Assistance Center (LAC) (see www.brazosport.edu/sites/CurrentStudents/LAC/default.aspx or call (979) 230-3253).

 

To contact the Computer Technology & Office Administration Department, call (979) 230-3229 or (979) 230-3394.

 

Student Services provides assistance in the following:

 

                                 Counseling and Advising                        (979) 230-3040

Financial Aid                              (979) 230-3294

Student Activities                                    (979) 230-3355

 

To reach the Information Technology Department for computer, E-mail, or other technical assistance, call the Helpdesk at (979) 230-3266.


ADDENDUM A

 

DAILY GRADING

 

Points will be deducted if the following is not done correctly.

 

                     1.         Did you follow the instructions in the textbook?

                     2.         Did you follow the instructions given by the instructor?

                     3.         Is your work in the correct sequence?

                     4.         Do you have any spelling errors?

                     5.         Did you omit any letters, words, spaces, lines?

                     6.         Did you omit any necessary parts of the document?

                     7.         Did you use the correct style?

                     8.         Did you use correct vertical and horizontal placement?

                     9.         Did you format the document correctly?

                     10.       Is your work labeled correctly?

 

Students will be responsible for the accuracy of documents which includes content, mechanics, and format of the document. Students should check for misspelled words, punctuation, capitalization, as well as the arrangement of the document on the page.


 

ADDENDUM B

 

WORK ATTITUDES AND HABITS

 

ATTITUDES

 

                     1.         Shows enthusiasm toward learning.

                     2.         Has positive attitude toward learning.

                     3.         Displays courtesy toward others.

                     4.         Takes pride in work.

 

HABITS

 

                     1.         Arrives on time.

                     2.         Begins work immediately upon entering classroom.

                     3.         Maintains own supply of materials.

                     4.         Does not waste time in classroom.

5.         Removes all waste materials from desk at end of period turns off computer and/or terminal at the end of period.

                     7.         Attends all classes.

                     8.         Listens and follows directions.

                     9.         Does not bring food, drink, or gum into the classroom.


ADDENDUM C

SCANS COMPETENCIES

POFI 1301 COMPUTER APPLICATIONS I

Competency

Reference

 

Application

 

 

 

1.

Resource

 

 

  Time Management,

Deadlines are assigned to exercises, with penalties awarded when the deadlines are not met.

 

   Facilities/Materials,

Student must have a fundamental working knowledge of a microcomputer and

 

   Human Resources

Windows.

 

 

 

2.

Interpersonal

 

 

   Leadership,

 

 

   Part. as Team Member,

 

 

   Works with Diversity

 

 

 

 

3.

Information

 

 

   Acquiring,

Acquire skills in using the software programs; evaluate necessary steps and organize ideas, and interpret information to use in formatting a document or in creating a spreadsheet.

 

   Organizing,

 

   Interpreting

 

 

 

4.

Systems, Understanding

 

 

   Organizational Systems,

 

 

   Technological Systems,

Execute basic commands for Word and Excel efficiently.

 

   Social Systems

 

 

 

 

5.

Technology

 

 

   Selecting,

 

 

   Applying,

Understand the basic operation of equipment and software by using it in the

 

   Maintaining

production of documents and spreadsheets.

 

 

 

6.

Basic Skills

 

 

   Reading, Writing,

Communicate ideas and information to the creation of a document or spreadsheet.

 

   Mathematics,

Execute the basic mathematical functions using a spreadsheet.

 

   Speaking, Listening

 

 

 

 

7.

Thinking Skills

 

 

   Decision Making,

Recognize the type of problem; create a document or spreadsheet to

 

   Problem Solving,

solve the problem.

 

   Learning Techniques

 

 

 

 

8.

Personal Qualities

 

 

   Responsibility,

Follow instructions on all assignments; consult the instructor for assignment when class is missed; make up any assignment as directed in the syllabus.

 

   Sociability,

 

   Integrity/Honesty

Display ethical and business-like conduct at all times.

 

 

 


 

POFI 1301 – Computer Apps I (Win/Wrd/Exl/PPT)

Weekly Schedule

Agenda

Assignment

Week 1

1.   Orientation-BC Network drives, Course Web Site, Syllabus, Schedule, etc.

2.   Introduction to Managing Your Files

MUST obtain personal network account before next class!!!!

1.   Managing Your Files

2.   Word2007 Tutorial 1--Creating A Document

Tutorial 1 Assignment

Week 2

1.   Turn in Tutorial 2 File (-2 pts on unit test if not time stamped before today)

2.   Word2007 Tutorial 2--Editing and Formatting a Document

Tutorial 2 Assignment

1.   Turn in Tutorial 3 File (-2 pts on unit test if not time stamped before today)

2.   Word2007 Tutorial 3--Creating a Multiple-Page Report

Tutorial 3 Assignment

Week 3

Tutorial 3--(continued)

1.   Turn in Tutorial 4 File (-2 pts on unit test if not time stamped before today)

2.   Word2007 Tutorial 4--Desktop Publishing and Mail Merge

Tutorial 4 Assignment

Week 4

Tutorial 4--(continued)

Review for Test 1- Microsoft Word2007 and complete ALL lab work

All Labs MUST be turned in before Exam

Week 5

TEST 1- Microsoft Word2007 - Tutorials 1-4

 

1.   Excel2007 Tutorial. 1—Getting Started with Excel

Tutorial 1 Assignment

Week 6

1.   Turn in Tutorial 2 File (-2 pts on unit test if not time stamped before today)

2.   Excel2007 Tutorial 2—Formatting a Workbook

Tutorial 2 Assignment

1.   Turn in Tutorial 3 File  (-2 pts on unit test if not time stamped before today)

2.   Excel2007 Tutorial 3 –Working with Formulas and Functions

Tutorial 3 Assignment

Week 7

Tutorial 3—(Continued)

Work on all Assigned Tutorials

1.   Turn in Tutorial 4 File (-2 pts on unit test if not time stamped before today)

2.   Excel2007 Tutorial 4--Working with Charts & Graphics

Tutorial 4 Assignment

Week 8

Tutorial 4—(Continued)

 

1.   Turn in Tutorial 5 File (-2 pts on unit test if not time stamped before today)

2.   Excel2007 Tutorial 5 --Working with Excel Tables

Work on all Assigned Tutorials

Week 9

Review for Test 2- Microsoft Excel2007 and complete ALL lab work

Tutorial 5 Assignment

TEST 2- Microsoft Excel2007 - Tutorials 1-5.2

All Labs MUST be turned in before Exam

Week 10

PowerPoint2007 Tutorial 1--Creating a Presentation

Tutorial 1 Assignment

PowerPoint2007 Tutorial 2—Text and Graphics

Tutorial 2 Assignment

Week 11

PowerPoint2007 Tutorial 3--Presenting a Slide Show

Tutorial 3 Assignment

LAB DAY – Tutorials 1-3

Week 12

PowerPoint2007 Tutorial 4--Integrating PowerPoint

Tutorial 4 Assignment

LAB DAY -- Tutorials 4 and Review for PowerPoint Test

Complete all Assigned Tutorials

Week 13

TEST 3- Microsoft PowerPoint2007 - Tutorials 1-5.1

All Labs MUST be turned in before Exam

Lab Period: Microsoft Word. You will need the following files:

Microsoft Word Lab Assignment

KidsRUS.docx

News.docx

Report.docx

Week 14

Lab Period: Microsoft Excel. You will need the following file:

Microsoft Excel Lab Assignment

ExcelLab.xlsx

Review for Final Exam

 

Week 15

Final Exam--Production covering Word and Excel

Week 16

Final Exam--Written covering Word, Excel, and PowerPoint

 

 

 

 

 

© 2013 Brazosport College | 500 College Drive | Lake Jackson, TX 77566 | (979) 230-3000 | Email login | ASTRA | BC Emergency Info | F.A.S. | Institutional Profile | Login