Please complete the following assignments and submit to me the requested homework. Send me an email to mariodvc@gmail.com when you are done with an assignment and use the provided email subject line (copy and paste it) so that your homework submission is routed to the correct assignment folder.
Thank You and Email me if you have ANY questions - Mario :)
The tasks that you should complete for Tech Assignment #1:
Order/Get your textbook
If Needed - Order/Install your Software
Follow the directions in the textbook
and DownLoad your STUDENT FILES off of the CD
- save them to your Hard Drive
Watch the Video: - Tips for Success This Video is located on the Class Homepage.
Install the Flash Player (link is on homepage)
- if needed - to view class videos.
Install the Adobe Reader (link is on homepage)
- If needed - to view PDF files.
Email me that you have completed Tech Assignment #1
Email Subject Line should Read: Excel-Tech #1 Completed - Your Name
Example = Excel-Tech #1 Completed - Mario Tejada
In the Discussion Board on WebCT:
=> Answer the Question Posted for Tech Assignment #2 .
Email me that you have completed Tech Assignment #2
Email Subject Line should Read: Excel-Tech #2 Completed - Your Name
Example = Excel-Tech #2 Completed - Mario Tejada
In these chapters, you will create documents for the Aspen Falls City Hall, which provides essential services for the citizens and visitors of Aspen Falls, California.
Microsoft Office is the most common software used to create and share personal and business documents. Microsoft Office is a suite of several programs-Word, Power Point, Excel, Access, and others-that each have a special purpose.
Because of the consistent design and layout of Microsoft Office, when you learn to use one Microsoft Office program, you can use most of those skills when working with the other Microsoft Office programs. The files you create with Microsoft Office need to be named and saved in locations where they can be easily found when you need them.
This first section in the textbook is called Common Features and cotains common elements that a person uses in the MS Office applications. The common features are items like opening files, saving files, entering text and printing.
The Ribbon (formally called the Toolbar) is used to select the different options in the application. The Ribbon is divided into Tabs, Groups and Buttons - Please pay special attention to which one of these you are being asked to use.
Important Note
If you are taking any of the following classes:
CIS - 115 - MS Word
CIS - 116 - MS Excel
CIS - 117 - MS Access
CIS - 118 - MS PowerPoint
This first section is the SAME in all the class textbooks! Remember this section is to teach you the COMMON FEATURES of all the MS Office Applications.
Excel Students - this section is slightly MS Word centric so please pay attention to the processes - saving the file, creating the folder, etc. that is what we need to focus on.
You will not need to submit any of the documents generated in this section.
If you have any questions or comments,
Please email me - Thank You
Microsoft Office Excel 2010 is used worldwide to create workbooks and to analyze data that is
organized into columns and rows.
After data is entered into Excel, you can perform calculations on the numerical data and analyze
the data to make informed decisions.
This section will introduce you to basic formulas and the SUM functions. Included in this sections is some printing, layout and formatting options.
When you are done working in Chapter 1 you will complete the end of chapter assignments Skill Check and Assess Your Skills #1 and then email me the solution files for credit.
If you have any questions or comments,
Please email me - Thank You
Complete the end of chapter sections:
Skill Check (pg. 58-59)
Assess Your Skills 1 (pg. 60)
Want to see an Example of the Completed Assignments?
Click this Link to see the PDF example file for
Excel - Chapter 1 = Bikes.xlsx
Skill Check = Sales.xlsx
Assess Your Skills 1 = Fees.xlsx
Homework Submission - Assess Your Skills assignment
Submit to me via email - 2 Files
File #1 = Lastname_Firstname_e01_Sales.xlsx File #2 = Lastname_Firstname_e01_Fees.xlsx
Email All Homework to: mariodvc@gmail.com Email Subject Line should Read = OL Excel - Chapter 1 - Your Name
After data is entered into Excel, you can create a visual representation of the data in the form of charts. Excel provides various types of charts that can make your data easier to understand-for example, pie charts show the size of items proportional to the sum of the items.
Charts can be enhanced with effects such as 3-D and soft shadows to create compelling graphical summaries.
This section also shows you how to work with absolute cell references, copy formulas with absolute cells and explode pie charts!
When you are done working in Chapter 2 you will complete the end of chapter assignments Skill Check and Assess Your Skills #1 and then email me the solution files for credit.
If you have any questions or comments,
Please email me - Thank You
Complete the end of chapter sections:
Skill Check (pg. 92-93)
Assess Your Skills 1 (pg. 94)
Want to see an Example of the Completed Assignments?
Click this Link to see the PDF example file for
Excel - Chapter 2 = Revenue.xlsx
Skill Check = Expenses.xlsx
Assess Your Skills 1 = Assets.xlsx
Homework Submission - Assess Your Skills assignment
Submit to me via email - 2 Files
File #1 = Lastname_Firstname_e02_Expenses.xlsx File #2 = Lastname_Firstname_e02_Assets.xlsx
Email All Homework to: mariodvc@gmail.com Email Subject Line should Read = OL Excel - Chapter 2 - Your Name
In an Excel workbook, you can insert and move worksheets, or you can group any number of worksheets and then edit or format the data in all of the worksheets at the same time. Multiple math operators can be used in one formula, and a formula can refer to a cell in another worksheet.
When you are done working in Chapter 3 you will complete the end of chapter assignments Skill Check and Assess Your Skills #1 and then email me the solution files for credit.
If you have any questions or comments,
Please email me - Thank You
Complete the end of chapter sections:
Skill Check (pg. 126-127)
Assess Your Skills 1 (pg. 128)
Want to see an Example of the Completed Assignments?
Click this Link to see the PDF example file for
Excel - Chapter 3 = Visitors.xlsx
Skill Check = Payroll.xlsx
Assess Your Skills 1 = Water.xlsx
Homework Submission - Assess Your Skills assignment
Submit to me via email - 2 Files
File #1 = Lastname_Firstname_e03_Payroll.xlsx
File #2 = Lastname_Firstname_e03_Water.xlsx
Email All Homework to: mariodvc@gmail.com Email Subject Line should Read = OL Excel - Chapter 3 - Your Name
The Excel Function Library contains hundreds of special functions that perform complex calculations quickly. Some of the categories in the Function Library include statistical, financial, logical, date and time, and math and trigonometry.
Excel tables help you manage information by providing many ways to sort, filter, analyze, format, and generate charts fr om the data in a table.
When you are done working in Chapter 4 you will complete the end of chapter assignments Skill Check and Assess Your Skills #1 and then email me the solution files for credit.
If you have any questions or comments,
Please email me - Thank You
Complete the end of chapter sections:
Skill Check (pg. 160-161)
Assess Your Skills 1 (pg. 162)
Want to see an Example of the Completed Assignments?
Click this Link to see the PDF example file for
Excel - Chapter 4 = Fire_Equipment.xlsx
Skill Check = Surplus.xlsx
Assess Your Skills 1 = Water.xlsx
Homework Submission - Assess Your Skills assignment
Submit to me via email - 2 Files
File #1 = Lastname_Firstname_e04_Surplus.xlsx
File #2 = Lastname_Firstname_e04_Water.xlsx
Email All Homework to: mariodvc@gmail.com Email Subject Line should Read = OL Excel - Chapter 4 - Your Name
In a workbook, you can format the cells to change the way that data is displayed without changing the underlying values of the data. Formatting the background and border of a cell often improves the appearance of the worksheet. Worksheets are formatted to provide a consistent or a unique look to an organization's documents.
When you are done working in Chapter 5 you will complete the end of chapter assignments Skill Check and Assess Your Skills #1 and then email me the solution files for credit.
If you have any questions or comments,
Please email me - Thank You
Complete the end of chapter sections:
Skill Check (pg. 160-161)
Assess Your Skills 1 (pg. 162)
Want to see an Example of the Completed Assignments?
Click this Link to see the PDF example file for
Excel - Chapter 5 = Course.xlsx
Skill Check = Golf.xlsx
Assess Your Skills 1 = Fuel.xlsx
Homework Submission - Assess Your Skills assignment
Submit to me via email - 2 Files
File #1 = Lastname_Firstname_e05_Golf.xlsx
File #2 = Lastname_Firstname_e05_Fuel.xlsx
Email All Homework to: mariodvc@gmail.com Email Subject Line should Read = OL Excel - Chapter 5 - Your Name
Excel functions are used to perform complex operations easily-for example, you can manipulate text and calculate the future value of assets. Excel analysis tools are used to perform what-if analysis and to determine which variables need to be changed in order to meet your goals.
When you are done working in Chapter 6 you will complete the end of chapter assignments Skill Check and Assess Your Skills #1 and then email me the solution files for credit.
If you have any questions or comments,
Please email me - Thank You
Complete the end of chapter sections:
Skill Check (pg. 228-229)
Assess Your Skills 1 (pg. 230)
Want to see an Example of the Completed Assignments?
Click this Link to see the PDF example file for
Excel - Chapter 6 = Payroll.xlsx
Skill Check = Utilities.xlsx
Assess Your Skills 1 = Investments.xlsx
Homework Submission - Assess Your Skills assignment
Submit to me via email - 2 Files
File #1 = Lastname_Firstname_e06_Utilities.xlsx
File #2 = Lastname_Firstname_e06_Investments.xlsx
Email All Homework to: mariodvc@gmail.com Email Subject Line should Read = OL Excel - Chapter 6 - Your Name
Data can be imported into Excel from a variety of file formats and then analyzed and manipulated in Excel. When errors occur in a formula, Excel provides tools to locate and fix the source of the error.
When you are done working in Chapter 7 you will complete the end of chapter assignments Skill Check and Assess Your Skills #1 and then email me the solution files for credit.
If you have any questions or comments,
Please email me - Thank You
Complete the end of chapter sections:
Skill Check (pg. 262-263)
Assess Your Skills 2 (pg. 265)
Want to see an Example of the Completed Assignments?
Click this Link to see the PDF example file for
Excel - Chapter 7 = Schedule.xlsx
Skill Check = Concession_Report.xlsx
Assess Your Skills 1 = Endowment.xlsx
Homework Submission - Assess Your Skills assignment
Submit to me via email - 2 Files
File #1 = Lastname_Firstname_e07_Concession_Report.xlsx
File #2 = Lastname_Firstname_e07_Endowment.xlsx
Email All Homework to: mariodvc@gmail.com Email Subject Line should Read = OL Excel - Chapter 7 - Your Name
You can improve the appearance of an Excel workbook by adding images and graphics. You can insert shapes to call attention to important areas on a worksheet.
When you are done working in Chapter 8 you will complete the end of chapter assignments Skill Check and Assess Your Skills #1 and then email me the solution files for credit.
If you have any questions or comments,
Please email me - Thank You
Complete the following tasks:
Watch these videos for the unit:
Video - Excel - Chapter 8 => Text book Publisher has NO VIDEO for this Chapter
In the Textbook Work through:
Excel - Chapter 8
Complete the end of chapter sections:
Skill Check (pg. 262-263)
Assess Your Skills 1 (pg. 264)
Want to see an Example of the Completed Assignments?
Click this Link to see the PDF example file for
Excel - Chapter 8 = Scorecard.xlsx
Skill Check = Portfolio.xlsx
Assess Your Skills 1 = Fuel.xlsx
Homework Submission - Assess Your Skills assignment
Submit to me via email - 2 Files
File #1 = Lastname_Firstname_e08_Portfolio.xlsx
File #2 = Lastname_Firstname_e08_Fuel.xlsx
Email All Homework to: mariodvc@gmail.com Email Subject Line should Read = OL Excel - Chapter 8 - Your Name
Import Data , Create PivotTable Reports and PivotChart Reports
PivotTable reports are used to dynamically summarize and analyze large amounts
of data. PivotTable report data can be graphically summarized using PivotChart reports.
When you are done working in Chapter 9 you will complete the end of chapter assignments Skill Check and Assess Your Skills #1 and then email me the solution files for credit.
If you have any questions or comments,
Please email me - Thank You
Complete the end of chapter sections:
Skill Check (pg. 330-331)
Assess Your Skills 1 (pg. 332)
Want to see an Example of the Completed Assignments?
Click this Link to see the PDF example file for
Excel - Chapter 9 = Demographics.xlsx
Skill Check = Population.xlsx
Assess Your Skills 1 = Vendor.xlsx
Homework Submission - Assess Your Skills assignment Submit to me via email - 2 Files
File #1 = Lastname_Firstname_e09_Population.xlsx
File #2 = Lastname_Firstname_e09_Vendors.xlsx
Email All Homework to: mariodvc@gmail.com Email Subject Line should Read = OL Excel - Chapter 9 - Your Name
When you collaborate with others to build a worksheet, each team member can add comments and
you can track each change made. You can also protect the worksheet so that only certain types of
changes are allowed.
You can create macros to automate common tasks.
When you are done working in Chapter 9 you will complete the end of chapter assignments Skill Check and Assess Your Skills #1 and then email me the solution files for credit.
If you have any questions or comments,
Please email me - Thank You
Complete the following tasks:
Watch these videos for the unit:
Video - Excel - Chapter 10 => Text book Publisher has NO VIDEO for this Chapter
In the Textbook Work through:
Excel - Chapter 10
Complete the end of chapter sections:
Skill Check (pg. 364-365)
Assess Your Skills 1 (pg. 366)
For the Final Project you will create a MS Excel file and incorperate several of the techniques learned in your Lessons. This is not an easy assignment thus the reason for the extra time to complete the project.
Make sure you set aside enough time to complete this Final Project and don't wait until the last minute!
The Final Project is worth 25 points.
When you have completed working on the Final Project you will email it to me for review and for credit - NO Later than Monday July 25th BEFORE 8am!!
I will accept NO Assignments after Monday July 25th at 8am!!
If you have any questions or comments,
Please email me - Thank You
Complete the following task:
Complete the section
- Chapter 10 - Assess Your Skills 2 (pg. 367)
Want to see an Example of the Completed Assignments?
Click this Link to see the PDF example file for
Assess Your Skills 2 = Loan2.xlsx & Loan1_Macro.xlsx
Homework Submission - Assess Your Skills Visuually assignment
Submit to me via email - 1 File
File #1 = Lastname_Firstname_e10_Loan2.xlsx
File #2 = Lastname_Firstname_e10_Loan1_Macro.xlsx
Email All Homework to: mariodvc@gmail.com Email Subject Line should Read = OL Excel - Final - Your Name