Recent Changes

Practical Assessment Summer Exam 2011

Hey bubs, this is MY wiki, so you cannot edit ANYTHING.
I'm Hao Qing, otherwise known as Olli, and I attend at Oakley College.
I'm in Y7L,Y7J, and I
I like bogeying. It means surfing, but lying down.
Carlos, Pepe, Ale
,Ale, Pablo and Miguel( Surkan, Orhan, Coco, Manolo, Nikolas, Petter, Frank and Methet)Miguel
{quiksilver.jpeg}

I'm in Y7L, and I am in a football team called the Streeters.
I like bogeying. It means surfing, but lying down.
Carlos, Pepe, Ale,Ale
, Pablo and
{quiksilver.jpeg}

Total number of items ordered
=COUNT( A2 : A4 )
{file:///C:/DOCUME%7E1/HaoQing.Lu/LOCALS%7E1/Temp/moz-screenshot-3.png}
Mindmap=
=
Assignments=
Homework {58Aforweb.JPG}

Summer Exam Revision Guide
Computer Hardware and Software
Working with Wikis
Word Processors (Microsoft Word)
Spreadsheets (Excel)
Summer Exam Revision Guide--Parts of a ComputerParts of a Computer
Students should be able to:
Define hardware and give examples
Define software and give examples
Describe the difference between hardware and software
Identify the main components of a multi purpose computer: CPU, hard drive, input/output devices, storage devices.
Use this website to help you revise: http://www.teach-ict.com/gcse/hardware/parts/miniweb/index.htm
Summer Exam Revision Guide--Working with WikisWorking with Wikis
Students should be able to:
Log onto their wikis with their username and password
Create new wiki pages
Edit wiki pages to add/modify content
Insert images.
Summer Exam Revision Guide--Word ProcessorsWord Processors
Students should be able to:
prepare a multimedia presentation with text, graphics and sound
Format text, Fonts, bold, Italics, colour, alignment (left, right, centre)
insert clipart (including sound), borders, page numbers and headers/ footers, bullets.
to insert files. Images, clipart
Summer Exam Revision Guide--SpreadsheetsSpreadsheets
Students should be able to:
Edit a spreadsheet, move around cells, name cells,
Perform simple calculations (Add, subtract, multiply)
Perform more complex calculations using functions (Average, Max, Min)
Create Graphs

For example =SUM (A1:A4) will add up the contents of cells A1, A2, A3, A4.
· If A1=3, A2=3, A3=1 and A4=6, what would be the result of the function above? 13
==Graphs and Charts
Type Uses
Bar graph when you are counting things
Line graph To show trends
Pie chart To show proportions
Making a graph in excel.
Highlight the information
Click the graph icon
Follow the wizard reading EVERY step.
Include title
Label axes
A
B
C
D
1
Item
Price
Quantity
Total price
2
Coke
2.00
10
=B2*C2
3
Biscuits
1.50
15
=B3*C3
4
Crisps
0.65
124
=B4*C4
Total cost of party
=SUM( D2 : D4 )
Total number of items ordered
=COUNT( A2 : A4 )
{file:///C:/DOCUME%7E1/HaoQing.Lu/LOCALS%7E1/Temp/moz-screenshot-3.png}
Mindmap=
=
Assignments=
Homework

For example =SUM (A1:A4) will add up the contents of cells A1, A2, A3, A4.
· If A1=3, A2=3, A3=1 and A4=6, what would be the result of the function above? 13
|| Item || Price || Quantity |||| Total Price || || ||
Coke
$1
15
15
Biscuits
$1.50
32
48
Crisps
$0.65
124
80.6
Total cost of party
SUM(D2:D4)
Total number of items ordered
Count(A2:A4)=
Mindmap=
=

Notes=
{Excel.jpeg}
=In a spreadsheet calculations are done using formulas. E.G. if we write =A2+A4 in cell D5, cell D5 will show the result of A2+A4.
· If the contents of cell A2 where 5 and the contents of A4 where 4 what would be the resulting cell D5 after imputing the formula above?
For more complicated calculations we use functions. E.g. SUM.
For example =SUM (A1:A4) will add up the contents of cells A1, A2, A3, A4.
· If A1=3, A2=3, A3=1 and A4=6, what would be the result of the function above? 13
|| Item || Price || Quantity |||| Total Price || || ||
Coke
$1
15
15
Biscuits
$1.50
32
48
Crisps
$0.65
124
80.6
Total cost of party
SUM(D2:D4)
Total number of items ordered
Count(A2:A4)
Mindmap=
=