Computer Applications

Home Multiculturalism Desktop Publishing Computer Applications 8th Grade Computer Applications Accounting 21st Century Skills Web Page Design Entrepreneurship Adv Computers Audiovisual Production 6th Grade

  Monday Tuesday Wednesday Thursday Friday
May 20-24 Database Ex 4 Tests SEMESTER TEST FOR COMPUTER APPLICATIONS    
  Monday Tuesday Wednesday Thursday Friday
May 13-17 dbex5.pdf Finish Database Finish Database Test Part 1 Database Ex 3
  Monday Tuesday Wednesday Thursday Friday
May 6-10 ex70.pdf EX86      
  Monday Tuesday Wednesday Thursday Friday
April 29-May 3 Writing Assignment

& Evaluation

EX 53

PMT EX

Dream car Finish Dream Car

and

EX67 & OXL67

ex55oxl55.pdf
  Monday Tuesday Wednesday Thursday Friday
April 22-26 ex66 and oxl66.pdf activity spreadsheet.pdf ex 42 and oxl 42.pdf    
  Monday Tuesday Wednesday Thursday Friday
April 15-19 ex 30 and oxl 30.pdf Freshmen at Play Finish OXL30

Writing Assignment

Early out - bad weather ex38 and oxl38.pdf
  Monday Tuesday Wednesday Thursday Friday
April 8-12 OXL31.pdf Finish OXL31 Snow Day Snow Day  
  Monday Tuesday Wednesday Thursday Friday
April 1-5 NO SCHOOL Finish Millionaire Project ex 23 and oxl 23.pdf ex24.pdf  
  Monday Tuesday Wednesday Thursday Friday
Mar 25-28 EX19

OXL19

Finish OXL19 Millionaire Project

Writing Assignment

  NO SCHOOL
  Monday Tuesday Wednesday Thursday Friday
Mar 18-22 Ex 14

oxl14.pdf

OXL14

EX1 5

Finish EX15

OXL15 

Ex 16

Finish OXL15

OXL 16
  Monday Tuesday Wednesday Thursday Friday
Mar 11-15 Spreadsheet Ex13 OXL13 Writing Assignment NO SCHOOL NO SCHOOL
  Monday Tuesday Wednesday Thursday Friday
Mar 4-8 Shapes Shapes Watermark Logo On Your Own

Watermark

Logo

  Monday Tuesday Wednesday Thursday Friday
Feb 25-Mar 1 Ex  62 Newsletter Newsletter Newsletter Writing Assignment

Favorite Food

  Monday Tuesday Wednesday Thursday Friday
Feb 18-Feb 22 NO SCHOOL finish ex 46

ex48.pdf

Finish Ex 48 ex52.pdf

Outline Current Chapter in your Science Textbook

 
  Monday Tuesday Wednesday Thursday Friday
Feb. 10-Feb. 15 Webpage Project Webpage Project Webpage Project ex 46.pdf NO SCHOOL
  Monday Tuesday Wednesday Thursday Friday
Feb. 4-Feb. 8 Ex 40   & On Your Own Tables Ex 44

Save & attach to wikispace

start webpage  project Click

Web Page Project

to learn what is required for this project. Remember to save in MYWEB Folder you created yesterday!

  Monday Tuesday Wednesday Thursday Friday
Jan 27-Feb 1 Finish Trip writing assignment Ex 26 Hyperlink doc. 36Train

36Course

SNOW Day! BHS 1
& BHS2
  Monday Tuesday Wednesday Thursday Friday
Jan 21-25 NO SCHOOL Finish On Your Own & Writing Assignment Bulleted Lists

On Your Own GOALS

Exercise 26 Writing Assignment
  Mon Jan 14 Tues Jan 15 Wed Jan 16 Thur Jan 17 Fri Jan 18
Jan 14-18 Create wikispaces for this class.

 

Ex 24

Save as EX24

Finish Ex 24

 

On Your Own Writing Assignment
  Mon Jan 7 Tues Jan 8 Wed Jan 9 Thur Jan 10 Fri Jan 11
 

Syllabus

Seating Chart

Map Network Drive

Class Rules

 

Go over parts of a Busines Letter

Type the Business Letter

Letter

Save as Ex15 to your server folder.

Follow the On Your Own directions below.

 


 

 

Apply your skills and create a letter to Mr. Degen

Information regarding Letter to Mr. Degen

 

 

Example of Modified Block Style Letter

Continue with Letter to Mr. Degen

Proofread Letters

 

Create wikispaces

 

On Your Own

Compose a letter to Mr. Degen about the following:

Remember to use complete sentences and correct spelling & grammar.

Use the following address for his address:  301 W. Maple St, Beresford, SD 57004.

Don't forget to include your address in the closing lines.

 

Make sure to save the document in your computer folder as Degen Letter.

On Your Own Assignment (01/16/13)
Draft an announcement about an upcoming event in your life. For example, the event could be your birthday, confirmation, a party, or a vacation trip...
*Right-align your name and address below the title.
*Add two paragraphs that describe the event in detail. Justify these paragraphs.
*Add other lines giving the time and location of the event as well as directions. Use left, right, & center alignments to organize and format other lines.
*Try different vertical alignments until you settle on the one that makes the document look the best.
*Apply fonts, font styles, and font sizes to the document text. Change the fonts to emphasize various parts of the document. For example, you will probably want to highlight the title by giving it a large, distinctive font.
*Apply alignments to improve the appearance of the document.
*Name this document Announcement  when you save it in your folder.
*Attach the document to your wikispace.


On Your Own Assignment

1) Type a bulleted list of five things you'd like to accomplish this year. These can be goals for school, work, or personal development. Examples might include earning a better grade in math, completing a project on the job, or getting in better shape by exercising and eating right. (Format your bullet to be a picture you locate from the Internet) 

2) Sort the list in alphabetical order.

3) Type a numbered list that includes at least five steps describing how you
expect to accomplish one of the items in the bulleted list.

4)SaveAs Goals in your folder.

 


 

On Your Own Assignment

Do a  review on a movie that you have recently seen. Must be at least 250 words.  Save as:  Movie Review.  Make sure to use complete sentences and check your spelling. At the end of the review give it a Thumbs up or a Thumbs down using the Insert Symbol Command.  Make the Thumb a bigger size so it is noticeable! Attach it to your wikispace. Create a new page called Writing and attach the file on it.       

    <<<<< =====  <<<<<

 

Writing Assignment:  If you could only take 3 people with you on a trip around the world, who would you take and why? Explain where all you would go and what you would do. Save as Trip. (250 words)

 

 

 

On Your Own Assignment
Create an outline

Using your Science textbook. Outline chapter 4 using the format you learned in Ex 52. Save the document as Chapter Outline in your folder.


Newsletter: Create a one-page newsletter. Create at least 3 or more different articles. Write the articles in your own words. In the newsletter include the following elements:

Save the document as Newsletter. When the document is completed, proofread & spell-check it and then attach it to your wikispace.

Writing Assignment:  FAVORITE FOOD

Write about your all time favorite meal that someone in your family makes. Also write about your favorite restaurant that you like to go to and what you like to order.  Describe what the atmosphere is like and how the restaurant is decorated. (200 words) Save the document as Favorite Food.


On Your Own Assignment: You recently were informed that you won a prize of $1,000,000.00.  The only stipulation was that you must spend your money in at least 10 different shops.  Get into Microsoft Excel, blank spreadsheet and Create the following column headings:   Store Name, Item purchased, and Cost. Below your Heading you will have more than 10 rows with the specific information on how you plan to spend the money. You must spend every penny. Search the Internet for prices on your items you purchase.  You can have more than 10 items!

Incorporate the following into your spreadsheet:

__Change the font color and fill color in the Heading Row, and make the text Bold.
__Click on the currency icon in your toolbar for the cost figures.

__Incorporate the Sum function to track your total as you are spending the money.

__Incorporate the Count function

__ Create a new theme and call it millionaire with the colors of your choice. Fill in cells with the colors from your new theme.

Save this document  as millionaire  and attach it to your wikispace when you are done.

Writing Assignment:  Boston Marathan

Write about your thoughts of the incident that happened this week at the Boston Marathan.  What more do you think security should be doing. (125 words) Save as Boston Marathan.


Writing Assignment (04/29/13)
If you could have been someone in history, who would you have been?  Explain why you selected this person. Also include what things you would do during your day and what type of clothes you probably would have worn. What type of house would you have lived in. Any other interesting thing you can think of about this person. Complete this in at least 250 words.  Save this as Famous Person.


Dream Car

To reinforce the PMT function, complete this exercise of budgeting for your dream car.

 

  1. Search and find information and a picture of your dream car.

  2. Begin a blank spreadsheet.

  3. Rename sheet 1 as Car Info

  4. Rename sheet 2 as Balance Sheet

  5. Color your sheet tabs.

  6. Paste a picture of your dream car on your Car Info sheet.

  7. Also list information about the vehicle on this sheet.

  8. Copy the source you found this information from to the Car Info Sheet.

  9. Create a Balance Sheet similar to Exercise 53. Substitute the Principal, interest rate, as they apply.

  10. Create a Data Table.

  11. Format your Balance Sheet to make it more attractive and easier to read.

  12. Save file as Dream Car.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 ** Writing Assignment

Write a 250-word description of a place. You can use any and all descriptions but sight: you can describe what it feels like, sounds like, smells like and even tastes like. Try to write the description in such a way that people will not miss the visual details. Save as SIGHT

 


 ** Writing Assignment

Write 175 words about your Spring Break plans.  Save as SPRING BREAK.

 

**Writing Assigment

If you could have lunch with any famous person who would it be? What would you talk about with this person?  Save it as Famous Person and make sure that is 150 words. Attach it to your wikispace under Writing Assignments.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

On Your Own Assignment (01/18/12)                HYPERLINKS

Create a new document that lists Periods 1-8 and the corresponding classes that you have each period. Below that list type each class name and under each name explain what you are working on for each of your classes.  Then Hyperlink each class in the list at top to their appropriate heading below.  Below each paragraph for each period have Back to Top hyperlinked back to the top of the page. Save this document as BHS Classes.

Create a second document and call it BHS Classes 2.  Again list each class at top and create a heading below for each class. Under each heading explain what you like and don't like about each class. Link both documents together.

.

Writing Assignment: (10/20/11) If you could only take 3 people with you on a trip around the world, who would you take and why? Explain where all you would go and what you would do. Save as Trip. (250 words)

 

 

PERSONAL WEB PAGE PROJECT

The web page must have four pages total.  
1.    About me page (homepage)
2.    Family page

3.    Favorites page

 
4.    Schedule page

You are being graded on:

Number of Points

 

 
1.    Digital Picture of yourself 5
2.    Digital pictures of family 5
3.    Other images and graphics  from Internet 5
4.    Word Art - all titles must be in word art 5
5.    Tables  - there must be a table on every page 5
6.    Backgrounds - all pages must have a     background 5
7.    Hyperlinks - include at least 3 links to other websites 5
8.    Navigation - all pages must have links to the other pages included in your website 5
8.    Spelling/Grammar 5
9.    Having all four pages saved correctly in webpage format 20
Total 65

 

Newsletter: Create a one-page newsletter. Create at least 3 or more different articles. Write the articles in your own words. In the newsletter include the following elements:

When the document is completed. Proofread & spell-check it and then attach it to your wikispace.

For Wed. Feb. 29 try to have the following tasks completed:  

  1. A title for your Newsletter

  2. 3 articles written by you (you may use other resources but it needs to be composed in your own words.) You can begin typing it up in a blank document. Keep all 3 articles on the same page.

  3. At least 3 little graphics to be used in your newsletter.

If you get all of these items ready to go and there is still time in the period, begin working on formatting your newsletter.

 

March 6th Writing Assignment:

Write about your all time favorite meal that someone in your family makes. Also write about your favorite restaurant that you like to go to and what you like to order.  Describe what the atmosphere is like and how the restaurant is decorated. (200 words) Include a picture of your food or your favorite restaurant. Save the document as Favorite Food.

March 12 LOGO:

Create a logo with the 3 initials of your name. You must include the following:

 

(Mar 14th) Writing Assignment:

Write a 250-word description of a place. You can use any and all descriptions but sight: you can describe what it feels like, sounds like, smells like and even tastes like. Try to write the description in such a way that people will not miss the visual details. Save as SIGHT

 

 

Writing Assignment: (3/21/12)

Write 125 words on each of the  following writing prompts. Write these in the same document and save the file as: 10 year old.

Attach to your wikispace.

On Your Own Assignment: You recently were informed that you won a prize of $1,000,000.00.  The only stipulation was that you must spend your money in at least 10 different shops.  Get into Microsoft Excel, blank spreadsheet and Create the following column headings:   Store Name, Item purchased, and Cost. Below your Heading you will have 10 rows or more with the specific information on how you plan to spend the money. You must spend every penny.

Incorporate the following into your spreadsheet:
__Change the font color and fill color in the Heading Row, and make the text Bold.
__Click on the currency icon in your toolbar for the cost figures.

__Incorporate the Sum function to track your total as you are spending the money.

__Incorporate the Count function

Save this document  as millionaire  and attach it to your wikispace when you are done.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Mon Apr 23 Tues Apr 24 Wed Apr 25 Thur Apr 26 Fri Apr 27
Ex 68 - Create a stock chart, add a secondary value axis to a chart, change data marker format

OXL 68

Ex 69 - Create an Exploded Pie Chart

OXL 69

Ex 70 - Create a 3-D Chart

-change the view of a 3D chart

-display hide gridlines or data labels

Ex 73 - Create a List/Database, Name a List/Database, Use a form to Add Records, Add fields to a list/database

OXL 73

Ex 81

Pivot tables & pivot charts

Writing Assignment

Mon Apr 16 Tues Apr 17 Wed Apr 18 Thur Apr 19 Fri Apr 20
Finish OXL 63

EX 64 - Use Chart Toolbar, Select a chart object, change chart text, change the orientation of chart text

Ex 65 - Enhance chart background, format category and value axes, change color and patterns of data series, add or remove data in a chart

OXL 65

Finish Ex 65

Begin OXL 67

Finish OXL 65

 

Ex 67 -

OXL 67

Writing Assignment

Mon Apr 9 Tues Apr 10 Wed Apr 11 Thur Apr 12 Fri Apr 13
NO SCHOOL Ex 38
Insert WordArt

Ex 51
IF Functions, =SUMIF, =COUNTIF

Ex 53

PMT Function

Ex 59
VLOOKUP Function
HLOOKUP Function
Ex 64

Charts

Mon Apr 2 Tues Apr 3 Wed Apr 4 Thur Apr 5 Fri Apr 6
Ex 32

OXL32

Ex 35
Critical Thinking
Ex 36

OXL 36

Ex 37

Ex 38

NO SCHOOL
Mon Mar 26 Tues Mar 27 Wed Mar 28 Thur Mar 29 Fri Mar 30
Ex 22

OXL21

Ex 24

Ex 27

Ex 27

Ex 28

Ex 29

Ex 30

OXL 30

WAC Assignment

Mon Mar 19 Tues Mar 20 Wed Mar 21 Thur Mar 22 Fri Mar 23
Overview of Spreadsheet Tool

Ex 12
OXL12

Copy data, autofill, copy a formula

Ex 14 Functions, Autocalculate

OXL 14

Ex 17
Format Data, Fonts, & fontsize

Add bold, italic, underline or color, change font color, format numbers

On Your Own Assignment Ex 24

Set Print Area & Page Setup

Ex 27

Move between sheets, change tab colors, add, delete, copy sheets, group sheets

Mon Mar 12 Tues Mar 13 Wed Mar 14 Thur Mar 15 Fri Mar 16
Ex 76
Survey

On Your Own

Complete On your Own Assignment Writing assignment Ex 81

On Your Own

Ex 85

Watermark

Mon Mar 5 Tues Mar 6 Wed Mar 7 Thur Mar 8 Fri Mar 9
Newsletter Newsletter Writing Assignment

SPRING BREAK

SPRING BREAK

Mon Feb 26 Tues Feb 27 Wed Feb 28 Thur Mar 1 Fri Mar 2
Ex 65 Track Changes

Ex 71 Create Newsletter Columns - Insert Column Breaks

Ex 72 Dropped Capitals
Borders & Shading

On your own - Newsletter

Newsletter Snow DayNewsletter Ex 76 Forms

On Your Own Assignment - Creating a survey form

Mon Feb 19 Tues Feb 20 Wed Feb 21 Thur Feb 22 Fri Feb 23

NO SCHOOL

Finish Web Pages Evaluate Web pages Evaluate Web Pages Writing Assignment
Mon Feb 12 Tues Feb 13 Wed Feb 14 Thur Feb 15 Fri Feb 16
Finish Outlines Ex 57
Ex 61 & 62
Creating Web Pages in Word

On Your Own Assignment

On Your Own Assignment On Your Own Assignment
Mon Feb 5 Tues Feb 6 Wed Feb 7 Thur Feb 8 Fri Feb 9
Ex 49

Critical Thinking

Ex 50
-Create an outline, Edit an Outline, Number an Outline
On Your Own Assignment Ex 57
-Table of Figures & Table of Contents
Ex 61 & Ex 62
-Creating Web pages w/ Word
On Your Own Assignment
Mon Jan 29 Tues Jan 30 Wed Jan 31 Thur Feb 1 Fri Feb 2
Evaluation of Assignments Ex 43 Ex 44 Ex 45 Writing Assignment
Mon Jan 22 Tues Jan 23 Wed Jan 24 Thur Jan 25 Fri Jan 26
Ex 37

OWD 37

Ex 38

Ex 39

Ex 40 Ex 42
OWD41
OWD42
Finish assignments

Writing Assignment

Mon Jan 15 Tues Jan 16 Wed Jan 17 Thur Jan 18 Fri Jan 19
NO SCHOOL Ex 23

On Your Own Assignment

Ex 25
Critical Thinking Ex

Ex 30

On Your Own Assignment Writing Assignment
Mon Jan 8 Tues Jan 9 Wed Jan 10 Thur Jan 11 Fri Jan 12
Finish Ex 12

Ex 13

Compose letter to a relative using the Modified Block Style Letter Format

Print off & hand in

Finish letters

Proofread letters

Ex 20

Ex 22

On Your Own Assignment

Writing Assignment

Finish missing assignments

 

On Your Own Assignment (01/11/07)
Draft an announcement about an upcoming event in your life. For example, the event could be your birthday, confirmation, a party, or a vacation trip...
*Right-align your name and address below the title.
*Add two paragraphs that describe the event in detail. Justify these paragraphs.
*Add other lines giving the time and location of the event as well as directions. Use left, right, & center alignments to organize and format other lines.
*Try different vertical alignments until you settle on the one that makes the document look the best.
*Apply fonts, font styles, and font sizes to the document text. Change the fonts to emphasize various parts of the document. For example, you will probably want to highlight the title by giving it a large, distinctive font.
*Apply alignments to improve the appearance of the document.
*Name this document Announcement  when you save it in your folder.
*Print it out and hand it in.

\


On Your Own Assignment (01/16/07)

1) Type a bulleted list of five things you'd like to accomplish this year. These can be goals for school, work, or personal development. Examples might include earning a better grade in math, completing a project on the job, or getting in better shape by exercising and eating right. (Format your bullet to be a picture you locate from the Internet) 

2) Sort the list in alphabetical order.

3) Type a numbered list that includes at least five steps describing how you
expect to accomplish one of the items in the bulleted list.

4)SaveAs Goals in your folder.


On Your Own Assignment (1/18/07)
Create a new document that lists Periods 1-7 and the corresponding classes that you have each period. Below that list type each class name and under each name explain what you are working on for each of your classes.  Then Hyperlink each class in the list at top to their appropriate heading below.  Save this document as BHS Classes.

Create a second document and call it BHS Classes 2.  Again list each class at top and create a heading below for each class. Under each heading explain what you like and don't like about each class.

Writing Assignment: (1/19/07) Do a  review on a movie that you have recently seen. Must be at least 250 words.  Save as:  Movie Review.  Make sure to use complete sentences and check your spelling. At the end of the review give it a Thumbs up or a Thumbs down using the Insert Symbol Command.  Make the Thumb a bigger size so it is noticeable!        

    <<<<< =====  <<<<<

Writing Assignment: (1/26/07) If you could only take 3 people with you on a trip around the world, who would you take and why? Explain where all you would go and what you would do. Save as Trip. (250 words)


Writing Assignment: (2/02/07)
Write about your all time favorite meal that someone in your family makes. Also write about your favorite restaurant that you like to go to and what you like to order.  Describe what the atmosphere is like and how the restaurant is decorated. (200 words) Save the document as Favorite Food.


Your Own Assignment (02/7/07)
Using a textbook from another class. Outline a future chapter using the format you learned in Ex 50. Save the document as Chapter Outline in your folder.


Personal Webpage Assignment -

The web page must have four pages total.  
1.    About me page (homepage)
2.    Family page

3.    Favorites page

 
4.    Schedule page

You are being graded on:

Number of Points

 

 
1.    Digital Picture of yourself 5
2.    Scanned picture 5
3.    Other images and graphics  from Internet 5
4.    Word Art - all titles must be in word art 5
5.    Tables  - there must be a table on every page 5
6.    Backgrounds - all pages must have a     background 5
7.    Hyperlinks - all hyperlinks must work properly 5
8.    Spelling/Grammar 5
9.    Having all four pages 20
Total 60
Writing Assignment: (02/23/07)

Write 125 words on each of the  following writing prompts. Write these in the same document and save the file as: 10 year old.

  • Write a letter to the 10-year old child you had been.  You can warn yourself how to handle certain situations differently now that you have already experienced. them. Compose about 125 words.
  • Where do you go when you want to get away from the pressures of life, family, work, etc? Write about that place in 125 words.

Assignment:  (3/05/07 - 3/06/07)                                             

Newsletter: Create a one-page newsletter. Create at least 3 or more different articles. Write the articles in your own words. In the newsletter include the following elements:

  • A title for the Newsletter in size 48, serif font.
  • A line for the Volume, Issue number, and date of publication.
  • Dropped capitals to the first paragraph of each article.
  • A pull-out box which utilizes, shading and either 3-D or shadow border effect.
  • At least 2-3 small graphics.
  • Borderlines to set off info at the top of the newsletter.
  • Apply a page border.

When the document is completed. Proofread & spell-check it and then print it off and hand it in.


On Your Own Assignment: (3/12/06)

Survey:  Create a one-page survey on your choice.  Make sure to save document as a template and name it Survey.  Create your form in a table so you have more options. Include the following:

  • Text form fields
  • Check boxes
  • At least one drop down box with at least 4 choices
  • At least 10 different items to answer
  • Add design and color to your form.

When you are satisfied with it make sure to Protect your form.

(Mar 14th) Writing Assignment:

Write a 200-word description of a place. You can use any and all descriptions but sight: you can describe what it feels like, sounds like, smells like and even tastes like. Try to write the description in such a way that people will not miss the visual details. Save as SIGHT

MICROSOFT EXCEL
(3/22)On Your Own Assignment: You recently were informed that you won a prize of $1,000,000.00.  The only stipulation was that you must spend your money in at least 10 different shops.  Get into Microsoft Excel, blank spreadsheet and Create the following column headings:   Store Name, Item purchased, and Cost. Below your Heading you will have 10 rows with the specific information on how you plan to spend the money.

Incorporate the following into your spreadsheet:
__Change the font color and fill color in the Heading Row, and make the text Bold.
__Click on the currency icon in your toolbar for the cost figures.

__Incorporate the Count function

Save this document in your  folder as millionaire

Writing Assignment (03/30/07)
If you could have been someone in history, who would you have been?  Explain why you selected this person. Also include what things you would do during your day and what type of clothes you probably would have worn. What type of house would you have lived in. Any other interesting thing you can think of about this person. Complete this in at least 250 words.  Save this as Famous Person.

 

Writing Assignment (04/20/07)

Write 250 words about what four things are most important in your life. Describe in detail about each one. Save this document as Four things.

 

Writing Assignment (04/27/07)

Write 150 words on how a teacher should handle students in a classroom that are not paying attention when the teacher is demonstrating. Explain what your thoughts are when you witnessed the teacher's frustrations from students not paying attention. What could have been done differently.  Also explain your preference of whether demonstrations by the teacher help you or you would prefer to figure the assignments out on your own.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Mon Dec 18 Tues Dec 19 Wed Dec 20 Thur Dec 21 Fri Dec 22
Database - Green Thumb Database - Green Thumb Review Sheet Semester Test Semester Test
Mon Dec 11 Tues Dec 12 Wed Dec 13 Thur Dec 14 Fri Dec 15
Ex 1 pg 11-24

Ex 2 p 11-24 -11-25

Finish Ex 2 Ex 7 pg 11-31 Ex 1 pg 12-26

Ex 2 pg 12-26

Ex 7 pg 12-29

Writing Assignment

Mon Dec 4 Tues Dec 5 Wed Dec 6 Thur Dec 7 Fri Dec 8
Ex 70

*Create a 3-D Chart
*Change the view of a 3-D Chart
*Display or hide gridlines or data labels

Ex 73 & On Your Own

*Create a List/Database
*Name a List/Database
*Use a form to Add Records
*Add Fields to a List/Database

Ex 81

*Create Pivot Tables & Pivot Charts

Finish Ex 81 & On Your Own  

Writing Assignment

Mon Nov 27 Tues Nov 28 Wed Nov 29 Thur Nov 30 Fri Dec 1
Ex 67

OXL 67

Ex 68

OXL 68

Ex 69

OXL 69

Ex 70

OXL 70

Writing Assignment
Mon Nov 20 Tues Nov 21 Wed Nov 22 Thur Nov 23 Fri Nov 24
Ex 64

OXL 64

Ex 65

OXL 65

Writing Assignment Thanksgiving
NO SCHOOL
NO SCHOOL
Mon Nov 13 Tues Nov 14 Wed Nov 15 Thur Nov 16 Fri Nov 17
Ex 36

OXL 36

Ex 37

Ex 38

Ex 51

 

Ex 63 Assembly
Mon Nov 6 Tues Nov 7 Wed Nov 8 Thur Nov 9 Fri Nov 10
Ex 32 3-D Formulas Ex 35 Critical Thinking Millionaire Project

 

Millionaire Project NO SCHOOL
Mon Oct 30 Tues Oct 31 Wed Nov 1 Thur Nov 2 Fri Nov 3
Ex 21
-Create a Series

Ex 22
-Critical Thinking Ex

Ex 24
-Set the Print Area & Page Setup

Ex 27
-Move between sheets, change tab colors, add, delete & copy sheets, group sheets

Ex 27
-On Your Own Assignment

Ex 28

Ex 29
-Transpose Data

OXL 29

Ex 30
-Combine Data with Copy & Paste Special

Writing Assignment

Mon Oct 23 Tues Oct 24 Wed Oct 25 Thur Oct 26 Fri Oct 27
Ex 84

WordArt, Drawing Tools

Ex 85

Watermark

On Your Own Assignment

Overview of the Spreadsheet Tool

Ex 12 - Copy Data, Autofill, Copy a Formula

Ex 14 - Functions, Autocalculate

OXL14 - On Your Own

Ex 17 - Format Data, Fonts & Font Size, Add Bold, Italic, Underline, or Color, Change Fot Color, Format Numbers

EX 18 - Apply Cell colors & patterns, Change Cell Borders, Hide Gridlines, Format Worksheet Background, Clear Cell Formats

Mon Oct 16 Tues Oct 17 Wed Oct 18 Thur Oct 19 Fri Oct 20
On Your Own Assignment Newsletter On Your Own Assignment Newsletter Ex 76 Forms
On Your Own Assignment: Creating a Survey Form
Finish On Your Own Assignment: Survey Form Ex 81 Creating a Logo

On Your Own Assignment

Mon Oct 9 Tues Oct 10 Wed Oct 11 Thur Oct 12 Fri Oct 13
NO SCHOOL Finish Web Pages
Begin Evaluation
Finish Evaluations
Ex 65 Track Changes
Ex 71 Create Newsletter Columns, Insert Column Breaks,
Ex 71 Create Newsletter Columns, Insert Column Breaks,

Writing Assignment

Mon Oct 2 Tues Oct 3 Wed Oct 4 Thur Oct 5 Fri Oct 6
On Your Own Assignment

Create an Outline, Edit an Outline, Number an Outline

Copy & paste the following writing assignments together:  Trip & Favorite Food Make sure your name is on the document. Print it out & hand it in.

Ex 57 Ex 61
Ex 62
On Your Own Assignment On Your Own Assignment
Mon Sep 25 Tues Sep 26 Wed Sep 27 Thur Sep 28 Fri Sep 29
NO SCHOOL Ex 45
-Mail Merge Basics
-Create a New Address List
-Use Merge Fields
Ex 49
Critical Thinking Ex
Finish Ex 49 Ex 50 & Writing Assignment
Mon Sep 18 Tues Sep 19 Wed Sep 20 Thur Sep 21 Fri Sep 22
Ex 40 & 41
-Use Tables & Borders Toolbar
-Draw a Table
-Merge and Split Cells
-Cell Borders & Shading
Ex 42 & 43
-Calculate in a Table
-Number Formats
-Sort Rows
-Convert Text to a Table, Autofit
Finish EX 43
On Your Own
Ex 44
Critical Thinking Exercise
Writing Assignment

Catch up on any missing assignments

Mon Sep 11 Tues Sep 12 Wed Sep 13 Thur Sep 14 Fri Sep 15
Ex 29
Create Footnotes & Endnotes

Ex 30
Create Hyperlinks within a file

On Your Own Assignment Demonstration of Ex 34

Ex 37 Tables

Ex 38 Tables

Ex 39

Writing Assignment

Homecoming
Mon Sep 4 Tues Sep 5 Wed Sep 6 Thurs Sep 7 Fri Sep 8
NO SCHOOL Ex 22
-Insert Symbols & Special Characters
-Customize Tool bars
Ex 23
-Bulleted List, Numbered List
ON YOUR OWN Assignments:
Store Assignment

Goals
Assignment

Ex 25 Critical Thinking Ex.

 

Finish Ex 25

Ex 29

Writing Assignment

Mon Aug 28 Tues Aug 29 Wed Aug 30 Thur Aug 31 Fri Sept 1
Compose your own letter to a relative. Save as My Letter

Margins:
Top: 1.5"
Left: 1"
Right: 1" 

Proofread letters. Correct letters & hand in.

Ex 24-1
Top: 2"
Left: 1"
Right: 1"

 

Finish Letters & Envelopes & Ex 24-2 On Your Own Exercise 
Click Here for Directions
Writing Assignment

Click for Directions

 

Assignment (8/31/06)
Draft an announcement about an upcoming event in your life. For example, the event could be your birthday, confirmation, a party, or a vacation trip...
*Right -align your name and address below the title.
*Add two paragraphs that describe the event in detail. Justify these paragraphs.
*Add other lines giving the time and location of the event as well as directions. Use left, right, & center alignments to organize and format other lines.
*Try different vertical alignments until you settle on the one that makes the document look the best.
*Apply fonts, font styles, and font sizes to the document text. Change the fonts to emphasize various parts of the document. For example, you will probably want to highlight the title by giving it a large, distinctive font.
*Apply alignments to improvethe appearance of the document.
*Name this document Announcement  when you save it in your folder.
*Print it out and hand it in.


Writing Assignment: (9/01/06) A huge controversy this week is the death sentence. Explain what your feelings are on this topic. If you are unfamiliar with what has been going on in the news do a little research first before you write about it. Search the Argus Leader or the TV station websites to find out more. Write complete sentences on this topic. Must be at least 200 words. Save this document as Death Sentence in your folder.


Assignment (9/06/06)

Create your own document for a store that includes the products and prices.

You must utilize the following in your document:

The name of the store at the top set apart from the rest of the text.

4 different text effects.
2 different styles of underlines.
3 different font colors.

Tabs including a decimal tab, when you list the products & prices.

Save this document as Store Prices in your folder.
DO NOT PRINT THIS DOCUMENT.


On Your Own Assignment (9/06/06)

1) Type a bulleted list of five things you'd like to accomplish this year. These can be goals for school, work, or personal development. Examples might include earning a better grade in math, completing a project on the job, or getting in better shape by exercising and eating right. (Format your bullet to be a picture you locate from the Internet) 

2) Sort the list in alphabetical order.

3) Type a numbered list that includes at least five steps describing how you
expect to accomplish one of the items in the bulleted list.

4)SaveAs Goals in your folder.


Writing Assignment: (9/08/06) Do a  review on a movie that you have recently seen. Must be at least 250 words.  Save as:  Movie Review.  Make sure to use complete sentences and check your spelling. At the end of the review give it a Thumbs up or a Thumbs down using the Insert Symbol Command.  Make the Thumb a bigger size so it is noticeable!


On Your Own Assignment (9/12/06)
Create a new document that lists Periods 1-7 and the corresponding classes that you have each period. Below that list type each class name and under each name explain what you are working on for each of your classes.  Then Hyperlink each class in the list at top to their appropriate heading below.  Save this document as BHS Classes.

Create a second document and call it BHS Classes 2.  Again list each class at top and create a heading below for each class. Under each heading explain what you like and don't like about each class.


Writing Assignment: (9/22/06) If you could only take 3 people with you on a trip around the world, who would you take and why? Explain where all you would go and what you would do. Save as Trip. (250 words)


On Your Own Assignment (9/28/06)
Using a textbook from another class. Outline a future chapter using the format you learned in Ex 50. Save the document as Chapter Outline in your folder.


Writing Assignment: (9/29/06)
Write about your all time favorite meal that someone in your family makes. Also write about your favorite restaurant that you like to go to and what you like to order.  Describe what the atmosphere is like and how the restaurant is decorated. (200 words) Save the document as Favorite Food.


 Personal Webpage Assignment -

The web page must have four pages total.  
1.    About me page (homepage)
2.    Family page

3.    Favorites page

 
4.    Schedule page

You are being graded on:

Number of Points

 

 
1.    Digital Picture of yourself 5
2.    Scanned picture 5
3.    Other images and graphics  from Internet 5
4.    Word Art - all titles must be in word art 5
5.    Tables  - there must be a table on every page 5
6.    Backgrounds - all pages must have a     background 5
7.    Hyperlinks - all hyperlinks must work properly 5
8.    Spelling/Grammar 5
9.    Having all four pages 20
Total 60

Assignment - On Your Own Assignment: (10/12/06)

Newsletter:  Create a one-page newsletter. Create at least 3 or more different articles. Write the articles in your own words. In the newsletter include the following elements:

  • A title for the Newsletter in size 48, serif font.
  • A line for the Volume, Issue number, and date of publication.
  • Must have more than a one-column newletter.
  • Dropped capitals to the first paragraph of each article.
  • A pull-out box which utilizes, shading and either 3-D or shadow border effect.
  • At least 2-3 small graphics.
  • Borderlines to set off info at the top of the newsletter.
  • Apply a page border.

When the document is completed. Proofread & spell-check it and then print it off and hand it in.


On Your Own Assignment: (10/18/06)

Survey:  Create a one-page survey on your choice.  Make sure to save document as a template and name it Survey.  Create your form in a table so you have more options. Include the following:

  • Text form fields
  • Check boxes
  • At least one drop down box with at least 4 choices
  • At least 10 different items to answer
  • Add design and color to your form.

When you are satisfied with it make sure to Protect your form.


On Your Own Assignment: (10/20/06)

Create a Logo similar to Ex 81 using the 3 initials of your name. Also include a graphic of your choice. Make sure the image is no larger than 2 inches wide by 2 inches high. Save as Logo.b


Writing Assignment: (10/13/06

Write 150 words on each of the  following writing prompts. Write these in the same document and save the file as: 2-24-06

  • Write a letter to the 10-year old child you had been.
  • Where do you go when you want to get away from the pressures of life, family, work, etc? Write about that place in 150 words.

On Your Own Assignment: (10/24/06)

Create a watermark similar to Ex 85. Locate your favorite saying or a poem or some type of inspirational message and use it for your text. Locate a graphic to coordinate with the message.  Save as Watermark.


(Oct 31st) Writing Assignment:

Write a 200-word description of a place. You can use any and all descriptions but sight: you can describe what it feels like, sounds like, smells like and even tastes like. Try to write the description in such a way that people will not miss the visual details. Save as SIGHT


MICROSOFT EXCEL
(11/8)On Your Own Assignment: You recently were informed that you won a prize of $1,000,000.00.  The only stipulation was that you must spend your money in at least 10 different shops.  Get into Microsoft Excel, blank spreadsheet and Create the following column headings:   Store Name, Item purchased, and Cost. Below your Heading you will have 10 rows with the specific information on how you plan to spend the money.

Incorporate the following into your spreadsheet:
__Change the font color and fill color in the Heading Row, and make the text Bold.
__Click on the currency icon in your toolbar for the cost figures.

__Incorporate the Count function

Save this document in your  folder as millionaire

(Nov 17th) Writing Assignment:

Write 250-words about what you are thankful for. Make sure to use complete sentences and check your spelling. Also include at least 3 Thanksgiving graphics in the document.   Save as Thanksgiving.  PRINT THE DOCUMENT OUT AND HAND IT IN.


(Dec 1st) Writing Assignment:

Write 250-words about what four things are most important in your life.  Describe in detail about each one. Save this document as Four things.


(Dec 15th) Writing Assignment:

With 10 days until Christmas, write 200 words about your favorite Christmas memory. Also write about your favorite Christmas sweets you like to eat!  Save the document as Christmas.

 


 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Friday, May 19th:

I have enjoyed teaching you about three of the Microsoft Office Tools this Semester. I know it seems like some days I was tough on you but with a class of 30 students on computers at one time I felt you needed to know I was in control and you had an effective learning environment. I encourage you to consider taking other computer classes in your future as technology is something that is here to stay. One thing that most students should know before they graduate is how to create a web page. There are two different classes that you can learn this from. That is Advanced Computers and Web Page Design. Most of these classes have smaller numbers and it is more of a relaxed learning environment. You also do more projects in which you use your own creativity. Keep this in mind when you map out your future years ahead!

Make sure to save anything that you wanted from your folder to another device as the folders will be cleaned out.

 

Double click on the link below and complete the questions. When you are done, print it out and hand it in. Place it in the top tray on my desk.  Have a Great SummerR!!J

Mrs. Coggins

EVALUATION FORM

 
 
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

       
Mon Apr 24 Tues Apr 25 Wed Apr 26 Thur Apr 27 Fri Apr 28
Finish Ex 69 & OXL 69

Ex 70
Create a 3-D Chart
Change the View of a 3-D Chart
Display or Hide Gridlines or Data Labels

OXL 70 &
Ex 81
*Create PivotTables & PivotCharts
*Link to Data in a PivotTable
*Publish a PivotTable or PivotChart
 OXL 81 Ex 73
*Create a List/Database

*Name a List/Database

*Use a Data Form to Add Records

*Add Fields to a List/Database

Begin Access
Chapter 11
Mon Mar 27 Tues Mar 28 Wed Mar 29 Thur Mar 30 Fri Mar 31
Ex 21
Create a Series

Ex 22
Critical Thinking Ex.

Ex 24
Set the Print Area & Page Setup

Ex 27
Move between sheets, change tab colors, add, delete, & copy sheets, group sheets

Ex 27
On Your Own


Ex 28

Ex 29
Transpose Data

Ex 29 On your Own


Ex 30

Writing Assignment

Click Here for topic

Catch up on any missing assignments

Mon Mar 20 Tues Mar 21 Wed Mar 22 Thur Mar 23  Fri Mar 24
Ex 12 Snow Day
No School
Ex 14 Ex 17 & 18 Finish OXL 18

On Your Own

Mon Mar 13 Tues Mar 14 Wed Mar 15 Thur Mar 16 Fri Mar 17
Grading Grading Grading SPRING BREAK NO SCHOOL
Mon Mar 6 Tues Mar 7 Wed Mar 8 Thur Mar 9 Fri Mar 10
Ex 81
On Your Own
Ex 85
On Your Own
Spreadsheet Tool    
Mon Feb 27 Tues Feb 28 Wed Mar 1 Thurs Mar 2 Fri Mar 3
Ex 71
Ex 72
On Your Own Finish On Your Own assignment Ex 76 On Your Own
Mon Feb 20 Tues Feb 21 Wed Feb 22 Thur Feb 23 Fri Feb 24
NO SCHOOL On Your Own Web page Project Web page Project Writing Assignment
Mon Feb 13 Tues Feb 14 Wed Feb 15 Thur Feb 16 Fri Feb 17
Ex 30
On Your Own Assignment
Ex 57 Ex 61
Ex 62
On Your Own On Your Own
Mon Feb 6 Tues Feb 7 Wed Feb 8 Thur Feb 9 Fri Feb 10
Ex 50
Ex 51
 
On Your Own Assignment On Your Own Assignment On Your Own Assignment NO SCHOOL
Mon Jan 30 Tues Jan 31 Wed Feb 1 Thur Feb 2 Fri Feb 3
Ex 42

Ex 43

Ex 44 Ex 45 Ex 49 Writing Assignment

Click Here to see topic

Mon Jan 23 Tues Jan 24 Wed Jan 25 Thur Jan 26 Fri Jan 27
Ex 29 & Ex 37 & On Your Own  Ex 38 & Ex 39 Ex 40 Ex 41 Writing Assignment

(Will post topic on Friday)

Mon Jan 16 Tues Jan 17 Wed Jan 18 Thur Jan 19 Fri Jan 20
NO SCHOOL Ex 22, Ex 23 & On Your Own Goals

[Click Here to see On Your Own directions]

Finish On Your Own Assignment from yesterday & Ex 24 Ex 25 Writing Assignment

Click Here to see topic

Catch up on any missing assignments

Mon Jan 9 Tues Jan 10 Wed Jan 11 Thur Jan 12 Fri Jan 13
Ex 13

Modified Block Business Letter

Create an Envelope & Labels

On Your Own Assignment Critical Thinking - Ex 14
& Ex 19

 

Critical Thinking - Ex 20 & On Your Own Assignment (Below) Writing Assignment

Catch up on any missing assignments

On Your Own Assignment (1/12/05)
Draft an announcement about an upcoming event in your life. For example, the event could be your birthday, confirmation, a party, or a vacation trip...
*Right -align your name and address below the title.
*Add two paragraphs that describe the event in detail. Justify these paragraphs.
*Add other lines giving the time and location of the event as well as directions. Use left, right, & center alignments to organize and format other lines.
*Try different vertical alignments until you settle on the one that makes the document look the best.
*Apply fonts, font styles, and font sizes to the document text. Change the fonts to emphasize various parts of the document. For example, you will probably want to highlight the title by giving it a large, distinctive font.
*Apply alignments to improvethe appearance of the document.
*Name this document Announcement  when you save it in your folder.
*Print it out and hand it in.
Writing Assignment (1/13/06)
If you could have been someone in history, who would you have been?  Explain why you selected this person. Also include what things you would do during your day and what type of clothes you probably would have worn. What type of house would you have lived in. Any other interesting thing you can think of about this person. Complete this in at least 250 words.  Save this as Famous Person.

On Your Own Assignment (1/17/05)

1) Type a bulleted list of five things you'd like to accomplish this year. These can be goals for school, work, or personal development. Examples might include earning a better grade in math, completing a project on the job, or getting in better shape by exercising and eating right. (Format your bullet to be a picture you locate from the Internet) 

2) Sort the list in alphabetical order.

3) Type a numbered list that includes at least five steps describing how you
expect to accomplish one of the items in the bulleted list.

4)SaveAs Goals in your folder.

 

 
Writing Assignment: (1/20/06) Do a  review on a movie that you have recently seen. Must be at least 250 words.  Save as:  Movie Review.  Make sure to use complete sentences and check your spelling. At the end of the review give it a Thumbs up or a Thumbs down using the Insert Symbol Command.  Make the Thumb a bigger size so it is noticeable!
Writing Assignment: ( 2/03/06)
If you could only take 3 people with you on a trip around the world, who would you take and why? Explain where all you would go and what you would do.  (250 words)
On Your Own Assignment (2/7/06)
Using a textbook from another class. Outline a future chapter using the format you learned in Ex 50. Save the document as Chapter Outline in your folder.
On Your Own Assignment (2/13/06)
Create a new document that lists Periods 1-7 and the corresponding classes that you have each period. Below that list type each class name and under each name explain what you are working on for each of your classes.  Then Hyperlink each class in the list at top to their appropriate heading below.  Save this document as BHS Classes.

Create a second document and call it BHS Classes 2.  Again list each class at top and create a heading below for each class. Under each heading explain what you like and don't like about each class.

Assignment: (2/16/06)

 Personal Webpage Assignment -

The web page must have four pages total.  
1.    About me page (homepage)
2.    Family page

3.    Favorites page

 
4.    Schedule page

You are being graded on:

Number of Points

 

 
1.    Digital Picture of yourself 5
2.    Scanned picture 5
3.    Other images and graphics  from Internet 5
4.    Word Art - all titles must be in word art 5
5.    Tables  - there must be a table on every page 5
6.    Backgrounds - all pages must have a background 5
7.    Hyperlinks - all hyperlinks must work properly 5
8.    Spelling/Grammar 5
9.    Having all four pages 20
Total 60

 

Assignment - On Your Own Assignment: (2/28/06)

Newsletter:  Create a one-page newsletter. Create at least 3 or more different articles. Write the articles in your own words. In the newsletter include the following elements:

  • A title for the Newsletter in size 48, serif font.
  • A line for the Volume, Issue number, and date of publication.
  • Dropped capitals to the first paragraph of each article.
  • A pull-out box which utilizes, shading and either 3-D or shadow border effect.
  • At least 2-3 small graphics.
  • Borderlines to set off info at the top of the newsletter.
  • Apply a page border.

When the document is completed. Proofread & spell-check it and then print it off and hand it in.

 
Write 150 words on each of the  following writing prompts. Write these in the same document and save the file as: 2-24-06
  • Write a letter to the 10-year old child you had been.
  • Where do you go when you want to get away from the pressures of life, family, work, etc? Write about that place in 150 words.
On Your Own Assignment: (3/03/06)

Survey:  Create a one-page survey on your choice.  Make sure to save document as a template and name it Survey.  Create your form in a table so you have more options. Include the following:

  • Text form fields
  • Check boxes
  • At least one drop down box with at least 4 choices
  • At least 10 different items to answer
  • Add design and color to your form.

When you are satisfied with it make sure to Protect your form.

On Your Own Assignment: (3/06/06)

Create a Logo similar to Ex 81 using the 3 initials of your name. Also include a graphic of your choice. Make sure the image is no larger than 2 inches wide by 2 inches high. Save as Logo.b

On Your Own Assignment: (3/07/06)
Create a watermark similar to Ex 85. Locate your favorite saying or a poem or some type of inspirational message and use it for your text. Locate a graphic to coordinate with the message.  Save as Watermark.
MICROSOFT EXCEL
(3/24)On Your Own Assignment: You recently were informed that you won a prize of $1,000,000.00.  The only stipulation was that you must spend your money in at least 10 different shops.  Get into Microsoft Excel, blank spreadsheet and Create the following column headings:   Store Name, Item purchased, and Cost. Below your Heading you will have 10 rows with the specific information on how you plan to spend the money.

Incorporate the following into your spreadsheet:
__Change the font color and fill color in the Heading Row, and make the text Bold.
__Click on the currency icon in your toolbar for the cost figures.

__Incorporate the Count function

ISave this document in your  folder as millionaire

 
 
(Mar 31st) Writing Assignment: Write a 200-word description of a place. You can use any and all descriptions but sight: you can describe what it feels like, sounds like, smells like and even tastes like. Try to write the description in such a way that people will not miss the visual details. Save as SIGHT

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 
 
Assignment Tues. May 3 - Fri. May 6

Powerpoint Links

Tips for creating PowerPoints

Backgrounds for PowerPoints

 

Assignment for Friday April 22
Complete the following Exercises:

P.  11-35 Exercise 10

P. 12-31 Exercise 10

Assignment for Friday April 8
  1. Design a database to track homes for sale in the Beresford, Centerville, and Alcester area.
  2. Save the file as HOMES.
  3. Format the worksheet attractively, adding a title, some clip art, and some color.
  4. Surf the Internet to locate the houses for sale and the information about each one. Also include your own home that you live in and try to list what you think a realistic price would be for it.

www.farmandhomerealestate.com

jensenins-re.com

www.webersd.com

5.  Include columns for the asking price, address, neighborhood or association, square footage, # of bedrooms, and extras, like a family room, bonus room, study, basement, fenced yard, and so on.

6.  Answer some key questions using the information in your database. Type the question and the answer in your spreadsheet on Sheet2.  Here are the questions:

   a.  Which house is the most expensive in each neighborhood?
   b.  Which house is the least expensive?

     Sort the house by square footage and answer the following

   c.  Which house has the most square footage? What is its asking        price?
    d. Which house has the least? What is its asking price?

Sort the house by the number of bedrooms (key 1) and by square footage (key 2) and answer the following

    e.  Which houses have the same number of bedrooms as yours? What are their asking prices?
    f.  Which house has square footage closest to the amount in your own home? What is its asking price?
     g. Do the houses that are similar to your have features that yours doesn't?

RENAME Sheet1 to Real Estate     
RENAME Sheet2 to Questions

SAVE YOUR WORK FREQUENTLY!!

 

 

 

 

 

 

 

 

 

 

 

 

Mon Mar 14 Tues Mar 15 Wed Mar 16 Thurs Mar 17 Fri Mar 18
Ex 33
Ex 34
Ex 39
Ex 41
Ex 44
Ex 45
Ex 47
On Your Own Exercise

 

 

 

 

 

 

 

 

 

 

 

 

 

Mon Feb 21 Tues Feb 22 Wed Feb 23 Thurs Feb 24 Fri Feb 25
NO SCHOOL EXCEL
Ex 7
Ex 8 On Your Own
Ex 9
On Your Own Exercise
Ex 13
On Your Own Exercise
Ex 14
On Your Own Exercise
Mon Feb 14 Tues Feb 15 Wed Feb 16 Thurs Feb 17 Fri Feb 18
Ex 79
Valentine's Card Assignment
Ex 80
Ex 81
Sign Assignment
Ex 82
Watermark Assignment
WORD TEST Writing Assignment
All Word assignments must be completed by today!
Mon Feb 7 Tues Feb 8 Wed Feb 9 Thurs Feb 10 Fri Feb 11
Ex 67 Newspaper Column

Ex 68 Dropped Capitals

 

Ex 75 Graphic Objects, Text wrap, Clip Art

Newsletter Project

Newsletter Project Newsletter Project NO SCHOOL
Mon Jan 31 Tues Feb 1 Wed Feb 2 Thurs Feb 3 Fri Feb 4
Finish Web page projects & begin to present Finish presenting web page projects
Ex 52 Form Letters
Ex 60 Footnotes, Endnotes & Comments
Ex 74 Track Changes, Accept/Reject changes
Ex 67 Newspaper Column

Ex 68 Dropped Capitals

Ex 75 Graphic Objects, Text wrap, Clip Art
Mon Jan 24 Tues Jan 25 Wed Jan 26 Thurs Jan 27 Fri Jan 28
Ex 49
Ex 51
Ex 50 Finish Ex 50
Start web page project
Web page project Web page project

Be ready to present projects on Monday

Mon Jan 17 Tues Jan 18 Wed Jan 19 Thurs Jan 20 Fri Jan 21
NO SCHOOl Ex 29
-Bulleted Lists
-Numbered Lists
On Your Own Assignment
(Goals)
Ex 31
-Vertical Alignment

Ex 35 
Word document as a Web Page

Ex 45-47
Tables
Ex 49
Writing Assignment
Mon Jan 10 Tues Jan 11 Wed Jan 12 Thurs Jan 13 Fri Jan 14
Finish Letters & Envelopes & Ex 24-2 On Your Own Exercise 
Click Here for Directions
Ex 26 &
On Your Own Exercise
Click Here for Directions
Ex 28 & On Your Own
Click Here for Directions
Writing Assignment

Click for Directions

Mon Jan 3 Tues Jan 4 Wed Jan 5 Thurs Jan 6 Fri Jan 7
No School Classroom rules, course syllabus, writing assignment Ex 11 Business Letter

Ex 12 personal business letter

Compose your own letter to a relative. Save as My Letter

Margins:
Top: 1.5"
Left: 1"
Right: 1"

Proofread letters. Correct letters & hand in.

Ex 24-1
Top: 2"
Left: 1"
Right: 1"

Mon Jan 10 Tues Jan 11 Wed Jan 12 Thurs Jan 13 Fri Jan 14
 

Assignment (1/11/05)
Draft an announcement about an upcoming event in your life. For example, the event could be your birthday, confirmation, a party, or a vacation trip...
*Right -align your name and address below the title.
*Add two paragraphs that describe the event in detail. Justify these paragraphs.
*Add other lines giving the time and location of the event as well as directions. Use left, right, & center alignments to organize and format other lines.
*Try different vertical alignments until you settle on the one that makes the document look the best.
*Apply fonts, font styles, and font sizes to the document text. Change the fonts to emphasize various parts of the document. For example, you will probably want to highlight the title by giving it a large, distinctive font.
*Apply alignments to improvethe appearance of the document.
*Name this document Announcement  when you save it in your folder.
*Print it out and hand it in.

Assignment (1/12/05)
Create your own document for a store that includes the products and prices.

You must utilize the following in your document:

The name of the store at the top set apart from the rest of the text.

4 different text effects.
2 different styles of underlines.
3 different font colors.

Tabs including a decimal tab, when you list the products & prices.

Save this document as Store Prices in your folder.
DO NOT PRINT THIS DOCUMENT.

Assignment (1/13/05)
Create a Flyer for an upcoming school activity.  Check on the school website calendar if you can't think of anything.

Make sure to include the following:

Event
Date
Place
Admission if any
Use different size fonts and font styles
Add font effects and symbols to decorate the flyer

Save this document as EVENT in your folder.

Writing Assignment: (1/14/05) Do a  review on a movie that you have recently seen. Must be at least 250 words.  Save as:  Movie Review.  Make sure to use complete sentences and check your spelling. At the end of the review give it a Thumbs up or a Thumbs down using the Insert Symbol Command.  Make the Thumb a bigger size so it is noticeable!
On Your Own Assignment (1/18/05)

1) Type a bulleted list of five things you'd like to accomplish in the next year. These can be goals for school, work, or personal development. Examples might include earning a better grade in math, completing a project on the job, or getting in better shape by exercising and eating right. (Format your bullet to be a picture you locate from the Internet) 

2) Sort the list in alphabetical order.

3) Type a numbered list that includes at least five steps describing how you expect to accomplish one of the items in the bulleted list.

4)SaveAs Goals in your folder.

 

Writing Assignment: ( 1/21/05)
If you could only take 3 people with you on a trip around the world, who would you take and why? Explain where all you would go and what you would do.  (250 words)

 

 

Assignment: (1/26/05)

 Personal Webpage Assignment -

The web page must have four pages total.  
1.    About me page (homepage)
2.    Family page

3.    Favorites page

 
4.    Schedule page

You are being graded on:

Number of Points

 

 
1.    Digital Picture of yourself 5
2.    Scanned picture 5
3.    Other images and graphics  from Internet 5
4.    Word Art - all titles must be in word art 5
5.    Tables  - there must be a table on every page 5
6.    Backgrounds - all pages must have a background 5
7.    Hyperlinks - all hyperlinks must work properly 5
8.    Spelling/Grammar 5
9.    Having all four pages 20
Total 60

 

Newsletter - On Your Own Assignment:

Create a one-page newsletter. Create at least 3 or more different articles. Write the articles in your own words. In the newsletter include the following elements:

  • A title for the Newsletter in size 48, serif font.
  • A line for the Volume, Issue number, and date of publication.
  • Dropped capitals to the first paragraph of each article.
  • A pull-out box which utilizes, shading and either 3-D or shadow border effect.
  • At least 2-3 small graphics.
  • Borderlines to set off info at the top of the newsletter.
  • Apply a page border.

When the document is completed. Proofread & spell-check it and then print it off and hand it in. Save As Newsletter.

 

Assignment - 2-15-05

  Create a sign which includes the following:

  • Autoshapes grouped together

  • Autoshapes layered

  • Script font

  • WordArt utilizing curve button

Save as Sign.

Writing Across Curriculum Assignment: 

 Write 150 words on each of the  following writing prompts. Write these in the same document and save the file as: 2-18-05

  • Write a letter to the 10-year old child you had been.
  • Where do you go when you want to get away from the pressures of life, family, work, etc? Write about that place in 150 words.

 

2-22-05 On Your Own Exercise
Plan 3 trips you would like to take anywhere in the world. Using an on-line air travel website, figure the cost for a round trip to each of these places. Use appropriate titles above your columns, format cells with currency when you list the price. Save as Trip in your Excel folder.
MICROSOFT EXCEL

(3/18)On Your Own Assignment: You recently were informed that you won a prize of $1,000,000.00.  The only stipulation was that you must spend your money in at least 10 different shops.  Get into Microsoft Excel, blank spreadsheet and Create the following column headings:   Store Name, Item purchased, and Cost. Below your Heading you will have 10 rows with the specific information on how you plan to spend the money.

Incorporate the following into your spreadsheet:
__Change the font color and fill color in the Heading Row, and make the text Bold.
__Click on the currency icon in your toolbar for the cost figures.

__Incorporate the Count function

ISave this document in your  folder as millionaire

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Assignment for 11/24/04 - Christmas List
Create a spreadsheet that contains a list of names for people you would like to give something to for Christmas. For each person create a list of items that you would consider giving them. Search the Internet for the prices of the products you have listed also copy the URL and paste that into a cell next to it so you can easily locate it.

Some of the possible headings you should have include: name, item, store, price, url.

Format the sheet background with a decorative holiday graphic. Format your column and row labels with colors and patterns.

Save this document in your Excel folder as Christmas List

Writing Assignment for 12/3/04 - Save as Headlines
Write about 5 Headline News Stories that have happened within the past week. Have at least 2 National, 2 State, and 1 local story.  After you explain the stories include what your thoughts are about each one.
On Your Own Assignment for 12/8/04 - Save as Television
1.  Start a blank spreadsheet document. Create a worksheet that tracks your television viewing for the past week.  Save the file as Television

2.  Include these categories, or something similar:

  • Sports
  • News
  • Situation Comedy
  • Drama
  • Reality
  • Movies
  • Other

3.  Include a column for each day of the week.

  • In the appropriate cells, type a value that equals the number of times you watched a program matching that category on that day.

4.  Create totals for the number of programs watched each day, and also the number of programs watched in each category for the week.

5. Create a chart (on its own sheet) that best illustrates the proportion of time you spend watching programs of each category.

6.  Create another chart (on its own sheet) that best illustrates the difference between the number of times each day you watch a news show versus a situation comedy.

7  Save the file and exit Excel.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(4/30) Writing Across Curriculum Assignment: 

(3/24) Writing Across Curriculum Assignment:  Choose one of the following writing prompts and write 200 words on it and email it to: dcoggins@bmtc.net.

OR

(3/2) On Your Own Assignment:  Use on-line air travel sites to figure costs, arrival and departure times, etc for 3 different trips.  You select the trips you want to go on. Set this up in a spreadsheet similar to Ex 9.  Save the file as Flight.

(2/27)On Your Own Assignment: You recently were informed that you won a prize of $1000.00.  The only stipulation was that you must spend your money in 10 different ways.  Get into Microsoft Excel, blank spreadsheet and Create the following column headings:   Store Name, Item purchased, and Cost. Below your Heading you will have 10 rows with the specific information on how you plan to spend the money.

Incorporate the following into your table:
__Change the font color in the Heading Row, and make the text Bold.
__Click on the currency icon in your toolbar for the cost figures.

Inside of  Dawg 2/HSpublic/Computer Science.  Go to the appropriate period and create a folder for yourself. Save this document in that  folder as millionaire

2-27, Writing Assignment:  Write 250 words (total) with complete sentences on the following statements:

Email me at the address listed above.


 

2-25, On Your Own Assignment: Locate a poem and search for a graphic to go with it. Make the graphic a watermark and format your poem on top. Format the text with readable fonts, use color, styles, sizes, line spaces to make the Poem fit on one page.  Make sure the title is bigger and bolder than the rest of the text.

2/20) Writing Assignment: Write a 200-word description of a place. You can use any and all descriptions but sight: you can describe what it feels like, sounds like, smells like and even tastes like. Try to write the description in such a way that people will not miss the visual details. Email me at dcoggins@bmtc.net

Newsletter - On Your Own Assignment:  Create a one-page newsletter. Create at least 3 or more different articles. Write the articles in your own words. In the newsletter include the following elements:

When the document is completed. Proofread & spell-check it and then print it off and hand it in.

 

Writing Assignment: (2/11/04)  Write about the scariest moment you have had in your life. Email 250 words to my email address:  dcoggins@bmtc.net.  Proofread your work before you email it!!

Writing Assignment: (1/30/04) Do a  review on a movie that you have recently seen. Email 250 words to my email address above.  Make sure to use complete sentences and check your spelling.

On Your Own  - Create a personal web page.   Create a new folder inside your Computer Science folder called Web.  This is where you will save your web page and graphics to. Save your web page as your name. On the first page include information about you, your family, your interests, your goals.  Off of your main page include links to at least 2 other pages. One will be about a club or an activity you are involved in. The other page will be a schedule of your school day with links to the teacher's web page.  Make sure to add a background.
Web page must include the following elements:
*Background
*Table
*Graphics
*Graphic or horizontal lines (inserted as dividers between sections)
*Word Art
*Include a scanned or a digital picture of yourself.

Assignment (1/23/04)
Writing Across Curriculum assignment - Respond to Janklow's sentencing. Do you think it is fair? Why or why not?  What type of community service do you think he should perform? 

Assignment (1/9/04)
Draft an announcement about an upcoming event in your life. For example, the event could be your birthday, confirmation, a party, or a vacation trip...
*Right -align your name and address below the title.
*Add two paragraphs that describe the event in detail. Justify these paragraphs.
*Add other lines giving the time and location of the event as well as directions. Use left, right, & center alignments to organize and format other lines.
*Try different vertical alignments until you settle on the one that makes the document look the best.
*Apply fonts, font styles, and font sizes to the document text. Change the fonts to emphasize various parts of the document. For example, you will probably want to highlight the title by giving it a large, distinctive font.
*Apply alignments to improvethe appearance of the document.
*Name this document Announcement  when you save it in your folder.
*Print it out and hand it in.

 

 

 

 

Powerpoint Links

Tips for creating PowerPoints

Backgrounds for PowerPoints

 

 


 

Mrs. Swanstrom's Home Page

Back to Top

Rubric for Web Page Assignment