Find Jobs
Hire Freelancers

Create Formulas for Easy Weighted Gradebook

$10-30 USD

Concluído
Publicado há mais de 9 anos

$10-30 USD

Pago na entrega
I am a teacher who has a basic excel spreadsheet set up for a gradebook. This spreadsheet only calculates the sum of a student's assignments and divides it by the total number of points, thereby giving a raw score (which I can convert to a percentage). Now I need to add formulas so that the individual assignment grades are weighted. There are 3 categories: Classwork = 30% Assessments = 60% Participation = 10% My goal is to type in the number of points a student earned on an assignment, then have the spreadsheet automatically reference a particular weight, and produce a weighted score. Then I need to be able to easily calculate the final class grade, factoring in each assignment that was already weighted. SURELY there is someone on here that knows the formulas or proper way to set up the spreadsheet for a teacher to accomplish this task. Please help!!
ID do Projeto: 6404505

Sobre o projeto

19 propostas
Projeto remoto
Ativo há 10 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
Concedido a:
Avatar do Usuário
Hello ready to start asap to deliver you, this seems easy project but need to be done precisely, I can deliver it to you fast, also about me: I am m.s of systems engineering and b.s of industrial engineering, and excel(dashboard, pivot tables, charts, conditions, conditional formatting, statistical, financial, mathematical, string, time, date,..functions), creating pretty charts and vba expert. I have done similar projects and I am confident about my profession, I also accept revisions and removing errors and minor changes in future for free, whenever you are ready lets go. I have good command of English that I think can be useful for this project. I have a base of statistics, data analysis, mathematics, accounting, business analysis, cost calculating, project scheduling and project management and finance that helps in this project.
$13 USD em 1 dia
4,8 (62 avaliações)
5,3
5,3
19 freelancers estão ofertando em média $20 USD for esse trabalho
Avatar do Usuário
Excel expert at your service. I can help you create excel spreadsheet which calculates the sum of a students assignments and divides it by the total number of points. Please check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.
$30 USD em 0 dia
4,9 (221 avaliações)
7,0
7,0
Avatar do Usuário
I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. Such jobs are my daily practice. I can complete the job in some hours with advanced Excel functions and VBA macros if necessary. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards
$25 USD em 0 dia
4,9 (55 avaliações)
5,7
5,7
Avatar do Usuário
Hey, I am an expert in excel formulas and can help you by adding the formulas in your spreadsheet. The formulas would be generic enough for you to add more students or assignments in future and still work correctly in calculating the final grades. I reviewed the spreadsheet you shared and can surely modify it as required. Please let me know if you would like me to work on this project for you and we could discuss the next steps. Look forward to hear from you. Thanks and Regards, Shikha
$25 USD em 3 dias
4,9 (103 avaliações)
5,6
5,6
Avatar do Usuário
Hi there, I've been working with Excel since before '98 and I've been using all possible versions of it. I have years of experience working with macros and writing code / debugging Excel VBA code. You may check my portfolio images to see few pieces of my kind of work. (This is what I do on daily basis). I am a professional and I can do a very good job. Also fast and accurate. Do not hesitate to contact me for further details. Kind Regards, Jon
$30 USD em 1 dia
5,0 (25 avaliações)
4,5
4,5
Avatar do Usuário
I can help you with this work. It will not take much effort to change the weightage so that your requirements are met. Please message for discussion if required.
$20 USD em 1 dia
4,9 (22 avaliações)
4,3
4,3
Avatar do Usuário
I am a native English speaker with extensive Excel experience and excellent ratings. The best approach is to create an assignment type column, where you can select one of the three categories. Based on the category selected, each assignment will be properly weighted. You will be able to change the weighting as needed, so you can adapt this to future classes. I have done Excel work for teachers and schools before, and I understand what you need.
$25 USD em 3 dias
4,9 (12 avaliações)
4,3
4,3
Avatar do Usuário
I can do this for you. A lot of my previous projects were similar to yours. I am proficient in Microsoft Excel. I work fast and accurately. See my reviews.
$25 USD em 0 dia
5,0 (13 avaliações)
4,1
4,1
Avatar do Usuário
Hi, excel and VBA expert here ready to take up your project, pls share your file, I will give you very good functionality incorporated in your file. Have a nice day.
$10 USD em 0 dia
4,9 (23 avaliações)
4,1
4,1
Avatar do Usuário
Can you please clarify? do you want to have percentage of complited work for each assignement, and also total assignement percentage? do you want three new rows added, each one to show percentage of particuar assignemant? or do you want for each student two rows, and in first one number of points per assignemant and in the second, bellow, percentage in ferefernce of total possible?
$25 USD em 1 dia
5,0 (2 avaliações)
3,2
3,2
Avatar do Usuário
Hi, I am interested to work on your project. I have done several excel sheet formulating on Freelancer only, and I do couple of formulated sheets for my own work also. The task you want to do is very easy and can be done very easily. Please allow me the chance to do this excel sheet for you. Please message me to discuss further about it Thanks, Dsarang
$15 USD em 1 dia
4,7 (3 avaliações)
2,3
2,3
Avatar do Usuário
After going through the project requirement described below, I would like to convey to you that I will be a great fit for this project. Given my qualifications and experience with building excel related tools, I can assure you that I prepare any sort of customizable excel tool for you. Please contact me through PM so that we can take this forward. =========================================================================== I am a multi-faceted professional having 5 years of experience, starting from working as a research assistant at Georgia Tech, Logistics Analyst at Nokia, Sales & Operations Manager at Sandisk to starting my own company which provides consulting/freelancer services. I have a Masters in Industrial Engineering from Georgia Tech, and an engineering undergraduate from Delhi College of Engineering (One of the top engineering institution in India). =========================================================================== My company- 'Neogistics India' is currently empaneled with IBM as their certified Business Partner, and is being mentored by Neogistics LLC, a consulting company based out of the USA.
$10 USD em 1 dia
5,0 (1 avaliação)
1,7
1,7
Avatar do Usuário
Ready to start. Please give me a chance. I would try to complete the project with accuracy and would try to meet all requirements. Thanks & Regards.
$20 USD em 1 dia
5,0 (3 avaliações)
1,6
1,6
Avatar do Usuário
I can do that for you sir. . . I have been doing this for some time now using census data. This can be easily done excell. You will have your format of formula in no time.
$25 USD em 1 dia
4,4 (1 avaliação)
1,1
1,1
Avatar do Usuário
Hi! This is relatively simple. I could either do it for you or show you how its done, and it would take probably 15-20 minutes. Would be happy to help. Don't hesitate to send a message if you have any questions! Cheers, Preston
$10 USD em 0 dia
5,0 (1 avaliação)
0,1
0,1
Avatar do Usuário
I would be happy to help. I am a teacher as well. I may have some solutions for you. Please reach ou to me by chat and I will try to help you resolve this.
$25 USD em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
sir/Madame, I am very interested to your project. I was a part-time teacher. I do excel grade computation. Hoping you consider my bid and looking forward to work with you. Thank you.
$25 USD em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hi there, My name is Milos Simikic, US citizen currently working in Bosnia. I saw your project and I am willing to help you out for free. My stepmother is speech therapist in Oakland School District (California) so in way this is the way for me to contribute to US education. All I ask you to do, if you decide to go with me, is to grade me for my work on this site. On my job I generally deal with corporate finance, mergers, takeovers, business planning and so on… As a freelancer I am just starting out so I can get some more income for the baby on the way :). Fastest way of dealing with this would be over Skype I think so you can explain me exactly what you need done (got the idea just need to be sure). Sorry about 10$ bit it is impossible to put 0 or 1 $, don’t worry about payment anyway. Best regards, Milos
$10 USD em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hello! I looked at the project and have already entered the formulas in the first sheet of the sample. I would like to send it to you, and if you are pleased you'll pay me after I make any other modification required by you! I'm looking forward to working with you! Regards, Mihai Barcan P.S. Let me know how can I send you the file!
$15 USD em 1 dia
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) UNITED STATES
Abingdon, United States
5,0
1
Método de pagamento verificado
Membro desde mar. 3, 2014

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.