Educ 3412: Computers in Education. Final Exam Preparation

Point Value: 30 points out of a course total of 100 possible points

Please begin by creating and naming a folder on your desktop. Save all your work today into this folder.

Part I: 10 points

Option A: Advanced Word Processing/Desktop Publishing. Topic: Your favorite season (and your reasons for loving it) OR Useful technology gadgets and related stuff

• Select one of the above topics, and incorporate an effective variety of the following items into one page of advanced word processing/desktop publishing which informs readers about your selected topic
  1. A modified layout from galleries, assistants, or templates; or create your layout from scratch
  2. Multiple borrowed digital images: modify if appropriate and effectively cite your source
  3. Thematic combinations of typefaces, point sizes, and font colors
  4. Thematic lines, shading, shading patterns, text boxes, borders, and colors
  5. Appropriate document margins, headers, footers, page numbers, and other organizing information
  6. Text columns, bullets, numbering, drop caps, shapes, auto shapes
  7. Line spacing, indentation, text orientation
  8. Other items and effects as you choose
• Please check your document for spelling and grammar errors.
• Save your document once in its original file format and once in another file format. Both documents should have appropriate file extensions.
• Place these documents in your desktop folder. In Part III of this exam, you'll link these as downloads to your website.

Option B: Interactive Multimedia Presentation. Topic: Your favorite season (and your reasons for loving it) OR Useful technology gadgets and related stuff

• Select one of the above topics, and incorporate any variety of the following content items into a 5 slide PowerPoint teaching tool
  1. An original and thematically fitting slide background
  2. A "home" control slide or repeated navigational element featuring interactive internal links
  3. Selective and concise use of text in appropriate typefaces, point sizes, and colors
  4. 5+ borrowed and appropriate images which help illustrate your main points
  5. URL links to cited sources (and other resources as you choose)
  6. A repeated slide footer including your name and page numbers
  7. High-contrast, readable content
• Please check your document for spelling and grammar errors
• Save your document once in its original file format and once in another file format. Both documents should have appropriate file extensions.
• Place these documents in your desktop folder. In Part III of this exam, you'll link these as downloads to your website.

Part II: 10 points

Option C: Spreadsheets. Topic: Duluth's annual temperature/precipitation

• Find Duluth's annual temperature using the following website: http://climate.umn.edu/doc/journal/dlh2000.htm
• Use this information to create a spreadsheet for Duluth's annual temperature

On Sheet One:

1. Record the words Duluth, Minnesota
2. Record the words Annual Temperature
3. Insert a hyperlink to the above climate web page (or another good Duluth page of your choosing)
4. Modify or AutoFormat your used cells for optimal readability
5. Change the name of sheet one to: About Duluth

On Sheet Two:

1. Create an Educ 3412: Duluth's Annual Temperature/Precipitation heading
2. Create columns entitled: Month, Average Temperature, Maximum Temperature, and Minimum Temperature (or Month, Total Precipitation, and Total Snowfall)
3. Create a row for each month of the year
4. Create a row entitled: Annual Averages
5. Enter in the values for the Average, Average Maximum, and Average Minimum temps
6. Use AutoSum to calculate the average temp for all months combined, average max temp, and average min temp
7. Modify or AutoFormat your used cells for optimal readability
8. Change the name of sheet two to: Weather data
9. Select your cells containing useful information and use the Chart Wizard to create a useful chart for your information
10. Label all information on your chart and give the chart a fitting title
11. Place your chart on sheet three

On Sheet Three:

1. Place your chart on sheet three
2. Label all of your chart's information for clarity
3. Verify that you've given sheet three a fitting name
• Delete any unnecessary sheets from your spreadsheet workbook, and organize your sheets in logical order
• Please check your document for spelling and grammar errors
• Save your document once in its original file format and once as a PDF file (or .html file if you choose). Both documents should have appropriate file extensions.
• Place these documents in your desktop folder (if you chose a .html file, also place the folder of associated files in your desktop folder). In Part III of this exam, you'll link these--perhaps as downloads--to your website.

Option D: Database and Mail Merge. Topic: Dream jobs OR your favorite places to eat

Database:

• Modify an existing database template to create a database of dream jobs or your favorite places to eat
  1. Construct your database from an existing "Contact Management" (or similar) database
  2. Create five records
2. Fill in company, notes, and main address fields (first name, last name, and title fields are optional)
3. Modify your database's appearance so that says "Dream Jobs" or "Favorite Places To Eat"
4. Sort your database in ascending order by company
• Please check your document for spelling and grammar errors
• Save your document to your desktop using "Save As" and naming it to reflect your username
• Place this document in your desktop folder. In Part III of this exam, you'll link it as a download to your website.

Mail Merging:

• Create or modify a document which communicates as described below:
1. Modify or create an MS Word document which contains your name, a UMD logo, and your student address.
2. On this letterhead, compose a simple but professional letter to your dream job or favorite place to eat. While keeping your letter to the point, express your appreciation to your audience or recognizing them for their success.
3. Into your letter, merge information from three or more database fields.
4. Merge your information into one document
• Please check your document for spelling and grammar errors
• Save your document in two different file formats. Both documents should have appropriate file extensions.
• Place these two documents in your desktop folder. In Part III of this exam, you'll link these as downloads to your website.

Part III: Linking your final exam files to your web site: 10 Points

• Link your files from Part I and Part II to your web site's professional page. Be sure to locate these in a predictable location on your page.
  1. Modify your web site's professional page so it contains a Final Technology Proficiencies section
  2. Link your files from Part I in two file formats to this section
  3. Be clear about identifying for your reader which files will function as downloads and which (if any) will appear as html hyperlinks
  4. Link your files from Part II in two file formats to this section
  5. Be clear about identifying for your reader what files you're linking and that these files are downloads
  6. Put your files to the web
  7. Check your work via a web browser (watch to see that what you're viewing is the actual URL of your web site--rather than a preview of your desktop)

Part IV: Backup method for submitting your work to Dan.

• In addition to attaching your files to your professional web page, please clearly label your files with your username and other useful information and burn these to a compact disk which bears your username and final exam.
• Please submit your CD to Dan (so I can evaluate your work--in case it does not successfully appear on your web site).

Thanks for your work this semester. Best wishes for the days ahead.

--Dan