Computers and Technology, 08.03.2021 14:00 Sbeech7246

PROJECT: DEVELOPING A SPREADSHEET Imagine you are working as a computer support technician for a large company and your boss needs help. He has to create a spreadsheet to present to the Chief Technology Officer showing the financial information for your department and how much you spend on buying new and upgraded software and equipment.

He has the data, but does not have time to create the presentation. He sends you the Excel file with all the data and asks you to perform the calculations and make it look good.

Create a file with financial information for each month of one year. Include the following categories:

software expenses
hardware expenses
labor costs (employee salaries)
training costs
office expenses
It is okay to create dummy data for this file.

Format the data using a general format, a number format, an accounting format, and a currency format to see if there are any differences.

Copy the data onto two worksheets, one labeled 2012 and one labeled 2011. Working with either set of data, calculate the following information:

total expenses in each of the five categories
total expenses for each month
expenses in each category for each month
total costs for computer related items for each month
total costs for staff and training for each month
Your boss did not tell you how the CTO wants to see the data. So create one or more charts showing a breakdown of expenses by month. Use colors, shapes, and labels to make the charts. Also create one or more tables showing a breakdown of expenses by month. Use highlighting and formatting to create a readable table. Format each in a way that is visually appealing and tells the proper story of the data.

Submit a report showing the final chart and final tables, including results of all calculations. Create the report as if you are submitting it to your boss for review by the CTO. You can embed the Excel files into a Word document or PowerPoint document if you are familiar with those programs.

Using narrative description (bullet points are okay) on a separate page, list the steps you followed to create the chart and the table. Include decisions you had to make, such as which type of chart to create, and why you made a particular decision.

Submission Requirements
Use standard English and write full phrases or sentences. Do not use texting abbreviations or other shortcuts.
Make any tables, charts, or screen shots neat and well organized.
Make the information easy to understand.

Answers: 1

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 05:00

Modern businesses use different technologies to accomplish work tasks

Answers: 2

Answer

Computers and Technology, 23.06.2019 06:30

Martha is designing a single-player game. her manager suggests that she plan the design to incorporate future modifications. which principle of game design relates to planning for future modifications?

Answers: 1

Answer

Computers and Technology, 23.06.2019 18:50

What is transmission control protocol/internet protocol (tcp/ip)? software that prevents direct communication between a sending and receiving computer and is used to monitor packets for security reasons a standard that specifies the format of data as well as the rules to be followed during transmission a simple network protocol that allows the transfer of files between two computers on the internet a standard internet protocol that provides the technical foundation for the public internet as well as for large numbers of private networks

Answers: 2

Answer

Computers and Technology, 23.06.2019 19:00

This question involves a class named textfile that represents a text file. public class textfile { private string filename; private string filename; private arraylist words; // constructors not shown // postcondition: returns the number of bytes in this file public int filesize() { } // precondition: 0 < = index < words.size() // postcondition: removes numwords words from the words arraylist beginning at // index. public void deletewords(int index, int numwords) { } // precondition: 0 < = index < = words.size() // postcondition: adds elements from newwords array to words arraylist beginning // at index. pub lic voidaddwords(int index, string[] newwords) { } // other methods not shown } complete the filesize() method. the filesize() is computed in bytes. in a text file, each character in each word counts as one byte. in addition, there is a space in between each word in the words arraylist, and each of those spaces also counts as one byte. for example, suppose the words arraylist stores the following words: { mary had a little lamb; its fleece was white as snow. } the filesize() method would compute 4 + 3 + 1 + 6 + 5 + 4 + 6 + 3 + 5 + 2 + 5 as the sum of the lengths of each string in the arraylist. the value returned would be this sum plus 10, because there would also be 10 spaces in between the 11 words. complete the filesize() method below: // postcondition: returns the number of bytes in this file public int filesize() { }

Answers: 1

Answer

You know the right answer?

PROJECT: DEVELOPING A SPREADSHEET Imagine you are working as a computer support technician for a la...

Questions