Highline Community College Business Technology Project

Highline Community College Business Technology Project.

Question Description

In daily life, you solve all sorts of problems, such as which car purchase makes the most economic sense when
comparing purchase price, mileage, and maintenance, or which software package will help your biking club
manage its funds, plan road trips, and keep memberships up to date. To solve these and other problems, you
need to collect data that tracks the current situation, determine your ultimate goal, and then follow a logical
progression to the best solution. Developing an Excel table can help you track the data you need to solve such
problems.
In this exercise, you need to select an activity in which you participate or an organization to which you belong,
and identify a one-time or process-oriented problem that needs to be solved. Then, create a worksheet and
develop an Excel table to track relevant data and create a solution to the problem, using the Excel skills and
features presented in Tutorials 5 through 8.
Note: Please be sure not to include any personal information of a sensitive nature in any worksheets you create
to submit to your instructor. Later, you can update the worksheets with such information for your own personal
use.
1. Identify a problem to solve. This can be a one-time problem, such as a car purchase, or a processoriented problem, such as tracking membership data for a club to which you belong. Determine feasible
alternatives to solve the problem, and then collect the data you need to evaluate these alternatives.
2. Plan the organization of your workbook and the Excel table you will develop based on how you will use
the data. Consider the outputs you want to create, and the fields needed to produce those outputs.
Decide what each record represents (such as data on a participant), and then identify the fields and field
names (such as last name, first name, birth date, and so on) within each record. What calculations will
you need to perform? How do you want to format the information?
3. Create a Documentation worksheet that includes your name, the date, and the purpose of your workbook.
Include a data definition table to document the fields in each record. Format the worksheet
appropriately.
4. Create an Excel table to track the data needed to solve the problem you identified. Enter an appropriate
table name and column headers. Add one or more calculated columns to the table to perform
calculations on the data that you will use to solve the problem.
5. Improve the appearance of the table by using appropriate formatting.
6. Apply validity checks to improve the accuracy of data entry.
Page 2
7. Add records to the table.
8. Apply conditional formatting to at least one column in the table to visually highlight some aspect of the
data that will help you evaluate and solve the problem.
9. Add a comment to the column with the conditional formatting to explain what the conditional formatting
shows, and how it will help you to evaluate and solve the problem.
10. Insert a Total row in the table, and then make appropriate summary calculations that you can use to
evaluate and solve the problem.
11. Divide the table into two horizontal panes–one for the data, and one for the Total row.
12. Sort the data in a logical way.
13. Use a filter to answer a question about the data to help you evaluate and solve the problem.
14. Create a PivotTable and a PivotChart to analyze the data. Format, filter, and sort the PivotTable
appropriately.
15. In a Word document, explain the problem you solved, identify the alternatives you considered, document
the data you collected to evaluate the alternatives, and then describe the results of your analysis.
Include the PivotChart in the Word document.
16. In an appropriate worksheet, insert a hyperlink that links to the Word document you created.
17. Create at least one macro to automate a repetitive task you need to perform in the workbook, such as
printing or saving a worksheet as a PDF file.
18. Prepare your workbook for printing. Include headers and footers that indicate the filename of your
workbook, the workbook’s author, and the date on which the report is printed. If a printed worksheet
will extend across several pages, repeat appropriate print titles across all of the pages, and include page
numbers and the total number of pages on each printed page.
19. Save the workbook. Submit both your Excel Workbook and your Word document into a folder and zip the
completed folder. Attach the zipped folder to the Canvas dropbox.

Haven’t Found The Relevant Content? Hire a Subject Expert to Help You With
Highline Community College Business Technology Project
Post Your Own Question And Get A Custom Answer
Hire Writer

Highline Community College Business Technology Project

MyhomeworkGeeks
Calculate the price of your paper
Pages (550 words)
Approximate price: -

Why Hire a Professional Essay Writer from MyHomeworkGeeks

Quality Urgent Essays

Domyhomeworkk online platform provides the best essay writing service ever received elsewhere, thanks to our professional essay writers. Experience gained in the 10+ years of being in the assignment writing industry is also an added advantage.

Professional and Experienced Academic Writers

A lot is done to maintain us as the best essay writing service provider. Besides owning a degree from a recognized university, a writer must pass the rigorous tests we take them through before they are considered eligible to offer urgent essay help on our website.

Affordable Urgent Assignment Help

Who said a reliable website should not be cheap also? While it is human nature to associate prices with quality, that does not always work. At domyhomeworkk.com, we guarantee you cheap and urgent essay help without compromising the quality.

24/7 Available Urgent Essay Writing Service

Whether it is a ‘write my essay for me cheap’ or ‘edit my essay’ order you want to request, always feel free to reach us at any time of the day. Our experts work in shifts to ensure that you access urgent essay writing services at any time of the day.

Plagiarism Free Essays Online

The punitive measures that come with plagiarized content are so harsh, and we understand that. We consequently ensure to write each client’s papers from scratch no matter how urgent the essay is. To acknowledge borrowed content, our quick writer references and cites the work.

Wow Customer Support 24/7

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

We'll send you the first draft for approval by at
Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

So much stress and so little time? Take care of yourself: let us help you with your tasks. We offer all kinds of writing services.

Essays

Custom Essay Writing Services

No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.

Admissions

Admission and Business Papers

An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.

Editing

Editing and Proofreading

Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.

Coursework

Revision Support

If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.

Have a homework question? Get help from verified tutors now!