[Informatics] Criteria 3: Validation Techniques

Sun Apr 29 08:31:30 EDT 2018

You can use Excel to validate…. But it’s best to validate at the original point of data entry. (eg Google forms not allowing a date in the future, not allowing text in a number field…)

To validate in Excel set up a validation rule to disallow clearly unreasonable data  - same examples as above.

Natalie (Marcellin College)

From: informatics <informatics-bounces at edulists.com.au> On Behalf Of Nayak, Jayanti S
Sent: Sunday, 29 April 2018 10:22 PM
To: Year 12 VCE Informatics Teachers' Mailing List <informatics at edulists.com.au>
Subject: Re: [Informatics] Criteria 3: Validation Techniques

Thanks for your reply.

I am still need some clarity.

  1.  when students use Excel to validate data what do they need to do.

  1.  What should I be looking for when I am marking their work for this Criteria?

Jayanti

From: informatics <informatics-bounces at edulists.com.au<mailto:informatics-bounces at edulists.com.au>> On Behalf Of John Schwartz
Sent: Sunday, 29 April 2018 10:19 PM
To: Year 12 VCE Informatics Teachers' Mailing List <informatics at edulists.com.au<mailto:informatics at edulists.com.au>>
Subject: Re: [Informatics] Criteria 3: Validation Techniques

Validation is part of data collection so using Excell to validate data is not the same as manipulating it.

John Schwartz
Semi-retired
Sent from my iPhone

On 29 Apr 2018, at 2:04 pm, Nayak, Jayanti S <nayak.jayanti.s at edumail.vic.gov.au<mailto:nayak.jayanti.s at edumail.vic.gov.au>> wrote:
Using Excel to manipulate data is part of Criteria-4 while validation is under criteria-3 (collecting, referencing & securing data).

From: informatics <informatics-bounces at edulists.com.au<mailto:informatics-bounces at edulists.com.au>> On Behalf Of Tony Crewe
Sent: Sunday, 29 April 2018 6:57 AM
To: informatics at edulists.com.au<mailto:informatics at edulists.com.au>
Subject: Re: [Informatics] Criteria 3: Validation Techniques

Jayanti,

In my view , in context of Excel,  that means, prior to applying formula, charting and other manipulation (sorting/filtering etc), using validation rules, and conditional formatting (even alignment based on data type (text right and number left) in cells)

If using Access, input masks (when entering data manually), validation rules and required settings.

Tony

CGS

________________________________
From: informatics <informatics-bounces at edulists.com.au<mailto:informatics-bounces at edulists.com.au>> on behalf of Nayak, Jayanti S <nayak.jayanti.s at edumail.vic.gov.au<mailto:nayak.jayanti.s at edumail.vic.gov.au>>
Sent: Saturday, 28 April 2018 7:40 PM
To: informatics at edulists.com.au<mailto:informatics at edulists.com.au>
Subject: [Informatics] Criteria 3: Validation Techniques

Criteria 3: Selects and applies complete set of validation techniques that result in dataset that has full integrity

Hi,

I am trying to understand what is it that students need to do to demonstrate the above criteria.

Since, I have taught Software Development for many years where the "electronic" validation technique is the code written to check user input, I am just not able to get my head around  what I need to look for.

From my understanding, Criteria 3 is all about data collection and Criteria 4 is about Manipulation of data.

Manual Validation would be to proof-read the data-set and check to see if there are any anomalies, discrepancies and "odd" data. Ignore these i.e. delete them (use screen shots to show before & after data). But what about electronic validation? How do students demonstrate this?

Can someone clarify this please.

________________________________

Kind Regards,

Ms. Jayanti S Nayak
Digital Technology, Maths & Science Teacher

I Werribee Secondary College - Wyndham’s International High School I

I Duncans Road, Werribee, Victoria, 3030 I
I t: +61 3  9741 1822
I e: nayak.jayanti.s at edumail.vic.gov.au<mailto:garner.mark.m at edumail.vic.gov.au> I w: www.werribeesc.vic.edu.au<https://www.edumail.vic.gov.au/owa/redir.aspx?C=Q8NrKV4jsGx2PrWcRFhFl9UftgdjudYcfV5yWOxtGqrciyttZlTUCA..&URL=http%3a%2f%2fwww.werribeesc.vic.edu.au%2f> I

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 - FAQ, resources, subscribe, unsubscribe
VCE Informatics Mailing List kindly supported by
http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html - Victorian Curriculum and Assessment Authority <br>
http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers Association Inc <br>
http://www.swinburne.edu.au/ict/schools - Swinburne University

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.

Natalie Heath
Marcellin Staff

[Marcellin College Logo]
MARCELLIN COLLEGE
160 Bulleen Road
Bulleen VIC 3105 Australia
T +61 3 9851 1698
F +61 3 9851 1555
ABN 77 413 001 496
marcellin.vic.edu.au<http://marcellin.vic.edu.au>
twitter.com/Marcellin<http://twitter.com/Marcellin>
DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please notify the sender immediately by reply email and delete the email from your system. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Marcellin College. Marcellin College does not guarantee that this email is virus or error free and accepts no liability for any damage caused by any virus transmitted by this email.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://edulists.com.au/pipermail/informatics/attachments/20180429/cbd88d90/attachment-0001.html>