Resources+(Teacher)

Technology Resource Share


 * **General Technology** ||  ||
 * [] || - Posters, tutorials and tools for teaching various technology concepts in the classroom. ||
 * [|Google Docs Help] || -How to use google docs ||


 * **Copyright:** ||  ||
 * [] || - Copyright rules and regulations activity site geared toward highschool and college students. There are also teacher resources for download. ||


 * **Searching and Search Engines** ||  ||
 * [] || - Fun game, that helps with seaching techniques and keyword searches........some I couldn't figure out : ) ||

http://itgsths.wikispaces.com ||
 * Wiki for THS - Almost ALL my class stuff is on there - feel free to join:

[]﻿﻿﻿﻿ Entering and using formulas in Excel: [] || [] ||
 * ===**Application Tutorials -**=== ||
 * Software tutorials - [|Woopid] ||
 * Excel basics:
 * This one is on charts:


 * =**Spreadsheet project:**=

Open up a new workbook. Rename the tabs My Data, Class Data, Charts
 * On the first tab, create four columns Estimated, Actual, Difference, and Percentage.
 * The row headings should be: Red, Yellow, Green, Blue, Orange, Brown
 * For fun, you can change the background color of those columns to match. :-)
 * Be sure to add a total to each column.
 * Use a formula to calculate the difference between your Estimated count and your Actual count.
 * Use a formula to calculate the percentage for each color (Actual Number / Total M&Ms)
 * Based on your percentages, use calculations to predict how many M&Ms of each color would be in a 1 pound package. Create a new table below your first one to display these calculations.

Now, open the bag and count the amount of each color and record in the Actual column. Use a formula to calculate the difference between your Estimated count and your Actual count.
 * Before you open your bag**, estimate the amount of each color (and the total amount which will calculate).

(Now you can munch your M&Ms.)

Now, gather data from all the other classmates. This should be put into the second spreadsheet (tab marked Class Data)
 * This spreadsheet is going to built a little differently.
 * You can copy the information on the first page (be sure to label it with YOUR name) at the top of the page, and below it 7 times. Label each set of data with names for each student in the class. The first set of data should be labelled TOTALS
 * Get data from the other students, and fill in their charts.
 * At the top chart, use formulas to sum up the data for each student for each category (ie Red Estimated, Red Actual, Red Difference)
 * Insert 10 rows below your top chart. Create an additional chart with the columns labelled : Red, Yellow, Green, Blue, Orange, Brown
 * Each row heading will be the name of each person in the class. Using a formula, refer to the correct cell for each entry, or copy the value into that space (use the actual values, not the estimated values).

In the third spreadsheet, we are going to make some charts. Turn in your assignment on edu20 when complete. ||
 * Make a pie chart that shows the total percentage of each color from the TOTALS chart on the Class Data tab
 * Make a bar chart that shows the Estimated vs. Actual for each color from your data.
 * Create a stacked bar chart using the newly added table that shows the amount each person had for each color.

[|Who Knows You Best - your Spouse or your credit card?] [|Card Loyalty Programs] || [|Youtube database tutorial] ||
 * Databases Stuff ||
 * Database Mining Links: [|Database Mining Article]
 * Database Mining Worksheet: [[file:Data Mining Worksheet.docx]] ||
 * Database youtube links: Here is part one - it is in 4 parts...
 * Polly's Pink Poodle Parlor db project: [[file:PPPP Design.doc]] ||