CSIT58 Friday Nov. 6 Participation Credit: Evidence and Excel

Part 1 Evidence

Answer the following questions by inputting your answers in the answer box in Etudes.

Click the link to open the editorial in PDF format "China's Cybertooth Tigers."

1. Give an example from the article of any of the types of evidence described in chapters 8 and 9 of Asking the Right Questions (intuition, personal experience, testimonial, appeal to authority, personal observation, research study, case examples, analogies). Identify the text from the article and what type of evidence it is.

2. Repeat #1 with a DIFFERENT type of evidence.

Do an Internet search to find another article about cyberwarfare by the Chinese or Russians.

3. What is the title and URL?

4. Give an example from the article of any of the types of evidence described in chapters 8 and 9 of Asking the Right Questions. Identify the text from the article and what type of evidence it is.

Part 2 Worksheet

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 today's date. We will work with this again in the next class meeting.

Upload to Tasks, Tests and Surveys.