I need assistance designing an excel workbook that tallies scores for individual students that identifes trends (movements) and creates reports, graphs, alerts etc.
The workbook is to be set-up for the entire school year broken up into Terms (1, 2, 3 & 4) with approximately 10 individual weeks for each term. We will need to set-up the dates etc.
The front page is a vertical class list where the classroom teacher can simply tally results against individual students. This will be done once a week. This data needs to be converted into a seperate report that outlines percentages for students in relation to the entire class and creates a bar graphs for each student.
I would like the functionality to produce a weekly report as well as a consolidated report for the following weeks. These reports then inform a Term overview report and then a yearly overview report.
I want to be able to track all changes week from week with an alert if there is significant change. For example, student X recieved 8 tallies week 1, 7 tallies week 2, 9 tallies week 3 and 2 tallies week 4. Week 4 was a significant change so this triggers an alert to the teacher (change of font, preprepared statement such as 'student at risk' etc)
Week 1 term 1, one single report and graph produced.
Week 2 term 1, week 2 report and graph produced and a consolidated report and graph produced capturing the information from week 1 and 2, and so on until week 10 of term 1.
Week 1 term 1 I need assiatnce designing an excel workbook that tallies scores for individual students that identifes trends (movements) and creates reports, graphs, alerts etc.
The workbook is to be set-up for the entire school year broken up into Terms (1, 2, 3 & 4) with approximately 10 individual weeks for each term.
The front page is a vertical class list where the classroom teacher can simply tally results against individual students. This will be done once a week. This data needs to be converted into a seperate report that outlines percentages for students in relation to the entire class and creates a bar graphs for each student.
I would like the functionality to produce a weekly report as well as a consolidated report for the following weeks. These reports then inform a Term overview report and then a yearly overview report.
I want to be able to track all changes week from week with an alert if there is significant change. For example, student X received 8 tallies week 1, 7 tallies week 2, 9 tallies week 3 and 2 tallies week 4. Week 4 was a significant change so this triggers an alert to the teacher within the report (change of font, preprepared statement such as 'student at risk' etc)
Week 1 term 1, one single report and graph produced.
Week 2 term 1, week 2 report and graph produced and a consolidated report and graph produced capturing the information from week 1 and 2, and so on until week 10 of term 1.
Week 1 term 2, week 1 report and graph produced and a consolidated report and graph capturing all data from term 1 reports produced.
This cycles through to the end of the school year.
I posses expertise in utilizing advance level tools of MS Excel to perform data analysis, creating reports, financial modeling, trend analysis & statistical analysis with years of experience.
Relevant Skills and Experience
I will be happy to discuss in detail regarding my qualification, my experience and how I am suitable for this project.
Proposed Milestones
$90 AUD - Complete Milestone
$90 AUD in 3 days
4.7 (45 reviews)
5.3
5.3
8 freelancers are bidding on average $203 AUD for this job
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement
Relevant Skills and Experience
I have the 5 years of experience with excellent knowledge. please give me a chance to work on your project
Proposed Milestones
$200 AUD - payment after work completion
Build excel tool to Track Student Disconnection
Relevant Skills and Experience
Excel/VBA
Proposed Milestones
$250 AUD - Completed tool
Hello, I Have more than 14 years of exp. Completed 320+ projects. Look at my feedback. Thanks.
Dear sir
I am an excel professional having hands on expertise in developing spreadsheet for analytical purpose I will do your project as per your requirements.
Best regards
Humayoon
Relevant Skills and Experience
Excel
Dear client I would like to do your project .
Please consider working with me with everything done as required.
If you have additional requirements, please talk to me.
Best regards!
Relevant Skills and Experience
Excel
Proposed Milestones
$50 AUD - work