Lesson 2: Formulas, Functions, and Formatting Microsoft Excel 2016 Project (20 Points)

Mike Chen is the director of information systems for Flex Cab Company, a taxi service in Toronto, Ontario. Mike would like you to complete a report he has started to present statistics on the company’s on-time record for picking up passengers over a four-year period.

 

Lesson 1: Creating a Worksheet and a Chart
Microsoft Excel 2016

IN THIS CHAPTER, YOU WILL LEARN HOW TO:

• Describe the Excel worksheet
• Enter text and numbers
• Use the Sum button to sum a range of cells
• Enter a simple function
• Copy the contents of a cell to a range of cells using the fill handle
• Apply cell styles
• Format cells in a worksheet
• Create a 3-D pie chart
• Change a worksheet name and worksheet tab color
• Change document proprieties
• Preview and print a worksheet
• Use the AutoCalculate area to display statistics
• Correct errors on a worksheet

Lesson 2: Creating a Business Letter with a Letterhead and Table Microsoft Word 2016

IN THIS CHAPTER, YOU WILL LEARN HOW TO:

• Change Margins
• Insert and Format a Shape
• Change Text wrapping
• Insert and format a clip art image
• Insert a symbol
• Add a Border to a paragraph
• Clear Formatting
• Convert a hyperlink to regular text
• Apply a style
• Set and use tab stops
• Insert the current date
• Insert a Word table, enter data in the table, and format the table

Lesson 2: Creating a Business Letter with a Letterhead and Table Microsoft Word 2013 (20 Points)

Lesson 1: Creating, Formatting, and Editing a Word Document with a Picture Microsoft Word 2016

PROJECT DESCRIPTION

For your marketing and special event major, you are helping to coordinate a concert fundraiser for a local homeless shelter. The band that is headlining the event needs a substitute bass player and has asked for your help finishing their flyer. You will add a picture and formatting to create an eye-catching flyer.

• Enter Text in a new document
• Format the Text in the flyer
• Insert a Picture called Mount Trail, in the flyer
• Format the Picture in the flyer.
• Enhance the Page with a border and spacing
• Correct errors And Revise text in the flyer.
• Print or the flyer.

Lesson 8: Presentation Enhancements Microsoft PowerPoint 2016

IN THIS CHAPTER, YOU WILL LEARN HOW TO:

• Set up presentations for delivery.
• View and change slide masters.
• Add WordArt text
• Create hyperlinks
• Attach actions to text or objects.

Lesson 8: Presentation Enhancements in Microsoft PowerPoint 2016 PROJECT (20 Points)

Lesson 7: Visual Elements in Microsoft PowerPoint 2016

IN THIS CHAPTER, YOU WILL LEARN HOW TO:

• Customize diagrams.
• Format charts.
• Arrange graphics.

Lesson 7: Visual Elements in Microsoft PowerPoint 2013

PROJECT (20 Points)

Lesson 6: Present Content in Tables Microsoft PowerPoint 2016 PRACTICE (5 Points) and PROJECT (20 Points)

IN THIS CHAPTER, YOU WILL LEARN HOW TO:

• Insert tables.
• Format tables.

Microsoft PowerPoint 2013
Lesson 5: Review and Deliver Presentations

IN THIS CHAPTER, YOU WILL LEARN HOW TO

• Set up presentations for delivery. -  Task1  - Click here for video
• Preview and print presentations.  -   Task2 - Click here for video
• Prepare speaker notes and handouts.
• Finalize presentations.
• Deliver presentations.

Microsoft PowerPoint 2016

Lesson 5: Review and Deliver Presentations
Project (20 Points)

Microsoft PowerPoint 2016

Lesson 4: Visual Enhancements Project (20 Points)

Lesson 3: Work with Slides Microsoft PowerPoint 2016Project ( 20 Points)

Scenario: In this project, you work on the presentation to Wynnedale Medical Center by modifying list items, text alignment, text, and the position and size of the placeholders.

Lesson 3: Working with Slide Text Microsoft PowerPoint 2016 

IN THIS CHAPTER, YOU WILL LEARN HOW TO  

• Change the alignment, spacing, size, and look of text. 
  • Task1 - Click for video here. 
• Correct and size text while entering it.                         
  • Task 2 - Click for video here.
• Check spelling and choose the best wording.               
• Find and replace text and fonts.                 
  • Task 3 - Click for video here.                    
• Add text boxes.                                                             
  • Task 4 -Click for video here.

Lesson 2: Work with Slides Microsoft PowerPoint 2016

Project (20 points)

Scenario: In this project, you work on a presentation for Restoration Architecture, a local architecture firm. You will modify the presentation by copying slides within the presentation and from another presentation, and rearranging and deleting slides.

Microsoft PowerPoint 2016

Lesson #1 - Create Presentations 

Lesson 1: Create Presentations Microsoft PowerPoint 2016

Points: 25

IN THIS CHAPTER, YOU WILL LEARN HOW TO:

• Start and save presentations.
• Enter text in placeholders.
• Edit text.
• Add and delete slides.
• Import slides from existing sources.

Print the presentation as a four slide horizontal handout in landscape orientation and turn in.

Quia link here

Below is the link to the assignments survey.Link is here

 Lesson 8: Organizing and Customizing Folders and Files

 Lesson 7: Using Context Menus, the Mini Toolbars, and Keyboard Shortcuts

Answer the questions regarding Lesson #3 using the document Microsoft Office 2016 Lesson 3 from the class web page. Fill in the words from the text to finish the sentences or match the Microsoft Office program with its description. You must get at least 70% of the answers correct in order to pass.

 Answer the questions regarding Lesson #2 using the document Microsoft Office 2016 Lesson 2 from the class web page. Fill in the words from the text to finish the sentences or match the Microsoft Office program with its description. You must get at least 70% of the answers correct in order to pass.

Quia Link here

Answer the questions regarding Lesson #1 using the document Microsoft Office 2016 Lesson 1 from the class web page. Fill in the words from the text to finish the sentences or match the Microsoft Office program with its description. You must get at least 70% of the answers correct in order to pass.