C Learning from Cathy Admin Terminal
Admin

Data Management

Return

Book

Unit & Lesson

Current Structure

Vocabulary Management

Choose an existing Book / Unit / Lesson. Single save submits lesson_id. Batch import still supports TSV copied from Excel / Google Sheets.

Open Vocabulary Learning

Vocabulary TSV Template

lesson_id	Book Name	Book No.	Unit No.	Lesson No.	Vocabulary	Part of Speech	UK IPA	中文释义	syllable	phonics rule	imageability	image url	audio url	Sample sentences	grammars	word chunks	role
1	Power Up Starter	PU-ST	Unit 0	Lesson 1	hello	interjection	/həˈləʊ/	你好	he/llo	e /ə/; o /əʊ/	3			Hello!	greeting	hello	new
1	Power Up Starter	PU-ST	Unit 0	Lesson 1	bird	noun	/bɜːd/	鸟	bird	ir /ɜː/	5	https://example.com/PU-ST/bird.jpg		A bird can fly.	noun	a bird	new

Batch Upload

Sentence Management

Choose an existing Book / Unit / Lesson. Single save submits lesson_id. Sentence data can link to grammar tags and vocabulary keywords by text.

Open Sentence Learning

Sentence TSV Template

lesson_id	Book Name	Book No.	Unit No.	Lesson No.	Sentence	UK IPA	中文释义	image url	audio url	grammar tags	keyword links	role	sort_order
1	Power Up Starter	PU-ST	Unit 0	Lesson 1	Hello!	/həˈləʊ/	你好!			greeting	hello	new	1
1	Power Up Starter	PU-ST	Unit 0	Lesson 1	What's your name?	/wɒts jɔː neɪm/	你叫什么名字?			question; be verb	what's your name	new	2

Batch Upload

Grammar Tag Links

This is only a light hyperlink table. A full grammar knowledge base can be added later.

Practice Package Management

Package binds to lesson. It does not bind to word_id or sentence_id.

Open Exercise Console

Packages