INSTRUCTIONAL TECHNOLOGY DEPARTMENT Tech Boot Camp: Microsoft Office Basics February 11, 2009 http://techbootcamp.weebly.com/technology-operations.html MACOMB INTERMEDIATE SCHOOL DISTRICT Instructional Technology Department 44001 Garfield Rd. Clinton Twshp., MI 48038 Fax: 586 228 1523 Frank Miracola: [email protected] 586 228 3417 Jennifer Parker-Moore, Ed.D. [email protected] 586 228 3517 http://www.misd.net Macomb Intermediate School District Department of Instructional Technology Presents Tech Boot Camp: Microsoft Office Basics February 11, 2009 featuring Dr. Jennifer Parker-Moore, Interactive Learning Consultant Mr. Frank Miracola, Interactive Learning Consultant Need an introduction to Word, Excel or PowerPoint? Get back to basics with this introductory level class that incorporates the basics of word processing, spreadsheets, and presentations with online productivity tools. Check out ZoomIt, shortcuts, templates, and other tips and tricks that make using Microsoft Office a snap! Word Learn how the experts create basic documents in Word, with some formatting and shortcuts thrown into the mix. Locate templates, create attractive layouts, add headers and footers, or track changes to your document. Excel Charts and spreadsheets are easy if you just have the basics. Learn how to use formulas to perform calculations within the worksheet. Create multiple worksheets, change names or customize formatting. Create a worksheet or chart in a snap! PowerPoint Add photos to create a photo album, prepare a digital story, setup a slide show for your Open House, or plan a lesson for students. All can be done very simply in PowerPoint. Learn how to create slides, add clipart, movies or photos, unique backgrounds and transitions, and WordArt to make it fun and you’re on your way! INSTRUCTIONAL TECHNOLOGY DEPARTMENT MICROSOFT WORD MACOMB INTERMEDIATE SCHOOL DISTRICT Instructional Technology Department 44001 Garfield Rd. Clinton Twshp., MI 48038 Fax: 586 228 1523 Frank Miracola: [email protected] 586 228 3417 Jennifer Parker-Moore, Ed.D. [email protected] 586 228 3517 http://www.misd.net Word Overview Using the Menu Bar Standard New Open Save Email Search Print Preview Spellcheck Cut, copy, paste Format painter Undo Hyperlinks Tables Columns Formatting Font Point size Bold, italics, underline Left, center, right, full justification Numbering Bullets Left, right indents Borders Highlighting Font color Menus File Edit View Insert o Symbols o Textboxes o Clipart, picture, objects Format o Paragraph Spac ing Han ging inde nts Tools o Track changes o Options (show all) Table Window Help Extra Word stuff Shortcuts Track changes Labels & Merge are too advanced for today! Word Hands on: Country of Kenya Activity or American Revolution Free Quick Reference Card Print It! Share it! Post it! Computer Training Courseware & eLearning www.customguide.com The Word 2003 Screen Title Bar Shortcuts Standard Toolbar Formatting Toolbar General Menu Bar Ruler End of Document Marker Task pane Vertical Split Bar Vertical Scroll Bar Open a Document Save a Document Print a Document Close a Document Undo Redo or Repeat Select Everything Help <Ctrl> + <O> <Ctrl> + <S> <Ctrl> + <P> <Ctrl> + <W> <Ctrl> + <Z> <Ctrl> + <Y> <Ctrl> + <A> <F1> Navigation — GO TO: Up One Screen View Buttons <Page Up> Down One Screen <Page Down> Beginning of a Line <Home> Status Bar Horizontal Scroll Bar The Fundamentals The Standard Toolbar New Blank Document Save Open E-mail Print Spell Check Cut Paste Insert Hyperlink Undo Print Research Copy Format Preview Painter Redo Insert Table Columns Document Map Insert Drawing Tables Worksheet and Borders Reading View Zoom End of a Line <End> Beginning of Document <Ctrl> + <Home> End of Document <Ctrl> + <End> Open the Go To Dialog Box <F5> Editing Show/ Hide Help Cut Copy Paste <Ctrl> + <X> <Ctrl> + <C> <Ctrl> + <V> To Create a New Document: Click the New Blank Document button, or press <Ctrl> + <N>. To Get Help: Press <F1> to open the Help task pane, type your question and press <Enter>. Open To Open a Document: Click the button on the Standard toolbar, or select File → Open from the menu, or press <Ctrl> + <O>. To Cut or Copy: Select the text and click the Cut button or Copy button on the Standard toolbar, or press <Ctrl> + <X> (cut) or <Ctrl> + <C> (copy). Save To Save a Document: Click the button on the Standard toolbar, or select File → Save from the menu, or press <Ctrl> + <S>. To Paste: Place the insertion point where you want to paste the text, click the Paste button on the Standard toolbar, or press <Ctrl> + <V>. To Save a Document with a Different Name: Select File → Save As from the menu and enter a different name for the document. To Move Text using Drag and Drop: Select the text you want to move, drag the text to the destination, and release the mouse button. Like this Quick Reference? You’ll LOVE the CD and book! To Preview a Document: Click the Print Preview button on the Standard toolbar or select File → Print Preview from the menu. Undo button on the To Undo: Click the Standard toolbar or press <Ctrl> + <Z>. Available at Amazon.com or your local bookstore, Personal Trainer will help you become a Word 2003 superhero! Interactive training CD with more than 12 hours of engaging lessons on Word Print To Print a Document: Click the button on the Standard toolbar, or select File → Print from the menu, or press <Ctrl> + <P>. For Advanced Print Options: Select File → Print from the menu. To Correct a Spelling Error: Right-click the error to bring up a suggestion menu. To Use the Thesaurus: Right-click the word you want to look up, select Synonyms from the shortcut menu, and select a synonym from the list. To Find Text: Select Edit → Find from the menu or press <Ctrl> + <F>. To Find and Replace Text: Select Edit → Replace from the menu, or press <Ctrl> + <H>. Formatting Bold Italics Underline Align Left Center Align Right Justify <Ctrl> + <B> <Ctrl> + <I> <Ctrl> + <U> <Ctrl> + <L> <Ctrl> + <E> <Ctrl> + <R> <Ctrl> + <J> Fully-illustrated and easy-to-read book Click to Learn More Bite-sized lessons: Learn what you need, at your own pace © 2005 CustomGuide, Inc. All rights reserved. © 2005 O’Reilly Media, Inc. O’Reilly logo is registered trademark of O’Reilly Media, Inc. You may print and distribute copies of this Quick Reference as long as you do not alter or sell them in any way. All other rights reserved. Formatting Tables Right Align The Formatting Toolbar Font Size Italic Style List Styles and Formatting Font List Left Align The Tables and Borders Toolbar Bullets Line Spacing Increase Highlight Indent Center Border Bold Numbering Decrease Underline Justify Indent Line Style Border Color Line Width Eraser tool Font Color To Format Selected Text: Change the style of text by clicking the Bold button, Italics button, or Underline button on the Formatting toolbar. Change the font type by selecting a font from the Font list on the Formatting toolbar. Change the font size by selecting it from the Font Size list. To Copy Formatting with the Format Painter: Select the text with the formatting you want to copy. Click the Format Painter button on the Standard toolbar and drag the Format Painter pointer across the text to which you want to apply the formatting. Double-click the Format Painter button to apply the formatting multiple times. To Change Paragraph Alignment: Select the paragraph(s) and Center, Right, or click the appropriate alignment button ( Left, Justify) on the Formatting toolbar. To Indent a Paragraph: Click the Increase Indent button on the Formatting toolbar, or click and drag the Left Indent marker on the ruler. To Decrease an Indent: Click the on the Formatting toolbar. Draw Table Decrease Indent button To Add a Tab Stop: Choose the type of tab you want to insert from the Tab selector box and click on the ruler to add the tab. Or select Format → Tabs from the menu and create tabs in the Tabs dialog box. To Adjust a Tab Stop: Click and drag the tab stop to the new position on the ruler. For exact measurements, select Format → Tabs from the menu and modify the tabs in the Tabs dialog box. To Remove a Tab Stop: Drag the tab stop from the ruler. To Change Paragraph Line Spacing: Select Format → Paragraph from the menu, click the Line Spacing list arrow, and select the spacing option. To Create a Bulleted or Numbered List: Select the paragraph(s) you want to bullet or number, and click the Bullets button or the Numbering button on the Formatting toolbar. To Add a Border: Select the paragraph and select a border from the Border button arrow on the Formatting toolbar. To Change a Document’s Margins: Select File → Page Setup from the menu, click the Margins tab, and adjust the margins. To Change a Page’s Orientation: Select File → Page Setup from the menu, click the Margins tab and select the orientation. To Add or View a Document Header or Footer: Select View → Header and Footer from the menu. To Switch Between the Header and Footer: Click the Switch Between Header and Footer button on the Header and Footer toolbar. To Insert a Manual Page Break: Place the insertion point where you want to insert the page break and press <Ctrl> + <Enter>. To Insert a Section Break: Select Insert → Break from the menu and select the type of section break you want to insert. To Create Newspaper Columns: Click the Columns button on the Standard toolbar and drag to select the number of columns you want. Cell Shading Color Add Borders Merge Align Cells button Insert Table Distribute Sort Columns Descending Evenly Text Direction Table AutoSum Split Cells Distribute AutoFormat Sort Rows Evenly Ascending Insert Table button on the To Create a Table: Click the Standard toolbar and select the number of columns and rows from the grid. To Adjust Column Width or Row Height: Drag the right border of the column, or drag the bottom border of the row. Right-click the border to AutoFit the column or row according to its contents. To Delete a Column or Row: Select the column or row, click the right mouse button and select Delete Columns or Delete Rows from the shortcut menu, or select Table → Delete → Columns or Rows from the menu. To Insert a Column or Row: Select the column or row where you want the new column or row to be inserted. Click the right mouse button and select Insert Columns or Insert Rows from the shortcut menu, or select Table → Insert → Columns or Rows from the menu. Drawing and Graphics The Drawing Toolbar Draw Menu Draw Text Draw Draw Line Rectangle Box Select Insert Draw Draw Objects AutoShape Arrow Circle Font Color Insert Clip Art Fill Object Color Insert Org Chart Insert Insert Picture WordArt Shadow Dash Style Line Color Line Style Arrow Style 3-D Effects To View the Drawing Toolbar: Click the Drawing button on the Standard toolbar, or select View → Toolbars → Drawing. To Insert a Clip Art Graphic: Select Insert → Picture → Clip Art, search by keyword, click the graphic’s list arrow, and select Insert. To Insert a Picture: Select Insert → Picture → From File from the menu, navigate to and select the file, and click Insert. To Draw an Object: Click the type of object you want to draw on the Drawing toolbar. Draw the shape by clicking on the document with the pointer and dragging until the shape reaches the desired size. To Move an Object: Click and drag the object using the mouse. To Resize an Object: Click the object to select it and drag the object’s sizing handles until the shape reaches the desired size. Mail Merge 1. Select the document type: Select Tools → Letters and Mailings → Mail Merge Wizard from the menu, select the type of main document type you want to use, and click Next. 2. Select the starting document: Specify how you want to set up your letters and click Next. 3. Select recipients: Specify the list of recipients you want to use (and enter the recipients if necessary) and click Next. 4. Write your letter: Place the insertion point where you want to insert the mail merge information in the Main Document and click the appropriate item(s) in the mail merge task pane. Click Next when you’re finished. 5. Preview your letters: Browse the merged letters and click Exclude to exclude a letter. Click Next when you’re finished. 6. Complete the Merge: Specify where you want to send the merged letters. © 2005 CustomGuide, Inc. All rights reserved. © 2005 O’Reilly Media, Inc. O’Reilly logo is registered trademark of O’Reilly Media, Inc. You may print and distribute copies of this Quick Reference as long as you do not alter or sell them in any way. All other rights reserved. Appendix A: Keyboard Shortcuts LINK to practice document: Women in American Revolution • • • • • • • • • • Ctrl – C = Copy Ctrl – V = Paste Ctrl – X = Cut Ctrl – Z = Undo Ctrl – A = Select All Ctrl – 1 = Single Space Ctrl – 2 = Double Space Alt – Tab = Move Between Programs Selecting B when in PPT = Screen Black Selecting W when in PPT = Screen White • Print Screen – Either Control+PrintScreen or just Print Screen Button Appendix B: Microsoft Word Shortcuts Zoom In and Out You can use the scroll button on your mouse to zoom in and out of documents quickly. Just hold down the Ctrl key and roll the scroll wheel forward to get a closer view of the document, or roll it back to shrink it. F7: Run the spell-checker. Shift-F7: Run the thesaurus. Shift-F3: Toggle Selected text between lowercase, initial capitals, and uppercase. F12: Open the Save As dialog Quickly Drawing a Line in a Word Document 3 hypens (---) and enter • • • Double click = to start typing anywhere in a Word document. Windows Key + D = to go desktop. Windows Key + M = minimize all open programs and documents. Format Painter INSTRUCTIONAL TECHNOLOGY DEPARTMENT MICROSOFT EXCEL MACOMB INTERMEDIATE SCHOOL DISTRICT Instructional Technology Department 44001 Garfield Rd. Clinton Twshp., MI 48038 Fax: 586 228 1523 Frank Miracola: [email protected] 586 228 3417 Jennifer Parker-Moore, Ed.D. [email protected] 586 228 3517 http://www.misd.net Excel Overview Standard Same as above Sort ascending, descending Chart wizard Formatting Same as above Merge and center Currency, percent, commas, decimals Formulas COUNT AVERAGE MAX MIN SUM MDAS (*/+-) Charting Chart Wizard Types range o o o o (rows vs. columns) X vs. Y titles, axes, gridlines, legends, data labels, data tables discuss difference - as new chart, in spreadsheet Excel Hands On: Practice 1,2,3 Add datasheets/worksheets, renaming Printing, set print area, what to print Office Basics - Excel Tour of screen: Columns (alphabetical) Rows (numbered) Cells identified as the intersection of Column/Row: “A1” Navigation Use arrow keys, Home (takes you to cell A1), End, Page Up, Page Down, Tab, Shift+Tab, or the Function Key 5 (F5) will GO TO a certain cell. Entering Data You may key information in any cell. Utilize the formatting tool bar to change the format of the information to dollars, percents, etc. Formatting cells On the tool bar, click on the $, %, or comma to format cells a certain way. You can also increase or decrease the number of decimals. Format, Cells Change the width of columns Use mouse to click between columns and drag to width desired or use Format, Column, Width Change the height of rows Use mouse to click between rows and drag to width desired or use Format, Row, Height Insert Row/Column Click where you want the row above or column to the left of and use Insert, Row or Column Wrap text Format, Cells, Alignment, check the “Wrap text” box Population of Northern Africa Merging cells Highlight two cells, Format, Cells, Merge cells Editing Cells You may type over a cell or go to the Edit mode with the Function Key 2 (F2). To delete rows or columns, click on Edit, Delete and select rows or columns. Sorting Click and drag (highlight) columns to be sorted. Click on Data, Sort, Ascending or Descending, OK If you wish to sort by two criteria (for example Western Africa and Population, identify both) Office Basics - Excel Charting To chart, click and drag on (highlight)the information to be charted. Click on the chart button on the tool bar. Complete steps 1-4. 1 2 3 4 When completing step 4, determine how you want to use the chart. “As New Sheet” will create a separate piece of paper. “As Object In” will let you insert the chart in an Excel sheet. Office Basics - Excel Chart Options Titles – Put titles on Chart, X (horizontal) axis title, Y (vertical) axis title Axes – format of graph using X or Y axis Gridlines – turn X and Y gridlines on or off Legend – A box to the left or right indicating what each color bar represents Data Labels – value or percent of each color bar, turn on or off Data Table – turn on or off ; the data sheet under the chart Formulas You can Count (only count cells that have numbers in them – it will not count cells that have letters [ex: names], Multiply(*), Divide (/), Add (+), Subtract (-), AVERAGE, and SUM. Or Use the AutoSum ∑ Headers and Footers Insert, Headers & Footers, Custom Header/Custom Footer Select left, middle or right heading Borders Use the borders button to add double lines or single lines under columns and make it look like a professionally prepared Accounting document! Name Date A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 B C D E Excel Basics Practice 1 Car Expenses Depreciation Insurance Maintenance and Repairs Gas/Oil Tires Taxes/Fees Total Expenses 1 2 3 4 5 6 7 8 9 10 Amount $ 49.00 $ 9.00 $ 5.00 $ 22.00 $ 2.00 $ 13.00 $ 100.00 Complete the following activities Create the worksheet Format the expensese in currency Align the expenses to the right Create a pie graph P t titl Put a title on the graph th h Label the pie graph with a legend on the right Label the pie graph with data labels that show percents Use a formula to find total expenses Put a header/footer on to include name, date Print on one page with formulas showing Car Expenses Depreciation 24% Insurance Maintenance and Repairs 50% 4% 3% Gas/Oil Tires Taxes/Fees 11% 1% 7% Total Expenses F Name Date A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 B C Excel Basics Practice 2 Name Sarah Shawn Raphael Michael Tommy Jeremy Su Li Carl Terri Kristen Juanita Pedro LaShawn Renee Stephen Sonya Todd Corbin Lester Ronald Jerry Jimmy MaryAlice Jay Conrad Sinbad Karly Samantha Lynn How many are over 5'6" What is the most frequent age What is the median/middle age What is the average age How old is the oldest student How old is the youngest student Height over 5'6" 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 =COUNT(B2:B30) Age 12 13 12 12 12 14 11 11 12 13 14 12 11 11 15 14 13 12 13 12 12 13 12 12 12 13 12 13 13 =MODE(C2:C30) =MEDIAN(C2:C30) =AVERAGE(C2:C30) =MAX(C2:C30) =MIN(C2:C30) D E Directions F 1 2 3 4 5 6 Enter the data in the worksheet G Center titles and data in Height, Age column Sort names AtoZ Put Header/Footer w/ Name, Date, Hour Use formulas to answer questions Print with formulas showing and on one page Name Date A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 B C D E F G Excel Basics Practice 3 Population of Africa Mid - 2001 in millions Northern Africa Algeria Egypt Libya Morocco Sudan Tunisia Western Sahara 177 =SUM(B6:B12) 31 69.8 5.2 29.2 31.8 9.7 0.3 Western Africa Benin Burkina Faso Cape Verde Cote d'Ivorie Gambia Ghana Guinea Guinea-Bissau Liberia Mali Mauritania Niger Nigeria Senegal Sierra Leone Togo 240 =SUM(B15:B30) 6.6 12.3 0.4 16.4 1.4 19.9 7.6 1.2 3.2 11 2.7 10.4 126.6 9.7 5.4 5.2 Eastern Africa Burundi Comoros Djibouti Eritrea Ethiopia Kenya Mdagascar Malawi Maritius Mayotte Mozambique Reunion Rwanda Seychelles Somalia Tanzania Uganda Zambia Zimbabwe 251.9 =SUM(B33:B51) 6.2 0.6 0.6 4.3 65.4 29.8 16.4 10.5 1.2 0.5 19.4 0.7 7.3 0.1 7.5 36.2 24 9.8 11.4 Middle Africa Angola Cameroon Central African Republic Chad Congo Congo, Dem. Rep. Of Equatorial Guinea Gabon Sao Tome and Principe 99 =SUM(B54:B62) 12.3 15.8 3.6 8.7 3.1 53.6 0.5 1.2 0.2 SAMPLE CHART Northern Africa Population 80 70 60 50 40 30 20 10 0 Algeria Egypt Libya Morocco Sudan 1 In Millions Tunisia Western Sahara SAMPLE FORMULAS Count =COUNT(B15:B30) Maximum =MAX(B15:B30) Minimum =MIN(B15:B30) Add =B15+B16 Multiply =B16*B17 Divide =B15/B17 Subtract =B17-B18 Sum =SUM(B15:B30) Average =AVERAGE(B15:B30) Southern Africa Botswana Lesotho Namibia South Africa Swaziland 50.3 =SUM(E44:E49) 1.6 2.2 1.8 43.6 1.1 INSTRUCTIONAL TECHNOLOGY DEPARTMENT MICROSOFT POWERPOINT MACOMB INTERMEDIATE SCHOOL DISTRICT Instructional Technology Department 44001 Garfield Rd. Clinton Twshp., MI 48038 Fax: 586 228 1523 Frank Miracola: [email protected] 586 228 3417 Jennifer Parker-Moore, Ed.D. [email protected] 586 228 3517 http://www.misd.net PowerPoint Overview Standard Same as above Formatting Same as above Menus File Edit View Insert Format Tools Slide Show Views of PowerPoint Outline, Notes, Slide Sorter, Slideshow Adding slides Format Slide Design, Slide layout, Backgrounds Fuzzy Boxes Two levels of fuzz; removing a fuzzy box Inserting Objects Picture Photo Album Chart Organizational chart Movie Sound Word Art Slideshow Animation, builds, transitions on objects and text Printing Specify notes, slides, 2-3-4-6 slides per page, outline, etc. PowerPoint Hands On: Create Social Studies Project – Country or Biographical Figure, Digital Story, Open House presentation Po erPoint PowerPoint -The Basics Basics-- 1 Common Abuses of PowerPoint Reading slides Text too small Using sentences instead of bullets so that it takes a lot of room and you just keep talking! Color conflicts Moving or flying text Annoying use of sounds Complex diagrams or charts 2 PowerPoint Training Outline Starting PowerPoint Click Start, Programs, Microsoft PowerPoint Click File, New There are many choices: Blank Presentation will be starting with no backgrounds or pre-defined outlines (Apply) Design Template will give you a choice of backgrounds for your presentation Auto Content Wizard gives you a variety of pre-defined outlines that you can modify to fit your presentation. These presentations vary from General to Sales/Marketing, Projects, Corporate or Carnegie Coach. Tour the Screen – The views of PowerPoint Outline view Notes o reduced slide with area for notes; often used for handouts Full Page Slide Slide Sorter o see all slides on the screen Slide Show Menu bar tips File o Save or Save as Web Page Edit o Undo is the same as on the toolbar View o Normal View the slide in its normal format o Slide Sorter View all slides on the screen at once o Notes Slide is smaller and includes an area for notes o Slide Show Continuous, can be timed or change slides through a mouse click o Master o B&W Color is a toggle switch Insert o New Slide o Picture here is where you add clipart, autoshapes, organizational charts, Word Art, Scanner/Digital Images, or a table You can insert animated gifs through clipart Insert, Pictures, Clipart, select pictures, sounds or motions o Text box o Movies & Sounds for pre-recorded digital video clips on file o Chart Use your Excel knowledge to enter cell information o Table Use your Word knowledge to modify the format Format o Font Can also be changed on the tool bar o Slide Layout Select the way you want your slide to look, including graphs, organizational charts, clipart or tables o Slide Color Scheme Change the colors on the slide o Background Select a new color scheme for the background Watch the color combinations Consumer colors are RED, BLUE AND YELLOW Use care in selecting how busy the slides are and how bright o Apply Design Template Select a pre-designed artistic background for all slides Again, watch how busy and bright they are Tools o Spelling Check the spelling of all slides – one error can make you look like a fool! Slide Show o View Show o Action Buttons Add buttons on the slide that will make sounds, run mini-programs, or go into Word for example. o Preset Animation Have your text fly in from the right, or drop from the “sky” o Slide Transition Create transition/build effects on all slides to show the beginning or ending of a slide Inserting Pictures off the Internet Right click on picture on the Internet Save Image As Make sure the file type is a .jpg, .gif. or some type of picture type so it can be inserted Go to PowerPoint Insert, Picture, From file MICROSOFT POWERPOINT 2003 Some important differences in how you do things … Using the AutoContent Wizard File, New, From AutoContent Wizard Changing the Design Template File, New, Design Templates, review the list in “Available for Use” and select one by double-clicking. Additional PowerPoint Backgrounds http://www.freefoto.com/pictures/powerpoint_backgrounds/index.asp http://www.powerpointart.com/cgi-bin/imagefolio/imageFolio.cgi http://www.slideboom.com Formatting the Slide Layout Format, Slide Layout, select layout from column on right. Note: change the views NORMAL, SLIDE SORTER, or SLIDESHOW in the bottom right corner. Use the tabs on the left column to toggle between OUTLINE and SLIDES views. Adding Animation with Transitions and Builds Transitions – for changes between slides Go to Slide Sorter view, Slide Show, Slide Transition, click on the slide you wish to transition or Apply to All Slides, select the effect in the Apply to selected slides window. Builds – for changes between text boxes, clipart, and other objects. Slide Show, Custom Animation, Add Effect, select when (Entrance, Emphasis, Exit, Motion Paths), select the effect (Blinds, Box, Checkerboard, Diamond, Fly In, etc.) Adding an Organizational Chart Using the Drawing toolbar, click on Insert Diagram or Organizational Chart OR Insert, Pictures, Organizational Chart Add subordinates, coworkers, and assistants by right clicking on the box and selecting from the popup menu. Key text within the boxes by clicking in the box. Saving Pictures or Images from the Internet when Image banks are blocked by Filter Locate any image on a web page Right click on the image “Save Picture As” or “Save Image As” If the Save Bar doesn’t appear in the top right corner, right click on the image, Save Picture As, give it a filename, Save Other picture sources: SchoolTube, United Streaming, Pics4Learning Inserting a Movie on the Slide Ex: UNITED STREAMING VIDEO Note: you must have already saved the video somewhere Insert, Movies and Sounds, Movie from File Note: I have placed my downloaded videos in a folder called STREAMING VIDEO Select when you want the movie to play. Automatically-will play the video when the slide comes up. When Clicked-will play the video when you click on the video box located on the slide. Printing in PowerPoint IMPORTANT: Do not print full page slides unless you need them. Always change “Print What” to handouts, and 3 or 6 per page Slides – full pages Notes – single slide with notes below Handouts – 2,3,4,6, or 9 slides per page Step 1: Click on “Print What” Change to “Handouts” Step 2: Click on “Slides per page” Change to 3 or 6 Step 3:Click “OK” Create a PowerPoint Project Create a basic slide show for an Open House or Parent Teacher Conferences. Include a minimum of 5 slides using a variety of formats. Required Elements: Slide 1 should be the title slide/”Welcome” Use the remaining slides to present information about your class Incorporate a variety of color, fonts, point sizes, and Word Art to make visually appealing Change Slide backgrounds or presentation templates to enhance presentation (try Slideboom!) Insert chart, graph, or organizational chart Create a photo album or add pictures Insert cliparts, movies and/or sounds from online sources (ex: Teachertube, Schooltube, United Streaming image bank, Microsoft Office Clipart Gallery, web images or etc.) Add Transitions and builds or custom animation effects Preview print with 2, 3, 4, 6, or 9 slides to page; notes pages, outline, full Technology Integration Project Social Studies: Africa & Europe 1. Internet Research a. Use an approved search site (Mel databases, etc.) to locate and print information on your assigned country within the continent of Europe or Africa. i. Locate the following information about your country: 1. Land a. Landscape b. Climate c. Natural resources d. Animals 2. Society & Culture a. Racial/ethnic groups b. Languages c. Religion d. Education or social issues e. Traditional dress 3. Economy (the money system) a. Products (agriculture, mining, manufacturing, forestry, fishing) b. Gross domestic product or Gross national product c. Per capita income 4. People (population) a. Growth or decline for the past ten years 5. History/Government a. Leaders b. What type of government do they have (democracy, dictatorship, etc.) c. Major events that have changed their country 9ex: war, famine, etc.) ii. Save 3+ pictures from the Internet to use in your report 2. Word a. Key a 1‐2 page report about your country and print i. Center, underline, boldface and italicize the title ii. Put a header/footer on wit name, date, and hour/teacher iii. Double space the paper iv. Make all margins 1” (top, bottom, left, right) v. Use appropriate font and point size (10 or 12 point font, Arial or Times New Roman) vi. Insert a clip art, Word Art, and at least one picture vii. Include the following side‐headings: 1. Land a. The landscape b. Climate c. Natural resources d. Animals 2. Society & culture a. Racial/ethnic groups b. Languages c. Religion d. Education or social issues e. Traditional dress 3. Economy (the money system) a. Products (agriculture, mining, manufacturing, forestry, fishing) b. Gross domestic product or Gross national product c. Per capita income 4. People (population) a. Growth or decline for the past ten years 5. History/Government a. Leaders b. What type of government do they have (democracy, dictatorship, etc.) c. Major events that have changed their country 9ex: war, famine, etc.) viii. Submit the report for grading based on the standard writing rubric. 3. 4. 5. Excel a. Create a spreadsheet of population information i. Use the maximum, minimum, count, sum and MDAS cell math functions to answer questions like: 1. What is the highest populated area 2. What is the lowest populated area 3. What is the total population 4. Others as demonstrated ii. Create a graph for your country’s population ( ex: bar, pie, X‐Y) and print on a full sheet iii. Print the worksheet with formulas showing! iv. Submit for grading based on the Excel rubric. PowerPoint a. Create a basic slide show about your country b. Change the background c. Add WordArt d. Include pictures and/or Clipart i. Include one map e. Include transitions and builds f. Include the following information i. Land 1. The landscape 2. Climate 3. Natural resources 4. Animals ii. Society & culture 1. Racial/ethnic groups 2. Languages 3. Religion 4. Education or social issues 5. Traditional dress iii. Economy (the money system) 1. Products (agriculture, mining, manufacturing, forestry, fishing) 2. Gross domestic product or Gross national product 3. Per capita income iv. People (population) 1. Growth or decline for the past ten years v. History/Government 1. Leaders 2. What type of government do they have (democracy, dictatorship, etc.) 3. Major events that have changed their country 9ex: war, famine, etc.) g. View the outline, view the slide show h. Get approval to print the slides 3 per page i. Submit for grading using the PowerPoint rubric. Capstone/Culminating activity : prepare a display or presentation for sharing with your class using the information obtained.
© Copyright 2025