Excel2
https://docs.google.com/document/d/1J_l8nx0RaFc87HJUZx5lfv1kHLW29v0e-bOeA7J0aNs/edit
Let's review with SECTIONING.
We can also review with all of the Excel spreadsheets on NJ Excel's website.
You can also use Pictochart to make infographics. Here is some data to play with. Plus there is Google Data Studio now too!
BELLRINGER
How do you make Checkboxes? Timesheets?
How should you demonstrate AP DATA for your district? Data Sheets from CollegeBoard and Possible Answer
Additional Sheets
Here is the Excel-enhanced SGO Excel Scoring and Tracking Tool
Additional Tipsa & Tricks
Create a drop-down list
- Open a spreadsheet in Google Sheets.
- Select the cell or cells where you want to create a drop-down list.
- Click Data. ...
- Next to "Criteria," choose an option: ...
- The cells will have a Down arrow. ...
- If you enter data in a cell that doesn't match an item on the list, you'll see a warning. ...
- Click Save.
Random Name Picker + (Richard Bryne)
Closure
Sparklines (on Google Sheets)
Filtering
Sorting
Freeze Panes
Handouts are attached to the bottom of this page.
EXCEL3 is a class based on using your own data for your Action Research report.
WHAT WORKS CLEARINGHOUSE: Educational Data and Evidence for ESSA
However, we also use the time to examine Google SHEETS (their version of Excel) and look at our district's most recent test scores. You can also use this Google Tutorial site.
Example: Morris County SUBS
Frank's PARCC Scores
Textbook Inventory https://docs.google.com/spreadsheets/d/1ioT6ZsXBdA7fbel1zFFXOrAGimWrH64NS3ohdvw6yf4/edit?usp=drive_web
Microsoft Excel Sessions