HSC
HSC 2008 Norman Vuong

Nov
07

Overview
Computer Management is a collection of Windows administrative tools that you can use to manage a local or remote computer. The tools are organized into a single console, which makes it easy to view administrative properties and to gain access to the tools that are necessary to perform your computer-management tasks.

The Computer Management Console
The Computer Management console consists of a window divided into two panes. The left pane contains the console tree; the right pane contains details. When you click an item in the console tree, information about that item is displayed in the details pane. The information that is displayed is specific to the item that you select.

The administrative tools in Computer Management are grouped into the following three categories in the console tree:
• System Tools
• Storage
• Services and Applications

Nov
05

A diagnostic card, or a power on self-test [POST] card can be a useful tool in locating problems in computers that are not booting up properly.

Diagnostic card cards detect the output of these codes and display them (usually in hex) on an LED display. This means that even if the computer in not booting up, and there is no screen display, you still have useful information about stages have been completed and at what stage the computer failed.

Viewing these codes is of great value in diagnosing problems, as the code will often point you to the actual problem component.

Features

· Hex display – a hexadecimal display (7-segment display) is used to display the current POST code as the test is initiated on the motherboard. Some diagnostic cards also have an outlet for a video monitor to display more meaningful messages

· Voltage LEDs – LEDs monitor the stand voltages and stay lit if voltages are within a tolerance of 10. if one is not lit, the power supply may be faulty, this feature is an alternative to using a multimeter to test voltage levels.

· Voltage pad – Voltage pads, or terminators, on the card (one for each of the standard voltage) can be tested with a multimeter for more accurate voltage measurements than the voltage LEDs.

· Logic probe – a logic probe consists of a handheld pointer with LEDs, and a plug on a lead that is connected to an earth connection on the motherboard. The logic probe enables you to test the logical levels (High/Low/No voltage levels) in a computer down to chip level. This is achieved by touching the probe against a 1C connector or one of the motherboard bus wires.

Limitations

Note that there are limitations to this type of testing. For example, since the AMI BIOS is used with a wide variety of chipsets, the POST codes may indicate the wrong error. Another reason that codes may point to the wrong part is that some components depend on other components in order to work correctly.

It is not usually feasible to remove (for example, by desoldering) and replace chips on a motherboard, so even knowing which chip is faulty will not lead to an easy fix.

Nov
05

· Demonstrating the skills needed to diagnose computer faults to keep a computer running smoothly and virus free

· Focus is placed on the home and business user

· Virus’ and harm com from the internet, flash discs or other portable storage media

How can we identify the cause of a computer problem?

1. identify the problem

2. Check for obvious errors

3. Check for internal errors

4. Isolate the problem

 

Most obvious problem – power! If the computer is not on, the screen is not on, or the device does not appear to work, then POWER is the obvious problem to look at:


Types of power problems

·        Power failure (shortage) – electrician stuff – the supply of electricity to the wall socket (outlet)

·        Solution – call the energy company to see if there is a known outrage or problem with supply.

·        Check for the circuit breake  is set to on (tripped a fuse) – OH&S CONSIDERATIONS Not qualified to play with 30 amps!+

·        Check for obvious physical defects to the socket or plug(s)

o       A visual inspection

  •         Is it plugged in correctly?
  •         Is the switch broken or sparking?
  •        Does it smell abnormal?
  •        Does the socket and plug appear to be ‘normal’

·        If it appears to be okay then you can proceed

·        Remove the cord from the plug to the device…. And use a different cord. Replace the new cord in the SAME socket and see if the device begins to work (supplied power)

·        If it fails – we can determine that the likely problem is NOT the device or the cord, it lies in the electrical wiring to the socket, so we would notify the OH&S representative, and await further instructions

·        You could swap the device….plug something you do know works into the socket – radio, phone as long as you know it works!

 

This is the kind of LOGICAL process that you would undertake even to investigate a simple problem like no power to a device THIS IS A PROCEDURE. It is likely that when asked to solve a problem in the HSC they will ask you to describe the procedure!

 

Other ways to identify problems (besides power)

 

  •        What were they doing before it stopped working>

If they say it’s never worked…then go back to the power scenario

  • Knowing what application were running at the same time may identify if the problem is software related (unexpected quit)
  • Were there any messages on the screen? (hardware and software failure). What were they?
  • BSOD – Hardware and software conflict – that invokes a shut down of all tasks and operations, leaving the user with a blue screen, and working in white letters informing them of ‘damage’ to their computer. Rarely seen in most offices these days
  • “WINDOWS HAS DETECTED A FATAL ERRROR ON YOUR COMPUTER – BLUE SCREEN OF DEATH – there is no cure, but your computer is not DEAD, you have no choice but to restart the computer – loosing all data in RAM and perhaps corrupting your hard drive. The way it shut down, it might stop the discs spinning, or affect the position of the read head. This might cause a loss or corruption of data.
  • System messages – usually about drivers (software that is designed to be used by the operating systems to make a hardware device function)
  • Have you install any new hardware or software?

o       Even something like a screen saver can cause havoc on a business computer – codes that fights with the operating system, or even a file that carries a VIRUS in it.

  • Has it happen before?

o       If it’s happen before then chances are WE’VE FIXED IT BEFORE, or someone else has experienced it BEFORE. We can look back on EXPERIENCE  to help solve the problem

Oct
28

graph 

3. 5.428571429    [=average(c4:I4)]

4.  14 hours [ ($16000/52)/$22 ]

5. $836.00  [ =((J4*K4)*c10 ]

6. $13,247.97 [=IF(N5>16000,N5*64%*98%,N5)]

Oct
28

Spreadsheets are used in business manipulate data such as numbers to produce information

  • NB: in the HSC you need to talk about
  • Software application using

Spreadsheets

Database

Desktop Publishing

Word processing

Other software is generally called either operating system or utility software

These application are characterised by the use of columns and rows to hold cells of data

graph1

  • Cells hold ‘data’
  • Data is text, numbers or calculation
  • Cells are REFERENCED by co-ordinates
  • Co-ordinates are given as a 2 dimensional array (x,y)
  • The example here shows a table whose array 4*3 (4by3)
  • 4 columns and 3 rows of data
  • We refer to an array as a RANGE of data
  • A cell reference for the first sales price data in the table above is B5
  • To reference a range of data we do this
    • Cell B6 has the value of $13
    • All the sales prices in the RANGE (array) above could be referenced as B6 – B8
  • In HSC exams (or in spreadsheet documentation) the idea of the cells in the range B6 to B8 would be written as [B6:B8]

graph2

  • The formula bar is used to enter
    • Data (data is text, numbers and calculation)
    • Calculation are either
      • Logical calculation (operation)
      • Mathematical calculation (operation)
  • Logical calculation are such things as
    • AND, IF, NOT, OR, SORT ….
  • IF B6<20 THEN “LOSS” ELSE “PROFIT”

Mathematical calculation

  • In cell C6, the spreadsheet calculates the GST (10%) components of the sale price

12*10%= 1.2

B6*10%=

C6= B6*10%

C6=B6* 0.1

graph3

The decoration of the table is called formatting. Commonly we say that formatting is ‘applied’ to a ‘table’

A table is a 2 dimensional array of data

Table, array of data and range are all similar concepts, but have subtle difference

The logical

AVERAGE, MIN, MAX, VLOOKUP, HLOOKUP, IF

=IF(F19>F18,”PROFIT”,”LOSS”)

Oct
28

Spreadsheet application in business

Common uses for spreadsheets

  • Payslips
  • Invoices

Operator

There are three types of operators in most spreadsheets

1. Arithmetic operators – mathematical operations on numbers – add, minus, multiply etc.

2. Comparisons – compare TWO things BINARY VALUE (RESULT) – 0 or 1 – yes or no eg. A1>B1

3.  Text operator – THERE IS ONLY ONE text operator & (2/3 call it the “&” sign). Ampersand (&) Example =A1(hot) and in A2 (dog) =(A1)&(A2) gives the result (HOT)(DOG)

Errors

Common errors that are cited

  • #### – Cell is too narrow to show the data
  • #NAME? – The spreadsheet cannot identify something in the formula. EG. A mis-typed formula name – SUM(SOM)
  • In–balanced brackets – (())))
  • Logical Errors – although the formula is valid and works. The logic of it is wrong. Eg. To add 10% to a value in cell A1, =A1+10% – gives the wrong answer. =A1 + (A1+10%) – gives the right answer
  • Circular reference error – when the cell refers itself in its own formula, =E2 +2 (when placed in cell E2)

Task – using the Jim and Jane Timesheet

  1. Save a working copy of the class demonstration
  2. publish all your spreadsheet notes (with illustrations) to wordpress

Jim and Jane get paid an hourly rate. A standard working week is 36 hours. If they work over that, then they are paid time and a half – the over time rate, so each our worked in paid at 1.5 times the normal rate.

Part time staffs, if working on a weekend are given a weekend loading of 1.25% of their normal pay rate for each hour worked over 4 hours [every 4 hours]

Employees earning less than $16,000 per annum do not pay tax

Employees earning $16,001 – $80,000 per annum pay 36% tax and 5% superannuation

3.  What is the average hour Jim works each week, based on this timesheet?

4. What is the average pay that Jim can expect before tax?

5. How much will Jim earn in the week above?

6. How much will Jane earn this year, based on the time sample

To answer these questions, you must show workings on your spreadsheet using functions and formula

Monday Week3 : hand in

spreadsheet application in business.doc

Jun
21

 Day: Thursday

Date: 21.06.07

Start: 9am

Finish: 5pm

Equipment used: computer, adobe photoshop CS2

Tasks Completed: Brochure, advertisements

News skills learnt: creating a cube from photshop

How could i improve: Read more instruction manuals and tutorials

Jun
21

Day: Wednesday

Date: 20.06.07

Start:9am finish: 5pm

Equipment used: Adobe Photoshop CS2, computer, Microsoft Word

Tasks Completed:  Editing documents, logos

News skills learnt: Creating Layers and filters

How could i improve? Read the instruction manual and tutorials

Jun
21

Day : Tuesday

Date:19.06.07

Start: 9am finish:5pm

equipment used: computer

Tasks completed: logos and ghosting

New skills learnt: ghosting

How can i improve?

Jun
18

Day: Monday      Date: 18.06.07

Start Time: 9am  Finish time: 5pm

Equipment Used: Computer (Photoshop cs2)

Task completed:

  • advertisement
  • Letterhead layout

New skills Learnt: Drawing shapes with Photoshop

How can i improve? Read the instruction manual for Photoshop CS2

Follow

Get every new post delivered to your Inbox.