• We need your support!

    We are currently struggling to cover the operational costs of Xtremepapers, as a result we might have to shut this website down. Please donate if we have helped you and help make a difference in other students' lives!
    Click here to Donate Now (View Announcement)

Applied ICT 9713- May/June 2012 Series

W

wasi

Messages
5
Reaction score
1
Points
3
fah3355 said:
come back and tell us wht came .plz
Click to expand...
Ok so heres the deal,
in excel there are a few formulas used to calculate transportation stuff for a concert type of think, mostly its just plain maths i.e. =i6/h6*55(this is just an example) etc.. the only important formulas used are vlookup and if statments, REMEMBER the if statement is very tricky and has many nested if statements. Other than this there is a graph in excel, its not so difficult but you should know how to make one very well!! that is it for excel. Other than this you will have to write an article on validation and verification techniques in word, you will also have to take screen shots of some of the validations and verification and put them in your report. You will have to know very good about corporate house style in word. The last thing is powerpoint, you should know how to make and edit a master slide, plus the important part is to know how to print 4 slides on one single page.
this is all i got for now. ill let you know if something else comes up!
REMEMBER!! THIS IS NOT 100% AUTHENTIC, DONOT RELY ON THIS, BE PREPARED FOR ANYTHING!! THIS IS JUST THE INFORMATION I GOT AND I AM PASSING IT ON.
 
F

fah3355

Messages
183
Reaction score
18
Points
28
wasi said:
Ok so heres the deal,
in excel there are a few formulas used to calculate transportation stuff for a concert type of think, mostly its just plain maths i.e. =i6/h6*55(this is just an example) etc.. the only important formulas used are vlookup and if statments, REMEMBER the if statement is very tricky and has many nested if statements. Other than this there is a graph in excel, its not so difficult but you should know how to make one very well!! that is it for excel. Other than this you will have to write an article on validation and verification techniques in word, you will also have to take screen shots of some of the validations and verification and put them in your report. You will have to know very good about corporate house style in word. The last thing is powerpoint, you should know how to make and edit a master slide, plus the important part is to know how to print 4 slides on one single page.
this is all i got for now. ill let you know if something else comes up!
REMEMBER!! THIS IS NOT 100% AUTHENTIC, DONOT RELY ON THIS, BE PREPARED FOR ANYTHING!! THIS IS JUST THE INFORMATION I GOT AND I AM PASSING IT ON.
Click to expand...
thnk you alot man !
this is good stuff !!xD
where should we show examples of validation and verification ?and are we allowed to use the internet ?
let me knw if you got more info ..
thnk you so much dude !:D:D:D:D
 
F

fah3355

Messages
183
Reaction score
18
Points
28
wasi said:
Ok so heres the deal,
in excel there are a few formulas used to calculate transportation stuff for a concert type of think, mostly its just plain maths i.e. =i6/h6*55(this is just an example) etc.. the only important formulas used are vlookup and if statments, REMEMBER the if statement is very tricky and has many nested if statements. Other than this there is a graph in excel, its not so difficult but you should know how to make one very well!! that is it for excel. Other than this you will have to write an article on validation and verification techniques in word, you will also have to take screen shots of some of the validations and verification and put them in your report. You will have to know very good about corporate house style in word. The last thing is powerpoint, you should know how to make and edit a master slide, plus the important part is to know how to print 4 slides on one single page.
this is all i got for now. ill let you know if something else comes up!
REMEMBER!! THIS IS NOT 100% AUTHENTIC, DONOT RELY ON THIS, BE PREPARED FOR ANYTHING!! THIS IS JUST THE INFORMATION I GOT AND I AM PASSING IT ON.
Click to expand...
Hope you give a good exam
 
W

wasi

Messages
5
Reaction score
1
Points
3
fah3355 said:
thnk you alot man !
this is good stuff !!xD
where should we show examples of validation and verification ?and are we allowed to use the internet ?
let me knw if you got more info ..
thnk you so much dude !:D:D:D:D
Click to expand...
I donot know wether we could use the internet or not.
To where i think we have to take screen shots and put the images within the article(but this is what i think i donot know for sure).
Thank you, And best of luck to you too. :)
 
F

fah3355

Messages
183
Reaction score
18
Points
28
o
wasi said:
I donot know wether we could use the internet or not.
To where i think we have to take screen shots and put the images within the article(but this is what i think i donot know for sure).
Thank you, And best of luck to you too. :)
Click to expand...
ohh so you mean we take examples of screenshots from our excel worksheet ?
 
F

fah3355

Messages
183
Reaction score
18
Points
28
wasi said:
It can be from both excel and access. Because mostly the validation rules are used in access databases.
Click to expand...
ok.bt i thought we dnt have to work on access. thnks man for the info good luck.let me knw if you find more info .
where you from btw?
 
W

wasi

Messages
5
Reaction score
1
Points
3
fah3355 said:
ok.bt i thought we dnt have to work on access. thnks man for the info good luck.let me knw if you find more info .
where you from btw?
Click to expand...
We are not going to do anything in access, the only thing to do is to show how validation works, i am attachting a file a was making as a article, it will help you.
P.S: this file is not complete, its only half, and donot use it.
 

Attachments

  • Validation and verification.docx
    123.1 KB · Views: 71
F

fah3355

Messages
183
Reaction score
18
Points
28
wasi said:
We are not going to do anything in access, the only thing to do is to show how validation works, i am attachting a file a was making as a article, it will help you.
P.S: this file is not complete, its only half, and donot use it.
Click to expand...
sure man.this was nice of you to do.thnk you :)
 
F

fah3355

Messages
183
Reaction score
18
Points
28
wasi said:
We are not going to do anything in access, the only thing to do is to show how validation works, i am attachting a file a was making as a article, it will help you.
P.S: this file is not complete, its only half, and donot use it.
Click to expand...
sure man.this was nice of you to do.thnk you :)
 
I

Igneous Marshmallow

Messages
29
Reaction score
6
Points
3
Kernel95 said:
I did the question, and there should be no errors.
I believe that you have not done question 22. itself correctly. Check it
The correct answer for question 22 is
=VALUE(MID("cell reference", 8, 1))​
What this does is gets the eight character (or number), and sets it into a value (VALUE). Now when you use the result of this, it should work.
ps. I tested the step 22 using =MID("cell ref", 8, 1) and this did cause my step 23 to give #N/A.
Click to expand...
You are right thats what happened with me...i kind of figured it out.....b4 seeing your reply.....but loads of thanxx
 
You must log in or register to reply here.
Top