Create Formulas for Easy Weighted Gradebook

Completed Posted Sep 2, 2014 Paid on delivery
Completed 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!!

Data Entry Data Processing Education & Tutoring Excel

Project ID: #6404505

About the project

19 proposals Remote project Active Sep 3, 2014

Awarded to:

ethicalboy

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 exce More

$13 USD in 1 day
(62 Reviews)
5.3

19 freelancers are bidding on average $20 for this job

Teloquence

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. Ea More

$30 USD in 0 days
(221 Reviews)
7.0
nagybatonyi

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 ho More

$25 USD in 0 days
(55 Reviews)
5.7
shikhamehta

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 More

$25 USD in 3 days
(103 Reviews)
5.6
JonNxt

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 More

$30 USD in 1 day
(25 Reviews)
4.5
teeares

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
(22 Reviews)
4.3
jal540

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 sel More

$25 USD in 3 days
(12 Reviews)
4.3
mirabueno319

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 days
(13 Reviews)
4.1
farr4u

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 days
(23 Reviews)
4.1
Frileser

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 assignem More

$25 USD in 1 day
(2 Reviews)
3.2
dsarang

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 More

$15 USD in 1 day
(3 Reviews)
2.3
neogisticsindia

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 as More

$10 USD in 1 day
(1 Review)
1.7
Muhammad78608

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
(3 Reviews)
1.6
vicfa

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
(1 Review)
1.1
PrestonPhelan

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 quest More

$10 USD in 0 days
(1 Review)
0.1
scgarland

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 Reviews)
0.0
mjdr2584

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 Reviews)
0.0
msimikic

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) More

$10 USD in 1 day
(0 Reviews)
0.0
MBM07

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 More

$15 USD in 1 day
(0 Reviews)
0.0