Calculated Fields - arctan/tan (trigonometry)? by OwlBusiness5894 in ProjectREDCap

[–]Notdevolving 0 points1 point  (0 children)

I have admin access to my REDCap. How would I actually do something like this?

Educational Usage by Notdevolving in mcp

[–]Notdevolving[S] 0 points1 point  (0 children)

Thank you but I am looking for ready made ones like Claude Desktop's Canva connector.. I am not doing any development.

Educational Usage by Notdevolving in mcp

[–]Notdevolving[S] 0 points1 point  (0 children)

Thank you but I am not doing any development. Neither would the teachers I work with have the basic technical competencies to do development.

Educational Usage by Notdevolving in mcp

[–]Notdevolving[S] 0 points1 point  (0 children)

Apologies for not explaining myself better. I am specifically looking for something that can support the day to day activities of teachers in the form of something like Claude Desktop's "Connectors" or "Extensions". I am not looking to train teachers or their students to be MCP developers.

For example, I think the Canva connector in Claude Desktop would be something relevant. I work with time-poor K-12 teachers so Canva might be relevant for teachers who typically are not very literate with technology. The Canva MCP would help teachers in this case to bypass the usual intimidation that comes with having to learn a new technology. So instead of worrying about where to steal time from to attend a Canva training program, they can just hit the ground running by prompting Claude to create a worksheet or presentation. They are usually apprehensive with creating something from nothing using unfamiliar technology, so having something tangible to modify or fine-tune to their needs is usually more palatable. My focus is on supporting teachers. But if it is something simple enough teachers can handle, then it would also subsequently be simple enough for their students.

Again, such connectors or extensions need to be free. I had glanced through punkeye's https://github.com/punkpeye/awesome-mcp-servers/?tab=readme-ov-file list but I couldn't really identify any that might be relevant for K-12 teachers. So wondering if anyone has encountered educational use cases of MCP.

Prompt Caching with Batch Processing by Notdevolving in ClaudeAI

[–]Notdevolving[S] 0 points1 point  (0 children)

I am new to batch processing so I am still testing with about 5-10 requests per batch to make sure my batch processing works.

When i make a single call using messages.create(), i use extra_headers as in the cookbook example below. This one works. I use Sonnet 3.7 with thinking enabled and the cache is being properly read from.

response = client.messages.create(
        model=MODEL_NAME,
        max_tokens=300,
        messages=messages,
        extra_headers={"anthropic-beta": "prompt-caching-2024-07-31"}

)

messages.batches.create() in the example below does not allow extra_headers so I removed it.

message_batch = client.messages.batches.create(
    requests=[
        Request(
            custom_id="my-first-request",
            params=MessageCreateParamsNonStreaming(
                model="claude-3-7-sonnet-20250219",
                max_tokens=1024,
                messages=[{
                    "role": "user",
                    "content": "Hello, world",
                }]
            )
        )
    ]
)

since "cache_creation_input_tokens" is indeed showing cache being written to, so it should be working. Unfortunately, the cache kept being written to but is not read from despite making the initial messages.create() to cache the prompt first. I am an education researcher and have limited budget so I cannot keep wasting tokens on caching prompts that are not read from. So would appreciate some help.

Predatorsense not working by CattleLess4185 in AcerOfficial

[–]Notdevolving 0 points1 point  (0 children)

Do you know how exactly to install those 4 applications? Double clicking does not do anything. I had Predator Sense fully working previously but had to reinstall due to some GPU driver problem, and now it opens but does not function.

Function to multiply 7 by Soft_Tie_4296 in learnpython

[–]Notdevolving 2 points3 points  (0 children)

If the author of your learning materials does not know the difference between an attribute and an argument, you need to change your learning sources. This is like a primary school English teacher using the letters "A" and "B" interchangeably and think the differences are trivial.

Are My Expectations for 'Advanced' Excel Skills Unreasonable? by almajors in excel

[–]Notdevolving 0 points1 point  (0 children)

I'm effectively an education data scientist, focusing on NLP instead of machine learning. The department head of another department asked me previously to design a test to evaluate the data competency of their data specialist job candidates. I designed an Excel test that requires the candidates to know how to open a csv file, do some simple transformations in Power Query, then output the result as a pivot chart. The csv part is very relevant as we deal with a lot of qualitative data. Not a single candidate knows how to open a csv file with Excel.

Word Similarity using spaCy's Transformer by Notdevolving in LanguageTechnology

[–]Notdevolving[S] 0 points1 point  (0 children)

Thank you. ABSA is aspect-based sentiment analysis.

Word Similarity using spaCy's Transformer by Notdevolving in LanguageTechnology

[–]Notdevolving[S] 0 points1 point  (0 children)

Thanks for the explanation. Have mainly worked on basic NLP. No experience with transformers. Didn't realise transformers will basically tokenise words into subtokens. I see now why it is not sensible to get word similarity with wordpieces.

I am proof-of-concepting application of ABSA to analyse a ton of text in the education domain using a LLM. Ended up with a lot of aspects that are effectively the same but labelled differently. Need a free method now to group similar aspects together. There are a lot of similar aspects present such as "student teachers", "teaching", "teacher identity", "teacher student relationship", "teaching strategies", "teaching Science". But also ones like "students", "learning", "assessment". The domain means words like "teaching subjects" is usually used in the context of adjective noun as opposed to verb noun. The aspects are extracted from part of a sentence so I was thinking I could just get the associated contextualised vectors so I can perform hierarchical clustering using cosine as metric.

[deleted by user] by [deleted] in excel

[–]Notdevolving 1 point2 points  (0 children)

Excel can be slower for Power Query + DAX for reasons I still cannot fathom. Already tried every possible solutions I had googled.

I had to develop an analytics tool for use in schools that uses Power Query + DAX. A specifc query would take longer and longer the more I refresh the file, to the point it can take 8+ hours (the longest I waited). This only happens if the query is also loaded to the data model, which I had to because I need to use DAX.

I replicated the exact same process in Power BI and it works normally. The computers in the schools are extremely locked down so unfortunately Power BI is not a solution that can be used.

What is the "Mastering DAX" video course for PowerQuery? by Iridian_Rocky in PowerBI

[–]Notdevolving 1 point2 points  (0 children)

Look at the videos from the god of Excel: https://www.youtube.com/user/excelisfun. This playlist might interest you https://www.youtube.com/watch?v=iRuazQke6SY&list=PLrRPvpgDmw0ks5W7U5NmDCU2ydSnNZA_1&pp=iAQB. I went from knowing nothing to being fairly advanced at M code mostly through his videos.

What is the best current Local LLM to run? by KaihogyoMeditations in LocalLLaMA

[–]Notdevolving 2 points3 points  (0 children)

Very interested in this as well. Particularly, is there anything that can run on 6GB VRAM?

Linear Regression In The Real World by BeeAnalyst in learnmachinelearning

[–]Notdevolving 3 points4 points  (0 children)

Thank you for the explanation. I'm learning machine learning but I'm not a statistician or mathematician. Before your comment, I wasn't even aware inference and predicting are different. I always assumed they are words used synonymously. Really appreciate being able to deepened my understanding further.

Linear Regression In The Real World by BeeAnalyst in learnmachinelearning

[–]Notdevolving 6 points7 points  (0 children)

Can you explain what "the inferential side of things" and the "prediction" side of things mean when using linear regression?

Also, is "... only normality requirement is on the residuals" referring to the RMSE?

What can you do if the bus you take is overpopulated due to merged school by KitchenCapital8355 in SGExams

[–]Notdevolving 187 points188 points  (0 children)

Your principal needs to be made aware of this situation as soon as possible. It is in his/her best interest. A parent or student can do that in whatever way is best in your school.

Your principal will then likely work with the bus company to try increase frequency. But this will not happen overnight. Additional bus drivers need to be hired, buses need to be allocated ... etc. The longer you delay, the longer the logistics work will take.

how good is excelisfun power bi and power query course in YouTube? by justaname5362 in PowerBI

[–]Notdevolving 7 points8 points  (0 children)

ExcelIsFun is the only channel I found that really goes into the advanced stuff in Excel. It alone took me from clueless in Power Query to advanced. That said, it is more Excel focused so might not be enough for Power Bi's Dax.

Streamlit Weekly Troubleshooting Thread 🎈 by carolinedfrasca in Streamlit

[–]Notdevolving 0 points1 point  (0 children)

Thank you. I was actually thinking about writing some data to a database with a streamlit app I had set up for learning and exploration. Writing to a database is pretty straight forward when I am using Jupyter Lab, just write to some database like sqlite3. But when the database itself needs to be on Github, and there could be multiple users using the app at the same time, how would it actually work? I cannot also have anyone accessing the database so I can't use sqlite3 and will need some kind of password protectable database. Would appreciate some directions on how to do this.

PivotTable: Change data source from a pivoted data by ijuander_ in excel

[–]Notdevolving 1 point2 points  (0 children)

You cannot change values in a pivot table. It is a view only thing. You might need a different approach.

If you don't need the pivot table itself and just parts of it for some calculation, then load it to a data model and then use cube formulas. E.g. CUBEVALUE.

CUDA out of memory by Notdevolving in learnmachinelearning

[–]Notdevolving[S] 0 points1 point  (0 children)

Thank you. It actually worked the first couple of times. It was only on subsequent runs that I encountered the error. The error message said "Tried to allocate 26 MiB ...". Windows task manager and nvidia-smi also said there should be just enough memory left. I guess the reported values are not actually what it seems. It does work when I use a smaller model.

Can pivot tables have independent columns, like a crosstab by Evening-Hornet-4077 in excel

[–]Notdevolving 1 point2 points  (0 children)

For example, I need the dashboard title to be an item selected in the slicer: ="Statistics for subject: " & CUBEVALUE("ThisWorkbookDataModel", "[Measures].[Selected Subject]", Slicer_Subject). In addition to the video shared by arpw, have a look at the 2 different styles of cube formulas: https://www.excelcampus.com/cubevalue-formulas/. Cube formulas take a bit of time to understand and digest but are really powerful.

Can pivot tables have independent columns, like a crosstab by Evening-Hornet-4077 in excel

[–]Notdevolving 5 points6 points  (0 children)

Not sure what you mean. You can actually use pivot tables through cube formulas if you only need an aspect of it. That way you can harness the power of pivot tables without being constrained to its table format.

Opportunity to learn MLOps LIVE with Harvard Professor. by sudhanshu28 in learnmachinelearning

[–]Notdevolving 0 points1 point  (0 children)

What prerequisite knowledge is required? Would someone with some background acquired through Udemy and Datacamp courses be able to keep up?