MDSB22 FMS Playlist Track 1


Studies Week 1 Outline MDSB22 ? FMS Playlist, Track 1 ? Introductions ? Introduce ourselves ? Overview of the course and the syllabus Break ? Classroom Community Statement ? Engagement Form Instructions ? Engagement Reflection Instructions 2 FMS Playlist Track 1:

“Rebel Girl” by Bikini Kill Week 1 Tasks Readings:

 No required readings

 (but) Read through the entire syllabus on your own sometime this week ? Suggested reading: Sarah Sharma, “Introduction: A Feminist Medium Is the Message.”

Re-Understanding Media. Due: ? Engagement Response – week 1 (submit in class) ? Engagement Reflection 1 (start and in class, submit before Friday, Sept. 6, at 11:59pm) What is this course about? ? An introduction to the major topics, debates and issues in

contemporary Feminist Media Studies ? How do we study and understand representations of gender, race and

sexuality in various media?

 What roles can media play in challenging racial, gendered, sexual and

economic violence?

 How can media technologies normalize or transform relations of

oppression and exploitation in specific social and cultural contexts? Who am I? Contact Information Name:

Dr. Sarah Jensen

Email:

sarah.jensen@utoronto.ca Office:

HW 416 Weekly Office Hours: Thursdays, 11:30 AM – 12:30 PM

Tuesdays, 1:15 PM – 2:15 PM

Remote office hours available upon request

Introduce Yourself! What’s your name? a. On one side of the paper, write what the professor and the other students should call you

during class discussions. If you want, you can include what pronouns we should use for

you. b. On the other side of the paper, let us know how to say your name. Please write it out

syllable-by-syllable and in a way that would help people pronounce it (e.g., include

rhyming words, images, IPA)

Example:

i. s + air + uh

2 syllables. Bold indicates which syllable is stressed. “s” = hissing sound; “air” rhymes with stair and bear; “uh” is the sound you make when you don’t know

something ii. ?s??? iii. In my email signature I also have a link to a recording of me pronouncing my name Introduce Yourself! Introduce yourself to each other in pairs or small groups by responding to the

following prompts: 1. What’s your name/what should we call you? 2. Why did you enrol in Feminist Media Studies? 3. Think back at the media you’ve consumed over the past couple of weeks

(i.e., social media posts, film, television, radio, music, comics, articles,

concerts, etc.).

a. In pairs/groups, write out any that were particularly memorable (and that you feel

comfortable sharing) b. Do you think any could count as feminist media? Identify one thing and say where

and how you encountered it, and then discuss why you think it does or doesn’t count

as feminist media.

Break Course Syllabus LSO245 Week 1 Open Quercus

Go through sections Download syllabus

Go through syllabus

Take notes 10 Classroom Community Statement Classroom Community Statement: (generated collectively in class on September 5, 2024) ? As your professor, you can expect me to: Answers questions/offer guidance for the course; answer student questions in class so that other students

can hear the answers; provide clear instructions for the course generally; provide clear guidelines and

expectations for assignments; respond to emails ? Students in this course are expected to: Participate and be mentally present for class; attend class and contribute to discussion; follow university and

course policies, incl. the academic integrity policy; limit distractions, esp. when peers are talking; try to

understand course material and ask for help when you need it; be open to different perspectives and lenses;

bring necessary materials to class; be on time ? Collectively, we can expect one another to: Respect each other by listening and responding to each other in group and class discussions; expect to

have different points of view and work toward respecting other people’s contributions, even if you disagree;

expect ppl to disagree and debate ideas in a productive way; help each other understand course materials;

use appropriate names and pronouns for each other Engagement -

Responses to weekly in-class prompts URL FMS 12 QR Code The link to the form – and the form

itself – is only available during

lecture. You need to use your UofT Microsoft

account in order to access the weekly

engagement forms. Engagement Reflections Engagement Reflections (8% total) Engagement Reflection 1 (Introduction) – due week 1 (Friday, Sept. 6) – worth 3% ? Answer 9 questions (on the next slide) ? 350-500 words ? This is a personal reflection based on your own thoughts, ideas shared during today’s

class, and the course syllabus. No outside sources should be consulted or used for this

assignment.

Engagement Reflection 2 (midterm check-in) – due week 6 – worth 2% ? Answer a few questions to check in with your learning process about halfway through the

course.

 About 250 words Engagement Reflection 3 (final) – due week 12 – worth 3% ? Answer approximately 10 questions to reflect back on the entire course and your experience

in it ? About 400 words Engagement Reflection 1 Please respond to the following questions: 1. Name a. What’s your full name as it appears on the official enrollment information?

b. During class discussions, what should the professor and the other students call you?

c. (Optional) What pronouns should we use to refer to you? d. How do you pronounce your name? Please write it out syllable-by-syllable 2. Why did you enroll in Feminist Media Studies? 3. Think back at the media you’ve consumed over the past couple of weeks (i.e., social media posts, film, television, radio, music, comics, articles, concerts, etc.).

a. In pairs/groups, write out any that were particularly memorable (and that you feel comfortable sharing) b. Do you think any of these could count as feminist media? Identify one thing and say where and how you encountered it, and then discuss why you think it

does or doesn’t count as feminist media.

4. What digital media platforms do you use fairly often (Instagram, Discord, WeChat, YouTube, TikTok, Snapchat, Whatsapp, etc.)? Why do you use these platforms?

Do you post much, or do you mostly look at other posts? What do you like to follow? 5. What experience do you have with the topics of this course? 6. What do you want to get out of taking this course? 7. What would an ideal class meeting look like for you?

8. What would be your ideal way to participate in class? What would you like from other students and/or the professor to feel comfortable participating in group

discussions? 9. Finally, is there a particular feminist media studies issue you’re interested in? Is there a weekly topic or a reading from the syllabus that you’re looking forward to more

than the others? Or is there a weekly topic or reading that you’re dreading more than the others?

Next Week ? There are 3 assigned readings for next week

 Make sure you read Collins and Bilge (2020) at least once before lecture. We’ll

definitely look at Niro’s photographs in class. If we have time, we’ll listen to some of the

podcast together during class.

 Ask 3 people (people you know outside of this class) what they think “feminism”

means. We’ll discuss what responses you receive in class next week.

WITH base_data AS ( SELECT mdsb.belong_year, mdsb.plan_month, mdsb.product_group_name, mdsb.product_manag_team_name, mdsb.product_manag_team_name_cn, mdsb.product_line_name, mdsb.product_line_cn_name, mdsb.product_type_i_name, MAX(mdsb.tag_id) AS tag_id, mdsb.tag_name, MAX(mdsb.unit_name) AS unit_name FROM edw_mktsales_cont_sop_model_delivery_support_base AS mdsb GROUP BY mdsb.belong_year, mdsb.plan_month, mdsb.product_group_name, mdsb.product_manag_team_name, mdsb.product_manag_team_name_cn, mdsb.product_line_name, mdsb.product_line_cn_name, mdsb.product_type_i_name, mdsb.tag_name ), base_qty_data AS ( SELECT mdsb.belong_year, mdsb.plan_month, mdsb.product_group_name, mdsb.product_manag_team_name, mdsb.product_manag_team_name_cn, mdsb.product_line_name, mdsb.product_line_cn_name, mdsb.product_type_i_name, mdsb.tag_name, mdsb.data_type, ROUND(SUM(mdsb.planning_qty), 0) AS planning_qty_sum FROM edw_mktsales_cont_sop_model_delivery_support_base AS mdsb GROUP BY mdsb.belong_year, mdsb.plan_month, mdsb.product_group_name, mdsb.product_manag_team_name, mdsb.product_manag_team_name_cn, mdsb.product_line_name, mdsb.product_line_cn_name, mdsb.product_type_i_name, mdsb.tag_name, mdsb.data_type ), overall_unit_head AS ( SELECT bouh.product_tag_id, MAX(bouh.device_code) AS device_code FROM ods_scp_ba_overall_unit_head bouh WHERE bouh.enabled = 1 GROUP BY bouh.product_tag_id ), dcs AS ( SELECT ucs.tag_name, ucs.planned_month, ucs.product_class, MAX(ucs.system_default_qty) AS system_default_qty, MAX(ucs.manual_default_qty) AS manual_default_qty FROM dm_get_unit_cost_seq ucs GROUP BY ucs.tag_name, ucs.planned_month, ucs.product_class ), dpad AS ( SELECT bd.belong_year, bd.plan_month, bd.product_group_name, bd.product_manag_team_name, bd.product_manag_team_name_cn, bd.product_line_name, bd.product_line_cn_name, bd.product_type_i_name, opm.product_model_class, opm.product_model_name AS device_type, bd.tag_name, bd.tag_id, bd.unit_name, dcs1.system_default_qty, dcs2.manual_default_qty, dcs3.manual_default_qty AS month_default_qty, '规划' AS data_type_1, bqd1.planning_qty_sum AS data_type_qty_1, CASE WHEN dcs3.manual_default_qty IS NOT NULL THEN bqd1.planning_qty_sum * dcs3.manual_default_qty WHEN dcs2.manual_default_qty IS NOT NULL THEN bqd1.planning_qty_sum * dcs2.manual_default_qty WHEN dcs1.system_default_qty IS NOT NULL THEN bqd1.planning_qty_sum * dcs1.system_default_qty ELSE NULL END AS qty_cost_1, '发货' AS data_type_2, bqd2.planning_qty_sum AS data_type_qty_2, CASE WHEN dcs3.manual_default_qty IS NOT NULL THEN bqd2.planning_qty_sum * dcs3.manual_default_qty WHEN dcs2.manual_default_qty IS NOT NULL THEN bqd2.planning_qty_sum * dcs2.manual_default_qty WHEN dcs1.system_default_qty IS NOT NULL THEN bqd2.planning_qty_sum * dcs1.system_default_qty ELSE NULL END AS qty_cost_2 FROM base_data AS bd LEFT OUTER JOIN base_qty_data AS bqd1 ON bqd1.tag_name = bd.tag_name AND bqd1.product_type_i_name = bd.product_type_i_name AND bqd1.plan_month = bd.plan_month AND bqd1.data_type = 1 LEFT OUTER JOIN base_qty_data AS bqd2 ON bqd2.tag_name = bd.tag_name AND bqd2.product_type_i_name = bd.product_type_i_name AND bqd2.plan_month = bd.plan_month AND bqd2.data_type = 3 LEFT OUTER JOIN overall_unit_head AS ouh ON ouh.product_tag_id = bd.tag_id LEFT OUTER JOIN ods_scp_aps_product_model AS opm ON opm.product_model_no = ouh.device_code LEFT OUTER JOIN dcs AS dcs1 ON dcs1.tag_name = bd.tag_name AND dcs1.planned_month = '1900-01' AND regexp_extract (dcs1.product_class, '\\((.*?)\\)', 1) = bd.product_type_i_name LEFT OUTER JOIN dcs AS dcs2 ON dcs2.tag_name = bd.tag_name AND dcs2.planned_month = '1900-02' AND regexp_extract (dcs2.product_class, '\\((.*?)\\)', 1) = bd.product_type_i_name LEFT OUTER JOIN dcs AS dcs3 ON dcs3.tag_name = bd.tag_name AND dcs3.planned_month = date_format (to_date (bd.plan_month, 'yyyyMM'), 'yyyy-MM') AND regexp_extract (dcs3.product_class, '\\((.*?)\\)', 1) = bd.product_type_i_name ), ecs AS ( SELECT efe.issue_date, efe.prod_class_name, SUM(efe.price) AS sum_cost FROM ( SELECT eiif.entity_name, DATE_FORMAT ( to_date (eiif.issue_date, 'yyyy-MM-dd'), 'yyyyMM' ) AS issue_date, eiif.master_code AS prod_class_name, eiif.price FROM edw_sup_inv_app_inventory_inout_fingoodsout_2 AS eiif ) AS efe GROUP BY efe.issue_date, efe.prod_class_name ), this_month_data AS ( SELECT dpad1.belong_year, to_timestamp (concat (dpad1.plan_month, '01'), 'yyyyMMdd') AS plan_month_first_day, dpad1.product_group_name, dpad1.product_manag_team_name, dpad1.product_manag_team_name_cn, dpad1.product_line_name, dpad1.product_line_cn_name, pcn.prod_class_check_name, dpad1.product_type_i_name, m5l.l1_name, m5l.l1_unit, m5l.l2_name, m5l.l2_unit, dpad1.product_model_class AS l3_name, m5l.l3_unit, dpad1.device_type AS l4_name, m5l.l4_unit, dpad1.tag_name AS l5_name, m5l.l5_unit, dpad1.system_default_qty, dpad1.manual_default_qty, dpad1.month_default_qty, dpad1.data_type_1, dpad1.data_type_qty_1, dpad1.qty_cost_1 / dpad1.data_type_qty_1 AS qty_unit_cost_1, dpad1.qty_cost_1 AS qty_total_cost_1, SUM(dpad1.data_type_qty_1 * dpad1.qty_cost_1) OVER ( PARTITION BY dpad1.plan_month, dpad1.product_type_i_name ) AS sum_cost_1, dpad1.data_type_2, mtep.sum_num AS data_type_qty_2, mtep.estimate_unit_price AS qty_unit_cost_2, mtep.estimate_sum_price AS qty_total_cost_2, ecs1.sum_cost AS sum_cost_2, atep.estimate_unit_price AS qty_unit_cost_3, dpad1.data_type_qty_1 * atep.estimate_unit_price AS qty_total_cost_3, SUM(dpad1.data_type_qty_1 * atep.estimate_unit_price) OVER ( PARTITION BY dpad1.plan_month, dpad1.product_type_i_name ) AS sum_cost_3, CASE WHEN to_timestamp (concat (dpad1.plan_month, '01'), 'yyyyMMdd') < date_trunc ('month', date_sub (current_date(), 1)) THEN '发货' ELSE '规划' END AS showed_type, CASE WHEN to_timestamp (concat (dpad1.plan_month, '01'), 'yyyyMMdd') < date_trunc ('month', date_sub (current_date(), 1)) THEN mtep.sum_num ELSE dpad1.data_type_qty_1 END AS showed_qty, CASE WHEN to_timestamp (concat (dpad1.plan_month, '01'), 'yyyyMMdd') < date_trunc ('month', date_sub (current_date(), 1)) THEN mtep.estimate_unit_price WHEN dpad1.month_default_qty IS NOT NULL THEN dpad1.month_default_qty WHEN dpad1.manual_default_qty IS NOT NULL THEN dpad1.manual_default_qty ELSE atep.estimate_unit_price END AS showed_unit_cost, CASE WHEN to_timestamp (concat (dpad1.plan_month, '01'), 'yyyyMMdd') < date_trunc ('month', date_sub (current_date(), 1)) THEN mtep.estimate_sum_price WHEN dpad1.month_default_qty IS NOT NULL THEN dpad1.qty_cost_1 WHEN dpad1.manual_default_qty IS NOT NULL THEN dpad1.qty_cost_1 ELSE dpad1.data_type_qty_1 * atep.estimate_unit_price END AS showed_total_cost FROM dpad AS dpad1 LEFT OUTER JOIN ecs AS ecs1 ON ecs1.issue_date = dpad1.plan_month AND ecs1.prod_class_name = dpad1.product_type_i_name LEFT OUTER JOIN dm_sop_month_tag_estimate_price AS mtep ON mtep.product_class_name = dpad1.product_type_i_name AND mtep.dates = CONCAT ( SUBSTRING(dpad1.plan_month, 1, 4), '-', SUBSTRING(dpad1.plan_month, 5, 2) ) AND mtep.tag_name = dpad1.tag_name LEFT OUTER JOIN dm_sop_average_tag_estimate_price AS atep ON atep.product_class_name = dpad1.product_type_i_name AND atep.tag_name = dpad1.tag_name LEFT OUTER JOIN ods_srm_op_prodclass_dp AS pcn ON pcn.prod_class_name = dpad1.product_type_i_name LEFT OUTER JOIN dm_product_model_5level AS m5l ON m5l.prod_class_check_name = pcn.prod_class_check_name AND m5l.l3_name = dpad1.product_model_class WHERE dpad1.data_type_qty_1 IS NOT NULL AND dpad1.data_type_qty_1 <> 0 OR dpad1.data_type_qty_2 IS NOT NULL AND dpad1.data_type_qty_2 <> 0 ) INSERT OVERWRITE TABLE dm_sop_tag_moth_plan_and_del_daily SELECT now () AS edw_create_date, now () AS edw_last_update, '' AS edw_data_source, 'Y' AS valid_flag, tmd.belong_year, tmd.plan_month_first_day, tmd.product_group_name, tmd.product_manag_team_name, tmd.product_manag_team_name_cn, tmd.product_line_name, tmd.product_line_cn_name, tmd.prod_class_check_name, tmd.product_type_i_name, tmd.l1_name, tmd.l1_unit, tmd.l2_name, tmd.l2_unit, tmd.l3_name, tmd.l3_unit, tmd.l4_name, tmd.l4_unit, tmd.l5_name, tmd.l5_unit, tmd.system_default_qty, tmd.manual_default_qty, tmd.month_default_qty, tmd.data_type_1, tmd.data_type_qty_1, tmd.qty_unit_cost_1, tmd.qty_total_cost_1, tmd.sum_cost_1, tmd.data_type_2, tmd.data_type_qty_2, tmd.qty_unit_cost_2, tmd.qty_total_cost_2, tmd.sum_cost_2, tmd.qty_unit_cost_3, tmd.qty_total_cost_3, tmd.sum_cost_3, tmd.showed_type, tmd.showed_qty, tmd.showed_unit_cost, tmd.showed_total_cost FROM this_month_data AS tmd
09-17
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值