| *** mobert has joined #schooltool | 00:59 | |
| *** mobert has quit IRC | 01:34 | |
| *** menesis has quit IRC | 02:19 | |
| *** kwak has joined #schooltool | 06:30 | |
| kwak | hello... | 07:10 |
|---|---|---|
| *** kwak has quit IRC | 07:56 | |
| *** menesis has joined #schooltool | 11:26 | |
| *** menesis has quit IRC | 12:53 | |
| *** yvl has joined #schooltool | 13:04 | |
| *** menesis has joined #schooltool | 13:43 | |
| *** replaceafill has joined #schooltool | 16:28 | |
| *** th1a has joined #schooltool | 16:31 | |
| th1a | Oh, what time is it replaceafill? | 16:53 |
| replaceafill | 8:54 | 16:54 |
| th1a | When are we meeting now? | 16:54 |
| replaceafill | your call | 16:55 |
| replaceafill | can you meet an hour earlier? | 16:55 |
| th1a | Like 25 minutes ago? | 16:55 |
| replaceafill | yeah | 16:56 |
| th1a | We just turned our clocks back. | 16:56 |
| replaceafill | 9:30 am your time? | 16:56 |
| th1a | Yeah. | 16:56 |
| th1a | That is the same time for you? | 16:56 |
| replaceafill | yes | 16:56 |
| th1a | Yeah, that's fine. | 16:56 |
| replaceafill | cool | 16:56 |
| replaceafill | so | 16:56 |
| replaceafill | i have lots of reports | 16:56 |
| replaceafill | i'll set up a separate instance, so i don't mess with their demo | 16:57 |
| replaceafill | give me a few minutes | 16:58 |
| th1a | OK. | 16:58 |
| replaceafill | ok th1a | 17:18 |
| replaceafill | http://dev.schooltool.org:9191 | 17:18 |
| th1a | Oh... let me grab a bagel before we get into this. | 17:18 |
| th1a | Just a sec. | 17:18 |
| replaceafill | kk | 17:18 |
| th1a | OK. | 17:21 |
| replaceafill | let's take a look at Sunesh spreadsheets | 17:22 |
| replaceafill | Demographic snapshot report 070814.xlsx | 17:22 |
| th1a | OK. | 17:23 |
| replaceafill | so, most of the reports are in the Student/Teacher Attendance views | 17:23 |
| replaceafill | Demographics snapshot is under STudent Attendance | 17:23 |
| replaceafill | most of these may live under more appropriate contexts | 17:24 |
| replaceafill | like terms | 17:24 |
| replaceafill | i just grouped them all together for now | 17:24 |
| th1a | That's the right move, really. | 17:24 |
| replaceafill | Demographics Snapshot is the 5th | 17:24 |
| th1a | We got a little overboard on those time span reports. | 17:24 |
| th1a | nobody ever finds them. | 17:25 |
| replaceafill | the first 4 are the old oness | 17:25 |
| th1a | Can we put a little reverse indent or something on the list of reports? | 17:25 |
| th1a | Or just better spacing between them? | 17:25 |
| replaceafill | ah ok | 17:26 |
| replaceafill | hold on | 17:26 |
| replaceafill | boy, i'm rusty editing css in place :D | 17:29 |
| replaceafill | see 6px bottom padding | 17:29 |
| replaceafill | or padding bottom | 17:29 |
| replaceafill | whatever :D | 17:30 |
| th1a | That's better. | 17:30 |
| replaceafill | it moved the other things, but focus on the Reports ;) | 17:30 |
| replaceafill | i'll fix it right later | 17:30 |
| replaceafill | kk | 17:30 |
| th1a | OK, what am I looking at now? | 17:30 |
| replaceafill | demographics snapshot | 17:31 |
| th1a | What's it called on the instance? | 17:31 |
| replaceafill | Demographics Snapshot | 17:31 |
| replaceafill | under Student Attendance reports | 17:32 |
| replaceafill | 5th one | 17:32 |
| th1a | Whoops, I had teacher attendance. | 17:33 |
| replaceafill | :) | 17:33 |
| replaceafill | so, first comment | 17:34 |
| replaceafill | i mostly used numbers for cell output | 17:34 |
| replaceafill | i think it's the right way to spit xls's | 17:34 |
| replaceafill | even if you get weird numbers like 33.33333333 | 17:34 |
| replaceafill | and so on | 17:34 |
| replaceafill | some of the old functionality (and a couple of new reports) will use formatting to trim decimals | 17:35 |
| replaceafill | i wanted your opinion on this | 17:35 |
| th1a | Yeah, I don't know if you can set it to just display 2 decimal places using xlwt. | 17:37 |
| th1a | I don't think I'd round the data before putting it in the spreadsheet. | 17:37 |
| replaceafill | i remember reading something about using # and 0s | 17:37 |
| replaceafill | i think it's possible | 17:38 |
| replaceafill | i'll check | 17:38 |
| replaceafill | (to display 2 decimals) | 17:38 |
| replaceafill | another comment | 17:38 |
| replaceafill | on demographics snapshot, i tried to style the sheet | 17:38 |
| replaceafill | i know it's not that important | 17:38 |
| replaceafill | but i think it looks better than some of our yellow headers, etc :) | 17:39 |
| replaceafill | and we need a description for all of these new reports | 17:39 |
| th1a | It is possible in excel, just a question of if xlwt does it. | 17:39 |
| th1a | So this is Peas only. | 17:40 |
| th1a | And S1, etc. are levels? | 17:40 |
| replaceafill | yes | 17:40 |
| th1a | OK so, attendance broken down by level and gender, including additional demographic data. | 17:41 |
| th1a | ? | 17:41 |
| replaceafill | actually, this one doesn't have attendance info | 17:42 |
| replaceafill | level enrollment maybe? | 17:43 |
| th1a | Oh, sorry. | 17:43 |
| th1a | Hrm. | 17:43 |
| th1a | Can this just go under school then? | 17:43 |
| replaceafill | yeah | 17:43 |
| th1a | Overview of demographic distribution over the levels in the school. | 17:44 |
| replaceafill | kk | 17:44 |
| replaceafill | i will write down all of these changes | 17:45 |
| replaceafill | and will work on them after the meeting | 17:45 |
| th1a | OK. | 17:45 |
| replaceafill | ok, now fees | 17:45 |
| replaceafill | open Fee Report suggest 250914.xlsx | 17:45 |
| replaceafill | again, under Student Attendance reports | 17:46 |
| replaceafill | Fee Collection Rate | 17:46 |
| replaceafill | it should match the "For students" sheet in the xls | 17:47 |
| replaceafill | here they requested some control on the collection rate | 17:47 |
| replaceafill | and you can see they have to select the term too | 17:47 |
| replaceafill | obviously, for this report to work, students should have Fees created | 17:48 |
| replaceafill | credits and debits | 17:48 |
| replaceafill | with proper dates | 17:48 |
| replaceafill | that match the term | 17:48 |
| th1a | OK, I'd just put these under school as well. | 17:49 |
| replaceafill | ah ok | 17:49 |
| replaceafill | descriptions for them? | 17:50 |
| th1a | "Fee Collection Rate" title should be... | 17:51 |
| th1a | Unpaid Students ? | 17:51 |
| th1a | Erm... | 17:51 |
| th1a | Maybe that's fine. | 17:51 |
| replaceafill | Unpaid Students? | 17:51 |
| th1a | Does that make sense? | 17:51 |
| replaceafill | sure | 17:51 |
| th1a | OK. | 17:51 |
| replaceafill | same for the by week one? | 17:52 |
| replaceafill | Unpaid Students By Week? | 17:52 |
| th1a | Well, that is the actual rate. | 17:52 |
| replaceafill | right | 17:52 |
| th1a | So I think it can be the same and doesn't need a description. | 17:53 |
| replaceafill | ah ok | 17:53 |
| th1a | I'd change "Collection Rate" to "Payment threshold" | 17:53 |
| th1a | IN the dialog. | 17:53 |
| replaceafill | ah ok | 17:54 |
| th1a | Description "By term, with adjustable payment threshold." | 17:54 |
| replaceafill | cool | 17:55 |
| replaceafill | ok, moving on to attendance reports? | 17:56 |
| replaceafill | Attendance Report suggestions 250914.xlsx | 17:56 |
| replaceafill | the first three sheets: | 17:56 |
| th1a | ok. | 17:56 |
| replaceafill | by day, by week, by term | 17:57 |
| replaceafill | match the Student Attendance reports: | 17:57 |
| replaceafill | Attendance Rate By Day | 17:57 |
| replaceafill | Attendance Rate By Week | 17:57 |
| replaceafill | Attendance Rate By Term | 17:57 |
| replaceafill | by day asks for a date range | 17:57 |
| replaceafill | and all of them ask for a Day/Boarding option | 17:57 |
| replaceafill | to filter students accordingly | 17:58 |
| replaceafill | that's how i understood: "Question: we would like to be able to choose the category of student shown in the report - this example covers boys, girls and all students, but it would be good to disaggregate further to day/boarding within these overall categories" | 17:58 |
| th1a | Do we have any control over column/row width in xlwt? | 17:58 |
| replaceafill | i think there's auto adjust somewhere | 17:58 |
| replaceafill | i'll check | 17:59 |
| th1a | I don't think the first three need descriptions. | 18:05 |
| replaceafill | ah ok | 18:05 |
| replaceafill | ok moving to the By absentteism sheet then | 18:06 |
| replaceafill | i called it "Absenteeism Report" :) | 18:06 |
| replaceafill | i used two sheets in the same xls | 18:07 |
| replaceafill | and hard-coded the 75% attendance rate | 18:07 |
| th1a | ok | 18:07 |
| replaceafill | and the 3 days in 10 days | 18:07 |
| replaceafill | 3 days in the last 10 days | 18:08 |
| replaceafill | we could provide options for all of these ofc | 18:08 |
| replaceafill | but they didn't request them :) | 18:08 |
| th1a | "Students with less than 75% attendance and 3 absences in the past 10 days. | 18:09 |
| th1a | " | 18:09 |
| th1a | For description. | 18:09 |
| replaceafill | kk | 18:09 |
| th1a | Looks fine to me. | 18:09 |
| replaceafill | cool | 18:10 |
| replaceafill | to Teacher attendance then | 18:10 |
| replaceafill | i split the sheet in two reports | 18:11 |
| replaceafill | they're under the Teacher Attendance tab | 18:11 |
| replaceafill | Attendance Rate By Day | 18:11 |
| replaceafill | Absenteeism Report | 18:11 |
| replaceafill | Attendance Rate By Day is the top-right table | 18:11 |
| replaceafill | (i think) :) | 18:11 |
| th1a | OK, you can use the same descriptions as for the student reports. | 18:12 |
| th1a | Look ok to me. | 18:12 |
| replaceafill | ah ok | 18:12 |
| replaceafill | and finally the For PEAS UK sheet | 18:13 |
| replaceafill | this is mostly done (not in the branch yet) | 18:13 |
| replaceafill | but i have a question | 18:13 |
| replaceafill | for some reason they split the term in 12 weeks | 18:13 |
| replaceafill | 1-4, 5-8, 9-12 | 18:13 |
| replaceafill | three grouped columns | 18:14 |
| replaceafill | and a total | 18:14 |
| replaceafill | this looks "random" to me | 18:14 |
| replaceafill | should we ask for an option value? | 18:15 |
| th1a | Is this in a more recent email? | 18:15 |
| replaceafill | it's under the Attendance Reports | 18:15 |
| replaceafill | xls | 18:15 |
| replaceafill | it's the last sheet | 18:15 |
| replaceafill | after Teacher attendance | 18:15 |
| th1a | Well, is it a 12 week term? | 18:17 |
| replaceafill | i mean, for my demo the term has like 52 weeks | 18:18 |
| replaceafill | it's the whole year | 18:18 |
| replaceafill | imho this division is just a sample | 18:18 |
| th1a | Well, they may just have 12 week terms. | 18:19 |
| th1a | That's something that would be consistent for a given system. | 18:19 |
| replaceafill | should i just "copy" the layout | 18:20 |
| replaceafill | i was looking for a more generic approach | 18:20 |
| th1a | I guess. | 18:20 |
| replaceafill | :) | 18:20 |
| replaceafill | ok | 18:20 |
| replaceafill | i don't like it, but that's fine | 18:20 |
| replaceafill | ;) | 18:20 |
| th1a | I mean, if they come back with, "You know, these layouts are hard to read" we can alway say "Yeah... that's why you probably want PDF's." | 18:20 |
| replaceafill | :D | 18:20 |
| replaceafill | ok, that's all i have | 18:21 |
| replaceafill | current todo: http://pastebin.com/BFFEtsHY | 18:21 |
| replaceafill | oh, i also enabled the Add person links | 18:22 |
| th1a | OK. | 18:22 |
| th1a | Cool. | 18:22 |
| replaceafill | and filtered the default groups out of the list | 18:22 |
| replaceafill | under Student Attendance | 18:22 |
| th1a | Lets get this at least on the demo site by the end of the day if possible. | 18:22 |
| th1a | Also, very important, add up your hours. | 18:23 |
| th1a | VERY IMPORTANT. | 18:23 |
| replaceafill | ah ok | 18:23 |
| th1a | Sunesh wants to move the meeting up an hour. | 18:24 |
| replaceafill | earlier? | 18:24 |
| th1a | Yes... | 18:24 |
| th1a | Let me check this... | 18:24 |
| replaceafill | fine by me | 18:24 |
| th1a | I'm going to see if we can reschedule. | 18:25 |
| replaceafill | cool | 18:25 |
| th1a | When is our meeting with jelkner tomorrow? | 18:27 |
| replaceafill | i can't find your email :P | 18:29 |
| replaceafill | "11:30 next Tuesday" | 18:31 |
| th1a | OK. | 18:31 |
| th1a | Thanks replaceafill. | 18:33 |
| replaceafill | ok, thanks th1a | 18:33 |
| *** yvl has quit IRC | 18:57 | |
| *** menesis has quit IRC | 22:08 | |
| *** menesis has joined #schooltool | 22:46 | |
| *** mobert has joined #schooltool | 22:55 | |
| th1a | Oh mobert, no lunch meeting tomorrow. | 23:06 |
| mobert | OK. IRC, text and if necessary, phone calls should suffice. | 23:39 |
| mobert | I mean, OK th1a. (Forgot to include your name so you get an alert!) | 23:40 |
| th1a | OK. Cool. | 23:40 |
| th1a | My parents are in town. | 23:40 |
| mobert | Well then, I'll try not to bug you unless I have urgent questions. | 23:43 |
| mobert | th1a, did you see what I wrote so far about Reports? | 23:43 |
| mobert | I'll flesh that out a bit tomorrow, but I think I'm headed in the right direction. | 23:44 |
Generated by irclog2html.py 2.15.1 by Marius Gedminas - find it at mg.pov.lt!