[Informatics] Excel Dashboards

[Tony Crewe]

Hi Vera,

Quick Look, and seem okay and worthy  but yes too ‘big’. Keep idea but late back?
Are you specifying testing for db, ss and charting components.
I have adapted, modified  QATS takes, more direction with design, extracting data from world bank, cleansing etc, —> single DB Table, query, some calculations inc calc field. Then —> some excel calculations and sorting, rearranging data. three charts. Maybe mine is too straightforward. But erring on caution first time.

Tony

On 4 Mar 2020, at 5:39 pm, Vera Cook <vcook at mscw.vic.edu.au> wrote:


Hi I was wondering if anyone had written their first sac I am working on mine but am worried that it is becoming too big could someone please give me some feedback

Thankyou Vera

From: informatics <informatics-bounces at edulists.com.au> On Behalf Of Watson, Donald R
Sent: Wednesday, 4 March 2020 1:32 PM
To: Year 12 VCE Informatics Teachers' Mailing List <informatics at edulists.com.au>
Subject: [Informatics] Excel Dashboards

Hello All,

Probably beyond the scope of Data Analytics, but a great tutorial on Excel Dashboards.

https://www.youtube.com/watch?v=cKkXtyjleX4<https://www.youtube.com/watch?v=cKkXtyjleX4>

<image001.png>

Don
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.
<Unit 3 Outcome 1 2020 Data Analytics V1..docx>
_______________________________________________
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
VCE Informatics Mailing List

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://edulists.com.au/pipermail/informatics/attachments/20200304/6e39a641/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 167489 bytes
Desc: image001.png
URL: <http://edulists.com.au/pipermail/informatics/attachments/20200304/6e39a641/attachment-0001.png>