[Informatics] Validation and Databases

Mon Feb 17 23:14:51 UTC 2020

Hi Litsa

Hope you are traveling well

Giving a test for Chapter 1 to my students today please feel free to customise for your use. (attached)

Not meeting tonight with Antoinette but we are meeting on the 3rd of March at the Workshop.

Let me know what you need and what you think of this.

I will see you on the 3rd of March Hopefully.

Frank

Please use my McKinnon email as it pops up rather than having to check edumail, rss at mckinnsc.vic.edu.au

Frank Russo, ICT Teacher
Email: rss at mckinnonsc.vic.edu.au
[McKinnonLogo_300dpi_TEXTBelow]
291a McKinnon Road, McKinnon
Phone: (03) 8520 9000
Fax: (03) 9578 9253
Website: www.mckinnonsc.vic.edu.au<http://www.mckinnonsc.vic.edu.au>

From: informatics <informatics-bounces at edulists.com.au> On Behalf Of Litsa Tzelepis
Sent: Monday, 10 February 2020 9:27 AM
To: Year 12 VCE Informatics Teachers' Mailing List <informatics at edulists.com.au>
Subject: Re: [Informatics] Validation and Databases

thank-you Frank and all the very best of luck.
yes "huge" shoes to fill but you will be magnificent.
have a great day, litsa
🎆

On Sat, Feb 8, 2020 at 12:01 PM Russo, Frank R <Russo.Frank.R at edumail.vic.gov.au<mailto:Russo.Frank.R at edumail.vic.gov.au>> wrote:
Hi Litsa and welcome back to another year……

Just thinking about you’re the validation it seems that if that data were entered via a form on a website the form what have the restriction and not allow the data to be entered. I would accept it as data validation as you could have your raw data set and then the validated data set and it would be easy to compare and explain why it is not valid?

Outcome 1 here we come.

Oh and yes I have moved school in the footsteps of Mark Kelly…I have big shoes to fill but very ready for it.

Frank Russo, ICT Teacher
Email: rss at mckinnonsc.vic.edu.au<mailto:rss at mckinnonsc.vic.edu.au>
[McKinnonLogo_300dpi_TEXTBelow]
291a McKinnon Road, McKinnon
Phone: (03) 8520 9000
Fax: (03) 9578 9253
Website: www.mckinnonsc.vic.edu.au<https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.mckinnonsc.vic.edu.au&data=02%7C01%7CRusso.Frank.R%40edumail.vic.gov.au%7C79046ea857a94c38977308d7adaf425e%7Cd96cb3371a8744cfb69b3cec334a4c1f%7C0%7C0%7C637168840621663248&sdata=Z4xLbWsBi4wmxq8zkanBfQNEXrRl3w7pcBRQ9768wP0%3D&reserved=0>

From: informatics <informatics-bounces at edulists.com.au<mailto:informatics-bounces at edulists.com.au>> On Behalf Of Litsa Tzelepis
Sent: Thursday, 6 February 2020 11:53 AM
To: Year 12 VCE Informatics Teachers' Mailing List <informatics at edulists.com.au<mailto:informatics at edulists.com.au>>
Subject: [Informatics] Validation and Databases

Good morning,

I hope the term has started well for yo all.

I have a little question regarding validation - normally we create our databases/spreadsheets with validation ready to accept data.

If the validation is entered before importing, it rejects the data that does not meet the criteria.

Would that be considered towards showing validation techniques for U3-O1? Obviously there will be data entry and data editing to show it, I was more so thinking about the importing part.

Thank-you,
Litsa :-)

--

Litsa Tzelepis

7-12 Computing Teacher | Senior Cameron Learning Mentor

Mount St. Joseph Girls’ College

133 Maidstone Street, Altona VIC 3018

t 03 8398 2000

www.msj.vic.edu.au<https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.msj.vic.edu.au&data=02%7C01%7CRusso.Frank.R%40edumail.vic.gov.au%7C79046ea857a94c38977308d7adaf425e%7Cd96cb3371a8744cfb69b3cec334a4c1f%7C0%7C0%7C637168840621673238&sdata=7BOq8nS9974gV500ZWSE8q3FEC66zIYoR%2Fg54QwSDbI%3D&reserved=0>

<https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.facebook.com%2FMSJGirlsCollege%2F&data=02%7C01%7CRusso.Frank.R%40edumail.vic.gov.au%7C79046ea857a94c38977308d7adaf425e%7Cd96cb3371a8744cfb69b3cec334a4c1f%7C0%7C0%7C637168840621673238&sdata=93wCVlcXrqlHqWjvdAquJwpTfD4tCXFAiZ5kodTIXOo%3D&reserved=0>

[https://lh6.googleusercontent.com/72j722aIVarP_8c-nM137soX5lqUHle12OMSSjeboru9iMmj1pNbfV-QXDhxJdIjlOEXGzcFSwnNYp1sPm7On0WXNiIKfrTk6MbpSPfv2JsnRA5MChX081Ei2zDxnSwWNVl2LTpL]<https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.instagram.com%2Fmsjgirlscollege%2F%3Fhl%3Den&data=02%7C01%7CRusso.Frank.R%40edumail.vic.gov.au%7C79046ea857a94c38977308d7adaf425e%7Cd96cb3371a8744cfb69b3cec334a4c1f%7C0%7C0%7C637168840621683237&sdata=EJIZHgoscoV3SHMaEknFXhun1c%2FDCbwByh8YY0s5sv4%3D&reserved=0>

[https://lh3.googleusercontent.com/Lg6sCk0jeyYpk0DsiaW3f0La6eqFgaFg1HY9m92l1Hr-cvJwULTpJUhzvUwbrKh29NfFiUaAscca_SQaDgNGWp4TvrkzNdIT6Bbwif183Fnw1LhjIEi6KyJ3_YgsilOrFW9lqOns]<https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2FMSJGirlsCollege&data=02%7C01%7CRusso.Frank.R%40edumail.vic.gov.au%7C79046ea857a94c38977308d7adaf425e%7Cd96cb3371a8744cfb69b3cec334a4c1f%7C0%7C0%7C637168840621683237&sdata=y7mZ%2BbKFu5mRE6tEzWPIE3ii81dpicqyqVGzKFYq%2FJs%3D&reserved=0>

[https://lh4.googleusercontent.com/wvpgI5eSZ8_tOhvqbRIUJv3NnblQvGYTEyIF7S2CCqbICtStE1L5sPFrHyGk0XTQHbhexKl-CD-AQnsCrjI0XFsYyx1Vj96wBl_hRtV1kQ3rNToQoWJRWtgyrB8AUJCHZpAIaIBm]<https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.msj.vic.edu.au&data=02%7C01%7CRusso.Frank.R%40edumail.vic.gov.au%7C79046ea857a94c38977308d7adaf425e%7Cd96cb3371a8744cfb69b3cec334a4c1f%7C0%7C0%7C637168840621693234&sdata=h8WspBrlqfH1WiZTCxcgXC3FeK2CXKbo2pznpuJ5rpU%3D&reserved=0>

This Email and any attachments may be confidential and, if you are not the intended recipient, you must not disclose or use the information in this email. If received in error, please notify the sender and Mount St. Joseph Girls' College immediately and delete the Email and all copies. Mount St. Joseph Girls' College does not guarantee that this email is virus or error free. The attached files are provided and may only be used on the basis that the user assumes all responsibility for any loss, damage or consequence resulting directly or indirectly from the use of the attached files, whether caused by the negligence of the sender or not. The content and opinions in this Email are not necessarily those of Mount St. Joseph Girls' College. Please consider the environment before printing this email.

IMPORTANT! This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Mount St Joseph Girls' College does not represent or warrant that the attached files are free from computer viruses or other defects. The attached files are provided, and may only be used, on the basis that the user assumes all responsibility for any loss, damage or consequence resulting directly or indirectly from the use of the attached files, whether caused by the negligence of the sender or not. The liability of Mount St Joseph Girls' College is limited in any event to either the resupply of the attached files or the cost of having the attached files resupplied. Any representations or opinions expressed in this email are those of the individual sender, and not necessarily those of Mount St Joseph Girls' College.
IMPORTANT - 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 Training. IMPORTANT - 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 Training.
_______________________________________________
http://www.edulists.com.au<https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.edulists.com.au&data=02%7C01%7CRusso.Frank.R%40edumail.vic.gov.au%7C79046ea857a94c38977308d7adaf425e%7Cd96cb3371a8744cfb69b3cec334a4c1f%7C0%7C0%7C637168840621693234&sdata=XwRWoixwhfIvXEOtmncMzq8Ux8JgGE48nQLE%2FWoCEQg%3D&reserved=0> - FAQ, resources, subscribe, unsubscribe
VCE Informatics Mailing List

--

Litsa Tzelepis

7-12 Computing Teacher | Senior Cameron Learning Mentor

Mount St. Joseph Girls’ College

133 Maidstone Street, Altona VIC 3018

t 03 8398 2000

www.msj.vic.edu.au<https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.msj.vic.edu.au&data=02%7C01%7CRusso.Frank.R%40edumail.vic.gov.au%7C79046ea857a94c38977308d7adaf425e%7Cd96cb3371a8744cfb69b3cec334a4c1f%7C0%7C0%7C637168840621703222&sdata=KISoClxBqKzXHKlkgU%2Flq9kRksWkcN3iencldy5qiFk%3D&reserved=0>

<https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.facebook.com%2FMSJGirlsCollege%2F&data=02%7C01%7CRusso.Frank.R%40edumail.vic.gov.au%7C79046ea857a94c38977308d7adaf425e%7Cd96cb3371a8744cfb69b3cec334a4c1f%7C0%7C0%7C637168840621703222&sdata=I4rCDi4lk99EoGDz4mSgl4GGBevbJclSIPSj9A8Q33E%3D&reserved=0>

[https://lh6.googleusercontent.com/72j722aIVarP_8c-nM137soX5lqUHle12OMSSjeboru9iMmj1pNbfV-QXDhxJdIjlOEXGzcFSwnNYp1sPm7On0WXNiIKfrTk6MbpSPfv2JsnRA5MChX081Ei2zDxnSwWNVl2LTpL]<https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.instagram.com%2Fmsjgirlscollege%2F%3Fhl%3Den&data=02%7C01%7CRusso.Frank.R%40edumail.vic.gov.au%7C79046ea857a94c38977308d7adaf425e%7Cd96cb3371a8744cfb69b3cec334a4c1f%7C0%7C0%7C637168840621713215&sdata=ueTH3W964QJtiw%2BLVBsyxFe6FX7HUtaqpreqs8VQEoI%3D&reserved=0>

[https://lh3.googleusercontent.com/Lg6sCk0jeyYpk0DsiaW3f0La6eqFgaFg1HY9m92l1Hr-cvJwULTpJUhzvUwbrKh29NfFiUaAscca_SQaDgNGWp4TvrkzNdIT6Bbwif183Fnw1LhjIEi6KyJ3_YgsilOrFW9lqOns]<https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2FMSJGirlsCollege&data=02%7C01%7CRusso.Frank.R%40edumail.vic.gov.au%7C79046ea857a94c38977308d7adaf425e%7Cd96cb3371a8744cfb69b3cec334a4c1f%7C0%7C0%7C637168840621713215&sdata=dIhmkttWh9DTtV4bUQa7lnTCbNEJ5Izfjc6vUury%2Fu8%3D&reserved=0>

[https://lh4.googleusercontent.com/wvpgI5eSZ8_tOhvqbRIUJv3NnblQvGYTEyIF7S2CCqbICtStE1L5sPFrHyGk0XTQHbhexKl-CD-AQnsCrjI0XFsYyx1Vj96wBl_hRtV1kQ3rNToQoWJRWtgyrB8AUJCHZpAIaIBm]<https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.msj.vic.edu.au&data=02%7C01%7CRusso.Frank.R%40edumail.vic.gov.au%7C79046ea857a94c38977308d7adaf425e%7Cd96cb3371a8744cfb69b3cec334a4c1f%7C0%7C0%7C637168840621713215&sdata=kHxlVixUXkD8DnxsNWEw88QIfa8scs%2B74VzFSOESqNo%3D&reserved=0>

This Email and any attachments may be confidential and, if you are not the intended recipient, you must not disclose or use the information in this email. If received in error, please notify the sender and Mount St. Joseph Girls' College immediately and delete the Email and all copies. Mount St. Joseph Girls' College does not guarantee that this email is virus or error free. The attached files are provided and may only be used on the basis that the user assumes all responsibility for any loss, damage or consequence resulting directly or indirectly from the use of the attached files, whether caused by the negligence of the sender or not. The content and opinions in this Email are not necessarily those of Mount St. Joseph Girls' College. Please consider the environment before printing this email.

IMPORTANT! This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Mount St Joseph Girls' College does not represent or warrant that the attached files are free from computer viruses or other defects. The attached files are provided, and may only be used, on the basis that the user assumes all responsibility for any loss, damage or consequence resulting directly or indirectly from the use of the attached files, whether caused by the negligence of the sender or not. The liability of Mount St Joseph Girls' College is limited in any event to either the resupply of the attached files or the cost of having the attached files resupplied. Any representations or opinions expressed in this email are those of the individual sender, and not necessarily those of Mount St Joseph Girls' College.

IMPORTANT - 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 Training. IMPORTANT - 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 Training.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://edulists.com.au/pipermail/informatics/attachments/20200217/8d66f551/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 20081 bytes
Desc: image001.png
URL: <http://edulists.com.au/pipermail/informatics/attachments/20200217/8d66f551/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Chapter 1 Test Mck2020.docx
Type: application/vnd.openxmlformats-officedocument.wordprocessingml.document
Size: 39769 bytes
Desc: Chapter 1 Test Mck2020.docx
URL: <http://edulists.com.au/pipermail/informatics/attachments/20200217/8d66f551/attachment-0001.docx>