Computer Applications

 

Computer Applications - Projects

College Newsletter

Database

Flash Animation

Spreadsheet

Web Site Creation

Digital Video

 

 

College Newsletter

Introduction

Choosing a college is one of the first big decisions that you will make that will shape your future life.  What characteristics are important to you in a college?  In this project you will put together a newsletter about one college. You are a journalist  for an independent company that produces newsletters that are designed to give high school juniors and seniors an encapsulated view of a college.  Each newsletter is two to three pages long and covers a specific set of information.   You are newly hired, your first project is to design and write one newsletter to add to the company's selection.

Introduction|Task|Process|Evaluation|Conclusion

Task 

Using Microsoft Publisher 2000 create a newsletter about a college of your choice.  Toward a balanced, attractive, and easily read newsletter, you will need to use:

Background/borders
Headlines and Article Titles
Word Art
Clip Art and/or Photos
Text Boxes
Design Elements (fonts, color, shapes, ruled lines, etc.)

The following articles (in separate text boxes) must be included:

Location
Size
Tuition and fees
Admission Requirements
Activities and Sports of Interest
Majors of Interest

Introduction|Task|Process|Evaluation|Conclusion

Process

  1. Decide which college will be the subject of your newsletter.   Pick a college that you are interested in attending.  If you need ideas go to www.collegenet.com and use the search option.

  2. Go to the web page of the college and/or use the college's catalogue (our library has some) to locate the information you need.

  3. Decide on a visual theme for your newsletter.  For example you might use a musical theme, thus your borders, ruling lines, and article titles would follow the theme and contain notes or CDs or people dancing .

  4. Write your articles.  Each article should provide information (i.e. The school is located in Newark, Delaware), but should also provide detail about the implications of that information. (i.e. It is a small town, so you won't have to be concerned with crowds, but don't expect a fully developed bus transportation system.  So if you don't have a car . . . ) Articles should be between one and two well developed paragraphs (8 to 10 sentences).

  5. Find pictures and clip art to enhance your articles.  Be sure to save all in your own file folder.

  6. Finish the layout process.  Be sure to include a Headline for the newsletter and titles for each article. Your newsletter should be between two and three pages.

  7. Print your newsletter.

Introduction|Task|Process|Evaluation|Conclusion

Evaluation
The journey we take to accomplish this project is a goal in itself, but as grades are expected to be assigned I will use the scoring system below to assess your final product:

Project Name: Newsletter    
Student Name:    
Filename: Z:\    
Item Possible Points Earned Points
Followed directions -- project is printed (2-3 pages) and saved in correct folder on system, all files needed by the project are in the same folder. 10  
Demonstrated proficiency with tools used -- used a variety of objects to achieve purpose of project. Including:
Backgrounds and borders(5) _____
Headline (4)_____
Word Art(5) _____
Article titles(6) _____
Clip Art and Photos(6) _____
Text Boxes(6) _____
Design Elements(3) _____
35  
Layout is pleasing to the eye  -- used a variety of pictures, fonts, colors, etc. in a balanced, themed format. 10  
Layout is easy to read -- colors used and font choices allow the user to see clearly and direct the user's focus to logically proceed to the next item.  10  
Content reflects thought and communicates clearly. Content is free of grammar and spelling errors.
Required:
Location (6) _____
Size(5)_____
Tuition and fees (6) _____
Admission Requirements (6) _____
Activities and Sports of Interest (6) _____
Majors of Interest(6) _____
35  

Total

100

 

Introduction|Task|Process|Evaluation|Conclusion

Conclusion

Has your knowledge about the college you studied increased?  As you consider other colleges to attend do you know what to look for?

Database Project

You will be given a set of specifications, similar to what we have done in class.  Based on the specifications you will need to create the data base, enter the data (given), search by form, create queries, sort, and print reports. You will receive the specifications in class. A scoring rubric will accompany your graded project.

Macromedia Flash

In this project you will put together a music video via Macromedia Flash. You are a web designer for an independent company that produces music videos for new artists. These videos are designed to give web viewers a taste of the new artist's music in a fun way.  You are newly hired, your first project is to design and create one video to add to the company's selection.

The scoring rubric will be posted soon.

Spreadsheet

Given $10,000. (in fictitious money;), you will decide which stocks are worthy of your investment.  Each day for 5 days you will check the value of your stocks and enter formulas to calculate the value of each stock in your portfolio and the total value of your portfolio.  At the end of 5 days, you will graph the value of your portfolio over time.

Stock Market Spreadsheet
Name
Points Points   
Earned Possible Category
  10 Spreadsheet layout is clear, color and white space used well.
  10 Data entered is correct -- Ticker symbols, stock names, prices.
  10 Data for stock prices is collected for 5 days.
  10 Formulas calculate value for each stock and total value of portfolio.
  10 Graph shows the changing value of the portfolio over 5 days, is clearly labeled and is sized well.
  50 Total

Web Site Creation

With all the money you made in the stock market this year, you decide that you will take an extended vacation.  You don't want to get bored though, so you take your laptop with you.  You decide that it is time that you made a web site for yourself.  You make up the idea for the site -- explore an interest or hobby, a travel log of your pretend vacation, or anything that you will find fun to work with.  Really show off your style.  You need an index page and 3 sub pages. Look at the rubric for technical requirements.

  

Web Site Scoring Rubric
Name
Points Points   
Earned Possible Category
  10 Followed directions -- project is saved in correct folder on system, all files needed by the project are in the same folder. Original scoring rubric turned in.
  20 Design elements: you follow the design principles of balance (4)_____    and readability(4) _____

Backgrounds(4)___ 
Titles in Window title bar (4) _____
Copyright/last_updated/mailto -- in a common border (4)_____

  20 Navigation: your work is easy to navigate within, you use a consistent method of linking your index page to all other pages.  The 3 sub pages follow the same navigation scheme and have a consistent method of returning to the index page.
  20 Content: 
You include a clear introduction on the index page (5)____

Your work includes appropriate information that is clearly communicated, is original, and is free of errors (15)_____ 

  30 Multimedia: your work uses a variety of objects including: 
tables(5)______
pictures (min.4)(5)______
marquee(5)______
Rollover Effect (5)______
Hover Button (5)______
Front Page Effects (5)_____
  100 Total

Digital Video

You have been hired by a video company (you have had a real variety of employment opportunities this year ;) to make a series of 30 second public service announcements that will be posted on a health website for kids (Kid's Health).  As a new employee, the company has asked you to make one video, so that they can see your style.

The scoring rubric will be posted soon.

 

 

ŠJudith Conway 2005            Last updated: 07/09/05