Find Jobs
Hire Freelancers

Create Formulas for Easy Weighted Gradebook

$10-30 USD

Terminado
Publicado hace más de 9 años

$10-30 USD

Pagado a la 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 del proyecto: 6404505

Información sobre el proyecto

19 propuestas
Proyecto remoto
Activo hace 10 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 1 día
4,8 (62 comentarios)
5,3
5,3
19 freelancers están ofertando un promedio de $20 USD por este trabajo
Avatar del usuario
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 en 0 día
4,9 (221 comentarios)
7,0
7,0
Avatar del usuario
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 en 0 día
4,9 (55 comentarios)
5,7
5,7
Avatar del usuario
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 en 3 días
4,9 (103 comentarios)
5,6
5,6
Avatar del usuario
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 en 1 día
5,0 (25 comentarios)
4,5
4,5
Avatar del usuario
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 en 1 día
4,9 (22 comentarios)
4,3
4,3
Avatar del usuario
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 en 3 días
4,9 (12 comentarios)
4,3
4,3
Avatar del usuario
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 en 0 día
5,0 (13 comentarios)
4,1
4,1
Avatar del usuario
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 en 0 día
4,9 (23 comentarios)
4,1
4,1
Avatar del usuario
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 en 1 día
5,0 (2 comentarios)
3,2
3,2
Avatar del usuario
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 en 1 día
4,7 (3 comentarios)
2,3
2,3
Avatar del usuario
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 en 1 día
5,0 (1 comentario)
1,7
1,7
Avatar del usuario
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 en 1 día
5,0 (3 comentarios)
1,6
1,6
Avatar del usuario
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 en 1 día
4,4 (1 comentario)
1,1
1,1
Avatar del usuario
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 en 0 día
5,0 (1 comentario)
0,1
0,1
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Abingdon, United States
5,0
1
Forma de pago verificada
Miembro desde mar 3, 2014

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos 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)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.