Mrs. Rucker's Business Education Activities and Resources

Computer Applications

Course Rationale: This area of instruction provides content for knowledge and skills required in the technology-based workplace. The demand will continue to expand for individuals to interact with the computer to create documents, gather information, and solve problems. The content of this class is vital for students planning to enter the workforce or post secondary education.

SAM 2010 Log-in

Resources:	Point Value	Due Date
*Textbook: Century 21
HPJ Communication Specialist
*Textbook: Shelly Cashman Microsoft Office 2007 Introductory Concepts and Techniques ~ Windows XP Edition
Textbook Website/Resources
Microsoft Office Assignments/Links for Word, Excel, PowerPoint, Access		Computer Apps College Credit Starting here 8-17-11
Publisher:
Tabs - Menu Assignment Save in your Publisher folder as Menu_Project_YourName	70
Tabs - Review
Certificate Assignment save as *certificate_yourname*
Business Card Assignment
Calendar Assignment
Marker Board Assignment - Web PDF	20
Halloween Recipe Cards - Web You will need to bring in your favorite recipe to complete this project.	50

Sample Formats:
Block
Business Letter
Business Letter-Personal
Memo
Modified Block Letter
Report
Table
Title Page

Christmas Memo
Memo to Santa
Sample Memo to Santa

Christmas Calendar
Calendar Project

	First/Second Quarter Assignments
Assignment #	Assignment	Point Value	Due Date
1	Lesson 22: Memos (save all in your Memo folder)
2	Lesson 22, p61, Memo 1, Save as memo22b1 (word count-152)	10
3	Lesson 22, p61, Memo 2, Save as memo22b2 (word count-134)	10
4	Lesson 22, p61, Memo 3, Save as memo22b3 (word count-157)	10
	Lesson 24: Memos (save all in your Memo folder)
5	Lesson 24, p64, Memo 1, Save as memo24b1 (word count-158)	10
6	Lesson 24, p65, Memo 2, Save as memo24b2 (word count-170)	10
7	Lesson 24, p65, Memo 3, Save as memo24b3 (word count-134)	10
	Lesson 28: Personal-Business Letters (create a personal_business_letter folder)
8	Lesson 28, p84 & p83, Letter 1, Save as ltr28b1 (word count - 176)	10
9	Lesson 28, p84, Letter 2, Save as ltr28b2 (word count-169)	10
	Lesson 29: Personal-Business Letters
10	Lesson 29, p86, Letter 2, Save as lter29b2 (word count-166)	10
11	Lesson 29C, p86, Envelopes, Save as env29c1 and env29c2 (we will do these together)	10 (5pts each)	complete together
	Lesson 30: Personal-Business Letters
12	Lesson 30, p87, Letter 1, Save as ltr30b1 (word count-193)	10
13	Lesson 30, p88, Letter 2, Save as ltr30b2 (word count-141)	10
14	Lesson 30, p88, Letter 3, Save as ltr30b3 (word count-130)	10
	Lesson 55: Review of Personal Business Letters
15	Lesson 55, p161, Letter 1, Save as lter55b1 (word count-224)	10
16	Lesson 55, p161, Letter 2, Save as lter55b2 (word count-126)	10
	Lesson 56: Business Letters
17	Lesson 56, p163, Letter 1, Save as lter56c1 (word count-224)	10
18	Lesson 56, p163, Letter 2, Save as lter56c2 (word count-111)	10
	Lesson 57: Business Letters
19	Lesson 57, p164, Letter 1, Save as lter57b1 (word count-136)	10
20	Lesson 57, p164, Letter 2&3, Save as lter57b2 (word count-227)	10
21	Lesson 57, p164, Letter 2&3, Save as lter57b3 (word count-258)	10
	Lesson 58: Format Letters with Special Parts
22	Lesson 58, p166, Letter 1, Save as lter58b1	10

	Word Processing 4 pages 90-93 Create a new folder in your Computer Apps folder called tables. Save the following activities in your new tables folder.
	Activity 1 - Together Save as WP4_Act1	10
	Activity 2 - Together Save as WP4_Act2	5
	Activity 3 - Together Save as WP4_Act3	20
	Activity 4 - Together Save as WP4_Act4	5
	Activity 5 - Together Save as WP4_Act5	5
	Activity 6 - Together Save as WP4_Act6	10
	Activity 7 - Together Save as WP4_Act7	10
	Activity 8 - Assignment Save as WP4_Act8	10
	Activity 9 - Assignment Save as WP4_Act9	10

	Second/Third Quarter Assignments
Assignment #	Assignment	Point Value	Due Date
	Mail Merge - Century 21
	(create a mail merge folder in your computer apps folder)
1	Lesson 114B, p306, Create Data Source File and Mail Merge. Save as lesson114B	20
2	Lesson 114C, p307, Mailing Labels. Save as lesson114C	10
3	Lesson 115B, p308, Personalized Form Letter. Save as lesson115B You are to type the form letter without the fields in them. I will show you how to add the fields when I get back. You are to make sure you have the data source completely typed. All fields should be complete.	30
4	Lesson 115C, p308. You are to edit the data source and save it as lesson115C. Complete all three steps. Print your data source with your name, date and assignment in the header.	20
5	Next you are to make labels using the data source you just saved as lesson115C. You are to create a new document. You are to use the step by step mail merge wizard. Print your updated mailing list with your name bolded* in the bottom right hand label.* Save your labels as lesson115C_labels	20
6	Lesson 115G, p310. You are to create a new document. You are to type the Personalized Form Letter and then add the mail merge features using the step by step mail merge wizard. Save as lesson115G. DO NOT PRINT YET. Use the data source from 114B. Sort by last name in ascending order. Instead of company use last name to show me that you know how to complete a mail merge on your own. After you have completed the mail merge, I want to view it. Save it as lesson115G_Letters.	20
7	Mail Merge for your class - You are to type all of your classmates name in a table in Word with the following headings: First Name, Middle Name, Last Name, Parents Name, Address, City, State, Zip, Phone. Print your source document with your name in the header. You are to change your page orientation to landscape. You are to fit the table to contents and then fit to window. Save in your Mail Merge folder as Class_Mates_Grad_Year example: Class_Mates_2013	40
8	You are to create labels using your classmates names. You are to create a new blank document. Select the mailing tab. Select mail merge/step by step mail merge. Follow the steps to complete the merge. Chose the Avery US Letter 5160 labels. Class_Mates_Grad_Year is your source document. You are to print your labels Put your name in the last cell in the bottom right hand corner. Save as Class_Mates_Grad_Year_Labels	30