IT BTEC Unit 2 2019 January Controlled Assessment Watch

crimsonenrage
Badges: 8
Rep:
?
#1
Report Thread starter 1 month ago
#1
Hi everyone. I am starting my ten hour controlled assessment on IT BTEC Unit 2 tomorrow.
I would really appreciate if you could post how you all are finding the assessment as the week progresses, and to help out when we each need it.
Thank you!
1
reply
HypNose
Badges: 8
Rep:
?
#2
Report 1 month ago
#2
I have my controlled assessment from tomrorow as well, let's hope for the best and try to do our best!
1
reply
crimsonenrage
Badges: 8
Rep:
?
#3
Report Thread starter 1 month ago
#3
(Original post by HypNose)
I have my controlled assessment from tomrorow as well, let's hope for the best and try to do our best!
Good Luck!
0
reply
crimsonenrage
Badges: 8
Rep:
?
#4
Report Thread starter 1 month ago
#4
Hi. I've completed 2 hours of the assessment. So far, I have completed activities 1 and 2 - the ERD Diagrams and Screenshots.
How is everyone else finding it?
0
reply
ITStudent420
Badges: 7
Rep:
?
#5
Report 1 month ago
#5
I have done 2hrs of it and this is what i remember off of my head...

Doris allens total rent calculations between 1/2/08 to 12/31/2015...
Make a form for a new tenant... Thats all i remember though...

What my teacher suggested is that get all the marks for the first two activities and then do the testing and evaluation...t

the first two activities are worth 16 marks...testing and evaluation are 12 each...if u guys put more effort into these u can defo get a distinction (Just do the easy forms and queries as well just in case)!!! Good luck for the next parts...
0
reply
crimsonenrage
Badges: 8
Rep:
?
#6
Report Thread starter 1 month ago
#6
(Original post by N.tony123)
I have done 2hrs of it and this is what i remember off of my head...

Doris allens total rent calculations between 1/2/08 to 12/31/2015...
Make a form for a new tenant... Thats all i remember though...

What my teacher suggested is that get all the marks for the first two activities and then do the testing and evaluation...t

the first two activities are worth 16 marks...testing and evaluation are 12 each...if u guys put more effort into these u can defo get a distinction (Just do the easy forms and queries as well just in case)!!! Good luck for the next parts...
Thank you! Good luck to you too!
I don't really know how to do the final query - Doris Allen - so my teacher told us to skip it. We're starting on the forms and report tomorrow, along with the testing if we do it in good time
0
reply
HypNose
Badges: 8
Rep:
?
#7
Report 1 month ago
#7
Hello everyone, does anyone remember the first two queries that we had to do? If so, what were they about?
0
reply
crimsonenrage
Badges: 8
Rep:
?
#8
Report Thread starter 1 month ago
#8
(Original post by Josiahjones)
Can someone confirm what the erd looks like. I’m scared mines wrong
Set out what you have in your tables. I'll correct you
0
reply
crimsonenrage
Badges: 8
Rep:
?
#9
Report Thread starter 1 month ago
#9
(Original post by LucieJan3X)
So can anyone help me out and explain to me step by step what to do in the exam so i can get some marks. Please help a sister out xx.
Do you have your tables sorted, with all the data types, validations and screenshots done? If so, just follow what I've written below
(Original post by HypNose)
Hello everyone, does anyone remember the first two queries that we had to do? If so, what were they about?
I can help with the Queries

A query to display a list of two bedroom vacant properties from the cheapest rent to the most expensive rent.

and

a query that would allow a user to enter a property type and minimum number of bedrooms as parameters

Okay so in query design, you need to have tblProperty and put in the fields NumBedroom and MonthlyRent
For the criteria, put 2 for bedrooms. For Rent, put the (I forgot what it was called but there is a drop down box beneath the field that should provide three options) and click ascending.
That is the first query done.

Second one, you need tblProperty and tblPropertyType. Put on both fields of tblPropertyType. Put in PropertyID. Click E totals. Under the fields should be "Group by". Put PropertyID as " count"

All done
0
reply
crimsonenrage
Badges: 8
Rep:
?
#10
Report Thread starter 1 month ago
#10
(Original post by Josiahjones)
i dont remember tho
Okay no worries.
So you have five tables:
tblProperty
tblRental
tblPropertyType
tblOwner
tblTenant

In tblRental, you need to have the foreign keys: PropertyID and TenantID
In tblProperty, you need to have the foreign keys: PropertyTypeID and OwnerID
0
reply
matty258987
Badges: 6
Rep:
?
#11
Report 1 month ago
#11
(Original post by crimsonenrage)
Okay no worries.
So you have five tables:
tblProperty
tblRental
tblPropertyType
tblOwner
tblTenant

In tblRental, you need to have the foreign keys: PropertyID and TenantID
In tblProperty, you need to have the foreign keys: PropertyTypeID and OwnerID
that is what I got.
0
reply
crimsonenrage
Badges: 8
Rep:
?
#12
Report Thread starter 1 month ago
#12
(Original post by Josiahjones)
does this acc work, like is this the right way?? (no offence)
My teacher confirmed it
1
reply
crimsonenrage
Badges: 8
Rep:
?
#13
Report Thread starter 1 month ago
#13
(Original post by Josiahjones)
ah okay, thank you. When do you have the rest exam
Tomorrow and Friday
0
reply
crimsonenrage
Badges: 8
Rep:
?
#14
Report Thread starter 1 month ago
#14
(Original post by Naz9941)
hey, Did you manage to finish report?
Yes. It was kind of straightforward but confusing. I can't really remember how I did it because I was trying to do the forms
0
reply
matty258987
Badges: 6
Rep:
?
#15
Report 1 month ago
#15
(Original post by crimsonenrage)
Yes. It was kind of straightforward but confusing. I can't really remember how I did it because I was trying to do the forms
this worked for me:
0
reply
Anonymous_IT
Badges: 3
Rep:
?
#16
Report 1 month ago
#16
Has anyone done the second form I'm so stuck please help meeee
0
reply
zammarbaig
Badges: 3
Rep:
?
#17
Report 1 month ago
#17
how are you guys doing the forms. Im mad confused.
0
reply
matty258987
Badges: 6
Rep:
?
#18
Report 1 month ago
#18
The first form is just a standard data entry form into the tenant table. I'm not too sure about the second form, unfortunately.
0
reply
justwhy2j
Badges: 3
Rep:
?
#19
Report 1 month ago
#19
can someone tell me how to do the 3rd qry
"the query that would allow a user to enter a property type and minimum number of bedrooms as parameters. Displaying the owners name, property address and number of bedrooms
1
reply
matty258987
Badges: 6
Rep:
?
#20
Report 1 month ago
#20
(Original post by justwhy2j)
can someone tell me how to do the 3rd qry
"the query that would allow a user to enter a property type and minimum number of bedrooms as parameters. Displaying the owners name, property address and number of bedrooms
1
reply
X

Quick Reply

Attached files
Write a reply...
Reply
new posts
Latest
My Feed

See more of what you like on
The Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

Personalise

University open days

  • Solent University
    Postgraduate and Professional Open Evenings Postgraduate
    Mon, 25 Feb '19
  • University of the Arts London
    MA Material Futures Open Day Postgraduate
    Mon, 25 Feb '19
  • University of Brighton
    Health and clinical practice + health professions + hospitality, tourism and events + journalism + sport and exercise Postgraduate
    Tue, 26 Feb '19

Do you have a food intolerance or allergy?

Yes - a food intolerance (88)
14.52%
Yes - a food allergy (63)
10.4%
Yes - an autoimmune disorder (i.e coeliac, colitis) (15)
2.48%
Yes - I have an intolerance and allergy (16)
2.64%
No (424)
69.97%

Watched Threads

View All