8th+grade+shopping

__PA standards__ –
 * NETS.1.6-8: Students demonstrate creative thinking, construct knowledge, and develop innovative products and processes using technology.
 * NETS.2.6-8: Students use digital media and environments to communicate and work collaboratively, including at a distance, to support individual learning and contribute to the learning of others.
 * NETS.3.6-8: Students apply digital tools to gather, evaluate, and use information.
 * NETS.6.6-8: Students demonstrate a sound understanding of technology concepts, systems and operations.

__Objectives__ -
 * Workbook Skills
 * Working with toolbars
 * Working with the menus
 * Keyboard moves
 * Entering info in a spreadsheet
 * Renaming an existing workbook || Borders and Styles
 * Using the borders button
 * Using the fill color button
 * Creating a style by example || Graphing
 * creating a pie chart
 * including a title
 * making the pieces of the pie % ||
 * Objects, Pictures, and Diagrams
 * Inserting a picture
 * Formatting a picture or a graphic || Formulas & Functions
 * Entering formulas
 * AutoSum and AutoSum list
 * Basic functions
 * Inserting functions in formulas
 * Editing functions
 * Multiplication formulas || Formatting Skills
 * Number formatting
 * Formatting using the toolbar
 * Formatting using the formatting palette
 * Cell alignment and spacing
 * Shrinking or wrapping text in a cell
 * Selecting columns and rows
 * Changing column width and row height
 * Inserting or deleting a column or row
 * Inserting or deleting selected cells ||

__Evidence of best practice__ – students will be able to refer to the video and helpful tips on my wiki at anytime they get stuck, peer instruction

__Activity__ - After researching the cost of some Holiday gifts make a chart and a pie chart showing percentages using excel...

toc

--GO>>>
for Toys For Tots for a 5-8 year old child

Job 1-
 * You have to buy 5 different toys The cost of each toy is $20-$30
 * OR
 * spend between $100-$150 for ATLEAST 5 toys

B1 - **Cost of toy** C1 - **% of Tax** D1 - **Tax in $** E1 - **Total cost for toy** **.** || . || highlight column B D and E (not all together) go to the menu bar and choose "Format" - numbers - Choose CURRENCY . || . || click in D2 - =B2*C2 click in D3 - =B3*C3 etc - tax is calculated! . || click in E2 - =B2+D2 Click in E3 - = B3+D3 Etc . || Use the sum tool to calculate the total of all the toys in cell E8 . ||
 * || Go in these cells and enter the title
 * || Enter the toys in column A, the cost in Column B
 * || FORMAT YOUR COLUMNS -
 * || PA state tax is 6%, but Philadelphia tax is 7%. Enter the tax for each item in column C. USE THE %
 * || In Column D you are going to calculate the tax using a formula
 * || In column E you are going to calculate the total cost of each toy, including tax
 * || In cell D8 write "Total for ALL toys"
 * || Add a border around your facts - highlight ONLY the section with facts.

. || . || Choose a pie graph. Your graph will include all the facts - you really only want //toy name// and //total cost of toy// - here is how to fix that: Click on the pie graph move your curser over the blue in the chart and drag it over so only the total column is on the blue outline . || . || . || . ||
 * || GRAPH TIME :)
 * || Highlight the chart, //not// including "total for ALL toys".
 * || Label your graph with a **title** and **percentage** of your money.
 * || Include **two pictures** - remember the pictures must go to your desktop FIRST, then into Excel
 * || Check it, Turn it in

--Scoring guide ** – **

 * There are 13 things I am looking for from the directions above. See pictures below **

border around chart only - 10 formulas used for tax - 10 formula used for total - 10 sum total used for complete total - 10 dollar signs used - 5 pie graph made -10 percent used - 10 key for graph - 10 title on graph - 10 picture included - 10

--Helpful videos
doing steps 1-5 doing steps 6-9 part 3 - adding graph