October

Mon

Tue

Wed

Thur

Fri

1
Today you need to finish up your letterhead and your letter. Please submit both to the Inbox by the end of the period.

Remember, you need to include a bulleted list in your letter. If you wish, and have time, you may create custom bullets by following the steps below.

Add picture bullets or symbols to a list (Word 2007)

The Bullet Library includes symbol and picture bullet styles. If you don't see the style that you want in the library, you can define a new bullet style.

Select the items to which you want to add picture bullets or symbols.

To change an entire list level in a multilevel list, click one bullet or number at that level in the list.

On the Home tab, in the Paragraph group, click the arrow next to Bullets.

3. Click Define New Bullet, and then click Symbol or Picture.

Click any symbol or picture that you want to use, and then click OK twice.

After you create a bulleted item, each time you press ENTER, another bulleted item is automatically added until you press ENTER twice.

After you finish, go ahead and start on the next assignment, the press release.

All assignments up to your Block Letter must be turned in by the end of the period TODAY! NO CREDIT FOR LATE ASSIGNMENTS.

Today you will work on a press release. A press release is a document sent to news agencies such as TV stations, radio stations, and newspapers. It is meant to give information about an upcoming event that might be of interest to the public. Click here for an example of a PRESS RELEASE. Use Word to create your document. It is due by the end of the period on 10/6.

Click here for a template of the Press Release.

The two press release assignments:

1. Planning sheet, you must turn this in.

2. The typed press release.

Turn in your Press Release Document. Be sure to follow the format on the template and complete on your Letterhead.

As the owner, it is important to make sure that the players’ training facility is fully equipped with proper training equipment for the players to use. In this section, you will generate a list of training equipment for the team’s training facility and the quantity needed of each item.
Skills Utilized:
Use the table feature in Microsoft Word to create an equipment inventory list
Tactics:
•Use the Internet to research the types of training equipment typically used in your particular sport
•Decide on ten different types of equipment and the quantity necessary for each item for a state‐of‐the‐art facility

Things to turn in:

1.Follow the instructions and complete the Planning Form
2.Use Microsoft Word, create a new document
3.Save as Period_lastname_Inventory

General Instructions

4.Set all margins to 1 inch
5.Insert your team logo at the top of the page
6.Below your team logo, center align the name of your team’s facility
7.Below the name of the training facility, center align the following title “Estimated training Equipment Inventory.”
8.Using the table feature, insert a table with 11 rows and 8 columns
9.Be sure to include the column headings from the Planning Form

Column One: Equipment
Column Two: Estimate the number needed (A baseball team may need 1000 baseballs)
Column Three: Store/Company Name
Column Four: Price
Repeat Columns Three and Four two more times

10.Format the table using your team colors
11.Carefully proofread your work for accuracy, design, spelling and grammar
12.Resave the document
13.Turn‐in electronically to the Inbox no later than Wednesday.

Click here for an example

6^th, Make-Up/Catch Up

7th
W-6 Player Personnel Form: Creating a document for gathering player information

Goal:

A personnel form is used by organizations to collect vital data about their employees. In this project, you will design a personnel form to collect important information about each of your players.

Skills Utilized:

Use the table feature in Microsoft Word to create a player personnel form

Tactics:

Use the Internet to research personnel forms and use them as a guide in creating and designing your own
Choose an easy-to-read font with a maximum point size of 12-14 points

Instructions:

Follow the instructions and complete the Planning Form
Use Microsoft Word, create a new document
Save as period_lastname_ player personnel form folder that you have created in your Documents > Focus
Insert your team logo at the top of the page
Use the table feature to create a personnel form that looks like the example.(Click Below)
Use merge and split cell table features to make your cells an appropriate size for data
Format the text, columns, and rows so that the personnel form projects a professional image and include your team's colors.
Using the example, enter the data inside the table
Be sure to include the column headings from the Example
Carefully proofread your work for accuracy, design, spelling and grammar
Resave the document
Tomorrow we will convert it to a PDF and insert fields.

*Have at least 30 cells

Click here for the EXAMPLE form.

Turn in the Planning Form (5 points) and the Table (10 points), for this project

Finish player personnel form and convert to an electronic form using Adobe PDF.

Goal:

A spreadsheet containing player information and salaries.

Skills Utilized:

Use the sort and auto sum features in an Excel Document

Tactics:

Use the Internet to research salaries for players
Copy your Roster into an new Excel Document
Total your player salaries

Instructions:

1. Copy and paste your roster into an Excel Document

2. Add a column titled SALARY

3. Use the internet to look up average salaries for players and positions

4. Assign each member of your team a salary based on experience and talent

5. Use the Auto Arrange/Sort function to organize salaries lowest to highest

6. Use the Auto Sum function to add team salaries. Be sure to label the cell to the left "Salary Total".

7. Save document in your H Drive. Period_LastName_Salary

Today we will continue working on Dream Team Excel Workbook that we began yesterday and begin an "Mail Merge" Assignment.

1. Open up your saved document and complete the following:

Copy information on S

heet 1 and paste to Sheet 2.

Rename Sheet 1 "Salaries" Delete all information from this sheet except player names and salaries. Right click to rename and color code Sheet 1 Tab.
Name and color Code Sheet 2. Call it addresses
Delete all information on Sheet 2 except for Player Names and Jersey Numbers
Add 4 Columns on Sheet 2. Name the columns (Address, City, State, Zip Code)
Create Addresses for each player

Save this as period_Lname_MailMergeInfo

2. Open up a blank Word document and create the following memo. Remember the memo information we used before?

Include: Date, To, From, RE, and logo at the top
Write a short memo asking players to verify the information that will go on the back of their jersey
Be sure to indicate who they should contact if they have any changes
Save this document and title it Period_LastName_mergememo

Tomorrow we will complete the mail merge together so your documents need to be finished.

13
Today we will be performing a mail merge between the Excel workbook and memo you created yesterday.

Below are the audio and text instructions:

If you are using Word 2007 Click here:

http://office2010.microsoft.com/en-us/training/how-it-works-RZ010277841.aspx?lc=en-us&section=2

If you are using Word 2003 Click here:

http://office.microsoft.com/training/training.aspx?AssetID=RC011205671033&ofcresset=1

14
Finish your mail merge assignments. Please show me that the merge works to get credit...

Next Assignment:

Create a schedule using EXCEL for your team. Your schedule should include the following information:

1. Put Logo on schedule

2. Put Main title centered at the top.

3. Columns: Date, Opponent, Location, Time

4. Color each row for away games

5. Format professionally

The schedule should have 12 games total. Half should be home and half should be away.

Save document as Period_lastname_schedule and submit to the Inbox.

Open up the Excel Document and practice using formula functions. Use the Help function to figure out how to write different formulas if you need. Turn in to the Inbox when finished. Be sure to name Period_lastname_formulapractice.

There are 4 Sheets in the document. Each sheet must be completed to earn credit.

E-4 Projected Revenue from the Ticket Sales

Goal:

A spreadsheet can be used to calculate values to help a business determine how well a product is performing. In this project, you will create an Excel spreadsheet to project the revenue (sales) that your team will receive from ticket sales. These projections will help the team with budgeting during the season

Skills Utilized:

Use Microsoft Excel to calculate ticket sales revenue

Tactics:

· Use proper currency style in formatting the dollar amounts on the worksheet

Instructions:

Follow the instructions provided and complete the Planning Form
Use Microsoft Excel, create a new workbook
Save as lastname_E-4 projected revenue to The Dream Team folder that you have created in your Documents > Focus
In cell A-1, enter the following title: <name of the stadium> Projected Ticket Sales Revenue
In cell A-2, enter the following subtitle: Based on a stadium seating capacity of 65,000
In cells A3 through E3, enter the following column headings:

Section
Price
# of Seats
# of Home Games
Total Sales

Bold and center align the text in cells A3 through E3
Using the information from the Planning Form, enter the appropriate data into the correct columns
Enter a formula in cell E4 to compute the Total Sales for the first section
Copy and paste the formula in cell E4 to cells E5 through E8
In cell D9, enter the following text: Total Projected Sales
Enter a formula in cell E9 to compute the Total Projected Sales for all the sections
Format column E as currency showing the “$” symbol and zero decimals
Merge and center align the title (cell A1) across the five columns of the worksheet
Merge and center align the subtitle (cell A2) across the five columns of the worksheet
Format the title, subtitle, and column headings with an appropriate font size and style
Center align cells D4 through D9
Format the worksheet using your team’s colors
Rename the worksheet tab Tix Sales
Carefully proofread your work for accuracy
Resave the file
Turn-in electronically to the Inbox

Today you will be adding charts to your Ticket Sales Spreadsheet. In order to do this, you spreadsheet data must be complete.

Insert a pie chart and a bar chart containing data about your projected ticket sales.
It must show potential revenues from all sections and the percentage of revenue that each section could generate.
Include a key and a title on your charts
Select colors
Move both charts to Sheet 2 of your spreadsheet.
Rename Sheet 2
Below the charts answer the following question: Which chart works best for displaying the percentage of sales and why?

Rename your spreadsheet Period_Name_charts

Finish adding your charts to your Ticket Sales Spreadsheets. See directions above for naming and turning in your assignment to the Inbox.

Today you are going to begin using Publisher to design and create various items for your team. The first item is a business card.

DTP-1 Business Card: Marketing your team to the public

Goal:

A business card is a small, printed card usually containing a person’s name, business affiliation, job title, address, telephone and fax numbers, and email/website addresses. In this project, you will create a business card for yourself as the owner of your dream team. Since you will be talking to and meeting with a lot of people in the community, you will need something to give them so they will remember you and your new team, as well as your contact information.

Skills Utilized:

Use Microsoft Desktop Publishing, design and create a business card

Tactics:

· Business cards present a lot of information in a small space

· Experiment with different card layouts on paper before creating on the computer

· After the team logo, your name should be the largest piece of information on the card

· Obtain some samples of real business cards for inspiration to help you design your own

Instructions:

1. Follow the instructions and complete the Planning Form .

2. Show your teacher your planning sheet and get your design approved.

3. Use Microsoft Desktop Publishing, create a new document

4. Save as lastname_DTP-1 Business Card to The Dream Team folder that you have created in your Documents > Focus

5. Set up your document by selecting File, Publications for Print, Business Card.

6. On your document, include the information from one of the sketches you created on the Planning Form

7. Format the size and placement of the text and other elements on the business card so that they are in proportion with each other and project a professional image

8. Arrange your team logo and text to fit your letterhead design

9. Carefully proofread your work for accuracy, design, spelling and grammar

10. Resave the document

11. Turn-in electronically to the Inbox

Caught up on recent work.

1. Complete business card and submit to Inbox before you begin next project

Today you will be making two items: VIP Ticket and T-shirt

Below are the directions for each assignment. You must complete the planning form for the VIP ticket before beginning this assignment. You will not earn credit for VIP Ticket if you do not get your planning form approved by me first.

Assignment 1

DTP‐2 VIP Pass: Creating a VIP pass for your luxury suite

Goal:

A VIP (Very Important Person) pass is a special ticket that allows the holder access to premiere locations within a facility. One of the many benefits of being an owner of a professional sports franchise is that you get a luxury suite to watch all of the games. Your task is to create a VIP pass for your guests. The VIP pass will allow your guests access to your luxury box suite for a home game of your choice.

Skills Utilized:

Use Microsoft Desktop Publishing, design and create a VIP pass

Tactics:

Since the VIP pass has a limited amount of space available, all important information should be in proportion with all elements
Use a maximum of one or two fonts on your VIP pass
Use a font that is easy to read

Instructions:

1. Print out and follow the instructions and complete the Planning Form

2. Use Microsoft Desktop Publishing, create a new document

3. Save as lastname_DTP‐2 VIP Pass to The Dream Team folder that you have created in your Documents > Focus

4. Set up your document using the Page Setup Instructions that we went over yesterday.

5. On the blank document, include the information from one of the sketches you created on the Planning Form

6. Add additional elements and/or graphic images that will help illustrate and enhance the look of the pass

7. Format the size and placement of the text and other elements on the VIP pass so that they are in proportion with each other and project a professional image

8. Carefully proofread your work for accuracy, design, spelling and grammar

9. Resave the document

10. Turn‐in electronically to the Inbox

Assignment 2

DTP‐3 T‐shirt Design: Designing a fan T‐shirt

Goal:

Any type of T‐shirt that includes a company logo and slogan offers businesses a walking from of free advertising. In this project, you will design a t‐shirt for your team to be sold at your stadium as well as in local department stores. The design should include a catchy slogan that really sets your fans apart from all others in the league.

Skills Utilized:

Use Microsoft Desktop Publishing, design and create a T‐shirt for your fans

Tactics:

If including a graphic image, be sure it’s large enough to be seen, and keep it simple so that the viewer can tell what it is
Do not clutter the t‐shirt design with too much text or too many graphic images
Keep it clean and simple
Create a catchy slogan that really makes this t‐shirt a "must have" item for your fans

Instructions:

1. Copy the image into PowerPoint, right click and save it as a jpg (or get it out of the assignments folder) . You will use this to layout your design.

2. Use Microsoft Desktop Publishing, create a new document

3. Save as lastname_DTP‐3 t‐shirt to The Dream Team folder that you have created in your Documents > Focus

4. Set up an appropriate size document and place the t-shirt image on your page

5. Format the size and placement of the text and other elements on the t‐shirt so that they are in proportion with each other and project a professional image

6. Carefully proofread your work for accuracy, design, spelling and grammar

7. Resave the document

8. Turn‐in electronically to the Inbox

26
Finish up your t-shirt design and your VIP Tickets before you begin the next assignment

Create a flyer for your opening game which includes the following information:

Your team name and your oppenent
The phrase "Home Game Opener on <Insert Date>"
Name of your stadium and time
A headline that announces this is your opening game
A list of special events and fan incentives
Contact information

Tactics:

Use a maximum of one or two fonts on your Flyer
Use fonts that are easy to read
Use a table and create a schedule of Home games
Include key graphic elements such as your logo and pictures of players
Create a background that is simple, yet interesting and compliments your overall design
Use a maximum of THREE key colors in your design

Instructions:

Open up a blank publisher document.
Choose a full- page size 8.5x11 inches
Save as Period_Name_Flyer
Create your flyer with all of the above elements
Carefully proofread your work for accuracy, design, spelling, punctuation and grammar
Resave the document

Turn in electronically to the Inbox

*Get in any remaining Dream Team projects, then:

Today we will begin keyboard skill practice.

First, open up a blank Excel work book. Name it Period_LastName_Keyboard

Create colums with the following labels: "Date" "Test #" "WPM" and "Errors"

Next,

1. Login to the following website and to take your first test. http://www.freetypinggame.net/

2. Click on the tab labeled "Tests" and select "Test #1" for a length of "5 minutes"

3. Record your results on your Excel document

4. Click on the tab called "Lessons" and work on Lesson #1-Lesson #4. You may continue to work on the next lset of lessons in succession OR...

5. Click on the tab called "Games". These games are intended to help you learn the different key placements on the keyboard. Some are more challenging than others. You will find that the more lessons you complete the easier the games become. You may also customize the game to fit the skills you need the most practice on. In addition, this is a good way to practice your keyboarding skills before the next Test.

This will establish your baseline score and you will be able to track your improvement over the next few weeks. Each Friday, you will take a new test and record your result in your Excel workbook.

Each day for the first 10 minutes of class we will practice keyboarding using the different games. If you are finished early with an assignment you may get extra practice by playing the various games.

Remember, the more you practice the faster and more accurate you will become.

After you finish, take the

netiquette test, get a perfect score, print it out and turn it into the basket on my desk.

Period 1 7:30-8:27

Period 2 8:33-9:30

Period 3 9:36-10:30

Start the Web Page (alternate for people who are out). Can be completed in Word or Frontpage.

Period 4 7:30-8:27

Period 5 8:33-9:30

Period 6 9:36-10:30

Start Career and Income

Link to website needed for above assignment.

Link to part II of above assignment

Continue CC presentations

Bullets Assignment in Word

Bullets PP

Bullets Assignment in Word

Career and Income

Wrap up Web Pages and netiquette

Start Flash unit:

Create a pencil and lead across a paper.

Remember to turn in the whole folder to the inbox, name it like we always do, example, 4_Flash2_Lname, First

Use what we covered in Flash, create:

1. 2 pictures

2. A shape tween

3. 2 keyframes

4. A motion tween that interacts with the two pictures, like the pencil with the lead.

As an alternative to the above assignment, you can complete this

assignment:

Flash 2

We are starting Dreamweaver tomorrow, the deadline for this is Thursday, use Panther Period if you have to.

Dreamweaver Introduction

Using Dreamweaver, we’ll cover together in class using a template, putting in a Spry toolbar, putting in a table, putting in a picture, putting in a hyperlink, saving 3 pages, and linking the pages together.

If you weren’t here, try to get information from your neighbor first, as Mr. Harris will likely be too busy to recreate the class..

Create a web page

Add to the web page we created yesterday, create a web page with:

A topic (5 pts) (a small business webpage). If you can’t think of anything, create a lawn-mowing business

4 pages (5 pts)

3 hyperlinks. (3 pts)

A coupon you make in Photoshop.

A Spry Toolbar with 4 pages. (8 pts)

Background color change, font formatting change. (2 pts)

Today is the last day to turn in the Flash projects from earlier in the week.

Wrap up what we cover in class with web pages.

Wrap up web page.