Find Jobs
Hire Freelancers

Create Formulas for Easy Weighted Gradebook

$10-30 USD

Completed
Posted over 9 years ago

$10-30 USD

Paid on delivery
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!!
Project ID: 6404505

About the project

19 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 in 1 day
4.8 (62 reviews)
5.3
5.3
19 freelancers are bidding on average $20 USD for this job
User Avatar
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 in 0 day
4.9 (221 reviews)
7.0
7.0
User Avatar
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 in 0 day
4.9 (55 reviews)
5.7
5.7
User Avatar
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 in 3 days
4.9 (103 reviews)
5.6
5.6
User Avatar
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 in 1 day
5.0 (25 reviews)
4.5
4.5
User Avatar
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 in 1 day
4.9 (22 reviews)
4.3
4.3
User Avatar
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 in 3 days
4.9 (12 reviews)
4.3
4.3
User Avatar
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 in 0 day
5.0 (13 reviews)
4.1
4.1
User Avatar
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 in 0 day
4.9 (23 reviews)
4.1
4.1
User Avatar
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 in 1 day
5.0 (2 reviews)
3.2
3.2
User Avatar
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 in 1 day
4.7 (3 reviews)
2.3
2.3
User Avatar
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 in 1 day
5.0 (1 review)
1.7
1.7
User Avatar
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 in 1 day
5.0 (3 reviews)
1.6
1.6
User Avatar
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 in 1 day
4.4 (1 review)
1.1
1.1
User Avatar
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 in 0 day
5.0 (1 review)
0.1
0.1
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Abingdon, United States
5.0
1
Payment method verified
Member since Mar 3, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.