PELLISSIPPI STATE TECHNICAL COMMUNITY COLLEGE  MASTER SYLLABUS
BASIC BUSINESS APPLICATIONS BUS 1010
Class Hours:  1.0								Credit Hours: 1.0
Laboratory Hours:  0.0								Date Revised: Fall 02
NOTE: This course is designed for transfer credit.
Catalog Course Description:
	An online computer literacy course introducing operating system basics, Microsoft Windows, and Microsoft Word, Excel, and PowerPoint computer applications.  This course is created to equip students with the computer skills needed for future classes and help them become self-learners in order to adapt to new computer applications.  Timed application exams will be included. P/NP credit only.
Entry Level Standards:
	Keyboarding skill of 28 wpm (minimum).
Prerequisites:
	OST 1100 -- Keyboarding I or equivalent
Textbook(s) and Other Course Materials:
	TBA
I. Week/Unit/Topic Basis:
	Week					Topic
	1-2					Windows 2000 : Introduction to Microsoft Windows 2000  Test 1: Windows 2000
	3-8					Word 2002: Creating, editing, formatting a document; working with tables and using Word utilities.  Test 2: Word 2002
	9-13					Excel 2002: Learning the basics of Excel, editing and formatting a worksheet, using formulas, inserting charts, integrating Excel with Word and the Internet.  Test 3: Excel 2002
	14-15					PowerPoint 2002: Creating and animating a PowerPoint presentation using graphic, audio and video elements; integrating PowerPoint with Office and the Internet.
	16					Test 4:  PowerPoint 2002
II. Course Objectives*:
	A.			To demonstrate basic fundamentals of Microsoft Windows 2000 concepts. I, II,III, VI, IX
	B.			Use basic windows utilities such as multitasking; formatting and copying disks; copying and deleting files; and creating and opening folders. I, III
	C.			Use Microsoft Word operations to create, edit, enhance, and print documents. I, II, III, VI, IX
	D.			Use Microsoft Excel to enter, calculate, and manipulate data in a worksheet and integrate with Word 2002. I, II, III, VI, IX
	E.			Use Microsoft PowerPoint to produce graphical presentations and integrate with Office XP. I, II, III, VI, IX
*Roman numerals after course objectives reference goals of the university parallel program.
III. Instructional Processes*:
Students will:
	1.				Use technology to promote the objectives of this course; specifically,  the Internet, email, and Word, Excel and PowerPoint computer applications. Technological Literacy Outcome
	2.				Use email to communicate problems, questions, and issues to instructor. Communications Outcome
	3.				Use a personal computer, browser software, and the Internet, to read and respond to tutorials on how to use the application packages presented in this course to gain user proficiency. Technological Literacy Outcome and Problem Solving and Decision Making Outcome and Information Literacy Outcome
	4.				Use the skills and applications taught in the Train-It tutorials in actual work required in exercises that simulate real-world applications. Transitional Strategy
	5.				Download applications from the Web and install the applications on the student's personal computer to complete research activities required in exercises. Active Learning Strategy
*Strategies and outcomes listed after instructional processes reference Pellissippi State’s goals for strengthening general education knowledge and skills, connecting coursework to experiences beyond the classroom, and encouraging students to take active and responsible roles in the educational process.
IV. Expectations for Student Performance*:
Upon successful completion of this course, the student should be able to:
	1.			Describe Microsoft Windows 2000 and user interface. A
	2.			Identify the objects on the Microsoft Windows 2000 desktop. A
	3.			Perform the basic mouse operations: point, click, right-click, double-click, drag, and right-drag. A
	4.			Open, maximize, minimize, restore, and close a Windows 2000 window. A
	5.			Resize and move a Windows 2000 window. A
	6.			Scroll in a window. A
	7.			Understand keyboard shortcut notation. A
	8.			Start an application program in Windows 2000. A
	9.			Format a disk. B
	10.			Create folders; copy files and change file attributes. B
	11.			Rename, move and delete a file or folder. B
	12.			Start Microsoft Word. C
	13.			Identify the components of the Word screen. C
	14.			Change the default font size of text and enter text into a document. C
	15.			Spell check a document in Word. C
	16.			Save and print a document in Word. C
	17.			Select, deselect and replace text. C
	18.			Cut and paste selected text. C
	19.			Change the font type, size and emphasis. C
	20.			Apply character effects and insert symbols. C
	21.			Work with paragraph alignment, line spacing and indents. C
	22.			Use format painter. C
	23.			Work with tab stops. C
	24.			Set margins and insert page numbers. C
	25.			Create, edit and format headers and footers. C
	26.			Create and revise columns. C
	27.			Create, edit and format tables. C
	28.			Use Word utilities. C
	29.			Create and format worksheets. D
	30.			Apply basic formulas in Excel. D
	31.			Use relative and absolute references in formulas. D
	32.			Create and edit charts in Excel. D
	33.			Delete, insert, move and rename sheets. D
	34.			Work with multiple worksheets. D
	35.			Integrate Excel with Word and the Internet. D
	36.			Create sequential text and number headings. D
	37.			Copy, delete, insert and hide sheets. D
	38.			Insert, delete, hide and unhide rows and columns. D
	39.			Use Format Painter and apply Autoformats. D
	40.			Define, apply and remove styles. D
	41.			Freeze panes. D
	42.			Create, edit and print a presentation in PowerPoint. E
	43.			Work with graphic, audio, and video elements in a presentation. E
	44.			Sort, animate and add transitions to slides. E
	45.			Set timings for a presentation. E
	46.			Use slides from another presentation. E
	47.			Insert Word tables and import Excel charts to slides. E
	48.			Export a presentation to an outline. E
	49.			Save presentation as a Web page. E
*Letters after performance expectations reference the course objectives listed above.
V. Evaluation:
	A. Testing Procedures:  80 percent
			Four tests, one over each of the following components will be given:   Windows, Word, Excel, and PowerPoint.
	B. Laboratory Expectations:
		N/A
	C. Field Work:
		N/A
	D. Other Evaluation Methods:  20 percent
		Complete tutorial and application assignments over each of the following components:  Windows, Word, Excel, and PowerPoint.
	E. Grading Scale:
		The grade for this course is pass/no-pass.  Students must pass all four exams – Windows,  Word, Excel and PowerPoint – at 75 percent or higher and must satisfactorily complete a minimum of 80 percent of the tutorial assignments and the applications assignments.
VI. Policies:
	A. Attendance Policy:
		Pellissippi State Technical Community College expects students to attend all scheduled instructional activities.  As a minimum, students in all courses must be present for at least 75 percent of their scheduled class and laboratory meetings in order to receive credit for the course (Pellissippi State Catalog).
	B. Academic Dishonesty:
		Plagiarism, cheating, and other forms of academic dishonesty are prohibited. Students guilty of academic misconduct, either directly or indirectly through participation or assistance, are immediately responsible to the instructor of the class. In addition to other possible disciplinary sanctions which may be imposed through the regular Pellissippi State procedures as a result of academic misconduct, the instructor has the authority to assign an F or a zero for the exercise or examination or to assign an F in the course. (Reference, PSTCC Catalog)
	C. Other Policies:
		Students must have a valid PSTCC ID to be presented on demand to gain access to PSTCC facilities.