Word Project One - Creating and Editing A Word Document in Word 2003

The project introduces Microsoft Word and using the Word window to create a document. Before entering any text in the document, students will learn how to change the font size. As students enter text, they will learn how to use Word’s check spelling as you type feature. Once the document is saved, students will format paragraphs and characters in the document. Next, they will insert and resize a clip art image. They will also discover how to save and print a document, quit Work, and open a document. Students will learn to move the insertions point so they can insert, delete, and modify text. Finally students will find out how to use the Word Help system to answer questions.

Students will have mastered the material in this project when they can:

Start and quit Word

Describe the Word window

Enter text in a document

Check spelling as they type

Save a document

Format text and paragraphs

Undo and redo commands or actions

Insert clip art in a document

Print a document

Open a document

Correct errors in a document

Use Word’s Help to answer questions





Word Project 2 - Creating a Research Paper

Reports are required in both academic and business environments. Business reports range from proposals to cost justifications to five-year plans to research findings. Academic reports focus mostly on research findings. A standard style should be followed when preparing a report. Many different styles of documentation exist for report preparation, depending on the nature of the report. Each style requires the same basic information; the differences among styles relates to how the information is presented. Two popular documentation styles for research papers are the Modern Language of America (MLA) and American Psychological Association (APA) style. BCIS I will be using the MLA documentation style.

The students will have mastered the material in this project when they can:

Describe the MLA documentation style for research papers

Change the margin settings and line spacing in a document

Use a header to number pages of a document

Apply formatting using shortcut keys

Modify paragraph indention

Add a footnote to a document

Count the words in a document

Insert a manual page break

Create a hyperlink

Sort selected paragraphs

Proof and revise a document

Use the Research task pane to locate information (discuss)

Display the Web page associated with a hyperlink (discuss)

E-mail a copy of a document (discuss)





Word Project 3 - Creating a Resume

At some time in their professional life, your student will prepare a resume along with a personalized cover letter to send to a prospective employer(s). In addition to some personal information, a resume usually contains the applicant’s educational background and job experience. A cover letter enables you to elaborate on positive points in your resume and provides you with an opportunity to show a potential employer your written communications skills. It is important that your cover letter is written well and follows proper business letter rules.

Composing documents from scratch can be a difficult process for many people. Microsoft Word provides wizards and templates to help prepared the documents. Your students will have mastered the material in Word Project 3 when they can:

Create a resume using Word Resume Wizard

Fill in a document template

Use print preview to view and print a document

Set and use tab stops

Collect and paste using the Clipboard task pane

Format paragraphs and characters

Remove formatting from text

Identify the components of a business letter

Insert the current date

Create and insert an AutoText entry

Insert a Word table, enter data into the table

Learn the rules for addressing and printing an envelope

Work with smart tags

Modify file properties

Excel Project 1 - Creating a Worksheet and an Embedded Chart

We are beginning the study of Microsoft Office Excel 2003. Excel is a powerful spreadsheet program that allows users to organize data, complete calculations, make decisions, graph data, develop professional looking reports, publish organized data to the Web, and access real-time data from Web sites. The four major parts of Excel are:
• Worksheets: Allow users to enter, calculate, manipulate, and analyze date such as numbers and text. The term worksheet means the same as spreadsheet.
• Charts: Excel can draw a variety of charts.
• Lists: Lists organize and store data. Excel can sort the data, search for specific data, and select data that satisfies defined criteria.
• Web Support: Allows users to save worksheets in HTML format so a user can view and manipulate the worksheet using a browser. Excel Web support also provides access to real-time data, such as stock quotes, using Web queries.

Students will have mastered the material in this project when they can:
• Start and quit Excel
• Describe the Excel worksheet
• Enter text and numbers
• Use the AutoSum button to sum a range of cells
• Copy a cell to a range of cells using the fill handle
• Format a worksheet
• Create a 3-D clustered column chart
• Save a workbook and print it
• Open a workbook
• Use the AutoCalculate area to determine statistics
• Correct errors on the worksheet
• Use the Excel Help system to answer questions.

Assignments for Excel 1
Chapter Problem with embedded chart Written Test
In The Lab 1 Lab Test
In the Lab 2
In The Lab 3
Cases & Places 1
Cases & Places 2
Cases & Places 3
Cases & Places 4

Excel Project 2 - Formulas, Functions and Formatting

In the previous Excel project, students learned how to enter data, sum values, format the worksheet to make it easier to read, and draw a chart. They also learned about Help and saving, printing, and opening a workbook. Project 2 continues to emphasize these topics and present new ones.

The new topics covered in this project include using formulas and functions to create a new worksheet. Other new topics include smart tags and option buttons, verifying formulas, adding borders, formatting numbers and text, using conditional formatting, changing the width of columns and heights of rows, spell checking, renaming worksheets, and using alternative types of worksheet displays and printouts. One alternative worksheet display and printout shows the formulas in the worksheet, instead of the values. When you display the formulas in the worksheet, you see exactly what text, data, formulas, and functions you have entered into it.

Students will have mastered the material in this project when they can:
• Enter formulas using the keyboard and Paint mode
• Recognize smart tags and option buttons
• Apply the AVERAGE, MAX and MIN functions
• Verify a formula using Range Finder
• Format a worksheet using buttons and commands
• Add conditional formatting to a range of cells
• Change the width of a column and height of a row
• Check the spelling of a worksheet
• Preview how a printed copy of the worksheet will look
• Print a partial or complete worksheet
• Display and print the formulas version of a worksheet
• Rename sheets in a workbook

Assignments for this project:
• Chapter Problem
• In The Lab 1
• In The Lab 2
• Cases and Places 1
• Cases and Places 2
• Cases and Places 3
• Cases and Places 4

Excel - Project 3


In this project, students learn how to work with large worksheets that extend beyond the window, how to use the fill handle to create a series, and some new formatting techniques. They learn how to show hidden toolbars, dock a tool bar at the bottom of the screen, and hide an active toolbar. They learn about the difference between absolute cell references and relative cell references, and how to use the IF function. They also learn how to rotate text in a cell, freeze titles, change the magnification of the worksheet, show different parts of the worksheet at the same time through multiple panes, create a 3-D Pie chart, and improve the appearance of a 3-D Pie chart. Finally, this project introduces students to using Excel to perform what-if analysis by changing values in cells and goal seeking.

At the completion of this project, students should know how to:
• Start and customize Excel
• Bold the font of the entire worksheet
• Rotate text and use the fill handle to create a series of month’s names
• Copy a cell’s format using the painter button
• Copy a range of cells to an nonadjacent destination area
• Insert a row
• Enter numbers with format symbols
• Freeze column and row titles
• Enter and format the system date
• Enter a formula containing absolute cell references
• Enter an IF function
• Determine row totals in nonadjacent cells

The following problems may be assigned:

Chapter Problems—Aquatics Wear
In The Lab 1—Shawshank Manufacturing
In The Lab 2—Casa Grande Resort & Spa
(Other problems may be assigned )
Written Test
Lab Test

If you have any questions or concerns about the material we are covering or your student’s progress, please call at 903-731-8076 or email at mann@palestineschools.org


Access - Project 1

Our next project is Creating and Using a Database. Microsoft Office Assess 2003 is a powerful database management system that functions in the Windows environment and allows you to create and process data in a database. Some of the key features are:

• Data entry and update: Access provides easy mechanisms for adding, changing, and deleting data, including the capability of making mass changes in a single operation.
• Queries (questions): Access makes it possible to ask complex questions concerning the data in the database and then receive instant answers.
• Forms: Access allows the user to produce attractive and useful forms for viewing and updating data.
• Reports: Access report creation tools make it easy to produce sophisticated reports for presenting data.
• Web support: Access allows you to save objects, reports, and tables in HTML format so they can be viewed using a browser. You also can import and export documents in XML format. Access’s capability of creating data access pages allows real-time access to data in the database via the Internet.

The following problems will be assigned:
Chapter Problem
In The Lab 1
In The Lab 2
In the Lab 3
Cases & Places 1
Cases & Places 2
Case & Places 3
Review
Lab Test
Written Test

Access - Project 2

We are starting the second project in Access. Access is a database management system and offers many useful features, among them the capability of answering questions. The answers to these questions are found in the database, and Access can find them quickly.
When you pose a question to a database system, they question is called a query. A query is simply a question represented in a way the Access can understand. Students will learn to ask questions of the databases we created in Project 1.

The following databases will be used:
Ashton James College
Birds2U
City Guide
College Dog Walkers
InPerson Fitness Company
Regional Books
Campus Housing

Upon completion of this project, student should be able to:
• Open a database
• Create a query
• Include fields in a design grid
• Run the query
• Print the results of a query
• Return to the select query window
• Close the query
• Include all field in a query
• Clear the design field
• Use text data in a criterion
• Use a wildcard
• Use a criteria for a field not included in the results
• Create and run a parameter query
• Save a query
• Use a saved query
• Use a number in a criterion
• Use a comparison operator in a criterion
• Use a compound criterion involving AND
• Use a compound criterion involving OR
• Sort data in a query
• Omit duplicates
• Sort on multiple keys
• Create a top-value query
• Join tables
• Change join properties
• Restrict the records in a join
• Use a calculated field in a query
• Change a format and a caption
• Calculate statistics
• Use criteria in calculating statistics
• Use grouping
• Create a crosstab query
• Close a database and quit Access

If you have any questions or concerns about this project, please email me at mamann@palestineschools.org or call me at 903-731-8076.


PowerPoint Project 1

Microsoft Office PowerPoint 2003 is a complete presentation graphics program that allows you to produce professional-looking presentations. A PowerPoint presentation is also called a slide show.

PowerPoint contains several features to simplify creating a slide show. For example, you can instruct PowerPoint to create a predesigned presentation, and then you can modify the presentation to fulfill your requirements. You quickly can format a slide show using one of the professionally designed presentation design templates. To make your presentation more impressive, you can add tables, charts, pictures, video, sound, and animation effects. Additional PowerPoint features include the following:
Word processing: create bulleted lists, combine words and images, find and replace text, and use multiple fonts and type sizes.
Outlining: develop your presentation using a outline format. You also can import outlines from Microsoft Word or other word processing programs
Charting: create and insert charts into your presentation. The two chart types are: standard, which includes bar, line, pie, and xy (scatter) charts; and custom, which shows such objects as floating bars and colored lines.
Drawing: form and modify diagrams using shapes such as arcs, arrows, cubes, rectangles, starts, and triangles.
Inserting multimedia: insert artwork and multimedia effects into your slide show. The Microsoft Clip Organizer contains hundreds of media files, including pictures, photos, sounds, and movies.

The following projects will be completed:
Chapter Problem
In The Lab 1
In The Lab 2
In The Lab 3—Part 1 and 2
Cases & Places 1
Cases & Places 2
Cases & Places 3
Cases & Places 4
Review
Written Test
Lab Test


At the end of Project 1, students should be able to perform the following.
Start PowerPoint
Customize the PowerPoint window
Choose a design template
Enter the presentation title
Enter the presentation subtitle
Change the text font style to Italic
Increase font size
Save the presentation
Add a new text slide with a bulleted list
Add a new slide and enter a slide title
Type a multi-level paragraph
Create a third-level paragraph
End a slide show with a black slide
Use the scroll box on the slide pane to move to another slide
Start slide show view
Move manually through slides in a slide show
Display the popup menu and to go a specific slide
Use the popup menu to end a slide show
Quit PowerPoint
Start the spell checker
Display a presentation in black and white
Print a presentation

If you have any questions or concerns, please email me at mamann@paletineschools.org or call and leave a message at 903-731-8076.


Access Project 3

Students are continuing their study of Microsoft Access with Project 3. Once a database has been created and loaded with data, it must be maintained. Maintaining the database means modifying the data to keep it up-to-date, such as adding new records, changing the data for existing records, and deleting records. Updating can include mass updates or mass deletions; that is, updates to, or deletions of, many records at the same time.

In addition to adding, changing, and deleting records, maintenance of a database can involves the need to restructure the database periodically; that is, to change the database structure. This can include adding new fields to a table, changing the characteristics of existing fields, and removing existing fields. It also can involve the creation of indexes, which are similar to indexes found in the back of books. Indexes are used to improve the efficiency of certain operations.

Projects to be completed:
• Chapter Problem—Ashton James College Database
• In The Lab 1—Birds2U Database
• In The Lab 2—Babbage Bookkeeping Database
• In The Lab 3—City Guide Database
• Review

What Students Should Know How To Do:
• Open A Database
• Use a Form to Add Records
• Search for a Record
• Update the Contents of a Field
• Switch from Form View to Datasheet View
• Use Filter By Selection
• Remove a Filter
• Use Filter by Form
• Use Advanced Filter/Sort
• Delete a Record
• Delete a Record in Form View
• Change the Size of a Field
• Add a Field to a Table
• Delete a Field
• Update the Contents of a Field
• Resize a Column
• Change the Font in a Datasheet
• Change the Format of the Datasheet Grid
• Use Print Preview
• Close the Datasheet Without Saving the Format Changes
• Use an Update Query to Update all Records
• Use a Delete Query to Delete a Group of Records
• Create an Append Query
• Specify a Required Field
• Specify a Range
• Specify a Default Value
• Specify a Collection of Legal Values
• Specify a Format
• Save the Validation Rules, Default Values, and Formats
• Create a Lookup Field
• Use a Lookup Field
• Specify Referential Integrity
• Use a Subdatasheet
• Find Duplicate Records
• Find Unmatched Records
• Use the Sort Ascending Button to Order Records
• Use the Sort Ascending Button to Order Records on Multiple Fields
• Create a Single-Field Index
• Create Multiple-Field Index
• Close a Database and Quit Access
• Backup a Database
• Compact and Repair a Database

PowerPoint Project 2

PowerPoint Project 2 is the last section of Office 2003 to be covered this year. It teaches an alternative to creating a presentation in the slide pane in normal view as done in
Project 1. PowerPoint 2 provides an outlining feature to help organize thoughts. When the outline is complete, it becomes the foundation for the presentation. Once the outline is complete, students will make their presentation more persuasive by adding clips, which are media files of art, animation, sound, and movies. Project 2 uses outlining to create the presentation and clip art to support the text visually.

Students should be able to perform the following tasks after completing Project 2.
• Start and customize PowerPoint
• Change to the outline tab and display the outlining toolbar
• Create a title slide on the outline tab
• Add a slide on the outline tab
• Create a text slide with a multi-level bulleted list on the outline tab
• Create a second text slide with a multi-level bulleted list
• Create a third text slide with a multi-level bulleted list
• Create a closing slide on the outline tab
• Save a presentation
• Change the view to slide sorter view
• Change the view to normal view
• Change the slide layout to title, text, and content
• Insert clip art into a content placeholder
• Change the slide layout to title, 2 content and text and insert clip art
• Insert a second clip into a slide
• Insert clip art into a slide without a content placeholder
• Use the automatic layout options button to undo a layout change
• Move clip art
• Change the size of clip art
• Insert, move, and size a clip into a slide
• Use the notes and handouts sheet to add headers and footers
• Add an animation scheme to a slide show
• Animate clip art
• Run an animated slide show
• Print an outline
• Print presentation slides
• Save changes and quit PowerPoint.

The following problems will be completed for PowerPoint Project 2
• Chapter Problem
• In The Lab 1
• In The Lab 2
• In The Lab 3
• Cases & Places 1
• Cases & Places 2
• Cases & Places 3
• Review
• Lab Test
• Written Test

After completion of this project, students will be reviewing Windows XP and Office 2003 as well as working on their final exam. The final will include an Excel project, an Access database with queries, and a PowerPoint presentation. The research for the final will be done on the Internet.

If you have any questions or concerns, please contact me at 903-731-8076 or email me at mamann@palestineschools.org.