|
|
|
|
Ms. Swanigan's Computer Skills Assignment Page Computer Assignments
Other assignments: 1. Save a word document to the DropOff Box (How to save to the DropOff Box) 2. Complete the MSWord Pre-test assignment 3. Practice using formatting tools in MSWord 4. Create your first web page using FrontPage 5. Create an online Welcome page 6. Use Excel to create graphs 7. Using Excel charts with Microsoft Word 8. Basic PowerPoint Assignment 9. Day I was Born: What was happening in the world on the day you were born. 10. Design, create, and publish your own home page and link it to your welcome page online 11. Iraq Create a PowerPoint presentation about the current situation in Iraq. 12. Using search engines to complete a Scavenger Hunt 13. Re-design ChinookMiddleSchool.com home page 14. Schoolkit: Crosscurricular: Excel: Review IT 15. PowerPoint/Excel/Internet images (6pptcars)
When moving any computer work to the DropBox, the first character in the name of your saved item must be your period number. The period number is followed by the name of the assignment and your last name. There are no capital letters or spaces in the document name. Examples: If John Fisher has Science fifth period and is turning in an assignment called “ecosystems” then the name that he saves this work under would be: 5ecosystemsfisher If Alex Moore from seventh period is saving an assignment called “speed,” then it goes in the Dropbox as: 7speedmoore If Mary Lou Retton has class during second period and puts her assignment called “chemical” into the DropBox, it goes in as: 2chemicalretton Before dragging your document to the DropBox, you must make a copy of it in your My Documents folder:
1. DropBox assignment. Create a MicrosoftWord document and save a copy of it in your My Documents folder and place the original document in the DropBox for Ms. Swanigan to grade. Follow these steps: 1. Open MSWord from the Programs menu in the Start menu 2. Type your first and last name in the upper right corner of the document 3. On the next line, type the sentence: This is the DropBox assignment. 4. Save your document in the My Documents folder as 6dropboxlastname (Replace the phrase lastname with your last name. Remember, no capital letters and no spaces) 5. Close MSWord 6. Open the My Documents folder on your desktop 7. Click once on the icon for your document 8. Copy and Paste the icon in the My Document folder (a copy will appear next to the original) 9. Drag the original document icon onto the DropBox on the Desktop and let go. The icon should disappear. The copy should remain in the My Documents folder. 10. Repeat steps 1-9, but name the document 6dropboxlastname2 To receive credit for this assignment, you must turn in both versions of the document.
2. Microsoft Word Pre-Test assignment: Duplicate the document given to you by your teacher as exactly as possible using MSWord word-processing program. Experiment with the different menus and menu options in MSWord.
4. Directions for creating simple web pages using Microsoft FrontPage This creates a simple, 4-page web, each page containing the same menu bar linking the pages to each other and each page to a site on the internet. Students practice formatting, placing an image and creating links. These directions work best for Office 2000, but may be used for earlier versions by using the toolbar buttons in some places instead of the right mouse button. 1. Log on to students03 online and create a new folder called firstpage. Begin a new page. 2. Drag down format menu to Background… 3. Under color, change to silver 4. Drag down Format menu to Font 5. Change font to any font that you like, size 4(14pt), click OK 6. Type the word Home and center it at the top of the page using the center align button 7. Hit Enter twice 8. Click left align button in toolbar to place cursor at left margin 9. Drag down Table menu to Insert…Table 10. Create a table of 4 rows, 1 column, border size 2, width 20 percent, left alignment 11. Type these four words in the table (one word in each cell): Home, Picture, Text, Internet 12. Save this page into your firstpage folder as homepage.htm 13. Drag down file menu to New…Page 14. Repeat steps 2,3,4,5 15. Type the word Picture and center it at the top of the page 16. Save this page into your folder as picture.htm 17. Repeat steps 2,3,4,5 18. Type the word Text and center it at the top of the page. Hit Enter twice 19. Type two sentences about any topic of your choice. 20. Save this page into your folder as text.htm 21. Open the page titled homepage 22. Select (highlight) the word Home in the table, not at the top of the page 23. Right click the word Home 24. In the menu that appears, click Hyperlink (or if it is not there, click the hyperlink button in the toolbar at the top) 25. In the list of files that appears, click once on the file for homepage (the file name will appear in the URL address window near the bottom) or type in just the name of the page: homepage.htm 26. Click OK 27. Repeat steps 22,23,24, 25,26 for Picture and then for Text instead of Home 28. After going through steps 22-26 three times, select the word Internet in the table 29. Right click Internet and click Hyperlink in the menu that appears 30. In the URL window, type http://www.chinookmiddleschool.com/teachers/benton/home.htm Click OK 31. Save the home page 32. Select (highlight) the links table you have just created 33. Right click the table and click Copy in the menu that appears 34. Open the page titled Picture, right click the page and click Paste 35. Open the page titled Text, right click the page and click Paste. Now you have placed the same links table on each page. 36. Save all pages and then open homepage.htm 37. Click the Preview tab at the bottom of the screen 38. Click on the hyperlinks to test them 39. Click the Normal tab at the bottom of the screen 40. Open the picture page 41. Use the Insert menu to place a picture from clipart on this page 43. Save all pages To see the pages on the internet, type in this address: http://www.chinookmiddleschool.com/students03/yourfirstname/firstpage/homepage.htm The teacher will grade what he finds at this address. If he finds zero, then that is your grade for the assignment.
5. Welcome page assignment: Create a single web page which will be linked to the Computer Class web page. This page will serve as an entry point to your online work. It is not your home page, which you will create later. From this welcome page, you, or anyone on the internet, can click and view work that you will later link to this page. For now, you only need to use FrontPage to create a normal web page that fits the following minimal requirements: * A colorful or interesting background * A picture of you * An explanation of what this page is and why you have made it * A table or menu bar that will later have links to other pages including a personal web page that you will make later. * Your first name only somewhere on the page * Pictures, graphics, clipart of your choice to add interest ***This page should be compact; a reader should see the entire page without scrolling. Put only the minimal requirements on this page. Personal information about yourself and links to favorite sites will be placed on a separate personal home page.***
Assignment: Using Excel charts with Microsoft Word In this assignment you will do the following: 1. Insert a previously made chart into a new Word document 2. Create a new chart and insert it into a letter created in Word following step by step directions. 3. Create another chart to insert into the letter, given only the data for the chart but no step by step directions.
Directions: Part 1 - 1. Open a new Word document 2. Type: Here is an Excel chart: 3. Drag down the Insert menu to Object… click on Create from file 4. Click on Browse… then find a chart that you already created in assignment #6 and double click on it 5. Click on OK 6. Resize the chart to fit by dragging on the black squares on the corners 7. Save a copy of the document as 6excel3lastname in your folder and drag the original to the dropoffbox
Part 2: 1. Open Excel 2. In cell A1 type: Grade; in B1 type: Pizza; in C1: Hamburger; in D1: Chinese 3. If necessary, resize columns by dragging the vertical black line on the grey header between the column letters from side to side 4. In cells A2 to A4 type 6th, 7th, 8th respectively 5. In cells B2 to B4 type 345, 311, 156 6. In cells C2 to C4 type 255, 194, 383 7. In cells D2 to D4 type 170, 208, 240 8. Select all cells that you typed in 9. Click on Chart Wizard 10. Click on Column then click next 11. Click on Data range, then click on Series in: Rows then on Series in: Columns and decide which setting is better for this chart. Then click Next 12. Click on Title 13. Chart title:Favorite Foods at Chinook MS; Category:Grade; Value:No. of Students 14. Click Next; click button for As New Sheet 15. Type in Favorites and save this chart as 6favoriteslastname in the your folder Part 3: 1. Open a Word Document and type a letter to Dr Bredin telling him that you have completed your survey on likes and dislikes of Chinook students, and that you will show your results using charts. 2. Save the letter as 6chartletlastname in the your Folder 3. Insert the Favorites chart into this letter using the instructions #3-6 above for Part one; then Save, then complete part 4, below.. Do not turn this part in yet, just save it. Part 4: Make another chart in Excel showing the three favorite music groups or musicians of Chinook students sorted by grade and insert this chart into your 6finalchartletlastname document. You can choose the groups and singers and make up numbers that total approximately 820 (the number of students at Chinook). Follow the steps in Part two above, but insert your own titles and numbers. Save your work as 6finalchartletlastname in your folder and place the original in the dropoffbox.
# 8. Powerpoint Assignment: 6pptbasic
These directions will show you how to make a simple PowerPoint presentation. Every student's presentation should be identical for this assignment. Later you will create individual PowerPoints that will be different from everyone else's.
1. Open PowerPoint (Start menu – Programs, or Desktop icon) 2. Click Design Template under Create a new presentation using: Then click OK 3. Under New Presentation click on Design Template tab and double click Fireworks. 4. Click on Title Slide (upper left on screen: New Slide: choose an Autolayout) 5. Click OK 6. In Title Box: Type the words PowerPoint Presentation 7. Center the words 8. Bold the words 9. Underline the words 10. Make the words size 48, color red 11. Re-size the title box so the words are on one line 12. In the subtitle box, type your first and last name 13. Save the presentation as pptbasiclastname 14. Go to Insert, New Slide 15. Under Text and Content Layouts choose Title, Text and Contents 16. Type Jet Landing in title box (where it says Click to add title) 17. Text: size 48; color, blue; underlined 18. In text box type: Here comes flight 570! 19. Double click on bottom right to add any colorful jet or plane from Clip Art 20. Type the word jet in the Search for Clips box and hit Enter 21. Click on any jet or plane and insert it into the presentation 22. Go to Slide Show, Custom Animation 23. Click on Add Effects, then Entrance, then Fly In 24. Under Modify effect change Start to automatically after one second, Direction from the left and Speed medium 25. Save your presentation 26. Go to first slide (use scroll bar on the right side of screen or page list on left) 27. Click on the Slide Show button at the bottom left of the screen to view your presentation (or Slide Show, View Show). Click to change screens and animate. 28. Save as pptbasiclastname and put original in Dropoff Box after saving a copy in My Documents
7. Microsoft Word Formatting Assignment. Save as 6formatlastname This assignment is meant to give you practice using various tools on the different toolbars available in Microsoft Word. Please take your time to explore the different options, so you will be able to use them in the future. Try to figure out the directions by yourself. Explore the toolbars. 1. Under the View menu, turn on the Standard, Formatting, Drawing, and Tables and Borders Toolbars 2. Write the following sentence: The quick grey fox jumped over the lazy brown dogs. 3. Copy and paste the sentence five times on different lines. 4. Select all six copies of the sentence then click on the numbered list button on the formatting toolbar to number the sentences 1-6 5. After each sentence write the following words (one per sentence): plain, businesslike, fancy, weird, script (handwritten), bold 6. Select one sentence at a time and change each to a different font that represents the word after the sentence, then type the name of the font at the end. Search for new fonts that you haven’t used before.
Example: The quick grey fox jumped over the lazy brown dogs. simple-Cezanne
7. Type any complete sentence about current events. Leave spaces above and below this sentence. 8. Select the sentence about the fox and dogs that you already typed that has your favorite font. 9. After that sentence is selected, click on the Format Painter button in the Standard toolbar. (It looks like a blue-handled paintbrush with yellow paint on it.) If the format painter is not showing, click on the two >> marks on the toolbar to expand the toolbar. 10. Drag the format painter paintbrush over the sentence you wrote about current events and let go. The font of the sentence about you should change to your favorite font. 11. Leave a few blank spaces, then type a sentence about computer class. 12. By using the Format Painter tool and your “bold” sentence about the fox, make the sentence about computer class bold. 13. Under the Format menu, use Borders and Shading to put a red, double-line border around the computer sentence. Use the paragraph option to border only this sentence. 14. Use the Insert Table button to insert a table with two rows and three columns in your document:
15. Type your first, middle and last names in the top three boxes 16. Type three of your favorite things in the other three boxes. 17. Center each word in each box. Change the background color of each cell to a different color. 18. If necessary, change the color of any fonts so that all of the words are readable. 18. Save this document as 6formatlastname in My Documents, put the original in the Dropoff Box, save a copy for yourself.
10.Personal Web Site Assignment Using Microsoft FrontPage, create a multi-page, personal web site. This site will include the following features (minimum):
1. A home page with interesting graphics or background features and a menu bar or site map connected to all pages of the site.
2. Each page of your web will have a clear, consistent link back to the home page
3. The text will be readable and easy to look at (no orange text on yellow background for example) and the pictures must be appropriate, proportional, and balanced on the page. Use invisible tables to space pictures.
4. One page (“favorites”) will have at least five links to favorite sites of yours with a brief, understandable description of each site next to the link.
5. One of the pages (“day”) will include biographical information about you including information from your Day I was Born assignment.
6. One of the pages (“photo”) will include a photo gallery of some of your favorite pictures, using thumbnails linked to larger versions of the pictures. Click here to learn how to make thumbnails.
7. All writing must be respectful and appropriate to be read by anyone. Spelling and grammar must be correct. Graphics must be used to inform and create interest, not to be cute or distracting.
8. Navigation must be logical and intuitive. Don't make the user guess what buttons are or how to get to the next page or back home.
9. Your web (all of the above pages) will be kept in a folder labeled home. You keep the most recent version of your web in your My Webs folder in My Documents.
10. Create a folder called home in your online folder in the students03 folder of chinookmiddleschool.com
11. Place the pages and images of this assignment into that folder called home.
12. Create a link on your Welcome page (that is already online) to your new home page.
10.The web must be online by October 17 for grading. You may correct and update the web before final grading on October 24.
11. A student's guide to Iraq: The present situation concerning relations between the United States and Iraq is viewed differently by people around the world. Even within the United States there is a wide range of opinions about whether we should have gone to war and what our goals were, or should be. Your assignment is to create a PowerPoint presentation aimed at students, that objectively explains the facts and the different points of view about the U.S./Iraq situation, and to separately present your personal opinion and prediction of what you think should have happened, what we should do now, and what you think will happen. Minimal requirements: 1. A title page with appropriate graphic, that also tells who you are and what the rest of the assignment will try to explain. 2. Clear headings that identify the different sections of your site 3. Links to the following sections of your site (can be hyperlinks or bookmarks): - Bush administration position (What the president and his people say about it) - American protests and arguments against Bush's policy - World opinion - for and against including opinions in the Arab world - Your personal opinion and prediction 4. A paragraph about each of the above topics. At least half of each paragraph must be in your own words. If you quote or paraphrase from another source, you need to include a footnote citation showing where you got the quote. 5. A separate list of links to additional information including the following sites which you can use to start your research: www.loc.gov/rr/international/amed/iraq/iraq.html 6. At least one appropriate graphic on each slide 7. Save as 6iraqlastname into the DropOff Box and save a copy in your folder
12. Internet Scavenger Hunt & Search Engine Critique (two assignments)
The assignments (2): 1. Use a variety of search engines from the list that follows to find the answers to the questions listed after the search engines. After finding the answers, create a table in Word or Excel to list the following (each in a separate column): Questions, Answers, URL (where you found the answer) and search engine used. (Save as 6scavhuntlastname) 2. After using at least 5 different search engines, create a Word document and evaluate each search engine by answering the critique questions at the bottom of this assignment. (Save as 6critiquelastname)
The search engines: AltaVista; Ask Jeeves; Dogpile; Excite; FinderSeeker; HotBot; Go.com; LookSmart; Lycos; Mamma; Metacrawler; Starting Page; WebCrawler; Yahoo; GoTo.
The questions you need to find the answers to: (put these in the first column of the table you turn in)
Back to top of this assignment
10. The Critique Assignment: Questions to answer about each search engine. (At least five different search engines). Write a paragraph with complete sentences about each one. (Save as 6critiquelastname) 1. Did the search engine give you a variety of useful information? Give examples. 2. Was the search engine easy to use? How so? 3. Which search engine was your favorite? Why?
Sample Table: Internet Scavenger Hunt Answers
Back to top of this assignment
13. Re-design ChinookMiddleSchool.com home page
We are going to re-design the front page of ChinookMiddleSchool.com. When re-designing the new Home page (chinookportal.htm) it must include all of the present links, but you may add additional links. Do not use large pictures that will slow down your page. Use pictures of activities and people around our school (including yourself) to place on pages. The text will be readable and easy to look at (no orange text on yellow background for example) and the pictures must be appropriate, proportional, and balanced on the page. Use invisible tables to space pictures. Don't waste space. Keep fonts and pictures small. Don't leave unnecessary space between elements.
15. PowerPoint/Excel/Internet images (6pptcars)After reading the following paragraph, create a PowerPoint presentation of at least 6 slides which will present and illustrate the information given in the paragraph. The history of the automobile in the United States is nearly 100 years long. The first cars were square boxes on wheels. Today’s vehicles are sleek, fast and loaded with fancy options. Car racing is one of the most popular sports in the country. The percentage of cars in the U.S. that were manufactured overseas continues to grow. Here are the numbers: 1960 - 7.6%; 1970 – 13%; 1980 – 22%; 1990 – 15%; 2000 – 32%. The possibility of continuing to use gasoline-powered cars is limited. Soon we may all be driving cars powered by hydrogen, solar power or electricity. Who knows what the future may bring? The PowerPoint presentation illustrating this paragraph must include the following minimum elements: 1. A title slide including your name 2. Each slide contains relevant text that is in a large enough font to be read when projected onto a screen in the lab or classroom. (Limit the amount of text on each page.) The text should reflect the ideas in the assignment paragraph above, but it should be in your words, not copied from above. 3. A background that does not conflict with the text (compatible colors). 4. An automatic transition after 5 seconds from the title slide to the second slide 5. A picture from the internet illustrating one of the points in the paragraph 6. A clipart illustrating one of the points in the paragraph 7. A properly labeled Excel chart showing the data presented in the paragraph 8. A button on the second slide that leads to the third slide (no automatic transition) 9. One, and only one, of the pictures or clipart should appear with a sound 10. Use action settings to turn the internet picture into a button linked to the URL (internet address) where you got the picture 11. On at least two slides, the elements of the slide (pictures, title, text,etc.) should appear automatically in a logical sequence.
10. Personal Web Site Assignment Using Microsoft FrontPage, create a multi-page, personal web site. This site will include the following features (minimum):
1. A home page with interesting graphics or background features and a menu bar or site map connected to all pages of the site. This entire first page must appear on the screen without scrolling.
2. Each page of your web will have a clear, consistent link back to the home page
3. The text will be readable and easy to look at (no orange text on yellow background for example) and the pictures must be appropriate, proportional, and balanced on the page.
4. One page (“favorites”) will have at least five links to favorite sites of yours with a brief, understandable description of each site next to the link.
5. One of the pages (“day”) will include biographical information about you including information from your Day I was Born assignment.
6. One of the pages (“photo”) will include a photo gallery of some of your favorite pictures, using thumbnails linked to larger versions of the pictures. Click here to learn how to make thumbnails.
7. All writing must be respectful and appropriate to be read by anyone. Spelling and grammar must be correct. Graphics must be used to inform and create interest, not to be cute or distracting.
8. Navigation must be logical and intuitive. Don't make the user guess what buttons are or how to get to the next page or back home.
9. Your web (all of the above pages) will be kept in a folder labeled home. You keep the most recent version of your web in your My Webs folder in My Documents.
10. Create a folder called home in your online folder in the students folder of chinookmiddleschool.com
11. Place the pages and images of this assignment into that folder called home.
12. Create a link on your Welcome page (that is already online) to your new home page.
10.The web must be online by April 10 for grading. You may correct and update the web before final grading on April 25.
11. Fill in one side of the “Web Site Design: Personal Home page” scoring rubric and turn it in before publishing the web for final grading.
Creating a thumbnail page (photo page).
Return to directions for making home page
14. Assignment: Follow the directions under Schoolkit: Crosscurricular: Excel: Review IT on the lab computers. Save your work into the My Documents folder and also into the DropOff box as 6reviewITlastname.
16. PowerPoint "Movie" Assignment: Create a simple cartoon movie using PowerPoint. Create a simple scene, like a ball falling off a table and bouncing, by making a drawing and then using insert duplicate slide to make the subsequent action. Move your picture incrementally across the screen on each slide.
6. Excel Spreadsheet Assignment Excel is a software program that allows you to sort and manipulate data in tables and charts. Your assignment today is to follow the directions to create charts to illustrate the results of two science experiments. Save the assignments as 6excel1lastname and 6excel2lastname in your My Documents folder. Part One: 1. Open Excel 2. In cell A1 type “No. of batteries” 3. Resize the column A to fit by dragging the line on the right side of the header to the right. 4. In cells A2 to A6, type 2,4,6,8,10 respectively 5. In cell B1 type “Mass (g)” 6. In cells B2 to B6 type 22, 44, 84, 154, 275 respectively 7. Select (drag across) cells B2-6 8. Click on the Chart Wizard (blue, yellow, and red button on the standard toolbar) 9. Choose Column then click next 10. Click on Series tab 11. Select Series 1 then type in the box for Name: Mass lifted 12. Click on the small red arrow icon at the right end of the Category X axis labels box 13. Highlight the numbers in column A and press Enter 14. Click Next 15. Click Titles tab 16. In Chart title: Mass lifted by electromagnets 17. In Category (X) axis: Number of batteries 18. In Value: Grams 19. Click next 20. Click on button for As New Sheet 21. Type in: 6excel1lastname 22. Save chart as 6excel1lastname in your folder. Part Two: 1. Open a new spreadsheet (File, New) 2. Follow the directions above in general, but create a pie chart instead of a column chart to show a second set of data in which a package of seeds containing 143 seeds is planted and only 111 seeds germinate (sprout). Of the seeds that sprouted, 25 die after one week. Show the number of seeds germinated, the number of seeds not germinated and the number of seeds that sprouted but died in a week on one pie graph. 2. Save chart as 6excel2lastname in your folder.
Assignment: Using Excel charts with Microsoft Word In this assignment you will do the following: 1. Insert a previously made chart into a new Word document 2. Create a new chart and insert it into a letter created in Word following step by step directions. 3. Create another chart to insert into the letter, given only the data for the chart but no step by step directions.
Directions: Part 1 - 1. Open a new Word document 2. Type: Here is an Excel chart: 3. Drag down the Insert menu to Object… click on Create from file 4. Click on Browse… then find a chart that you already created and double click on it 5. Click on OK 6. Resize the chart to fit by dragging on the black squares on the corners 7. Save a copy of the document as 6excel3lastname in your folder. Part 2: 1. Open Excel 2. In cell A1 type: Grade; in B1 type: Pizza; in C1: Hamburger; in D1: Chinese 3. If necessary, resize columns by dragging the vertical black line on the grey header between the column letters from side to side 4. In cells A2 to A4 type 6th, 7th, 8th respectively 5. In cells B2 to B4 type 345, 311, 156 6. In cells C2 to C4 type 255, 194, 383 7. In cells D2 to D4 type 170, 208, 240 8. Select all cells that you typed in 9. Click on Chart Wizard 10. Click on Column then click next 11. Click on Data range, then click on Series in: Rows then on Series in: Columns and decide which setting is better for this chart. Then click Next 12. Click on Title 13. Chart title:Favorite Foods at Chinook MS; Category:Grade; Value:No. of Students 14. Click Next; click button for As New Sheet 15. Type in Favorites and save chart as favoriteslastname in the your folder
Part 3: 1. Open a Word Document and type a letter to Dr. Bredin telling him that you have completed your survey on likes and dislikes of Chinook students, and that you will show your results using charts. 2. Save the letter as 6chartletlastname in the your Folder 3. Insert the Favorites chart into this letter using the instructions #3-6 above for Part one; then Save.
Part 4: Make another chart in Excel showing the three favorite music groups or singers/artists of Chinook students sorted by grade and insert this chart into your 2finalchartletlastname document. Use your imagination: You can choose the groups and singers and make up numbers that total approximately 800 (the number of students at Chinook). Follow the steps in Part two above, but insert your own titles and numbers. Save your work as 6finalchartletlastname in your folder and turn it in to the Dropbox or show it to your teacher if no dropbox appears on your desktop.
Computer assignments Due Dates
|