PELLISSIPPI STATE TECHNICAL COMMUNITY COLLEGE 
MASTER SYLLABUS

INTRODUCTION TO SOFTWARE APPLICATIONS

OST 1211

Class Hours:  3.0

 

Credit Hours: 3.0

 

Laboratory Hours: 0.0

 

Revised: Fall  08

 

 

Catalog Course Description:

 

 

 

A computer literacy course introducing personal computers and computer applications software used in business. Emphasis is on developing computer operation skills using a basic operating system and Word, Excel, Access, and PowerPoint (Microsoft Office) software applications.

Entry Level Standards:

 

 

 

Keyboarding skill of 28 wpm (minimum).

Prerequisites:

 

 

 

OST 1100 or equivalent.

Textbook(s) and Other Course Materials:

 

 

1.         Microsoft Word 2007/Microsoft Excel 2007/Microsoft PowerPoint 2007/Microsoft Access 2007/Microsoft Windows XP (Five individual books which will be sold bundled together), Course Technology, Shelly Cashman Series, 2007. ISBN: 1423841764.

2.       Skills Assessment Manager (SAM) 2007, assessment and training license. ISBN: 142390348X.

3.        One USB drive for data storage (included in textbook bundle)

4.        A folder with pockets for turning in work

I. Week/Unit/Topic Basis:

 

 

 # of Weeks

Topic

Assessment

 5

Windows XP concepts: Understanding PC Fundamentals, Using Windows, and Using Basic E-Mail commands.

Word 2007--Project 2 (including Word 2007 basic concepts: Starting Word; Creating and Editing a Word Document; Spell Checking a Document, Centering a Paragraph, Changing Fonts, Enhancing Text, Inserting Clip Art). Creating a Research Paper using MLA documentation style, Creating a Text Hyperlink, Sorting Paragraphs, Finding and Replacing Text.

Word 2007--Project 3: Using Word's Resume Wizard to Create a Resume, Creating a Business Letter with Table, Collecting and Pasting Text, Switching Among Word Documents, Using Tabs.

(Lab Quiz on Business Letter formatting; other Lab Quiz optional)


APPLICATION TEST 1 (Windows XP, Word basic concepts, and Word Projects 2-3)

 3.5

Excel 2007--Project 1: Starting Excel; Creating and Editing a Worksheet, and Creating a Column Chart

Excel 2007--Project 2: Entering Formulas and Functions, Formatting Worksheets, and Creating Pie Charts.
Excel 2007-Project 3 (Optional)

APPLICATION TEST 2 (Excel Projects 1-2)

 3.5

Access 2007- Project 1: Starting Access, Creating a Table, Using Queries, Using a Form to View Data, Creating a Report, and Designing a Database

Access 2007-Project 2: Creating and Running Queries, Sorting Data in a Query

APPLICATION TEST 3 (Access Projects 1-2)

 2

PowerPoint 2007--Project 1: Starting PowerPoint, Using a Design Template and AutoLayouts to Create a Presentation
PowerPoint 2007--Project 2: Using Outline View and Clip Art to Create a Slide Show

PowerPoint 2007--Project 3 (Optional)

APPLICATION TEST 4 (PowerPoint Projects 1-2)

 

Final Exam--Student PowerPoint Presentations

II. Course Objectives*:

 

 

 

A.

Learn the terminology and concepts relevant to personal computing. (I, III)

 

B.

Use basic WINDOWS utilities such as multitasking; formatting and copying disks; copying and deleting files; and opening folders. (I, III)

 

C.

Use Microsoft Word operations to create, edit, enhance, and print documents. (I, III, VI, X, XI)

 

D.

Use Microsoft Excel to enter, calculate, and manipulate data in a worksheet. ( I, III, VI, XI)

 

E.

Use Microsoft Access to produce simple tables and queries. (I, III, VI, X, XI)

 

F.

Use Microsoft PowerPoint to produce informal graphical presentations. (I, III, VI, X, XI)

*Roman numerals after course objectives reference goals of the OST program.

III. Instructional Processes*: 

 

 

Students will:

 

 

 

 

1.

Refine reading skills and expand vocabularies through completion of reading assignments. (Communication Outcome, Active Learning Strategies.)

 

2.

Use technology to promote the objectives of the course; specifically, Microsoft Windows XP, Word 2007, Excel 2007, Access 2007, and PowerPoint 2007. (Technological Literacy Outcome)

 

3.

Develop spreadsheets, database tables, and word processing documents based on real workplace situations. (Mathematics Outcome, Transitional Strategies, Active Learning Strategies, Technological Literacy Outcome)

 

4.

Develop a professional-looking PowerPoint presentation and use oral communication skills to present the presentation. (Communication Outcome, Transitional Strategies; Active Learning Strategies, Technological Literacy Outcome)

 

5.

Internalize the work ethic by regularly attending class, being punctual, being dependable, and acting in a professional manner while in class. (Transitional Strategies; Active Learning Strategies)

*Strategies and outcomes listed after instructional processes reference TBR's goals for strengthening general education knowledge and skills, connecting course work 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.

Identify basic components of a microcomputer system. (A)

 

2.

Identify applications and operating systems levels of software. (A)

 

3.

Identify types of memory. (A)

 

4.

Identify types of storage. (A)

 

5.

Demonstrate ability to handle disks correctly. (A)

 

6.

Identify hardware used for input, output, storage, and processing. (A)

 

7.

Backup disks. (B)

 

8.

Describe Microsoft Windows XP and user interface. (B)

 

9.

Identify the objects on the Microsoft Windows XP desktop. (B)

 

10.

Perform the basic mouse operations: point, click, right-click, double-click, drag, and right-drag. (B)

 

11.

Open, maximize, minimize, restore, and close a Windows XP window. (B)

 

12.

Resize and move a Windows XP window. (B)

 

13.

Scroll in a window. (B)

 

14.

Understand keyboard shortcut notation. (B)

 

15.

Start Microsoft Word. (C)

 

16.

Identify the components of the Word screen. (C)

 

17.

Change the default font size of text and enter text into a document. (C)

 

18.

Spell check a document in Word. (C)

 

19.

Save and print a document in Word. (C)

 

20.

Select text, sentences, and paragraphs in Word and change the font; bold, underline or italicize the selected text. (C)

 

21.

Drag and drop selected text. (C)

 

22.

Center a paragraph in Word. (C)

 

23.

Insert and resize a picture in Word. (C)

 

24.

Correct errors in a Word document. (C)

 

25.

Use Microsoft Word Help. (C)

 

26.

Quit Microsoft Word. (C)

 

27.

Identify the Word screen in different view. (C)

 

28.

Replace selected text with new text in Word. (C)

 

29.

Insert a line break in Word. (C)

 

30.

Use AutoFormat as you type in Word. (C)

 

31.

Use print preview to view and print a document. (C)

 

32.

Format a business letter. (C)

 

33.

Zoom a document. (C)

 

34.

Create and insert an AutoText entry in Word. (C)

 

35.

Format characters using shortcut keys in Word. (C)

 

36.

Indent the left margin of a paragraph and indent paragraphs in Word. (C)

 

37.

Run spell check and grammar check in a Word document at the same time. (C)

 

38.

Switch from one open Word document to another and close all open documents. (C)

 

39.

Describe the MLA documentation style for research papers. (C)

 

40.

Change the margin settings in a Word document. (C)

 

41.

Adjust line spacing in a Word document. (C)

 

42.

Use a header to number pages of a Word document. (C)

 

43.

Use Word's AutoCorrect feature. (C)

 

44.

Insert a manual page break in Word. (C)

 

45.

Create a hanging indent in Word. (C)

 

46.

Create a text Hyperlink in Word and display the Web site associated with a Hyperlink. (C)

 

47.

Sort selected paragraphs in Word. (C)

 

48.

Scroll by a page in Word. (C)

 

49.

Find and replace text in Word. (C)

 

50.

Use Word's thesaurus feature. (C)

 

51.

Know the parts of the Excel worksheet and be able to efficiently access different features in the toolbar and menus. (D)

 

52.

Enter text and numbers and then select and copy these cells. (D)