Part 1 Rival Causes (6 points)
1 & 2. Read "Dropouts: A real problem for U.S." Ruben says that we must do something about the dropout rate before it is too late. He provides reasoning to back that up. He doesn't present an explanation of WHY dropout rates are high. Search the Internet to find 2 different causes for the high dropout rate. For EACH, provide the following:
a. The title of the page
b. The URL
c. A brief description of the cause
Save your answers in a Word document called Nov14Dropout and upload to Tasks, Tests and Surveys.
Part 2 Worksheets (4 points)
This exercise covers the material in Excel Projects 1 and some of 3 in Dozer's Quintessential Guide to Computer Literacy. We will create a worksheet about technology in schools from information at http://www.edweek.org/media/ew/tc/2008/30state_tech_ranking.h27.pdf
1. Start Excel. Notice the name box, formula bar, worksheet area with cells,
worksheet frame and worksheet tabs.
2. Make sure the active cell is A1.
3. Type the worksheet title: Technology in the Western State Schools
4. Press Enter or click the Enter button.
5. Edit the title to say: Western State School Technology
6. Make A3 the active cell.
7. Enter the following state names (one per row): Arizona, California, Nevada,
Oregon, Washington
8. Make B2 the active cell.
9. Enter the following column labels (one per column). Press Alt+Enter in the
middle of the text to wrap it to two lines: Overall Score, Access to Technology,
Use of Technology, Capacity to Use Technology
10. Point to the dividing line between the column letters and drag to make the
columns wider so the labels display nicely.
11. Enter the numbers into the grid for each state and category.
12. Insert a new row in alphabetical order and add the data for Utah
13. Insert a new column to the left of the Overall Score.
14. Give the new column the label: Rank
15. Enter the ranking data for the states.
16. Right-align the column labels over the numbers.
17. Starting in cell A10, copy and paste the reference information from the bottom of
the data page.
18. Italicize the reference information.
19. Insert a row below the title and put your name in it as the creator of the
worksheet.
20. Double-click the worksheet tab and rename it CSIT58.
21. Save the worksheet as Nov14. We will work with this again in the next class
meeting.
Upload to Tasks, Tests and Surveys.