Assignments for Computer Concepts

A. Skerker


 

References for Microsoft Office products

 

 

Place the Teaching and Learning CD [disk 2] in your computer. If it does not start automatically, goto My Computer and double-click on the CD icon. Notice the Blue bar that runs across the top of the screen. Left click on Classroom resources and then select In & Out Of The Classroom. Once the In & Out Of The Classroom menu appears click on Office 97. the select Hands-on Exercises

 

 

 

 

 

 

 

 


Thursday, 9-4-03

Welcome to Computer Concepts!

This afternoon we will go over the objectives for the course and then will begin with some technology basics. Your task today is to establish a folder on the "D" drive where you can store your assignments. When you go back to your dorm, check out your computer for this information; how much ram do you have, how large is your hard drive and how much space is available on this drive?


Tuesday, 9-9-03

Wear your smiles to class this afternoon, we will be taking digital photographs with our sony Mavica camera. You will learn how to import your photo into a Word file. Once in the file, you will resize the picture and learn how to flow the text around it. You will also learn how to add section breaks and move your text into multicolumns.

reminder: quiz on chapter 1, Thurs. 9.18.03

Thursday, 9-11-03

Newsletter Assignment and Scoring Rubric

Your task: You are to develop and submit a two page newsletter using Microsoft Word. Include the following;

What should your newsletter be about???

Tell me about yourself. [I'll give you some ideas in class.]
 
 

Upon completion of this assignment you should feel comfortable using Word. You will also learn how to take and import digital pictures using a Sony Mavica camera.
 
 

The following rubric will be used for scoring your project.

Use it as a self-assessment tool.

   exemplary [5 pts.] acceptable [3 pts.] needs work [1 pt.]

 score
 syntax/spelling  no errors  a few errors  multiple spelling and grammar errors  
 banner headline WordArt properly sized, centered  missing one of the banner requirements  missing two or more of the banner requirements  
 second line of text + evidence of bulleted or numerical list  all requirements met all but one of the requirements met  two or more requirements missing  
 section breaks + multi column text exhibits at least three section breaks with different numbers of columns in at least two two sections + title section  missing at least one item from exemplary box missing more than one item from exemplary box  
 a banner or star with your name glued into a group  your name does not have a border around it; text is wrapped around the graphic  missing one of the required elements missing more than one element  
 use of stylized elements + borders  all requirements met  all but one of the requirements met   two or more requirements missing  

reminder: quiz on chapter 1, Thurs. 9.18.03
Tuesday, September 16, 2003

reminder, quiz on chapter 1, on Thurs.

This afternoon we will learn some of the basics of Microsoft Excel, the most popular spreadsheet program in the world.


Thursday, September 18, 2003

quiz on chapter 1

This afternoon we will experience the use of Paste special and Paste Link so that spreadsheet objects once moved to a word processed document will remain current with any changes in your spreadsheet.


Tuesday, September 23, 2003

reminder, quiz on chapter 2, Tuesday, Sept. 30, 2003

This afternoon you will be given a paragraph with a multitude of data in it. You are to develop a table [with at least two column headings and three row headings] and a corresponding graph or chart. The graph should be titled and have all of its axis labeled. Once the Excel objects have been developed, COPY and PASTE SPECIAL both of them into a Word document with at least a half a page of text. Format each of the objects in Excel so that the text wraps around them. Add a Footer with your name, the date and the phrase original file. Save and print out a copy of this file.
Go back to the Excel document and change the data in cell B-2. Open the Word document and look for the change to have taken place. Change the Footer; remove the phrase original file and change it to changed file. Save you new file and print out a copy. Submit both pages to Mr. Skerker.
On September 6, 2003, Leo went to the supermarket. He purchased 12 pieces of fruit, 2 pounds of meat, 1 gal of milk and 2 boxes of snack cakes. On September 7th, Leo came back to the market. This time he purchased 2 pieces of fruit, 2 gal of milk, 3 boxes of snack cakes and 1.5 pound of meat. On both the 8th and 10th, Leo went shopping. On each of those days, he bought 1 gal of milk, no snack cakes, 10 pieces of fruit and 1 pound of meat.
Thursday, September 25, 2003

reminder...quiz on chapter 2 on Tuesday

Develop three tables [along with a unique graph or chart for each table] to illustrate the following information…


Mary, Jose and Leonard went to McDonald's on a regular basis. On Monday, Mary had two quarter pounders, a large fry, a small coke and two desserts. Jose had the same lunch for three days in row; one quarter pounder, no fries, a small coke and no dessert. On Monday, Leonard had two quarter pounders, three fries, two small drinks and two desserts. Tuesday Leonard and Jose went to Mcdonald's without Mary. Leonard had three quarter pounders, two fries, one small drink and a single dessert. Mary, who was sick on Tuesday, felt better on Wednesday. She had a single quarter pounder, two fries, a small drink and one dessert. Leonard didn't have much money on Wednesday so he was only able to have one quarter pounder, one fry, a small drink and no dessert.

Title your graphs, label as much as you can…place both the tables and graphic representations on one page. Place your name and today's date in the footer (center these elements).

 

Scoring rubric for Excel table and graphs/charts
 

 5

3

1
 self-score  final score
appropriate resizing of cells and fonts all tables are resized properly some resizing lack of appropriate resizing    
data entry into table titles and variables along X and Y axis are centered and boldfaced, data is entered with 2 decimal places [without labels] missing one of the elements missing two or more elements    
graph or chart has appropriate title, legend, and labels X, Y and Z axis are labeled [if graphic allows], title and legend are placed appropriately missing one of the elements missing two or more elements    
evidence of three different graphic representations all three graphs/charts are easily understandable two of the graphics are easily understandable only one of the graphics is easily understandable    
appropriate use of page setup tools, appropriate information centered in footer margins are reduced to 0.5", landscape orientation, appropriate use of spacing on page, requested footer information missing one of the elements missing two or more elements    

Tuesday, September 30, 2003

reminder...Quiz on Chapter 2 on Thursday

Today we begin to look at Microsoft PowerPoint. By the end of the next class you will have produced a six slide presentation with bulleted text, custom animation, transitions, graphics and a colorful background. Place your name and date in the footer.


Thursday, October 2, 2003

Your task this afternoon is to develop a nine slide PowerPoint presentation. Your presentation should include the following; a bulleted list, a photograph placed into a "picture" slide, another picture or graphic that takes up an entire slide, an ORG chart that represents part of your family tree, transitions and animations. Print out your presentation in the handout format (9/page).


Reminder...class is cancelled for Tuesday, October 7, 2003
October 9, 2003

reminder...quiz on chapter 3 on Tuesday, October 14, 2003

We will continue exploring the capability of PowerPoint. Using altavista.com, you will download and add a video to your slide-show. Your show should have at least two videos (that are less than 30 seconds each). One of the videos should play automatically and the second should be initiated with a mouse click. Print out out your slide show (six slides per page), and then run the presentation for Mr. Skerker.

October 14, 2003

Quiz on chapter 3

Your task this afternoon is to develop a PPT nine-slide show detailing what has been going on in the news this week. (Include information about the two Egyptian boys who were surgically separated in Texas, the supposed Saddam sightings and the Chinese astronauts)Your show should have the following elements: transitions, animations of text, at least three appropriate graphics and a short movie or the URL of a movie. Place your name and date in the footer. Print out your presentation so that all of the slides appear on one page. (Include the URLs of any of the information that you download.)

reminder...quiz on chapter 5 on Tuesday, October 21, 2003

October 16, 2003

The last few weeks have not been peaceful ones in the world. There has been a tremendous amount of violence in the middle east. Three Americans died in a bombing incident. In Staten Island, NY there was a terrible ferry accident and some good news; the Chinese astronauts came home successfully. Your task is to document some of the events that took place and submit a Word or Excel file with the following included:

 

  • What actually happened?
  • Where did the incidents occur?

 

Your table should allow for text wrap and automatic resizing [autofit] of the rows. Upon completion of the assignment, save it on your disk and then print out a copy for me. [place your name and the date in the footer] A suggestion…besides using the search engines that we've explored, you might want to look at some online news sources such as CNN.com, abcnews.com, etc. Your name and today's date should appear in the footer.

scoring rubric
 

 5 pts.

 3 pts.

 1 pt.

 score
2 pictures pictures properly sized to no more than 2"X3" missing one of the elements missing more than one of the elements  
a table with three columns and four rows with all of the information that was requested, demonstrating autofit and text wrap missing one of the elements missing more than one of the elements  
information presented in the table proper syntax, factually accurate, with appropriate sources listed missing one of the elements missing more than one of the elements  

October 21. 2003

quiz on chapter 5

Your task today is to do some vacation shopping. Find three vacation getaways; one in Florida, a second in Spain and one more in Hawaii. Use a spreadsheet to list the locations, description of the vacation package, a picture (resized to no more than 1.5" X 2") and the URL for each. Place your name and today's date in a header.


October 23, 2003

Your task today is to spec out a new computer system. Your system will include a brand name computer [Dell, Compaq, Gateway, etc.] with a Pentium processor of at least 2.6 ghz, 512 mb of ram, a 80 gb hard drive, a DVD and a separate CDRW, a 19" monitor, Microsoft Office Professional, at least a six month subscription to an antiviral program, speakers and a 3 year warrantee. Additional peripherals should include a laser printer, a scanner and a digital camera. You have $3000.00 to spend. (Hint...you may purchase your computer and peripherals from different vendors.)

Take all of your data and develop it into a spreadsheet format. Include a picture of your system. Use the footer for your name and date.


October 28, 2003

reminder...review quiz on Thursday - October 30, 2003

This afternoon you will learn how to use Inspiration for concept mapping and webbing. If you would like to download a complete working demo copy of Inspiration for your own computer, goto Inspiration.com


October 30, 2003

review quiz

Your task this afternoon is to design an Inspiration presentation. The main idea for your presentation is My Life by your name. You will need to have at least six items that come off of My Life and at least two items that come off of each of the subordinate ideas. Your diagram should have the following:

You will need to print out two pages. Print out a copy of your Inspiration diagram and after you export your outline to PowerPoint, print a handout copy (9 slides per page) of presentation.


November 4, 2003

reminder...quiz on Chapter 11, Thursday, November 13, 2003

Your task today is to detail some of the news events that occurred in the last 48 hours. Using Inspiration, you are to develop a diagram that discusses:

For each of these topics, you will need to have at least two relevant subordinate comments and a photo from your favorite news source. Your links should be at least 2X the normal thickness and they should exhibit at least three bends. Once you have completed your diagram, Export the outline as an Microsoft Word RTF into Word. On to that same Word page, include the export diagram as a JPEG. Use a header for your name and today's date.


November 6, 2003

reminder...quiz on Chapter 11, Thursday, November 13, 2003

This afternoon you will learn some of the basics of Microsoft Access.

November 11, 2003

reminder...quiz on chapter 11, Thursday, November 13, 2003

Your task this afternoon is to design a database and then print and submit out a report (the report should have all the data on one page).
Sort your information by price and then date .

Cars sold during the last two years.

 year

 make

 color
 radio

  price
 type  tires  hp

 date purchased
 1947  Buick green no $42,000 convertible black 35  3.27.03
 1935 Zepher black no $36,500 convertible black 52  3.15.03
 1959 Caddie red yes $12,500 convertible white 325  4.15.01
 1967 Mustang green yes $8,500 hard top black 275  1.24.03
 1953 Ferrari red no $325,000 hard top black 125  11.25.02
 1979 Corvette blue yes $18,000 hard top black 325  9.13.01

November 13, 2003

quiz on chapter 11

This afternoon we we learn how to combine a database with a Word document.


November 18, 2003

reminder...quiz on Tuesday, December 2, 2003 on Chapter 12

Your task today is to create the beginning of what will become a mail merge letter. You will need to create two files prior to initiating your merge.
1. Create an Access file. Label it data for merge.
2. In design view, list the following as fields:
Title, L name, F name, address, city, zip (make sure that zip is considered text), pet's name, type of animal
3. Create a Word file; label it letter.
4. Write a brief business letter. Use the following format:

Your address
City, zip

Dear ;

This letter is to inform you that your , , has once again destroyed the flowers in my yard. This is my last and final warning. Blah blah blah. Blah blah blah. Blah blah blah. Blah blah blah. Blah blah blah. Blah blah blah.

Sincerely,

Make sure that you save both of these files into your folder.

In addition to the mail merge letters that you will print out, you will also need to print out mailing labels for the envelop. (I will show you how to use an Access Wizard to do this.)
November 20, 2003

reminder...quiz on Tuesday, December 2, 2003 on Chapter 12

Your task this afternoon is to develop a brochure (a Word document that is landscape oriented) that mentions at least three of the latest stories that are in the news. Each story should have a picture copied from the Internet and resized to not more than 1.5" x 2.5". Your brochure should have three columns, 0.5" margins and text that is 14 point (or less).


November 25, 2003

reminder...quiz on Tuesday, December 2, 2003 on Chapter 12

Class will not meet today

December 2, 2003

quiz on chapter 12

This afternoon you will be given your final project. You will have four class periods to work on the project. Submission date/time for the completed work is no later than the end of class on December 11, 2003.