Skip to main content
Home of the Bulldogs
  1. Computer Applications (Period 5)
  2. Assignments

Computer Applications (Period 5) Assignments

Upcoming Assignments RSS Feed

No upcoming assignments.

Past Assignments

Due:

Assignment

Due:

Assignment

Lesson 11: Compare and Analyzing Data Microsoft Excel 2016

IN THIS CHAPTER, YOU WILL LEARN HOW TO

  • Using Parentheses in Formula
  • Calculating a value after an increase
  • Editing a Linked or embedded Chart in a Word Document
  • Creating and modify8ing hyperlinks

Due:

Assignment

Lesson 10: Advanced Chart Elements and Design

IN THIS CHAPTER, YOU WILL LEARN HOW TO:

  • Formatting Pie Chart style and elements
  • Adding special elements to chart or sheet to update a chart
  • Enhancing chart elements to plot and chart areas

Due:

Assignment

Due:

Assignment

Lesson 9: Creating Charts and Graphics Microsoft Excel 2016

PROJECT (20 POINTS)

Due:

Assignment

Lesson 8: Analyzing data and alternative data sets Microsoft Excel 2016

IN THIS CHAPTER, YOU WILL LEARN HOW TO

·         Examine data by using the Quick Analysis Lens.

·         Define an alternative data set.

·         Define multiple alternative data sets.

·         Analyze data by using data tables.

·         Vary your data to get a specific result by using Goal Seek.

Due:

Assignment

Lesson 7: Combining Multiple Data Sources Microsoft Excel 2016 PROJECT (20 POINTS) 

 
Scenario: Consolidate the Quarterly Sales and Commission Paid from four worksheets on a fifth worksheet in the same workbook. This takes the same data stored in four separate workbooks and consolidates the Quarterly Sales and Commission Paid by linking to a fifth workbook.

Due:

Assignment

Lesson 7: Combining Multiple Data Sources Microsoft Excel 2016

IN THIS CHAPTER, YOU WILL LEARN HOW TO:

  1. Use workbooks as templates for other workbooks.
  2. Link to data in other worksheets and workbooks.
  3. Consolidate multiple sets of data into a single workbook.

Due:

Assignment

Lesson 6: Reordering and Summarizing Data Microsoft Excel 2016

IN THIS CHAPTER, YOU WILL LEARN HOW TO:

  • Sort worksheet data.
  • Sort data by using custom lists.
  • Organize data into levels.
  • Look up information in a worksheet.

 Video#1

 Video#2

Due:

Assignment

Lesson 6: Reordering and Summarizing Data
Microsoft Excel 2016
PROJECT (20 POINTS)

Due:

Assignment

Lesson 5: Focusing on Data with Filters Microsoft Excel 2016

IN THIS CHAPTER, YOU WILL LEARN HOW TO

  • Limit data that appears on your screen.
  • Filter Excel table data by using slicers.
  • Manipulate worksheet data.
  • Define valid sets of values for ranges of cells.

 Video#1

 Video#2

Due:

Assignment

Lesson 5: Focusing on Data with Filters Microsoft Excel 2016

PROJECT (20 POINTS) 

Due:

Assignment

Lesson 4: Changing the Workbook Appearance Excel 2016

PROJECT (20 POINTS)

Scenario: As the Inventory Manager of the Voyager Travel Adventures retail store, you want to enhance the appearance of an inventory worksheet you have created. You have already complied the inventory data, and you want to spruce up the worksheet prior to printing by adding some formatting.

 

Due:

texture.jpg phone.jpg

Assignment

Lesson 4: Changing the Workbook Appearance Microsoft Excel 2016

IN THIS CHAPTER, YOU WILL LEARN HOW TO:

  • Format cells.
  • Define styles.
  • Apply workbook themes and Excel table styles.
  • Make numbers easier to read.
  • Change the appearance of data based on its value.
  • Add images to worksheets

Video #1

Video#2

Due:

Assignment

Lesson 3: Performing Calculations Data in Excel 2013

IN THIS CHAPTER, YOU WILL LEARN HOW TO:

  • Name groups of data.
  • Create formulas to calculate values.
  • Summarize data that meets specific conditions.
  • Work with iterative calculation options and automatic workbook calculation

Video#1

Video#2

Due:

Assignment

Lesson 3: Performing Calculations Data Excel 2016

PROJECT 1 (20 POINTS)

Due:

Assignment

Lesson 2: Working with Data in Excel 2016

IN THIS CHAPTER, YOU WILL LEARN HOW TO:

  • Enter and revise data.
  • Manage data by using Flash Fill.
  • Move data within a workbook.
  • Find and replace data.

Video#1

 

Video#2

 

Video#3

Due:

Assignment

Lesson 2: Working with Data Excel 2016

PROJECT 1 (20 POINTS)

Scenario: As an Adventure Coordinator for Voyager Travel Adventures, you make all the arrangements necessary to create a unique and thrilling adventure vacation for your clients.  Today, the Tell City Thrill Seekers Club has asked for an estimate of expenses per person for a special trip that combines white water rafting, back country hiking, and rock climbing. You have started both a trip budget for the club and a profit worksheet. To complete the two worksheets, you need to copy formulas, data, and formatting.

Due:

Assignment

Lesson 1: Getting Started with Excel 2016
PROJECT 1 (20 POINTS)

Scenario: In this project, you will enter and edit text, undo and redo editing actions, and check the spelling in a worksheet.