Labels

ICT (23) Theory (17) Practical (6) Software (6) Paper1 (5) Access (4) Components (4) Hardware (4) Paper 2 (4) Syllabus (4) Learning (3) Paper3 (3) Link (2) Database (1) Excel (1) Facebook (1) Interface (1) Powerpoint (1) Storage Devices (1) Twitter (1)

Wednesday, May 18, 2011

Fax, tele/video conferencing, LAN/WLAN/WANs, intranet, Hub/Bridges/Switches, Proxy Server.

If you sign a fax and sign it, they  can hold it up in a court of law, if you email something with your signature, it cannot be. Faxes are also a huge security risk, the have a delay (who will be there to pick it up) but are faster to get a hard copy to someone.

tele/video conferencing (example: skype) main benefit is multiple people, a group. It allows you to show 'material'.

Local Area Network- is a network on one site.
When two lans come together you have WAN, 2 sites. To create a LAN you need network cables, switches, hubs, and bridges. To create a wireless WAN you need an access point so it can be linked onto the LAN. Equipment for a WAN- you need a router at either end. WLAN allow for wireless devices. WLAN is a wireless LAN.

Intranets are also only accessed by passwords, it is an internal website, for when you are only on-site. Intranet is just web technologies being used inside you business/school.

A Hub is a very confused box, it takes one thing in and broadcasts it multiple times/ways; 'Multi Broadcasting' and much slower.
Bridges are used to organise a LAN, they are intelligent, they are used to maximize the speed of sending a signal. If you have a private line, you 'don't' need a router at each end, it can send it straight from LAN to LAN.
A Switch, has overtaken the Hub, it holds a lost of everyone's IP address of anyone who connects to it, it manages the traffic going through it, it broadcast the signal down only one line, unlike the Hub.
A Proxy server makes your connection tot he outside world anonymous. It can log activity, and manage bandwidth.

Tuesday, May 17, 2011

(Dis)Advantages of the internet, IDs and PWs

+
It eases communication of files (and other stuff). Reduce amount of training required. Provides a common recognisable interface. Share resources.

-
Hacking (unauthorised access), viruses, loss of resource (if network goes down).

ID's and Passwords are used to divide the information between people, and also group accounts into authorisation (staff/students at school)

Monday, May 16, 2011

Router, WiFi, Bluetooth, Setting up a network.

Router sits between 2 networks. It goes to your ISP first. ISP is a network that dishes out numbers. The tele communication can only give out so many numbers, so it gives your router a number.  The router is a way of dividing 2 networks up, it passes info thats going around one network to another network, keeping the traffic separate.  Routers control traffic.

WiFi- transferring data between devices without the need for a physical connection. It is faster than Bluetooth.
Bluetooth is used to transfer small files between mobile devices. When you use a bluetooth connection, the network is being run off your device (phone for example). To run of a wireless network, it must be being run somewhere.  Bluetooth is between two devices only.

To sep up an network for the internet, you need an ISP, software.

Tuesday, April 5, 2011

Dreamweaver

HTML vs CSS

Hypertext markup language places things, make pieces of text go where they go; it puts things in places.

Cascading Style Sheets are the styles of the web page, it allows you change things about the website such as the font or they way links are shown. Like this, or this.

Monday, April 4, 2011

Questions on Storage Devices

The RED writing is the answers.

RAM and ROM are types of storage.
(a) Explain the major difference between RAM and ROM:

RAM is random access memory and is read only memory.

Ring two items which are storage media.
A. Flash memory card 
B. Graph plotter
C. Magnetic disc
D. OCR
E. OMR
F. Touch pad


Ring two items which are magnetic storage media.
A. CD ROM 
B. DVD ROM
C. DVD RW
D. Floppy disk
E. Hard disk
F. Memory stick

Ring two items which are storage media.
A. Bar code reader
B. DVD RAM
C. Joystick
D. Magnetic tape
E. Sensor
F. Touch screen

                                                                                                    True     False       

Backing storage devices are examples of software

Thanks to Clapham  : )

The use of backing storage at KC

Use of Backing Storage at Kings College

  • Fixed hard discs- Used in every computer in the school
  • Portable hard discs- Used to store large files
  • Magnetic tape- Uses serial access for reading and writing.  Used for backups of file servers for computer networks. Optical backing storage media such as CDs and DVD and is quite cheap for backing up files at King's.
  • Optical backing storage media such as CDs and DVD-CDs tend to be used for large files (but smaller than 1Gb) which are too big for a floppy disc to hold such as music and general animation.  DVDs are used to hold very large files (several Gb) such as films at school.
  • CD ROM/DVD ROM-Applications which require the prevention of deletion of data, accidental or otherwise for students.
  • CD R/DVD- Applications which require a single burning of data, e.g. CDs Z recording of music downloads from the internet, recording of music from MP3 format, recording of data for archiving or backup purposes at King's.
  • CD RW/DVD RW-Applications which require the updating of information and ability to record over old data at King's.
  • DVD RAM- Same properties as DVD RW but quicker access and data can be overwritten more easily. 
  • Blu-ray-Capacities of 25Gb, 50Gb and 100 Gb.  Used for storing films (movies). 25Gb equates to 2 hrs HDTV, 13hrs standard definition TV
  • Solid state backing storage-Smallest form of memory, used as removable storage at school.  More robust than other forms of storage. 
  • Memory sticks/Pen drive-Used at Kings to transport small files conveniently.
  • Flash memory cards-Used in digital cameras, palmtops, mobile phones, MP3 players at Kings

Thanks Robert Sheetz for this.

Why back up?

Why Back Up?
You should back up you data because, if your computer is hacked, there is a power surge(which could fry your mother board, destroying the file that you had saved it to), or your computer just dies in general. All of these things would result in your loss of data if you hadn't backed them up.

On to What?
You could back up your files onto an external hard drive that you could remove afterwards and store somewhere safe, or you could back it up onto the hard drive in your PC but there are the risks that I have mentioned above.

How Often?
Ideally you should back up your data every few hours but being realistic you should try and do it once a day or so

Thanks to Clapham

Privacy

Parents worry about disclosures. Facebook rewards disclosure with attention (social stimulus). Feedback with action make us better at task (taking photos). When the reaction is far away it doesn't make enough of a difference. Competitors want their social network to be more private and less creepy. School blocking websites such as FB make kids using the internet learn less about using it well. Kids should be taught to examine things and find out how to get around their own neighborhoods without being seen by CCTV. 

Tuesday, March 22, 2011

Making a Report

Go the the report wizard, do not make it from the table, make it from the query.
Press the arrow or double arrow to get the Available Fields across.
Modify whichever fields are necesary in the remaining pages, depending on what the exam asks for.

Sunday, March 20, 2011

Microsoft Access

Step 1. Open up access and create new BLANK database called the Exam Name.
Step 2. Click on External Data, then Text File.
Step 3. Then import steps 2,4. (If your in Mr Wells class you will get it.)
Step 4. Then browse for the file in my case it was J8prods, then click finish.
Step 5. Then right-click on the tab in the top left and click on Design View.
Step 6. Change the categories to what you need to, however on the 08 and previous exams they made a mistake so you need to change the Yes/No to Text to keep the Y's and N's. You don't need to do this for exams past 2008.
Step 7. Click continue on the next few bars that come up, it will display a gray screen. Double-click on the name of your database and you have finished Q1.

Databases - Queries - Reports

A table is cut down by a query with criteria which is outputed as a report with a title.


The table is full of info, when you search a query, it cross checks all info in the table with criteria, this is then put into a report. The report is to make the databases results look good.




As you can see in this example the criteria was that the boys had to be 16 years old and from Remuera.
So as only Jon and Tim were from Rem, they fitted the criteria and so were put into the report.

A query is the cut down form of the table.

Microsoft Access

In access, when making a new database name it after the exam. When importing click on external data. csv files are under text files. To look at the types of data in each column, R-click on the title of the table, then click on design view. Boolean are yes/no questions. When importing a file, page 2 and four need a tick, that's all.

Thursday, March 17, 2011

Database Tables

A table is cut down by a query with criteria which is outputed as a report with a title. Eg;

Table > (query/criteria) > report


The table is full of info, when you search a query, it cross checks all info in the table with criteria. For example:

A table of everyone's ages, houses, addresses, and names. If you made a query with the criteria of 16 and in Remuera, you'd get everyone matching both of those. Should someone be 16 and live in Parnell, they would not be included. After the query has been made, this is taken and made 'prettier' by putting it into a report.

Networks

A Router

A router is a device that forwards data packets across computer networks. Routers perform the data "traffic directing" functions on the Internet. A router is a microprocessor-controlled device that is connected to two or more data lines from different networks. 

WIFI

A Wi-Fi enabled device such as a personal computer, video game console, smartphone, or digital audio player can connect to the Internet when within range of a wireless network connected to the Internet.

ISP

An Internet service provider (ISP) is a company that provides access to the Internet, hosts data, or does both. Access ISPs connect customers to the Internet using copper, wireless or fiber connections. 

Browser

A web browser or Internet browser is a software application for retrieving, presenting, and traversing information resources on the World Wide Web. 

WAN

A wide area network (WAN) is a computer network that covers a broad area (i.e., any network whose communications links cross metropolitan, regional, or national boundaries). 


LAN

A local area network (LAN) is a computer network that connects computers and devices in a limited geographical area such as home, school, computer laboratory or office building.

Intranet

An intranet is a private computer network that uses Internet Protocol technology to securely share any part of an organization's information or network operating system within that organization.

Tuesday, March 15, 2011

Inputs and Outputs

Output_devices: Printers e.g Laser, Ink Jet, Speakers,CRT monitor, TFT monitor, Dot Matrix Printer,


Graph Plotter.   




Input_device: Sensors e.g Pressure, Temp., Optical Mark Reader, Optical Character Reader, Bar-code Reader,    


Light Pen:    Used like a mouse where desktop space is limited.

Sorage Devices and Media

Fixed Hard Disks: Used to store operating systems,software and working data.

Portable Hard Disks: Used to store very large files which need transport from one computer to another.

Magnetic Tapes: Any application which requires extremely large storage capacity and speed of access is not an issue. Uses serial access for reading and writing.  Used for backups of file servers for computer networks.  Used in a variety of batch processing applications such as reading of bank cheques, payroll processing and general stock control.


Optical backing storage media such as CDs and DVDs: CDs tend to be used for large files (but smaller than 1Gb) which are too big for a floppy disc to hold such as music and general animation.  
DVDs are used to hold very large files (several Gb) such as films.  Both 
CDs and DVDs are portable i.e. they can be transported from one 
computer to another.  Both can be used to store computer data 


CD ROM/DVD ROM0: Applications which require the prevention of deletion of data, 
accidental or otherwise.  CDs used by software companies for 
distributing software programs and data; by music companies for 
distributing music albums and by book publishers for distributing 
encyclopaedias, reference books etc.  DVDs used by film distributors 


CD R/DVD R Applications which require a single ‘‘burning’’ of data, e.g. CDs –– 
recording of music downloads from the internet, recording of music 
from MP3 format, recording of data for archiving or backup purposes.  
DVDs –– recording of films and television programs 


CD RW/DVD RW Applications which require the updating of information and ability to 
record over old data.  Not suitable for music recording but is very 
useful for keeping generations of files.  DVDs have between five and 
ten times the capacity of CDs 


DVD RAM Same properties as DVD RW but quicker access and data can be 
overwritten more easily.  Similar to floppies in nature but has 3000–– 
6000 times more storage and uses optical technology 


Blu-ray: Capacities of 25Gb, 50Gb and 100 Gb.  Used for storing films (movies). 
25Gb equates to 2 hrs HDTV, 13hrs standard definition TV.  It is 
possible to playback video on a disc while simultaneously recording HD 
video.  (Will be) used for storage of PC data 


Solid state backing storage: Smallest form of memory, used as removable storage.  More robust 
than other forms of storage.  More expensive than other forms, but 
can be easily written to and updated 


Memory sticks/Pen drives: Can store up to many Gb.  Used to transport files and backup data 
from computer to computer 


Flash memory cards: Used in digital cameras, palmtops, mobile phones, MP3 players

Sunday, March 13, 2011

IGCSE Syllabus Section 3

Section 3: Storage devices and media
Candidates should be able to:
(a) describe common backing storage media (including magnetic tapes, hard discs, all forms of CD and
DVD, memory sticks, flash memory) and their associated devices
(b) identify typical uses of the storage media, including types of access (e.g. serial/sequential, direct/
random) and access speeds
Media Use
Magnetic backing storage media
Fixed hard discs Used to store operating systems, software and working data. Any
application which requires very fast access to data for both reading and
writing to. Not for applications which need portability. Used for online
and real time processes requiring direct access. Used in file servers
for computer networks
Portable hard discs Used to store very large files which need transporting from one
computer to another and price is not an issue. More expensive than
other forms of removable media
Magnetic tapes Any application which requires extremely large storage capacity and
speed of access is not an issue. Uses serial access for reading and
writing. Used for backups of file servers for computer networks. Used
in a variety of batch processing applications such as reading of bank
cheques, payroll processing and general stock control

4. Curriculum content
Optical backing storage media
such as CDs and DVDs
CDs tend to be used for large files (but smaller than 1Gb) which are
too big for a floppy disc to hold such as music and general animation.
DVDs are used to hold very large files (several Gb) such as films. Both
CDs and DVDs are portable i.e. they can be transported from one
computer to another. Both can be used to store computer data
CD ROM/DVD ROM Applications which require the prevention of deletion of data,
accidental or otherwise. CDs used by software companies for
distributing software programs and data; by music companies for
distributing music albums and by book publishers for distributing
encyclopaedias, reference books etc. DVDs used by film distributors
CD R/DVD R Applications which require a single ‘‘burning’’ of data, e.g. CDs ––
recording of music downloads from the internet, recording of music
from MP3 format, recording of data for archiving or backup purposes.
DVDs –– recording of films and television programs
CD RW/DVD RW Applications which require the updating of information and ability to
record over old data. Not suitable for music recording but is very
useful for keeping generations of files. DVDs have between five and
ten times the capacity of CDs
DVD RAM Same properties as DVD RW but quicker access and data can be
overwritten more easily. Similar to floppies in nature but has 3000––
6000 times more storage and uses optical technology
Blu-ray Capacities of 25Gb, 50Gb and 100 Gb. Used for storing films (movies).
25Gb equates to 2 hrs HDTV, 13hrs standard definition TV. It is
possible to playback video on a disc while simultaneously recording HD
video. (Will be) used for storage of PC data
Solid state backing storage Smallest form of memory, used as removable storage. More robust
than other forms of storage. More expensive than other forms, but
can be easily written to and updated
Memory sticks/Pen drives Can store up to many Gb. Used to transport files and backup data
from computer to computer
Flash memory cards Used in digital cameras, palmtops, mobile phones, MP3 players
Candidates should be able to:
(c) describe the comparative advantages and disadvantages of using different backing storage media
(d) define the term backup and describe the need for taking backups
(e) describe the difference between main/internal memory and backing storage, stating the relative benefits
of each in terms of speed and permanence

IGCSE Syllabus Section 2

Section 2: Input and output devices
Candidates should be able to:
(a) identify the following input devices:
keyboards, numeric keypads, pointing devices (including mouse, touch pad and tracker ball), remote
controls, joysticks, touch screens, magnetic stripe readers, chip readers, PIN pads, scanners, digital
cameras, microphones, sensors, graphics tablet, MICR, OMR, OCR, barcode readers, video cameras,
web cams, light pens
(b) identify suitable uses of the input devices stating the advantages and disadvantages of each:
Device Use
Keyboard Entering text into a word processing document. Applications where text
has to be created rather than copied
Numeric keypad Applications where only numeric data is to be entered. Inserting personal
identification number (PIN) for Chip and PIN credit/debit cards, or when
using an ATM machine to withdraw money or check a bank balance
Pointing devices –– all All applications which require selection from a graphical user interface. For
example: the selection of data from a set list or menu
Mouse In most PCs
Touchpad On laptop computers
Trackerball For use by people with limited motor skills e.g. young children or people
with disabilities
Remote control Using remote control devices to operate TVs, video players/recorders,
DVD players/recorders, satellite receivers, HiFi music systems, data or
multimedia projectors
Joystick Used by a pilot to fly an aeroplane or flight simulator. Used in car driving
simulators and for playing games
Touch screen Selecting from a limited list of options e.g. certain POS uses such as cafes,
tourist information kiosks, public transport enquiries. May be used for
handwriting recognition in a PDA or Tablet PC
Magnetic stripe readers At POS terminals, ATMs and in security applications
Chip readers and PIN pads Payment cards, ID cards, door control systems, public transport tickets
Scanners Entering hard copy images into a computer
Digital cameras Taking photographs for input to computers, for input to photo printers
Microphones Recording of voices for presentation software
4. Curriculum content
Sensors (general) in control and measuring applications, see section 7.1
Temperature sensor Automatic washing machines, automatic cookers, central heating
controllers, computer-controlled greenhouses, scientific experiments
and environmental monitoring
Pressure sensor Burglar alarms, automatic washing machines, robotics, production line
control, scientific experiments and environmental monitoring
Light sensor Computer controlled greenhouses, burglar alarm systems, robotics,
production line control, scientific experiments and environmental
monitoring
Graphics tablet Inputting freehand drawings or retouch photographs
Optical Mark Reader Inputting pencil marks on a form such as a school register, candidate
exam answers, any application involving input of a choice of options
Optical Character Reader Inputting text to a computer ready for processing by another software
package such as word processors, spreadsheets, databases etc.
Bar code Reader Inputting code numbers from products at a POS terminal, library books
and membership numbers
Video camera Inputting moving pictures, often pre-recorded, into a computer
Web cam Inputting moving pictures from a fixed position into a computer
Light pen Where desktop space is limited, it is used instead of a mouse or for
drawing applications where a graphics tablet might be too big
4. Curriculum content
Candidates should be able to:
(c) identify the following output devices: monitors (CRT, TFT), projectors, printers (laser, ink jet and dot
matrix), plotters, speakers, control devices –– motors, buzzers, lights, heaters
(d) identify suitable uses of the output devices stating the advantages and disadvantages of each:
Device Use
CRT monitor Applications where space is not a problem. Applications where more than
one user may need to view screen simultaneously such as in design use,
e.g. when several designers may need to offer suggestions on a prototype
TFT monitor Applications where space is limited such as small offices. Applications
where only one person needs to view the screen such as individual
workstations
Multimedia Projector Applications such as training presentations, advertising presentations and
home cinema –– it displays data from computers, pictures from televisions
and video/DVD recorders
Laser printer Applications which require low noise and low chemical emissions, e.g. most
networked systems. Applications which require rapid, high quality and high
volumes of output, e.g. most offices and schools
Inkjet printer Applications which require portability and low volume output, where
changing cartridges is not an issue e.g. small offices and stand alone
systems. Applications which require very high quality output and where
speed is not an issue, e.g. digital camera applications
Dot matrix printer Applications where noise is not an issue and copies have to be made, e.g.
industrial environments (multipart forms, continuous stationery, labels etc.),
car sales and repair companies, manufacturing sites
Graph plotter CAD applications, particularly where large printouts are required such as A0
Speakers Any application which requires sound to be output such as multimedia
presentations and websites including encyclopaedias. Applications that
require musical output such as playing of music CDs and DVD films
4. Curriculum content
Control devices in Control applications, see section 7.1
Motors Automatic washing machines, automatic cookers, central heating controllers,
computer-controlled greenhouses, microwave ovens, robotics, production
line control
Buzzers Automatic cookers, microwave ovens
Heaters Automatic washing machines, automatic cookers, central heating controllers,
computer-controlled greenhouses
Lights/lamps Computer-controlled greenhouses

IGCSE Syllabus Section 1

Candidates should be able to:
(a) define hardware, giving examples
(b) define software, giving examples
(c) describe the difference between hardware and software
(d) identify the main components of a general-purpose computer: central processing unit, main/internal
memory (including ROM and RAM), input devices, output devices and secondary/backing storage
(e) identify operating systems, including those which contain a graphical user interface, a command line
interface
(f) identify different types of computer including Personal Computer or desktop, mainframe, laptop, palmtop
and Personal Digital Assistant
(g) describe recent developments in ICT

Monday, March 7, 2011

Twitter's part in the Chrictchurch Earthquake

Twitter helped people in the Christchurch because it gave a chance for the victims or their friends/family to communicate instantly. It gave a way for anyone with an IPhone or access to internet and trapped to ask for help, or if not trapped to tell people that. It allows people to tell everyone they’re ok, or to coordinate themselves. It allows family to regroup, or friends to check if they’re alive.  People have been offering help, or asking if it has been.  Twitter has helped people spread their love and anguish too. Some examples are:
"I think all of us freaked out tweeters need a convent or something to hide in til the ground stops shaking," Bex Davies wrote in between aftershocks measuring 5.2 and 5.4.
"Enough with rocking my bed already," Megan Campbell wrote a few moments later.
"I wanna sleep and this is just making me all nervy."
There have been so many aftershocks since the initial earthquake - at least 200 before midday yesterday - that Cantabrians have taken to guessing the magnitude of each one before GeoNet publishes their data online.
Meanwhile Kalena Jordan, the woman who posted that single-word tweet of warning moments after the first quake, has gathered up other Twitter users' first earthquake tweets and published them in a single blog entry.

It’s also allowed people to talk about it freely:
Good morning from wobblesville. A night of aftershocks and yes they are still going. Everyone just pauses and then gets on with it.
- Justin Hygate (Twitter)

What will all the #eqnz broken brick chimneys be replaced with? More brick?
- Greg Comfort (Twitter)

At around 5am a very drunk driver pulled up outside our house and asked "What happened?"
- Reg Blackwood (Twitter)

hmmm bet John & Lisa are glad they moved - just watching their old house on the news.
- Rachel Ah Kit (Twitter)


Twitters functions are the search box at the top of the site, allowing quick and simple searching of all ‘Tweets’. Also, another function which has been incredibly helpful is the # grouping, allowing instant group creation. Where as in Facebook, the group is created slower, and you need to be friends with people to join and so on and so on.
Twitter is good in a crisis because it is instant. It has also allowed for crises to happen, such as in Egypt and Libya. Twitter is ‘now’ and global, these are the main reasons why it was such a great help for all of the people. Twitter allowed people to organize help faster than txt because it’s to everyone, not to just people whose phone numbers you already have.
Twitter is better than Facebook for these reasons:
1.Tweets get quick attention than facebook updates.

2.You can follow more people quickly in twitter when compared to facebook.

3.You can have more contacts in twitter when compared to facebook.You can only have a maximum number of 5000 friends in facebook.

4.You are not restricted to follow more new people until your following limit reaches 2000.Unlike in twitter,facebook has more restrictions for adding new people.You are able to send more friendship requests based on the approval of your friendship requests from others.For example,if your friendship requests sent to others not approved,you are temporarily banned for adding friends in facebook.

5.You are able to get other’s updates easily just by following them in twitter.But in facebook you must add the person as a friend to get their updates.

6.Twitter has less privacy settings when compared to facebook which lets us to get more online exposure.

7.Unlike in facebook,you dont have to waste your worthable time like playing online games,useless pokes and tags from friends in twitter.

8.More desktop clients are available for twitter when compared to facebook.

9.Monetizing twitter is easy for every twitter users and time consuming when compared to monetizing facebook.

10.You can able to get quick reply for your update from your twitter network when compared to your update in facebook.

11.Unlike in twitter,you can only send a bulk message to a list having a maximum of 20 conatcts in facebook.You can add many people in many lists but you can only send a message to a list which has maximum 20 contacts.Unlike in twitter,messaging to other people in facebook needs word verification if you send more messages.

12.Navigation inside twitter is easy when compared to facebook.

13.Your followers and the people followed by you are not able to write or post anything in your twitter wall(What’s happening) but in facebook you friends are able to write or post anything in your wall unless you restricted your privacy settings.

Thursday, March 3, 2011

Power Point: Master Slide

Powerpoint: slide master ONLY does style and fonts. Also on the slide master to do page number you must delete it and put another
text box in with page number. Same goes for date, author and stuff. Any words you want to be on EVERy slide must be in your own text
box on the master slide.

Wednesday, March 2, 2011

My favorite lesson Thursday 3/3/11

My favorite lesson from today was Latin. We just went over some simple epigrams that we were asked to translate for prep yesterday. We talked about a few of them, and during one we managed to ask a few good questions and distracted Mr. Jackson for a good 10 minutes. During the 10 minutes he told us some interesting stuff, which was semi-related, but off-topic enough for our liking. Then towards the end of the period we were told to begin on a new translation about Agricola's message to the Emperor claiming victory over the Scots in Britain. I managed to do significatnly more than usual without looking into the back of the book for help in translation. That was what made my lesson awesome.

Sunday, February 20, 2011

Excel

When opening a .csv in an exam, save it as a non-.csv file as soon as possible. Save it as a Excel Workbook. SAVE AS EXCEL
SAVE AS EXCEL

1. Import .csv (comma separating value) standardized format for all computers
2. Absolute and relative cell references (A1 refers to that cell) formula changes to where you've copied from.
3. Names cells, named ranges.Changes the name of a cell/s to insure an absolute reference. Makes reading formulas easy.
4. Sum, average, maximum, minimum, integer, rounding, counting, if, lookup.
5. Perform searches (filter) using AND, OR, NOT, LIKE, >, <, =, <=, >= (cuts down the stuff you see).
6. Perform searches using wildcards (this is where you use a *). If you said *th, you'd get anything ending in 'th e.g: beTH. th* would give anything starting with 'th'. They broaden searches.
7. Sort data

All formulas have thier own name, start with =, and have brackets.
When naming a cell, press enter otherwise it won't work.

SAVE AS EXCEL

Thursday, February 17, 2011

Tuesday, February 15, 2011

This is a PDA or personal digital assistant <<<



               This is a palm Top^^^


<<<This is a mainframe computer

Wednesday, February 9, 2011

Hardware/software

Hardware: Physical component of the system (printer, mouse)
Software:  Non-physcial components. (control pannel, system preferences, programs)    3 Types = Utility, application, operating system.

Components: Input (magnetic character reader, keyboard, lightpen), CPU, RAM (random access memory (volatile/always changes)) / ROM (read only memory (non-vaolatile)), Secondary Storage (hardrive), Output (printer).
Pimary Memory is closest to the CPU, which is RAM/ROM. Secondary storeage is the hardrive.

Interface: One thing talking to another, allows communiction. Allowing you to talk to the machine.Types:  GUI (graphical user interface). GUIs are WIMPS (Windows, Icons, Menus, Pointers) Command Line Interface.