Proficiency with Simplicity

1. Proficiency with Simplicity

2. Tech Integration Tips, Tricks, and Techniques Using Microsoft Office

3. Barbara K. Barr District Technology Resource Teacher

4. Barbara K. Barr bbarr@fayette.k12.ky.us

5. Agenda • Getting to know you ~ PARTICIPATION! • Getting to know me • Why? • Integration: Current theories • Resources • Tips and Tricks • Fun and Games • Door Prizes!!!!!

6. Getting to Know You Please Raise Your Hand!

7. Getting to Know You • Classroom teachers, technology, media specialists, administration • Pre-school, elementary, middle school, high school, P/K – 12, college • Average classroom in your building/district: One, Two, Few, ? computers

8. Getting to Know Me

9. Some Important Notes! <I am not an employee of Microsoft! <No one in my family is an employee of Microsoft! <I am not receiving products or special treatment from Microsoft! (How I wish) <Most of these tips, tricks, and techniques can be used with ClarisWorks/AppleWorks, Lotus SmartSuite, and other similar products.

10. Some Important Notes! <Technology use is easier when one uses software with common terms and features. <Technology integration can be simple, and does not require lots of software. <MS Office, ClarisWorks/AppleWorks, Lotus SmartSuite have just about anything an educator could want to integrate technology and make real life connections.

11. Some Important Notes! <There are many other wonderful resources to help you integrate technology with ClarisWorks/AppleWorks, Microsoft, and similar products. <Keep in mind that almost every function in Office programs has multiple ways to be accomplished. I may show you only one way, and there are usually a number of other ways to do the same thing!

12. Why??? • Frustrated faculty • User problems • Time To learn how to use programs To reinforce what has been learned To plan or prepare for integration • Money • Difference in programs • Similarities in a family of programs • Developmentally appropriate • Paint by number approach vs. easel and oils

13. Commonalities

14. Integration • History of computer education • Teacher use/Student use • Tipping Point • Mastering the one, two, or few computer classroom • Daily opportunities • Daily tool • Equity for all students

15. Some Current Resources • Microsoft http://www.microsoft.com/education/ CD Local reps • Teacher Created Materials • ClarisWorks/AppleWorks • Training • Websites • Technology Wizards • Books

16. Tips and Tricks W A R N I N G Be sure to try these things at home, at school, at the office, or where ever you can find a computer!

17. Clip Art

18. MS Clip Art Search Clips On- Line

19. Clips On-Line

20. Downloading Clips

21. Wonderful Word

22. Where to use Word • In the classroom, Word can be used for just about anything for which you would normally use a paper and pencil. • Student workstations • Center activities • Small group activities • Large group presentations with SmartBoards, scan converters, multimedia projectors • Computer labs • Teacher/Administration workstations

23. Customizing Your Program 1.On your Menu Bar, click on Format. On the drop down menu, select Font. 2. In the dialogue box, select your desired Font, then select your desired Font Style, followed by selecting your desired size. Click on Default to set your program for this font.

24. Creating Styles Why??? It is easy to personalize Word to meet the needs of individual students, or to work with special projects. It is essential to set up new styles for younger or special needs students in order to keep the computer developmentally appropriate for them.

25. When to Use New Styles I set up some of the following styles for teachers: Primary writing: For writing projects in the primary classes Student writing: For writing projects in the intermediate classes. Writing: For secondary writing projects. Spelling: For spelling and related projects. Small group: A larger font, perhaps in a color, for small groups of people working at the computer. Large group: A large font, generally in a color, for viewing on a television screen or SmartBoard. Individual student name: For students with special needs. Math: Includes superscript for formulas and math symbols.

28. Creating New Styles 1. On the Menu Bar, click on Format. On the drop down menu, select Style, and click. 2. In the dialogue box, you will click on New.

29. Selecting Fonts 3.    In the next dialogue box enter the new name for your style in the box entitled Name. Click on the Add to template box to keep your style. 4.   Click on Format, followed by selecting Font. 4. Select Font. Next, select the style you want. Lastly select the size for your style. You will see a sample in the box at the bottom on the dialogue box. Then click OK, OK, and Apply.

30. Venn Diagrams Use the circle on the drawing tool bar.

31. Venn Diagrams Select “No Fill” on the “Fill Color” Tool

32. Venn Diagrams Place text boxes appropriately.

33. Word Tables

34. Making Word Tables

35. Sample Word Table

36. Everyday Use

37. Report Cards

38. Mrs. Chapman’s Question of the Day Date: Friday, September 1, 2000 Question: What are your favorite things to eat for lunch? Question of the Day

39. Use Tables for BINGO

40. Pyramid Spelling

41. Pyramid Spelling 1. In Word, select “Spelling” style. Your style setting is generally on “Normal.” 2. To set columns, go to Format, then click on columns

42. Pyramid Spelling 3. Select 2, 3, or 4 columns, depending upon the number of spelling works. Then click OK.  4. Your computer is now set up on Spelling style and columns. 5. For the spelling activity, students first begin a new Word Document. They enter their name and begin writing the spelling words.

43. Excellent Excel

44. Uses for Excel <Grading – it even totals and averages grades! <Charting information <Gathering data for projects <Translating numbers into various types of charts and graphs <Comprehending charts and graphs <Lesson plans <Calendars <Spreadsheets <Insert in all other Office programs <Planning <Student projects <Tracking bank accounts and checking accounts <Student records

45. Excel

46. Excel Tip 1. Select all button can be used to select everything or to uniformly expand the cells. Click on the button, then place cursors betweennumbers and letters. When you see the two sided arrows, pull to stretch.

47. Navigation Tricks 2. Use the Border Tool on highlighted areas to set the boundaries of your spread- sheet and to see the individual cells. Click on the arrow next to the button for a drop down menu of borders styles. 3. Navigation on your spreadsheet will be easier if you use Control plus home, end, arrow up, arrow down, arrow right, and arrow left. 4. Control end will take you to your last entry.

48. Autofill 5. Autofill will automatically help you make calendars with months or days. Write Jan. or January/Mon or Monday in a cell. Click on the lower right corner, then press the alt button until you see a small Plus sign. Drag to the right. You will see the other days and/or months. To copy, do the same thing using the control button.

49. More Tricks 6. Use Shift Click to highlight or select adjacent areas. 7. Use Control Click to highlight or select non-adjacent areas.

50. Charts and Graphs 8. To make a chart or graph, highlight the information. Click on the chart icon or go to the menu bar and click on view, then toolbars, then chart. Follow the chart wizard.