Please either Logon or create a New Account.
Tag
DDA (7)
Our registrar is attempting to break up a few very large study halls into smaller sections. Since you can't mass unenroll students from a course section, this will be a long, tedious process for her. I found a post on PSUG from 2006 that said you can just delete a course section and everyone in that section will be dropped from the course. Then you can re-create sections and mass enroll students.

This seems too easy and like it would leave orphan files. Has anyone done this? Can you just delete the section form the Edit Section screen? (School Setup > Section > Edit Section > Delete Section).

Or do I delete the section through DDA? (DDA > CC table > SectionID=### >  Modify Records > Delete section)

Is there a better way to unenroll about 160 students from course sections? Anything to avoid one-by-one modify schedule option!

TIA

Jane Campbell / Marian High School / Omaha, NE

 
Tags: DDAScheduling
Comments
2 Responses to "Can you delete a section with students enrolled in it?"

We had a similar situation last year, Jane. Here is the method we used to handle moving the student enrollments fairly quickly (deleting the section wasn’t an option for us as the term had already started; I would be concerned about ghost enrollments in your situation and advise against deleting the section with students enrolled):
Create all of the needed sections so they are ready to enroll students.
Then from the large section page that lists all of the students use the checkboxes to select a group of students needing moved to a specific section. Use the Drop and re-enroll button to move the group of students together to the correct section. Repeat this drop and re-enroll with each group of students from the original large section until it is down to only one of the smaller sections.
Good luck!
 

That looks very easy. Thanks, Amanda! :-)

Post Your Comment



The registrar accidentally enrolled a student into the wrong school. We have an Admissions school where we are enrolling all new students for next year. They will be transferred to our main school at EOY. This student was enrolled into our current school, has an enroll_status of -1 and entry date is 8/17/2018. She has no course requests and the only record I can find in DDA is in the Students table. Can I just change her SchoolID field in DDA > Students table to the correct school? TIA.

Jane Campbell / Marian High School / Omaha
Comments
4 Responses to "Student enrolled in wrong school" (view all)

The fields you need to change are
schoolid
enrollment_schoolid

That is what I do

Suzanne

Thanks, Suzanne!

You will also want to reset the FTE as that is unique to the school and will not carry over to the new school.

Kristi

Post Your Comment



Hi All,

First post for me and hopefully the first step on the path to feeling more positive about Powerschool!
Within the student table, I have two fields - Student_Web_ID and Student_Email. Student_Email is exactly the same as Student_Web_ID except with the addition of @domain.com on the end.

I would have thought there would be a straightforward way of copying the data from one field to another, but I have so far been stumped. I thought I had solved it using ~([01]Fieldname) but this only produces the right results within Powerschool (as it interprets the call on the fly). I need to fill the field with the correct data, as I will be exporting this data for use within Follet Destiny.

Right now, I am thinking I will simply export the relevant data, amend it as necessary and then import it back in to the email field. However, I find myself relying more and more on external software to manipulate and present the data held in Powerschool. Does anyone know of a way to complete what I feel is a basic task, solely within Powerschool?

Many thanks for any suggestions,

Al
Tags: DDAPowerSchool
Comments
2 Responses to "Automatically copy data from one field to another"

Al,

Unfortunately there is no automatic way in PS to move values from one field to another. It probably could be done by writing some java scripts, but for a one time mass change it would be faster to export the fields (make sure you export the Student_Number), manipulate it and then reimport it back into the Student_Email field. 

Just to clarify and not b/c it matters, Student_Email is a custom field correct? 

Wayne Wiens
ESU 10


Yes, the email field is custom. Earlier today, I gave up and exported-modified-imported. The thing is, I am doing this kind of thing more and more - using third party software for data manipulation and presentation - because PS either doesn't have the function I want or it is such a headache to make it perform a task.

Some of the problem may be due to my expectations. When I build an interface for a database, I want to make sure it is as simple to use as possible, while offering as many options as I can imagine. Referencing an existing value and filling a field with that data is pretty rudimentary and I can imagine many other applications for such a function.

I guess what I mean is that I am spending too much time trying to make PS do what I think it SHOULD do, rather than simply working with the functions I KNOW how to use. In the end, as long as I can get the result I want, I should opt for the simpler method, whether it is outside of PS or not.

Post Your Comment



How can I pull all the standards issued for a specific class and a specific

teacher for a specific term.



For example. In Elementary, each student has three standards they are assessed

on duringg Q1. They do this in the gradebook under final grades.



I want a list of all students and each standards grade for Q1. It sure sounded

easy to me until I started looking.
Tags: DDA
Comments
3 Responses to "Pulling standards grades from DDA"

This is the code I have in my 1st Grade report card to pull the "score" for Understands math concepts.

M.1.MC is the abbreviation for the standard.

<TABl .375>Understands math concepts<tabc 3.375>^(*std.stored.transavg;M.1.MC;Q1)<tabc 3.625>^(*std.stored.transavg;M.1.MC;Q2)<tabc 3.875>-<tabc 4.125>^(*std.stored.transavg;M.1.MC;Q3)<tabc 4.375>^(*std.stored.transavg;M.1.MC;Q4)<tabc 4.625>-

I'd be happy to share my report card with you. You could tweak it to suit your needs and you wouldn't have to reinvent the wheel.

I have pulled them for my report card, but I was wondering how to pull them from DDA as well. I may try exporting it with this code and see what happens.

What happens if you go to Standards in DDA and then choose StandardsID from the pull down and then put the ID in? I would think you'd have to do that for every single one. It might be easier to take your report card text and put it into new object report.

Just thinking off the top of my head....

Post Your Comment



Last fall when my elementary kids got scheduled, the last day was put in wrong and I need to change them all. I imagine I can do this in DDA, but I'm not sure which table to go to. Can anyone point me in the right direction?

Thanks in advance!
Tags: DDAPowerSchoolScheduling
Comments
1 Response to "Changing exit date on course sections"

I figured it out. It was in the CC table.

Post Your Comment



In one of my schools, my secretaries were getting an error in the ada/adm by date report.

They were seeing a negative number in the report.  


10/20/2008   MON (A)   40.00  -32.00

The work fix to this error was in the report setup.
I could not leave default settings for

Attendance Mode   

Attendance Conversion

I had to define them.  When I did define them, then my report worked and I got positive numbers.

Jane



Tags: ADA/ADMDDA
Comments
0 Responses to "How I fixed a negative number error on my ADA/ADM by Date report"

Post Your Comment



Here are screen shots to show the difference between DDA and DDE.








Tags: DDADDE
Comments
8 Responses to "DDA and DDE - Difference" (view all)

Thanks!

Good Job Brian!

Thanks Brian, as always you are a wealth of information!

Post Your Comment



  1