Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Using think free Online calc to create gradebook

by lowewilliamcou812 May 30, 2006 7:10PM PDT

Hi,
I'm using "Thinkfree Online Beta Calc" (similar to MS Excel)to create my class gradebook. However, what I'm having difficulty with, is how to get the program to deal with pupils who are absent from assignments. The program seems to want to give them zero and so they are given a lower mark than they should have.
So how can I have the program calculate the marks based only the assignments which are written and ignore assignments which have ''abs'' in the mark cell?
Thanks!
L

Discussion is locked

2 Posts

- Collapse + Expand Details

- Collapse -

Since it's similar to Excel

by PudgyOne May 31, 2006 7:06AM PDT

Since it's similar to Excel, I'm just guessing at this,

Try telling it that

=IF(SUM(AO25:AR38)=abs;"place your value here")This may not be a doable function listed above, but is an example I copied from a report sheet. You may have to write a macro to use a function like this.

Or what ever columns they are. Say you want the value to be 100 for bsing absent, the you would use that value. I like the value of abs=0 becaues they then have to make the work up to get a better grade.

Hope this helps.

Rick

- Collapse -

Re: free online calc

by Kees Bakker May 31, 2006 4:51PM PDT

I don't know a product called 'online calc', but I do know both Excel and the free OpenOffice (www.openoffice.org) counterpart Calc.

And I know (because I tried) that if I enter 1,2,a,4 in A1:A4 both programs say the sum = 7, the average = 2.33 and the count = 3.
And I do know that Excel (didn't check it in Calc) has a isnumeric-function to check if the contents of a cell are numeric.

So I would say that both programs have the means to do what you want. But as you don't specify what you want, nor how you (try to) do it at the moment, it's impossible to tell you how to do it. So, for the moment, it's up to you to choose a suitable program and learn to use it to accomplish your tasks.

Kees

Back to PC Applications forum