EXTRA EXCEL UNIT FOR CERTIFICATION PREP

GOAL: Before you leave today you will know how to create a budget using Excel. More specifically, you will know:

  1. PR C-Projected Budget for Camp Orca.xlsx, Excel Unit C, Project 1
    1. In Project 1, you will create a budget for the Camp Orca, a summer camp in Washington State, and then ask several What if? questions that require you to change the budget entries. The goal of Project 1 is to show you how to use a spreadsheet to make simple planning decisions. In addition, you will gain practice with using formulas, applying your arithmetic skills, and learning the difference between absolute and relative cell references. Before you begin Project 1, you might want to review the following materials.
    2. Applying a Theme
      1. In Step 3, on page 52 of the text you are instructed to apply the Austin theme to the worksheet. If you have not worked with themes before, you should select a few of the other themes available to see how the font effects change. Remember that each theme also includes a unique color scheme.
    3. Enhancing Labels
      1. You need to only select the cell that a label starts in when you want to format the text in the label. You can choose to apply the formatting to cells A1 to A5 as instructed, or you might want to experiment with the various fonts, font sizes, and shaded fills and colors available.
    4. Centering Text Across Columns
      1. In step 5, on page 52 of the text, you are instructed to select cells A1 to G5 and then to center the text across columns. Refer to the Clues to Use on p. 53 of the text for more information about merging cells in a worksheet.
    5. Filling Cells
      1. In step 7, on page 52 of the text, you will use the Fill function to enter the months of the year from May to September. What are some other types of sequential data that you can automatically enter by dragging the fill handle down or across? For example, if you enter “Monday” in cell A1 and then drag the fill handle to cell G1, the remaining days of the week will appear. Remember that they can fill horizontally or vertically.
      2. If you want to enter a series of numbers, you enter the first two numbers in consecutive cells (for example, “1” and “2”) and then drag the fill handle to enter the remaining numbers. Similarly, you can enter sequences such as “5,” “10,” “15,” and so forth, by first entering “5” and “10,” and then dragging the fill handle. If time allows, experiment with the various types of sequential data that you can enter with the Fill function. For further options, click Fill in the Edit menu, and then click Series.
    6. Working with Two Worksheets
      1. In step 3, on page 54 of the text, you are instructed to name two worksheets—the current worksheet and a new worksheet. You are then instructed to display a new worksheet.The new worksheet is used to make calculations that will not appear in the worksheet when printed.
      2. By using a separate worksheet, you avoid cluttering up the original worksheet. When you want to display a value in the Budget worksheet that is from the Fees worksheet, you must include “Fees” in the cell address. Remember that an exclamation mark (!) always appears between the sheet name and the cell address. For example, if you enter “=Fees!A4” into cell A10 of the Budget worksheet, the value in cell A4 of the Fees worksheet will appear.
    7. Understanding Absolute and Relative References
      1. Be sure you understand the difference between absolute and relative references. You need to understand this concept to work successfully with a spreadsheet program. Note that an absolute reference (expressed with dollar signs) will never change, no matter where it is entered in a spreadsheet. On the other hand, a relative reference will change, depending on where it is copied in a worksheet. For example, the formula =A1*$A$4 will change to =A2*$A$4 if the formula is copied down. If the formula is copied to the right, the formula will change to =B1*$A$4. Note that you can use the F4 command to enter an absolute cell reference. That is, you can type “=B4” and then press [F4]. The =B4 reference will change to =$B$4.
      2. Refer to the Clues to Use, on page 55 of the text, to review relative and absolute references.
    8. Using Formulas
      1. As you complete the steps required for Project 1, be sure to constantly check that the formula results match the results provided. If a value does not match, be sure to check the formula carefully. Accuracy is essential when working with a spreadsheet. Remember that parentheses are required to control the order of operations in a formula.
    9. Asking What if? Questions
      1. What do you think the use of What if? questions are to the planning decisions? One of the most powerful and important uses for a spreadsheet program is to ask What if? questions. You need to see the spreadsheet as a fluid document that changes in accordance with new events that in turn necessitate new input. A budget, for example, is not a static document. Adjustments are frequently made to projected income and expenses.
    10. Formatting and Finalizing the Budget
      1. Refer to Figure C-8 ,on page 59 of the text, as you finalize the worksheet. Notice the various options available in the Page Setup dialog boxes. Note that a worksheet can be displayed in landscape or portrait format and can be centered horizontally and vertically on the page.
      2. Experiment with border styles. You will quickly learn how to use borders to give your finished spreadsheets a professional look.
    11. Extra Practice
      1. When you have completed the Budget for Project 1, list four or five What if? questions and then modify the budget to reflect the results. This additional budget should be uploaded to Edmodo. Be sure to list your What If? questions in the note in Edmodo that you are attaching the spreadsheet file. The more you work with the values in the budget to make realistic planning decisions, the more you will understand how the changes you make affect the bottom line—the projected profit.

GOAL: Before you leave today you will know how to create your own budget using Excel.

  1. In a note in Edmodo, explain the difference between absolute cell references and relative cell referencing. Explain when and how they are used. Give an example of each. Be sure to use good writing skills.
  2. Excel Unit C Independent Challenge 1PR C-My Personal Budget.xlsxYou will create your own personal budget for the next six months.Hand in both your printed budget, a description of your budget goal, and a list of the What if? questions you asked while preparing the budget. Think realistically and use the budget you create to help you manage your personal finances. When you have completed the budget, enter your “real” expenses as they occur and make adjustments to your projected expenses as required. MAKE THIS AS REALISTIC AS POSSIBLE!!!! Send me a note in Edmodo before you leave today explaining what you accomplished with your OWN budget, Challenge 1. THIS PROJECT NEEDS TO INCLUDE THE FOLLOWING:
    1. Sparklines
    2. Visually appealing formatting
    3. Merged cells
    4. Multiple sheets–at least 2–name them
    5. SUM function
    6. At least 1 absolute cell reference
    7. All dollar amounts are formatted as such
    8. Name in footer
    9. Print so it fits on 1 page
    10. 3-5 What if questions in Edmodo–attach your spreadsheet

FINISH:

  1. Excel Unit C Independent Challenge 1PR C-My Personal Budget.xlsxYou will create your own personal budget for the next six months.Hand in both your printed budget, a description of your budget goal, and a list of the What if? questions you asked while preparing the budget. Think realistically and use the budget you create to help you manage your personal finances. When you have completed the budget, enter your “real” expenses as they occur and make adjustments to your projected expenses as required. MAKE THIS AS REALISTIC AS POSSIBLE!!!! Send me a note in Edmodo before you leave today explaining what you accomplished with your OWN budget, Challenge 1. THIS PROJECT NEEDS TO INCLUDE THE FOLLOWING:
    1. Sparklines
    2. Visually appealing formatting
    3. Merged cells
    4. Multiple sheets–at least 2–name them
    5. SUM function
    6. At least 1 absolute cell reference
    7. All dollar amounts are formatted as such
    8. Name in footer
    9. Print so it fits on 1 page
    10. 3-5 What if questions in Edmodo–attach your spreadsheet
  2. START PROJECT 2–Travel Expense Report for Bright Lights Learning (page 60)–if time permits (See DAY 44 for details)

Project 2: Travel Expense Report for Bright Lights Learning

PR C-Expense Statements for Bright Lights Learning.xlsx

In Project 2, you will set up a travel expense form and then enter expenses for three employees in three separate worksheets. You will then compile all the expenses in one worksheet and format an expense report. The goal of Project 2 is to show you how you can use Excel to create a form that you can use over and over for many different participants. There are various types of forms you can create in Excel. For example, you can create an invoice form, a purchase order form, or a petty cash form.

Before you begin Project 2, review the following materials.

  1. Explore the Excel form templates you can download from Office.com—then you can see the various business applications available. To access these templates:
    1. click the File tab
    2. click New
    3. then select one of the categories listed under Office.com Templates in the Backstage View.
  2. Creating the Form
    1. You will need to spend some time completing Step 1, on page 60 of the text. In this step, you are instructed to create the worksheet shown in Figure C-10, on page 61 of the text. Remember to format the labels as shown in the callouts attached to Figure C-10.
  3. Copying and Pasting
    1. In Step 8, on page 60 of the text, you are instructed to select the entire worksheet and then copy it to two other worksheets. Do you know why you need to select the entire worksheet instead of individual cells? If you select just the cells containing the labels and values to copy and then paste the cells into a new worksheet, the adjusted column widths will revert to their default widths. The new columns widths are only maintained if the entire worksheet is selected before copying and pasting it.
  4. Calculating Expenses
    1. In the Calculate Expenses activity, on page 62 of the text, you are provided with the data you need to calculate for each of the three sales associates. If you need help with entering the correct formulas, ask me or one of your classmates. Be sure to check your results carefully against the results provided. For example, the total expenses for Abigail Wong are $1,132.15; the total expenses for Harry Martin are $897.10 (less advance) and the total expenses for Maria Sanchez are $1150.45 (less advance).
  5. Using Conditional Formatting
    1. Excel 2010 includes the new conditional formatting feature. You use this feature to apply the Traffic Lights icon set to the total expenses for each employee. This icon set provides a visual highlight of how the expenses of the three employees are related. For example, the red icon appears next to the expenses for Adam Grant because Adam’s expenses are the highest.Remember that you modify the rules associated with the conditional formatting so that the red icon appears next to the highest number. By default, the green icon appears next to the highest number.
    2. Be sure to explore some of the ways in which you can use conditional formatting to show relationships between data. Select some of the other icon sets and then explore options in the New Formatting Rule dialog box for customizing the icon sets.

FINISH:

Project 2: Travel Expense Report for Bright Lights Learning

PR C-Expense Statements for Bright Lights Learning.xlsx

In Project 2, you will set up a travel expense form and then enter expenses for three employees in three separate worksheets. You will then compile all the expenses in one worksheet and format an expense report. The goal of Project 2 is to show you how you can use Excel to create a form that you can use over and over for many different participants. There are various types of forms you can create in Excel. For example, you can create an invoice form, a purchase order form, or a petty cash form.

Before you begin Project 2, review the following materials.

  1. Explore the Excel form templates you can download from Office.com—then you can see the various business applications available. To access these templates:
    1. click the File tab
    2. click New
    3. then select one of the categories listed under Office.com Templates in the Backstage View.
  2. Creating the Form
    1. You will need to spend some time completing Step 1, on page 60 of the text. In this step, you are instructed to create the worksheet shown in Figure C-10, on page 61 of the text. Remember to format the labels as shown in the callouts attached to Figure C-10.
  3. Copying and Pasting
    1. In Step 8, on page 60 of the text, you are instructed to select the entire worksheet and then copy it to two other worksheets. Do you know why you need to select the entire worksheet instead of individual cells? If you select just the cells containing the labels and values to copy and then paste the cells into a new worksheet, the adjusted column widths will revert to their default widths. The new columns widths are only maintained if the entire worksheet is selected before copying and pasting it.
  4. Calculating Expenses
    1. In the Calculate Expenses activity, on page 62 of the text, you are provided with the data you need to calculate for each of the three sales associates. If you need help with entering the correct formulas, ask me or one of your classmates. Be sure to check your results carefully against the results provided. For example, the total expenses for Abigail Wong are $1,132.15; the total expenses for Harry Martin are $897.10 (less advance) and the total expenses for Maria Sanchez are $1150.45 (less advance).
  5. Using Conditional Formatting
    1. Excel 2010 includes the new conditional formatting feature. You use this feature to apply the Traffic Lights icon set to the total expenses for each employee. This icon set provides a visual highlight of how the expenses of the three employees are related. For example, the red icon appears next to the expenses for Adam Grant because Adam’s expenses are the highest.Remember that you modify the rules associated with the conditional formatting so that the red icon appears next to the highest number. By default, the green icon appears next to the highest number.
    2. Be sure to explore some of the ways in which you can use conditional formatting to show relationships between data. Select some of the other icon sets and then explore options in the New Formatting Rule dialog box for customizing the icon sets.

BEGIN:

Independent Challenge 2

You can do the instructions below OR you can create an expense report for Bellevue FBLA’s National Qualifiers for 2014. Use the National FBLA website to help you.

PR C-My Travel Expenses.xlsx

Create a record of travel expenses over a three-month period. Search the Internet for the appropriate prices for flights and hotels to the travel destinations you have chosen. Be sure to include four worksheets in your completed workbook—one worksheet for each of three months and one worksheet to summarize all  travel expenses. Be sure to include conditional formatting in the report.

FINISH:

Project 2: Travel Expense Report for Bright Lights Learning

PR C-Expense Statements for Bright Lights Learning.xlsx

In Project 2, you will set up a travel expense form and then enter expenses for three employees in three separate worksheets. You will then compile all the expenses in one worksheet and format an expense report. The goal of Project 2 is to show you how you can use Excel to create a form that you can use over and over for many different participants. There are various types of forms you can create in Excel. For example, you can create an invoice form, a purchase order form, or a petty cash form.

Before you begin Project 2, review the following materials.

  1. Explore the Excel form templates you can download from Office.com—then you can see the various business applications available. To access these templates:
    1. click the File tab
    2. click New
    3. then select one of the categories listed under Office.com Templates in the Backstage View.
  2. Creating the Form
    1. You will need to spend some time completing Step 1, on page 60 of the text. In this step, you are instructed to create the worksheet shown in Figure C-10, on page 61 of the text. Remember to format the labels as shown in the callouts attached to Figure C-10.
  3. Copying and Pasting
    1. In Step 8, on page 60 of the text, you are instructed to select the entire worksheet and then copy it to two other worksheets. Do you know why you need to select the entire worksheet instead of individual cells? If you select just the cells containing the labels and values to copy and then paste the cells into a new worksheet, the adjusted column widths will revert to their default widths. The new columns widths are only maintained if the entire worksheet is selected before copying and pasting it.
  4. Calculating Expenses
    1. In the Calculate Expenses activity, on page 62 of the text, you are provided with the data you need to calculate for each of the three sales associates. If you need help with entering the correct formulas, ask me or one of your classmates. Be sure to check your results carefully against the results provided. For example, the total expenses for Abigail Wong are $1,132.15; the total expenses for Harry Martin are $897.10 (less advance) and the total expenses for Maria Sanchez are $1150.45 (less advance).
  5. Using Conditional Formatting
    1. Excel 2010 includes the new conditional formatting feature. You use this feature to apply the Traffic Lights icon set to the total expenses for each employee. This icon set provides a visual highlight of how the expenses of the three employees are related. For example, the red icon appears next to the expenses for Adam Grant because Adam’s expenses are the highest.Remember that you modify the rules associated with the conditional formatting so that the red icon appears next to the highest number. By default, the green icon appears next to the highest number.
    2. Be sure to explore some of the ways in which you can use conditional formatting to show relationships between data. Select some of the other icon sets and then explore options in the New Formatting Rule dialog box for customizing the icon sets.

BEGIN:

Independent Challenge 2

You can do the instructions below OR you can create an expense report for Bellevue FBLA’s National Qualifiers for 2014. Use the National FBLA website to help you.

PR C-My Travel Expenses.xlsx

Create a record of travel expenses over a three-month period. Search the Internet for the appropriate prices for flights and hotels to the travel destinations you have chosen. Be sure to include four worksheets in your completed workbook—one worksheet for each of three months and one worksheet to summarize all  travel expenses. Be sure to include conditional formatting in the report.

Excel Certification Exam

Integrating Word & Excel
Activities 1.1 to 1.5
DO NOT PRINT

Integrating Word & Excel
Skills Review 1, 2, 3
Share all with me through Google Drive

Excel Objective Test

Excel Hands On Test

Project 1: Five-Page Proposal for Lakeview College–SHOW ME–5 points

  1. Creating the Header and Footer. What You Need To Know:
    1. How to insert a header with the document name & the current date
    2. How to insert a footer that includes your name at the left margin and the current page number at the right margin
    3. In a later project you will be modifying the header and footer—you will insert a cover page that contains no header and footer and a table of contents page that contains no header and a different style of page number in the footer. EXPERIMENT with this project to see if you can do this!!!
    4. Review the use of headers and footers to provide signpost information on each page of a multiple-page document. This information generally includes the title of the document, the author’s name, and the page number. Because of the time-sensitive nature of the proposal for Project 1, the current date is also included. For a lengthy document, it is helpful to use one of the formats that indicate the current page number as well as the total number of pages in the document, i.e. Page 2 of 24.
  2. Setting up the Document. What You Need To Know:
    1. You will select the Perspective style set and the Slipstream color scheme.
    2. Modify the Heading 1 and Heading 2 styles associated with the style set.
    3. Do you know why you first create the three pages of the proposal text (in the first three activities) and then create the table of contents page and the cover page (in the final activity of this project)?
  3. Creating a New Style. What You Need To Know:
    1. Before typing text for the proposal, starting on page 28 of the text, you will create a new style for the proposal text. All text formatted with the new style (called Proposal Text) will be indented .5″ with 1.5 spacing between lines and 12-point spacing between paragraphs.
  4. Entering Footnotes. What You Need To Know:
    1. In Step 7, on page 28 of the text, you will insert the first footnote required for the proposal.Footnotes are automatically renumbered when a specific footnote is removed.
    2. You need to know how to remove a footnote—by selecting the footnote number in the text, then pressing [Delete].
  5. Formatting Footnotes
    1. You will modify the style associated with the footnote text by first checking the formatting in the Reveal Formatting task pane.
    2. You need to know how to use the Style Inspector and Reveal Formatting task pane to determine what style is applied to text when the style is not shown in the Style gallery. EXPERIMENT!!
  6. Drawing the Rounded Rectangle
    1. In Step 8, on page 30 of the text, you are instructed to draw a rounded rectangle.
    2. You will select “No Fill” when they want to make a shape transparent.
    3. You use the mouse to adjust the size and position of the rounded rectangle so that it encloses the table as shown in Figure B-4, on page 31.
    4. The adjustment process can require some time.
  7. Creating the SmartArt Diagram
    1. On page 3 of the proposal text, you will insert a SmartArt Diverging Radial diagram that consists of one central circle and five perimeter circles. Experiment with some of the different ways you can display the SmartArt diagram (for example, by selecting other SmartArt styles from the SmartArt Styles group), before selecting the Inset SmartArt style and the Colorful – Accent Colors color scheme as directed in Step 5, on page 32 of the text.
  8. Generating the Table of Contents
    1. In Step 3, on page 34 of the text, you will generate a table of contents.
    2. The table of contents contains all the headings in the text that were formatted in a heading style.
    3. Note that heading styles must be used in a multiple-page document if a table of contents is required.
    4. The table of contents will be automatically updated if a section of the proposal is removed. In addition, the numbering of headings subsequent to the deleted section will be automatically updated.
  9. Modifying Page Numbering Styles
    1. Carefully follow the instructions in Steps 4 to 8, on page 34 of the text, and then check that an i appears on the table of contents page and a 1 appears on page 1 of the proposal text.
    2. This is typical: numbering preliminary materials, such as a table of contents page, an Executive Summary, etc., in lowercase Roman numerals and the text of a report or proposal in regular numerals.
    3. Do you know how to use the Link to Previous button?
    4. Deselect the Link to Previous button when you want to ensure that the contents of a header or a footer are not the same as the contents of the header or footer in the previous section.
  10. Creating the Cover Page
    1. In Step 9, on page 34 of the text, you will insert a Cover Pages using the Austin style, then enter text in content controls.
    2. Be sure you know the purpose of content controls and how to delete any content control you do not need.
    3. Be sure to view the other cover page styles available. Note that not all cover page styles use the same content controls.
  11. Finalizing the Proposal
    1. Make any spacing adjustments in Whole Page view to ensure that the proposal appears attractively formatted over five pages before printing it.

Independent Challenge 1–Send to me in a note in Edmodo–This should be for our school.

READ THE INSTRUCTIONS!!

Send #1-3 to me in a note in Edmodo

This project will be graded by me AND it will be given to Mr. Meyer!!!

Project 1: Five-Page Proposal for Lakeview College–SHOW ME–5 points

  1. Creating the Header and Footer. What You Need To Know:
    1. How to insert a header with the document name & the current date
    2. How to insert a footer that includes your name at the left margin and the current page number at the right margin
    3. In a later project you will be modifying the header and footer—you will insert a cover page that contains no header and footer and a table of contents page that contains no header and a different style of page number in the footer. EXPERIMENT with this project to see if you can do this!!!
    4. Review the use of headers and footers to provide signpost information on each page of a multiple-page document. This information generally includes the title of the document, the author’s name, and the page number. Because of the time-sensitive nature of the proposal for Project 1, the current date is also included. For a lengthy document, it is helpful to use one of the formats that indicate the current page number as well as the total number of pages in the document, i.e. Page 2 of 24.
  2. Setting up the Document. What You Need To Know:
    1. You will select the Perspective style set and the Slipstream color scheme.
    2. Modify the Heading 1 and Heading 2 styles associated with the style set.
    3. Do you know why you first create the three pages of the proposal text (in the first three activities) and then create the table of contents page and the cover page (in the final activity of this project)?
  3. Creating a New Style. What You Need To Know:
    1. Before typing text for the proposal, starting on page 28 of the text, you will create a new style for the proposal text. All text formatted with the new style (called Proposal Text) will be indented .5″ with 1.5 spacing between lines and 12-point spacing between paragraphs.
  4. Entering Footnotes. What You Need To Know:
    1. In Step 7, on page 28 of the text, you will insert the first footnote required for the proposal.Footnotes are automatically renumbered when a specific footnote is removed.
    2. You need to know how to remove a footnote—by selecting the footnote number in the text, then pressing [Delete].
  5. Formatting Footnotes
    1. You will modify the style associated with the footnote text by first checking the formatting in the Reveal Formatting task pane.
    2. You need to know how to use the Style Inspector and Reveal Formatting task pane to determine what style is applied to text when the style is not shown in the Style gallery. EXPERIMENT!!
  6. Drawing the Rounded Rectangle
    1. In Step 8, on page 30 of the text, you are instructed to draw a rounded rectangle.
    2. You will select “No Fill” when they want to make a shape transparent.
    3. You use the mouse to adjust the size and position of the rounded rectangle so that it encloses the table as shown in Figure B-4, on page 31.
    4. The adjustment process can require some time.
  7. Creating the SmartArt Diagram
    1. On page 3 of the proposal text, you will insert a SmartArt Diverging Radial diagram that consists of one central circle and five perimeter circles. Experiment with some of the different ways you can display the SmartArt diagram (for example, by selecting other SmartArt styles from the SmartArt Styles group), before selecting the Inset SmartArt style and the Colorful – Accent Colors color scheme as directed in Step 5, on page 32 of the text.
  8. Generating the Table of Contents
    1. In Step 3, on page 34 of the text, you will generate a table of contents.
    2. The table of contents contains all the headings in the text that were formatted in a heading style.
    3. Note that heading styles must be used in a multiple-page document if a table of contents is required.
    4. The table of contents will be automatically updated if a section of the proposal is removed. In addition, the numbering of headings subsequent to the deleted section will be automatically updated.
  9. Modifying Page Numbering Styles
    1. Carefully follow the instructions in Steps 4 to 8, on page 34 of the text, and then check that an i appears on the table of contents page and a 1 appears on page 1 of the proposal text.
    2. This is typical: numbering preliminary materials, such as a table of contents page, an Executive Summary, etc., in lowercase Roman numerals and the text of a report or proposal in regular numerals.
    3. Do you know how to use the Link to Previous button?
    4. Deselect the Link to Previous button when you want to ensure that the contents of a header or a footer are not the same as the contents of the header or footer in the previous section.
  10. Creating the Cover Page
    1. In Step 9, on page 34 of the text, you will insert a Cover Pages using the Austin style, then enter text in content controls.
    2. Be sure you know the purpose of content controls and how to delete any content control you do not need.
    3. Be sure to view the other cover page styles available. Note that not all cover page styles use the same content controls.
  11. Finalizing the Proposal
    1. Make any spacing adjustments in Whole Page view to ensure that the proposal appears attractively formatted over five pages before printing it.

 

GOAL: Before you leave today you will begin applying what you learned about font styles and business proposal by creating a proposal for our school.

READ THE INSTRUCTIONS!!

Share #1-3 to me in our class Google Group

This project will be graded by me AND it will be given to Mr. Meyer!!!

GOAL: Apply what you have learned about how to write a proposal and what you have learned about applying styles.

Independent Challenge 1–This project will be graded by me AND it will be given to Mr. Meyer!!! Make sure it is well written!! We are fortunate to have an open-minded principal. If this proposal is well written, it could possibly be considered! Take advantage of this opportunity!

You and your partner will need to gather primary and secondary data. Suggestions:

  1. Create a form using Google Docs to gather primary data–send it to teachers, parents, community members, & students (primary data is powerful data!!!)
  2. Gather secondary data–find out how other school districts handle this situation–I am willing to set up a Google Hangout with another school–I am looking into this–please let me know if you have any suggestions. Find 3 different school districts.
  3. NUMBERS–get realistic prices/numbers/percentages for all of your claims.
  4. DO NOT RELY ON ONE WEBSITE/SCHOOL FOR ALL YOUR INFORMATION!!!
  5. Communicate with your partner through your Google Doc ONLY–you may use the comments!!
  6. You will be graded on what you accomplish today. (I can see what you do & your comments in your Google Doc)

 

DO THIS FIRST TODAY–GOOGLE GROUP POST: PROPOSAL GRADING RUBRIC

GOAL: Apply what you have learned about how to write a proposal and what you have learned about applying styles.

FINISH RESEARCHING TODAY

Independent Challenge 1–This project will be graded by me AND it will be given to Mr. Meyer!!! Make sure it is well written!! We are fortunate to have an open-minded principal. If this proposal is well written, it could possibly be considered! Take advantage of this opportunity!

Suggestions:

  1. Include SmartArt FUNCTIONALLY and describe it using a caption.
  2. Include Paragraph Shading & Underlining
  3. lnclude a title page
  4. Include a table of contents page
  5. Include a Works Cited/Bibliograph page with all your sources
  6. Include your primary data in the body of the report
  7. Include your secondary data in the body of the report
  8. NUMBERS–get realistic prices/numbers/percentages for all of your claims.
  9. Cite all your sources
  10. Communicate with your partner through your Google Doc ONLY–you may use the comments!!

GOAL: Apply what you have learned about how to write a proposal and what you have learned about applying styles.

BEGIN WRITING THE PROPOSAL TODAY IN WORD

Independent Challenge 1–This project will be graded by me AND it will be given to Mr. Meyer!!! Make sure it is well written!! We are fortunate to have an open-minded principal. If this proposal is well written, it could possibly be considered! Take advantage of this opportunity!

  1. Include SmartArt FUNCTIONALLY and describe it using a caption.
  2. Include Paragraph Shading & Underlining
  3. lnclude a title page
  4. Include a table of contents page
  5. Include a Works Cited/Bibliograph page with all your sources
  6. Include your primary data in the body of the report
  7. Include your secondary data in the body of the report
  8. NUMBERS–get realistic prices/numbers/percentages for all of your claims.
  9. Cite all your sources
  10. Communicate with your partner through your Google Doc ONLY–you may use the comments!!

FINISH THE PROPOSAL TODAY

Independent Challenge 1–This project will be graded by me AND it will be given to Mr. Meyer!!! Make sure it is well written!! We are fortunate to have an open-minded principal. If this proposal is well written, it could possibly be considered! Take advantage of this opportunity!

  1. Include SmartArt FUNCTIONALLY and describe it using a caption.
  2. Include Paragraph Shading & Underlining
  3. lnclude a title page
  4. Include a table of contents page
  5. Include a Works Cited/Bibliograph page with all your sources
  6. Include your primary data in the body of the report
  7. Include your secondary data in the body of the report
  8. NUMBERS–get realistic prices/numbers/percentages for all of your claims.
  9. Cite all your sources
  10. Communicate with your partner through your Google Doc ONLY–you may use the comments!!

 

FINISH THE PROPOSAL TODAY

Independent Challenge 1–This project will be graded by me AND it will be given to Mr. Meyer!!! Make sure it is well written!! We are fortunate to have an open-minded principal. If this proposal is well written, it could possibly be considered! Take advantage of this opportunity!

  1. Include SmartArt FUNCTIONALLY and describe it using a caption.
  2. Include Paragraph Shading & Underlining
  3. lnclude a title page
  4. Include a table of contents page
  5. Include a Works Cited/Bibliograph page with all your sources
  6. Include your primary data in the body of the report
  7. Include your secondary data in the body of the report
  8. NUMBERS–get realistic prices/numbers/percentages for all of your claims.
  9. Cite all your sources
  10. Communicate with your partner through your Google Doc ONLY–you may use the comments!!

 

FINISH THE PROPOSAL TODAY

Independent Challenge 1–This project will be graded by me AND it will be given to Mr. Meyer!!! Make sure it is well written!! We are fortunate to have an open-minded principal. If this proposal is well written, it could possibly be considered! Take advantage of this opportunity!

  1. Include SmartArt FUNCTIONALLY and describe it using a caption.
  2. Include Paragraph Shading & Underlining
  3. lnclude a title page
  4. Include a table of contents page
  5. Include a Works Cited/Bibliograph page with all your sources
  6. Include your primary data in the body of the report
  7. Include your secondary data in the body of the report
  8. NUMBERS–get realistic prices/numbers/percentages for all of your claims.
  9. Cite all your sources
  10. Communicate with your partner through your Google Doc ONLY–you may use the comments!!

 

FINISH THE PROPOSAL TODAY

Independent Challenge 1–This project will be graded by me AND it will be given to Mr. Meyer!!! Make sure it is well written!! We are fortunate to have an open-minded principal. If this proposal is well written, it could possibly be considered! Take advantage of this opportunity!

  1. Include SmartArt FUNCTIONALLY and describe it using a caption.
  2. Include Paragraph Shading & Underlining
  3. lnclude a title page
  4. Include a table of contents page
  5. Include a Works Cited/Bibliograph page with all your sources
  6. Include your primary data in the body of the report
  7. Include your secondary data in the body of the report
  8. NUMBERS–get realistic prices/numbers/percentages for all of your claims.
  9. Cite all your sources
  10. Communicate with your partner through your Google Doc ONLY–you may use the comments!!

 

FINISH THE PROPOSAL TODAY

Independent Challenge 1–This project will be graded by me AND it will be given to Mr. Meyer!!! Make sure it is well written!! We are fortunate to have an open-minded principal. If this proposal is well written, it could possibly be considered! Take advantage of this opportunity!

  1. Include SmartArt FUNCTIONALLY and describe it using a caption.
  2. Include Paragraph Shading & Underlining
  3. lnclude a title page
  4. Include a table of contents page
  5. Include a Works Cited/Bibliograph page with all your sources
  6. Include your primary data in the body of the report
  7. Include your secondary data in the body of the report
  8. NUMBERS–get realistic prices/numbers/percentages for all of your claims.
  9. Cite all your sources
  10. Communicate with your partner through your Google Doc ONLY–you may use the comments!!

 

FINISH THE PROPOSAL TODAY

Independent Challenge 1–This project will be graded by me AND it will be given to Mr. Meyer!!! Make sure it is well written!! We are fortunate to have an open-minded principal. If this proposal is well written, it could possibly be considered! Take advantage of this opportunity!

  1. Include SmartArt FUNCTIONALLY and describe it using a caption.
  2. Include Paragraph Shading & Underlining
  3. lnclude a title page
  4. Include a table of contents page
  5. Include a Works Cited/Bibliograph page with all your sources
  6. Include your primary data in the body of the report
  7. Include your secondary data in the body of the report
  8. NUMBERS–get realistic prices/numbers/percentages for all of your claims.
  9. Cite all your sources
  10. Communicate with your partner through your Google Doc ONLY–you may use the comments!!

 

FINISH THE PROPOSAL TODAY

Independent Challenge 1–This project will be graded by me AND it will be given to Mr. Meyer!!! Make sure it is well written!! We are fortunate to have an open-minded principal. If this proposal is well written, it could possibly be considered! Take advantage of this opportunity!

  1. Include SmartArt FUNCTIONALLY and describe it using a caption.
  2. Include Paragraph Shading & Underlining
  3. lnclude a title page
  4. Include a table of contents page
  5. Include a Works Cited/Bibliograph page with all your sources
  6. Include your primary data in the body of the report
  7. Include your secondary data in the body of the report
  8. NUMBERS–get realistic prices/numbers/percentages for all of your claims.
  9. Cite all your sources
  10. Communicate with your partner through your Google Doc ONLY–you may use the comments!!

 

FINISH THE PROPOSAL TODAY

Independent Challenge 1–This project will be graded by me AND it will be given to Mr. Meyer!!! Make sure it is well written!! We are fortunate to have an open-minded principal. If this proposal is well written, it could possibly be considered! Take advantage of this opportunity!

  1. Include SmartArt FUNCTIONALLY and describe it using a caption.
  2. Include Paragraph Shading & Underlining
  3. lnclude a title page
  4. Include a table of contents page
  5. Include a Works Cited/Bibliograph page with all your sources
  6. Include your primary data in the body of the report
  7. Include your secondary data in the body of the report
  8. NUMBERS–get realistic prices/numbers/percentages for all of your claims.
  9. Cite all your sources
  10. Communicate with your partner through your Google Doc ONLY–you may use the comments!!

 

FINISH THE PROPOSAL TODAY

Independent Challenge 1–This project will be graded by me AND it will be given to Mr. Meyer!!! Make sure it is well written!! We are fortunate to have an open-minded principal. If this proposal is well written, it could possibly be considered! Take advantage of this opportunity!

  1. Include SmartArt FUNCTIONALLY and describe it using a caption.
  2. Include Paragraph Shading & Underlining
  3. lnclude a title page
  4. Include a table of contents page
  5. Include a Works Cited/Bibliograph page with all your sources
  6. Include your primary data in the body of the report
  7. Include your secondary data in the body of the report
  8. NUMBERS–get realistic prices/numbers/percentages for all of your claims.
  9. Cite all your sources
  10. Communicate with your partner through your Google Doc ONLY–you may use the comments!!

 

FINISH THE PROPOSAL TODAY

Independent Challenge 1–This project will be graded by me AND it will be given to Mr. Meyer!!! Make sure it is well written!! We are fortunate to have an open-minded principal. If this proposal is well written, it could possibly be considered! Take advantage of this opportunity!

  1. Include SmartArt FUNCTIONALLY and describe it using a caption.
  2. Include Paragraph Shading & Underlining
  3. lnclude a title page
  4. Include a table of contents page
  5. Include a Works Cited/Bibliograph page with all your sources
  6. Include your primary data in the body of the report
  7. Include your secondary data in the body of the report
  8. NUMBERS–get realistic prices/numbers/percentages for all of your claims.
  9. Cite all your sources
  10. Communicate with your partner through your Google Doc ONLY–you may use the comments!!

 

FINISH THE PROPOSAL TODAY

Independent Challenge 1–This project will be graded by me AND it will be given to Mr. Meyer!!! Make sure it is well written!! We are fortunate to have an open-minded principal. If this proposal is well written, it could possibly be considered! Take advantage of this opportunity!

  1. Include SmartArt FUNCTIONALLY and describe it using a caption.
  2. Include Paragraph Shading & Underlining
  3. lnclude a title page
  4. Include a table of contents page
  5. Include a Works Cited/Bibliograph page with all your sources
  6. Include your primary data in the body of the report
  7. Include your secondary data in the body of the report
  8. NUMBERS–get realistic prices/numbers/percentages for all of your claims.
  9. Cite all your sources
  10. Communicate with your partner through your Google Doc ONLY–you may use the comments!!

 

FINISH THE PROPOSAL TODAY

Independent Challenge 1–This project will be graded by me AND it will be given to Mr. Meyer!!! Make sure it is well written!! We are fortunate to have an open-minded principal. If this proposal is well written, it could possibly be considered! Take advantage of this opportunity!

  1. Include SmartArt FUNCTIONALLY and describe it using a caption.
  2. Include Paragraph Shading & Underlining
  3. lnclude a title page
  4. Include a table of contents page
  5. Include a Works Cited/Bibliograph page with all your sources
  6. Include your primary data in the body of the report
  7. Include your secondary data in the body of the report
  8. NUMBERS–get realistic prices/numbers/percentages for all of your claims.
  9. Cite all your sources
  10. Communicate with your partner through your Google Doc ONLY–you may use the comments!!

MEN’S VBALL

 

START: Project 2: Six-Panel Brochure for French Country Tours: The goal of Project 2 is to show you how you can use the columns feature to create a multiple-column brochure in landscape orientation. Hopefully, you will enjoy creating the brochure and seeing how to apply the skills you learned to create a variety of document types. Before you begin Project 2,  READ THE FOLLOWING!!!

  1. Understanding the Brochure Layout
    1. Try this first: Fold a blank piece of paper into a six-column brochure and then number the six panels. By so doing, notice that the panel 6 of the brochure contains the text and graphics for the front cover of the brochure and is formatted last as the third column on the second page.
  2. Creating the Header and Footer
    1. Display a blank document in landscape orientation and then create a header and footer.
    2. Select the Different First Page option in the Page Setup dialog box so that the header and footer you create will appear only on panels 1, 2, and 3 (page 1) of the brochure.
    3. Draw a line for the header.
    4. Remember: You must press and hold [Shift] as you drag the mouse so the line is kept straight.
  3. Creating Page 1 of the Brochure
    1. Page 1 of the document contains panels 1, 2, and 3 of the completed brochure.
    2. These panels form the inside of the brochure when it is opened.
    3. For the French Country Tours brochure, panels 2 and 3 are combined into one panel.
    4. You can choose to retain all three columns on page 1 of the brochure that you will create yourself for Independent Challenge 2.
  4. Inserting and Modifying Drop Caps
    1. In Step 8, on page 38 of the text, you create a drop cap to begin each of the six paragraphs in the “Moments to Remember” section.
    2. Experiment with various ways in which you can use drop caps to enhance a document. For example, you can modify the number of lines the drop cap is “dropped”, change the font of the drop cap, and modify the spacing between the drop cap and the text that follows.
  5. Working with WordArt
    1. In Step 7, on page 40 of the text, you insert a WordArt object and then format it with one of the preset gradient fills.
    2. If you have not used gradient fills before, view the various options available and experiment with different looks.

FINISH: Project 2: Six-Panel Brochure for French Country Tours: The goal of Project 2 is to show you how you can use the columns feature to create a multiple-column brochure in landscape orientation. Hopefully, you will enjoy creating the brochure and seeing how to apply the skills you learned to create a variety of document types. Before you begin Project 2,  READ THE FOLLOWING!!!

  1. Understanding the Brochure Layout
    1. Try this first: Fold a blank piece of paper into a six-column brochure and then number the six panels. By so doing, notice that the panel 6 of the brochure contains the text and graphics for the front cover of the brochure and is formatted last as the third column on the second page.
  2. Creating the Header and Footer
    1. Display a blank document in landscape orientation and then create a header and footer.
    2. Select the Different First Page option in the Page Setup dialog box so that the header and footer you create will appear only on panels 1, 2, and 3 (page 1) of the brochure.
    3. Draw a line for the header.
    4. Remember: You must press and hold [Shift] as you drag the mouse so the line is kept straight.
  3. Creating Page 1 of the Brochure
    1. Page 1 of the document contains panels 1, 2, and 3 of the completed brochure.
    2. These panels form the inside of the brochure when it is opened.
    3. For the French Country Tours brochure, panels 2 and 3 are combined into one panel.
    4. You can choose to retain all three columns on page 1 of the brochure that you will create yourself for Independent Challenge 2.
  4. Inserting and Modifying Drop Caps
    1. In Step 8, on page 38 of the text, you create a drop cap to begin each of the six paragraphs in the “Moments to Remember” section.
    2. Experiment with various ways in which you can use drop caps to enhance a document. For example, you can modify the number of lines the drop cap is “dropped”, change the font of the drop cap, and modify the spacing between the drop cap and the text that follows.
  5. Working with WordArt
    1. In Step 7, on page 40 of the text, you insert a WordArt object and then format it with one of the preset gradient fills.
    2. If you have not used gradient fills before, view the various options available and experiment with different looks.

BEGIN: Independent Challenge 2–This can be a fictitious company/business that you may wish to own someday or it can be for an existing business. You choose! You could make one for the FBLA Coffee Shop OR you could make one for the Bellevue Community School District that could be placed on the counter in the superintendent’s office and the main offices at the elementary and middle/high school. Suggestions:

  1. Make the document 3 columns to begin with!!!
  2. Do the column & page breaks LAST!!!

GOAL: Before you leave today you will have the opportunity to apply what you have learned about creating 6 panel brochures using Word 2010.

FINISH: Independent Challenge 2–This can be a fictitious company/business that you may wish to own someday or it can be for an existing business. You choose! You could make one for the FBLA Coffee Shop OR you could make one for the Bellevue Community School District that could be placed on the counter in the superintendent’s office and the main offices at the elementary and middle/high school. Suggestions:

  1. Make the document 3 columns to begin with!!!
  2. Do the column & page breaks LAST!!!
  3. PRINT on BOTH sides!!!

BEGIN: Work on Independent Challenge 4 Suggestions:

  1. Make the document 3 columns to begin with!!!
  2. Do the column & page breaks LAST!!!
  3. Show me when you are done.

GOAL: Before you leave today you will have the opportunity to apply what you have learned about creating 6 panel brochures using Word 2010.

FINISH: Independent Challenge 2–This can be a fictitious company/business that you may wish to own someday or it can be for an existing business. You choose! You could make one for the FBLA Coffee Shop OR you could make one for the Bellevue Community School District that could be placed on the counter in the superintendent’s office and the main offices at the elementary and middle/high school. Suggestions:

  1. Make the document 3 columns to begin with!!!
  2. Do the column & page breaks LAST!!!
  3. PRINT on BOTH sides!!!

FINISH: Independent Challenge 2–This can be a fictitious company/business that you may wish to own someday or it can be for an existing business. You choose! You could make one for the FBLA Coffee Shop OR you could make one for the Bellevue Community School District that could be placed on the counter in the superintendent’s office and the main offices at the elementary and middle/high school. Suggestions:

  1. Make the document 3 columns to begin with!!!
  2. Do the column & page breaks LAST!!!
  3. PRINT on BOTH sides!!!

BEGIN: Work on Independent Challenge 4 Suggestions:

  1. Make the document 3 columns to begin with!!!
  2. Do the column & page breaks LAST!!!
  3. Show me when you are done.

Finish Independent Challenge 4: SUGGESTION:

  1. Make the document 3 columns to begin with!!!
  2. Do the column & page breaks LAST!!!
  3. Show me when you are done.

BEGIN: Project 3: One-Page Resume for Ian Robinson

The goal of Project 3 is to encourage you to take advantage of timesaving features, such as tables and styles to create a simple one-page resume. You can use the resume for Ian Robinson as a template for your own resume that you will create for Independent Challenge 3. Before you begin Project 3, you might want to review the following materials.

Table Form

Notice how the resume is made using table form instead of tabs to create the two-column resume. A table form is more efficient than tabs because it allows you to change you mind regarding the size of the two columns. If you require more space for the date column, for example, you can easily increase the size of column 1 in the table form. Be thinking of other ways in which you can use the table form to simplify common formatting tasks.

Modifying Styles

In Step 2, on page 42 of the text, you are asked to modify the Heading 1 style without instruction. Remember to: right-click Heading 1 in the Styles gallery, click Modify, select the new settings, then click OK.

FINISH: Project 3: One-Page Resume for Ian Robinson–Upload it to Edmodo

The goal of Project 3 is to encourage you to take advantage of timesaving features, such as tables and styles to create a simple one-page resume. You can use the resume for Ian Robinson as a template for your own resume that you will create for Independent Challenge 3. Before you begin Project 3, you might want to review the following materials.

Table Form

Notice how the resume is made using table form instead of tabs to create the two-column resume. A table form is more efficient than tabs because it allows you to change you mind regarding the size of the two columns. If you require more space for the date column, for example, you can easily increase the size of column 1 in the table form. Be thinking of other ways in which you can use the table form to simplify common formatting tasks.

Modifying Styles

In Step 2, on page 42 of the text, you are asked to modify the Heading 1 style without instruction. Remember to: right-click Heading 1 in the Styles gallery, click Modify, select the new settings, then click OK.

BEGIN: Independent Challenge 3–Print–THIS NEEDS TO BE ERROR FREE!!

#1-4–READ!!! This is to help you gather information to include in your resume–you will be expected to include everything in #1-4 in YOUR resume!!

#5–READ & DO!!!

You will print this when you are done, but I want to see it on your screen also to be sure you did everything from #5!!!

FINISH: Independent Challenge 3–Print

GOAL: Before you leave class today you will have the opportunity to apply your advanced word processing knowledge to real life tasks.

Visual Workshop–Turn in through Edmodo

EXTRA Project 1–THIS IS FOR A TEST/PROJECT GRADE!!!!

Art Festival Proposal.docx

You work for Miami Innovations, an art gallery in Miami, Florida. The gallery has decided to team up with two other Miami galleries and several community arts organizations to hold an art festival. The proposal for the festival has been written. Now you need to format the proposal attractively for distribution to the various galleries and arts organizations involved in the art festival. Follow the steps below to create and format the proposal for the Miami Art Festival.

  1. Type and enhance “Table of Contents.” The title should be centered and formatted with bold and a large font size.
  2. Save the document as PR B-Art Festival Proposal.docx.
  3. Insert a new page, then type the indented, italicized text shown below. Do not indent or italicize the text in your document. Make sure you format single lines of text with the Heading 1 or Heading 2 styles where indicated. Hint: Just type the text for the headings not the directions “Heading 1” or “Heading 2”. You also need to create a table where shown.

Introduction (Heading 1)

This proposal discusses plans to organize the Miami Art Festival for the citizens of Miami and South Florida. Three galleries, including the Miami Innovations Gallery, will participate in the festival, along with several public art galleries and non-profit organizations. The purpose of the Miami Art Festival is to celebrate our local artists and to encourage an interest visual art by making the galleries open and accessible in a festive atmosphere. Events will be held throughout the week, culminating in a Celebrity Art Auction and Grand Paint-a-long on the final day.

The report will cover three issues with regard to the organization of the Miami Art Festival: Gallery Information, Festival Events, and Proposed Schedule.

Gallery Information (Heading 1)

Following is information about each of the three private galleries committed to participating in the Miami Art Festival.

Miami Innovations Gallery (Heading 2)

Founded in 1998, the Miami Innovations Gallery has developed a solid reputation for its commitment to artists producing primarily abstract and landscape art in the modernist tradition. With at least 4000 square feet of space is available for both solo and group exhibitions, the Miami Innovations Gallery is one of Miami’s largest private galleries.

South Florida Fine Arts (Heading 2)

Maria Ramirez opened Portland South Florida Fine Arts in 2001 and has succeeded in developing the careers of an enthusiastic collection of young artists. One of Maria’s star artists, Luis Rodriguez, recently received the prestigious Miami Artist of the Year award. The South Florida Fine Arts gallery is committed to showcasing the work of artists under 40 during the Miami Art Festival.

Swaying Palms Galleria (Heading 2)

Miami’s oldest private art gallery can trace its roots back to the post-war boom in the 1950’s when Miami was just emerging as a force to be reckoned with. Tiffany Price, the owner of the Swaying Palms Galleria, will be hosting the Celebrity Art Auction that closes the Miami Art Festival.

Festival Events (Heading 1)

Events will be held throughout the week, culminating in a Celebrity Art Auction and Grand Paint-a-long on the final day.

Event Location
Children’s Art Fair Swaying Palms Galleria
Celebrity Art Auction Swaying Palms Galleria
Paint-a-long Miami Innovations
Gallery Artists Shows All Galleries
Juried Art Competition Miami Innovations
Lantern Parade 3 Block radius of “Gallery Row” in Miami
Merchant Window Displays Storefronts throughout downtown Miami
Art Raffle South Florida Fine Arts
Art Supplies Fair Miami Community Arts Center

Festival Dates (Heading 1)

The Miami Art Festival kicks off on Saturday, March 30, 2013 with fully catered openings at all three of the participating art galleries. Following the openings, the artists and art lovers like can participate in the lantern parade, which winds through the streets of downtown Miami. On Sunday, March 31, the children’s art fair and art supplies fair welcomes families and art enthusiasts. The Juried Community Art Show also opens, featuring the winners of the competition. Submissions to the juried show must be made prior to March 1, 2013.

From Monday to Thursday, each participating gallery will hold a series of artist and curator talks. These events promise to be very simulating!

On Friday, March 29, the grand Paint-a-long at Miami Innovations promises to be a wild event! Gallery artists put own their painting overalls and paint to the music of local bands. The results are auctioned off at the end of the evening.

The Miami Art Festival ends with the Celebrity Art Auction on Saturday, April 28 at the Swaying Palms Galleria.

  1. Change the Color Scheme to Origin.
  2. Modify the Heading 1 style so that the text is formatted with Brown, Accent 5, Darker 50%, 15-point, bold, and Calibri.
  3. Modify the Heading 2 style so that the text is formatted with Brown, Accent 5, Darker 25%, 14-point, Calibri, Arial, Bold, and Italics.
  4. In the Festival Events section of the proposal, apply the Light List – Accent 5 table design to the table, then click the Total Row check box in the Table Style Options group to deselect it.
  5. Insert a new blank page at the beginning of the document, then create a Cover page using the Titles style.
  6. Type text for the title page of the proposal as shown below:

Company Name: Miami Innovations Gallery

Document Title: Proposal for Miami Art Festival

Subtitle: Delete

Year: 2013

Company Address: 800 Palm Drive, Miami, FL 33120

  1. Generate a table of contents on page 2 of the proposal.
  2. Create a header that starts on the first page of the text (e.g., page 3). The header should contain the text “Miami Art Festival” and your name.
  3. Create a footer that starts on the table of contents page and includes Page i.
  4. For the footer on page 1 of the text, change the starting page number to “1”.
  5. Update the table of contents, then save and show your teacher the document.

Cover Page and Table of Contents Page

Extra Project 1B Title Page & Table of Contents

Page 1 and 2 of the document

Extra Project 1B Pages 1 & 2 of the Report

 

 

FINISH: EXTRA Project 1–THIS IS FOR A TEST/PROJECT GRADE!!!! (this is from last class)

EXTRA Project 2–TEST/PROJECT GRADE

June 19 Menu for Olivero’s Bistro.docx

You’ve just opened a new restaurant and have decided to serve a different menu every day so that you can always serve the freshest food available from your local market. To save money on printing costs, you’ve decided to create a menu on the computer, make changes to the document daily, and then print only the number of copies you need for your customers each day. Follow the steps required to create the menu for Wednesday, June 19, 2013, as shown on the following page, and then create a menu for a restaurant of your choice.

  1. Modify the Normal style to change the font to Garamond and 12 point with After spacing of 0.
  2. Modify the Heading 1 style to change the font to Garamond and 16 point, the font color to Olive Green, Accent 3, Darker 50%, and t he Before spacing to 12 pt.
  3. Save the document as June 19 Menu for Olivero’s Bistro.docx.
  4. Create Olivero’s Bistro as a WordArt object.
  5. Fill the WordArt shape with the Brown Marble texture or a texture of your choice.
  6. Size and position the WordArt as shown in the sample menu.
  7. Insert the clip art pictures shown in the completed menu.
  8. Insert two copies of the top image, and flip one so that it faces the other direction.
  9. Size and position the clip art pictures as shown.
  10. Type Menu for June 19, 20103, press [Enter], select the text, apply Heading 1, then center it.
  11. Below the heading, insert a table containing 2 columns and 14 rows.
  12. Widen column 1 to 3.25 on the ruler bar and decrease column 2 to 5.0 on the ruler bar.
  13. Enter just the text as shown in the sample menu. Note that each line of the menu appears in a separate row in the table.
  14. Merge the menu category rows into one cell each. Apply Heading 1 to the menu categories.
  15. Right-align the prices entered in column 2.
  16. Check the appearance of the menu in One Page view, make any spacing adjustments required, then save the document.
  17. Raise you hand to show your teacher.

Completed menu

Extra Project 2B Menu

FRUIT SALES FORM–Get a copy of the form from Mrs. Weber. Create a GOOGLE FORM so people can order fruit online.

Goal: Today you will have the opportunity to create a form for our Athletic Department to use for fruit sales.

RETRO ASSIGNMENT: Create a Google form that can be linked from our district website that will allow people to place their fruit order online. Here are the requirements:

  1. Required Field:
    1. First Name
    2. Last Name
    3. Address
    4. City
    5. State
    6. Zip
    7. Telephone Number
  2. Fields for each fruit box with the price
    1. See overhead
  3. Field that calculates the total cost
  4. All orders are final on December 2
  5. All orders must be paid for and picked up on December 13 or December 14
  6. Checks should be payable to Bellevue High School
  7. On the back side of the form (the spreadsheet form):
    1. calculate the total for each order
    2. make sure to spreadsheet can be print on 1 piece of paper
  8. When you are finished, send the form to yourself and make changes if needed.
  9. Once it complete, send the form to tracyweber@bellevue.k12.ia.us and davidwright@bellevue.k12.ia.us

FRUIT SALES FORM–Get a copy of the form from Mrs. Weber. Create a GOOGLE FORM so people can order fruit online.

Goal: Today you will have the opportunity to create a form for our Athletic Department to use for fruit sales.

RETRO ASSIGNMENT: Create a Google form that can be linked from our district website that will allow people to place their fruit order online. Here are the requirements:

  1. Required Field:
    1. First Name
    2. Last Name
    3. Address
    4. City
    5. State
    6. Zip
    7. Telephone Number
  2. Fields for each fruit box with the price
    1. See overhead
  3. Field that calculates the total cost
  4. All orders are final on December 2
  5. All orders must be paid for and picked up on December 13 or December 14
  6. Checks should be payable to Bellevue High School
  7. On the back side of the form (the spreadsheet form):
    1. calculate the total for each order
    2. make sure to spreadsheet can be print on 1 piece of paper
  8. HINT: A NUMBER (no words at all) needs to be returned in the spreadsheet in order to make calculations & experiment with ALL the different types of questions you can create in a form.
  9. When you are finished, send the form to yourself and make changes if needed.
  10. Once it complete, send the form to tracyweber@bellevue.k12.ia.us and davidwright@bellevue.k12.ia.us

FINISH TODAY!!

FRUIT SALES FORM–Get a copy of the form from Mrs. Weber. Create a GOOGLE FORM so people can order fruit online.

Goal: Today you will have the opportunity to create a form for our Athletic Department to use for fruit sales.

RETRO ASSIGNMENT: Create a Google form that can be linked from our district website that will allow people to place their fruit order online. Here are the requirements:

  1. Required Field:
    1. First Name
    2. Last Name
    3. Address
    4. City
    5. State
    6. Zip
    7. Telephone Number
  2. Fields for each fruit box with the price
    1. See overhead
  3. Field that calculates the total cost
  4. All orders are final on December 2
  5. All orders must be paid for and picked up on December 13 or December 14
  6. Checks should be payable to Bellevue High School
  7. On the back side of the form (the spreadsheet form):
    1. calculate the total for each order
    2. make sure to spreadsheet can be print on 1 piece of paper
  8. HINT: A NUMBER (no words at all) needs to be returned in the spreadsheet in order to make calculations & experiment with ALL the different types of questions you can create in a form.
  9. When you are finished, send the form to yourself and make changes if needed.
  10. Once it complete, send the form to tracyweber@bellevue.k12.ia.us and davidwright@bellevue.k12.ia.us
  11. WRITING FOR TODAY: NOTE TO ME IN EDMODO: What did you accomplish today? How did class go? What do you still need to do? What questions do you have? 3-5 sentence paragraph
  12. Check JMC & turn in any missing zeros.

FINISH Independent Challenge 2–Submit through Edmodo

You can do the instructions below OR you can create an expense report for Bellevue FBLA’s National Qualifiers for 2014. Use the National FBLA website to help you.

PR C-My Travel Expenses.xlsx

Create a record of travel expenses over a three-month period. Search the Internet for the appropriate prices for flights and hotels to the travel destinations you have chosen. Be sure to include four worksheets in your completed workbook—one worksheet for each of three months and one worksheet to summarize all  travel expenses. Be sure to include conditional formatting in the report.

BEGIN: Project 3: Planning Budget for a European Vacation

PR C-European Trip Budget.xlsx

The goal of Project 3 is for students to determine the formulas required to solve the problem of taking a trip to Europe for under $5,000. Be sure to progress slowly and to check your totals against the totals provided. If errors are found, you will need to think carefully about the formulas. The process required to complete Project 3 encourages problem-solving skills. You will need to add new rows to complete the budget.

The completion of this project you should develop an understanding of how changing expenses affects the total cost of the vacation and you will have the opportunity to develop your problem-solving skills. Illustrated below is a sample vacation budget.

advappsday55_clip_image002

 

WRITING FOR TODAY: NOTE TO ME IN EDMODO: What did you accomplish today? How did class go? What do you still need to do? What questions do you have? 3-5 sentence paragraph

CHECK IT OUT: https://docs.google.com/a/bellevue.k12.ia.us/spreadsheet/viewform?usp=drive_web&formkey=dDRJQWlqbnA4ZFpGTjlIT0JHMUhKN1E6MQ#gid=0

Independent Challenge 3

PR C-My Vacation Budget.xls

Create a planning budget for a vacation of your choice. Set a realistic budget and include the appropriate expense categories (accommodations, food, sightseeing, and so forth). Have fun with it! By the completion of this project you should develop an understanding of how changing expenses affects the total cost of the vacation and you will have the opportunity to develop your problem-solving skills. Illustrated below is a sample vacation budget.

advappsday55_clip_image002

 

BE SURE TO APPLY THE FOLLOWING:

  1. Absolute cell referencing–with meaning to it!!
  2. Conditional formatting
  3. Sparkline
  4. Multiple sheets
  5. Tie multiple sheets together using a formula

Independent Challenge 3 PR C-My Vacation Budget.xls Create a planning budget for a vacation of your choice. Set a realistic budget and include the appropriate expense categories (accommodations, food, sightseeing, and so forth). Have fun with it! By the completion of this project you should develop an understanding of how changing expenses affects the total cost of the vacation and you will have the opportunity to develop your problem-solving skills. Illustrated below is a sample vacation budget. advappsday55_clip_image002   BE SURE TO APPLY THE FOLLOWING:

  1. Absolute cell referencing–with meaning to it!!
  2. Conditional formatting
  3. Sparkline
  4. Multiple sheets
  5. Tie multiple sheets together using a formula
  1. COMPLETE THESE SURVEYS FIRST TODAY:
    1. Student Learning Styles Survey
    2. Student Information Survey

FINISH: Independent Challenge 3 PR C-My Vacation Budget.xls Create a planning budget for a vacation of your choice. Set a realistic budget and include the appropriate expense categories (accommodations, food, sightseeing, and so forth). Have fun with it! By the completion of this project you should develop an understanding of how changing expenses affects the total cost of the vacation and you will have the opportunity to develop your problem-solving skills. Illustrated below is a sample vacation budget. advappsday55_clip_image002   BE SURE TO APPLY THE FOLLOWING:

  1. Absolute cell referencing–with meaning to it!!
  2. Conditional formatting
  3. Sparkline
  4. Multiple sheets
  5. Tie multiple sheets together using a formula

BEGIN: Independent Challenge 4 PR-C Canada Trip Budget.xlsx Create the worksheet illustrated in Figure C-21, on page 72 of the text, and then use the Web query feature to calculate exchange rates for Canadian dollars. Shown below is a sample solution file. advappsday56_clip_image002advappsday56_clip_image004

Verizon App Idea Contest

GOAL: Before you leave today you will:

  1. WORKING IN A GROUP TIPS
  2. APP IDEA DEVELOPMENT GRADING RUBRIC
  3. Get into teams of 5-7
  4. You will brainstorm and think of 1 idea
  5. Create a plan for next class.
  6. RESOURCES TO USE

GOAL: Before you leave today your group needs to have completed the essay or the video clip.

Before beginning today, READ the following:

  1. APP IDEA DEVELOPMENT GRADING RUBRIC
  2. TIPS FROM THE JUDGES
  3. RESOURCES TO USE
  4. ESSAY TIPS
  5. VIDEO PRESENTATION TIPS

Verizon App Idea Contest

GOAL: Before you leave today your group needs to have completed the essay or the video clip. Before beginning today, READ the following:

  1. APP IDEA DEVELOPMENT GRADING RUBRIC
  2. TIPS FROM THE JUDGES
  3. RESOURCES TO USE
  4. ESSAY TIPS
  5. VIDEO PRESENTATION TIPS

Verizon App Idea Contest

FINISH THE APP GOAL: Before you leave today your group needs to have completed the essay or the video clip. Before beginning today, READ the following:

  1. APP IDEA DEVELOPMENT GRADING RUBRIC
  2. TIPS FROM THE JUDGES
  3. RESOURCES TO USE
  4. ESSAY TIPS
  5. VIDEO PRESENTATION TIPS

Verizon App Idea Contest

 

EXTRA Project 1TEST GRADE Marathon Investments Party Budget.xlsx You are responsible for planning the annual staff party at JMP Associates, Inc., in Los Angeles. The company employs 100 people and proposes a budget of $9,000 for the party, which is usually held during the winter holiday season. You will first create a budget based on the quotes you have received from various suppliers and then you will work to reduce the expenses so that they meet the $9,000 budget. Follow the steps required to create the budget shown in the following and then to answer the questions provided.

  1. Select the Clarity theme, then set up a worksheet so that it appears as shown below. Note that the fill color in row 1 and the bottom border color for row 4 is Green.

advappsday58_clip_image002

  1. Multiply the Unit Cost by the Number to determine the total expense for each item, and then calculate the total expenses ($11,584.00). You need to cut $2,1584.00 from the current budget.
  2. Answer the What if? questions listed in the following. Compare the total expenses after each question.

 

#

Questions

Total Expenses

1. What if you held the party on the company premises instead of at the Seaview Hotel, thereby incurring only $300 for extra cleaning costs.
3. What if you hired a DJ instead of a band at a cost of $200?
5. What if you designated ten employees to make table decorations at a cost of $5.00 per table for materials?
6. What if you provided a simpler dinner at a per person cost of $65?
7. What if you decreased the gift costs to $14 per person?
  1. Save the worksheet as PR-C JMP Party Budget.xlsx.
  2. Format cell E13 with the Single Top and Double Bottom line style and bold, format the worksheet for printing by centering the worksheet horizontally and adding “JMP Associates Staff Party and the left side of the header, your name at the right side, and the filename centered in the footer. Change the orientation to landscape.
  3. Submit the workbook to your instructor.
  4. A completed party budget appears below. Check that the Catering cost is $65.00 per person for total expenses of $8992.00.

advappsday58_clip_image004   EXTRA Project 1TEST GRADE Marathon Investments Party Budget.xlsx You are responsible for planning the annual staff party at JMP Associates, Inc., in Los Angeles. The company employs 100 people and proposes a budget of $9,000 for the party, which is usually held during the winter holiday season. You will first create a budget based on the quotes you have received from various suppliers and then you will work to reduce the expenses so that they meet the $9,000 budget. Follow the steps required to create the budget shown in the following and then to answer the questions provided.

  1. Select the Clarity theme, then set up a worksheet so that it appears as shown below. Note that the fill color in row 1 and the bottom border color for row 4 is Green.

advappsday58_clip_image002

  1. Multiply the Unit Cost by the Number to determine the total expense for each item, and then calculate the total expenses ($11,584.00). You need to cut $2,1584.00 from the current budget.
  2. Answer the What if? questions listed in the following. Compare the total expenses after each question.

 

#

Questions

Total Expenses

1. What if you held the party on the company premises instead of at the Seaview Hotel, thereby incurring only $300 for extra cleaning costs.
3. What if you hired a DJ instead of a band at a cost of $200?
5. What if you designated ten employees to make table decorations at a cost of $5.00 per table for materials?
6. What if you provided a simpler dinner at a per person cost of $65?
7. What if you decreased the gift costs to $14 per person?
  1. Save the worksheet as PR-C JMP Party Budget.xlsx.
  2. Format cell E13 with the Single Top and Double Bottom line style and bold, format the worksheet for printing by centering the worksheet horizontally and adding “JMP Associates Staff Party and the left side of the header, your name at the right side, and the filename centered in the footer. Change the orientation to landscape.
  3. Submit the workbook to your instructor.
  4. A completed party budget appears below. Check that the Catering cost is $65.00 per person for total expenses of $8992.00.
  • advappsday58_clip_image004

EXTRA Project 2–TEST GRADE Six-Month Budget for Ocean Quest Wildlife Tours.xlsx You have been asked to prepare a six-month budget for Ocean Quest Wildlife Tours, a small tour company based in Sitka, Alaska. The budget covers the six months of the company’s summer season—when the cruise ships anchor in the bay and passengers purchase Ocean Quest Wildlife Tours as an excursion. You will first create the budget and then you will make the calculations required.

  1. Select the Module theme, then set up the worksheet so that it appears as shown below. You choose the fill color you prefer for rows 1 and 3.

advappsday59_clip_image002

  1. Save the workbook as Six-Month Budget for Ocean Quest Wildlife Tours.xlsx.
  2. Calculate the tour sales for each month based on the following information: $75 per tour cost, 700 tours sold in May and October, 1,500 tours sold in the remaining months.
  3. Calculate the refunds as 9% of the tour sales in each month.
  4. Calculate the total sales for each month (subtract the refunds from the sales), and then calculate the totals required for cells H5 to H8.
  5. Calculate the fuel costs (20% of the Total Sales in each month).
  6. Calculate the total expenses in row 18 and column H.
  7. Calculate the total profit, and then ensure that the total profit in cell H20 is $326,140.00.
  8. Answer the following five What if? questions:

 

# Questions
1. What if you sold 2,000 tours in July and 2,500 tours in August?
2. What if you hired two more guides in July and August at an additional cost of $4,000 each month?
3. What if you increased your advertising budget in May and June to $7,000 each month?
4. What if you purchased a new boat in June at a cost of $150,000, thereby increasing your boat maintenance costs to $1,500 from July to October? Note that you will need to add a row for the boat purchase.
5. What if you increase the tour price to $80 starting in July?
  1. Check that your total profit is $268,228.00.
  2. Format the worksheet attractively for printing in landscape orientation, and then print a copy.

The completed budget appears below. Check that you format your completed budget attractively, center it horizontally and vertically on one page, and add appropriate border lines. Landscape orientation. advappsday59_clip_image004

FINISH Independent Challenge 4 PR-C Canada Trip Budget.xlsx Create the worksheet illustrated in Figure C-21, on page 72 of the text, and then use the Web query feature to calculate exchange rates for Canadian dollars. Shown below is a sample solution file. advappsday56_clip_image002advappsday56_clip_image004

Visual Workshop PR-C Home on the Web Budget.xlsx The completed budget with answers should appear as shown below. advappsday57_clip_image002

MAKE UP WORK–CHECK JMC & TURN IN ALL ZEROS!!

GOAL: Before you leave today you will have a topic chosen for you semester final project and you will begin conducting research on your topic.

Visual Workshop PR-C Home on the Web Budget.xlsx The completed budget with answers should appear as shown below. advappsday57_clip_image002

Excel and Word Integrated Hands On Exam–HERE IS HOW YOU WILL BE GRADED

Word/Excel Hands On Exam. Choose from one of the following (or choose a topic of your own that compares and contrasts something meaningful to you):

  • Name Brand Vs. Off Brand Products
  • Cost Vs. Benefits of a New Bellevue Public Pool
  • Cost Vs. Benefits of Alternatives Forms of Energy for Bellevue

Exam Requirements:

  • Conduct Internet Research on your topic.
  • Create an Excel Spreadsheet and Chart (optional) to illustrate your findings.
  • Create a written proposal in Word to send to interested parties regarding your findings and your suggested course of action.
  • Prepare your presentation. You may use PowerPoint/Prezi or whatever means you choose to convey your findings to the class. We will treat this as a professional presentation. Be sure to review the Presentation Grading Rubric. You will be graded on your presentation separately.
  • Project Presentations–Be sure to provide your teacher with:
    • your printed report & spreadsheet(s), and chart(s) (optional).
    • ALSO TURN IN YOUR PROJECT GRADING RUBRIC AND YOUR PRESENTATION GRADING RUBRIC.
  • You may use ANYTHING at your disposal to help you–EXCEPT–NOT EACH OTHER!!

**Put yourself in the position of the person who will approve or disapprove your recommendation. Try to knock their socks off with your findings.

GOAL: Before you leave today you will start your  proposal and spreadsheet. You will finish it next class.

Exam Requirements:

  • Conduct Internet Research on your topic.
  • Create an Excel Spreadsheet and Chart (optional) to illustrate your findings.
  • Create a written proposal in Word to send to interested parties regarding your findings and your suggested course of action.
  • Prepare your presentation. You may use PowerPoint/Prezi or whatever means you choose to convey your findings to the class. We will treat this as a professional presentation. Be sure to review the Presentation Grading Rubric. You will be graded on your presentation separately.
  • Project Presentations–Be sure to provide your teacher with:
    • your printed report & spreadsheet(s), and chart(s) (optional).
    • ALSO TURN IN YOUR PROJECT GRADING RUBRIC AND YOUR PRESENTATION GRADING RUBRIC.
  • You may use ANYTHING at your disposal to help you–EXCEPT–NOT EACH OTHER!!

How you will be graded: Excel and Word Integrated Hands On Exam–HERE IS HOW YOU WILL BE GRADED

**Put yourself in the position of the person who will approve or disapprove your recommendation. Try to knock their socks off with your findings.

GOAL: Before you leave today you will FINISH your proposal and spreadsheet. Be sure EVERYTHING is formatted properly. Check the grading rubric.

Exam Requirements:

  • Finish conducting Internet Research on your topic.
  • FINISH creating an Excel Spreadsheet and Chart (optional) to illustrate your findings.
  • FINISH creating a written proposal in Word to send to interested parties regarding your findings and your suggested course of action.
  • You may use ANYTHING at your disposal to help you–EXCEPT–NOT EACH OTHER!!
  • Prepare your presentation. You may use PowerPoint/Prezi or whatever means you choose to convey your findings to the class. We will treat this as a professional presentation. Be sure to review the Presentation Grading Rubric. You will be graded on your presentation separately.
  • Project Presentations–Be sure to provide your teacher with:
    • your printed report & spreadsheet(s), and chart(s) (optional).
    • ALSO TURN IN YOUR PROJECT GRADING RUBRIC AND YOUR PRESENTATION GRADING RUBRIC.

How you will be graded: Excel and Word Integrated Hands On Exam–HERE IS HOW YOU WILL BE GRADED

**Put yourself in the position of the person who will approve or disapprove your recommendation. Try to knock their socks off with your findings.

GOAL: Finish the project and prepare to present your project to the class next class.

Excel and Word Integrated Hands On Exam–HERE IS HOW YOU WILL BE GRADED

  • Also remember the following:
  • Today you will prepare your presentation. You may use PowerPoint/Prezi or whatever means you choose to convey your findings to the class. We will treat this as a professional presentation. Be sure to review the Presentation Grading Rubric. You will be graded on your presentation separately.
  • Project Presentations–Be sure to provide your teacher with:
    • your printed report, letter & envelope, spreadsheet(s), and chart(s).
    • ALSO TURN IN YOUR PROJECT GRADING RUBRIC AND YOUR PRESENTATION GRADING RUBRIC.

GOAL: FINISH FIRST SEMESTER

  1. Please complete the Teacher/Course Evaluation
  2. In a note to me in Edmodo, write a course description for this course. Write it so that students will want to take the course. Be sure to include what you learned this semester.
  3. FINISH:
    1. Excel and Word Integrated Hands On Exam–HERE IS HOW YOU WILL BE GRADED
      • Also remember the following:
      • Today you will prepare your presentation. You may use PowerPoint/Prezi or whatever means you choose to convey your findings to the class. We will treat this as a professional presentation. Be sure to review the Presentation Grading Rubric. You will be graded on your presentation separately.
      • Project Presentations–Be sure to provide your teacher with:
        • your printed report, letter & envelope, spreadsheet(s), and chart(s).
        • ALSO TURN IN YOUR PROJECT GRADING RUBRIC AND YOUR PRESENTATION GRADING RUBRIC.

Pick one skill that you learned this semester and create a how-to video clip. You have today and next class to finish it. Use the following websites:

  1. For screen recording: www.screenr.com
  2. For voice recording: www.vocaroo.com
  3. Here are some suggested topics::
    1. Term Paper
      1. Headers/Footers
      2. Adding and editing citations
      3. Manage sources
      4. Works Cited
      5. Cover page
      6. Table of contents
    2. Business Card and Letterhead
      1. Symbols
      2. WordArt
      3. Clipart: rotation and cropping
      4. Labels
      5. Clip art edits
      6. Paragraph formatting
      7. Headers/Footers
    3. Brochure
      1. Shapes (lines)
      2. Margins
      3. Page orientation
      4. clip art in footer
      5. columns
      6. drop caps
      7. styles
      8. artistic effects
      9. picture wrapping
      10. borders
    4. Budget
      1. Worksheet setup and formatting
      2. sheet tabs
      3. themes
      4. copying formulas
      5. autofill
      6. absolute and relative values
      7. sparklines
    5. Expense Report
      1. autosum
      2. enter formulas
      3. format values
      4. border lines
      5. sheet references
      6. conditional formatting
      7. row height
      8. custom width
      9. custom margins

Pick one skill that you learned this semester and create a how-to video clip. Today is the last day. You will present it next class. Use the following websites:

  1. For screen recording: www.screenr.com
  2. For voice recording: www.vocaroo.com
  3. Here are some suggested topics::
    1. Term Paper
      1. Headers/Footers
      2. Adding and editing citations
      3. Manage sources
      4. Works Cited
      5. Cover page
      6. Table of contents
    2. Business Card and Letterhead
      1. Symbols
      2. WordArt
      3. Clipart: rotation and cropping
      4. Labels
      5. Clip art edits
      6. Paragraph formatting
      7. Headers/Footers
    3. Brochure
      1. Shapes (lines)
      2. Margins
      3. Page orientation
      4. clip art in footer
      5. columns
      6. drop caps
      7. styles
      8. artistic effects
      9. picture wrapping
      10. borders
    4. Budget
      1. Worksheet setup and formatting
      2. sheet tabs
      3. themes
      4. copying formulas
      5. autofill
      6. absolute and relative values
      7. sparklines
    5. Expense Report
      1. autosum
      2. enter formulas
      3. format values
      4. border lines
      5. sheet references
      6. conditional formatting
      7. row height
      8. custom width
      9. custom margins

BEGIN FIRST SEMESTER FINAL EXAM Create a 3 panel brochure in Word that promotes the business classes at BHS. Include a spreasheet.

  1. Present your video clip–send it to me in a note in edmodo
  2. FIRST SEMESTER FINAL EXAM
  3. Create a 3 panel brochure in Word that promotes the business classes at BHS. Include a spreasheet.
  4. TipCam–experiment!!! You will pick a topic out of the Word unit. You will present your video to the class as the final for first semester.
  5. IMPORTANT!!!! This will allow you to show your clip to the class on the front computer and make your file more portable.
    1. Go to OPTIONS in the TipCam box (the middle button on the bottom)
    2. Click the BASIC tab
    3. In the SAVE RECORDED TIPS IN THIS FOLDER click browse and go to YOUR DRIVE and click OK!!!
    4. Click the RECORDING tab
    5. Under FILE FORMAT choose AVI
    6. Click OK
  6. Complete your TipCam project. Present next class.
  1. In order to upload your movie YouTube (you can access from ANY computer with internet access):
    1. Go to OPTIONS in the TipCam box (the middle button on the bottom)
    2. Click the BASIC tab
    3. In the SAVE RECORDED TIPS IN THIS FOLDER click browse and go to the uTipu folder in the My Videos folder located in the My Documents folder and click OK!!!
    4. Click the RECORDING tab
    5. Under FILE FORMAT choose FLV
    6. Click OK
    7. In Internet Explorer go to YouTube and log in to your account. Choose to Upload a movie and navigate to your uTipu folder in the My Videos folder of the My Documents folder. Be sure to make it an unlisted or private movie. (Here is an example)
  2. In order to make your movie portable (to be placed on a flash drive or moved from one location to another). YOU SHOULD ONLY DO THIS WHEN YOU ARE COMPLETELY DONE WITH THE MOVIE–THIS INCLUDES BEING DONE WITH THE VOICE OVER:
    1. Go to OPTIONS in the TipCam box (the middle button on the bottom)
    2. Click the BASIC tab
    3. In the SAVE RECORDED TIPS IN THIS FOLDER click browse and go to YOUR DRIVE and click OK!!!
    4. Click the RECORDING tab
    5. Under FILE FORMAT choose AVI
    6. Click OK
    7. In Internet Explorer go to YouTube and log in to your account. Choose to Upload a movie and navigate to your uTipu folder in the My Videos folder of the My Documents folder. Be sure to make it an unlisted or private movie. (Here is an example)
  3. Present TipCam projects
  4. Create your own blog–log in to your Google Account–click on More–Even More–In your blog, create a blog post telling me about what topic you think you will focus your ScreenToaster video on from Word Section 4. Describe why and how you think you will do it. Share your blog post with me. (tweber@bellevue.k12.ia.us)
  1. DO THIS FIRST TODAY: Right now, we will practice Mail Merge a little more. Do the following: (you will have until the end of next class to complete this project.)
    1. You are Santa Claus! You are unable to WRITE individual letters to each child this year because you have developed carpel tunnel syndrome! One of your elves showed you how to use mail merge in Word 2007, so you have decided to use it to help you compete your letters this year! What a great idea! Here is what you have decided to do:
      1. Create a form letter that greets the children (paragraph 1), let’s them know you have been watching them (paragraph 2), and then let’s them know what they will be getting for Christmas (paragraph 3). You want the letter to be as personable as possible, so you will enter a <field> in each paragraph that will contain information specifically for each child (examples may include: paragraph 1–a field for the child’s first name or nickname, paragraph 2–a field that says you think they are nice, exeception, great, etc., and paragraph 3–a field that states some toys you plan to bring–just tell them you will TRY, don’t promise anything! Decorate the letter with clipart, etc. Be creative in design & wording!
      2. Create a database for each child.
      3. Create an envelope for the letter. Be sure to include fields!
      4. Merge the letter & envelope with the database.
      5. HINT: When doing mail merge, work left to right in the Mailings ribbon!!!!
      6. Show me when you are done!

    Santa Letters–Begin this project as a mail merge, you can edit the individual letters AFTER you do a final merge.

EXTRA CREDIT: Show your parents this lesson plan and have them visit this part of my website:

  1. Parent Info.
  2. Resources
  3. Advanced Computer Applications web page
  4. Ask them to fill out the form on the Parent Info. page AND/OR write in the COMMENTS section of the Advanced Computer Applications web page .
  5. Ask them to tell me what they expect you to learn in this class this quarter and if they have any questions during this course, they can ask them here!

GOAL: By the completioin of Project 1: Sales Forecast for Central Green Consulting, you will know how to use the Scenario Manager in Excel and you will know why it is important to know.

WATCH THIS FIRST: http://www.youtube.com/watch?v=B6grOpt-yxw

Project 1: Sales Forecast for Central Green Consulting

PR-D Central Green Consulting Sales Forecasts.xlsx

In Project 1, you will set up a Revenue and Expenses worksheet for Central Green Consulting, and then create three groups of scenarios—Current scenarios, Best Case scenarios, and Worst Case scenarios. The goal of Project 1 is to introduce you to using the Scenario Manager to make predictions. The Best Case scenarios contain figures that reflect the projected income and expenses, should the move to a commercial office building and the hiring of new staff result in high sales. The Worst Case scenarios contain figures that reflect the projected income and expenses should the move and hiring result in poor sales. Before you begin Project 1, you might want to review the following materials.

Understanding Scenarios

Each set of scenarios contains different figures, depending on the situation. The Current scenarios contain the figures for the current income and expenses, the Best Case scenarios contain projected figures based on an assumption of a high sales increase, and the Worst Case scenarios contain projected figures based on an assumption of low sales. Be sure to study Figures D-8 and D-9, on page 83 of the text, before they start the project. Take note that the column chart changes between the two printouts, depending on the active scenarios. The projected income for the Best Case scenarios, for example, far exceeds the projected income for the Worst Case scenarios.

Be sure that you understand that both of the printouts displayed are, in fact, printouts of the same worksheet, but with different scenarios activated.

Setting Up the Worksheet

In Step 1, on page 76 of the text, enter the labels and values shown in Figure D-1 on page 77 of the text. Be sure to carefully check the values you enter in cells B6 through G6 (the Revenue section) against Figure D-1. If a value is entered incorrectly, you will not achieve the required results.

You can save time by entering the values required for cells B13 to B16 in the Expenses section, then selecting cells B13 to B16 and dragging the fill handle across to cell G17 to enter the expenses for the remaining months.

Calculating Totals

In steps 2 through 5, on page 76 of the text, you are instructed to use formulas and the Sum function leading to the calculation of the total net profit in cell H18.

Remember that when calculating a percent, use the correct decimal point placement. For instance, in cell B15 the formula is =B8*0.6 because they are multiplying by 60%.

Creating Scenarios

You will create a total of 12 scenarios in the project as follows:

Current Scenarios

Best Case Scenarios

Worst Case Scenarios

Current Sales Best Case Sales Worst Case Sales
Current Salaries Best Case Salaries Worst Case Salaries
Current Rent Best Case Rent Worst Case Rent
Current Operating Costs Best Case Operating Costs Worst Case Operating Costs

As you create the scenarios required, be sure to check each total carefully to verify that you have entered the correct values for each scenario. As each scenario is activated, the total net profit in cell H18 changes.

Changing the Value Axis Scale

In Step 5 on page 82 of the text, you are instructed to change the scale of the value access (Y-axis) so that the maximum value is 3000. What is the purpose of this step?—to ensure that each version of the chart uses the same scale. If the maximum value of the Y-axis is not changed, each version of the chart could display a different set of values on the Y-axis. As a result, the various versions of the chart would not show obvious differences—thereby diminishing the impact of the changes that result from applying each set of scenarios.

Mixing and Matching Scenarios

After you have completed the project and printed the required scenarios, experiment by “mixing and matching” various combinations of scenarios to determine a variety of options. For example, what is the net income if sales remain current and the company pays the Worst Case Salaries and the Best Case rent and the Best Case Operating Costs?

  1. PRINT AS INSTRUCTED AND SHOW ME!
  2. Send me a note in Edmodo addressing the following: Think about the Scenario Manager. What is another way a person could compare situations? Is using Scenario Manager better? Explain.

Project 1: Sales Forecast for Central Green Consulting

PR-D Central Green Consulting Sales Forecasts.xlsx

In Project 1, you will set up a Revenue and Expenses worksheet for Central Green Consulting, and then create three groups of scenarios—Current scenarios, Best Case scenarios, and Worst Case scenarios. The goal of Project 1 is to introduce you to using the Scenario Manager to make predictions. The Best Case scenarios contain figures that reflect the projected income and expenses, should the move to a commercial office building and the hiring of new staff result in high sales. The Worst Case scenarios contain figures that reflect the projected income and expenses should the move and hiring result in poor sales. Before you begin Project 1, you might want to review the following materials.

Understanding Scenarios

Each set of scenarios contains different figures, depending on the situation. The Current scenarios contain the figures for the current income and expenses, the Best Case scenarios contain projected figures based on an assumption of a high sales increase, and the Worst Case scenarios contain projected figures based on an assumption of low sales. Be sure to study Figures D-8 and D-9, on page 83 of the text, before they start the project. Take note that the column chart changes between the two printouts, depending on the active scenarios. The projected income for the Best Case scenarios, for example, far exceeds the projected income for the Worst Case scenarios.

Be sure that you understand that both of the printouts displayed are, in fact, printouts of the same worksheet, but with different scenarios activated.

Setting Up the Worksheet

In Step 1, on page 76 of the text, enter the labels and values shown in Figure D-1 on page 77 of the text. Be sure to carefully check the values you enter in cells B6 through G6 (the Revenue section) against Figure D-1. If a value is entered incorrectly, you will not achieve the required results.

You can save time by entering the values required for cells B13 to B16 in the Expenses section, then selecting cells B13 to B16 and dragging the fill handle across to cell G17 to enter the expenses for the remaining months.

Calculating Totals

In steps 2 through 5, on page 76 of the text, you are instructed to use formulas and the Sum function leading to the calculation of the total net profit in cell H18.

Remember that when calculating a percent, use the correct decimal point placement. For instance, in cell B15 the formula is =B8*0.6 because they are multiplying by 60%.

Creating Scenarios

You will create a total of 12 scenarios in the project as follows:

Current Scenarios

Best Case Scenarios

Worst Case Scenarios

Current Sales Best Case Sales Worst Case Sales
Current Salaries Best Case Salaries Worst Case Salaries
Current Rent Best Case Rent Worst Case Rent
Current Operating Costs Best Case Operating Costs Worst Case Operating Costs

As you create the scenarios required, be sure to check each total carefully to verify that you have entered the correct values for each scenario. As each scenario is activated, the total net profit in cell H18 changes.

Changing the Value Axis Scale

In Step 5 on page 82 of the text, you are instructed to change the scale of the value access (Y-axis) so that the maximum value is 3000. What is the purpose of this step?—to ensure that each version of the chart uses the same scale. If the maximum value of the Y-axis is not changed, each version of the chart could display a different set of values on the Y-axis. As a result, the various versions of the chart would not show obvious differences—thereby diminishing the impact of the changes that result from applying each set of scenarios.

Mixing and Matching Scenarios

After you have completed the project and printed the required scenarios, experiment by “mixing and matching” various combinations of scenarios to determine a variety of options. For example, what is the net income if sales remain current and the company pays the Worst Case Salaries and the Best Case rent and the Best Case Operating Costs?

  1. PRINT AS INSTRUCTED AND SHOW ME!
  2. Send me a note in Edmodo addressing the following: Think about the Scenario Manager. What is another way a person could compare situations? Is using Scenario Manager better? Explain.

Independent Challenge 1 PR-D My Predictions.xlsx Create an income and expenses worksheet for a business of your choice and then use the Scenario Manager to determine the effect of a proposed expansion. If you currently work for a business, create one for them and show your boss!! EXTRA CREDIT!!! Take lots of time to determine appropriate expansion plans and then creating a realistic income and expenses statement. To save time, you could open the income and expenses statement you created for Project 1 and adapt it for your own business. When you have created the Current, Best Case, and Worst Case scenarios, ensure that you format the worksheet attractively and print each scenario in turn. Ensure that each version includes the appropriate changes to the header. To make the values related to each scenario easy to read, be sure to apply a shaded fill to the appropriate cells. Illustrated below is a sample Worst Case version of the Revenue and Expenses worksheet for Atlantis Publishing Services. New values are entered in the Copy Sales, Salaries, Rent, and Operating Cost rows. You should also print a Best Case version and a Current version of the worksheet. Be sure to change the header information and the chart title for each version. DIRECTIONS IN YOUR BOOK:

  1. #1–Send this information to me in a note in Edmodo. Use good writing skills.
  2. #8–Actually print according to the instructions in your book.
  3. #10–Actually print according to the instructions in your book.
  4. #11–Actually print according to the instructions in your book.
  5. Send me a copy of your workbook as an attachment to a note in Edmodo

advappsday67_clip_image002

Project 1: Sales Forecast for Central Green Consulting

PR-D Central Green Consulting Sales Forecasts.xlsx

In Project 1, you will set up a Revenue and Expenses worksheet for Central Green Consulting, and then create three groups of scenarios—Current scenarios, Best Case scenarios, and Worst Case scenarios. The goal of Project 1 is to introduce you to using the Scenario Manager to make predictions. The Best Case scenarios contain figures that reflect the projected income and expenses, should the move to a commercial office building and the hiring of new staff result in high sales. The Worst Case scenarios contain figures that reflect the projected income and expenses should the move and hiring result in poor sales. Before you begin Project 1, you might want to review the following materials.

Understanding Scenarios

Each set of scenarios contains different figures, depending on the situation. The Current scenarios contain the figures for the current income and expenses, the Best Case scenarios contain projected figures based on an assumption of a high sales increase, and the Worst Case scenarios contain projected figures based on an assumption of low sales. Be sure to study Figures D-8 and D-9, on page 83 of the text, before they start the project. Take note that the column chart changes between the two printouts, depending on the active scenarios. The projected income for the Best Case scenarios, for example, far exceeds the projected income for the Worst Case scenarios.

Be sure that you understand that both of the printouts displayed are, in fact, printouts of the same worksheet, but with different scenarios activated.

Setting Up the Worksheet

In Step 1, on page 76 of the text, enter the labels and values shown in Figure D-1 on page 77 of the text. Be sure to carefully check the values you enter in cells B6 through G6 (the Revenue section) against Figure D-1. If a value is entered incorrectly, you will not achieve the required results.

You can save time by entering the values required for cells B13 to B16 in the Expenses section, then selecting cells B13 to B16 and dragging the fill handle across to cell G17 to enter the expenses for the remaining months.

Calculating Totals

In steps 2 through 5, on page 76 of the text, you are instructed to use formulas and the Sum function leading to the calculation of the total net profit in cell H18.

Remember that when calculating a percent, use the correct decimal point placement. For instance, in cell B15 the formula is =B8*0.6 because they are multiplying by 60%.

Creating Scenarios

You will create a total of 12 scenarios in the project as follows:

Current Scenarios

Best Case Scenarios

Worst Case Scenarios

Current Sales Best Case Sales Worst Case Sales
Current Salaries Best Case Salaries Worst Case Salaries
Current Rent Best Case Rent Worst Case Rent
Current Operating Costs Best Case Operating Costs Worst Case Operating Costs

As you create the scenarios required, be sure to check each total carefully to verify that you have entered the correct values for each scenario. As each scenario is activated, the total net profit in cell H18 changes.

Changing the Value Axis Scale

In Step 5 on page 82 of the text, you are instructed to change the scale of the value access (Y-axis) so that the maximum value is 3000. What is the purpose of this step?—to ensure that each version of the chart uses the same scale. If the maximum value of the Y-axis is not changed, each version of the chart could display a different set of values on the Y-axis. As a result, the various versions of the chart would not show obvious differences—thereby diminishing the impact of the changes that result from applying each set of scenarios.

Mixing and Matching Scenarios

After you have completed the project and printed the required scenarios, experiment by “mixing and matching” various combinations of scenarios to determine a variety of options. For example, what is the net income if sales remain current and the company pays the Worst Case Salaries and the Best Case rent and the Best Case Operating Costs?

  1. PRINT AS INSTRUCTED AND SHOW ME!
  2. Send me a note in Edmodo addressing the following: Think about the Scenario Manager. What is another way a person could compare situations? Is using Scenario Manager better? Explain.

Independent Challenge 1 PR-D My Predictions.xlsx Create an income and expenses worksheet for a business of your choice and then use the Scenario Manager to determine the effect of a proposed expansion. If you currently work for a business, create one for them and show your boss!! EXTRA CREDIT!!! Take lots of time to determine appropriate expansion plans and then creating a realistic income and expenses statement. To save time, you could open the income and expenses statement you created for Project 1 and adapt it for your own business. When you have created the Current, Best Case, and Worst Case scenarios, ensure that you format the worksheet attractively and print each scenario in turn. Ensure that each version includes the appropriate changes to the header. To make the values related to each scenario easy to read, be sure to apply a shaded fill to the appropriate cells. Illustrated below is a sample Worst Case version of the Revenue and Expenses worksheet for Atlantis Publishing Services. New values are entered in the Copy Sales, Salaries, Rent, and Operating Cost rows. You should also print a Best Case version and a Current version of the worksheet. Be sure to change the header information and the chart title for each version. DIRECTIONS IN YOUR BOOK:

  1. #1–Send this information to me in a note in Edmodo. Use good writing skills.
  2. #8–Actually print according to the instructions in your book.
  3. #10–Actually print according to the instructions in your book.
  4. #11–Actually print according to the instructions in your book.
  5. Send me a copy of your workbook as an attachment to a note in Edmodo

advappsday67_clip_image002

 

Independent Challenge 1

PR-D My Predictions.xlsx

Create an income and expenses worksheet for a business of your choice and then use the Scenario Manager to determine the effect of a proposed expansion. If you currently work for a business, create one for them and show your boss!! EXTRA CREDIT!!! Take lots of time to determine appropriate expansion plans and then creating a realistic income and expenses statement. To save time, you could open the income and expenses statement you created for Project 1 and adapt it for your own business. When you have created the Current, Best Case, and Worst Case scenarios, ensure that you format the worksheet attractively and print each scenario in turn. Ensure that each version includes the appropriate changes to the header. To make the values related to each scenario easy to read, be sure to apply a shaded fill to the appropriate cells.

Illustrated below is a sample Worst Case version of the Revenue and Expenses worksheet for Atlantis Publishing Services. New values are entered in the Copy Sales, Salaries, Rent, and Operating Cost rows. You should also print a Best Case version and a Current version of the worksheet. Be sure to change the header information and the chart title for each version.

DIRECTIONS IN YOUR BOOK:

  1. #1–Send this information to me in a note in Edmodo. Use good writing skills.
  2. #8–Actually print according to the instructions in your book.
  3. #10–Actually print according to the instructions in your book.
  4. #11–Actually print according to the instructions in your book.
  5. Send me a copy of your workbook as an attachment to a note in Edmodo

advappsday67_clip_image002

 

Before you start this project, send me a note in Edmodo explain order of operation. Explain this formula to me: =(b4+c4+d4+e4)/($b$20+$c$20+$d$20+$e$20)*$j$20

Project 2: Course Grades Analysis for Psychology 200

PR-D Course Grades Analysis.xlsx

In Project 2, you will set up a grades worksheet for Psychology 200, calculate the grades earned by each of the students enrolled in the course, and then create a Subtotals list that counts the number of students who earned each grade (for example, A, B, and so forth). You will then display the data from the Subtotals list in a pie chart. The goal of Project 2 is to show you how they can use the Subtotals function to analyze data entered in a worksheet and then display this data in chart form. You will also learn how to use the Lookup function to match values entered in a lookup table with the appropriate values entered in a worksheet. Before you begin Project 2, you might want to review the following topics.

Setting Up the Worksheet

Be sure to carefully check the values enter enter in the worksheet against the values entered in Figure D-10, on page 85 of the text. If a value is entered incorrectly, you will not achieve the required results.

Understanding Weighted Values

Review the concept of weighted values, as calculated in Steps 2 through 7 on page 84 of the text. Make sure that the total points a student earns in any given category (for example, 60 points for Assignments) are divided by the total points possible (for example, 80 points for Assignments) and then multiplied by the weighted score (for example, 50 points for Assignments). The resulting value represents the student’s weighted score for the category.

This method of weighting scores enables instructors to total the weighted scores to calculate the number of points out of 100 that each student earns. This number of points (for example, 87) represents a grade of 87% for the course. A lookup table is then used to assign a letter grade to the student (for example, B+ if the percentage is greater than or equal to 87% and less then 90%).

Calculating Totals

In Steps 2 through 6, on page 84 of the text, you are instructed to enter a formula to calculate the total points earned by the first student on the list (Michael Banks) and then to copy the formula for the remaining students in the class. Note the use of [F4] to insert dollar signs ($) in the formula so that the references to cells in rows 20 and 21 are absolute. Make sure you understand that these references must be absolute so that the total assignment score earned by each student is divided only by the values in row 21.

Entering the Lookup Formula

In Steps 1 through 3, on page 86 of the text, use the Lookup function to calculate the letter grade earned by each student in the class. Here are the tasks performed by the Lookup function:

  1. Searches the ranges in a lookup table
  2. Finds the range that includes the value in a designated cell (for example, cell M5)
  3. Enters the values for that range (for example, A-)

You can use the Lookup function for other purposes. For example, you can create a list of products in Sheet1 and then create a lookup table in Sheet2 that contains a price list. The Lookup function can then be used to enter a specific price, depending on the product entered in a specific cell in Sheet 1.

Note that array refers to the range of cells that contains the lookup table (cells A2 to B12 in the Lookup sheet).

Creating a Subtotals List

What is the purpose of the Subtotals list?—to display the number of times each letter grade appears in column M. Be sure that you compare your collapsed Subtotals list against Figure D-14, on page 87 of the text, to ensure that the correct breakdown of grades is achieved.

Creating the Pie Chart

You will create a pie chart from the Subtotals list when it is collapsed to level 2. If you click 3 in the Grouping frame, the pie chart will display different results. Be sure to click 3, check how the pie chart appears, then click 2 again so the pie chart appears as shown in Figure D14.

Using Table Formats

In Step 7, on page 88 of the text, you are instructed to apply one of Excel’s preset table formats to the worksheet. Be sure to experiment with the various table formats available. Notice how such formatting can make worksheet data more readable or it can obscure data unnecessarily. Make sure you always format a worksheet so that the data can be easily read.

PRINT AS INSTRUCTED AND SHOW ME!

Independent Challenge 1

PR-D My Predictions.xlsx

Create an income and expenses worksheet for a business of your choice and then use the Scenario Manager to determine the effect of a proposed expansion. If you currently work for a business, create one for them and show your boss!! EXTRA CREDIT!!! Take lots of time to determine appropriate expansion plans and then creating a realistic income and expenses statement. To save time, you could open the income and expenses statement you created for Project 1 and adapt it for your own business. When you have created the Current, Best Case, and Worst Case scenarios, ensure that you format the worksheet attractively and print each scenario in turn. Ensure that each version includes the appropriate changes to the header. To make the values related to each scenario easy to read, be sure to apply a shaded fill to the appropriate cells.

Illustrated below is a sample Worst Case version of the Revenue and Expenses worksheet for Atlantis Publishing Services. New values are entered in the Copy Sales, Salaries, Rent, and Operating Cost rows. You should also print a Best Case version and a Current version of the worksheet. Be sure to change the header information and the chart title for each version.

DIRECTIONS IN YOUR BOOK:

  1. #1–Send this information to me in a note in Edmodo. Use good writing skills.
  2. #8–Actually print according to the instructions in your book.
  3. #10–Actually print according to the instructions in your book.
  4. #11–Actually print according to the instructions in your book.
  5. Send me a copy of your workbook as an attachment to a note in Edmodo

advappsday67_clip_image002

 

Before you start this project, send me a note in Edmodo explain order of operation. Explain this formula to me: =(b4+c4+d4+e4)/($b$20+$c$20+$d$20+$e$20)*$j$20

Project 2: Course Grades Analysis for Psychology 200

PR-D Course Grades Analysis.xlsx

In Project 2, you will set up a grades worksheet for Psychology 200, calculate the grades earned by each of the students enrolled in the course, and then create a Subtotals list that counts the number of students who earned each grade (for example, A, B, and so forth). You will then display the data from the Subtotals list in a pie chart. The goal of Project 2 is to show you how they can use the Subtotals function to analyze data entered in a worksheet and then display this data in chart form. You will also learn how to use the Lookup function to match values entered in a lookup table with the appropriate values entered in a worksheet. Before you begin Project 2, you might want to review the following topics.

Setting Up the Worksheet

Be sure to carefully check the values enter enter in the worksheet against the values entered in Figure D-10, on page 85 of the text. If a value is entered incorrectly, you will not achieve the required results.

Understanding Weighted Values

Review the concept of weighted values, as calculated in Steps 2 through 7 on page 84 of the text. Make sure that the total points a student earns in any given category (for example, 60 points for Assignments) are divided by the total points possible (for example, 80 points for Assignments) and then multiplied by the weighted score (for example, 50 points for Assignments). The resulting value represents the student’s weighted score for the category.

This method of weighting scores enables instructors to total the weighted scores to calculate the number of points out of 100 that each student earns. This number of points (for example, 87) represents a grade of 87% for the course. A lookup table is then used to assign a letter grade to the student (for example, B+ if the percentage is greater than or equal to 87% and less then 90%).

Calculating Totals

In Steps 2 through 6, on page 84 of the text, you are instructed to enter a formula to calculate the total points earned by the first student on the list (Michael Banks) and then to copy the formula for the remaining students in the class. Note the use of [F4] to insert dollar signs ($) in the formula so that the references to cells in rows 20 and 21 are absolute. Make sure you understand that these references must be absolute so that the total assignment score earned by each student is divided only by the values in row 21.

Entering the Lookup Formula

In Steps 1 through 3, on page 86 of the text, use the Lookup function to calculate the letter grade earned by each student in the class. Here are the tasks performed by the Lookup function:

  1. Searches the ranges in a lookup table
  2. Finds the range that includes the value in a designated cell (for example, cell M5)
  3. Enters the values for that range (for example, A-)

You can use the Lookup function for other purposes. For example, you can create a list of products in Sheet1 and then create a lookup table in Sheet2 that contains a price list. The Lookup function can then be used to enter a specific price, depending on the product entered in a specific cell in Sheet 1.

Note that array refers to the range of cells that contains the lookup table (cells A2 to B12 in the Lookup sheet).

Creating a Subtotals List

What is the purpose of the Subtotals list?—to display the number of times each letter grade appears in column M. Be sure that you compare your collapsed Subtotals list against Figure D-14, on page 87 of the text, to ensure that the correct breakdown of grades is achieved.

Creating the Pie Chart

You will create a pie chart from the Subtotals list when it is collapsed to level 2. If you click 3 in the Grouping frame, the pie chart will display different results. Be sure to click 3, check how the pie chart appears, then click 2 again so the pie chart appears as shown in Figure D14.

Using Table Formats

In Step 7, on page 88 of the text, you are instructed to apply one of Excel’s preset table formats to the worksheet. Be sure to experiment with the various table formats available. Notice how such formatting can make worksheet data more readable or it can obscure data unnecessarily. Make sure you always format a worksheet so that the data can be easily read.

PRINT AS INSTRUCTED AND SHOW ME!