#13 Word, Excel, Powerpoint and REFLECTION #12

Word
- alternating between landscape and portrait views for flyers or storybook presentations.
- utilizing the research or "look up" tool to refine or support my statements.
- user friendly toolbar navigation
- autoformatting can often be frustrating when building tables

Excel
- primarily use excell for strength and conditioning spreadsheet

example:
CYCLE 4
Core Lift 1RM 90% Wendler Percentages
Squat 342 308 Week 1 Week 2 Week 3 Week 4
Bench 235 212 65% 80% 75% 40%
Shoulder Press 172 155 75% 85% 85% 50%
Deadlift 403 363 85% 90% 95% 60%
Core Lift
Squat Mon, 12 Nov Mon, 19 Nov Mon, 26 Nov Mon, 03 Dec
Set 1 200.00 215.00 230.00 125.00
Set 2 235.00 250.00 260.00 155.00
Set 3 265.00 280.00 295.00 185.00 -1.89% 0.00%
PR: Set 3 11 9 NA 367.04 360.08 #N/A
Bench Tue, 13 Nov Tue, 20 Nov Tue, 27 Nov Tue, 04 Dec
Set 1 135.00 170.00 160.00 85.00
Set 2 160.00 180.00 180.00 105.00
Set 3 180.00 190.00 200.00 125.00 0.00% 0.00%
PR: Set 3 8 NA 223.49 #N/A #N/A
Shoulder Press Thu, 15 Nov Thu, 22 Nov Thu, 29 Nov Thu, 06 Dec
Set 1 100.00 125.00 115.00 60.00
Set 2 115.00 130.00 130.00 75.00
Set 3 130.00 140.00 145.00 95.00 0.00% 0.00%
PR: Set 3 10 NA 173.38 #N/A #N/A
Deadlift Fri, 16 Nov Fri, 23 Nov Fri, 30 Nov Fri, 07 Dec
Set 1 235.00 290.00 270.00 145.00
Set 2 270.00 310.00 310.00 180.00
Set 3 310.00 325.00 345.00 220.00 0.00% 0.00%
PR: Set 3 15 NA 507.53 #N/A #N/A

Cells are formulated to adapt and change off of each other. Automatically calculates percentages of increase and improvement over various cycles.

Powerpoint
- primarily used for visual presentations
- pre designed slides are effective for building a quick and professional presentation
- animations are easily edited and applied to slideshow

- can be saved as PDF files



Project 1:

Create a Powerpoint Presentation
 Save as PDF
Create a free “FLIPSNACK” account

Upload PDF onto FLIPSNACK under “Make a Flipping Book”

Use free EMBED link to retrieve HTML for Link.
Access CLASS BLOG and click HTML and paste embedded link

Post Flipping Book to Blog 

Project 2:

Design a project where students must create an excel spreadsheet to document the expenditures for a hypothetical vacation trip. Students will be allotted 6,000$ each and must research and describe how funds will be spent during the vacation.




This should include:
- Gas/Airfare
- hotel
- food
- activities
- tours etc.

Project 3:

Conduct a survey among peers in regards to a specific interest of the students and have them use WORD to create a series of the various charts and graphs available in a word documents. Creating tables is an accurate way of recording results.

REFLECTION #12:
Excel spreadsheets have always been the most fascinating recording device to me. Also, it is the most difficult. Being able to successfully navigate Excel is a capacity that I am looking to further refine as I know that in the personal training, military and teaching worlds, documenting and recording strategies and assessments can prove beneficial to reviewing success. This brings me to the point of emphasis of programs being user friendly. In my experiences with Excel, it is not a very user friendly program, simply meaning that for the novice browser, Excel is difficult to function.