Excel

http://www.bepublishing.com/Textbooks/It_Series/Excel_It.htm All resources are a part of Excel It curriculum.


 * Notes: || =Downloadable Files:= || Skills being practiced || Resources for help ||
 * Learning the skills: ||  ||   || http://www.gcflearnfree.org/office2010/excel2010 ||
 * || [[file:Excel formatting knowledge.xlsx]] || * Different types of formating numbers || Download and compete using the right click, "Format Cells" option. ||
 * || [[file:Activities 9-12 Students.xlsx]] || * format cell as a number
 * use AutoFill feature
 * add numbers in a spreadsheet
 * use average, maximum and minimum
 * sort in descending order
 * using formulas || This website, GCFLearnFree.org  is neatly organized has video and step by step instructions.
 * using formulas || This website, GCFLearnFree.org  is neatly organized has video and step by step instructions.

[] ||
 * || [[file:Activities 13 14 21 22.xlsx]] || * formulas using division
 * increase decimal place
 * sum function
 * using clip art in excel
 * <span class="GINGER_SOFTWARE_mark">adding comments ||  ||
 * || [[file:Activities 18 19 20 23 - level of mastery.xlsx]] || All of the above
 * <span class="GINGER_SOFTWARE_mark">format text direction
 * <span class="GINGER_SOFTWARE_mark">use Autofit to change column and row widths
 * <span class="GINGER_SOFTWARE_mark">format cells as currency
 * <span class="GINGER_SOFTWARE_mark">use text <span class="GINGER_SOFTWARE_mark">wrap in a cell || There is a video at the bottom of this page that reviews each skill. No sound. Trying to keep it simple so I can upload it. ;) ||
 * || [[file:assessment used activity 24 for guide.pdf]] || Apply knowledge and skill learned to make your own decisions, solving this Music Store's Problems.
 * Data must be in one spreadsheet to do this:
 * Find a common variable that both sets of data <span class="GINGER_SOFTWARE_mark">share ,
 * Create a spreadsheet that will tell the story from the data
 * Total Debits (Withdrawls) and Credits (Deposits)
 * One column must have a running total
 * || Usin g charts and graphs:
 * 2007 Excel
 * @http://www.gcflearnfree.org/excel2007/16
 * 2010 Excel
 * [] || 1st Know and understand the parts of the basic charts, pie, line, column and bar. || @http://nces.ed.gov/nceskids/help/user_guide/graph/whentouse.asp
 * [] || 1st Know and understand the parts of the basic charts, pie, line, column and bar. || @http://nces.ed.gov/nceskids/help/user_guide/graph/whentouse.asp

Use PowerPoint to demonstrate your knowledge of graphs and charts. || media type="file" key="support for activity 18, 19 20 23.mp4" width="570" height="570"
 * || [[file:Activities 45-48 Students.xlsx]] || ** Practice creating charts using data provided in activities **
 * <span class="GINGER_SOFTWARE_mark">create a pie chart
 * <span class="GINGER_SOFTWARE_mark">create a line chart
 * <span class="GINGER_SOFTWARE_mark">create a column chart
 * <span class="GINGER_SOFTWARE_mark">create a bar chart
 * <span class="GINGER_SOFTWARE_mark">enhance chart by changing colors and font sizes
 * Select cells sing multiple ranges
 * <span class="GINGER_SOFTWARE_mark">use the <span class="GINGER_SOFTWARE_mark">fill effect feature in a chart
 * <span class="GINGER_SOFTWARE_mark">align text in a chart ||  ||
 * EXTRA! || [[file:Activity 50 students.xlsx]] || * <span class="GINGER_SOFTWARE_mark">use the Median and Mode function
 * <span class="GINGER_SOFTWARE_mark">use multiple condition in formulas ||  ||
 * FINAL || [[file:1 - Final Music activity.pdf]] || Using the skills <span class="GINGER_SOFTWARE_mark">your have been practicing to demonstrate your ability to use Excel to communicate information, using charts, graphs and tables
 * Add visual elements to your chart to make it rememberable.
 * https://www.youtube.com/watch?v=8um7jaOw_vA
 * Add visual elements to your chart to make it rememberable.
 * https://www.youtube.com/watch?v=8um7jaOw_vA