[Year 12 IT Apps] ITA U3O2 SAC

[Litsa Tzelepis]

Hi Simone,

 

In the past I have asked my students to generate a combination of criteria
and calculated queries.

 

Calculated Queries

For example, for our practice, we created a database where customers booked
tickets for a Musical/s. The students had to calculate the cost of the
tickets depending on how many adult and child tickets they requested and
they also had to determine whether a customer was eligible for a discount on
their tickets, based on how many bookings they have made via the booking
company. In the total cost, there was also a standard booking fee that
needed to be included. These are outlined below:

 

§     Total Cost$ - The total cost of the booking, including the booking
fee.

§     Disc$ - The discount amount off the Total Cost$

§     Actual Cost$ - the final cost deducting any discount amount

 

The formulas:

 


Total Cost$:8+[Adult$]*[Adult#]+[Child$]*[Child#]

Disc$:IIf([Booked#]>=3,[Total Cost$]*5.5/100,0)

Actual Cost$:[Total Cost$]-[Disc$]

 

 

Criteria Queries – some of these are generated via multiple tables

 

§     All bookings >= 3

§     All customers attending CATS or MAMA MIA

§  All plays playing at the National or Regent theatres where the patrons
have paid by VISA or AMEX

§  Customers who have paid and have qualified for a discount

 

I’m not sure if this is helpful or even if its enough in terms of level of
difficulty.

I hope it makes sense.

Good luck, Litsa J

 

From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au]
On Behalf Of Simone Tynan
Sent: Saturday, 12 May 2012 6:48 PM
To: itapps at edulists.com.au
Subject: [Year 12 IT Apps] ITA U3O2 SAC

 

Hi all.

Just looking at U3O2 sac. My students are starting it this week. 

I am having difficulty with the vagueness of the question on queries:

  "Construct and produce a range of queries to effectively retrieve required
information and to produce reports that would satisfy the needs of the
organisation." (Taken from Study Design)

What is the standard expectation?

If a student produced a query for customer addresses and another for money
owed by customers, would that be sufficient to get a good mark?

 

Would it be wrong to explicitly ask for several different queries? eg "Write
a query which would retrieve information about what products each customer
bought?"

 

Any help/suggestions along these lines would be appreciated.

Thanks

Simone

 

************************************

Simone Tynan

eLearning Leader

LOTE Leader P-12

Simone.Tynan at shcy.vic.edu.au

 

Sacred Heart College

P.O. Box 286

Yarrawonga

Victoria 3730

Phone (03)5744 3258

 

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20120512/756cca08/attachment-0001.html