Wednesday, December 2, 2009
Tuesday, October 20, 2009
Friday, October 2, 2009
excel assignment
Wednesday, September 23, 2009
microsoft excel work sheet 2
microsoft excel work sheet 2
Monday, September 14, 2009
assignment #1
Name: Dane Leung
ID#:18085002
Course: Computer Application
The Internet- Essential Introduction to Computer
- Define terms associated with the internet.
* (LAN)-Local Area Network
* TCP/IP-Transmission Control Protocol and Internet Protocol.
* URL-Uniform Resource Locator
* WWW-World Wide Web
- Differentiate between the internet and the World Wide Web.
- Internet, computer –based global information system, the internet is composed of many interconnected computer networks.
- World Wide Web (WWW), computer based network of information resources that combines text and multimedia, information on the (WWW) can be accessed and searched through the internet.
- State what hardware devices and software devices are important to connect to the internet.
* Hardware- modem, internet server
Software- World Wide Web, Web sites
Ethical Behavior
- Discuss ethics and provide several examples of ethical Misbehavior.
- Ethics is the principles or the standards of human conduct sometimes called morals eg. Of ethical misbehavior are stealing, killing, lying, child abuse, sexual offenses.
- Identify viruses and describe how they work.
- parasitic or file viruses- infects executable files or programs in the computer
- boot strap-sector viruses reside on the first portion of the hard disk or floppy disk , known as the boot sector
- Trojan Horse a destructive program disguised as a game, a utility , or an application
- Worm virus a program that propagates itself across computer usually by spawning copies of itself in each computer memory
- Script viruses are written in script programming languages, such as VBScript ( Visual Basic Script) and Java Script.
- Describe how to avoid computer viruses.
* Fire walls- computers connected to communications network , such as the internet are vulnerable to electronic attacks because so many people have access to them, these computers can be protected by using fire wall computer software placed between the networked computers and the network.
assignment #2
INTRODUCTION
Excel Spreadsheet is an application made and distributed by Mac OS X by Microsoft for Microsoft Windows. Allows the user to use calculation tools, graphing tools and pivot tables. The programme uses a language called VBA (visual basic application). Five of Excel Spreadsheet features about to be discussed are Sum, Average, Minimum, Maximum and Count.
SUM
The sum function adds the cells together.
Example: =SUM(A1,B1)
In this function: equal sign starts the function.SUM is the name of the function. A1, and B27 are the cells. Parentheses enclose the cells. A comma separates the cells.
AVERAGE
In excel spreadsheet the average function returns the average or arithmetic mean of the numbers provided.
Example: =AVERAGE(A1:A8)
In this function: The equal sign begins the function, AVERAGE is the name of the function. A1 to A8 are the cells. Parentheses enclose the cells. A colon separates the range.
MINIMUM
In Excel Spreadsheet the MINIMUM function returns the minimum value within a range of cells.
Example: =MIN(A1:A100)
In this function: The equal sign begins the function, MIN is the name of the function. A1 to A100 are the range of cells. Parentheses enclose the cells. A colon separates the range.
MAXIMUM
In Excel Spreadsheet the MAXIMUM function returns the maximum value within a range of cells.
Example: =MAX(A1:A100)
In this function: The equal sign begins the function, MAX is the name of the function. A1 to A100 are the range of cells. Parentheses enclose the cells. A colon separates the range.
COUNT
Excel Spreadsheet the COUNT function totals the number of cells in a selected range.
Example: =COUNT(A1:A6)
In this function: The equal sign begins the function, COUNT the name of the function. A1 to A6 are the range of cells. Parentheses enclose the cells. colon separates the range.
CONCLUSION
Microsoft excel is a good program it make tables easy to use with its simple task functions and it commands and i look forward to using it