<HTML>
<HEAD>
<TITLE>Re: [Offtopic] Google Forms and Spreadsheets</TITLE>
</HEAD>
<BODY>
<FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>Hi Everyone,<BR>
<BR>
I am so excited I got the forms working. It is so easy.<BR>
I made a spreadsheet in google docs.<BR>
Then clicked create form.<BR>
I then clicked embed and copied the code.<BR>
I went to my wikipage and added a widget html code (the blue tellie button) and pasted the html code.<BR>
Save!<BR>
<BR>
All done. When teachers enter their Name School and Email for the PD Session I will have a complete spreadsheet of then as an attendance list and can mail merge the certificates for them.<BR>
<BR>
Cheers,<BR>
<BR>
Pennie White<BR>
Ultranet Coach<BR>
Dandenong Ranges Network<BR>
Eastern Metropolitan Region<BR>
Mobile 0403 274 253<BR>
C/O Menzies Creek Primary School 9754 3695<BR>
<BR>
<BR>
<BR>
<BR>
On 4/1/09 6:11 AM, "Pennie White" <<a href="white.pennie.l@edumail.vic.gov.au">white.pennie.l@edumail.vic.gov.au</a>> wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>Hi Roland,<BR>
<BR>
This look great thanks.<BR>
<BR>
Is this an easy way for me to take registrations for teachers attending PD?<BR>
<BR>
Do I need to make more than one form?<BR>
<BR>
For example if I was offering 13 sessions would this help me collate the registration or is there a better way?<BR>
<BR>
Can you help me get my head around this a bit faster?<BR>
<BR>
Thanks,<BR>
<BR>
Pennie White<BR>
Ultranet Coach<BR>
Dandenong Ranges Network<BR>
Eastern Metropolitan Region<BR>
Mobile 0403 274 253<BR>
C/O Menzies Creek Primary School 9754 3695<BR>
<BR>
<BR>
<BR>
<BR>
On 4/1/09 4:11 AM, "Roland Gesthuizen" <<a href="rgesthuizen@gmail.com">rgesthuizen@gmail.com</a>> wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>This year we subscribed to an online PD service that can handle this for your staff. Over the last two years I had some fun making a small flat database that we simply used with Moodle. It now think that it would be easy enough to do something similar with Google Docs using their free form -> spreadsheet feature.<BR>
<a href="http://docs.google.com/support/bin/answer.py?hl=en&answer=87809">http://docs.google.com/support/bin/answer.py?hl=en&answer=87809</a><BR>
<BR>
Just a suggestion.<BR>
<BR>
Regards Roland<BR>
<BR>
2009/3/23 WEIR Andrew <<a href="andrew.weir@thomascarr.vic.edu.au">andrew.weir@thomascarr.vic.edu.au</a>><BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>Dear all,<BR>
I am wondering if there is a way to implement access control within an<BR>
MS Access database.<BR>
<BR>
We are trying to keep track of staff pd hours.<BR>
So a staff member accesses the database and updates how many hours and<BR>
what the topic was then submits to a central location.<BR>
The pd coordinator can then access the data and print it of.<BR>
Staff are only able to access there own records. The pd coordinator can<BR>
access all the records.<BR>
<BR>
The school has asked for a access based solution but I am also<BR>
relatively sure it can we done Php Mysql, but not fully sure of how.<BR>
Any ideas on either option would be fantastic.<BR>
<BR>
Regards<BR>
Andrew<BR>
<BR>
<BR>
<BR>
<BR>
Andrew Weir<BR>
<BR>
Information Technology Co-ordinator<BR>
<BR>
<BR>
<BR>
Thomas Carr College<BR>
<BR>
35 Thomas Carr Drive,<BR>
<BR>
Tarneit, VIC 3029<BR>
<BR>
(P) (03) 8734 2526<BR>
<BR>
(F) (03) 9748 4388<BR>
<BR>
(E) <a href="andrew.weir@thomascarr.vic.edu.au">andrew.weir@thomascarr.vic.edu.au</a><BR>
<BR>
<BR>
<BR>
IMPORTANT! This email and any attachments may be confidential. If<BR>
received in error, please contact us and delete all copies. Thomas Carr<BR>
College does not represent or warrant that the attached files are free<BR>
from computer viruses or other defects. The attached files are provided,<BR>
and may only be used, on the basis that the user assumes all<BR>
responsibility for any loss, damage or consequence resulting directly or<BR>
indirectly from the use of the attached files, whether caused by the<BR>
negligence of the sender or not. Any representations or opinions<BR>
expressed in this email are those of the individual sender, and not<BR>
necessarily those of Thomas Carr College.<BR>
<BR>
Please consider the environment before printing this email<BR>
<BR>
<BR>
<BR>
<BR>
_______________________________________________<BR>
offtopic mailing list<BR>
<a href="offtopic@edulists.com.au">offtopic@edulists.com.au</a><BR>
<a href="http://www.edulists.com.au/mailman/listinfo/offtopic">http://www.edulists.com.au/mailman/listinfo/offtopic</a><BR>
</SPAN></FONT></BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><BR>
<BR>
</SPAN></FONT></BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><BR>
<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 and Early Childhood Development.<BR>
<BR>
</SPAN></FONT></BLOCKQUOTE>
<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 and Early Childhood Development.</p>
</BODY>
</HTML>