Select a publicly-traded company that is traded on U.S. exchange. Locate the

Select a publicly-traded company that is traded on U.S. exchange. Locate the annual report for at least the last three fiscal years.
Analyze the financial statements for the company and review for large movements in specific accounts from one year to the next. In addition, review the notes to the financial statements as these are an integral part of the financial reporting package. Evaluate the balance sheet to determine if there are large changes in the company’s assets, liabilities, or equity accounts. In addition, analyze the income statement and statement of cash flows.
At a minimum, calculate the following ratios for two years, the debt-to-equity ratio, current ratio, quick ratio, return on equity, and net profit margin. For each ratio, explain what the ratio tells you about the company.

Overview For this hands-on project, you’ll be creating a Microsoft PowerPoint pr

Overview
For this hands-on project, you’ll be creating a Microsoft PowerPoint presentation of your choice from one of the following topics. You may only choose one topic, and it must meet all the requirements listed below. You’ll be using most of the tools that you learned throughout this lesson in a real-world scenario. 
Incomplete work will be returned without a score and asked to resubmit immediately. Remember, per the syllabus, that all work must be considered complete in order to pass the course.
You may choose one of the following three topics, then use the requirements below to craft your presentation:
A presentation featuring your Dream Vacation Destination
 If you use any outside sources, such as pictures, text, or quotes, be sure to properly cite using APA style on the last slide of your slide show.  
 Citation, spelling, grammar, and the overall look and feel of your presentation will be evaluated, so be sure to create, edit, and revise before turning in. 
Storyboard Project
Choose your topic from the list presented above. Using the Storyboard template document, map out your presentation, including the main topic of each slide, the layout you will use, and list the types of content that will be included on each slide.
Your presentation should be at least 10 slides long: one title slide, one slide for references at the very end, and eight or more content slides.
Review all the requirements below and include items where applicable in your Storyboard document.
Save your Storyboard as “Lesson05_Storyboard_MEID.docx,” where MEID is your MEID.
 The Storyboard is meant to be a brainstorming document to help you plan out how the presentation will flow and which topics you’ll cover. This Storyboard is not set in stone; it can evolve and change as you decide to add more or less to your final presentation.  
PowerPoint Presentation
Start a New PowerPoint Presentation. Do not use a Template, but start a New Blank Presentation.
Save your file as “Lesson5_Presentation_MEID.pptx,” where MEID is your MEID.
Apply a Theme to the presentation.
Create a Title Slide that features your title, name, MEID, and today’s date.
Create eight content slides.
The first content slide should be an introduction of what you will present.
You must use three different slide layouts.
Each slide must contain text.
You must use one of the following on every slide, and each should be used at least once:
Picture or Clip-Art
Shapes/Diagram
On the slide where shapes are used, group the shapes together.
Your content should match your previously created Storyboard document.
Use at least one bullet list.
Use at least one numbered list.
Use font formatting at least once. This can be bolding, underlining, or italicizing text on a slide.
Using the Master Views, edit the Slide Master for your presentation and add a text box shape with your MEID in the lower left corner of every slide. (Be sure to choose an appropriate text color based on your theme and background image.)
Create a References slide as the final slide in your presentation. Any outside material should be cited here using APA format.
Review your presentation and create presenter notes for each slide.
Apply animations to each slide of your presentation.
Apply transitions to each content slide of your presentation.
Preview your presentation in Presentation Mode.
Use the Pen Annotation Tool and make a note on at least one slide.
Review each slide for grammatical and spelling errors.
When you have reviewed your document, save all your changes and create a zip file with your Storyboard document included.
Submit the assignment based on the instructions provided.

For this assignment, you will demonstrate your knowledge of how to work with dif

For this assignment, you will demonstrate your knowledge of how to work with different data table features available in Excel.
Tables allow you to analyze data in Excel quickly and quite easily. Most companies utilize different Excel features including Tables to compile their customer, sales, employee information, and much more because it is comprehensive yet versatile.  
For this project, you will be modifying a table for the company your work uses to track the sales data and apply different table formatting features.
Add a new sheet and name the sheet Sales.
Copy cell range A3:F40 from the Reporting worksheet and paste it in the Sales worksheet.
AutoFit columns on the Sales worksheet.
Apply the Accounting number format to cell range F2:F38.
Select cell range A1:F38 and Insert a Table. In the Create Table dialog box, double-check that the range is correct for the “Where is the Data for your table?” and click on the “My Table has Headers” checkbox and then press OK.
Apply AutoFit to columns on the Sales worksheet again.
Select cell range A1:F38 and apply a different Table theme of your choice instead of the default Office theme.
Within the Sales worksheet, insert Filters to the Table range A1:F1.
Insert a Totals Row on the Sales worksheet.
Add a custom Header to your workbook with your name in the left section and MEID in the right section of Header
Add a custom Footer to your workbook with today’s date in the left section and the words Lesson 7 in the right section of the Footer.
Review your workbook for spelling.
Save your file and close.
PART 2
For this assignment, you will continue working with the Paper Sales company workbook from Project 1 to demonstrate your knowledge of creating charts, manipulating table data, and using additional formatting to provide a more in-depth analysis of basic sales data in a more comprehensive workbook. Businesses and individuals alike can benefit from being able to analyze and share information using a straightforward and accurate perspective.
Hands-On Project 2 Directions
Open workbook file CIS105_Lesson7Project1_MEID.xlsx and Save As CIS105_Lesson7Project2_MEID.xlsx.
On the Sales worksheet, select cell range A1:F38 and insert a Line Graph chart.
A Line Graph has been created on your Sales worksheet. Move this to a new worksheet titled: Sales Chart
Edit the Source Data for the graph and deselect all ranges except Net Sales, ensure the Horizontal Axis is set as your date column.
Apply Chart Style 5.
Apply Chart Quick Layout 3.
Change the title of your chart to: Net Sales by Date
Hide the Legend of your graph.
Change the color of the line to red.
On the Sales worksheet, click on cell F40 and insert a Sparkline using the data in the Net Sales column excluding the total (F2:F38). Choose an appropriate chart to show change over time.
Change the Sparkline design color to Orange, Sparkline Color Dark #2.
Apply filters to show only the North region.
Add a custom Header to your workbook with your name in the left section and MEID in the right section of Header.
Add a custom Footer to your workbook by using the Date function in the left section and in the right section of the Footer type the words: Lesson 7
Review your workbook for spelling errors and make any necessary corrections.
Save your file and close.

Overview For this assignment, you will demonstrate your knowledge using the feat

Overview
For this assignment, you will demonstrate your knowledge using the features available in Excel. Many businesses track customers, products, and other financial data using software applications instead of pencil and paper. One reason for this is to manage data and information easily and to utilize creative and unique customization tools provided with Excel.
You will create a workbook for a company to use to input customer information, using formatting and page setup features, and explain why you should use Excel.
Hands-On Project 1 Directions
Open a blank workbook and then save the workbook as CIS105_Lesson6Project1_MEID.xlsx. NOTE: Change the MEID to your personal school MEID. Ex. as CIS105_Lesson6_ABC1234567.xlsx.
Rename the Sheet1 worksheet as Customers.
Enter the following data into the specified cells:
Cell A1: Bubbles & Bows
Cell A2: Date
Cell A20: Use to track customer sales for Bubbles & Bows Gift Shop
Cell B2: Customer Name
Cell C2: Customer Address
Cell D2: Contact Number
Cell E2: Total Sales
Cell F2: Discount Applied
Set the width of column A to 10.00.
Set the width of column B to 15.00.
Set the width of column C to 25.00.
Set the width of column D to 10.00.
Set the width of column E to 10.00.
Set the width of column F to 16.00.
Set the height of row 1 to 36.00.
Change the Font of the entire worksheet to Times New Roman with Font Size 11.
Merge & Center cells A1 through F1.
Merge & Center cells A20 through F20.
Apply Wrap Text to cell D2.
Apply Bold and center alignment to cells A2 through F2.
Apply Bold and font size 20 to merged cell A1:F1.
Apply Red font color to words in merged cell A1:F1.
Apply a fill color of your choice to merged cell A1:F1.
Apply italics and underline font style to merged cell A20:F20.
Select cell range A1:F20 and apply All Borders.
Add a new sheet to the workbook. Rename Sheet2 as Purpose.
On the Purpose worksheet, provide a minimum of 2-3 sentences to answer for each of the following questions:
Cell A1 answer – What software program group does Excel belong to, and when was it created?
Cell A3 answer – What tasks can you perform in Excel when compared to Word?
Cell A5 answer – Why do you think Bubbles & Bows Gift Shop might want to use Excel with their business?
Back on the Customers worksheet, enter appropriate data of your choosing (real or made up) data into all cells A3:D19. (Dates in column A, customer names in column B, customer addresses in column C, and contact phone number in column D).
Select columns B, C and D, and AutoFit Columns to the longest entry of each column.
Apply Narrow margins to your worksheet. (.75” Top/Bottom; .25 Right/Left).
Apply Landscape orientation.
Add a custom Header with your first and last names in the left section and your MEID in right section of the Header.
Add a custom Footer by inserting the DATE function in the left section and the words “Lesson 6” in the right section of the Footer.
Review your entire workbook for spelling.
Save your file and close.  NOTE: Be sure your file is named CIS105_Lesson6Project1_MEID.xlsx.
Submit the assignment according to the instructions in the lesson.
PART 2
Overview
For this assignment, you will demonstrate your knowledge of how to create and modify different formulas and functions available in Excel. When businesses track customers, products, and other financial aspects, Excel’s features can help customize and personalize business needs and expectations.
You will continue using the Lesson 6 Project workbook you created in Project 1 to input customers’ personal and sales information. You will use additional formatting techniques, apply formulas and functions, and use a Quick Analysis tool to determine a varying sales total projection.
Hands-On Project 2 Directions
Open the workbook CIS105_Lesson6Project1_MEID.xlsx created in the previous project and save it as CIS105_Lesson6Project2_MEID.xlsx  NOTE: Change the MEID to your Rio Salado MEID. 
Delete column F.
Insert two new columns to the left of column E; you will now have columns through G.
Type the word Regular in cell E2 and Clearance in cell F2.
In each cell in range E3:E7, type 150.
In each cell in range E8:E14, type 100.
In each cell in range  E15:E19, type 75.
In each cell in range F3:F9, type 30.
In each cell in range F10:F19, type 50.
Select cell range E3:F19, and apply the Accounting number formatting ($ English).
In cell G3, enter a formula to provide the answer when adding cells E3 and F3. Copy the formula down through G19 to add the values in columns E and F for each appropriate row.
Enter a new row after row 19.
Select cell range A1:G21, and apply All Borders.
Merge cells A20 through D20 and then apply the same fill color as in row 1.
In cell E20, enter the appropriate function to add E3:E19.  
In cell F20, enter the appropriate function to add F3:F19.  
In cell G20, copy the function used in F20 and use to add G3:G19. 
Insert a new sheet and name the sheet Projections.
On the Customers worksheet, copy cell range E2:G20 and then with A1 active in the Projections worksheet, paste the copied cells.
On the Projections worksheet, AutoFit columns A through C.
In cell A21 on the Projections worksheet, enter a Function that will add the current date.
On the Projections worksheet, click into cell C21 and then enter a Scenario Manager What-If Analysis completing the following:
In the Add Scenario dialog box:
Scenario Name – No Clearance
Changing Cells – B2:B18
Do not make any changes to the Comment
Protection – click “Prevent Changes” box
In the Scenario Values dialog box, change each value to 0 then press OK. TIP: Pressing tab after each zero will take you to the next value entry box.
Once you are back to the Scenario Manager dialog box, press Show and then Close.
Apply Bold to cell G20 on the Customers worksheet and apply Bold to cell C19 on the Projections worksheet.
On the Customers worksheet, add a custom Header with your name in the left section and your MEID in the right section of the Header.
On the Customers worksheet, add a custom Footer with the Date function in the left section and the words Lesson 6 in the right section of the Footer.
Review your workbook for spelling.
Save your file and close Excel. 
Place the following files in a folder and label it “Lesson 6.” Zip the folder as described in the Syllabus.
CIS105_Lesson6Project1_MEID.xlsx
CIS105_Lesson6Project2_MEID.xlsx
Submit the assignment according to the instructions in the lesson.

Overview For this assignment, you will use the tools you learned from Lesson 4 t

Overview
For this assignment, you will use the tools you learned from Lesson 4 to create a standard APA formatted paper.
Directions
Open a new document and save the document as CIS105_Lesson4Project_MEID.docx.
 
Type the following information for the Title Page of your paper:
Document Productivity
Your First & Last Name, MEID
Rio Salado College
Insert a Next Page Section Break after typing “Rio Salado College”.
Align the text on the title page to be centered, both vertically and horizontally.
On page 2, type each of the following section headings and format them using the Heading 1 Style:
Table of Contents
Plagiarism
Citation & Bibliography
Proofing a Document
Analyzing a Document
Tables
Tracking Changes
Headers & Footers
Under each of the titles created in Step 5, write a paragraph summarizing the topic. Make sure that the style for each paragraph is set to Normal. 
Include at least one reference and one in-text citation using that reference.
Insert a Page Break before the Table of Contents heading. This should move your content to page 3.
At the top of page 2, insert a Table of Contents.
Make any necessary adjustments to your page breaks. Page 1 should be your Title Page. Page 2 should be your Table of Contents. The body of your paper should begin on Page 3.
Insert a table under the paragraph in the Tables heading.

Include 4 rows and 4 columns.
Table spacing should be height 0.2 and width 1.0.
Apply Table Theme Grid Table 6 Colorful – Accent 1.
Center the table in the document.
Enter the following topics to the top row:

Week 
Topic
Assignment

Add a row to the bottom of the table.
Enter the following in the first column:

1
2
3
4

Delete the last column.
Resize the center column to Width 3.5.
Enter the following in the Topic column:

Network, Internet, and Computer Technology
Operating Systems and Software
Introduction to Microsoft Word
Document Productivity

Enter your assignment scores in the Assignment column.

Insert a header that starts on page 2 of your document. Include the following information in the header:
Document Title
Your first and last name
Your MEID
A date that shows the month, day, year
Align the header text to the left.
Insert a footer that starts on page 2. Include the following information in your footer:

Page Number (please note, you should be using the auto page number tool and not manually entering in the page number)

Align the footer text to the center.
Highlight the Tracking Changes heading and insert a comment for your instructor.
Proof your document for errors.
Check the Accessibility of your document. Fix any errors that are found in the document.
At the end of the document, insert a Page Break.
At the top of the last page, type References. Align the text to the center and format it using the Heading 1 Style.
Insert your references in APA format. Align the text to the left and set a hanging indent for the references.
Format the entire document using these settings:

Double-Spaced
Times New Roman font
Font Size 12

Update the Table of Contents to ensure that all headings are included and all page numbers are correct.
Submit your assignment following the instructions in the lesson.

Select a publicly-traded company that is traded on U.S. exchange. Locate the

Select a publicly-traded company that is traded on U.S. exchange. Locate the annual report for at least the last three fiscal years.
Analyze the financial statements for the company and review for large movements in specific accounts from one year to the next. In addition, review the notes to the financial statements as these are an integral part of the financial reporting package. Evaluate the balance sheet to determine if there are large changes in the company’s assets, liabilities, or equity accounts. In addition, analyze the income statement and statement of cash flows.
At a minimum, calculate the following ratios for two years, the debt-to-equity ratio, current ratio, quick ratio, return on equity, and net profit margin. For each ratio, explain what the ratio tells you about the company.

For this assignment, you will demonstrate your knowledge of how to work with dif

For this assignment, you will demonstrate your knowledge of how to work with different data table features available in Excel.
Tables allow you to analyze data in Excel quickly and quite easily. Most companies utilize different Excel features including Tables to compile their customer, sales, employee information, and much more because it is comprehensive yet versatile.  
For this project, you will be modifying a table for the company your work uses to track the sales data and apply different table formatting features.
Add a new sheet and name the sheet Sales.
Copy cell range A3:F40 from the Reporting worksheet and paste it in the Sales worksheet.
AutoFit columns on the Sales worksheet.
Apply the Accounting number format to cell range F2:F38.
Select cell range A1:F38 and Insert a Table. In the Create Table dialog box, double-check that the range is correct for the “Where is the Data for your table?” and click on the “My Table has Headers” checkbox and then press OK.
Apply AutoFit to columns on the Sales worksheet again.
Select cell range A1:F38 and apply a different Table theme of your choice instead of the default Office theme.
Within the Sales worksheet, insert Filters to the Table range A1:F1.
Insert a Totals Row on the Sales worksheet.
Add a custom Header to your workbook with your name in the left section and MEID in the right section of Header
Add a custom Footer to your workbook with today’s date in the left section and the words Lesson 7 in the right section of the Footer.
Review your workbook for spelling.
Save your file and close.
PART 2
For this assignment, you will continue working with the Paper Sales company workbook from Project 1 to demonstrate your knowledge of creating charts, manipulating table data, and using additional formatting to provide a more in-depth analysis of basic sales data in a more comprehensive workbook. Businesses and individuals alike can benefit from being able to analyze and share information using a straightforward and accurate perspective.
Hands-On Project 2 Directions
Open workbook file CIS105_Lesson7Project1_MEID.xlsx and Save As CIS105_Lesson7Project2_MEID.xlsx.
On the Sales worksheet, select cell range A1:F38 and insert a Line Graph chart.
A Line Graph has been created on your Sales worksheet. Move this to a new worksheet titled: Sales Chart
Edit the Source Data for the graph and deselect all ranges except Net Sales, ensure the Horizontal Axis is set as your date column.
Apply Chart Style 5.
Apply Chart Quick Layout 3.
Change the title of your chart to: Net Sales by Date
Hide the Legend of your graph.
Change the color of the line to red.
On the Sales worksheet, click on cell F40 and insert a Sparkline using the data in the Net Sales column excluding the total (F2:F38). Choose an appropriate chart to show change over time.
Change the Sparkline design color to Orange, Sparkline Color Dark #2.
Apply filters to show only the North region.
Add a custom Header to your workbook with your name in the left section and MEID in the right section of Header.
Add a custom Footer to your workbook by using the Date function in the left section and in the right section of the Footer type the words: Lesson 7
Review your workbook for spelling errors and make any necessary corrections.
Save your file and close.

Overview For this assignment, you will demonstrate your knowledge using the feat

Overview
For this assignment, you will demonstrate your knowledge using the features available in Excel. Many businesses track customers, products, and other financial data using software applications instead of pencil and paper. One reason for this is to manage data and information easily and to utilize creative and unique customization tools provided with Excel.
You will create a workbook for a company to use to input customer information, using formatting and page setup features, and explain why you should use Excel.
Hands-On Project 1 Directions
Open a blank workbook and then save the workbook as CIS105_Lesson6Project1_MEID.xlsx. NOTE: Change the MEID to your personal school MEID. Ex. as CIS105_Lesson6_ABC1234567.xlsx.
Rename the Sheet1 worksheet as Customers.
Enter the following data into the specified cells:
Cell A1: Bubbles & Bows
Cell A2: Date
Cell A20: Use to track customer sales for Bubbles & Bows Gift Shop
Cell B2: Customer Name
Cell C2: Customer Address
Cell D2: Contact Number
Cell E2: Total Sales
Cell F2: Discount Applied
Set the width of column A to 10.00.
Set the width of column B to 15.00.
Set the width of column C to 25.00.
Set the width of column D to 10.00.
Set the width of column E to 10.00.
Set the width of column F to 16.00.
Set the height of row 1 to 36.00.
Change the Font of the entire worksheet to Times New Roman with Font Size 11.
Merge & Center cells A1 through F1.
Merge & Center cells A20 through F20.
Apply Wrap Text to cell D2.
Apply Bold and center alignment to cells A2 through F2.
Apply Bold and font size 20 to merged cell A1:F1.
Apply Red font color to words in merged cell A1:F1.
Apply a fill color of your choice to merged cell A1:F1.
Apply italics and underline font style to merged cell A20:F20.
Select cell range A1:F20 and apply All Borders.
Add a new sheet to the workbook. Rename Sheet2 as Purpose.
On the Purpose worksheet, provide a minimum of 2-3 sentences to answer for each of the following questions:
Cell A1 answer – What software program group does Excel belong to, and when was it created?
Cell A3 answer – What tasks can you perform in Excel when compared to Word?
Cell A5 answer – Why do you think Bubbles & Bows Gift Shop might want to use Excel with their business?
Back on the Customers worksheet, enter appropriate data of your choosing (real or made up) data into all cells A3:D19. (Dates in column A, customer names in column B, customer addresses in column C, and contact phone number in column D).
Select columns B, C and D, and AutoFit Columns to the longest entry of each column.
Apply Narrow margins to your worksheet. (.75” Top/Bottom; .25 Right/Left).
Apply Landscape orientation.
Add a custom Header with your first and last names in the left section and your MEID in right section of the Header.
Add a custom Footer by inserting the DATE function in the left section and the words “Lesson 6” in the right section of the Footer.
Review your entire workbook for spelling.
Save your file and close.  NOTE: Be sure your file is named CIS105_Lesson6Project1_MEID.xlsx.
Submit the assignment according to the instructions in the lesson.
PART 2
Overview
For this assignment, you will demonstrate your knowledge of how to create and modify different formulas and functions available in Excel. When businesses track customers, products, and other financial aspects, Excel’s features can help customize and personalize business needs and expectations.
You will continue using the Lesson 6 Project workbook you created in Project 1 to input customers’ personal and sales information. You will use additional formatting techniques, apply formulas and functions, and use a Quick Analysis tool to determine a varying sales total projection.
Hands-On Project 2 Directions
Open the workbook CIS105_Lesson6Project1_MEID.xlsx created in the previous project and save it as CIS105_Lesson6Project2_MEID.xlsx  NOTE: Change the MEID to your Rio Salado MEID. 
Delete column F.
Insert two new columns to the left of column E; you will now have columns through G.
Type the word Regular in cell E2 and Clearance in cell F2.
In each cell in range E3:E7, type 150.
In each cell in range E8:E14, type 100.
In each cell in range  E15:E19, type 75.
In each cell in range F3:F9, type 30.
In each cell in range F10:F19, type 50.
Select cell range E3:F19, and apply the Accounting number formatting ($ English).
In cell G3, enter a formula to provide the answer when adding cells E3 and F3. Copy the formula down through G19 to add the values in columns E and F for each appropriate row.
Enter a new row after row 19.
Select cell range A1:G21, and apply All Borders.
Merge cells A20 through D20 and then apply the same fill color as in row 1.
In cell E20, enter the appropriate function to add E3:E19.  
In cell F20, enter the appropriate function to add F3:F19.  
In cell G20, copy the function used in F20 and use to add G3:G19. 
Insert a new sheet and name the sheet Projections.
On the Customers worksheet, copy cell range E2:G20 and then with A1 active in the Projections worksheet, paste the copied cells.
On the Projections worksheet, AutoFit columns A through C.
In cell A21 on the Projections worksheet, enter a Function that will add the current date.
On the Projections worksheet, click into cell C21 and then enter a Scenario Manager What-If Analysis completing the following:
In the Add Scenario dialog box:
Scenario Name – No Clearance
Changing Cells – B2:B18
Do not make any changes to the Comment
Protection – click “Prevent Changes” box
In the Scenario Values dialog box, change each value to 0 then press OK. TIP: Pressing tab after each zero will take you to the next value entry box.
Once you are back to the Scenario Manager dialog box, press Show and then Close.
Apply Bold to cell G20 on the Customers worksheet and apply Bold to cell C19 on the Projections worksheet.
On the Customers worksheet, add a custom Header with your name in the left section and your MEID in the right section of the Header.
On the Customers worksheet, add a custom Footer with the Date function in the left section and the words Lesson 6 in the right section of the Footer.
Review your workbook for spelling.
Save your file and close Excel. 
Place the following files in a folder and label it “Lesson 6.” Zip the folder as described in the Syllabus.
CIS105_Lesson6Project1_MEID.xlsx
CIS105_Lesson6Project2_MEID.xlsx
Submit the assignment according to the instructions in the lesson.