Networks

You will use the following likes to learn more about networks and home networks

Networking basics

Home Networking

Wired network

Switches - How does a switch work?

How does a router work?

What is the Internet?

Take the Home Network Quiz

Microsoft Access Assessment

Please note that your Accessment for the Microsoft Access is a demonstration of the following skills:

1. Understanding of the Database, Database Management Systems and using Microsoft Access
2. Create tables and use appropiate datatypes in Microsfoft Access
3. Understanding referencial integrity and creating relationships between tables
4. Creating Query on a database in Microsfoft Access
5. Creating reports in Microsfoft Access

You can demonstrate the above key skills by completing the tutorial exercise.  You need to create tables, define relationships, create queries and reports in this tutorial exercise.

Excel Exercise - FRIDAY August 16

All Students Please start on this activity today

Please save the following file to your folder and start on this activity today.
Click on the link, then save the file to your work area.

http://www.abs.gov.au/websitedbs/CaSHome.nsf/home/downloadable+files.es/$FILE/Excel2010+Skills+What+Graph+Or+Display+To+Use+When.docx

Microsoft EXCEL - Monday August 5 2013

Introduction to Microsoft Excel-

Step through the following tutorial to begin your first lesson in Microsoft Excel:

http://office.microsoft.com/en-us/excel-help/get-to-know-excel-2010-create-your-first-spreadsheet-RZ101773335.aspx?CTT=1

 

 

Software and Hardware Questions

1. What is the difference between software and Hardware ?

2. Name 3 input and 3 output devices and describe what is inputed or outputed by the device

3. Is the USB Drive and Input or Output Device ?

4. Can the firmware of the hardware equipment be accidentally deleted by a user

5.Name three different operating systems and the type of hardware they are designed for

6. Name three application software and the application that they are used

7. Describe one system utility and what it is used for ?

Computer Hardware

You can further explore in detail how personal computer components work by following link:
http://computer.howstuffworks.com/computer-hardware-channel.htm.

You are to review the information and post a reply about one piece of new information you learnt from the hardware channel that has not been presented in class.  Also you can not memtion anything another student has posted in a reply so get in early.

Hardware Assignments

Your Assessment for the hardware topics are as follows:
TASK 1. PowerPoint Presentation of Hardware Components

You are to prepare a Powerpoint Presentation outlining the components of a computer and provide details of each components functions.  The parts must include at least the following:

1. Motherboard
2. CPU
3. Random Access Memory - RAM
4. Hard Disk Drive - HDD
5. Video Display Card
6. Case with Power Supply
7. Mouse
8. Keyboard
9. Video Display Unit (Monitor)

TASK 2
Build A Computer:

You are to visit an online PC parts retailer and select components to build a computer. You have a budget of $1500 for all hardware, software and a Printer.  You must specify the type of printer and justify your choice.

You can use the Centrecom PC builder, located at www.centrecom.com.au/buildpc
to pick and price your parts, and once satisfied, copy the specification and price to an Excel Spread sheet.

Another website to use is www.auspcmarket.com.au. It has prices for all computer parts and components. You may use other websites, however each part needs to have a price and identify the source with the website address. You may also use any print media advertisements as well to price your parts.  All prices quoted must have a reference to the shop or online store that advertises that price.


 You need to specify the parts and specification of all the software and hardware required for your computer. The computer must be capable of being used as a student PC to complete all your school work. Your parents may also need to use it for business applications as well.

You need to specify all the hardware and software components. You may use Excel and add up individual prices using the summing function within Excel.