All questions on Computing

Functions for a User-friendly Spreadsheet

What Functions could i use to create a User Friendly Excel Spreadsheet ?

Emma

Answers

What is the purpose of your spreadsheet? That's usually a good place to start.

jamxmitchell

18 October 2014

It's about Managing Finances

colouredsmurf

18 October 2014

I'm imagining that this is for adults managing personal finances, or is it for a company?Is this an assignment you've been given by your ICT teacher, because you're not giving very much information about what you need to include, or is this all the information you've been given?With anything involving finances, whether personal or professional the main concerns will be how much is coming in (earnings, wages, profit, tips, interest, whatever) and what is going out (expenses (rent, food and other bills if personal, materials, staff, other bills if professional)). From that total of "In" and total of "Out" you can calculate whether you're in the black (bring in more than what's going out) or in the red (more is being spent than is being earned).If I were to approach this I would make each sheet (at the bottom of the page) a new month, to show that you're managing money over a length of time.I'd identify how money is coming in (will be different is personal or business) and create categories for each of these in a column so you can add numbers in the adjacent (neighbouring) column. You can then use the Sum function in Excel to find the total of all money coming in. Then leave an empty column to visually separate the two, and find categories for money out (again, the list of these will be different for personal and business) and input the numbers next to it. Use the Sum function to work out the total money out.Then, find the cell reference (e.g. B27 or G4) and write a function along the lines of money in minus money out, to find out if you're in the black or red. For example, if the Sum total of money in is in cell B9 and the Sum total of money out is in D7, I'd type "=B9-D7" to get that answer.Once you've got this set up you can copy and paste onto another "month" (sheet) and change the values in the different categories, but as long as you don't change the functions of the Sum total on money in, Sum total of money out, and working out the difference it should tell you the correct answer for the values you put in each month. If you wanted to then track whether you're in the black or red each month you could put the values from each month into a new table and plot a line graph to see how productive you're being over a period of time.I hope this helps. You've not given us very much information about what you're being asked to achieve so this is just speculation. Check with your teacher that this is what you're being asked to do before spending too much time on it.

jamxmitchell

19 October 2014

Add an answer

information system and information technology concepts

identify how can we use IS and IT concepts to solve car accidents problem in Jordan?

Emma

What is Cyberspace and its advantages and disadvantages

I need as much information to make a speech

Emma

What does HTML stand for and do?

Hypertext Markup Language

As you can probably guess from the title, HTML stands for Hypertext Markup Language and is a language used by web browsers to interpret and represent text, images, videos, audio and other mediums for people on web pages. HTML defines the structure of a website while other technologies their appearance (CSS) and behaviour (JavaScript). "Hypertext" describes the links between pages of content on the web that you can access immediately by clicking on said link. "Markup" refers to the method by which text, images, and other content is annotated to then be displayed. Examples of the these markup elemetns include <head>, <title>, <body>, <header>, <footer>, <article>, <section>, <p>, <video>, <ul>, <ol>, <li> and many more.

What is HTML Used For?

HTML was first developed by physicist Tim Berners-Lee at CERN, the European Organization for Nuclear Research in 1990 when looking for a way that researchers could share documents with each other. This was the foundation of the World Wide Web. HTML allows people to create and design web pages using elements such as paragraphs, headings, links, quotes, images etc. It is not a programming language, so doesn't have a dynamic functionality, rather it helps to organize and format a page. It uses simple coding to denote how each part of the page should look. For example, you could create a paragraph by placing the relevant text within 2 tags <p> and </p>. HTML is now an official web standard which is monitored and developed by the World Wide Web Consortium (W3C

Emma

What is open source software?

Emma

I need some help with javascript

Emma

Cyberspace

Advantage and disadvantages

Emma

Importance of HTML

Why is HTML important?

Emma

WSN detecting bluetooth device

i'm trying to build a WSN which would detect a bluetooth device in a closed environment (eg:room)and track it in a map layout of the room(interface).

i would would like your suggestions on what device u would advice me to use. so far,i have been looking waspmote extension boards http://www.libelium.c..._sensors_over_zigbee

i need abit of a guidence so that i can make the first move

thank u

Emma

Wireless Sensor Network(waspmote IDE)

hi!i'm trying to build a wireless sensor network which could detect bluetooth devices in a room and track the device(on an overhead map layout of the room).i have been thinking of using waspmote extension board(http://www.libelium.c...xpansion_radio_board) inwhich uses two radios at the same time(bluetooth and zigbee radio).

my problem is,using waspmote boards would require to do the programming using "waspmote IDE" inwhich is similar to c++,i'm wondering how would i construct a map layout.

anyone having suggestings??

Emma

wireless sensor network

Hi Theo.i am wondering if you can give me a hand on building a wireless sensor network with the use of bluetooth dongle.the WSN should detect bluetooth devices and be able to track their movement(map layout,i.e interface) in a small room.

i haven't made a start yet because i'm stuck or knowing which programming language would suit this project

thanx

Emma

What's the importance of ICT in primary schools curriculum?

Emma

What's a good basic programming language to learn?

for a 12 year old who wants to learn the basics of programming?

Emma

What should I look before choosing a college for Engg or management studies

What are the factors i should check before deciding if a college is worht joining or not?

Emma

What is the difference between hardware and software?

Emma

what is the difference between a flat- file and a relational database

Emma

What is TCP/IP?

Can someone explain TCP/IP to me?

I have read Wikipedia yet I need someone to explain it simply to me.

Does anyone have any recommended videos perhaps?

Thanks,

Emma

what is margin of safety~?

Emma

What is a formula

Emma

what dose self-created interactive elements mean

GCSE ict

Emma

What can you tell me about CAD & CAM

Emma

what

How do I insert an image into a shape on Microsoft Word 2010

Emma

was is exel

Emma

Vector Differntiation

Prove that (grad)2 f(r) = D2/dr2 + (2/r) Df/Dr

Where D2/dr2 refers to the second partial derivative of f , w.r.t. r and

Df/ Dr refers to partial derivative of f, w.r.t r

vector r = xi + yj + zk and f(r) is twice differentiable

Emma

Urgent tutor help

I have an assignment on Java coding need help with it. The assignment detail is below :

The overall aim of this assignment is to implement a simple graphics tool. This must be built as a graphical application using the Java Swing and AWT classes. The software will allow users to type in simple commands which cause a “pen” to move around a virtual canvas area drawing lines as it moves. The final product should be a fully working application which includes a typical application window, containing a menu bar and supporting dialogue boxes.

As well as implementing a programmatic solution to the defined requirements, you are required to submit a graphical representation of your final solution as a Unified Modelling Language (UML) class model. This class model should show all classes used in your solution, along with all attributes and methods which you yourself have written. Although classes used from the Swing library should be shown there is no need to display their attributes and methods.

Requirement 1 – basic application

The first requirement is to develop a simple GUI which contains an outer window (frame), a canvas drawing area, a console type text input area, and a menu bar. The menu bar should contain at least a ‘File’ and a ‘Help’ menu. The ‘File’ menu should contain the options “New”, “Load”, “Save” and “Exit”. The ‘Help’ menu should contain an “About” option. The application window should be resizable by the user. For this first requirement the menu options should simply act as stubs, later requirements will provide the actual functionality. When selected each option should pop–up a dialogue saying that the option has been selected.

Requirement 2 – command support

The second requirement is to implement some basic commands to allow drawing. The users should be able to type in these commands within the console text area. The “New” menu option should cause the canvas to be cleared. The application should be able to spot invalid commands and report this to the user.

The commands to be supported are shown in the following table.

Command:Description penup: Lifts the pen from the canvas, so that movement does not get shown. pendown : Places the pen down on the canvas so movement gets shown as a drawn line. left : Turn the direction 90 degrees to the left. right : Turn the direction 90 degrees to the right. forward : Move forward the specified distance. back : Move backwards the specified distance. red : Sets the output pen colour to red. green: Sets the output pen colour to green. blue : Sets the output pen colour to blue. reset: Resets the canvas to its initial state.

Emma

System analysis and design

How to create relational databases?

Emma

Smart Devices

Which smart device is best? A smart phone, laptop, or tablet? What's best for a work team and why? What are the advantages and disadvantages of using each of these devices? Is apple better or android or something else? What smart device would you use for work purposes? What smart devices are useful for a work team to be able to share files, etc?

Emma

skool stuff

i need to concentrate more in classes, can any1 help plz!

Emma

Simple programming problem #1

Averages Make a program that asks the user for a series of numbers until they either want to output the average or quit the program. Extensions: 1. Expand the program to print the median and mode averages also 2. Include options so that if the user wants to, they can save their list of numbers to a text file and read them back out later on.

Emma

Programing is a tough subject?

Emma

PHP programming

Looking for a Tutor to teach me Object Oriented PHP.

Emma

Need Computing tutor for as level

Emma

magento tutorial

Emma

Java Assignment

Hi. I am stuck on this question. Any help will be appreciated. The overall aim of this assignment is to implement a simple graphics tool. This must be built as a graphical application using the Java Swing and/or AWT classes. The software will allow users to type in simple commands which cause a virtual pen (sometimes it is also called a turtle after the Logo programming language which was popular in schools in the 1980s) to move around a virtual canvas area drawing lines as it moves. The final product should be a fully working application which includes a typical application window, containing a menu bar and supporting dialogue boxes. You should use GraphicsPanel.java inside your program. It sets up a canvas for you to draw on and displays a simple turtle. You can modify it as you see fit. Requirement 1 – basic application 20 marks The first requirement is to develop a simple GUI which contains an outer window (frame), a canvas drawing area, a console type text input area, and a menu bar. Themenu bar should contain at least a ‘File’ and a ‘Help’ menu. The ‘File’ menu should contain the options “New”, “Load”, “Save” and “Exit”. The ‘Help’ menu should contain an “About” option. The application window should be resizable by the user. For this first requirement the menu options can be blank and have no attached functionality, subsequent requirements will provide the actual functionality. When selected each option should pop–up a dialogue saying that the option has been selected. Program runs Panel for drawing is displayed You need to demonstrate that the panel can be drawn on (note if you have implemented subsequent requirements they will do this). Console text area Note this could be the console itself or some sort of component such as a TextArea or TextField. You need to demonstrate that text can be entered and minimally echoed back (note if you have implemented subsequent requirements they will do this). (5 marks) File Menu Items with pop ups for each New (1 mark) Load (1 mark) Save (1 mark) Exit (1 mark) Help Menu About (1 mark) UML Diagram (10 marks) Should show internal detail of your classes (including GraphicsScreen.java). Any Swing/AWT classes or other external classes should be shown as boxes only. Requirement 2 – command support 35 marks The second requirement is to implement some basic commands to allow drawing. The users should be able to type in these commands within the console text area. The “New” menu option should cause the canvas to be cleared. The application should be able to spot invalid commands and report this to the user. The commands to be supported are very explicit and MUST match those shown in the following table. The command must be typed in by the user and not selected from a menu as some of them will have parameters which MUST be typed with the command, for example “forward 90”. The parameters must not be entered separately, either after the command or in a separate text field. These commands must not be entered using separate textfields for command and parameter. When the program first runs the turtle/pen should be set to the middle of the canvas and point down the screen and the pen should be set to “down”. Hence if the first command was “forward 100” a line from the middle of the screen to nearer the bottom would be drawn. Requirement 3 – loading, saving and exiting. 20 marks The main aim of requirement three is to implement the remaining menu options. The “Load” and “Save” should allow the user to select a file name via a dialogue box. The current image should then be either loaded or saved to a file. If the user attempts to load a new image without the current one been saved first then a warning dialogue should be shown to the user, which should provide the opportunity for the current image to be saved first. The “Exit” and “About” menu options should also be completed. During exit a similar check should be made to see whether the user is attempting to exit without saving changes.

Emma

Is an Comp Sci MSc worthwhile if I already have 20 years experience?

I've never been formally trained, always self taught, and I sometimes feel I should go back to formal education so round out my knowledge. Is it proven to be financially worth the time and tuition fees in the long run?

Emma

input and output devices

what are 2 input and output devices for : a. hospital b. animated film studio c. school

Emma

Information Retrieval

Hi, I'm stuck on evaluation, average precision, Im struggling to understand how to calaculate them. for example: A query has 6 relevant answers in a collection. In ranked order, the tigerland retrieval system returns the following results: (1) relevant; (2) irrelevant; (3) relevant; (4) relevant; (5) irrelevant; (6) relevant; (7) relevant; (8) relevant; (9) irrelevant; and (10) irrelevant. Calculate the average precision (AP). Answer: (1 + 2/3 + 3/4 + 4/6 + 5/7 + 6/8 ) / 6 Suppose that there is a seventh relevant item, which your system does not find. Does this affect average precision? Answer: Yes – the seventh (missed) item must be counted in the averaging (i.e. the denominator of the fraction becomes 7 instead of 6).

why and how can we get this answer? what are the steps to get the result?

Emma

ict short course cea

i need help asap exam is tomorrow

Emma

i need help in building a wireless sensor network

i'm really stuck in building a WSN which would detect bluetooth devices and track the targets movement on an interface.i need help,my deadline is in 2 weeks time!!it should use bluetooth dongle for detecting signal strength.i need help,plzzzzzzzzzzz

Emma

HTML CSS External Styles

write the required external CSS rules for the following :

Set the font size and font style , of the first bold word of all the paragraphs in a document into 14px and italic respectively.

Emma

How to create a simple website

Can anyone explain how to set up a simple website for my school project?

Emma

How does a inkjet printer work

Emma

How do you make a graph in Excel?

I need this by Wednesday please.

Emma

How do you create a flow chart?

Can I have this by the 22nd of June please??

Emma

How do you create a distribution list in Outlook

Emma

How do laser printers work

I understand inkjets squirt ink out, but I don't understand how light can be used to print a page

Emma

how do i setup protocols

Emma

Homework help for Ict

If you were given £100 and asked to buy additional or replacement hardware for a Desktop Computer, what would you buy, and why?

I do not understand this question, please help ASAP

Emma

hi , I looking for an person can help with artificial intelligence assignment

hi , I looking for an person can help with artificial intelligence. to pass do have any knowledge in that area." computer science

Emma

hi.

Hi. I have taken a new interest in the html and css, and I feel I have gripped html easily, but I am not very good at css. My question is, how do you have more than one div on the same line? Thank you, James Allison

Emma

give an example of a open question

Emma

GCSE low level programming

i have to write a program to run in LMC(little man computer) that takes two different numbers(user defined) and divides the larger by the smaller, the outputs the larger, then the smaller and the the quotient. some one please help me? its for 30% of my GCSE

Emma

Explanations on computers

could you explain all of these points please:

-Extent it Achieves Purpose of computers -How computers work -Benefits of computers -The limitations of computers

Emma

Could some one define these questions thanks

What dose these terms mean: domestic savings Metric breach Impared lending CONVO modle cross heratige acquisition

Emma

Computer Systems

Hi just wondering if anyone knows what factors a business owner should consider when considering purchasing computer systems?

Emma

Case of the missing crystal eggs. Use rough pseudo code to solve? Edit

CHALLENGE: Case of the missing crystal eggs

The scientists noticed a set of crystal eggs had been stolen when they reported to work early Tuesday morning. Reliable witnesses say the eggs were definitely there on Monday morning. The thieves must have come in sometime between Monday morning and Tuesday morning.

The camera system had been disconnected, but the laboratory had a backup system: a webcam took a picture of the crystals every 5 minutes and stored it securely. Every hour 12 pictures were taken, so in the 24-hour period, 12 * 24 = 288 pictures were taken.

Write rough pseudocode to find out the time of the crime as quickly as possible

Emma

C++

Given an integer K and a sequence integers, list the K largest integers from that sequence using c++

Emma

bluetooth sensor network detecting & monitoring bluetooth device

i would like to know appropriate devices i would need(type of sensor nodes,gateway)

Emma

before a metal article is plastic dip-coated it should be what

what is integer

Emma

BBC Bitesize

Its sooo booring. Everyone says use it. But its boring.

Emma

Assignment Help Please

Your boss at Innovations R Us, Rita Webb, has agreed to equip a selected work team with SMART devices. Instructions: 1. Rita asks you to prepare a report for the Purchasing Committee that will analyse the advantages and disadvantages of each type of device for the staff team to use. Relevant factors could be:  Specific features/advantages at least 2 devices relevant for a specific work team  Purchase price/budget considerations  Ongoing costs/future proofing  Information technology trends for business use  Need for staff training  Operability with existing operating systems/technology platforms e.g. Windows, iOS or Android  Other relevant issues such as types of software to be run 2. Innovations R Us is an authorised reseller of IT equipment. As the report author, you are free to make any realistic assumptions about this NZ based company and its operations. However the information presented about the appropriate technology, must be from actual acknowledged sources. E.g. online publications and web sites of similar businesses. 3. The report will need to come to some valid conclusions and make recommendations based on your investigation. 4. The report must be structured according to an acceptable format such as found at: http://www.monash.edu...ogy/report/1.3.3.xml and will include:  Cover page  Table of contents  Introduction  Relevant sections/subsections  Conclusions  Recommendations  Reference list/bibliography  Appendices (where relevant) 5. References must be formatted using APA (MS Word APA acceptable)

Emma

advantages of cyberspace

Emma