Bell Work: (5min)
Intermediate Excel Agenda
Descriptor: Learn to use some of the more advanced features and functions in Microsoft Excel 2013/2016 in this hands-on workshop. TN State standards include data interpretation by students in a variety of ways. This training is designed for those participants who have previously attended Basic Excel and are ready to learn how to create tables and build a basic database, use conditional formatting to filter grades by color, protect worksheets and workbooks, go a step further in chart creation and insert them into PowerPoint Presentations. Participants will learn how to use concatenate, text to columns, and find and replace, which are valuable tools for data analysis. Lastly participants will learn how to create an Excel Survey and collect data for analysis charts in PowerPoint.
Team Rubric: Use of Data, Planning
ISTE / Digital Citizenship:
ISTE Standard for Students: collect data or identify relevant data sets, use digital tools to analyze them, and represent data in various ways to facilitate problem-solving and decision-making
ISTE Standards for Teachers: model and facilitate effective use of current and emerging digital tools to locate, analyze, evaluate, and use information resources to support research and learning
Digital Citizenship Component: Privacy
Go over the search feature in Excel with participants. Example: When the tech coach says go to Find and replace do not waste time trying to figure out where that is. Go to the search box and type in find and replace.
*Search box is underlined in red.
Task Two: Find and Replace
Task Four: Text to Columns
at the bottom on the workbook
name, ID, CFA 1, CFA 2, CFA 3
Select data for the chart.
Select Insert > Recommended Charts.
Select a chart on the Recommended Charts tab, to preview the chart.
Note: You can select the data you want in the chart and press ALT + F1 to create a chart immediately, but it might not be the best chart for the data. If you don’t see a chart you like, select the All Charts tab to see all chart types.
Select a chart.
Select a chart.
Select Design > Add Chart Element.
Select Trendline and then select the type of trendline you want, such as Linear, Exponential, Linear Forecast, or Moving Average.