Microsoft Excel
|
4-6 Weeks based on Project(s)
|
- What is Microsoft Excel mainly used for?
- What is a spreadsheet?
- 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
|
- Title Bar
- Save
- Save As
- Open
- New Document
- Print
- Ribbon
- Tab
- Insert
- Space
- Backspace
- Enter
- Font
- Font Size
- Font Color
- Font Weight
- Text Decoration
- Text Alignment
- Cut
- Copy
- Paste
- Table
- Picture
- Online Picture
- ClipArt
- SmartArt
- WordArt
- Shapes
- Screenshot
- Text Box
- Format
- Symbol
- Equation
- Theme
- Row
- Column
- Cell
- Formula
- Sum
- Average
- Percentage
- Bar Graph
- Pie Graph
- Column Graph
- Line Graph
- Sheets
- Formatting
- Sorting
|
Projects:
- Multiplication Table
- Survey Spreadsheet
|
|
Microsoft PowerPoint
|
4-6 Weeks based on Project(s)
|
- What is Microsoft PowerPoint mainly used for?
- What are the two main concepts that you need to keep in mind when developing a PowerPoint presentation?
- What type of situations would a PowerPoint be helpful to utilize?
- 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
|
- Title Bar
- Save
- Save As
- Open
- New Document
- Print
- Ribbon
- Tab
- Insert
- Space
- Backspace
- Enter
- Font
- Font Size
- Font Color
- Font Weight
- Text Decoration
- Text Alignment
- Cut
- Copy
- Paste
- Table
- Picture
- Online Picture
- ClipArt
- SmartArt
- WordArt
- Shapes
- Screenshot
- Text Box
- Format
- Symbol
- Equation
- Theme
|
Projects:
- Government PowerPoint
|
|
Microsoft Publisher
|
1-4 weeks based on Project(s)
|
- What is Microsoft Publisher mainly used for?
- Identify the main components of Microsoft Publisher in relation to the other Office programs?
- What is a key difference between Word and Publisher?
|
- In what situation would you choose Microsoft Publisher over Microsoft Word?
- What are three benefits for utilizing Microsoft Publisher?
- 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
|
- Title Bar
- Save
- Save As
- Open
- New Document
- Print
- Ribbon
- Tab
- Insert
- Space
- Backspace
- Enter
- Homerow
- Font
- Font Size
- Font Color
- Font Weight
- Text Decoration
- Text Alignment
- Cut
- Copy
- Paste
- Cover Page
- Table of Contents
- Table
- Picture
- Online Picture
- ClipArt
- SmartArt
- WordArt
- Shapes
- Screenshot
- Text Box
- Format
- Symbol
- Equation
- Theme
- Background Color
- Page Boarder
- Margin
- Page Size
- Orientation (Portrait/Landscape)
|
Projects:
- Government quiz plate
- Flashcards
|
|
Microsoft Word
|
1-4 Weeks based on project(s)
|
- What is Microsoft Word mainly used for?
- Identify the key components of Microsoft Word in relation to the Office Suite.
|
- What do we mainly use Microsoft Word for?
- What and where is the title bar located?
- What and where is the ribbon located?
- What are tabs?
- How do you open/create a document? Give at least 2 ways.
- Where does text/images go when you open a Word document?
- What is page orientation mean?
- What is the default page orientation?
- 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:
|
- Title Bar
- Save
- Save As
- Open
- New Document
- Print
- Ribbon
- Tab
- Insert
- Space
- Backspace
- Enter
- Homerow
- Font
- Font Size
- Font Color
- Font Weight
- Text Decoration
- Text Alignment
- Cut
- Copy
- Paste
- Cover Page
- Table of Contents
- Table
- Picture
- Online Picture
- ClipArt
- SmartArt
- WordArt
- Shapes
- Screenshot
- Text Box
- Format
- Symbol
- Equation
- Theme
- Background Color
- Page Boarder
- Margin
- Page Size
- Orientation (Portrait/Landscape)
|
Projects:
- Declaration of Independence
- 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)
|
- 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
- Network folder
- Network location
- Network
- 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
|
|