Excel Dashboards
- or -
Post a project like this1581
$80
- Posted:
- Proposals: 10
- Remote
- #2626466
- Completed
Data Modeling in Excel & Power BI With Power Pivot, Power Query, DAX and Google Data Studio Expert.
Dhaka
Sr. Business Intelligence (BI) Consultant - Dashboard Reporting & Data Analysis - Power BI | Tableau | Advanced Excel
Indore
ADMIN SUPPORT / WEB RESEARCHER / PDF SOLUTION / DATA ENTRY / LEAD GENERATION / EMAIL SIGNATURE /AMAZON LISTING
Bay Minette
I will do any kind of Excel work from simple data entry to complex formulas and VBA,Macros,Dashboards,Reports
Faisalabad
208270194671422444572616776272709430114683015549318533333829803403777
Description
Experience Level: Entry
We want to create a monthly student and group report based on input from teachers and supervisors every day on attendance and observed skills.
1.Attendance is easy, yes or no, sum function, and % then monthly weighted average score based on attendance weight
2. For Skills: Teachers will rate each student from 1-5 on a number of skills (behaviours) for each class. We want the system (excel program) to compute average score for each skill by end of the month and generate a weighted average score for All Demonstrated Skills.
There should be 2 dashboards:
1. Group Results Dashboard: with average scores of all students for the 3 areas (attendance, behaviours, journal submissions)
2. Student Dashboards: Results (average scores) for each of the 3 areas.
Last but not least, how can we create a system so each teacher and supervisor can submit their daily student sheet (like attached) and the system automatically updates student data and dashboards (group dashboard and student dashboard).
1.Attendance is easy, yes or no, sum function, and % then monthly weighted average score based on attendance weight
2. For Skills: Teachers will rate each student from 1-5 on a number of skills (behaviours) for each class. We want the system (excel program) to compute average score for each skill by end of the month and generate a weighted average score for All Demonstrated Skills.
There should be 2 dashboards:
1. Group Results Dashboard: with average scores of all students for the 3 areas (attendance, behaviours, journal submissions)
2. Student Dashboards: Results (average scores) for each of the 3 areas.
Last but not least, how can we create a system so each teacher and supervisor can submit their daily student sheet (like attached) and the system automatically updates student data and dashboards (group dashboard and student dashboard).
Faisal C.
100% (46)Projects Completed
42
Freelancers worked with
34
Projects awarded
32%
Last project
5 Feb 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies