20 20 total 100 100 week 6 exercise requirements points available points earned comments freezing panes B u s i n e s s F i n a n c e

20 20 total 100 100 week 6 exercise requirements points available points earned comments freezing panes B u s i n e s s F i n a n c e

W5: Functions

Discussion Points:
Please select one new function that you have not used before, look it up, and teach us all about it. Please include (1) what the function is, (2) how it works, (3) explain how you might use it or in what situation it may be helpful, (4) explain how what you have learned in the course so far helped you in learning this additional function. You may also explain how difficult or easy it was to learn the new functions and why. Please share everything you learned with your peers. Using functions is a valuable way of displaying information in an Excel spreadsheet. If you have experience in using functions in MS Word tables, you may compare and contrast using calculations in both programs.

W6: The Next Course Enrollment

Congratulations on completing your course! Please reflect and share your educational goals. Here are some questions to serve as a catalyst for your reflection and discussion:

  • Why are softskills important to your success as an information technology practitioner?
  • How effective are you at leading, working as a team member, collaborating and communicating with others?
  • What degree are you working toward? ( accounting)
  • What benefits do you hope to achieve with your degree e.g. career advancement?
  • What is your progress in accomplishing your educational goals?
  • What courses are you starting next month? Why did you choose these courses?
  • If you anticipate any obstacles or have any concerns, how do you plan to address them?
  • Would you like to discuss your concerns with an APUS representative?

W8: Pivot Charts

Discussion Points:

What is a pivot tables? How do you create a pivot table in Excel? What are some uses of pivot tables? What does it mean to “pivot your data”? Give an example. How are filters and slicers used in pivot tables? What is a pivot chart? How do you create a pivot chart in Excel? What is the purpose of creating a pivot chart from your pivot table? Do the Challenge Exercises in the two modules below and report what your experience is like. Did you find it challenging? Did you find it useful? Do you think you will use pivot tables and pivot charts in the future?

Week 4 Project 1

Requirements

Points Available

Points Earned

Comments

Features:

  • In one column, you were to list assignment.
  • In the next column, you were to either put the grade (as a percentage of 100) that you have earned on the assignment (if it is already graded) or the grade you hope to earn on the assignment.
  • Underneath the list of assignments, you were to add a cell labeled “Final Score.”
  • In the cell next to it (underneath your list of scores), you were create a formula that uses the weighting of each assignment to calculate your final course grade.

50

50

Professional Impact: Be sure to include these key features (and more): font styles and sizes, borders, adjustments to column width and row height, cell borders and fill colors.

10

10

Organization: Be sure to include these key features (and more): number formatting, wrapping text, merging cells, and naming worksheets.

10

10

Creativity: Be sure to include these key features (and more): mathematical operators and formulas.

10

10

Overall Impression: Develop a course gradebook from scratch using MS Excel to predict your course grade.

20

20

Total

100

100

Upon completion, upload your Excel Spreadsheet to the Assignments area.

Week 5 Project 2

Requirements

Points Available

Points Earned

Comments

Features:

  • Develop a personal budget from scratch using MS Excel.
  • Create your own worksheet that incorporates income for all 12 months in the budget.
  • Create your own worksheet that incorporates expenses for all 12 months in the budget.
  • You should be able track your budget by subtracting your expenses from your income using a formula.

50

50

Professional Impact: Be sure to include these key features (and more): font styles and sizes, borders, adjustments to column width and row height, cell borders and fill colors.

10

10

Organization: Be sure to include these key features (and more): number formatting, wrapping text, merging cells, and naming worksheets

10

10

Creativity: Be sure to include these key features (and more): mathematical operators and formulas.

10

10

Overall Impression: Develop a personal budget from scratch using MS Excel.

20

20

Total

100

100

Week 6 Exercise

Requirements

Points Available

Points Earned

Comments

Freezing Panes & View Options – Challenge activity

  1. Follow the instruction given here
    • Freeze First Column and use the horizontal scroll bar to look at sales from 2015.
    • the first column.
    • Select cell G17 and select Split to split the worksheet into multiple panes. Hint: This should split the worksheet between rows 16 and 17 and columns F and G.
    • Use the horizontal scroll bar in the bottom right of the window to move the worksheet so that Column N, which contains data for January 2015, is next to Column F.
    • Open a new window for your workbook, and select the 2012-2013 Sales
    • Move your windows so they are side by side. Now you’re able to compare data for similar months from several different years.
  2. Use the file provided on the site. Create a screen shot of your edited document and paste it in Word before saving. Save as YourName_FreezingAndView.docx

30

Sorting Data – Challenge activity

  1. Follow the instruction given here
    • Selecct Challenge in the bottom-left of the workbook.
    • For the main table, create a custom sort that sorts by Grade from Smallest to Largest and then by Camper Name from A to Z.
    • Create a sort for the Additional Information section. Sort by Counselor (Column H) from A to Z.
  2. Use the file provided on the site. Create a screen shot of your edited document and paste it in Word before saving. Save as Sorting.docx

15

Filtering Data – Challenge activity

  1. Follow the instructions given here
    • Select Challenge in the bottom-left of the workbook.
    • Apply a filter to show only Electronics and Instruments.
    • Use the Search feature to filter item descriptions that contain the word Sansei. After you do this, you should have six entries showing.
    • Clear the Item Description filter.
    • Using a number filter, show loan amounts greater than or equal to $100.
    • Filter to show only items that have deadlines in 2016.
  2. Put your name on the file and screen shot the document showing your name. Paste the screenshot into Word before saving as YourName_Filtering.pdf. (Be sure to save it as a PDF file.)

55

Total

100

100

Week 7 Final Project

Assignment:

This project requires you to develop an Excel spreadsheet from scratch that incorporates the key features that you have learned about throughout the course. You will be graded on use of all features, professional impact, organization, creativity and overall impression. (Remember, creativity makes an impression!) Upon completion, upload your Project to the Assignments area of the classroom.

Topic: Management assigned you the task of organizing an award ceremony for your organization. They have asked you to organize data into a spreadsheet so they can easily view and manipulate the award types and amounts before decisions are made. The overall budget is an amount of your choosing. All of this information should be fictitious. You are required to create a spreadsheet to track all of the following items:

Details:
– Organization size: 30
– Award Ceremony Date: December 5th
– Two Types of Awards: Performance Award and Special Commendation Award
– Performance Awards can be given in the range of $500 – $5000
– Special Commendation Awards can be given in the range of $500 – $2000

Data to include:
– List of all employees receiving awards (should be at least 50% of employees)
– Type of award each employee will receive
– Amount of award each employee will receive
– Percentage of overall budget that each employee’s award will represent
– Percentage of overall budget that each type of award will represent
– Column totals using formulas

Features of Excel to Include:
– Use of formulas for adding and computing percentages
– Changes to font size and style, as appropriate for impact
– Label on worksheet
– Use Headings/Titles for each category listed
– Format currency to zero decimal places
– Adjust width of columns or wrapping the text within cells to avoid overlap of adjacent cells by long text entries
– Use color to emphasize important aspects of the sheet
– Use borders to separate sheet into appropriate sections
– Charts to show data

Submission Instructions: Submit your completed project as a Microsoft Excel attachment.

************

Details:

Organization size: 30

5

Award Ceremony Date: December 5th

5

Two Types of Awards: Performance Award and Special Commendation Award

10

Performance Awards can be given in the range of $500 – $5000

5

Special Commendation Awards can be given in the range of $500 – $2000

5

Data to include:

List of all employees receiving awards (should be at least 50% of employees)

10

Type of award each employee will receive

3

Amount of award each employee will receive

3

Percentage of overall budget that each employee’s award will represent

3

Percentage of overall budget that each type of award will represent

3

Column totals using formulas

10

Features of Excel to Include:

Use of formulas for adding and computing percentages

10

Changes to font size and style, as appropriate for impact

3

Label on worksheet

3

Use Headings/Titles for each category listed

3

Format currency to zero decimal places

3

Adjust width of columns or wrapping the text within cells to avoid overlap of adjacent cells by long text entries

2

Use color to emphasize important aspects of the sheet

2

Use borders to separate sheet into appropriate sections

2

Charts to show data

10

Grade

100