[Informatics] Criteria 3: Validation Techniques

[John Schwartz]

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> 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> On Behalf Of Tony Crewe
> Sent: Sunday, 29 April 2018 6:57 AM
> To: 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> on behalf of Nayak, Jayanti S <nayak.jayanti.s at edumail.vic.gov.au>
> Sent: Saturday, 28 April 2018 7:40 PM
> To: 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 I w: www.werribeesc.vic.edu.au 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.
>  
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://edulists.com.au/pipermail/informatics/attachments/20180429/52080f5e/attachment.html>