I did have a question for experienced users that has to do with best practices when displaying information on a dashboard though: Is it better to have a helper sheet, or use the Sheet Summary for information that I am collecting for my dashboard?
To give a little background, one of the things I am working on is collecting post-implementation surveys from team members. Of course I have to provide a "free-form" text field for additional comments, and not just the rating scales. I had started by creating a table that has a column for each text field, and has the formula:
This solution was working good, but I didn't like the fact that it had the column name in the data, and was looking for a solution to that, when I realized that since I use the Sheet Summary in other sheets, I could probably use the same formula on the original sheet and get the same results:
I get a better result when adding a Metric Widget from the Sheet Summary, than a Report Widget, which is a report running off the extra sheet that is collecting the data from the original sheet. (See picture below. The top two rows are from the report, the bottom two are from the Sheet Summary.)
With the Sheet Summary solution, templates are easier too. I am a big fan of having a template, configuring a few fields, and having the project mapped out in a couple of minutes. I simply copy the pre-configured template and modify it as needed. With the Post-Implementation survey, it is a snap.
So which should I do from a "best practice" standpoint? Is having all that data in the Sheet Summary going to slow down page loads, or is there something I am missing by using them? I think it might be the ideal solution when I am not referencing other sheets, but I am new to Smartsheet and would like an experts opinion before I make the changes to my templates.
I personally like to use a separate sheet (or sheets) to gather my metrics and whatnot for my dashboards. It provides for greater flexibility, better scaling, easier management and visibility when creating, etc..
I'm trying include a date range with counting the number of applicants within various depts, in certain date ranges, but it's saying incorrect argument set. =COUNTIFS(DISTINCT([Name of Requestor]:[Name of Requestor], [Submission Date]:[Submission Date], AND(@cell > DATE (2023, 9, 30), @cell
In order to maximize the amount of information that I am able to distill into just one sheet of paper, I use ball point pens (anything else will just bleed, making it harder to write in tight spaces) and write in neat columns to maximize the amount of space used. Color coded headings also help with finding what you need when you need it. Images can be difficult to format, but are usually necessary.
My first approach is to comb through all of the lecture notes for a unit and copy down virtually everything that was covered. You never know what odd equation or briefly mentioned concept might appear on a test. Once lecture notes have been copied down, I move onto key concepts or equations that I feel might be tested, followed by the copying down of any pset or practice exam questions that I think might be relevant in order to fill in the rest of the space.
Creating these cheat sheets is no walk in the park. They can take hours, predominantly because the physical act of copying down content is quite time consuming. But having everything that was ever covered in the class alongside you during an exam is worth every minute.
One could argue that cheat sheets as a learning instrument in classes are there to encourage students to study the material before the exam and bring in only the essential ideas and formulas on their limited sheet of paper that they have condensed after rigorous studying. After all, if they were going to let you bring in everything, why not just make it an open notes test? Or perhaps the theory is that the physical act of copying notes over again will better ingrain the information into your head?
One of the biggest differences between freshmen GIRs and sophomore major classes that I noticed was the shift from memory based exams to cheat sheet dependent ones. 8.02, 7.012, 18.02 and many of the other general classes that I took did not allow cheat sheets at the exam. We were tasked with memorizing a small handful of equations or concepts per unit and then tested on our ability to use them in relatively familiar settings. Beyond the introductory classes, beginning with 7.03 and 20.110 in the fall semester of sophomore year, the content became more extensive and complicated and the reliance on cheat sheet mediated test taking became commonplace. By allowing students to bring in cheat sheets, professors are given the freedom to test specific equations or concepts without having to worry about whether or not a student was able to memorize 12 different complex formulas. They are able to focus on testing comprehension of these formulas and application of the many concepts.
Has anyone discovered a brain dump sheet that helped get them through the exam? I used one for my SIE and did not use one for the Series 7 but I am curious if maybe Achievable could create a sheet to memorize going into the exam that will help with certain questions.
Other heavily tested Series 7 topics usually include debt securities (municipal products in particular), options, taxes, investment companies (mutual funds in particular), and dynamics of brokerage accounts (e.g. fiduciary accounts, required information to open different types of accounts).
Try BarNow for free! Sign up for the BarNow Demo Pack and you'll receive a sample study aid with official NCBE practice questions for 30 days. On BarNow, you can practice for the bar exam and the MPRE anytime, anywhere. Track your progress as you complete simulated exams and see your percent correct and average time spent per question. Learn more by visiting -barnow-demo-pack/
I am currently teaching an applied mathematics course for about thirty students with business-related majors, and I want to give them the opportunity to use a sheet of notes (a.k.a cheat sheet) on their first exam. I am concerned about the implementation of this policy; specifically, I want to ensure the following:
There is no way to cover every eventuality, but what helps is to have a clear paradigm as to what cheat sheets are supposed to achieve.Then view every decision you make regarding your exam in this respect.My paradigm (which may align with yours) is:
Memorising is your benchmark for fairness.You cannot avoid slight unfairness to some students (see below for some examples), but as long as your process is more fair than relying on memory, you have won.
Communicate your paradigm to the students.This way, you avoid that students use the cheat sheet in misguided way that is detrimental to them.Moreover, by teaching them the spirit of the rule, you reduce the chance and strengthen your position in case of any rule disputes and allow the students to answer certain questions about the rules themselves (do not rely on any of this though).
The most important part of memorising before a classical exam is structuring and reiterating the relevant knowledge as this strengthens the actual understanding of concepts (which is what your exam should be about).Making the cheat sheet handwritten replaces this.Provided cheat sheets are not good for this.The same applies to machinally created cheat sheets, as they can simply be created by copying and pasting.
On the other hand, make sure that whatever size limit you give suffices for the content the students should need, so you do not inadvertently reward those with a smaller handwriting, better eyesight, finer pen, etc.Giving them slightly more space than they need is not a problem; giving them much more space is.
Handwritten cheat sheets will pose problems to some handicapped students. (Just like memorising is bad for people who have issues with memorising or anxiety.)Ensure beforehand that every student can voice such problems so that a reasonable alternative can be found for them.
This does not agree with the above paradigm:You cannot control what students memorised for the exam either.It may be helpful to verify and helpful to evaluate your approach to cheat sheeting by collecting the cheat sheets anonymously, but this deprives the students of re-using their cheat sheets.
His reasoning? He figured that most students would discard their notes at the end of the term, but some would at least keep their textbooks. And pertinent formulas and such would be scrawled inside the front and back covers.
Keeping the notes with the exam sheet means there is little overhead, but it gives you the option to get a general idea of what students are writing down and may help give context when grading a particular student's exam.
Even if you choose not to review the notes, collecting them with the exam allows the students to eventually keep the notes without giving them the ability to write confidential exam information on their paper and possibly use it to help other students cheat.
Ask, in class, for suggestions: How long would you like the note sheet to be? Write down all suggestions, and set up an online poll with a deadline. Pick the one with most votes by the deadline, no extensions or excuses.
Have the students prepare the sheet a week before the exam, and organize a Q/A session based on the sheets. Have the students prepare sheets, and perhaps bring your own suggestion to how you would make a sheet, but tell them that sheets organizing knowledge are per definition individual. Allow the students to compare sheets (in groups if there are many students) and discuss among themselves.
Even as an engineer, I rarely need these formulas in my life (last I needed a formula was about a year ago), and even when I do, there are sites such as Wolfram Alpha or Wikipedia that will give me a hand.
For what reason? Do you want to increase your workload, just to see if they wrote down entire questions? Taking the papers is somewhat like homework with additional steps, I suggest leaving them with the students. Even if they just throw away their sheets right after the exam.
3a8082e126