<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<title>RE: [Year 12 IT Apps] Edutainment</title>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceName"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceType"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle19
{mso-style-type:personal;
font-family:Arial;
color:navy;}
span.EmailStyle20
{mso-style-type:personal;
font-family:Arial;
color:black;}
span.EmailStyle21
{mso-style-type:personal;
font-family:Arial;
color:black;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:Verdana;
color:blue;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
@page Section1
{size:21.0cm 842.0pt;
margin:72.0pt 89.85pt 72.0pt 89.85pt;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:447819166;
mso-list-type:hybrid;
mso-list-template-ids:1583805418 201916417 201916419 201916421 201916417 201916419 201916421 201916417 201916419 201916421;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l1
{mso-list-id:1681156456;
mso-list-type:hybrid;
mso-list-template-ids:25315050 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l1:level1
{mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level2
{mso-level-tab-stop:72.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level3
{mso-level-tab-stop:108.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level4
{mso-level-tab-stop:144.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level5
{mso-level-tab-stop:180.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level6
{mso-level-tab-stop:216.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level7
{mso-level-tab-stop:252.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level8
{mso-level-tab-stop:288.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level9
{mso-level-tab-stop:324.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l2
{mso-list-id:1711958016;
mso-list-template-ids:181337262;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-AU link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'>Hi Diane<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'>To protect formulas;<o:p></o:p></span></font></p>
<ul style='margin-top:0cm' type=disc>
<li class=MsoNormal style='color:blue;mso-list:l0 level1 lfo4'><font size=2
color=blue face=Verdana><span style='font-size:10.0pt;font-family:Verdana'>Highlight
all the cells you want the user to be able to ALTER.<o:p></o:p></span></font></li>
<li class=MsoNormal style='color:blue;mso-list:l0 level1 lfo4'><font size=2
color=blue face=Verdana><span style='font-size:10.0pt;font-family:Verdana'>Go
to Format, Cells, Protection, then UNCHECK the ‘Locked’. This
removes the ‘locks’ from these cells, so that when you protect
the whole sheet, these cells can then be changed. That’s why you
select the ones you want to be able to ALTER first.<o:p></o:p></span></font></li>
<li class=MsoNormal style='color:blue;mso-list:l0 level1 lfo4'><font size=2
color=blue face=Verdana><span style='font-size:10.0pt;font-family:Verdana'>Go
to Tools, Protection, Protect sheet. This turns of the ‘locks’
for every cell that has them. You have options to allow users to change
aspects of the formats of cells here whilst protecting the contents, as
well as supplying a password (not recommended for students!)<o:p></o:p></span></font></li>
<li class=MsoNormal style='color:blue;mso-list:l0 level1 lfo4'><font size=2
color=blue face=Verdana><span style='font-size:10.0pt;font-family:Verdana'>This
now means that everything you haven’t chosen earlier will be locked.
<o:p></o:p></span></font></li>
</ul>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'>I believe Mark has addressed the second
part of the question<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'>Regards,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'>Bill<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span lang=EN-US style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span lang=EN-US
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span lang=EN-US style='font-size:10.0pt;font-family:Tahoma'>
itapps-bounces@edulists.com.au [mailto:itapps-bounces@edulists.com.au] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Diane Peat<br>
<b><span style='font-weight:bold'>Sent:</span></b> Monday, 13 August 2007 8:28
AM<br>
<b><span style='font-weight:bold'>To:</span></b> Year 12 IT Applications
Teachers' Mailing List<br>
<b><span style='font-weight:bold'>Subject:</span></b> [Year 12 IT Apps] Query
on Excel</span></font><span lang=EN-US><o:p></o:p></span></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div id=idOWAReplyText84761>
<p class=MsoNormal><span class=EmailStyle21><font size=2 color=black
face=Arial><span lang=EN-US style='font-size:10.0pt'>Hello <o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle21><font size=2 color=black
face=Arial><span lang=EN-US style='font-size:10.0pt'>Firstly, my apologies if
this appeared on the VELS list (poor reading on my part). I have two queries
I’m hoping someone can assist with:<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle21><font size=2 color=black
face=Arial><span lang=EN-US style='font-size:10.0pt'><o:p> </o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle21><font size=2 color=black
face=Arial><span lang=EN-US style='font-size:10.0pt'>Firstly </span></font></span><span
class=EmailStyle21><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt'><o:p></o:p></span></font></span></p>
<ol style='margin-top:0cm' start=1 type=1>
<li class=MsoNormal style='color:black;mso-list:l1 level1 lfo3'><span
class=EmailStyle21><font size=2 color=black face=Arial><span lang=EN-US
style='font-size:10.0pt'>I want to protect the formula columns in my U4O1
spreadsheet, so I use Tools, Protection, Protect Sheet. But if I do that,
I can’t type into the two columns where I want to enter data. </span></font></span><span
class=EmailStyle21><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt'><o:p></o:p></span></font></span></li>
<li class=MsoNormal style='color:black;mso-list:l1 level1 lfo3'><span
class=EmailStyle21><font size=2 color=black face=Arial><span lang=EN-US
style='font-size:10.0pt'>If I only select the cells that contain the
formulas and then use the Format, Cells, Protection, it doesn’t work
and I can still alter the formula cells.</span></font></span><span
lang=EN-US> </span><span class=EmailStyle21><font size=2 color=black
face=Arial><span lang=EN-GB style='font-size:10.0pt'><o:p></o:p></span></font></span></li>
<li class=MsoNormal style='color:black;mso-list:l1 level1 lfo3'><span
class=EmailStyle21><font size=2 color=black face=Arial><span lang=EN-US
style='font-size:10.0pt'>If I do both lots of protection, I still
can’t type into the two columns. </span></font></span><span
class=EmailStyle21><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt'><o:p></o:p></span></font></span></li>
</ol>
<p class=MsoNormal><span class=EmailStyle21><font size=2 color=black
face=Arial><span lang=EN-US style='font-size:10.0pt'> </span></font></span><span
class=EmailStyle21><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt'><o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle21><font size=2 color=black
face=Arial><span lang=EN-US style='font-size:10.0pt'>I created a separate Data
Entry sheet (thank Keith!) for the practice SAC but I don’t think it will
work for the ‘real’ one I’m about to start. Does anyone know
if there’s a way I can protect <i><span style='font-style:italic'>only </span></i>a
few columns or cells, and still be able to enter data into other cells? I
thought I was OK with Excel, but am I missing something really basic???</span></font></span><span
class=EmailStyle21><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt'><o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle21><font size=2 color=black
face=Arial><span lang=EN-US style='font-size:10.0pt'> <o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle21><font size=2 color=black
face=Arial><span lang=EN-US style='font-size:10.0pt'>Secondly<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle21><font size=2 color=black
face=Arial><span lang=EN-US style='font-size:10.0pt'>I want to round up a
figure in my spreadsheet and can’t remember how to include the ROUNDUP
criteria in my formula. I want to round up the formula that reads
=(B4*K8*I8)/I5 but I can’t remember where to put ROUNDUP. I know
it’s a simple thing but …<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle21><font size=2 color=black
face=Arial><span lang=EN-GB style='font-size:10.0pt'><o:p> </o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle21><font size=2 color=black
face=Arial><span lang=EN-US style='font-size:10.0pt'> </span></font></span><span
class=EmailStyle21><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt'><o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle21><font size=2 color=black
face=Arial><span lang=EN-US style='font-size:10.0pt'>Thanks everyone.</span></font></span><span
class=EmailStyle21><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt'><o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle21><font size=2 color=black
face=Arial><span lang=EN-US style='font-size:10.0pt'> </span></font></span><span
class=EmailStyle21><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt'><o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle21><font size=2 color=black
face=Arial><span lang=EN-US style='font-size:10.0pt'>Diane Peat</span></font></span><span
class=EmailStyle21><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt'><o:p></o:p></span></font></span></p>
<p class=MsoNormal><st1:place w:st="on"><st1:PlaceName w:st="on"><span
class=EmailStyle21><font size=2 color=black face=Arial><span lang=EN-US
style='font-size:10.0pt'>Firbank</span></font></span></st1:PlaceName><span
class=EmailStyle21><font size=2 color=black face=Arial><span lang=EN-US
style='font-size:10.0pt'> <st1:PlaceType w:st="on">Grammar School</st1:PlaceType></span></font></span></st1:place><span
class=EmailStyle21><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt'><o:p></o:p></span></font></span></p>
<p class=MsoNormal><st1:place w:st="on"><span class=EmailStyle21><font size=2
color=black face=Arial><span lang=EN-US style='font-size:10.0pt'>BRIGHTON</span></font></span></st1:place><span
class=EmailStyle21><font size=2 color=black face=Arial><span lang=EN-US
style='font-size:10.0pt'> </span></font></span><span
class=EmailStyle21><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt'><o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle21><font size=2 color=black
face=Arial><span lang=EN-US style='font-size:10.0pt'>Telephone 9591 5118</span></font></span><span
class=EmailStyle21><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt'><o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle21><font size=2 color=black
face=Arial><span lang=EN-US style='font-size:10.0pt'>Email <a
href="mailto:dpeat@firbank.vic.edu.au"><font size=3 face="Times New Roman"><span
style='font-size:12.0pt;font-family:"Times New Roman"'>dpeat@firbank.vic.edu.au</span></font></a></span></font></span><span
class=EmailStyle21><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt'><o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle21><font size=2 color=black
face=Arial><span lang=EN-US style='font-size:10.0pt'> </span></font></span><span
class=EmailStyle21><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt'><o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle20><font size=2 color=black
face=Arial><span lang=EN-US style='font-size:10.0pt'> </span></font></span><span
class=EmailStyle20><font size=2 color=black face=Arial><span style='font-size:
10.0pt'><o:p></o:p></span></font></span></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-US
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-US
style='font-size:12.0pt'>_______________________________________________ <br>
<a href="http://www.edulists.com.au">http://www.edulists.com.au </a>- FAQ,
resources, subscribe, unsubscribe <br>
IT Applications Mailing List kindly supported by <br>
<a href="http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html%20">http://www.vcaa.vic.edu.auvce/studies/infotech/infotechindex.html
</a>- Victorian Curriculum and Assessment Authority and <br>
<a href="http://www.vitta.org.au">http://www.vitta.org.au </a>- VITTA Victorian
Information Technology Teachers Association Inc<o:p></o:p></span></font></p>
</div>
</div>
<p></p><p><b>Important - </b>This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education.</p></body>
</html>
<P><FONT SIZE=2 FACE="Arial">_______________________________________________<BR>
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe<BR>
IT Applications Mailing List kindly supported by<BR>
http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html - Victorian Curriculum and Assessment Authority and<BR>
http://www.vitta.org.au - VITTA Victorian Information Technology Teachers Association Inc</FONT></P>