Grade Guide | Tech Type

ClickWith Spreadsheets

What Is A Spreadsheet?

Do this first:

Bingo Board Spreadsheet | Example | Grade Guide

Bingo Board Categories

Bingo Board Instructions:

  1. Open another browser window besides this one: Bingo Board Categories.
  2. Open AppleWorks; Under file choose New/Spreadsheet.
  3. Under Window Menu, select Page View so that check mark is next to it.
  4. Go to the Window drop down menu and Show Tools.
  5. Under Format Menu: Insert Header
  6. Header Title: Tech Type Bingo Board #1 (24 point; not bold)
  7. Below Header Title, put your first and last name and computer number (24 point; not bold).
  8. Click in a cell. Under Options Menu: Display--Take check mark out of Column Headings and Row Headings.
  9. Under Format Menu: Document--Columns Across--5; Rows Down--6
  10. After selecting all cells in board, under Format Menu: Column width--100; Row height--75
  11. Category Titles: 18 point; Centered
  12. Category Titles must be in alphabetical order left to right going across top row of board.
  13. In center cell of board, type FREE SPACE (all caps).
  14. Words from list: 14 point; Align left; Capitalized
  15. Words from list should not be in alphabetical order.
  16. Save file as Bingo Board 1.

Check the Grade Guide to make sure that your Bingo Board has all required elements and is formatted correctly.
Save, print, and turn in.


Do this second:

Define "spreadsheet."

  • Copy and paste the spreadsheet definitions form into a word processing document.
  • Copy and paste from three different online dictionaries three definitions of "spreadsheet" into a word processing document. (Use the following three online dictionaries:
  1. World Book Dictionary
  2. Free Dictionary
  3. Your Dictionary
  • Write a fourth one sentence definition of spreadsheet using parts from the three dictionary definitions. Your definition should be specific and accurate.
  • Use Citation Maker to make a works cited for the three Web dictionaries that you used. Use the Works Cited Worksheet to help you make your citatations. Go to file New tab and have three browser windows open: 1) This spreadsheet assignment page, the Works Cited Worksheet, and Citation Maker.

Do this third:
My Ten Friends List | Example 1 Example 2 | Grade Guide

Make a ten name spreadsheet list of your friends. Format the spreadsheet so that it has eye appeal and sort the names so that they are in alphabetical order.

  1. Open an AppleWorks Spreadsheet document.
  2. Go to the Window drop down menu and choose Page View.
  3. Go to the Window drop down menu and choose Show Tools.
  4. Go the the Format drop down menu and choose Document. In the Document window type Columns Across: 2 and Rows Down: 12.
  5. Click and drag so that all 24 cells are highlighted. Go to the Format menu and go down to Column Width. Change the 72 to 200. Then go back to the Format menu and change the Row Height from 14 to 50.
  6. Save your document to your folder on the Data server. Name it Ten Friends Spreadsheet.
  7. In column 1A type My. In column 1B type Friends. In column 2A type your first name. In column 2B type your last name.
  8. Click and drag to highlight the first four cells (1A through 2B where you have typed text.) Go the the Format menu and go down to size and choose 36 pt..
  9. Highlight the top two left cells (1A and 2A) and go the the Format menu/Alignment and choose Right.
  10. Go to the Options menu and choose Display. Remove the check marks from Column Headings and Row Headings. Click OK.
  11. Type the first name of your first friend in cell A3. Type your first friend's last name in cell B3. Continue typing until you have all ten friends.
  12. Format the names so that first names are aligned right and are 24 pt. in size, then format the last names so that they are aligned left and 24 pt. in size.
  13. Make the list of names all the same font but a different font from the title and your name.
  14. Sort the names so that they are in alphabetical order by last name: Click and drag so that all then first and last names of your friends are highlighted. Go to the Calculate drop down menu and choose Sort. In the Sort window change A3 to B3 below Order Keys. Your friends should now be in alphabetical order by last name.
  15. Prettify the text color (Format/text color) and cell color (color palette button in tool bar.)

Check the Grade Guide to make sure that your Friends List has all required elements and is formatted correctly.
Save, print and turn in.

Grade Guide

Do this fourth:
My Music Mix Spreadsheet | Example 1 | Example 2 | Example 3 | Grade Guide

Electric Guitar Computer Music

Amazon (for CD picture) or Altavista Images

Make a CD case insert of twelve favorite songs:

  • Your mix must have 12 songs by 12 different artists/groups.
  • You will use Amazon, Altavista Images, and Napster to research the songs that you will include
  • Use good judgment. (Song lyrics will not be part of the project, but song titles can be objectionable.)
  1. Open three other browser windows or tabs besides this one: Amazon | Altavista Images | Napster
  2. Open an AppleWorks Drawing document.
  3. Go to the Window drop down menu and Show Tools.
  4. Click on the Spreadsheet Tool.
  5. Make a four cell spreadsheet (two cells wide and two cells high).
  6. Save your document to your folder on the DATA server. Name it My Music Mix.
  7. Click inside a cell, then click and drag the pointer to highlight the four cells. Make each of the cells a row height 171 pt. and column width 170 pt.
  8. Make another spreadsheet two cells wide and fourteen cells deep. Make cells three through fourteen row height 23 pt. and column width 171 pt.. Make cells one and two row height 33 pt. and column width 171 pt.
  9. For the top (four cell) spreadsheet go to Options/Display to remove check marks from cell grid, column headings, and row headings. For the bottom (28 cell) spreadsheet go to Options/Display to remove check marks from column headings and row headings. (In the bottom spreadsheet do not remove the check mark from cell grid.)
  10. Each of the two spreadsheets should measure 4.75 inches by 4.75 inches. (To check the size: Use the pointer tool to select spreadsheet/Go to Options drop down menu/Choose Object Size.)
  11. Align the second spreadsheet under the first.
  12. Type song names in the left column and artists in the right column. Number the song names one through twelve. (Be sure to put a space between the period and the song name.) If the song title is too long to fit in the cell, either use the first part of the title or make the font size a point or two smaller.
  13. Find a CD cover graphic from Amazon or a picture of the music group at Altavista images. The CD picture should be one that has one of the twelve songs. If you use a band picture, it should be one of the twelve groups from your mix.
  14. Copy/Paste the cover graphic into the top spreadsheet. (The graphic should be centered within the spreadsheet. Do not stretch out the picture to fill the space in the upper spreadsheet. If you do, it will appear distorted.)
  15. Give the mix a name. The mix should be named after one of the 12 songs. The mix name goes in the first row of the bottom spreadsheet.
  16. Color the background of the top spreadsheet (with the picture) by clicking on the spreadsheet and choosing a color from the color palette in the tools menu.
  17. Give your mix a name. Be more creative than "John's Songs." (Johnny's Jukebox is better.) Your mix name goes in the second row of the bottom spreadsheet.
  18. The mix name and your mix name also need to be included in the top spreadsheet on the CD cover graphic. The font and color of the text should match the font and color on the CD cover.
  19. Highlight the cells in the bottom spreadsheet to tweak the font and color. You can also change the background color of the cells.

Check the Grade Guide to make sure that your Music Mix has all required elements and is formatted correctly.
Save, print and turn in.