Excel-Based Mark Book System for English Learning Area Tracking

Closed Posted 1 month ago Paid on delivery
Closed Paid on delivery

Project Title: Customizable Excel-Based Mark Book System for English Learning Area Tracking

This reads like a lot, but I am only trying to be clear.

It's just a mark book.

Project Overview

I need a skilled Excel developer to create a solution that helps schools track student progress against specific English Achievement Standards across year levels of the Australian Curriculum. The goal is to pinpoint areas needing improvement, empowering schools to target resources effectively.

Is it Speaking and Listening, Reading and Viewing, or Writing and Creating?

If so what particular Aspect (sentence?

Key Requirements

Foundation: Excel workbooks to accommodate multiple teachers and classes.

Structure:

Year Levels (tabbed sheets) with each year's Achievement Standards split into individual, gradable aspects.

Separate areas for classes, students, and tasks.

Task creation linked to specific Achievement Standard aspects.

Student grading interface with data linked to tasks and aspects.

Flexibility: Standardized workbook naming ("PrepA", "Year1B", etc.) to allow for scaling.

Master File: A central file pulls data from teacher workbooks, providing schoolwide reporting.

Automatic Updates: Master File refreshes data when teacher workbooks are saved (VBA preferred).

Reports: Basic summaries within teacher workbooks, and comprehensive reports in the Master File.

Desired Skills:

Proficiency in Excel: Deep understanding of formulas, data linking, and sheet structuring.

VBA Expertise: Experience with workbook events and automating updates.

UI Focus: Emphasis on clear navigation and user-friendly data entry within Excel.

Deliverables:

Workbook Templates:

Standardized teacher workbook template

Master File template

Documentation:

Complete user guide for teachers

Technical notes for file setup and maintenance

Additional Considerations

Future-Proofing: Please ensure for transitioning to a database-driven application for larger-scale situations.

Project Scope: This first phase focuses on creating the core functionality and establishing a solid foundation. There's potential for expanding features and reports in later phases.

Purpose:

Problem Statement: Schools need a focused method to pinpoint areas in English instruction (specifically Reading and Viewing, Listening and Speaking, Writing and Creating) requiring improvement.

Solution: A mark book tool enabling teachers to track student progress against specific aspects of English Achievement Standards within and across year levels. This will help schools optimize their efforts and resources.

All the Achievement Standards can be seen here:

[login to view URL]

It is literally the three paragraphs. The first is Reading and Viewing, the second Listening and Speaking, and the last Writing and Creating

Eg:

By the end of Foundation, students listen to texts, interact with others and create short spoken texts, including retelling stories. They share thoughts and preferences, retell events and report information or key ideas to an audience. They use language features including words and phrases from learning and texts. They listen for and identify rhymes, letter patterns and sounds (phonemes) in words. They orally blend and segment phonemes in single-syllable words.

They read, view and comprehend texts, making connections between characters, settings and events, and to personal experiences. They identify the language features of texts including connections between print and images. They name the letters of the English alphabet and know and use the most common sounds (phonemes) represented by these letters (graphs). They read words including consonant–vowel–consonant words and some high-frequency words.

They create short written texts, including retelling stories using words and images where appropriate. They retell, report information and state their thoughts, feelings and key ideas. They use words and phrases from learning and texts. They form letters, spell most consonant–vowel–consonant words and experiment with capital letters and full stops.

The grades are A-E (and N not rated).

I would like for each class, and each year level and then for all school (or selected year levels) graphs that show what areas need improvement.

Here shows how all the Aspects roll into the next year and align.

[login to view URL]

So there could be a GPA for the student, and a GPA for that Aspect of the achievement standard.

System Overview

User: Teachers

Data: English Achievement Standards broken into individual aspects (sentences) for each year level (Foundation-Year 10)

Key Capabilities:

Select a year level

Create assessment tasks linked to specific Achievement Standard aspects

Assign tasks to classes

Grade students on each aspect within a task

Generate reports to reveal trends in students' strengths and weaknesses

How it Works (Teacher's Perspective)

Select Year Level: Choose the appropriate year level (Foundation - Year 10).

Create Task:

Name the task (e.g., "Short Story Analysis")

Assign it to a school term (1-4)

Select the specific aspects of the Achievement Standards that this task will assess.

Assign to Class: Choose the class for which this task is intended.

Grading: For each student:

Assess them on each relevant aspect.

Assign grades (e.g., A, B, C)

Example: Task 1.1 - Short Story Analysis (Year 3)

Assessed Achievement Standard Aspects:

Listening and Speaking: They relate ideas; express opinion, preferences and appreciation of texts; and include relevant details.

Reading and Viewing: They identify literal meaning and explain inferred meaning.

Writing and Creating: They use text structures including paragraphs, and language features including compound sentences, topic-specific vocabulary and literary devices, and/or visual features.

Additional Considerations

User-Friendly Interface: Design should be intuitive for teachers.

Reports: Ability for teachers and school leadership to generate reports highlighting areas of concern and trends both across a class and over time.

Database: Secure storage for student data and assessments.

Excel VBA UI / User Interface Excel

Project ID: #37987880

About the project

57 proposals Remote project Active 1 mo ago

57 freelancers are bidding on average $422 for this job

P0L

Hello, I am an Excel/VBA expert and I would like to help you with your mark book system. Thanks for the extended project description, I may revise my proposal after having a closer look at the requirements. Please chec More

$750 AUD in 10 days
(501 Reviews)
8.0
UMERM41

As an Excel Master, I can claim to not just be capable of fulfilling but excelling in this project. For more than 5 years now, I have offered high-quality data management, and notably, advanced Excel services including More

$1000 AUD in 15 days
(23 Reviews)
6.3
LiveExperts

Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the More

$750 AUD in 3 days
(8 Reviews)
6.0
usmanbashir12100

Hi, Provides complete ranges of solution for your Excel, Custom Formulas, Functions, Pivot Table, Dashboards, VBA Macros Automation need. I have more than 18 years of experience and have worked for several renowned or More

$500 AUD in 7 days
(18 Reviews)
5.8
AmazingEngr76386

As an Excel and VBA expert with extensive knowledge in building efficient and user-friendly interfaces, I'm well-equipped to develop the customized Mark Book System you need for tracking English learning progress. My d More

$500 AUD in 7 days
(5 Reviews)
4.7
yesubabu10203

Hello there myself Yesu I am a vba developer I can do this you can contact me on this for further discussion thanks

$500 AUD in 1 day
(40 Reviews)
4.8
arwamoizds

Hi! With my expertise in Excel development and VBA programming, I am confident that I can create a tailored solution that aligns perfectly with your requirements. Based on the project overview you provided, I underst More

$750 AUD in 7 days
(5 Reviews)
4.1
ExpertSoul

I understand that you are looking for Excel-Based Mark Book System for English Learning Area Tracking I specialize in building custom Excel solutions, tailored to track student progress against English Achievement Stan More

$350 AUD in 2 days
(6 Reviews)
3.7
ajamshad162

As a highly experienced Excel and VBA expert, I've successfully completed over 50 similar projects in my career. Not only am I proficient in all aspects of Excel - from complex formulas to data linking and sheet struct More

$300 AUD in 3 days
(10 Reviews)
3.7
zubairmbafinance

As an Excel expert, I propose developing a comprehensive English Achievement Tracking System. I will create structured teacher workbooks for each year level, ensuring intuitive user interfaces. Using VBA, I'll automate More

$250 AUD in 4 days
(16 Reviews)
3.5
stheven19

As a data analyst with an extensive knowledge of Excel and Excel VBA, I am confident in my ability to create an effective, customizable mark book system that meets your unique needs. This project truly speaks to my exp More

$300 AUD in 7 days
(9 Reviews)
3.1
wilfrednjorog

Hello, Good morning? I hope this proposal finds you well. As an experienced freelancer, I have honed my skills in Excel VBA, UI / User Interface and Excel and am confident in delivering top-quality work. If you cou More

$560 AUD in 1 day
(1 Review)
2.9
fazalimamnuttkan

With a deep understanding of Excel, VBA expertise, and proficiency in database management, I am confident in my ability to excel (pun intended!) at creating your customized Excel-Based Mark Book System. Over the course More

$250 AUD in 7 days
(4 Reviews)
2.7
TayyabDastgir

Hello, Kindly consider initiating a CHAT to transform your aspirations into tangible reality, as I am eager to delve into the intricacies of your project and collaborate effectively to achieve your desired outcome. Her More

$250 AUD in 1 day
(3 Reviews)
2.7
OmidAA

you need: 1. excel based on rate system 2. based on A-E right?

$250 AUD in 1 day
(4 Reviews)
2.8
writerLanguage

Hello, As an Excel and VBA expert with a track record of over five years, I'm well-fitted to build the comprehensive, yet user-friendly mark book system you require. I've developed various Excel-based tools for differe More

$300 AUD in 4 days
(4 Reviews)
2.3
pcruiz

Hi, I have more than 20 years of experience in developing custom solutions for excel using formulas and macros. Upon reading your requirement, I see that it is achievable.

$500 AUD in 15 days
(4 Reviews)
2.2
khanpress713

As enticing as my curriculum vitae may be, it seems there has been a small confusion. I am not a graphic designer by trade; however, I am more than proficient in Excel and VBA programming. I have spent the last few yea More

$400 AUD in 1 day
(3 Reviews)
1.8
Imtiwrites99

Hey Silas M., I have carefully read through the project requirements for creating a customizable Excel-Based Mark Book System for English Learning Area Tracking. The goal is to provide schools with a tool to track stu More

$250 AUD in 1 day
(1 Review)
1.4
mian62

Hi I have read the requirements and understand them. I can assure you that if you work with me once, you will always work with me on these kinds of projects. would you like to discuss the project with me?

$320 AUD in 7 days
(4 Reviews)
1.6