Microsoft Excel- Guided Notes is a designed to perform basic and complex mathematical computations and Microsoft Excel spreadsheet application functions. In addition to performing arithmetic operations, Excel allows users to create graphical displays of data, forms It is also routinely used to sort information and assist users in identifying data trends. and pivot tables. () Why do we use visual analysis? Easy to learn readily available Excel is a common program and Easy to disseminate patterns and trends Quickly shows the manipulate data in real time Can clear communication tool Provides a (for other staff, participants, families) Three Stages with Excel (for our purpose) Creating the Excel Template Let the data sheet guide you, keep variables aligned, be concise Left to right, top to bottom Use new tabs within one spreadsheet when necessary Data Entry Have a plan Are you highlighting or checking the top of the form when entered? How often will you enter data? Organize data sheets before entry- maybe by date? Double check your work (including spelling, spacing, format) Data Analysis Mathematical Computations Graphical Representation Five Step Self-Checklist YES fluently YES NO with help Can you accurately enter data to allow for comprehensive analysis in Excel? Can you perform simple math calculations and enter basic formulas in Excel? Can you create a Pivot Table? Can you create a chart or graph from raw data set and/or Pivot Table in Excel? Can you enhance the table/chart/graph in Excel for final presentation? Today’s Date: __________________
Microsoft Excel- Guided Notes Microsoft Excel is a spreadsheet application designed to perform basic and complex mathematical computations and functions. In addition to performing arithmetic operations, Excel allows users to create graphical displays of data, forms and pivot tables. It is also routinely used to sort information and assist users in identifying data trends. () Why do we use visual analysis? Easy to learn Excel is a common program and readily available Easy to disseminate Quickly shows the patterns and trends Can manipulate data in real time Provides a clear communication tool (for other staff, participants, families) Three Stages with Excel (for our purpose) Creating the Excel Template Let the data sheet guide you, keep variables aligned, be concise Left to right, top to bottom Use new tabs within one spreadsheet when necessary Data Entry Have a plan Are you highlighting or checking the top of the form when entered? How often will you enter data? Organize data sheets before entry- maybe by date? Double check your work (including spelling, spacing, format) Data Analysis Mathematical Computations Graphical Representation Five Step Self-Checklist YES fluently YES with help NO Can you accurately enter data to allow for comprehensive analysis in Excel? Can you perform simple math calculations and enter basic formulas in Excel? Can you create a Pivot Table? Can you create a chart or graph from raw data set and/or Pivot Table in Excel? Can you enhance the table/chart/graph in Excel for final presentation? Today’s Date: __________________
Excel_Guided+Notes_Answers.docx