Fun with Excel |
Most popular question:
HOW DO I RAISE MY GRADE? |
Data Analysis Portfolio HELP here:
Unit 4 is all about using spreadsheets. ALL of Unit 4 is important to really practice. The portfolio at the end of Unit 4 is a designed to show me that you know how to use a spreadsheet. I'm not looking for perfection. I'm looking for basic skills in using a spreadsheet. You may use Excel, Google Sheets or Libre Office spreadsheets. If you do NOT create a graph in the spreadsheet and show me in the spreadsheet, how do I grade that portion of the assignment? That is why I NEED the spreadsheet...not JUST the summary (which you may do IN the spreadsheet or in another document).
- This link will walk you through creating a scatterplot in Excel
- This link will guide you through adding a Trend Line to your Scatterplot
If you are using Google Sheets, please watch these:
- This will walk you through creating a scatterpoint graph and trendline in Google Sheets.
- This will show you how to save and send it to me in a format that I can open.
Here is an example of the Scatterpoint chart and Trendline. Your chart will look different because your data is different.
Unit 4 Data Analysis Instructions download
Unit 4 Excel Spreadsheet template download
Brief instructions on doing the scatterplot and trendline in Excel
Citing Sources
This is the fast and easy way to cite sources in Word.
Week 3
This is a short video that will help you insert shapes and create graphics in your documents
Week 2 -- Computers
This document has links to options other than Microsoft Office. If you don't have Microsoft Office and need to get the appropriate software, check here:
|
How to Improve your Scores |
alternatives_to_ms.pdf | |
File Size: | 2325 kb |
File Type: |
Don't forget, you can always use Google Docs and Google Sheets for these upcoming assignments.
Access Fall Term's video lessons for review here:
- Week 12 (Plagiarism)
- Week 11 (Audacity Link)
- Week 9 & 10
- Week 8 (NASA)
- Week 7 video and check in held over for another week--see above
- Week 6 Video
- Week 5 Video
- Week 4 Video Lesson was such a fail, I'm not showing it.
- Week 3 Video Lesson (removed for lack of sound, ugh)
- Week 2 Video Lesson
- Week 1 Video Lesson