Microsoft Excel

4-6 Weeks based on Project(s)

1. What is Microsoft Excel mainly used for?
2. What is a spreadsheet?
3. What is a graph?

File Tab:

• Create a new blank book
• Create a new template book
• Open a saved book from: Network or OneDrive locations
• Save a book to: Network or OneDrive locations
• Print a book
• Export (pdf)

Home Tab:

• Copy, Cut, Paste
• Change the font
• Change the font size
• Change the font color
• Change the font weight
• Add italics
• Add an Underline
• Change the text alignment
• Add bullets/lists
• Numbers
• Insert
• Delete
• Format
• Sort

Insert Tab:

• Tables
• Insert Picture Placeholder
• Insert Picture from file
• Insert Oneline Picture
• Insert ClipArt
• Insert/Edit SmartArt
• Insert/Edit page parts
• Insert/Edit boarders and accents
• Insert page numbers
• Insert Shapes
• Insert Screenshot
• Insert/Edit Word Art
• Insert Text Box (draw text box)
• Insert Symbol
• Insert Equation
• Insert Audio
• Insert Video
• Charts (Pie, Bar, Column, Line)
• Hyperlink

Page Layout Tab:

• Themes
• Page Set-up (margin, orientation, size, print area, breaks, background, print titles)

Formulas Tab:

•  Functions (add, subtract, multiply, divide, average, percentage)

Review Tab:

• Protect worksheet, workbook
• Share

View Tab:

•  Normal, Page Break, Page Layout, Custom
• Gridlines, Formula Bar, Headings

1. Title Bar
2. Save
3. Save As
4. Open
5. New Document
6. Print
7. Ribbon
8. Tab
9. Insert
10. Space
11. Backspace
12. Enter
13. Font
14. Font Size
15. Font Color
16. Font Weight
17. Text Decoration
18. Text Alignment
19. Cut
20. Copy
21. Paste
22. Table
23. Picture
24. Online Picture
25. ClipArt
26. SmartArt
27. WordArt
28. Shapes
29. Screenshot
30. Text Box
31. Format
32. Symbol
33. Equation
34. Theme
35. Row
36. Column
37. Cell
38. Formula
39. Sum
40. Average
41. Percentage
42. Bar Graph
43. Pie Graph
44. Column Graph
45. Line Graph
46. Sheets
47. Formatting
48. Sorting

Projects:

1. Multiplication Table
2. Survey Spreadsheet

Microsoft PowerPoint

4-6 Weeks based on Project(s)

1. What is Microsoft PowerPoint mainly used for?
2. What are the two main concepts that you need to keep in mind when developing a PowerPoint presentation?
3. What type of situations would a PowerPoint be helpful to utilize?
4. What type of situations would a PowerPoint be hurtful to utilize?

File Tab:

• Create a new blank presentation
• Create a new template presentation
• Open a saved presentation from: Network or OneDrive locations
• Save a presentation to: Network or OneDrive locations
• Print a presentation (1 per page, 4 per page, with notes)
• Export (presentation, handouts)
• Share (email, online)

Home Tab:

• Copy, Cut, Paste
• Change the font
• Change the font size
• Change the font color
• Change the font weight
• Add italics
• Add an Underline
• Change the text alignment
• Add bullets/lists

Insert Tab:

• Insert/Edit Table
• Insert Picture Placeholder
• Insert Picture from file
• Insert Oneline Picture
• Insert ClipArt
• Insert/Edit SmartArt
• Insert/Edit page parts
• Insert/Edit boarders and accents
• Insert page numbers
• Insert Shapes
• Insert Screenshot
• Insert/Edit Word Art
• Insert Text Box (draw text box)
• Insert Symbol
• Insert Equation
• Insert Audio
• Insert Video

 Design Tab:

• Slide Background
• Slide Side (standard, widescreen, custom)
• Change theme
• Change color scheme

Transition Tab:

• Tansitions types
• Transition effect options
• Sounds
• Durations
• Advance Slide (on-click, after)
• Apply to all
• Remove tansition (right-click on slide)
• Preview

 Animations Tab:

• Animations (Entrance, Exit, Emphaisis, Motion Paths)
• Animation options
• Animation Pane (on-click, with previous, with after, moving order)
• Animation Trigger
• Animation Painter
• Start animation
• Duration of animation
• Delay animation
• Reorder animation (move up, move down)
• Preview

 Slideshow Tab:

• From beginning slide
• From current slide
• Present online
• Custom slideshow
• Setup slideshow
• Hide slide
• Rehearse timing
• Record slideshow
• Play narrations
• Using timings
• Show media controls
• Monitor (automatic, primary)
• Use presentor view

Review Tab:

•  Compare (merge two presentations together)
• Inking
• Link Notes

View Tab:

• Normal, outline, slide sorter, notes page, reading view
• Slide master, handout master, notes master
• Rulers, Gridlines, Guides
• Notes
• Color/Grayscale

Shortcuts:

• ESC - Exit slideshow
• F5 - Start slideshow

1. Title Bar
2. Save
3. Save As
4. Open
5. New Document
6. Print
7. Ribbon
8. Tab
9. Insert
10. Space
11. Backspace
12. Enter
13. Font
14. Font Size
15. Font Color
16. Font Weight
17. Text Decoration
18. Text Alignment
19. Cut
20. Copy
21. Paste
22. Table
23. Picture
24. Online Picture
25. ClipArt
26. SmartArt
27. WordArt
28. Shapes
29. Screenshot
30. Text Box
31. Format
32. Symbol
33. Equation
34. Theme

Projects:

1. Government PowerPoint

Microsoft Publisher

1-4 weeks based on Project(s)

1. What is Microsoft Publisher mainly used for?
2. Identify the main components of Microsoft Publisher in relation to the other Office programs?
3. What is a key difference between Word and Publisher?

1. In what situation would you choose Microsoft Publisher over Microsoft Word?
2. What are three benefits for utilizing Microsoft Publisher?
3. What types of documents can you create in Microsoft Publisher?

File Tab:

• Create a new blank document (portrait, landscape, different size)
• Create a new template document
• Open a saved document from: Network or OneDrive locations
• Save a documnet to: Network or OneDrive locations
• Print a document

Home Tab:

• Copy, Cut, Paste
• Change the font
• Change the font size
• Change the font color
• Change the font weight
• Add italics
• Add an Underline
• Change the text alignment
• Add bullets/lists

Insert Tab:

• Insert/Edit Table
• Insert Picture Placeholder
• Insert Picture from file
• Insert Oneline Picture
• Insert ClipArt
• Insert/Edit SmartArt
• Insert/Edit page parts
• Insert/Edit boarders and accents
• Insert page numbers
• Insert Shapes
• Insert Screenshot
• Insert/Edit Word Art
• Insert Text Box (draw text box)
• Insert Symbol
• Insert Equation

Design Tab:

• Insert a page background
• Change the theme
• Change color scheme
• Change guides
• Create/Edit/Delete Master Pages

Navigation Pane:

• Navigation
• Insert new (1 or 2 page)
• Insert Duplicate (1 or 2 page)
• Delete page
• Move page
• Rename page
• Page Numbers (locations)
• Master pages (apply/remove)
• View as two page spread

Document Pane:

• Rulers
• Print Lines
• Guide Lines
• Zooming

1. Title Bar
2. Save
3. Save As
4. Open
5. New Document
6. Print
7. Ribbon
8. Tab
9. Insert
10. Space
11. Backspace
12. Enter
13. Homerow
14. Font
15. Font Size
16. Font Color
17. Font Weight
18. Text Decoration
19. Text Alignment
20. Cut
21. Copy
22. Paste
23. Cover Page
24. Table of Contents
25. Table
26. Picture
27. Online Picture
28. ClipArt
29. SmartArt
30. WordArt
31. Shapes
32. Screenshot
33. Text Box
34. Format
35. Symbol
36. Equation
37. Theme
38. Background Color
39. Page Boarder
40. Margin
41. Page Size
42. Orientation (Portrait/Landscape)

Projects:

• Government quiz plate
• Flashcards

Microsoft Word

1-4 Weeks based on project(s)

1. What is Microsoft Word mainly used for?
2. Identify the key components of Microsoft Word in relation to the Office Suite.

1. What do we mainly use Microsoft Word for?
2. What and where is the title bar located?
3. What and where is the ribbon located?
4. What are tabs?
5. How do you open/create a document? Give at least 2 ways.
6. Where does text/images go when you open a Word document?
7. What is page orientation mean?
8. What is the default page orientation?
9. What allows for some flexibility within Microsoft Word in where items can be placed on a page?

File Tab:

• Create a new blank document
• Create a new template document
• Open a saved document from: Network or OneDrive locations
• Save a documnet to: Network or OneDrive locations
• Print a document

Home Tab:

• Copy, Cut, Paste
• Change the font
• Change the font size
• Change the font color
• Change the font weight
• Add italics
• Add an Underline
• Change the text alignment
• Add bullets/lists

Insert Tab:

• Insert/Edit Cover Page
• Insert/Edit Tablet of Contents
• Insert/Edit Table
• Insert Picture from file
• Insert Oneline Picture
• Insert ClipArt
• Insert/Edit SmartArt
• Insert Shapes
• Insert Screenshot
• Insert/Edit Word Art
• Insert Text Box (draw text box)
• Insert Symbol
• Insert Equation
• Insert page numbers

Design Tab:

• Insert a page boarder
• Insert a page background
• Change the theme

Page Layout Tab:

• Change the page orientation (Portrait or Landscape)
• Change the margins
• Change the page size

Document Pane:

• Zooming

1. Title Bar
2. Save
3. Save As
4. Open
5. New Document
6. Print
7. Ribbon
8. Tab
9. Insert
10. Space
11. Backspace
12. Enter
13. Homerow
14. Font
15. Font Size
16. Font Color
17. Font Weight
18. Text Decoration
19. Text Alignment
20. Cut
21. Copy
22. Paste
23. Cover Page
24. Table of Contents
25. Table
26. Picture
27. Online Picture
28. ClipArt
29. SmartArt
30. WordArt
31. Shapes
32. Screenshot
33. Text Box
34. Format
35. Symbol
36. Equation
37. Theme
38. Background Color
39. Page Boarder
40. Margin
41. Page Size
42. Orientation (Portrait/Landscape)

Projects:

1. Declaration of Independence
2. The Bill of Rights

Tablet/Office 365 Introduction

1-4 weeks as needed

Tablet:

• Hardware Procedures
• Software Procedures
• Care and Maintenance
• Troubleshooting
• Expectations

Outlook:

• What is an email?
• What is the difference between reply and reply-all?
• How do you find a contact?
• Can you share a calendar?
• Can you add additional calendars to your Outllok account?
• Where can you go to access your email through a web browser?

OneDrive:

• Do you have access to your files anywhere, anytime? Why?
• Can files be shared with other students/teachers?
• What is the structure of your OneDrive folder?
• Can you add additional folders to OneDrive?
• What is the difference between the network drives and OneDrive?

OneNote:

• Where do you create new OneNote notebooks?
• Can you open a shared notebook directly from OneNote?
• When you insert information into your OneNote, can a teacher see it?
• Name two ways in which you can send information to a teacher or another student directly from OneNote?
• Can you export Notebook information?
• Is there a way to look back at the revisions that have happened in OneNote?

Outlook:

• Create new message
• Send new message
• To: / Address book
• CC: / Address book
• BCC: / Address book
• Subject / Message
• Insert/Attach File
• Add Calendar Item
• Update Calendar Item
• Delete Calendar Item
• Categorize Item / Color Scheme
• Recurring Item

OneNote:

• Open Notebook (Local, Web-based, SharePoint)
• Export Notebook
• Print Notebook
• Share Notebook

OneDrive:

• Create new folders
• Save/open documents

Network Documents:

• Save/open documents from network locations
• Move old documents into OneDrive

SharePoint / OneDrive Pro for Business:

• Website: https://tuckahoe.sharepoint.com
• Status Bar / Icon
• Sync Folder / Sync New Folder
• Sync now
• web-based SharePoint
• Download File(s)

1. email
2. Compose
3. New Message
4. Reply
5. Reply All
6. Forward
7. Address Book
8. CC (Carbon Copy)
9. BCC (Blind Carbon Copy)
10. Sync
11. Upload
12. Download
13. URL (Uniform Resource Locator)
14. https:// (Hyper-text Transfer Protacol Secure
15. Status Bar
16. Icon
17. Right-click menu
18. Import
19. Export
20. Network folder
21. Network location
22. Network
23. Shared Folder

• email
• Compose
• New Message
• Reply
• Reply All
• Forward
• Address Book
• CC (Carbon Copy)
• BCC (Blind Carbon Copy)
• Sync
• Upload
• Download
• URL (Uniform Resource Locator)
• https:// (Hyper-text Transfer Protacol Secure
• Status Bar
• Icon
• Right-click menu
• Import
• Export
• Save
• Save As
• Copy/Cut/Paste