Chesso
Jul 4 2007, 04:29 AM
QUOTE At the beginning of the term our staff is busy with enrolments. Students are
given a discount if they pay the course fee in advance. The staff needs to
calculate and record the course fees paid by students. To make this task
easier for our staff you will need to design a template which can be re-used
each term. Include appropriate headings.
You should create and enter formulas to calculate the No. of Days paid in
Advance, the Discount and the Course Fee Paid.
Use a VLOOKUP function in your template to determine the discount rate
to be used for the calculation of the Discount. Your template should include
a separate discount table containing the following information about the
discount received: If students pay the course fee less than 7 days prior to the course
commencing then they receive no discount. If students pay the course fee 7 to 13 days prior to the course
commencing then they receive a discount of 5%. If students pay the course fee 14 to 20 days prior to the course
commencing then they receive a discount of 8%. If students pay the course fee 21 days or more prior to the course
commencing then they receive a discount of 10%.
Format the document appropriately. Save it as a template called
CourseFeesPaid in the Drafts folder.
Use the template you created to enter the following data for Term 3: And then there is tabular data in the pdf (student name, course code, course name, date course commences, date paid and course fee). This is one of the tasks for an assignment (for the course I am doing via correspondence, called "Information Technology Certificate III"). I have (I believe) managed everything else the assignment requires, but I am stuck on a few things about this particular task. Like, am I supposed to use Word or Excel? (it is involving formulas and this VLOOKUP function they mention) and I wonder due to the norm of asking me to create a Word, then Excel then Access document (this task resides inbetween ones asking me to create a word document, and the n an access one). How and where do I insert these formulas and make use of this VLOOKUP function, They don't even really give any details as to how they want it formated (and this external table and what not, how does it relate etc). I really wish they would provide basic samples of what *they* expect, I have a learning materials CD for all of the current modules that have been sent to me, but none of them give me any information about some of this (like using formula's in word itself not excelt and this VLOOKUP function and how they want it done). Any help is greatly appreciated, this would be my 3rd assignment done in one day if I can get this task done (I'm working hard) and still searching for answers lol.
Reply
Jimmy89
Jul 4 2007, 04:57 AM
This task would be completed in Excel. The VLOOKUP function finds values from another area of the sheet, or on another different sheet. You would use that for finding the percentage for discounts so if the number of days prior to course start is < 7 then 0% discount. So your 'discount table' would have the days in one column (days before course starts) and the percentages in another. So you type the amount of days left when the fees were payed under the students name, and the VLOOKUP function will find the percentage that needs to be discounted. Have a look at some websites that explain the use of VLOOKUP and understand that before you start making this assignment. Some good sites are: www.techonthenet.com/excel/formulas/vlookup.phphttp://office.microsoft.com/en-us/excel/HP052093351033.aspx (example 2 is about marking up values, which is the opposite of what you are doing, but is easily swapped) Good Luck -jimmy
Reply
Chesso
Jul 4 2007, 05:04 AM
Yeah I thought excel too, but it mentions "designing" a "document" like I have in the past using word (with graphics and stuff, like clipart), is that feasible in excel?
Reply
Jimmy89
Jul 4 2007, 06:12 AM
well you can use graphics (like clipart) in excel. But i dont think you can actually use functions like VLOOKUP in word. Thw only way taht I know of is making a excel document and importing it into word (as a object). From what you have posted, my initial thoughts were of excel for a project of this nature. Where you quoted before QUOTE you will need to design a template which can be re-used each term a template would be where they can re-enter students names each term. This template, to my understanding would be best made in excel. The mathematical functions that you can use in excel aren't available in word, which makes me think that you would use excel.
Reply
Chesso
Jul 4 2007, 06:40 AM
Yeah that's what I was thinking, it's just that they didn't state it and some things said in it make me think word, so I was confused about it lol. I usually ring them and ask but they changed to an annoying voice thing with buttons that takes forever to get through to a real person recently, and I got a call back for some clarification on something I finally got done, nearly a week after I emailed them..... lol.
Reply
Jimmy89
Jul 4 2007, 01:52 PM
Hopefully you will be able to sort it out with them Good Luck -jimmy
Reply
Chesso
Jul 4 2007, 01:56 PM
Yeah I might have to try and get a hold of them tomorrow and see if I can get this task all cleared up, I'd hate to have to send it all off and find it out it's completely wrong lol. Thanks for the help jimmy!
Reply
Jimmy89
Jul 4 2007, 11:15 PM
If you do end up using excel, i have a excel document that I made while I was in Year 10 at school. It was a basic budget calculator and used the VLOOKUP function. I'll attach it so you can have a look at how it works. Have a look on the wages tab, where it calculates tax, there is a VLOOKUP function for how much tax to be payed - something similar to what you are doing! Good Luck -jimmy
Reply
Jack gopher
Jun 11 2008, 07:26 AM
You can find here more info regarding the usage of Excel vlookup function: vlookup
Reply
iGuest
Jun 10 2008, 06:51 PM
You can find further easy assistance with the vlookup function on the following address, which presents the subject using simple tutorial vidoes: Http://www.Free-training-tutorial.Com/function-vlookup.Html -reply by Jack Gopher
Reply
Similar Topics
Keywords : understanding parts assignment involves microsoft- Microsoft Enlists Jerry Seinfeld
- News (2)
- Administrator Account Problem In Microsoft Xp [solved]
- I have lost "my documents" (20)
I have problem with administrator account ... I created new administrator account with this way:
start /control panel /account users/new account and than I created a new one ; after this I turned
off computer . I wanted to have two skypes turned on and my friend suggested me to do so... when I
turned it on the second day , I coudn't enter with the first administrator ,and I entered with
the administrator that I had created . I have lost my document folder.. please help me . how can I
enter or can I enter with that first administrator account?? Can my documents be ...
Microsoft Service Pack 2 Cd (free)
- Windows XP (17)
For those who missed my post: http://www.astahost.com/index.php?act=ST&f...t=10#entry27941 For
those who want a free CD copy of Service Pack 2 with Advanced Security Technologies (popup blocker
and firewall) follow this link: http://www.microsoft.com/windowsxp/downloa...us/default.mspx I
ordered mine about 3 months ago, received it in a within a week. ...
Bill Gates To Leave Microsoft!
- :O (10)
I just read this on a different forum! What do u think will happen to Microsoft now, i wonder
how much he input into the decsions QUOTE The highlight of the event was Gates’ leaving video
speculating on what might become of him once he steps down from his full time position at Microsoft.
The video shows Gates attempting to be a star in rock, rap, movies and politics and features
numerous Hollywood stars, as well as past and present US presidential candidates. The reality is
that Gates will now concentrate his efforts on the Bill and Melinda Gates Foundation, wh...
Microsoft Updates Your Copy Of Windows Without Your Consent
- (13)
Microsoft has begun patching files on Windows XP and Vista without users' knowledge, even when
the users have turned off auto-updates.
http://www.windowssecrets.com/2007/09/13/0...t-users-consent Sounds like these were updates
limited to updating Windows Update itself (I like the sound of "Windows Update is keeping its Update
system up to date"). The question is, if these were just minor changes unrelated to Windows, just
the Update application, why do it under the radar? The whole point of Windows Update is the clear
transparency of what is going on. Microsoft i...
Windows Xp Professional And My Assignment.
- (7)
Hello, I'm doing an Information Technology Certificate through OTEN here in Australia and am
having some issues that you might be able to help me with (they expect me to work weekends but there
not open >_>). I have an assignment that requires me to Install, Configure, Update etc an Windows
XP Professional Operating System. I don't have the Professional flavour of this Operating
System, and the Windows XP Professional trial that they link to in the Assignment material is only
the 64-Bit Edition of Windows XP Professional. I could not find a 32-Bit version, th...
Vlookup In Microsoft Excel.
- (8)
I'm doing a task for an Assignment in Microsoft Excel. The material isn't overly helpful
and nor is there teachers lol...... The biggest problem I am facing now is working with the
VLOOKUP function and what information they want. I have been asked to use the VLOOKUP function, to
the best of my understanding to produce a percentage for calculating a discount on a fee for
materials based on a commencement date and paid date. So for example, a person's material
commences on 9th of september (they display it in excel as 9 Sep which excel converts to a format...
Outlook Requires Microsoft Outlook Express 4.01 Or Greater
- (0)
Was trying to avoid this, but having worked with this user remotely for a few hours, I need another
brain here to help out /biggrin.gif" style="vertical-align:middle" emoid=":D" border="0"
alt="biggrin.gif" /> The user was originally having problems sending emails using Outlook 2000
because it said that it couldn't find the Windows Address Book. Well, we fixed that issue but
now stumbled on another one. This one was most likely caused by changing the registry value to 0 for
IsInstalled. The error he's getting now whenever he tries to run Outlook is: QUOTE ...
TCPA/TCP A.k.a Microsoft Palladium....
- Who really knows what it is, and whats your opinion? (0)
Ok everyone, I looked around here on astahost and found that this isn't a subject that seems to
have been discussed at any real length, and it kinda surprised me. For one reason main reason,
personal rights and open software development. Now I won't say that I know much about it yet
but from what little I've read and researched on this subject I have found many places that say
that if there is a bill passed in the USA: QUOTE In the USA there's a planed bill, the so
called CBDPTA (Consumer Broadband and Digital Television Promotion Act). First it wa...
Can Two System Share Microsoft Office
- eg. client run Excel from server (2)
Dear all, I wanna share a copy of Microsoft office in more than two system. What I am think is,
install microsoft Office in a Server. then other client system can run the application such Work
and Excel remotely. So that, Office suit do not required to be installed in every client system. Is
that possible? is there any other 3rd party software needed?...
Microsoft Command Shell?
- (0)
Today, I saw this on winbeta.org : Microsoft Command Shell Beta 1 Released to BetaPlace The code
name of Microsoft Command Shell is Monad. This shell provide rich scripting support. It built on the
.NET Framework and fully object-oriented. "It includes many concepts from traditional UNIX shells
such as bash and ksh, delivers rich scripting support challenging languages like Perl and
Python"!!!??? /rolleyes.gif' border='0' style='vertical-align:middle'
alt='rolleyes.gif' /> This Microsoft Command Shell (MSH) can be downloaded here
http://beta.microso...
Microsoft Windows Longhorn
- (17)
Has anybody heard about Microsoft's next generation of Windows? It's named Longhall, after
the Longhall Pub under/near the main microsoft building or something like that. I saw it on the news
last night, and it looks quite spiffy, but will be (as usual) full of bugs and viruses and stuff. I
think it runs on a touch screen, and most of the functions looked similar/same, but they have given
it a major cosmetic overhaul so stuff lights up when you touch it and other spoofy stuff.. Anyway, I
tried to find out more about it, but it seems there's no info anywhere....
When Did Microsoft Start?
- (7)
this is one of my technology course questions, i really need help, when did it start?!...
Microsoft Does It Again.
- what do you think of software parents ? (11)
http://www.eweek.com/article2/0,1759,1767520,00.asp
http://www.eweek.com/article2/0,1759,1730746,00.asp miscosft has filed a patent for the
'IsNot' operator (thats the '!=' operator to c/c++/java programmers and '
' to visual basic porgrammers.) i sometimes the the news on ani-software parent sites.
Microsoft also have patents like 1)the *nix sudo sommand (used in linux / unix for decades, but
never in windows) 2) timed double clicking. im not against real patents for real inventions.. but
you should NOT be able to patent prior art O...
News: Winfs For Windows Xp?
- Microsoft is considering it. (1)
Thursday 10 March appeared this in a computer new-paper: QUOTE Microsoft has said to the the
website MicrosoftWatch that they're considering to make their future coming filesystem also
compatible to Windows XP. Earlier the company had let known that Avalon and Indigo, the
presentation- and communicationlayer of Longhorn, would be avaible for Windows XP and Windows server
2003. WinFS is a special case, because the development of it takes so much time that it
wouldn't be a part of Longhorn, that will appear at the end of 2006. The filesystem has to run
on top...
What If Microsoft........
- (11)
Here's an idea. (more of a crazy dream, but its interesting) What if MS borrowed a MacOSX idea,
and dropped there current OS.. just binned it. then, took a *BSD or GNU/Linux OS, but instad of
using GNOME or KDE, ported the vurrently existing windowsXP Desktop Envodonment to run on Xorg-x11.
They could build a portage free like what Gentoo uses, except with pre-compiled binaries. Now you
would have an OS which looked and felt exactly like Windows, except running on a BSD or Linux Kenrel
and libraries. Good bye securety issues and virus scanners, hello inherrant se...
Future of Microsoft ?
- predictions on the future of microsoft ? (14)
What does everyone think will happen to microsoft as Awareness of alternative operating systems
becomes greater ? True, that MS has a very strong hold on the OS market, but even the giants
fall.... remember IBM ? they were once the evil monopolisers.... but one day, somebidy cloned their
bios, and they lost there hold on the hardware monopoly... How many people here have IBM PC's ?
all of you... (except the mac users) and how many of you bought the computer from IBM ? or how many
parts of your computer were made by ibm.... almost none of them. anyways... the way i...
Microsoft media keyboard -- F keys on by default?
- (3)
I have the MS media keyboard where you have volume controls, calculator, etc buttons on it. This
new version also has secondary controls for the function keys. That's fine by the function keys
are ALWAYS off by default which is an annoyance for me. It only requires me to press one key to
turn it on but if I forget to do that and start pressing buttons, all sorts of programs start
running and bad things start happening. How can I make them ON by default (like I have Num Lock on
by default)?...
Looking for understanding, parts, assignment, involves, microsoft, office,
|
*RANDOM STUFF*
*SIMILAR VIDEOS*
Searching Video's for understanding, parts, assignment, involves, microsoft, office,
|
advertisement
|
|
