Thursday, March 31, 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                      X

Wednesday, March 30, 2011

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.

Tuesday, March 29, 2011

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

Tuesday, March 22, 2011

Database 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.


If it says summarise in a task, press the Sigma button.

Cheers Wilson Downes for some info for this blog.

Sunday, March 20, 2011

Creating 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.

Saturday, March 19, 2011

Databases

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.

Wednesday, March 16, 2011

Networks

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


WIFIWi-Fi (pronounced /ˈwaɪfaɪ/) is a trademark of the Wi-Fi Alliance. 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. WIFI when is overlapping will create a hotspot.


ISPAn 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. Hosting ISPs lease server space for smaller businesses and host other people servers (colocation). Transit ISPs provide large tubes for connecting hosting ISPs to access ISPs.


WANA 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). This is in contrast with personal area networks (PANs), local area networks (LANs), campus area networks (CANs), or metropolitan area networks(MANs) which are usually limited to a room, building, campus or specific metropolitan area (e.g., a city) respectively.

LANA 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. The defining characteristics of LANs, in contrast to wide area networks (WANs), include their usually higher data-transfer rates, smaller geographic area, and lack of a need for leased telecommunication lines.

IntranetAn 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. The term is used in contrast to internet, a network between organizations, and instead refers to a network within an organization. Sometimes the term refers only to the organization's internal website, but may be a more extensive part of the organization's information technology infrastructure. It may host multiple private websites and constitute an important component and focal point of internal communication and collaboration.

Sunday, March 13, 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.

Thursday, March 10, 2011

Storage 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 

Paper One

Paper one is theory here are some possible Q's:
Tick whether each one is either magnetic or optical media
Jaz Disk
DVD
Compact Disc
Zip Disc

for others go to www.kcict.net, got to the igcse part in downloads and get all paper 1 Q's

Thursday, March 3, 2011

Powerpoint Notes

Slide master is in the view member.


The masters text box's are only style e.g red font arial size 22 but if you want words you have to insert your own text box. Aso incudes page number, date etc.

Wednesday, March 2, 2011

My Favourite Lesson 3 March 2011

Today my favourite lesson was P.E. This was my favourite lesson because we played some cricket. We finished off our game from yesterday very convincingly beating the other team by 34 runs. We then diversified our teams. Then my team bowled (I'll just call us team awesome) and the other team are currently sitting on 54 at stumps. So on friday we have to go and bowl a few more overs then come out in prime form with the bat so as to achieve what could end up being a hefty total. Keen As!