[Informatics] Criteria 3: Validation Techniques

Sun Apr 29 08:29:44 EDT 2018

Use data validation  (and possible conditional formatting and/or sorting) in Excel to highlight invalid / out of range data.

Tony

On 29 Apr 2018, at 10:22 pm, Nayak, Jayanti S <nayak.jayanti.s at edumail.vic.gov.au<mailto:nayak.jayanti.s at edumail.vic.gov.au>> wrote:

Thanks for your reply.

I am still need some clarity.

(a)    when students use Excel to validate data what do they need to do.

(b)    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.

_______________________________________________
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/16ee55e8/attachment-0001.html>