Urgent Need help :( Watch

Announcements

Get advice on your exam results and Clearing here >>

fatima1998

Badges: 15

Rep:

Report Thread starter 3 years ago

Who is doing AS level ICT OCR coursework??
if u are please respond to my thread as i need ur help pleaseeeee
or if u are good in ict then please respond to the thread so i can respond u back
Thnaks
pleaseeeeeeee

shawn_o1

Badges: 21

Rep:

Report 3 years ago

i have a computer science degree so may know what you're talking about

Mactotaur

Badges: 20

Rep:

Report 3 years ago

I did it last year.

fatima1998

Badges: 15

Rep:

Report Thread starter 3 years ago

(Original post by shawn_o1)
i have a computer science degree so may know what you're talking about

i am stuck on my spreadsheet task so dunno how to make it work?

fatima1998

Badges: 15

Rep:

Report Thread starter 3 years ago

(Original post by Mactotaur)
I did it last year.

ohh okay!!! but i dont think that the tasks are the same or similar coz 2015-2017 AS is changed
but if u want to help me which would be great then plz respond

Mactotaur

Badges: 20

Rep:

Report 3 years ago

(Original post by fatima1998)
ohh okay!!! but i dont think that the tasks are the same or similar coz 2015-2017 AS is changed
but if u want to help me which would be great then plz respond

What are your tasks this year?

fatima1998

Badges: 15

Rep:

Report Thread starter 3 years ago

(Original post by Mactotaur)
What are your tasks this year?

well... it contains the same element as last year i think
task one- spreadsheet
task 2- graphics and word processing
task 3- website
task 4- data base
i am stuck on task 1
have already done task 2 and 3

shawn_o1

Badges: 21

Rep:

Report 3 years ago

(Original post by fatima1998)
i am stuck on my spreadsheet task so dunno how to make it work?

Is it just using excel, or coding an excel task in VBA?

fatima1998

Badges: 15

Rep:

Report Thread starter 3 years ago

(Original post by shawn_o1)
Is it just using excel, or coding an excel task in VBA?

just excel!!!
and formulas for calculation within an excel

Mactotaur

Badges: 20

Rep:

#10

Report 3 years ago

#10

(Original post by fatima1998)
just excel!!!
and formulas for calculation within an excel

Give us context. What calculations need to be done? What do you already have?

shawn_o1

Badges: 21

Rep:

#11

Report 3 years ago

#11

(Original post by fatima1998)
just excel!!!
and formulas for calculation within an excel

There's an fx button in excel that you click, and you get a list of available functions. You can also search for a function by keyword.

fatima1998

Badges: 15

Rep:

#12

Report Thread starter 3 years ago

#12

(Original post by Mactotaur)
Give us context. What calculations need to be done? What do you already have?

Doc2.odt
u may b able to check that document
if u can see that document then i have done date and day and type of van and additional driver
needs to do total days hired
weeks
days
and quotation

fatima1998

Badges: 15

Rep:

#13

Report Thread starter 3 years ago

#13

(Original post by shawn_o1)
There's an fx button in excel that you click, and you get a list of available functions. You can also search for a function by keyword.

i know all that

i meant i have a task given and i am stuck on that

Mactotaur

Badges: 20

Rep:

#14

Report 3 years ago

#14

(Original post by fatima1998)
Doc2.odt
u may b able to check that document
if u can see that document then i have done date and day and type of van and additional driver
needs to do total days hired
weeks
days
and quotation

Total days hired is just Return date-collection date, isn't it?

Then Weeks is that number divided by 7.

fatima1998

Badges: 15

Rep:

#15

Report Thread starter 3 years ago

#15

(Original post by Mactotaur)
Total days hired is just Return date-collection date, isn't it?

Then Weeks is that number divided by 7.

ermmmmm.... i got what u mean... but i dont know

i am stuck
can u like write the formula so i can work it out

Mactotaur

Badges: 20

Rep:

#16

Report 3 years ago

#16

(Original post by fatima1998)
ermmmmm.... i got what u mean... but i dont know

i am stuck
can u like write the formula so i can work it out

Okay. Say that the cell ref. for Return Date is C6, and the cell ref for Collection Date is C7.

For Total Days Hired (or whatever else you're calling it):
=C6-C7

Say Total Days Hired is in D8.

For Total Weeks Hired:
=D8/7

fatima1998

Badges: 15

Rep:

#17

Report Thread starter 3 years ago

#17

(Original post by Mactotaur)
Okay. Say that the cell ref. for Return Date is C6, and the cell ref for Collection Date is C7.

For Total Days Hired (or whatever else you're calling it):
=C6-C7

Say Total Days Hired is in D8.

For Total Weeks Hired:
=D8/7

OMGGGGGGGGGGGGGGGGGGGGGGGGGGG thanks a lot
but wait....
still on progress

soooo when i divided total weeks hired i got my answer in decimal 12.142...
is it right?
also there is a cell on days?

Mactotaur

Badges: 20

Rep:

#18

Report 3 years ago

#18

(Original post by fatima1998)
OMGGGGGGGGGGGGGGGGGGGGGGGGGGG thanks a lot
but wait....
still on progress

soooo when i divided total weeks hired i got my answer in decimal 12.142...
is it right?
also there is a cell on days?

Might want to format the cell so it shows decimals to the nearest whole number.

Mactotaur

Badges: 20

Rep:

#19

Report 3 years ago

#19

Can you screenshot your formulas and send it to me in a private message? It's easier to work with it if I know what you've got.

fatima1998

Badges: 15

Rep:

#20

Report Thread starter 3 years ago

#20

(Original post by Mactotaur)
Might want to format the cell so it shows decimals to the nearest whole number.

okay

and what about the days?

start new discussion

Page 1 of 1

Go to first unread

Quick Reply

Submit reply

Attached files

Replying is easier on our app - Click here to download for FREE!

Write a reply...

new posts

University open days

University of Dundee

Undergraduate Open Day Undergraduate

Mon, 26 Aug '19

find out more
University of Aberdeen

General Open Day Undergraduate

Tue, 27 Aug '19

find out more
Norwich University of the Arts

Postgraduate (MA) Open Day Postgraduate

Sat, 31 Aug '19

find out more

Poll

Join the discussion

How are you feeling about GCSE Results Day?

Hopeful

Excited

Worried

Terrified

Meh

Confused

Putting on a brave face

Impatient

Hopeful (213)

12.71%

Excited (151)

9.01%

Worried (303)

18.08%

Terrified (375)

22.37%

Meh (155)

9.25%

Confused (37)

2.21%

Putting on a brave face (230)

13.72%

Impatient (212)

12.65%

Quick Reply

All the exam results help you need

1,473

225,530

Oops, nobody has posted
in the last few hours.

See more of what you like on
The Student Room

Today on TSR

University open days

Poll

How are you feeling about GCSE Results Day?

Watched Threads

Oops, nobody has posted
in the last few hours.

See more of what you like on
The Student Room

TSR Support Team

Get Started

Using TSR

Info

TSR Group

Connect with TSR

Urgent Need help :( Watch

Not what you're looking for? Try…

Quick Reply

Related discussions

Related articles

All the exam results help you need

1,473

225,530

Oops, nobody has postedin the last few hours.

Oops, nobody is replying to posts.

See more of what you like onThe Student Room

Today on TSR

University open days

Poll

How are you feeling about GCSE Results Day?

Watched Threads

Spotlight

Oops, nobody has postedin the last few hours.

Oops, nobody is replying to posts.

See more of what you like onThe Student Room

TSR Support Team

Get Started

Using TSR

Info

TSR Group

Connect with TSR

Oops, nobody has posted
in the last few hours.

See more of what you like on
The Student Room

Oops, nobody has posted
in the last few hours.

See more of what you like on
The Student Room